To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: Re: Row level
security and latch waits
.c
i wasny referring to application contexts. I was referring to just using a policy
based on dbms_rls.
thats different isnt it?
>
> From: [EMAIL PROTECTED]
> Date: 2003/08/19 Tue PM 03:14:28 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: R
[EMAIL PROTECTED]Sub
its just appending a where clause. its not binding it.
im not familiar with contexts. never worked with them. someone correct me if im wrong
here? Could have sworn i read that somewhere.
i looked up application contexts. they appear to be handled differently.
am i wrong?
>
> From: [EMAIL PROT
im fairly certain its because DBMS_RLS doesnt use bind variables now. latch waits
indicates plus your 100 concurrent users.
you can check this by going to v$sqlarea and checking for similiar sql_text
statements. if they are there, then your not using bind variables. there is a query in
tom kyte
its the way the taem is organized. all communication goes through the product managers
to the client. No direct access for the technical people.
i dont make the rules. I just have to live with them. Ive been onsite with clients
before. its easier.
So Im looking for things to make my life easier
Political problems are best solved by hiring action move stars with
abominable
accents and a lot of muscle. In other words, the company should hire a
terminator
to deal with the bad guys. Hasta la vista, baby!
--
Mladen Gogala
Oracle DBA
-Original Message-
Millsap
Sent: Tuesday, August
Title: RE: Re: tuning question when you have a 3GL application
Cary,
is there any event top resolve political problems? or
"alter system set event 'immediate dump person_causing_problem, level cause_pain';" is the
Then you have a political problem, not a technical one.
This is plenty common. In my opinion, you'll aggravate yourself to death
before you'll successfully solve a political problem with a technical
solution.
I have total faith in the technical solution that Dan suggested, but you
won't be able t
all i usually get is 'the application is slow'
i cant get more out of them than that. its in acceptance testing so i often get that
from the customer. they are offsite and i dont have direct contact with them.
so i cant run traces on individual sessions. Further when the database runs slow the
Message-
[EMAIL PROTECTED]
Sent: Monday, August 18, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
i did use the dbca to create this instance?
>
> From: "Richard Foote" <[EMAIL PROTECTED]>
> Date: 2003/08/18 Mon AM 10:39:23 EDT
> To: Multiple recipients of
i did use the dbca to create this instance?
>
> From: "Richard Foote" <[EMAIL PROTECTED]>
> Date: 2003/08/18 Mon AM 10:39:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Re: system tablespace at 50 pct_increase in 9i?
&
Hi Mladen,
Just to avoid any confusion, you have the *option* to create a LM System
tablespace, the *default* is still DM. The ODCA uses the extent management
local clause in it's default scripts but to create a database manually, you
need to remember the clause.
Whether it should use ASSM is som
Actually, from 9iR2, system tablespace is created as locally managed
autoallocate. They should have put in "SEGMENT MANAGEMENT AUTO" clause as
well, but hey, you can't always get what you want, but you can try sometimes.
On 2003.08.18 07:59, [EMAIL PROTECTED] wrote:
i thought you should leave th
i thought you should leave the system table space to the defaults? Ive never touched
System.
you really should change system to locally managed tablespaces?
>
> From: Tim Gorman <[EMAIL PROTECTED]>
> Date: 2003/08/17 Sun PM 11:19:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
thanks. Im running the following test code from two different sessions. Odd thing is
when I run the signal routine once nothing happens. However, when i run it the second
time, my waiting routine executes on it?
I run this first:
declare
vname varchar2(10) := 'myalert';
vmessage varchar2(
Ryan
I have found the actual OCP questions to be clearer. I think it is very
hard to develop a good multiple choice exam. And these are tricky because
the objective is to test more than simple memorization. You need to
administer it to many people and find out which questions aren't clear or
are
i have all of it or 8i. this question was in architecture. I havent looked at the sql
and pl/sql stuff since the cert test for that was a blowoff.
>
> From: "Ed Sherman" <[EMAIL PROTECTED]>
> Date: 2003/08/15 Fri AM 09:00:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Su
yeah thats what i figured... but having these certifications are good for my career.
thanks. I figured it was a stupid question.
>
> From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/08/15 Fri AM 01:14:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP
>Thanks a lot Stephane.
>
>There are indexes on profile table which u pointed
>out.
>but none of the tables/indexes are analyzed yet.
First thing to do.
>Connor pointed that there are 54million consistent
>gets.
>LIO is high.
>
>does it mean that db_cache_size (700M) is small ?
>how to deal wit
i think its DBA_MVIEWS though I could be wrong. see what is in there. if your view is
there then you are using materialized views.
>
> From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <[EMAIL PROTECTED]>
> Date: 2003/08/12 Tue AM 11:24:42 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED
Im dont know much about other databases so I dont know how they implement materialized
views. All you have to do to make a materialized view 'current is to refresh it. I
dont remember the exact syntax. Its on OTN. This could take a while and should be done
during off-hours.
The reasoning behind
Just an addition, CRM isn't probably an issue, but most of countries have
laws which forbid taking and handling financial and billing information
abroad..
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 14, 2003 7:04 PM
I'd also like to point out that this is least likely
to happen if you are a DBA in a federal or state
government position (outsourcing to India etc not
likely to happen).
mohammed
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> >Ken - Since you've recently changed jobs, your
> >upbeat attitude
Ryan
Then you're ahead of me. That's why I said "I think", thereby implying a
degree of uncertainty. I have worked with ODBC for many years and this
wasn't mentioned. I first heard of it when JDBC arose. I did a quick search
on Google for "odbc autocommit" and received 9000 hits. It looks like a
thanks... didnt realize you could do this with a GUI.
the command line answer was helpful too. Thanks Dennis.
>
> From: Chip <[EMAIL PROTECTED]>
> Date: 2003/08/12 Tue AM 12:34:29 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: how to turn off ODBC auto-commit?
>Profile(sex,entpc,laccess) and profile(sex,entpc,faccess)
>Would appear to be called for. Obviousdly you will wish to analyze the
>schema, and even more obviously you will do all this in test first.
>If sex is a column that does not have many values (one would think no
>more than 8 or so) then y
correct but the job stays in dba_jobs_running.
im assuming it completes or fails correct, but wont go back in the jobs$ table?
>
> From: Hemant K Chitale <[EMAIL PROTECTED]>
> Date: 2003/08/14 Thu AM 11:29:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: what
>Dennis:
>
>With respect to sending production DBA positions to
>India, et al. I don't
>think companies are very included to do this
>because of security concerns
>and the confidentiality of the information stored
>in the DB. It's not a
>good idea to open your DB's to the entire world.
>
>Ken
>
>Jared,
>
>LIO being high and BHCR ~ 99% : is this is a normal
>or abnormal ?
>
>Regards,
>Jp.
>
>12-08-2003 00:44:23, Jared Still
><[EMAIL PROTECTED]> wrote:
>>But his BCHR is 99.57% !
>
>
OK, let's have another try at it. Let's say that you are a travelling salesman, with a
number of prospect
t;Jesse, Rich" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/07/2003 02:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR
Yes, V$OPEN_CURSOR
Ah but then everything is fine ... Could we suggest buying a bigger machine :-) ?
>- --- Original Message --- -
>From: Jared Still <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 11 Aug 2003 07:44:23
>
>
>But his BCHR is 99.57% !
>
>On
thanks... I have jonathan lewis's book on my list to read.
The transaction table is what is modified with the initrans and maxtrans setting. I
get it now.
when you perform block clean out you modify the block and state that it is no longer
being used in this transaction. when the blocks are fl
it says it is in tom kytes book. he says its there because ODBC is written by
microsoft and sql server needs to commit often because reads blocks writes and you run
into concurrency issues.
>
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/08/11 Mon AM 10:44:29 EDT
> To: Multiple recip
>Ken - Since you've recently changed jobs, your
>upbeat attitude is
>encouraging. I think you've made a good point that
>jobs aren't always
>advertised. Another point is that when there are
>more jobs than available
>candidates, companies have to advertise strongly to
>fill their positions.
>When t
>When I worked for Oracle's custom development group
>I worked on a large
>conversion project that employed about 350
>consultants (150 from Oracle).
>They had a number of foreign consultants on the
>project. About 1 in 10 had
>technical skills that were above mediocre, but they
>worked cheap. Th
Thanks a lot Millsap,Stephane Faroult,Jared Still,Wolfgang,Tanel and Dennis for
your pointers and suggestions.
I owe a lot to you Oracle Gurus.
A novice DBA like me is ever grateful to this wonderful list.
I love this list.
Thanks once again.
Jp.
--
Please see the official ORACLE-L FAQ: htt
v$open_cursors is all open cursors in the instance
v$sesstat is just open cursors in the session.
what 3rd party product is that? is it cross platform? Ill make sure not to buy it.
really bad code to get too many open cursors.
>
> From: "Jesse, Rich" <[EMAIL PROTECTED]>
> Date: 2003/08/07 Thu
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: RE: why does block
cleanout incur redo?
gt; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 07, 2003 3:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR
>
>
> v$open_cursors is all open cursors in the instance
>
> v$sesstat is just
SP: Stored Procedure[EMAIL PROTECTED] wrote:
what is an 'SP'?> > From: "Tanel Poder" <[EMAIL PROTECTED]>> Date: 2003/08/04 Mon AM 08:54:31 EDT> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>> Subject: Re: How to Lock and unlock a table until SP completes> > Hi!> > You could also play
vsize seems to only give the number of characters. i think the guy was asking for how
many bytes in each row. do you know how to calculate that? I know there are papers out
there that tell you how many bytes different datatypes take up, but how do you find
out about how many bytes are in a row h
SP = Stored Procedure
Dave
-Original Message-
Sent: Monday, August 04, 2003 8:34 AM
To: Multiple recipients of list ORACLE-L
what is an 'SP'?
>
> From: "Tanel Poder" <[EMAIL PROTECTED]>
> Date: 2003/08/04 Mon AM 08:54:31 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]
what is an 'SP'?
>
> From: "Tanel Poder" <[EMAIL PROTECTED]>
> Date: 2003/08/04 Mon AM 08:54:31 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: How to Lock and unlock a table until SP completes
>
> Hi!
>
> You could also play with set transaction read only, set
yeah that might be the right answer, but you would get it wrong on the OCP... assuming
the books are right.
>
> From: Peter Gram <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 04:09:28 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 9i-OCP Question
>
> Hi
>
> I
dont know from experience, since I dont handle backups and redo, but according to the
books, you are multiplexing your redo log groups. so if one of the files gets
corrupted, etc... you have exact duplicates on different storage devices.
So if you put all the members on the same storage device
i didnt ask the question. I was responding. what is up with the attitude?
>
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 02:04:57 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 9i-OCP Question
>
> So, what do you need us for?
>
>
>
> O
Euro character? Isn't that '$'?
On 2003.07.30 11:04, [EMAIL PROTECTED] wrote:
Even better is ISO-8859-15, which contains the EURO-character.
oli
Original Message
To: [EMAIL PROTECTED]
> I'm not German, but to my knowledge, all west European languages
> use ISO-8859-1.
> On
>
> From: "Smith, Ron L." <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon PM 02:49:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: Oracle Snapshot Too Old during programatic load
>
> Yep, all at once. All inserts I be
Yep, all at once. All inserts I believe.
-Original Message-
Sent: Monday, July 28, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
well does the load process happen serially or are you breaking it into
pieces and doing it at once?
by load I take it to mean
insert
update
delet
does an archiver problem show up when you run statspack?
>
> From: "Tanel Poder" <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon AM 10:49:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 8.1.7 instance on Solaris periodically goes sluggish, then hangs...
>
> Hi!
>
well does the load process happen serially or are you breaking it into pieces and
doing it at once?
by load I take it to mean
insert
update
delete
create index.
correct?
>
> From: "Smith, Ron L." <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon PM 01:24:23 EDT
> To: Multiple recipients of list O
what bugs are those?
>
> From: Jack van Zanen <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon AM 11:09:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 8.1.7 instance on Solaris periodically goes sluggish, then ha
>
> Plus if you are on 8.1.7.3 you have several bug
ltiple recipients of list ORACLE-L
> Subject: RE: RE: Oracle 9i refuses to allow client connection
> -- I need
>
>
> Stephen.
> OTN is the abbreviation for Oracle Technology Network
> http://otn.oracle.com/. It is a source and startup point for
> documentation,
tephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 9:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: Orac
y 28, 2003 9:24 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: RE: Oracle 9i refuses to allow client connection
> > -- I need
> >
> >
> > the otn document for administering oracle on windows is
> > pretty solid. the book includes m
L PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 9:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: Oracle 9i refuses to allow client connection
> -- I need
>
>
> the otn document for administering oracle on windows is
> pretty so
There is a 'book' on ORacle for
Windows'.
>
> From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon AM 10:09:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: Oracle 9i refus
age-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 9:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: Oracle 9i refuses to allow client connection
> -- I need
>
>
> the otn document for administering oracle on windows i
Actually it's not ultimately bad. I'd say it's rather good instead.
When you initiate a process and allocate memory to it, it's actually just
mapped to virtual memory in modern operating systems, meaning that a process
which hasn't actually touched the memory it has allocated (thus unused
memory),
if you dont have enough memory, it will be taken from virtual memory which is very
bad.
if there is enough memory, Oracle will reserve its space from that first.
>
> From: "Naveen Nahata" <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon AM 07:59:24 EDT
> To: Multiple recipients of list ORACLE-L <[EM
the otn document for administering oracle on windows is pretty solid. the book
includes most of that stuff plus some fo the gui tools.
>
> From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon AM 08:11:32 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTE
el <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
26-07-2003 12:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Re[2]: Union quries: INTERSECT, MINUS, etc
okay, I answered this offlist
okay, I answered this offlist but...
it started out as "do we have a problem, indicated by records in the
parent table with no children"
select id from parent
minus
select parentid from child
that identified that we had a problem.
next step (I'm a paranoid DBA when it comes to permanently delet
where will you publish this? Id like to read your results.
>
> From: Jonathan Gennick <[EMAIL PROTECTED]>
> Date: 2003/07/25 Fri AM 10:04:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re[2]: Union quries: INTERSECT, MINUS, etc
>
> Friday, July 25, 2003, 6:39:3
I'd purge myself first 'cause I don't have kids.
Like the bad joke "After I kill myself I'm turning the gun on you"
--- Jonathan Gennick <[EMAIL PROTECTED]> wrote:
> Friday, July 25, 2003, 6:39:35 AM, Rachel wrote:
> RC> not very slick but I used MINUS yesterday to find parents with no
> RC> ch
- Original Message -
> what do you mean by 'arc'?
> >
have a look:
http://www.docm.mmu.ac.uk/online/SAD/T07/erd2.htm
much better explanation than I can give here.
Cheers
Nuno Souto
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Sout
what do you mean by 'arc'?
>
> From: "Nuno Souto" <[EMAIL PROTECTED]>
> Date: 2003/07/24 Thu AM 09:39:29 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Union quries: INTERSECT, MINUS, etc
>
> - Original Message -
>
>
> > I'm doing research for an art
I'm young but my memory is already going away :(
-Original Message-
Gogala, Mladen
Sent: Wednesday, July 23, 2003 5:20 PM
To: Multiple recipients of list ORACLE-L
Yup! SQL Protected Mode Executable, which loaded oracle above 1M
boundary on 286 boxes. I believe that the last ones were p
Yup! SQL Protected Mode Executable, which loaded oracle above 1M
boundary on 286 boxes. I believe that the last ones were produced
for oracle 6.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 23, 2003 4:40 PM
To: Multiple r
exactly...
now, i have to say, there is the option to round up/down when necessary
depending on how many gray hairs are showing through the hair color
application and available room lighting...
-Original Message-
Sent: Wednesday, 23 July, 2003 12:15
To: Multiple recipients of list ORAC
Hi Igor,
yes, it is. But it would be better if we all
swallow the use of the builtin functions.
My weaknesses are with analytic functions.
I would give my colleague's right arm for
getting into them ;-))
Greetings,
Guido
>>> [EMAIL PROTECTED] 23.07.2003 15.54 Uhr >>>
> eat this:
Is it chewab
Thanks a Lot
===
On Mon, 21 Jul 2003 Thomas Day wrote :
>
>Assuming that you have 3 physical devices (NON-RAID, RAID-1, and
>RAID-0+1)
>my quick-and-dirty take on this is:
>
>NON-RAID
> redo logs - mirrored by Oracle
> control logs - mirrored by Oracle
> ORACLE_
think the other suggests on user_errors etc. are on the right track.
Ciao
Fuzzy
:-)
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
> Sent: Monday, July 21, 2003 17:44
> To: Multiple recipients of list ORACLE-L
> Subject
you sure? Ive noticed this before. SHOW ERRORS is a function. Do you know where its
created? you can find the code and then just craete the show errors function? might be
in sql.bsq
>
> From: "Grant Allen" <[EMAIL PROTECTED]>
> Date: 2003/07/21 Mon PM 12:24:24 EDT
> To: Multiple recipients of li
FORTE compiler
On Mon, 21 Jul 2003 Richard Ji wrote :
>So which compiler will you standarize on? GCC?
>On Solaris I believe the Sun C Compiler is supported but not gcc,
>though
>you can make it work.
>
>-Original Message-
>Sent: Sunday, July 20, 2003 12:50 PM
>To:
thanks a lot
On Sun, 20 Jul 2003 Tanel Poder wrote :
>Hi!
>
>When moving to binary compatible platform, you can directly copy
>over the
>files (and software).
>
>It's even possible with different versions of OS - like from
>SunOS 2.6 to
>Solaris 8.
>
>For upgrading to 8.1.7.
Yes
We will bedoing it thru exp/imp as downtime is there
thanks
On Mon, 21 Jul 2003 zhu chao wrote :
>Hi,
> I suggest you upgrade your old server from 8170 to 8174 and
>then copy
>the datafiles there.
> Or if downtime is limited, you can use standby database to
>switch
It looks like you have to join, but the article can be found here:
Method 4 Dynamic SQL with Native Dynamic SQL (online subscribers only)
http://www.oracleprofessionalnewsletter.com/OP/OPmag.nsf/Index/594D98A6AF90025185256D32006A41CE
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[
MAIL PROTECTED]>
cc:
Subject:Re: RE: help with dynamic pl/sql
i should have seen that one... error looks like it wasnt seeing the
variable.
If you do a google search for the online journal 'Oracle Professional'.
Steve Fuerstein has an article where he s
i should have seen that one... error looks like it wasnt seeing the variable.
If you do a google search for the online journal 'Oracle Professional'. Steve
Fuerstein has an article where he shows you how to do method 4 dynamic sql with
execute immediate instead of dbms_sql. Method 4 is when you
Wilco,
"AS" in line 3 doesn' seem to be a problem.
AS Ben said, i hope the embeded SELECT is not a feature of 8i.
i changed it accordingly and it worked fine.
Cheers,
Jp.
18-07-2003 15:29:14, Wilco Scheffers <[EMAIL PROTECTED]> wrote:
>At line 3, replace AS with IS
--
Please see the offic
Ben,
1# i tried with "IS" in line number 3 too...doesn't work.
"AS" in line number 6 is the problem.
2# may be as u said , that embeded SELECT is a 9i feature.
let me confirm it.
Thanks Ben.
Jp.
18-07-2003 15:13:18, "Wittmeier, Ben" <[EMAIL PROTEC
Nope, wasn't '97.
The OCP tests were free that year. Took em all in an afternoon.
As they were beta tests, they were rather lengthy: about 160 questions
each.
Jared
Jonathan Gennick <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/17/2003 12:59 PM
Please respond to ORACLE-L
i just hope they dont add a requirement to take one of their $2000 classes just to
upgrade your certification.
though it sure looks like they are heading that way... talk about a scam to get money.
The classes are not rigorous, many instructors have little to no experience, and they
go right o
are there any practical uses for dbms_repair? or is it just a stop gap measure to use
if your not able to do a recovery at that time?
>
> From: Stefick Ronald S Contr ESC/HRIDD <[EMAIL PROTECTED]>
> Date: 2003/07/17 Thu AM 10:39:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED
i read this last year. correct me if im wrong, but it didnt seem to have much more
than was on otn? just explained slightly differently with a slightly more depth.
>
> From: Kirtikumar Deshpande <[EMAIL PROTECTED]>
> Date: 2003/07/17 Thu AM 09:54:29 EDT
> To: Multiple recipients of list ORACLE-L
- Original Message -
> how does the object features improve performance of the jdbc? its fairly
common now to have a java or .net(which we are using) and an Oracle backend.
>
When we started to use JDBC, one of the things I noticed
was some very unusual network traffic. Certainly more t
i kind of get the point... its just overkill now.
>
> From: "Boivin, Patrice J" <[EMAIL PROTECTED]>
> Date: 2003/07/16 Wed AM 11:39:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
>
> Intersting... I get spa
noones hiring H1-Bs. there are so many DBAs out there who were H1-Bs in the past and
are now permanent residents or US citizens that they dont need to anymore.
there are typical multiple qualified applicants for every job these days. Many of
which are over-qualified.
>
> From: "Meng, Dennis"
Title: RE: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
ie is probably Ireland ... IN is for India.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
what country is 'ie'? is that india?
its the same thing if Americans started flooding to your country on the Indian
equivalent of an H1-B. If its easier and less expensive to hire Indians, why hire the
Americans?
US immigration laws are FAR less stringent than Europes btw. I tried getting a j
you can get the same performance improvements by passing a REF Cursor out to the
client also.
basically he is saying that if you are over a network particularly in a web
application where you cant always control the speed of the internet access that the
client is using and you do:
select colu
how does the object features improve performance of the jdbc? its fairly common now to
have a java or .net(which we are using) and an Oracle backend.
your comments would be much appreciated.
>
> From: "Nuno Souto" <[EMAIL PROTECTED]>
> Date: 2003/07/16 Wed AM 07:54:32 EDT
> To: Multiple recipie
i know you can get the IP in a client-server mode and i think its with sys_context.
Ill have to look it up. in web mode you have to use a client side script. I know there
is a javabean you can write to do it(its actually in the forms 9i demo). dont know how
to do it in .net(which is what we are
> why is it useful to seperate different i/o pattersn? such as
> multi-block reads and single block reads?
Because (assuming adaptive I/O subsystems like EMC's and
such) each gets optimized into different priority scales and
device queues. And of course if they are to the same device, they
*m
t mount
> > points in an instance used for batch loads? such as a data publication
> model
> > where you ingest deltas?
> >
> > any data on this?
> > >
> > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > > Date: 2003/07/15 Tue PM 12:04:24 EDT
S <[EMAIL PROTECTED]>
> > Date: 2003/07/15 Tue PM 12:04:24 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: RE: should you separate indexes from tables in separate
dataf
> >
> > R,
> >My personal theory on
Oh I'm sure I have a copy at home, somewhere. I'm a packrat.
I was an almost brand-new DBA at the time, so I was on information
overload then, trying to learn Oracle and as as much as I could, all at
once (you try becoming the Oracle DBA without ever having seen Oracle
before!)
and yes, you do tr
If you can't find it, you can download it again from
http://www.hotsos.com/catalog. I *promise* I haven't cheated and edited the
document since the date that's published on its cover.
Lots of people at the time (~1992) were preaching to separate indexes and
data on different disks. The OFA gave yo
1001 - 1100 of 2928 matches
Mail list logo
