RE: another OCP question -- help me guys

[Pete Sharman]

Well, so here's the challenge for RMOUG training days - loosening Rachel's lips.  
Who's gonna join me in this endeavour?  :)

 
Pete
 
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-Original Message-
Sent: Friday, 9 January 2004 1:09 PM
To: Multiple recipients of list ORACLE-L

my lips are sealed... 


--- Mogens_NÃrgaard <[EMAIL PROTECTED]> wrote:
> I demand to know who the other one is!
> 
> Mogens
> 
> Rachel Carmichael wrote:
> 
> >you leave me such straight lines :)
> >
> >which part is qualified as an accountant?
> >
> >you volunteer to be the sacrificial lamb? Hm, masochist?
> >
> >Before Jared tries to send everyone over to my list on this topic,
> I'll
> >try to bring it at least slightly back on topic.  I really don't
> care
> >if someone has a degree or has completed the OCP exams. I want to
> see
> >what they have done in practice, or if they are interviewing for a
> >truly junior position, I want to know how they learn, what they've
> >played with on their own. 
> >
> >Two of the smartest men I have ever known never finished college.
> >


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: oaktable people

[Bobak, Mark]

Hehehe...

I'm sorry I won't make it!  As I said, one of these days, I WILL make it
to Denmark!  I figure, between the two of us, if we can drink the beer fast 
enough, there won't be any opportunity for anyone to steal it!  ;-)
(Then you won't have to worry about sending Annette to do your dirty work,
capturing the criminal! ;-))

See you in Dallas! ;-)

-Mark


-Original Message-
From:   Mogens Nørgaard [mailto:[EMAIL PROTECTED]
Sent:   Thu 1/8/2004 6:04 PM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:Re: oaktable people
It certainly is true for Mark, too, yes.

Mark - it would have been so wonderful if you had just added one little 
K in your sentence. Right in front of the word "now". That would have 
been so very cool :).

Now go and find an excuse for visiting Denmark. On Friday Lex de Haan 
arrives. On Saturday Gaja and James Morle. On Sunday 16 other members. 
All to stay in my house (except Gaja - don't know what he's up to). 
Rock'n'roll. And none of them know what I meant when I asked them to 
bring some old clothes for some unusual teambuilding...

Mogens

Bobak, Mark wrote:

>No, I'm an American, a member of the OakTable, and I do not now, nor have
>I ever worked for Oracle.  Also, I'm pretty sure the same is true of Mark
>Powell.
>
>Also, WRT to James Morle, he's got a new white paper out, "Brewing 
>Becnchmarks".  It's available at http://www.oaktable.net/
>
>-Mark
>
>
>-Original Message-
>From:  Ryan [mailto:[EMAIL PROTECTED]
>Sent:  Mon 1/5/2004 7:19 PM
>To:Multiple recipients of list ORACLE-L
>Cc:
>Subject:   Re: oaktable people
>when did fuerstein join oaktable?
> 
>http://www.oaktable.net/pageServer.jsp?body=members.jsp
> 
>btw, are the only Americans members of Oracle or former members of Oracle? 
> 
>
>- Original Message - 
>To: Multiple recipients of list ORACLE-L   
>Sent: Monday, January 05, 2004 6:49 PM
>
>
>I've heard that Steven Feuerstein has a new book on the way, though I 
>have been unable to find any reference to it. 
>
>Jared 
>
>
>
>
>   "Ryan" <[EMAIL PROTECTED]> 
>Sent by: [EMAIL PROTECTED] 
>
>
> 01/05/2004 02:34 PM 
> Please respond to ORACLE-L 
>
>
>
>To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
>cc: 
>Subject:oaktable people
>
>
>
>Conner McDonald's book just came out and it looks to be pretty good. Any
>more books in the pipeline?
>
>  
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?windows-1252?Q?Mogens_N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

finding the partition for a newly inserted row, from inside a trigger on the table

[Jacques Kilchoer]

This is probably old hat for some of you and not very useful to most of you, but maybe 
there's that one person who is struggling with this question who will be happy to read 
the post.

You have a partitioned table and you want to find out in which partition a newly 
inserted or updated row will be placed, because for example you want to prevent 
changes in that partition for certain users or whatever.
Here's one way to do it. If there's a better way I'd be glad to hear about it.
(I realize that for list or range partitions one could compare the relevant columns to 
the partitioning values but you would have to modify the trigger every time you 
add/remove partitions.)

create table t (n number, d date)
  partition by hash (n)
   (partition tp1, partition tp2) ;
create trigger t_afi
after insert on t
for each row
declare
   rid_type number ;
   objid number ;
   rfno number ;
   bno number ;
   rno number ;
   objname sys.obj$.subname%type ;
begin
   dbms_rowid.rowid_info (rowid_in => :new.rowid,
  rowid_type => rid_type,
  object_number => objid,
  relative_fno => rfno,
  block_number => bno,
  row_number => rno) ;
   select subname
into objname
from sys.obj$
where dataobj# = objid ;
   dbms_output.put_line ('Row was placed in partition ' || objname) ;
end ;
/

Proof of concept:

SQL> set serveroutput on

SQL> insert into t (n, d) values (1, sysdate) ;
Row was placed in partition TP2
1 ligne créée.

SQL> insert into t (n, d) values (2, sysdate) ;
Row was placed in partition TP1
1 ligne créée.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: another OCP question -- help me guys

[Rachel Carmichael]

my lips are sealed... 


--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> I demand to know who the other one is!
> 
> Mogens
> 
> Rachel Carmichael wrote:
> 
> >you leave me such straight lines :)
> >
> >which part is qualified as an accountant?
> >
> >you volunteer to be the sacrificial lamb? Hm, masochist?
> >
> >Before Jared tries to send everyone over to my list on this topic,
> I'll
> >try to bring it at least slightly back on topic.  I really don't
> care
> >if someone has a degree or has completed the OCP exams. I want to
> see
> >what they have done in practice, or if they are interviewing for a
> >truly junior position, I want to know how they learn, what they've
> >played with on their own. 
> >
> >Two of the smartest men I have ever known never finished college.
> >


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Trigger Question

[Jared Still]

Dick, you cannot do that in an AFTER trigger.

Jared

On Thu, 2004-01-08 at 11:54, Goulet, Dick wrote:
> Wolfgang,
> 
>   Yes you may, within the trigger only, change values of that row only.  it's 
> known as
> 
>   :new. := ;
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> 
> -Original Message-
> Sent: Thursday, January 08, 2004 2:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I'm sure I will be corrected if I'm wrong.
> Answers inline
> 
> At 12:24 PM 1/8/2004, you wrote:
> 
> >Hi All,
> >
> >Firstly my apologies if this seems like a very *stupid* question but I'm a
> >tad confused (and it's late in the evening)
> >
> >When an AFTER INSERT trigger is fired (row level) has the row been committed
> >to the database at this stage?
> 
> No. You could raise an error as part of what the trigger does in order to 
> reject the action.
> 
> >If so is it ok to call a package in the trigger that selects that row and
> >changes some values in the row?
> 
> a) it is not so and
> b) you can not do anything with that row (or that table for that matter) in 
> either the trigger or any called package or procedure. You'll get a 
> "mutating table" error.
> 
> 
> >Thanks,
> >
> >N.
> >
> 
> Wolfgang Breitling
> Oracle7, 8, 8i, 9i OCP DBA
> Centrex Consulting Corporation
> http://www.centrexcc.com 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Wolfgang Breitling
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Goulet, Dick
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Should we stop analyzing?

[Jared Still]

This opens a whole new can of worms.

design bug
specification bug
'get it out the door, now!' bug
'had a few too many porters when I wrote that bit' bug
..

Jared

On Thu, 2004-01-08 at 11:59, Jonathan Lewis wrote:
> 
> - Original Message - 
> > 
> > Roughly, a bug would seem to be code that falls into one of 
> > two categories:
> > 
> > * code that doesn't do what the developer intended
> > * code that generates errors 
> > 
> 
> Several years ago I raised an issue with Oracle support
> where something was clearly going wrong - can't remember
> what, too long ago - and got told that I couldn't get the
> issue logged as a bug because the code was performing
> to specification.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jonathan Lewis
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Trigger Question

[Jared Still]

> When an AFTER INSERT trigger is fired (row level) has the row been committed
> to the database at this stage?

No

> If so is it ok to call a package in the trigger that selects that row and
> changes some values in the row?

No

See the following snippet from the fine SQL manual.

Jared

PS.  Your email had a virus attached to it.

AFTER

Specify AFTER to cause Oracle to fire the trigger after executing the
triggering event. For row triggers, the trigger is fired after each
affected row is changed.
Restrictions on AFTER Triggers

* You cannot specify an AFTER trigger on a view or an object view.
* You cannot write either the :OLD or the :NEW value.


On Thu, 2004-01-08 at 11:24, Nuala Cullen wrote:

> 
> Hi All,
> 
> Firstly my apologies if this seems like a very *stupid* question but I'm a
> tad confused (and it's late in the evening)
> 
> When an AFTER INSERT trigger is fired (row level) has the row been committed
> to the database at this stage?
> 
> If so is it ok to call a package in the trigger that selects that row and
> changes some values in the row?
> 
> Thanks,
> 
> N.
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: oaktable people

[Grant Allen]

> -Original Message-
> From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]
> Sent: Friday, 9 January 2004 09:50
> To: Multiple recipients of list ORACLE-L
> Subject: Re: oaktable people
> 
> 
> Heh-heh. It should be said in all fairness that we don't really spend 
> much time with our website (keeping it updated, for instance 
> - just to 
> mention one minor detail), so we certainly understand if people are 
> asking for directions there :).
> 
> One very un-serious question: Is it actually possible to do a "revoke 
> all from grant;"?
> 
> Mogens

It is quite possibly the worst name to have as a DBA - thus my usual use of my 
nickname, Fuzzy.  My personal favourite is "grant [whatever priv] to grant with grant 
option;".  One small benefit is you can be sure the apps we develop never have any 
problems with reserved words :-)

Ciao
Grant/Fuzzy
:-)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORA-01578 data block corrupted

[Tanel Poder]

Yup, there are some nice ways for restoring even parts of a datablock using
contents from corresponding indexes... or if it's an index block (just a
plain count(*) can use indexes as well if all rows are quaranteed to be
indexed), then you can "just" rebuild the index. So, nothing is lost, until
it's completely lost ;)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 09, 2004 1:24 AM


> If the restore/recovery thing from backup doesn't work (it usually
> does), it's time to panic in a controlled fashion...
>
> Dump the block to see if it's a hard or soft corruption.
>
> A hard corruption is when some kind of "stray write" has hit the block,
> causing one of many checks against eg the rows to fail.
>
> A soft corruption happens when Oracle decides it doesn't have faith in
> the block anymore, so better corrupt it by zero'ing out part of the
> footer field.
>
> There's no easy way to tell whether it's a hard or soft corruption. You
> can dump the block and study the header and footer fields to see if they
> match. If not, it's probably a soft corruption.
>
> Or get Peter Gram to look at such stuff. He's crazy.
>
> Mogens
>
> Nguyen, David M wrote:
>
> > I got ORA-01578 error while querrying info for below table.  How do I
> > fix this error?
> >
> >
> > SQL>Select count(*) from GATEWAYCALLSTATS;
> >
> >  *
> >
> > ERROR at line 2:
> >
> > ORA-01578: ORACLE* data block corrupted* (file # 3, block # 2683299)
> >
> > ORA-01110: data file 3: '/apps/oracle/oradata/SIDB/rtesvr01.dbf'
> >
> > Thanks,
> >
> > David
> >
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORA-01578 data block corrupted

[Mogens Nørgaard]

If the restore/recovery thing from backup doesn't work (it usually 
does), it's time to panic in a controlled fashion...

Dump the block to see if it's a hard or soft corruption.

A hard corruption is when some kind of "stray write" has hit the block, 
causing one of many checks against eg the rows to fail.

A soft corruption happens when Oracle decides it doesn't have faith in 
the block anymore, so better corrupt it by zero'ing out part of the 
footer field.

There's no easy way to tell whether it's a hard or soft corruption. You 
can dump the block and study the header and footer fields to see if they 
match. If not, it's probably a soft corruption.

Or get Peter Gram to look at such stuff. He's crazy.

Mogens

Nguyen, David M wrote:

I got ORA-01578 error while querrying info for below table.  How do I 
fix this error?

SQL>Select count(*) from GATEWAYCALLSTATS;

 *

ERROR at line 2:

ORA-01578: ORACLE* data block corrupted* (file # 3, block # 2683299)

ORA-01110: data file 3: '/apps/oracle/oradata/SIDB/rtesvr01.dbf'

Thanks,

David

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: oaktable people

[Mogens Nørgaard]

It certainly is true for Mark, too, yes.

Mark - it would have been so wonderful if you had just added one little 
K in your sentence. Right in front of the word "now". That would have 
been so very cool :).

Now go and find an excuse for visiting Denmark. On Friday Lex de Haan 
arrives. On Saturday Gaja and James Morle. On Sunday 16 other members. 
All to stay in my house (except Gaja - don't know what he's up to). 
Rock'n'roll. And none of them know what I meant when I asked them to 
bring some old clothes for some unusual teambuilding...

Mogens

Bobak, Mark wrote:

No, I'm an American, a member of the OakTable, and I do not now, nor have
I ever worked for Oracle.  Also, I'm pretty sure the same is true of Mark
Powell.
Also, WRT to James Morle, he's got a new white paper out, "Brewing 
Becnchmarks".  It's available at http://www.oaktable.net/

-Mark

-Original Message-
From:   Ryan [mailto:[EMAIL PROTECTED]
Sent:   Mon 1/5/2004 7:19 PM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:Re: oaktable people
when did fuerstein join oaktable?
http://www.oaktable.net/pageServer.jsp?body=members.jsp

btw, are the only Americans members of Oracle or former members of Oracle? 

- Original Message - 
To: Multiple recipients of list ORACLE-L   
Sent: Monday, January 05, 2004 6:49 PM

I've heard that Steven Feuerstein has a new book on the way, though I 
have been unable to find any reference to it. 

Jared 



	"Ryan" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 

01/05/2004 02:34 PM 
Please respond to ORACLE-L 

   
   To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
   cc: 
   Subject:oaktable people



Conner McDonald's book just came out and it looks to be pretty good. Any
more books in the pipeline?
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?windows-1252?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Any Oracle 9i Data Guard limitations specific to Linux implementations?

[Tanel Poder]

I've done sync physical DG on linux (over direct gigabit ethernet). Didn't
encounter any serious problems.
With physical standby you can forget about nologging operations -> use alter
database force logging or at least on tablespace level for important
tablespaces.
Also I set LGWR running on higher priority on primary in order to transfer
log records to standby with smallest latency.

Go with async if your business requirements allow you to lose few bits of
data in case of disaster on primary (especially when servers aren't
connected via low-latency high-throughput network).

And logical standby is only a prototype yet.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 9:34 PM
implementations?


> Does anyone here know of any Oracle 9i (9.2.0.4) Data Guard limitations
and/or needed workarounds?
>
> In the process of planning a near-terabyte size data warehouse utilizing
both Real Application Clusters (RAC) and Data Guard (primary/standby)
technologies on a Linux (Red Hat v 2.1) environment (using raw partitions).
>
> As part of my active research on the matter (manuals, release notes, OTN,
etc.), I am wondering if anybody on the list knows (from experience) of any
specific limitations (e.g., bugs, etc.) that may be encountered while using
the Data Guard (logical or physical standby databases and synchronous or
asynchronous modes) implementation on Linux? In other words, looking for any
information about possible limitations (or special workarounds needed) using
Data Guard on a Linux implementation.
>
> Regards,
>
> William
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: William R. Jones
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Book (was) oaktable people

[Mogens Nørgaard]

And since my topic at the Hotsos Symposium is "/The DBA is Dead, the 
Database is Dying... But Our Future Looks Bright"/ //there just MIGHT be 
a need for me to use a few, chosen, Danish bad words. I shall try, of 
course, to keep it in Danish. Shouldn't offend too many.

Can I suggest, Gary, that we also do a Profanity Class 101 for the 
speakers during the event? I could teach some of it.

Mogens

Gary Goodman wrote:

We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium
speaker agreement.  I will admit that profanity from Connor does not
carry the same impact as profanity from Mogens!
Gary

-Original Message-
Connor McDonald
Sent: Wednesday, January 07, 2004 5:29 AM
To: Multiple recipients of list ORACLE-L
I'm saving that for the Hotsos symposium

--- "Daniel W. Fink" <[EMAIL PROTECTED]> wrote: >
Who cares about the profanity
 

Do you a) pound nails in a squirrel and b) force
David Kurtz to consume massive amounts of gin whilst
lobbing Fosters at the
audience?
Connor McDonald wrote:

   

I have to admit I like this stuff about "Connor's
book" especially since I'm only a co-author for
 

the
   

thing :-)

(And unlike my presentations, I promise that there
 

is
   

no profanity in the book...)

Cheers
Connor
--- Niall Litchfield
<[EMAIL PROTECTED]> wrote: > I
 

haven't
   

read it yet, but I'd be amazed if Connor's
 

book wasn't excellent.
He is a great communicator, despite being an
   

aussie
   

and all.

Mogens and Tony from apress are probably pretty
   

busy
   

with the Miracle db
forum right now (work gloves and stuff were
mentioned euurgh), but there are
plans that exist in more than Mogens' head for
   

an
   

OakTable press sequence of
books, with apress as publishers. Someone has to
write the buggers though.
Some of us have work to do.
Niall

Not american, but not big and not clever either.

   

-Original Message-
From: [EMAIL PROTECTED]
 

[mailto:[EMAIL PROTECTED] On
   

Behalf Of Ryan
Sent: 05 January 2004 22:34
To: Multiple recipients of list ORACLE-L
Subject: oaktable people
Conner McDonald's book just came out and it
 

looks
   

to be
   

pretty good. Any more books in the pipeline?

--
Please see the official ORACLE-L FAQ:
 

http://www.orafaq.net
   

--
Author: Ryan
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
 

http://www.fatcity.com
   

San Diego, California-- Mailing list
 

and
   

web hosting services
   

-
 

To REMOVE yourself from this mailing list,
 

send an
   

E-Mail message
   

to: [EMAIL PROTECTED] (note EXACT spelling
 

of
   

'ListGuru')
   

and in the message BODY, include a line
 

containing: UNSUB
   

ORACLE-L (or the name of mailing list you want
 

to
   

be removed
   

from).  You may also send the HELP command for
 

other
   

information (like subscribing).

 

--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Niall Litchfield
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and
   

web
   

hosting services

   

-
 

To REMOVE yourself from this mailing list, send
   

an
   

E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing:
   

UNSUB
   

ORACLE-L
(or the name of mailing list you want to be
   

removed
   

from).  You may
also send the HELP command for other information
(like subscribing).
   

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]
"GIVE a man a fish and he will eat for a day. But
 

TEACH him how to fish, and...he will sit in a boat
and drink beer all day"
   

 


 

Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
--
Please see the official ORACLE-L FAQ:
 

http://www.orafaq.net
   

--
Author: =?iso-8859-1?q?Connor=20McDonald?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
 

http://www.fatcity.com
   

San Diego, California-- Mailing list and
 

web hosting services
   

-
 

To REMOVE yourself from this mailing list, send an
 

E-Mail message
   

to: [EMAIL PROTECTED] (note EXACT spelling of
 

'ListGuru') and in
   

the message BODY, include a line containing: UNSUB
 

ORACLE-L
   

(or the name of mailing list you want to be
 

removed from).  You may
   

also send the HELP c

OT: RE: DBA position

[Paul Drake]

--- "Mercadante, Thomas F"
<[EMAIL PROTECTED]> wrote:
> I like the "relocation" info.  It says 'None' and
> then 'click here'.  When
> you do that, it says:
>  
> None - Lifetouch offers no assistance.
>  
> I guess this is in case you don't understand the
> meaning of the word "None".
> 
> Tom Mercadante 
> Oracle Certified Professional 

Here is a good test of if you'll like Minnesota:

Order any type of food in a restaurant.
The Waiter/Waitress asks:
"Do you want cheese on that?"
If you answer "You betcha" - you're in.

Pd


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: oaktable people

[Mogens Nørgaard]

Heh-heh. It should be said in all fairness that we don't really spend 
much time with our website (keeping it updated, for instance - just to 
mention one minor detail), so we certainly understand if people are 
asking for directions there :).

One very un-serious question: Is it actually possible to do a "revoke 
all from grant;"?

Mogens

Grant Allen wrote:

D'oh ... just spotted the link to Oaktable - hidden, of all places, under "Links".  Who'd a thought ...

Ciao
Fuzzy
:-)
--
The contents of this post are my opinions only
 If swallowed seek medical advice 
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: another OCP question -- help me guys

[Mogens Nørgaard]

I demand to know who the other one is!

Mogens

Rachel Carmichael wrote:

you leave me such straight lines :)

which part is qualified as an accountant?

you volunteer to be the sacrificial lamb? Hm, masochist?

Before Jared tries to send everyone over to my list on this topic, I'll
try to bring it at least slightly back on topic.  I really don't care
if someone has a degree or has completed the OCP exams. I want to see
what they have done in practice, or if they are interviewing for a
truly junior position, I want to know how they learn, what they've
played with on their own. 

Two of the smartest men I have ever known never finished college.

--- Niall Litchfield <[EMAIL PROTECTED]> wrote:
 

Rachel writes
   

Now I understand their use, I shall immediately go out and 
hire an art history major as the deparmental sacrifical lamb 
(and dartboard while we are at it)
 

Hey I have an *economics* degree, *and* am a part-qualified
accountant. I
claim that sacrificial lamb position as my own. Nothing so useful as
Art in
my background, just graphs with the axes befuddled. 

Niall

P.S. I can work powerpoint too. 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall Litchfield
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
   



__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: A free sql analysis tool

[Daniel Hanks]

On Thu, 8 Jan 2004, Jared Still wrote:

> interesting. 
> 
> you might want to hack it for time slices being in uS 
> on 9i, otherwise you get some rather interesting results.
> 
> Jared
> 

Ah. Yeah. Still using 8i here. *sigh*. I've updated the script to allow you to set a 
variable to determine the resolution. It'll also now try and figure out the Oracle 
version on its own if it can.

I also tried the script on the sample 9i trace that comes with Oracle::Trace, and it 
croaks. Looks like I expect a PARSE line immediately following the END OF STMT line 
closing each PARSING IN CURSOR section. I'll have to fix that. Can anybody shed any 
light on why there are no PARSE lines after END OF STMT in the following two trace 
sections:


=
PARSING IN CURSOR #1 len=32 dep=0 uid=63 oct=42 lid=63 tim=1046586568955488 
hv=4220954983 ad='55afb3bc'
alter session set sql_trace true
END OF STMT
EXEC #1:c=16000,e=50842,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1046586568924750
*** 2003-12-17 15:44:32.818
=
PARSING IN CURSOR #1 len=24 dep=0 uid=63 oct=3 lid=63 tim=1046586594549056 
hv=4113743782 ad='55b0eef4'
select sysdate from dual
END OF STMT
dep=0,og=4,tim=1046586594548851
EXEC #1:c=3000,e=19436,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1046586594577246
FETCH #1:c=1000,e=1235,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1046586594583271
FETCH #1:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1046586594615367
*** 2003-12-17 15:44:50.253


Looking at Cary/Jeff's book, this is probably the answer: (page 104)

"The kernel did not emit information about the parse of the ALTER SESSION command, 
because tracking wasn't enabled until after the parse had completed."

That explains the first absence, but what about it not being there for the select 
statement? And what about that line beginning with "dep=0"...Is that normal? I looked 
through a cople of dozen of trace files I have (8i) and don't see any lines like 
that...Should I ignore such lines?

Thanks for any input,

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Hanks
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Bobak, Mark]

Then ask for the bug to be filed against the spec! ;-)

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Thursday, January 08, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L



Comment in-line

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
> 
> Roughly, a bug would seem to be code that falls into one of 
> two categories:
> 
> * code that doesn't do what the developer intended
> * code that generates errors 
> 

Several years ago I raised an issue with Oracle support
where something was clearly going wrong - can't remember
what, too long ago - and got told that I couldn't get the
issue logged as a bug because the code was performing
to specification.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Suggestions Needed: Latch free - library cache

[Jonathan Lewis]

Note in-line

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
> Other than the four parse invocations in your message, I think we can add
one
> between your first and second: Invoke a parse to create a new version of
the
> same cursor (same in the sense of same address and hash) due to either
bind
> threshold change or execution plan change.

An interesting point there - I think we tend to include the optimisation
phase in the concept of parsing; but perhaps there ought to be a breakdown
in the statistics so we actually see a statistic called something like:
"plans generated"
so that the number of optimisation events stands out from the
hard parses.  (I suspect a hard parse is probably synonymous
with an optimize, but I'm not sure of that).

In terms of costing, then, I think we only need five or six statistics:
a)search for text
b)check objects
c)check permissions
d)generate plan
e)use cached cursor
f)use held cursor
g)???

(I'm trying to break it down into the major cost areas -
obviously a 'check objects' cost would vary with the number
of objects in the query, so any very fine detail wouldn't
really add value).

>
> To the OP: Other people point out common reasons for library cache latch
> contention. A less common reason is extensive use of public synonyms. If
that's
> the reason, you also see row cache objects latch contention.
>

I'm not sure that's right.  If everyone uses a public synonym, then
you get one sql text, and one cursor.  I think the contention appears
because everyone has to have a 'non-existent' reference in memory
to say that they don't own an object with the same name as the public
synonym - consequently if you have lots of users who have to check
long chains of  'non-existent' then the latches get held for longer
periods of time.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Should we stop analyzing?

[Jonathan Lewis]

Comment in-line

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
> 
> Roughly, a bug would seem to be code that falls into one of 
> two categories:
> 
> * code that doesn't do what the developer intended
> * code that generates errors 
> 

Several years ago I raised an issue with Oracle support
where something was clearly going wrong - can't remember
what, too long ago - and got told that I couldn't get the
issue logged as a bug because the code was performing
to specification.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Any good product / option for Source code control

[eric king]

I like Visual Source Safe.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 4:19 PM


> Carry,
> 
> Thanks for your input. I really got good response.
> 
> Regards
> Rafiq
> 
> 
> 
> 
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Wed, 07 Jan 2004 11:29:37 -0800
> 
> WinCVS has worked well for us and several of our friends. www.wincvs.org
> 
> If I recall correctly, it's free.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Performance Diagnosis 101: 1/27 Atlanta
> - SQL Optimization 101: 2/16 Dallas
> - Hotsos Symposium 2004: March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> 
> -Original Message-
> M Rafiq
> Sent: Wednesday, January 07, 2004 12:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> Env: Windows 2000/NT/HP-UX/Solaris/Linux
> Oracle Databases: 7.3 to 9.2.0.4
> 
> I am looking for any good product/option for centralized source code
> control.
> 
> Any pointer or experiences shall be appreciated.
> 
> Regards
> Rafiq
> 
> _
> Have fun customizing MSN Messenger - learn how here!
> http://www.msnmessenger-download.com/tracking/reach_customize
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: M Rafiq
>INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Cary Millsap
>INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> _
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: M Rafiq
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: eric king
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Any good product / option for Source code control

[M Rafiq]

Carry,

Thanks for your input. I really got good response.

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 07 Jan 2004 11:29:37 -0800
WinCVS has worked well for us and several of our friends. www.wincvs.org

If I recall correctly, it's free.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
M Rafiq
Sent: Wednesday, January 07, 2004 12:34 PM
To: Multiple recipients of list ORACLE-L
Env: Windows 2000/NT/HP-UX/Solaris/Linux
Oracle Databases: 7.3 to 9.2.0.4
I am looking for any good product/option for centralized source code
control.
Any pointer or experiences shall be appreciated.

Regards
Rafiq
_
Have fun customizing MSN Messenger - learn how here!
http://www.msnmessenger-download.com/tracking/reach_customize
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Cary Millsap
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Trigger Question

[GovindanK]

Ok. Here you go.

http://osi.oracle.com/~tkyte/Mutate/index.html

Let me know if you find this useful.

HTH

GovindanK
OCP 8,8i
Brainbench Certified Master DBA(8)


On Thu, 08 Jan 2004 11:24:25 -0800, "Nuala Cullen" <[EMAIL PROTECTED]>
said:
> 
> Hi All,
> 
> Firstly my apologies if this seems like a very *stupid* question but I'm
> a
> tad confused (and it's late in the evening)
> 
> When an AFTER INSERT trigger is fired (row level) has the row been
> committed
> to the database at this stage?
> 
> If so is it ok to call a package in the trigger that selects that row and
> changes some values in the row?
> 
> Thanks,
> 
> N.
> 

-- 
http://www.fastmail.fm - Or how I learned to stop worrying and
  love email again
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: table reorganizations - simple/complex

[Cary Millsap]

Nelson, I think you're right on both accounts.

About how a fragmented table would show up in 10046 data: there are lots
of people on the list. Maybe one has the time to try it. If it takes
more time, it'll show up in response time *somehow*. If not, then it's
simply not a problem for the case being traced.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L

Comments in-line.

-Original Message-
Sent: Wednesday, January 07, 2004 10:59 PM
To: Multiple recipients of list ORACLE-L



>There are a lot of tuning "authorities" that make hard
>and fast rules about how to find problem areas by simply
>running a few queries.
>
>It is unfortunately, not that simple.  Or for people like
>Cary Millsap, Gary Goodman, Steve Adams, Jonathan Lewis
>and a number of others, it is, fortunately for them, not
>that simple.  ;)
>
>

I think Cary and Gary (plus many others) would argue that 
the hard-and-fast rules accompanied by long, multiple checklists
of parameter settings, v$ queries, etc. are what is truly "not simple."

The whole point of Method-R (the Millsap/Goodman/Holt tuning method) is
to
de-mystify
and simplify tuning.  Eliminate the guess-work.  Precisely identify the
performance issue and nail it.  Everyone who is willing to put in some
sweat
equity
can use Method-R.

I'm not sure how a badly fragmented table would show up in a 10046 trace
file.
If a table reorganization is really required, I think a trace would show
excess physical io.

Nelson Petersen



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: simple question

[Mladen Gogala]

Why do you have r declared as number(10)?
On 01/08/2004 03:24:25 PM, oranew2004 wrote:
> CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables
> (
> schema_ownerIN VARCHAR2
> ) 
> AS
>r number(10);
> BEGIN
> FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner)
>   LOOP
> EXECUTE IMMEDIATE 'truncate table schema_owner.'||r.table_name;
>   END LOOP;
> END;  
>  
>  
> ERROR:  Line 14 Column 55 PLS-00364: loop index variable 'R' use is invalid.
>  
>  
> Any ideas?
>  
> Thank you!
>  
>  
> 
> 
> -
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: simple question

[Stephen.Lee]

I'll add that if you have foreign keys, they will mess you up.  Here is an
old script I have in my stash that you can modify with info already provided
by others.

procedure truncate_all(code_word in varchar2 default 'XXX') is
   cursor c1 is select table_name,constraint_name from user_constraints
where constraint_type = 'R';
   cursor c2 is select table_name from user_tables;
   handle integer;
   rows integer;
begin
   if code_word != 'NUKE' then
  raise_application_error(-20001, 'WRONG MAGIC WORD, BUCKWHEAT.');
   end if;
   dbms_output.enable(10);
   handle := dbms_sql.open_cursor;
   for t in c1 loop
  dbms_sql.parse(handle,'alter table '||t.table_name||' disable
constraint '||t.constraint_name, dbms_sql.native);
  rows := dbms_sql.execute(handle);
   end loop;
   for t in c2 loop
  dbms_sql.parse(handle,'truncate table '||t.table_name,
dbms_sql.native);
  rows := dbms_sql.execute(handle);
   end loop;
   for t in c1 loop
  dbms_sql.parse(handle,'alter table '||t.table_name||' enable
constraint '||t.constraint_name, dbms_sql.native);
  rows := dbms_sql.execute(handle);
   end loop;
exception
   when others then
  dbms_output.put_line(SQLCODE||': '||SQLERRM);
end;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: table reorganizations - simple/complex

[nelson . petersen]

Comments in-line.

-Original Message-
Sent: Wednesday, January 07, 2004 10:59 PM
To: Multiple recipients of list ORACLE-L



>There are a lot of tuning "authorities" that make hard
>and fast rules about how to find problem areas by simply
>running a few queries.
>
>It is unfortunately, not that simple.  Or for people like
>Cary Millsap, Gary Goodman, Steve Adams, Jonathan Lewis
>and a number of others, it is, fortunately for them, not
>that simple.  ;)
>
>

I think Cary and Gary (plus many others) would argue that 
the hard-and-fast rules accompanied by long, multiple checklists
of parameter settings, v$ queries, etc. are what is truly "not simple."

The whole point of Method-R (the Millsap/Goodman/Holt tuning method) is to
de-mystify
and simplify tuning.  Eliminate the guess-work.  Precisely identify the
performance issue and nail it.  Everyone who is willing to put in some sweat
equity
can use Method-R.

I'm not sure how a badly fragmented table would show up in a 10046 trace
file.
If a table reorganization is really required, I think a trace would show
excess physical io.

Nelson Petersen



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Any Oracle 9i Data Guard limitations specific to Linux

[Carel-Jan Engel]

Hi William,

During the past 2,5 years I've been responsible for appr 20 DG 
installations, varying form 9.0.1 to 9.2.0.4, most Physical Standby. 
Logical Standby is not ready for High Availability purposes yet, but 
Physical Standby definitely is. The biggest production systems I've worked 
on were severel hundreds of Megabytes, most of them on Solaris. The biggest 
Linux site I've worked with was around 100 MB. Today I configured a Linux 
RH installation for one of my customers.

No experience with DG in combination with raw partitions.

I'll send you the materials I created for several classed I tought on DG, 
and would like to stay in touch with you about your experiences.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===
At 11:34 8-1-04 -0800, you wrote:
Does anyone here know of any Oracle 9i (9.2.0.4) Data Guard limitations 
and/or needed workarounds?

In the process of planning a near-terabyte size data warehouse utilizing 
both Real Application Clusters (RAC) and Data Guard (primary/standby) 
technologies on a Linux (Red Hat v 2.1) environment (using raw partitions).

As part of my active research on the matter (manuals, release notes, OTN, 
etc.), I am wondering if anybody on the list knows (from experience) of 
any specific limitations (e.g., bugs, etc.) that may be encountered while 
using the Data Guard (logical or physical standby databases and 
synchronous or asynchronous modes) implementation on Linux? In other 
words, looking for any information about possible limitations (or special 
workarounds needed) using Data Guard on a Linux implementation.

Regards,

William
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: William R. Jones
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA tasks

[Loughmiller, Greg]

Title: RE: DBA tasks





deja vu..


story of our lives around here.


greg


-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 08, 2004 11:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBA tasks



That was funny.


Thanks, I needed that.


: )


Another funny thread might be silly instance names people use for
development databases, but then oops!  The database is now production.


Patrice


-Original Message-
Sent: January 8, 2004 9:34 AM
To: Multiple recipients of list ORACLE-L



I had one like that:
I created a database under our 7.1.6, because "We need an Oracle database
for development." "When?" "Yesterday!"
I gave them usernames and passwords and made sure that TNSNAMES was
configured.
In monitoring a few weeks later, I noticed no activity, so I asked them,
"That database you wanted right away isn't being used, is there a problem."
"No problem, we just had a delay, we're going to be starting any day now."
Two years later, I was upgrading some databases to 8.  The database had
still not been used, other than a few objects created.  "Should I upgrade
this database?", I asked.  "Oh no, don't bother, we're not using it."  "Can
I delete it?" "No, please keep it around.  We're going to need it anytime
now."
A year later, I backed it up with export to tape, in case I ever wanted it
back, and deleted it (along with Oracle home for 7.1.6).  Five years later,
I don't think anyone ever noticed that it was gone.  The tape is in a drawer
somewhere.
Most troublefree database I've ever had.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA position

[Bellow, Bambi]

Title: RE: DBA position



Bet 
they wanna pay $3.50/wk.

  -Original Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 1:54 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  DBA position
  WORSE than that! 
  they want TEN YEARS dba experience with Oracle AND Sql Server 
  experience, and management and BS and Masters and a red cape... 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas  @>-->-->-- Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  -Original Message- From: Joe 
  Testa [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, January 08, 2004 1:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: DBA position 
  this always amazes me: 
  # Bachelor's degree in Computer Science, Engineering, or 
  related discipline. # Master's degree is 
  desirable. 
  guess that leaves me out :) 
  joe 
  Jared Still wrote: 
  >http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime 
  > >The domain name may be 
  familiar, a prolific poster on this >list happens 
  to be there as well. > >The location is  Minneapolis, MN, USA > > > 
  > > > >  > 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Joe Testa   INET: 
  [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 
  


  The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

RE: Should we stop analyzing?

[Carel-Jan Engel]

At 11:09 8-1-04 -0800, you wrote:
'Waddya mean, propaganda sheets?  We never release propaganda - everything 
always works the way we say it does! '
Says Pat -Al-Shahaf- Sherman, so it must be the truth, the whole truth and 
nothing but the truth

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===
Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Sent: Friday, 9 January 2004 5:49 AM
To: Multiple recipients of list ORACLE-L
Right Jared,

But this is where the new 'learning CBO' comes into picture isn't it? in 
10g CBO looks at the history and then modified the execution plans.

This is all from Oracle 10g propaganda sheets, I'll agree when I see it in 
action.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Thursday, January 08, 2004 1:40 PM
To: Multiple recipients of list ORACLE-L
> Me thinks CBO is probably never going to be bug free.
> What works for you, won't work for me unless we run
> identical systems, it is a general purpose system,
> CBO doesn't know your system or data usage.
At this point it would seem beneficial to differentiate between a
bug and a logic error.
Roughly, a bug would seem to be code that falls into one of
two categories:
* code that doesn't do what the developer intended
* code that generates errors
A logic error would be found in code that does exactly what
the developer intended, but what the developer intended is
the wrong thing to do.
This could be expanded to include the inability of CBO to
properly identify a usage pattern.
just my opinion.

Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Sharman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: simple question

[Mercadante, Thomas F]

Remove 
the  
 
r 
number(10);
 
and it 
should be fine.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: oranew2004 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 3:24 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  simple question
  CREATE OR REPLACE PROCEDURE 
  labware_admin.truncate_tables(    
  schema_owner    IN VARCHAR2) 
  AS
     r number(10);
  BEGIN
  FOR r IN (SELECT table_name FROM dba_tables WHERE 
  owner=schema_owner)  LOOP    EXECUTE IMMEDIATE 
  'truncate table schema_owner.'||r.table_name;  END LOOP;
  END;  
   
   
  ERROR:  Line 14 Column 55 PLS-00364: loop index variable 'R' use is 
  invalid.
   
   
  Any ideas?
   
  Thank you!
   
   
  
  
  Do you Yahoo!?Yahoo! Hotjobs: Enter 
  the "Signing Bonus" Sweepstakes

Re: A free sql analysis tool

[Carel-Jan Engel]

At 10:39 8-1-04 -0800, you wrote:
Doh! Nothing like Google telling the world about something you put on your 
website. :-).

The script on the link given is something I put together after reading 
through Cary and Jeff's book. It's currently pretty simple, and doesn't 
(yet) handle recursive calls (patches are welcome :-). But for simpler 
traces, it does a decent job of letting you know where the time in your 
trace is going.

I'd appreciate any feedback, bug reports, etc. I'd like to see a robust, 
featureful open-source 10046 trace analyzer developed. (Competition is a 
good thing, right Cary? :-).
Maybe TFR, TraceFile Repository, developed by Torben Holm form Miracle AS 
and free downloadable form their site 
(http://www.miracleas.dk/tools/MirTFR104.zip) might be a starting point? 
I've used it succesfully in fighting several 'hit-and-run' 
performance-disaster recovery situations. It's in PL/SQL, combined with 
iAS, and gives you browser-access to your trace-data. I like it.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===
-- Dan

On Thu, 8 Jan 2004, Hatzistavrou John wrote:

> Dear All,
>
>
>
> I have found this Perl script that makes an analysis of 10046 SQL trace
>
>
>
> http://brainshed.com/software/
>
>
>
> Kind Regards,
>
>
>
>
>
> Hatzistavrou Yannis
>
>
>
>
--

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Hanks
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
=== 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: simple question

[Mercadante, Thomas F]

Greg,
 
Try 
this:
 
create 
or replace procedure truncate_tables(in_owner in varchar2) 
is
BEGIN  FOR r IN (SELECT table_name FROM dba_tables WHERE 
owner=in_owner)  
LOOP    EXECUTE IMMEDIATE 'truncate table ' || in_owner || '.' || r.table_name;  
END LOOP;END;/
 

You 
will need to grant select on DBA_TABLES to the owner of this procedure.  
You may also need to grant ALTER ANY TABLE to the same user to allow you to 
perform the Truncate function.  I forget exactly which priv you need to do 
this - but something extra needs to be granted to the owner of the procedure to 
perform the trancate function.
 
Good 
Luck
 
Tom 
Mercadante Oracle Certified 
Professional 

  -Original Message-From: Greg Sorrel 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 2:55 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  simple question
  Hi!
   
  I  need to wrap this SQL into SP where I can pass new owner name. 
  I'm planning create db table with all owners I need to pass.
   
  BEGIN  FOR r IN (SELECT table_name FROM dba_tables WHERE 
  owner='TRAIN1')  LOOP    EXECUTE IMMEDIATE 
  'truncate table TRAIN1.'||r.table_name;  END LOOP;END;/
   
  Thanks.
   
  Greg
  
  
  Do you Yahoo!?Yahoo! Hotjobs: Enter 
  the "Signing Bonus" Sweepstakes

Re: DBA position

[Ryan]

Title: RE: DBA position



alot of companies put tons of stuff in job reqs. 
You dont know what is really important to them until you apply. This includes 
degree, experience, and all the buzzwords.
 
This happens all the time. 

  - Original Message - 
  From: 
  April Wells 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, January 08, 2004 2:54 
  PM
  Subject: RE: DBA position
  
  WORSE than that! 
  they want TEN YEARS dba experience with Oracle AND Sql Server 
  experience, and management and BS and Masters and a red cape... 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas  @>-->-->-- Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  -Original Message- From: Joe 
  Testa [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, January 08, 2004 1:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: DBA position 
  this always amazes me: 
  # Bachelor's degree in Computer Science, Engineering, or 
  related discipline. # Master's degree is 
  desirable. 
  guess that leaves me out :) 
  joe 
  Jared Still wrote: 
  >http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime 
  > >The domain name may be 
  familiar, a prolific poster on this >list happens 
  to be there as well. > >The location is  Minneapolis, MN, USA > > > 
  > > > >  > 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Joe Testa   INET: 
  [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 
  


  The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

RE: DBA position

[Mercadante, Thomas F]

Title: RE: DBA position



I like 
the "relocation" info.  It says 'None' and then 'click here'.  When 
you do that, it says:
 
None - 
Lifetouch offers no assistance.
 
I 
guess this is in case you don't understand the meaning of the word 
"None".
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 2:54 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  DBA position
  WORSE than that! 
  they want TEN YEARS dba experience with Oracle AND Sql Server 
  experience, and management and BS and Masters and a red cape... 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas  @>-->-->-- Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  -Original Message- From: Joe 
  Testa [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, January 08, 2004 1:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: DBA position 
  this always amazes me: 
  # Bachelor's degree in Computer Science, Engineering, or 
  related discipline. # Master's degree is 
  desirable. 
  guess that leaves me out :) 
  joe 
  Jared Still wrote: 
  >http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime 
  > >The domain name may be 
  familiar, a prolific poster on this >list happens 
  to be there as well. > >The location is  Minneapolis, MN, USA > > > 
  > > > >  > 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- Author: Joe Testa   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 
  


  The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

Re: simple question

[oranew2004]

CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables(    schema_owner    IN VARCHAR2) AS
   r number(10);
BEGIN
FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner)  LOOP    EXECUTE IMMEDIATE 'truncate table schema_owner.'||r.table_name;  END LOOP;
END;  
 
 
ERROR:  Line 14 Column 55 PLS-00364: loop index variable 'R' use is invalid.
 
 
Any ideas?
 
Thank you!
 
 
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

RE: Trigger Question

[Wolfgang Breitling]

Of course. Silly me.

At 12:54 PM 1/8/2004, you wrote:
Wolfgang,

Yes you may, within the trigger only, change values of that row 
only.  it's known as

:new. := ;

>If so is it ok to call a package in the trigger that selects that row and
>changes some values in the row?
a) it is not so and
b) you can not do anything with that row (or that table for that matter) in
either the trigger or any called package or procedure. You'll get a
"mutating table" error.
--
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DBA position

[Joe Testa]

yea me neither, oh wait, damn sig line states otherwise.

--
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001



Thater, William wrote:

Joe Testa  scribbled on the wall in glitter crayon:

 

this always amazes me:

# Bachelor's degree in Computer Science, Engineering, or related
discipline. # Master's degree is desirable.
guess that leaves me out :)
   

well, at least i'm in distinguished company.;-)  but then i don't want to be
no boss no way no how.;-)
--
Bill "Shrek" Thater ORACLE DBA  
"I'm going to work my ticket if I can..." -- Gilwell song
   [EMAIL PROTECTED]

Great spirits have always found violent opposition from mediocre minds. The
latter cannot understand it when a man does not thoughtlessly submit to
hereditary prejudices but honestly and courageously uses his intelligence. -
Albert Einstein
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Pete Sharman]

Of course!
 
Pete
 
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-Original Message-
Sent: Friday, 9 January 2004 6:29 AM
To: Multiple recipients of list ORACLE-L

And if it doesn't it's a "documentation error". ;-)

At 12:09 PM 1/8/2004, you wrote:
>Waddya mean, propaganda sheets?  We never release propaganda - everything 
>always works the way we say it does!  :)
>
>
>Pete
>
>"Controlling developers is like herding cats."
>Kevin Loney, Oracle DBA Handbook
>
>"Oh no, it's not.  It's much harder than that!"
>Bruce Pihlamae, long-term Oracle DBA
>
>--
>Author: Pete Sharman
>   INET: [EMAIL PROTECTED]

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA position

[Paula_Stankus]

What about a good solid resume with experience showing and a cover letter?  

-Original Message-
Joe Testa
Sent: Thursday, January 08, 2004 2:45 PM
To: Multiple recipients of list ORACLE-L


this always amazes me:

# Bachelor's degree in Computer Science, Engineering, or related discipline.
# Master's degree is desirable.

guess that leaves me out :)

joe



Jared Still wrote:

>http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime
>
>The domain name may be familiar, a prolific poster on this
>list happens to be there as well. 
>
>The location is  Minneapolis, MN, USA
>
>
>
>
>
>
>  
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Trigger Question

[Poras, Henry R.]

You can do some funky stuff with Autonomous Transactions (trigger
independent from initiating transaction), but I need lots more coffee before
even attempting more detail on this.

Henry


-Original Message-
Mladen Gogala
Sent: Thursday, January 08, 2004 2:45 PM
To: Multiple recipients of list ORACLE-L


Row has not been commited yet. The AFTER INSER trigger fires
after the row has been inserted. Rollback can still undo all
the changes performed by both insert and trigger. And no,
trigger cannot select from the table it is defined on, not 
even through a procedure. 
On 01/08/2004 02:24:25 PM, Nuala Cullen wrote:
> 
> Hi All,
> 
> Firstly my apologies if this seems like a very *stupid* question but I'm a
> tad confused (and it's late in the evening)
> 
> When an AFTER INSERT trigger is fired (row level) has the row been
committed
> to the database at this stage?
> 
> If so is it ok to call a package in the trigger that selects that row and
> changes some values in the row?
> 
> Thanks,
> 
> N.
> 
> 

--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Poras, Henry R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA position

[Thater, William]

Joe Testa  scribbled on the wall in glitter crayon:

> this always amazes me:
> 
> # Bachelor's degree in Computer Science, Engineering, or related
> discipline. # Master's degree is desirable.
> 
> guess that leaves me out :)

well, at least i'm in distinguished company.;-)  but then i don't want to be
no boss no way no how.;-)

--
Bill "Shrek" Thater ORACLE DBA  
"I'm going to work my ticket if I can..." -- Gilwell song
[EMAIL PROTECTED]

Great spirits have always found violent opposition from mediocre minds. The
latter cannot understand it when a man does not thoughtlessly submit to
hereditary prejudices but honestly and courageously uses his intelligence. -
Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

simple question

[Greg Sorrel]

Hi!
 
I  need to wrap this SQL into SP where I can pass new owner name. I'm planning create db table with all owners I need to pass.
 
BEGIN  FOR r IN (SELECT table_name FROM dba_tables WHERE owner='TRAIN1')  LOOP    EXECUTE IMMEDIATE 'truncate table TRAIN1.'||r.table_name;  END LOOP;END;/
 
Thanks.
 
Greg
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

RE: Trigger Question

[Goulet, Dick]

Wolfgang,

Yes you may, within the trigger only, change values of that row only.  it's 
known as

:new. := ;

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Thursday, January 08, 2004 2:39 PM
To: Multiple recipients of list ORACLE-L


I'm sure I will be corrected if I'm wrong.
Answers inline

At 12:24 PM 1/8/2004, you wrote:

>Hi All,
>
>Firstly my apologies if this seems like a very *stupid* question but I'm a
>tad confused (and it's late in the evening)
>
>When an AFTER INSERT trigger is fired (row level) has the row been committed
>to the database at this stage?

No. You could raise an error as part of what the trigger does in order to 
reject the action.

>If so is it ok to call a package in the trigger that selects that row and
>changes some values in the row?

a) it is not so and
b) you can not do anything with that row (or that table for that matter) in 
either the trigger or any called package or procedure. You'll get a 
"mutating table" error.


>Thanks,
>
>N.
>

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Quest....

[AdamDonahue]

We run Spotlight here, although I go right to the various v$ tables.  I 
did notice some quirkiness in how Spotlight's 'Top 10 SQL' lists rows. 
It's like it returns # of rows for a static query (e.g. select 'Y' from 
some_table where some_predicate = :b1) as '1' although it's executed with 
separate predicates a large number of times, which of course also skews 
its overall statistics.   A bit confusing.

Adam




"Jonathan Lewis" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
01/08/2004 08:44 AM
Please respond to
[EMAIL PROTECTED]


To
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc

Subject
Re: Quest







The number of sites I go to that use spotlight 
to keep a check on the top 10 SQL statements -
it's weird, but it always seems to be this query
against v$sqlarea.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 4:29 PM


> I'm TOADing and Spotlighting right now...  :)
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA position

[April Wells]

Title: RE: DBA position





WORSE than that!


they want TEN YEARS dba experience with Oracle AND Sql Server experience, and management and BS and Masters and a red cape... 

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
 @>-->-->--
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 08, 2004 1:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: DBA position



this always amazes me:


# Bachelor's degree in Computer Science, Engineering, or related discipline.
# Master's degree is desirable.


guess that leaves me out :)


joe




Jared Still wrote:


>http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime
>
>The domain name may be familiar, a prolific poster on this
>list happens to be there as well. 
>
>The location is  Minneapolis, MN, USA
>
>
>
>
>
>
>  
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

Trigger Question

[Nuala Cullen]

Hi All,

Firstly my apologies if this seems like a very *stupid* question but I'm a
tad confused (and it's late in the evening)

When an AFTER INSERT trigger is fired (row level) has the row been committed
to the database at this stage?

If so is it ok to call a package in the trigger that selects that row and
changes some values in the row?

Thanks,

N.

<>

Re: Trigger Question

[Mladen Gogala]

Row has not been commited yet. The AFTER INSER trigger fires
after the row has been inserted. Rollback can still undo all
the changes performed by both insert and trigger. And no,
trigger cannot select from the table it is defined on, not 
even through a procedure. 
On 01/08/2004 02:24:25 PM, Nuala Cullen wrote:
> 
> Hi All,
> 
> Firstly my apologies if this seems like a very *stupid* question but I'm a
> tad confused (and it's late in the evening)
> 
> When an AFTER INSERT trigger is fired (row level) has the row been committed
> to the database at this stage?
> 
> If so is it ok to call a package in the trigger that selects that row and
> changes some values in the row?
> 
> Thanks,
> 
> N.
> 
> 

--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DBA position

[Joe Testa]

this always amazes me:

# Bachelor's degree in Computer Science, Engineering, or related discipline.
# Master's degree is desirable.
guess that leaves me out :)

joe



Jared Still wrote:

http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime

The domain name may be familiar, a prolific poster on this
list happens to be there as well. 

The location is  Minneapolis, MN, USA





 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Trigger Question

[Bobak, Mark]

See in-line replies.

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Nuala Cullen
Sent: Thursday, January 08, 2004 2:24 PM
To: Multiple recipients of list ORACLE-L



Hi All,

Firstly my apologies if this seems like a very *stupid* question but I'm
a
tad confused (and it's late in the evening)

When an AFTER INSERT trigger is fired (row level) has the row been
committed
to the database at this stage?

  No, this action happens after the insert but before the
completion of the INSERT statement.  In other words, the trigger actions
are atomic to the statement that caused them to be executed.  If the
INSERT is committed, the trigger changes are also committed.  If the
INSERT is rolled back, so are the trigger modifications.

If so is it ok to call a package in the trigger that selects that row
and
changes some values in the row?

  No, this would likely cause mutation when doing multi-row
inserts.  If this is necessary, you may want to re-consider your app
design.  If that's out of the question, check MetaLink for the standard
mutation solution.

Hope that helps!

PS  Autonomous transactions are different, and an exception to
the above.  See the documentation for more details

Thanks,

N.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Trigger Question

[Wolfgang Breitling]

I'm sure I will be corrected if I'm wrong.
Answers inline
At 12:24 PM 1/8/2004, you wrote:

Hi All,

Firstly my apologies if this seems like a very *stupid* question but I'm a
tad confused (and it's late in the evening)
When an AFTER INSERT trigger is fired (row level) has the row been committed
to the database at this stage?
No. You could raise an error as part of what the trigger does in order to 
reject the action.

If so is it ok to call a package in the trigger that selects that row and
changes some values in the row?
a) it is not so and
b) you can not do anything with that row (or that table for that matter) in 
either the trigger or any called package or procedure. You'll get a 
"mutating table" error.


Thanks,

N.

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A free sql analysis tool

[Jamadagni, Rajendra]

I have a very very basic pl/sql implementation that I am working on.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, January 08, 2004 1:40 PM
To: Multiple recipients of list ORACLE-L


Doh! Nothing like Google telling the world about something you put on your website. 
:-).

The script on the link given is something I put together after reading through Cary 
and Jeff's book. It's currently pretty simple, and doesn't (yet) handle recursive 
calls (patches are welcome :-). But for simpler traces, it does a decent job of 
letting you know where the time in your trace is going.

I'd appreciate any feedback, bug reports, etc. I'd like to see a robust, featureful 
open-source 10046 trace analyzer developed. (Competition is a good thing, right Cary? 
:-).

-- Dan

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Any Oracle 9i Data Guard limitations specific to Linux implementations?

[William R. Jones]

Does anyone here know of any Oracle 9i (9.2.0.4) Data Guard limitations and/or needed 
workarounds?

In the process of planning a near-terabyte size data warehouse utilizing both Real 
Application Clusters (RAC) and Data Guard (primary/standby) technologies on a Linux 
(Red Hat v 2.1) environment (using raw partitions). 

As part of my active research on the matter (manuals, release notes, OTN, etc.), I am 
wondering if anybody on the list knows (from experience) of any specific limitations 
(e.g., bugs, etc.) that may be encountered while using the Data Guard (logical or 
physical standby databases and synchronous or asynchronous modes) implementation on 
Linux? In other words, looking for any information about possible limitations (or 
special workarounds needed) using Data Guard on a Linux implementation. 

Regards, 

William 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: William R. Jones
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA position

[STEVE OLLIG]

the position is slated to be said individuals PHB.  and all our databases
are mauve.  consider yourselves warned  ;)

but seriously - this is a good place to work.  candidates welcome. 

-Original Message-
Sent: Thursday, January 08, 2004 1:10 PM
To: Multiple recipients of list ORACLE-L




http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime

The domain name may be familiar, a prolific poster on this
list happens to be there as well. 

The location is  Minneapolis, MN, USA






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Wolfgang Breitling]

And if it doesn't it's a "documentation error". ;-)

At 12:09 PM 1/8/2004, you wrote:
Waddya mean, propaganda sheets?  We never release propaganda - everything 
always works the way we say it does!  :)

Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
--
Author: Pete Sharman
  INET: [EMAIL PROTECTED]
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: chk integrity of a .dmp exp

[Khedr, Waleed]

The "SHOW" option for import might be helpful

Waleed

-Original Message-
Sent: Thursday, January 08, 2004 12:59 AM
To: Multiple recipients of list ORACLE-L


Hi,

What is the procedure to check the integrity of a
exported .dmp file?

I have: an exported .dmp file of a critical database.

I want: to check the integrity, the contents, whether
it can be successfully restored.

I already know about: creating another test database
and trying to import this exported file. This is not
what I am looking for.

Is there a utility that displays the contents of a
.dmp in tree format AND verify the data integrity that
the ,dmp can be successfully restored?

Thanks
L. MOhan Arun

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: L. Mohan Arun
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Jared Still]

Yeah, copped a copy of 10g new features from somewhere, but
it was sorely lacking in detail. I seem to have missed the
CBO bit.

Jared

On Thu, 2004-01-08 at 10:49, Jamadagni, Rajendra wrote:
> Right Jared,
> 
> But this is where the new 'learning CBO' comes into picture isn't it? in 10g CBO 
> looks at the history and then modified the execution plans.
> 
> This is all from Oracle 10g propaganda sheets, I'll agree when I see it in action.
> 
> Raj
> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
> 
> 
> -Original Message-
> Sent: Thursday, January 08, 2004 1:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> > Me thinks CBO is probably never going to be bug free. 
> > What works for you, won't work for me unless we run
> > identical systems, it is a general purpose system, 
> > CBO doesn't know your system or data usage. 
> 
> At this point it would seem beneficial to differentiate between a
> bug and a logic error.
> 
> Roughly, a bug would seem to be code that falls into one of 
> two categories:
> 
> * code that doesn't do what the developer intended
> * code that generates errors 
> 
> A logic error would be found in code that does exactly what
> the developer intended, but what the developer intended is
> the wrong thing to do.
> 
> This could be expanded to include the inability of CBO to 
> properly identify a usage pattern.
> 
> just my opinion.
> 
> Jared
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Pete Sharman]

Waddya mean, propaganda sheets?  We never release propaganda - everything always works 
the way we say it does!  :)

 
Pete
 
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-Original Message-
Sent: Friday, 9 January 2004 5:49 AM
To: Multiple recipients of list ORACLE-L

Right Jared,

But this is where the new 'learning CBO' comes into picture isn't it? in 10g CBO looks 
at the history and then modified the execution plans.

This is all from Oracle 10g propaganda sheets, I'll agree when I see it in action.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, January 08, 2004 1:40 PM
To: Multiple recipients of list ORACLE-L


> Me thinks CBO is probably never going to be bug free. 
> What works for you, won't work for me unless we run
> identical systems, it is a general purpose system, 
> CBO doesn't know your system or data usage. 

At this point it would seem beneficial to differentiate between a
bug and a logic error.

Roughly, a bug would seem to be code that falls into one of 
two categories:

* code that doesn't do what the developer intended
* code that generates errors 

A logic error would be found in code that does exactly what
the developer intended, but what the developer intended is
the wrong thing to do.

This could be expanded to include the inability of CBO to 
properly identify a usage pattern.

just my opinion.

Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

DBA position

[Jared Still]

http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime

The domain name may be familiar, a prolific poster on this
list happens to be there as well. 

The location is  Minneapolis, MN, USA






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: A free sql analysis tool

[Jared Still]

interesting. 

you might want to hack it for time slices being in uS 
on 9i, otherwise you get some rather interesting results.

Jared

On Thu, 2004-01-08 at 02:59, Hatzistavrou John wrote:
> Dear All,
> 
>  
> 
> I have found this Perl script that makes an analysis of 10046 SQL trace
> 
>  
> 
> http://brainshed.com/software/
> 
>  
> 
> Kind Regards,
> 
>  
> 
>  
> 
> Hatzistavrou Yannis
> 
>  
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions Needed: Latch free - library cache

[Bobak, Mark]

Yong,

In case you missed it, see my previous reply to Jonathan's mail.  I'll
expand my test case and see what I can come up with for the other cases
you motion.

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Thursday, January 08, 2004 1:09 PM
To: Multiple recipients of list ORACLE-L


It would be good if Oracle could break SQL parse down into not just hard
and
soft, not just hard-soft-softer (Tom Kyte's wording), but different
levels.
Oracle may have to work slightly harder to update these new statistics
but the
benefit for OLTP databases is huge.

Other than the four parse invocations in your message, I think we can
add one
between your first and second: Invoke a parse to create a new version of
the
same cursor (same in the sense of same address and hash) due to either
bind
threshold change or execution plan change. In fact, these two types of
changes
may be broken down to two statistics. Looking at the columns in
v$sql_shared_cursor, I'm afraid we may need much more statistics?

To the OP: Other people point out common reasons for library cache latch
contention. A less common reason is extensive use of public synonyms. If
that's
the reason, you also see row cache objects latch contention.

Yong Huang

Jonathan Lewis wrote:
...
Code that issues a parse call may:
Invoke the whole parse/optimize cycle
Invoke a permissions cycle on an existing statement
Invoke a search and execute cycle on an existing statement with
valid
permission
Invoke a 'this is where it is and I know I've got permission, so
just do
it' cycle
...
NOTE: This description is probably not complete
and I'd welcome any corrections and refinements
that anyone can supply.

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Jamadagni, Rajendra]

Right Jared,

But this is where the new 'learning CBO' comes into picture isn't it? in 10g CBO looks 
at the history and then modified the execution plans.

This is all from Oracle 10g propaganda sheets, I'll agree when I see it in action.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, January 08, 2004 1:40 PM
To: Multiple recipients of list ORACLE-L


> Me thinks CBO is probably never going to be bug free. 
> What works for you, won't work for me unless we run
> identical systems, it is a general purpose system, 
> CBO doesn't know your system or data usage. 

At this point it would seem beneficial to differentiate between a
bug and a logic error.

Roughly, a bug would seem to be code that falls into one of 
two categories:

* code that doesn't do what the developer intended
* code that generates errors 

A logic error would be found in code that does exactly what
the developer intended, but what the developer intended is
the wrong thing to do.

This could be expanded to include the inability of CBO to 
properly identify a usage pattern.

just my opinion.

Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Jared Still]

> Me thinks CBO is probably never going to be bug free. 
> What works for you, won't work for me unless we run
> identical systems, it is a general purpose system, 
> CBO doesn't know your system or data usage. 

At this point it would seem beneficial to differentiate between a
bug and a logic error.

Roughly, a bug would seem to be code that falls into one of 
two categories:

* code that doesn't do what the developer intended
* code that generates errors 

A logic error would be found in code that does exactly what
the developer intended, but what the developer intended is
the wrong thing to do.

This could be expanded to include the inability of CBO to 
properly identify a usage pattern.

just my opinion.

Jared


On Thu, 2004-01-08 at 08:49, Jamadagni, Rajendra wrote:
> Me thinks CBO is probably never going to be bug free. What works for you, won't work 
> for me unless we run identical systems, it is a general purpose system, CBO doesn't 
> know your system or data usage. Still it tries to make a better judgment ..
> 
> Hey it is a whale lot better than those RDBMS where there are no hints to use in 
> case optimizer goes crazy.
> 
> Raj
> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
> 
> 
> -Original Message-
> Sent: Thursday, January 08, 2004 11:29 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> > 2- the CBO like any other piece of code, is sometimes buggy?
> 
> Always, not sometimes
> 
> Tanel.
> 
> **
> This e-mail message is confidential, intended only for the named recipient(s) above 
> and may contain information that is privileged, attorney work product or exempt from 
> disclosure under applicable law. If you have received this message in error, or are 
> not the named recipient(s), please immediately notify corporate MIS at (860) 
> 766-2000 and delete this e-mail message from your computer, Thank you.
> **4
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: A free sql analysis tool

[Daniel Hanks]

Doh! Nothing like Google telling the world about something you put on your website. 
:-).

The script on the link given is something I put together after reading through Cary 
and Jeff's book. It's currently pretty simple, and doesn't (yet) handle recursive 
calls (patches are welcome :-). But for simpler traces, it does a decent job of 
letting you know where the time in your trace is going.

I'd appreciate any feedback, bug reports, etc. I'd like to see a robust, featureful 
open-source 10046 trace analyzer developed. (Competition is a good thing, right Cary? 
:-).

-- Dan

On Thu, 8 Jan 2004, Hatzistavrou John wrote:

> Dear All,
> 
>  
> 
> I have found this Perl script that makes an analysis of 10046 SQL trace
> 
>  
> 
> http://brainshed.com/software/
> 
>  
> 
> Kind Regards,
> 
>  
> 
>  
> 
> Hatzistavrou Yannis
> 
>  
> 
> 

-- 

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Hanks
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORACLE-L Digest -- Volume 2004, Number 008 (Out of Office

[Jared Still]

At least he's on digest mode.

Otherwise I would have unsubscribed him some time ago.

On Thu, 2004-01-08 at 04:06, Richard Foote wrote:
> Let's hope he's not on long service leave :)
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, January 08, 2004 8:44 PM
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Richard Foote
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Suggestions Needed: Latch free - library cache

[Yong Huang]

It would be good if Oracle could break SQL parse down into not just hard and
soft, not just hard-soft-softer (Tom Kyte's wording), but different levels.
Oracle may have to work slightly harder to update these new statistics but the
benefit for OLTP databases is huge.

Other than the four parse invocations in your message, I think we can add one
between your first and second: Invoke a parse to create a new version of the
same cursor (same in the sense of same address and hash) due to either bind
threshold change or execution plan change. In fact, these two types of changes
may be broken down to two statistics. Looking at the columns in
v$sql_shared_cursor, I'm afraid we may need much more statistics?

To the OP: Other people point out common reasons for library cache latch
contention. A less common reason is extensive use of public synonyms. If that's
the reason, you also see row cache objects latch contention.

Yong Huang

Jonathan Lewis wrote:
...
Code that issues a parse call may:
Invoke the whole parse/optimize cycle
Invoke a permissions cycle on an existing statement
Invoke a search and execute cycle on an existing statement with valid
permission
Invoke a 'this is where it is and I know I've got permission, so just do
it' cycle
...
NOTE: This description is probably not complete
and I'd welcome any corrections and refinements
that anyone can supply.

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: chk integrity of a .dmp exp

[Bellow, Bambi]

Quick answer...

do a strings on the file... 

strings .dmo

the first line should be EXPORT:V
the last line should be EXIT

In between you should see stuff you recognize.

If all of that is in place, you have a valid .dmp file

Of course, I am assuming Unix.  Of course I am.
HTH,
Bambi.

-Original Message-
Sent: Wednesday, January 07, 2004 11:59 PM
To: Multiple recipients of list ORACLE-L


Hi,

What is the procedure to check the integrity of a
exported .dmp file?

I have: an exported .dmp file of a critical database.

I want: to check the integrity, the contents, whether
it can be successfully restored.

I already know about: creating another test database
and trying to import this exported file. This is not
what I am looking for.

Is there a utility that displays the contents of a
.dmp in tree format AND verify the data integrity that
the ,dmp can be successfully restored?

Thanks
L. MOhan Arun

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: L. Mohan Arun
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bellow, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Quest....

[Stephen.Lee]

Now I get the question.  Sorry about that.

-Original Message-

but it needs windows os to run ...

Right?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Suggestions Needed: Latch free - library cache

[Jonathan Lewis]

Thanks,

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 5:19 PM


> Jonathan,
> 
> Second session, same user:  first is soft w/o authentication.  Second is
> session cursor cache hit.
> Second session, different user: first is soft w/ authentication.  Second
> is session cursor cache hit.
> 
> So, once everything is cached, the same user case is as expected, and
> the different user case does even better than you predicted.
> 
> -Mark
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Quest....

[Jamadagni, Rajendra]

but it needs windows os to run ...

Right?

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, January 08, 2004 12:00 PM
To: Multiple recipients of list ORACLE-L



As far as I know (which isn't real far), spotlight just uses the Oracle
client.

-Original Message-

Has anyone tried to run spotlight on linux with windows crossover software?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions Needed: Latch free - library cache

[Bobak, Mark]

Jonathan,

Second session, same user:  first is soft w/o authentication.  Second is
session cursor cache hit.
Second session, different user: first is soft w/ authentication.  Second
is session cursor cache hit.

So, once everything is cached, the same user case is as expected, and
the different user case does even better than you predicted.

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Thursday, January 08, 2004 11:50 AM
To: Multiple recipients of list ORACLE-L



Excellent !!

I've been demonstrating in the past using v$latch
that the latch costs of parsing are different on 
the first, second, and third parse - and I've assumed
that that's why the cursor goes into the cache on
the third parse.  I've never thought that the
'cursor authentication' statistic might be relevant.

If you go to the other session 
a)  Where the user is the same - do you see a 
session cache cursor hit on the second execution,
or does it still not appear until the fourth
Rationale - maybe the cursor is put into the cache
on the first hit after full authentication.

b)Where the user is different - do you see a
session cache cursor hit on the THIRD execution,
or does it still not appear until the fourth.
Rationale - the first execution generates the in-memory
permissions; the second execution finds the cursor
authenticated, therefore causes a cache load.

The manual says the cursor is cached on the third execution -
but maybe that's the "obvious" result from the simplest test.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 4:34 PM


> Ok, I did a little experiment.  Here are my results:
> 
> In session A, I do:
> I did 'select sid from v$mystat where rownum=1;'
> I did 'alter session set session_cached_cursors=100;'
> I did 'alter system flush shared_pool;'
> 
> In session B, I ran the following:
> select my.statistic#, sn.name, my.value from v$sesstat my, v$statname
sn
>  where sn.statistic#=my.statistic#
>and sn.statistic# in(179,180,191,193)
>and my.sid=62;
> 
> Which yielded the baseline stats:
> STATISTIC# NAME
VALUE
> -- --
--
>179 parse count (total)
60
>180 parse count (hard)
9
>191 session cursor cache hits
6
>193 cursor authentications
6
> 
> Now, session A:
> Select /* this is my unique sql */ * from dual;
> 
> Session B shows:
> STATISTIC# NAME
VALUE
> -- --
--
>179 parse count (total)
62
>180 parse count (hard)
10
>191 session cursor cache hits
6
>193 cursor authentications
6
> 
> Two more total parses, one hard.  (The extra soft parse due to
recursive
> sql?)
> 
> Now, session A:
> /
> (Re-execute query)
> 
> Session B:
> STATISTIC# NAME
VALUE
> -- --
--
>179 parse count (total)
63
>180 parse count (hard)
10
>191 session cursor cache hits
6
>193 cursor authentications
7
> 
> Hmm...no hard parse, soft parse and 'cursor authentication'.
> 
> Session A:
> /
> (execute a third time)
> 
> Session B:
> STATISTIC# NAME
VALUE
> -- --
--
>179 parse count (total)
64
>180 parse count (hard)
10
>191 session cursor cache hits
6
>193 cursor authentications
7
> 
> Hmm...soft parse, NO cursor authentication.  This is just the third
> exec, so no session cursor cache hit, but we should be in the session
> cursor cache now.
> 
> Session A:
> /
> (Fourth execution)
> 
> Session B:
> STATISTIC# NAME
VALUE
> -- --
--
>179 parse count (total)
65
>180 parse count (hard)
10
>191 session cursor cache hits
7
>193 cursor authentications
7
> 
> There's our session cursor cache hit!
> 
> So, it seems that this is happening:
> 
> 1.)  Hard parse.
> 2.)  Soft parse w/ 'cursor authentication'.
> 3.)  Soft parse w/o 'cursor authentication'.
> 4.)  Soft parse w/ session cur

RE: Ideas to workaround view merge being disabled (try #2)

[Jesse, Rich]

And, sorry, Raj, it's apparently *any* function in the view that can cause
the FTS.  I should have mentioned that...

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Thursday, January 08, 2004 11:09 AM
To: Multiple recipients of list ORACLE-L


 stupid KVM hacking my mouse gets me again.  Here's the *whole*
message:


Hey all,

So, there I am on 8.1.7.4.0 creating some SQL suitable for a view:

SELECT
TS.username, 
TS.reportdate, 
TS.hours AS hours, 
DECODE(TD.description, NULL, SC.DESCRIPTION, TD.DESCRIPTION) AS
TASK_DESCRIPTION, 
TEAM.teamtype AS TeamType, 
TS.productline,
ST.SUBTASKID "DEFECTID",
ST.DESCRIPTION "DEFECT_DESCRIPTION"
FROM 
T1 TS,
T2 ST,
T3 TD, 
TEAM , 
T5 SC
WHERE 
TS.TASKID = TD.TASKID (+) AND 
TS.TEAMID = TEAM.TEAMID AND 
TS.WORKORDERNO = SC.WORKORDERNO (+) 
AND TS.operation = SC.OPERATIONNO (+)
AND TS.TASKID = ST.TASKID (+);

Works great, except when the view is created from this SQL because according
to Metalink article 1030221.6, the DECODE function is preventing the view
from being merged, causing an FTS on the T5 (SC) table.  Of course, this
table is near 1M rows and gets caught in an inner NL in the explain plan
(cutting/pasting the explain plan doesn't seem to want to work in Windohs).

The doc says the workaround is to move the DECODE outside the view.  This
won't work for us as the end-user is  MS Access.  Anyone have an idea
other than a RULE hint to get around this?

TIA,
Rich
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OCP Question (Perf Tuning)

[Tanel Poder]

> After the students have scribbled everything down, he then leans forward
and
> quietly whispers to them that in the "real world", heart surgeons actual
> first check whether or not it's actually necessary to cut out the heart
> *beforehand*. He then gives them a little wink and a nod, the students
> usually reply with an "hh" and the class moves on to discuss how
to
> remove blood stains from their white surgical outfits.
>
> IMHO it's all a little scary and a touch surreal and yet it all sounds
> strangely familiar ...

And they don't have too many backups either :(

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Ideas to workaround view merge being disabled.

[Boyle, Christopher J.]

Would using a function to return DECODE(TD.description, NULL, SC.DESCRIPTION, 
TD.DESCRIPTION)  achieve what you are after?  (assuming you can do that in 8.1.7, I am 
not sure)

-Original Message-
Sent: Thursday, January 08, 2004 11:59 AM
To: Multiple recipients of list ORACLE-L

Hey all,

So, there I am on 8.1.7.4.0 creating some SQL suitable for a view:

SELECT
TS.username,
TS.reportdate,
TS.hours AS hours,
DECODE(TD.description, NULL, SC.DESCRIPTION, TD.DESCRIPTION) AS
TASK_DESCRIPTION,
TEAM.teamtype AS TeamType,
TS.productline,
ST.SUBTASKID "DEFECTID",
ST.DESCRIPTION "DEFECT_DESCRIPTION"
FROM
T1 TS,
T2 ST,
T3 TD,
TEAM ,
T5 SC
WHERE
TS.TASKID = TD.TASKID (+) AND
TS.TEAMID = TEAM.TEAMID AND
TS.WORKORDERNO = SC.WORKORDERNO (+)
AND TS.operation = SC.OPERATIONNO (+)
AND TS.TASKID = ST.TASKID (+);

Works great, except when the view is created from this SQL because according
to Metalink article 1030221.6, the DECODE function is preventing the view
from being merged, causing an FTS on the T5 (SC) table.  Of course, this
table is


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boyle, Christopher J.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Ideas to workaround view merge being disabled (try #2)

[Jesse, Rich]

 stupid KVM hacking my mouse gets me again.  Here's the *whole*
message:


Hey all,

So, there I am on 8.1.7.4.0 creating some SQL suitable for a view:

SELECT
TS.username, 
TS.reportdate, 
TS.hours AS hours, 
DECODE(TD.description, NULL, SC.DESCRIPTION, TD.DESCRIPTION) AS
TASK_DESCRIPTION, 
TEAM.teamtype AS TeamType, 
TS.productline,
ST.SUBTASKID "DEFECTID",
ST.DESCRIPTION "DEFECT_DESCRIPTION"
FROM 
T1 TS,
T2 ST,
T3 TD, 
TEAM , 
T5 SC
WHERE 
TS.TASKID = TD.TASKID (+) AND 
TS.TEAMID = TEAM.TEAMID AND 
TS.WORKORDERNO = SC.WORKORDERNO (+) 
AND TS.operation = SC.OPERATIONNO (+)
AND TS.TASKID = ST.TASKID (+);

Works great, except when the view is created from this SQL because according
to Metalink article 1030221.6, the DECODE function is preventing the view
from being merged, causing an FTS on the T5 (SC) table.  Of course, this
table is near 1M rows and gets caught in an inner NL in the explain plan
(cutting/pasting the explain plan doesn't seem to want to work in Windohs).

The doc says the workaround is to move the DECODE outside the view.  This
won't work for us as the end-user is  MS Access.  Anyone have an idea
other than a RULE hint to get around this?

TIA,
Rich
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Ideas to workaround view merge being disabled.

[Jamadagni, Rajendra]

try ...

nvl(TD.description,SC.DESCRIPTION) AS TASK_DESCRIPTION,

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, January 08, 2004 11:59 AM
To: Multiple recipients of list ORACLE-L


Hey all,

So, there I am on 8.1.7.4.0 creating some SQL suitable for a view:

SELECT
TS.username, 
TS.reportdate, 
TS.hours AS hours, 
DECODE(TD.description, NULL, SC.DESCRIPTION, TD.DESCRIPTION) AS
TASK_DESCRIPTION, 
TEAM.teamtype AS TeamType, 
TS.productline,
ST.SUBTASKID "DEFECTID",
ST.DESCRIPTION "DEFECT_DESCRIPTION"
FROM 
T1 TS,
T2 ST,
T3 TD, 
TEAM , 
T5 SC
WHERE 
TS.TASKID = TD.TASKID (+) AND 
TS.TEAMID = TEAM.TEAMID AND 
TS.WORKORDERNO = SC.WORKORDERNO (+) 
AND TS.operation = SC.OPERATIONNO (+)
AND TS.TASKID = ST.TASKID (+);

Works great, except when the view is created from this SQL because according
to Metalink article 1030221.6, the DECODE function is preventing the view
from being merged, causing an FTS on the T5 (SC) table.  Of course, this
table is 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Collaboration Suite Printers

[Brian McGraw]

A question for any of you using Collaboration Suite.

 

I’ve gone through Enterprise Manager, and set up a new
printer for my Files domain.  How is that printer typically used?  I had
ass-u-me-d that once printers were set up, I would have a print option show up
in Oracle Files, and I would be able to send documents to specific printers. 
But that has not been the case so far.  I have searched Metalink for any pertinent
documents, but I have not found any.

 

I guess what I’m asking is this:  If I set up my
printer devices in OEM, what does it do for me?


Brian

 

-
| Brian McGraw  -+-  Senior DBA |
| mailto:[EMAIL PROTECTED]
|
-

 

Ideas to workaround view merge being disabled.

[Jesse, Rich]

Hey all,

So, there I am on 8.1.7.4.0 creating some SQL suitable for a view:

SELECT
TS.username, 
TS.reportdate, 
TS.hours AS hours, 
DECODE(TD.description, NULL, SC.DESCRIPTION, TD.DESCRIPTION) AS
TASK_DESCRIPTION, 
TEAM.teamtype AS TeamType, 
TS.productline,
ST.SUBTASKID "DEFECTID",
ST.DESCRIPTION "DEFECT_DESCRIPTION"
FROM 
T1 TS,
T2 ST,
T3 TD, 
TEAM , 
T5 SC
WHERE 
TS.TASKID = TD.TASKID (+) AND 
TS.TEAMID = TEAM.TEAMID AND 
TS.WORKORDERNO = SC.WORKORDERNO (+) 
AND TS.operation = SC.OPERATIONNO (+)
AND TS.TASKID = ST.TASKID (+);

Works great, except when the view is created from this SQL because according
to Metalink article 1030221.6, the DECODE function is preventing the view
from being merged, causing an FTS on the T5 (SC) table.  Of course, this
table is 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Quest....

[Stephen.Lee]

As far as I know (which isn't real far), spotlight just uses the Oracle
client.

-Original Message-

Has anyone tried to run spotlight on linux with windows crossover software?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Index usage

[Bellow, Bambi]

Am I missing something?  It looks to me like these queries are the same...

-Original Message-
Sent: Thursday, January 08, 2004 9:09 AM
To: Multiple recipients of list ORACLE-L



Hi All,

I have the query like:

SELECT *
FROM tab1
WHERE UPPER(col1) <> 'abc';

Obviously, the function based index i have is not hetting used because of
the ineqality.

When using 
SELECT *
FROM tab1
WHERE UPPER(col1) <> 'abc';

index is getting used.

How can I possibly use index in the 1st case.


Thanks and Regards,
B S Pradhan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bellow, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Should we stop analyzing?

[Jamadagni, Rajendra]

Me thinks CBO is probably never going to be bug free. What works for you, won't work 
for me unless we run identical systems, it is a general purpose system, CBO doesn't 
know your system or data usage. Still it tries to make a better judgment ..

Hey it is a whale lot better than those RDBMS where there are no hints to use in case 
optimizer goes crazy.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, January 08, 2004 11:29 AM
To: Multiple recipients of list ORACLE-L


> 2- the CBO like any other piece of code, is sometimes buggy?

Always, not sometimes

Tanel.

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Quest....

[Paula_Stankus]

I agree.  Spotlight and SQL Navigator interfaces are very straightforward.  While you 
still have to do the analysis and understand the database architecture it makes it 
much easier to gather all the necessary information so that you can concentrate on 
resolving the issue and not on gathering the information.  Also, for the more junior 
DBA's it provides some useful starting point and help to point that person in the 
right direction.  The solutions suggested may not be appropriate all the time.  
However, 

I have found Spotlight straightforward to use for both the Oracle and SQL Server 
environments.  It allows me basically to pinpoint locking issues and performance 
issues and then quickly get to the exact SQL statement involved.  From there I need to 
resolve the issue - suggest rewrite of SQL which I still need to understand the CBO 
for.  However, the research is much much quicker.

SQL Navigator offers team coding library functions, standard formats for stored 
procedures and a straightforward interface for both PL/SQL and SQL - from writing 
stored procedures to verifying and creating database structures.  

Now, I have just started looking into OEM v 9i and have noted that the interface is 
better in this last release and that it has some advantages Spotlight doesn't.  

Hate to say it but I use SQL Nav. for creating PL/SQL and some basic SQL testing.
I use Spotlight for real-time performance issues - as a starting point 
I use OEM for storage, security, schema management
I use the various Oracle traces for more in-depth tuning.

Each of the above has its advantages and do something better than the others.  I want 
to be able to have one tool - however, I have found that these tools do something 
better than others.  

In the SQL Server land I use QE for creating SQL and stored procedures
I use profiler that comes with EM for tracing specific SQL and getting explain plans
I use Spotlight for general overall real-time performance analysis of what is 
happening right now on my system.  

Of course, I still have my own little bag of scripts..Yikes!

-Original Message-
Jesse, Rich
Sent: Thursday, January 08, 2004 11:30 AM
To: Multiple recipients of list ORACLE-L


I'm TOADing and Spotlighting right now...  :)

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Thursday, January 08, 2004 9:54 AM
To: Multiple recipients of list ORACLE-L



I like Spotlight.  It's about the only GUI type thing I use.  It provides a
lot of info in a handy format.  You still have to use your brain to
interpret the info, but you at least have a convenient way of collecting the
info.

-Original Message-

Hey Any thoughts on that quest material? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Suggestions Needed: Latch free - library cache

[Jonathan Lewis]

Excellent !!

I've been demonstrating in the past using v$latch
that the latch costs of parsing are different on 
the first, second, and third parse - and I've assumed
that that's why the cursor goes into the cache on
the third parse.  I've never thought that the
'cursor authentication' statistic might be relevant.

If you go to the other session 
a)  Where the user is the same - do you see a 
session cache cursor hit on the second execution,
or does it still not appear until the fourth
Rationale - maybe the cursor is put into the cache
on the first hit after full authentication.

b)Where the user is different - do you see a
session cache cursor hit on the THIRD execution,
or does it still not appear until the fourth.
Rationale - the first execution generates the in-memory
permissions; the second execution finds the cursor
authenticated, therefore causes a cache load.

The manual says the cursor is cached on the third execution -
but maybe that's the "obvious" result from the simplest test.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 4:34 PM


> Ok, I did a little experiment.  Here are my results:
> 
> In session A, I do:
> I did 'select sid from v$mystat where rownum=1;'
> I did 'alter session set session_cached_cursors=100;'
> I did 'alter system flush shared_pool;'
> 
> In session B, I ran the following:
> select my.statistic#, sn.name, my.value from v$sesstat my, v$statname sn
>  where sn.statistic#=my.statistic#
>and sn.statistic# in(179,180,191,193)
>and my.sid=62;
> 
> Which yielded the baseline stats:
> STATISTIC# NAMEVALUE
> -- -- --
>179 parse count (total)60
>180 parse count (hard)  9
>191 session cursor cache hits   6
>193 cursor authentications  6
> 
> Now, session A:
> Select /* this is my unique sql */ * from dual;
> 
> Session B shows:
> STATISTIC# NAMEVALUE
> -- -- --
>179 parse count (total)62
>180 parse count (hard) 10
>191 session cursor cache hits   6
>193 cursor authentications  6
> 
> Two more total parses, one hard.  (The extra soft parse due to recursive
> sql?)
> 
> Now, session A:
> /
> (Re-execute query)
> 
> Session B:
> STATISTIC# NAMEVALUE
> -- -- --
>179 parse count (total)63
>180 parse count (hard) 10
>191 session cursor cache hits   6
>193 cursor authentications  7
> 
> Hmm...no hard parse, soft parse and 'cursor authentication'.
> 
> Session A:
> /
> (execute a third time)
> 
> Session B:
> STATISTIC# NAMEVALUE
> -- -- --
>179 parse count (total)64
>180 parse count (hard) 10
>191 session cursor cache hits   6
>193 cursor authentications  7
> 
> Hmm...soft parse, NO cursor authentication.  This is just the third
> exec, so no session cursor cache hit, but we should be in the session
> cursor cache now.
> 
> Session A:
> /
> (Fourth execution)
> 
> Session B:
> STATISTIC# NAMEVALUE
> -- -- --
>179 parse count (total)65
>180 parse count (hard) 10
>191 session cursor cache hits 

Re: Quest....

[Jonathan Lewis]

The number of sites I go to that use spotlight 
to keep a check on the top 10 SQL statements -
it's weird, but it always seems to be this query
against v$sqlarea.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 4:29 PM


> I'm TOADing and Spotlighting right now...  :)
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Quest....

[Jamadagni, Rajendra]

Has anyone tried to run spotlight on linux with windows crossover software?

Just curious ... 
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, January 08, 2004 11:30 AM
To: Multiple recipients of list ORACLE-L


I'm TOADing and Spotlighting right now...  :)

Rich
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORA-3113 errors after switching W2K server to new network

[Paul Drake]

Hi Paul,

I'd start with reading Anita Bardeen's paper,
available on the NYOUG site:

http://www.nyoug.org/presentations.htm

ORA-3113's, 600's and 7445's Oh My!

Are these connections local, like on the same subnet,
or is there a firewall or router in between that could
be performing network address translation (NAT)? Could
the translation table now be the source of the
timeout?

We had just the opposite at a site, whereby network
contention was causing ORA-3113s, and after moving the
citrix server farm from fast ethernet to gigabit, the
3113s flat out stopped.

First guess is that the cabling is to blame (works
fine for fast ethernet, has issues for GigE).
Second I'd figure on the new NIC and its driver.
Muck with the settings for the NIC - check diagnostics
for it. What is the server make, who is the network
card manufacturer?

Dell uses Broadcom cards. You can check the cabling
with diagnostics included in the Broadcom Advanced
Control Suite. I haven't used Gigabit cards internally
with Compaq/HP or IBM wintel boxes, so I'm not yet
familiar with their diagnostics. This is SysAdmin
space, get your sysadmin to check it out (unless that
is you).

Oracle on windows couldn't kill an idle session
properly if a support analyst with 10 years experience
tried, so this should not be occurring, as sqlnet
idle_timeout doesn't work in 8.1.7.4 and 9.2.0.4.

this sounds like a good way of killing off the idle
sessions. we had to code a terminator routine to get
this functionality. :)

Paul


--- Paul Vincent <[EMAIL PROTECTED]> wrote:
> Hi everybody,
> 
> one of our Win2K servers, running Oracle 8.1.7, has
> recently been
> switched from the University's old network to our
> shiny new network. All
> the DNS entries have been successfully switched,
> everybody can still
> connect to the databases, and all appeared well.
> Until our users started
> reporting ORA-3113 errors (end of file on
> communiation channel). In
> every case, this happens after the user's connection
> has been inactive
> for somewhat over an hour. There are no messages in
> the database alert
> log, no trace files or dump files in the bdump,
> cdump or udump
> locations, and no messages in the listener log or in
> the sqlnet log. But
> it happens with alarming frequency, and only since
> the switch to the new
> network. The network guy who switched the server to
> the new network says
> the only change was to replace the server's previous
> network card with a
> new gigabit ethernet card. In the absence of any
> kind of server-side
> error messages or trace files, I'm more than
> somewhat stumped. None of
> the possible explanations I've found in MetaLink
> seem to apply in this
> case.
> 
> Has anyone any ideas? Not only possible solutions,
> but ideas for further
> inquiries, or further questions would be welcome!
> 
> Best regards,
> 
> Paul Vincent
> DBA
> University of Central England
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Paul Vincent
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions Needed: Latch free - library cache

[Bobak, Mark]

Ok, I did a little experiment.  Here are my results:

In session A, I do:
I did 'select sid from v$mystat where rownum=1;'
I did 'alter session set session_cached_cursors=100;'
I did 'alter system flush shared_pool;'

In session B, I ran the following:
select my.statistic#, sn.name, my.value from v$sesstat my, v$statname sn
 where sn.statistic#=my.statistic#
   and sn.statistic# in(179,180,191,193)
   and my.sid=62;

Which yielded the baseline stats:
STATISTIC# NAMEVALUE
-- -- --
   179 parse count (total)60
   180 parse count (hard)  9
   191 session cursor cache hits   6
   193 cursor authentications  6

Now, session A:
Select /* this is my unique sql */ * from dual;

Session B shows:
STATISTIC# NAMEVALUE
-- -- --
   179 parse count (total)62
   180 parse count (hard) 10
   191 session cursor cache hits   6
   193 cursor authentications  6

Two more total parses, one hard.  (The extra soft parse due to recursive
sql?)

Now, session A:
/
(Re-execute query)

Session B:
STATISTIC# NAMEVALUE
-- -- --
   179 parse count (total)63
   180 parse count (hard) 10
   191 session cursor cache hits   6
   193 cursor authentications  7

Hmm...no hard parse, soft parse and 'cursor authentication'.

Session A:
/
(execute a third time)

Session B:
STATISTIC# NAMEVALUE
-- -- --
   179 parse count (total)64
   180 parse count (hard) 10
   191 session cursor cache hits   6
   193 cursor authentications  7

Hmm...soft parse, NO cursor authentication.  This is just the third
exec, so no session cursor cache hit, but we should be in the session
cursor cache now.

Session A:
/
(Fourth execution)

Session B:
STATISTIC# NAMEVALUE
-- -- --
   179 parse count (total)65
   180 parse count (hard) 10
   191 session cursor cache hits   7
   193 cursor authentications  7

There's our session cursor cache hit!

So, it seems that this is happening:

1.)  Hard parse.
2.)  Soft parse w/ 'cursor authentication'.
3.)  Soft parse w/o 'cursor authentication'.
4.)  Soft parse w/ session cursor cache hit.
All subsequent executions are same as #4.

Two more quick tests:
I tried connecting another session, as the same user, and there was no
'cursor authentication'.  So, I tried ano connection as a *different*
user, and, voila!, cursor authentication was done on the first
execution!

So, I'll think about this a bit more, but I think one can distinguish
between all the cases you mentioned.  What do you think, Jonathan?

-Mark


Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Thursday, January 08, 2004 10:10 AM
To: Multiple recipients of list ORACLE-L


Jonathan,

At least the last case you mention is accounted for by the 'session
cache cursor hits' statistic.  And, though it's not entirely clear to
me, based on the description in the Reference manual, it seems to me
that the 'cursor authentications' statistic may reflect the second case
in your list?

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Thursday, January 08, 2004 4:54 AM
To: Multiple recipients of list ORACLE-L



There's a failure in the statistics at this point.
As far as I can tell, there are at least four different
reasons why the stats can report a
parse count (total)
without recording a
parse count (hard)
and it would be nice 

RE: Quest....

[Jesse, Rich]

I'm TOADing and Spotlighting right now...  :)

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Thursday, January 08, 2004 9:54 AM
To: Multiple recipients of list ORACLE-L



I like Spotlight.  It's about the only GUI type thing I use.  It provides a
lot of info in a handy format.  You still have to use your brain to
interpret the info, but you at least have a convenient way of collecting the
info.

-Original Message-

Hey Any thoughts on that quest material? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Should we stop analyzing?

[Tanel Poder]

> 2- the CBO like any other piece of code, is sometimes buggy?

Always, not sometimes

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-3113 errors after switching W2K server to new network

[Tim Onions]

Paul

Sounds suspiciously like an issue we had when se set up our latest system -
something in the firewall or network set-up has a TCP time-out in it. TCP
(or the network or something I'm no network expert) drops the connection
after 60 minutes resulting in client and Oracle server no longer being able
to talk to each other (3113 etc). We get no logs either.

Sorry I can't actually help here but this error we see is nothing to do with
Oracle, Net8 etc and everything to do with the network/firewall. We have not
solved it yet but luckily our software is configurable and can
disconnect/reconnect every 30 minutes so does not fall fowl of the issue.

T¬
_
Tim Onions
Head of Oracle Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider
Tel: +44.1684.312364
http://www.speechmachines.com



-Original Message-
Sent: 08 January 2004 15:39
To: Multiple recipients of list ORACLE-L


Hi everybody,

one of our Win2K servers, running Oracle 8.1.7, has recently been
switched from the University's old network to our shiny new network. All
the DNS entries have been successfully switched, everybody can still
connect to the databases, and all appeared well. Until our users started
reporting ORA-3113 errors (end of file on communiation channel). In
every case, this happens after the user's connection has been inactive
for somewhat over an hour. There are no messages in the database alert
log, no trace files or dump files in the bdump, cdump or udump
locations, and no messages in the listener log or in the sqlnet log. But
it happens with alarming frequency, and only since the switch to the new
network. The network guy who switched the server to the new network says
the only change was to replace the server's previous network card with a
new gigabit ethernet card. In the absence of any kind of server-side
error messages or trace files, I'm more than somewhat stumped. None of
the possible explanations I've found in MetaLink seem to apply in this
case.

Has anyone any ideas? Not only possible solutions, but ideas for further
inquiries, or further questions would be welcome!

Best regards,

Paul Vincent
DBA
University of Central England
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Vincent
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Onions
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OSUSER v 9.2.0.2 on linux

[Norris, Gregory T [ITS]]

You should be aware that Oracle relies on the client providing this information, so it 
isn't always available.  In particular, the JDBC thin driver tends to always use 
"__jdbc__".

-Original Message-
Lisa R. Clary
Sent: Wednesday, January 07, 2004 3:05 PM
To: Multiple recipients of list ORACLE-L


Wow---I guess I have been missing out quite a bit going from 7.3.4 to 9i.
Thanks to Tanel & Mladen!  I didn't know it was that easy!

lc

-Original Message-
Mladen Gogala
Sent: Wednesday, January 07, 2004 3:45 PM
To: Multiple recipients of list ORACLE-L


select sys_context('USERENV','OS_USER') from dual;

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Norris, Gregory T [ITS]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA tasks

[Boivin, Patrice J]

That was funny.

Thanks, I needed that.

: )

Another funny thread might be silly instance names people use for
development databases, but then oops!  The database is now production.

Patrice

-Original Message-
Sent: January 8, 2004 9:34 AM
To: Multiple recipients of list ORACLE-L


I had one like that:
I created a database under our 7.1.6, because "We need an Oracle database
for development." "When?" "Yesterday!"
I gave them usernames and passwords and made sure that TNSNAMES was
configured.
In monitoring a few weeks later, I noticed no activity, so I asked them,
"That database you wanted right away isn't being used, is there a problem."
"No problem, we just had a delay, we're going to be starting any day now."
Two years later, I was upgrading some databases to 8.  The database had
still not been used, other than a few objects created.  "Should I upgrade
this database?", I asked.  "Oh no, don't bother, we're not using it."  "Can
I delete it?" "No, please keep it around.  We're going to need it anytime
now."
A year later, I backed it up with export to tape, in case I ever wanted it
back, and deleted it (along with Oracle home for 7.1.6).  Five years later,
I don't think anyone ever noticed that it was gone.  The tape is in a drawer
somewhere.
Most troublefree database I've ever had.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: seperate external procedure listeners for different SIDs

[Goulet, Dick]

John,

I agree if you have multiple databases under the same home all is well, one 
extproc sid will do.  But if you have several different Oracle homes, with different 
versions of Oracle then each needs it's own extproc sid.  Tried using the latest 
listener and/or extproc combinations, didn't work.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Thursday, January 08, 2004 10:44 AM
To: Multiple recipients of list ORACLE-L


Thanks - I wasn't sure if each session got its own instance of extproc.  The SID 
associated with an EXTPROC is not the same as a SID associated with a database.  I 
have several databases running under the same Oracle Home, and they are sharing the 
same external procedure listener - which references that Oracle Home.  If you are 
running databases under several versions of Oracle, you may be able to use the 
listener for the latest version of Oracle you have to listen for all of them, and use 
its extproc.  But it is probably a better idea to run separate listeners for databases 
and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own 
Oracle Home.  Just be careful about how the TNS administration directory is set.

-Original Message-
Sent: Thursday, January 08, 2004 9:54 AM
To: Multiple recipients of list ORACLE-L


John,

On the contrary.  You do need to associate an EXTPROC with a particular SID 
otherwise running different versions of Oracle on the same box blows the EXTPROC to 
hell.  You'll notice that in listener.ora there needs to be a line "SID_NAME=" and in 
TNSNAMES.ora there is a "Connect_data = (sid = " as well.  Now a particular database 
instance/version can only have one extproc_connect_data entry, but with multiple 
versions each has it's own, and sure enough each has to have a particular sid 
otherwise they mess each other up.

BTW: Your description of the process is dead on, with one exception.  An 
instance of extproc is connected to one and only one session in the calling database.  
If two sessions each need to call an external procedure then each gets it's own 
instance of extproc.  Also if you need to update the dll or so file you have to get 
everyone to let go of extproc, namely by disconnecting from the database.  Although 
it's like a database link, closing the links does not release extproc.  Also using TCP 
to connect to extproc is not an Oracle recommended method, opens a door to hackers.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Flack
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Quest....

[Stephen.Lee]

I like Spotlight.  It's about the only GUI type thing I use.  It provides a
lot of info in a handy format.  You still have to use your brain to
interpret the info, but you at least have a convenient way of collecting the
info.

-Original Message-

Hey Any thoughts on that quest material? 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: seperate external procedure listeners for different SIDs

[John Flack]

Thanks - I wasn't sure if each session got its own instance of extproc.  The SID 
associated with an EXTPROC is not the same as a SID associated with a database.  I 
have several databases running under the same Oracle Home, and they are sharing the 
same external procedure listener - which references that Oracle Home.  If you are 
running databases under several versions of Oracle, you may be able to use the 
listener for the latest version of Oracle you have to listen for all of them, and use 
its extproc.  But it is probably a better idea to run separate listeners for databases 
and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own 
Oracle Home.  Just be careful about how the TNS administration directory is set.

-Original Message-
Sent: Thursday, January 08, 2004 9:54 AM
To: Multiple recipients of list ORACLE-L


John,

On the contrary.  You do need to associate an EXTPROC with a particular SID 
otherwise running different versions of Oracle on the same box blows the EXTPROC to 
hell.  You'll notice that in listener.ora there needs to be a line "SID_NAME=" and in 
TNSNAMES.ora there is a "Connect_data = (sid = " as well.  Now a particular database 
instance/version can only have one extproc_connect_data entry, but with multiple 
versions each has it's own, and sure enough each has to have a particular sid 
otherwise they mess each other up.

BTW: Your description of the process is dead on, with one exception.  An 
instance of extproc is connected to one and only one session in the calling database.  
If two sessions each need to call an external procedure then each gets it's own 
instance of extproc.  Also if you need to update the dll or so file you have to get 
everyone to let go of extproc, namely by disconnecting from the database.  Although 
it's like a database link, closing the links does not release extproc.  Also using TCP 
to connect to extproc is not an Oracle recommended method, opens a door to hackers.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Flack
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-3113 errors after switching W2K server to new network

[Paul Vincent]

Hi everybody,

one of our Win2K servers, running Oracle 8.1.7, has recently been
switched from the University's old network to our shiny new network. All
the DNS entries have been successfully switched, everybody can still
connect to the databases, and all appeared well. Until our users started
reporting ORA-3113 errors (end of file on communiation channel). In
every case, this happens after the user's connection has been inactive
for somewhat over an hour. There are no messages in the database alert
log, no trace files or dump files in the bdump, cdump or udump
locations, and no messages in the listener log or in the sqlnet log. But
it happens with alarming frequency, and only since the switch to the new
network. The network guy who switched the server to the new network says
the only change was to replace the server's previous network card with a
new gigabit ethernet card. In the absence of any kind of server-side
error messages or trace files, I'm more than somewhat stumped. None of
the possible explanations I've found in MetaLink seem to apply in this
case.

Has anyone any ideas? Not only possible solutions, but ideas for further
inquiries, or further questions would be welcome!

Best regards,

Paul Vincent
DBA
University of Central England
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Vincent
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Index usage

[zions swordfish]

hi, pradhan,I don't see any kind of differences with your two queries, butI suggest you to use hint in your query to activate index.Regards,Sony

- Original Message -



DATE: Thu, 08 Jan 2004 07:09:26

From: "bhabani s pradhan" <[EMAIL PROTECTED]>

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

Cc: 
Hi All,I have the query like:SELECT *FROM tab1WHERE UPPER(col1) <> 'abc';Obviously, the function based index i have is not hetting used because of the ineqality.When using SELECT *FROM tab1WHERE UPPER(col1) <> 'abc';index is getting used.How can I possibly use index in the 1st case.Thanks and Regards,B S Pradhan Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos Mail

RE: seperate external procedure listeners for different SIDs

[John Flack]

That's pretty much it, at least through Oracle 8.1.7 (what I'm using).  This is mostly 
because Oracle only uses one service name to make the connection, 
EXTPROC_CONNECTION_DATA, and TNSNAMES can only associate that service name with one 
IPC key.  Therefore you can only talk to the one listener that is listening for that 
IPC key.  You could start a second listener listening on another IPC key, but only the 
one referenced in TNSNAMES would ever be used.

Which brings to mind a possible work around - if you can get a different database to 
use a different TNSNAMES.ORA file to resolve service names, you might get this to work 
- maybe by setting the TNS_ADMIN environment variable to a different value before you 
bring up the database.  I haven't tried it, though, so no promises.

If you are using a later version of Oracle, however, read the docs carefully.  Seems 
to me that if they have made it possible to connect to remote external procedure 
handlers through TCP/IP - 8.1.7 REQUIRES a local handler using IPC, they may have made 
a way to control the service name it uses so you can choose which external procedure 
handler to use.  The key docs for external procedures are the Application Programmers 
Guide, the PL/SQL Guide, and the Server Guide, plus a few Technical Notes in MetaLink.

-Original Message-
Sent: Thursday, January 08, 2004 9:39 AM
To: Multiple recipients of list ORACLE-L


Hmm...so if for some reason I needed two external procedure listeners to
run, (because, for example I wanted them to run as 2 different application
users rather than oracle or use 2 different sets of .so files), I could not
do it?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Flack
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions Needed: Latch free - library cache

[Bobak, Mark]

Jonathan,

At least the last case you mention is accounted for by the 'session
cache cursor hits' statistic.  And, though it's not entirely clear to
me, based on the description in the Reference manual, it seems to me
that the 'cursor authentications' statistic may reflect the second case
in your list?

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Thursday, January 08, 2004 4:54 AM
To: Multiple recipients of list ORACLE-L



There's a failure in the statistics at this point.
As far as I can tell, there are at least four different
reasons why the stats can report a
parse count (total)
without recording a
parse count (hard)
and it would be nice if we could see them as four
different statistics.

Code that explicit holds a cursor open need
not issue a parse call at all.

Code that issues a parse call may:
Invoke the whole parse/optimize cycle
Invoke a permissions cycle on an existing statement
Invoke a search and execute cycle on an existing statement with
valid
permission
Invoke a 'this is where it is and I know I've got permission, so
just do
it' cycle

The last option can appear when you set up
session_cached_cursors != 0.

The front-end code is still issuing an explicit parse call,
which is why you see the parse count go up, but the
work done is kept to near minimum.


NOTE: This description is probably not complete
and I'd welcome any corrections and refinements
that anyone can supply.



Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 1:34 AM


> if your caching the cursors, why does soft parsing still happen?
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 07, 2004 7:24 PM
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).