date:20031006

Good evening dear sir from down under (It's 22:07, here in Connecticut).
Yes, it is safe to do. The only case when you do have to be careful is when
the table you want to take for a ride into another tablespace is an index  
organized table and is being used. Then, you have to specify "online" option.
I was moving aound indexes, tables and partitions, without any problems. I
even moved a SYS table (AUD$) into another tablespace. No problem whatsoever.
On 2003.10.06 22:34, "Kaing, Leng" wrote:
Good morning, everyone,

> Env: Oracle 8.1.7.4, Sun 5.8
>
> We have a master table with a FREST REFRESH based on PRIMARY KEY. We would
like to rebuild the master table, snapshot log and snapshot to reclaim  
space.
There is no advanced replication involved. It is simply a snapshot (or
materialized view) that's refreshed at certain intervals from a dbms_job.
>
> We'd like to know whether we can safely rebuild the tables using the ALTER
TABLE MOVE command as such:
>
> 1) stop all client connects, and DBMS_JOBS on master and destination site
> 2) issue another refresh of snapshot so that the MLOG$ table is cleared.
> 3) on master site, issue the command: ALTER TABLE  MOVE
TABLESPACE  NOLOGGING;
> 4) on master site, issue the command: ALTER TABLE MLOG$_ MOVE
TABLESPACE  NOLOGGING;
> 5) on the destination site, issue the command: ALTER TABLE   
MOVE
TABLESPACE  NOLOGGING;
> 6) reenable DBMS_JOBS and client connections
>
Have you done it before? Is it safe to do?

TIA,

Leng.

> --
> Leng Kaing
> Email: [EMAIL PROTECTED]
> Phone: +61-3-9203-7589
> Mobile: +61-417-371-348
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kaing, Leng
  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).
--
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: FW: Oracle Performance Software from Veritas

WE!? Do you also happen to work for Veritas? Wow!
Veritas then, already is a superpower and a major
force to be reckoned with. The only thing you need to do
to achieve the total Oracle World Domination is to...
acquire me :)
On 2003.10.06 21:59, Gaja Krishna Vaidyanatha wrote:
Mladen,

Anjo quit Oracle and joined Precise Software in
November/December timeframe of 2001. When Veritas
acquired Precise this year, he became a "veritable
Veritas employee"...;-)
So your conclusion is 100% accurate - Veritas is a
very serious contender in the Oracle Performance
Solutions market. Combine that with the wealth of
storage management solutions and we have a unique
position in the marketplace.
Cheers,

Gaja

--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> Well, they've just acquired OraPerf. I don't know
> whether Anjo Kolk
> is now a veritable Veritas employee, but if he is,
> then Veritas is
> a very serious contender in oracle performance
> tools/consulting market.
> If they acquire hotsos, everybody else, including
> Quest, is done for.
>
> On Mon, 2003-10-06 at 16:59, David Wagoner wrote:
> > Just got this email from Veritas...apparently they
> are getting into
> > the database performance business for Oracle (and
> SQL Server too I
> > think).
> >
> >
> > Best regards,
> >
> > David B. Wagoner
> > Database Administrator
> > Arsenal Digital Solutions
> > "the most trusted source for
> > STORAGE MANAGEMENT SERVICES"
> >
> >
> > The contents of this e-mail message may be
> privileged and/or
> > confidential. If you are not the intended
> recipient, any review,
> > dissemination, copying, distribution or other use
> of the contents of
> > this message or any attachment by you is strictly
> prohibited. If you
> > receive this communication in error, please notify
> us immediately by
> > return e-mail or by telephone (919-466-6700), and
> please delete this
> > message and all attachments from your system.
> > Thank you.
> >
> > -Original Message-
> > From: VERITAS Software [mailto:[EMAIL PROTECTED]
> > Sent: Monday, October 06, 2003 3:40 PM
> > To: David Wagoner
> > Subject: Trial Software for Oracle environment
> >
> >
> >
>
> >
>
> >
>
> >
>
> >
> [image]
> >
>
> >
> [image]
> >
>
> >
> [image]
> >
> [image]
> >
> [image]
> >
>
> >
>
> >
> [image]
> >
>
> >
>
> >
> Do
> >
> something
> >  about
> it.
> >
>
> >
> Download a
> >  free
> trial
> >  of
> VERITAS
> >Indepth(tm) for
> Oracle.
> >
>
> >
> Easier
> >  said
> than
> >
> done.
> >
> Usually
> >
> it's
> >
> difficult,
> > if
> not
> > impossible, to pinpoint the root cause of
> performance slowdowns. Countless hours are spent
> troubleshooting and analyzing applications with few
> results to show for it.
> >
>
> >
> That's
> >
> about to
> >
> change.
> >
> With
> >
> VERITAS
> >
> Indepth
> >
> for
> >
> Oracle,
> >you
> can
> >
> identify
> >
> specific
> > application bottlenecks, resolve them faster, and
> maintain promised service levels to users.
> >
>
> >
> Download
> >
> VERITAS
> >
> Indepth
> >  for
> Oracle
> >  to
> see how
> >   you
> can:
> >
>
> >   * Monitor the Oracle environment
> continuously and capture performance data for
> current, short term, and long-term performance
> analysis.
> >   * Drill down and identify a performance
> problem caused by a resource bottleneck or a poorly
> written SQL statement.
> >   * Resolve performance problems faster with
> detailed steps and displays statistics relevant to
> each step in the Oracle access path.
> >
> Download
> >
> Now
> >
>
> >
>
> >
>
> >
> [image]
> >
> [image]
> >
>
> >
> [image]
> >
>
> >
> [image]
> >
> [image]
> >
>
> >
> [image]
> >
> [image]
> >
>
> >
> [image]
>
=== message truncated ===
=
Gaja Krishna Vaidyanatha
Principal Technical Product Manager,
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
  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: U

Rebuilding/Moving master table, snapshot log and snapshot

2003-10-06 Thread Kaing, Leng

Good morning, everyone,

> Env: Oracle 8.1.7.4, Sun 5.8
> 
> We have a master table with a FREST REFRESH based on PRIMARY KEY. We would like to 
> rebuild the master table, snapshot log and snapshot to reclaim space. There is no 
> advanced replication involved. It is simply a snapshot (or materialized view) that's 
> refreshed at certain intervals from a dbms_job.
> 
> We'd like to know whether we can safely rebuild the tables using the ALTER TABLE 
> MOVE command as such:
> 
> 1) stop all client connects, and DBMS_JOBS on master and destination site
> 2) issue another refresh of snapshot so that the MLOG$ table is cleared.
> 3) on master site, issue the command: ALTER TABLE  MOVE TABLESPACE  tablespace> NOLOGGING;
> 4) on master site, issue the command: ALTER TABLE MLOG$_ MOVE TABLESPACE 
>  NOLOGGING;
> 5) on the destination site, issue the command: ALTER TABLE  MOVE 
> TABLESPACE  NOLOGGING;
> 6) reenable DBMS_JOBS and client connections
> 
Have you done it before? Is it safe to do? 

TIA,

Leng.

> --
> Leng Kaing
> Email: [EMAIL PROTECTED]
> Phone: +61-3-9203-7589
> Mobile: +61-417-371-348
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kaing, Leng
  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).

Populating BLOB's from a SQL Script?

2003-10-06 Thread Mark Richard


Hi List,

I have been asked to look into the possibility of populating a BLOB column
(Oracle 8i currently) using an SQL Script.  All the examples I've ever seen
involve reading the blob from a file and inserting it directly to the table
though.

The reasoning behind this is the desire to deliver a single script which
loads perhaps 50 images into a table.  Performance isn't a problem, neither
is the size of the script.

Does anyone know of a way to do this?  It is safe to assume the data
already exists in a table if that helps to create the script.  I was
thinking perhaps a "rawtohex" type function may convert the binary data
into something that can exist within a script.  Am I on the right track?

Regards,
  Mark.

<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>




<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply 
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail 
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the 
official business of Transurban Infrastructure Developments Limited and CityLink 
Melbourne Limited shall be understood as neither given nor endorsed by them.
<<>>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Richard
  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: FW: Oracle Performance Software from Veritas

2003-10-06 Thread Gaja Krishna Vaidyanatha

Mladen,

Anjo quit Oracle and joined Precise Software in
November/December timeframe of 2001. When Veritas
acquired Precise this year, he became a "veritable
Veritas employee"...;-)

So your conclusion is 100% accurate - Veritas is a
very serious contender in the Oracle Performance
Solutions market. Combine that with the wealth of
storage management solutions and we have a unique
position in the marketplace.

Cheers,

Gaja

--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> Well, they've just acquired OraPerf. I don't know
> whether Anjo Kolk
> is now a veritable Veritas employee, but if he is,
> then Veritas is
> a very serious contender in oracle performance
> tools/consulting market.
> If they acquire hotsos, everybody else, including
> Quest, is done for.
> 
> On Mon, 2003-10-06 at 16:59, David Wagoner wrote:
> > Just got this email from Veritas...apparently they
> are getting into
> > the database performance business for Oracle (and
> SQL Server too I
> > think).
> >  
> > 
> > Best regards,
> > 
> > David B. Wagoner
> > Database Administrator
> > Arsenal Digital Solutions
> > "the most trusted source for
> > STORAGE MANAGEMENT SERVICES"
> > 
> > 
> > The contents of this e-mail message may be
> privileged and/or
> > confidential. If you are not the intended
> recipient, any review,
> > dissemination, copying, distribution or other use
> of the contents of
> > this message or any attachment by you is strictly
> prohibited. If you
> > receive this communication in error, please notify
> us immediately by
> > return e-mail or by telephone (919-466-6700), and
> please delete this
> > message and all attachments from your system.
> > Thank you.
> > 
> > -Original Message-
> > From: VERITAS Software [mailto:[EMAIL PROTECTED]
> > Sent: Monday, October 06, 2003 3:40 PM
> > To: David Wagoner
> > Subject: Trial Software for Oracle environment
> > 
> > 
> >   
>  
> >   
>  
> >   
>  
> >   
>  
> >   
> [image]
> >   
>  
> >   
> [image]
> >   
>
> >   
> [image]
> >   
> [image]
> >   
> [image]
> >   
>  
> >   
>  
> >   
> [image]
> >   
>  
> >   
>  
> >   
> Do
> > 
> something
> >  about
> it.
> >   
>  
> > 
> Download a
> >  free
> trial
> >  of
> VERITAS
> >Indepth(tm) for
> Oracle.
> >   
>  
> >
> Easier
> >  said
> than
> >
> done.
> >   
> Usually
> > 
> it's
> > 
> difficult,
> > if
> not
> > impossible, to pinpoint the root cause of
> performance slowdowns. Countless hours are spent
> troubleshooting and analyzing applications with few
> results to show for it.
> >   
>  
> >
> That's
> >  
> about to
> >   
> change.
> > 
> With
> >   
> VERITAS
> >   
> Indepth
> >  
> for
> >   
> Oracle,
> >you
> can
> >  
> identify
> >  
> specific
> > application bottlenecks, resolve them faster, and
> maintain promised service levels to users.
> >   
>  
> >  
> Download
> >

Re: FW: Oracle Performance Software from Veritas

2003-10-06 Thread Gaja Krishna Vaidyanatha

Hey dude,

Thanks for that, although, I don't want to be tagged
as a "spammer"...;-).

Cheers,

Gaja

--- [EMAIL PROTECTED] wrote:
> Our good friend Gaja Vaidyanatha is now with
> Veritas,
> so this isn't really too surprising.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
> David Wagoner <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/06/2003 01:59 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:FW: Oracle Performance
> Software from Veritas
> 
> 
> Just got this email from Veritas...apparently they
> are getting into the 
> database performance business for Oracle (and SQL
> Server too I think).
>  
> Best regards, 
> David B. Wagoner 
> Database Administrator 
> Arsenal Digital Solutions 
> "the most trusted source for 
> STORAGE MANAGEMENT SERVICES" 
> 
> The contents of this e-mail message may be
> privileged and/or confidential. 
> If you are not the intended recipient, any review,
> dissemination, copying, 
> distribution or other use of the contents of this
> message or any 
> attachment by you is strictly prohibited. If you
> receive this 
> communication in error, please notify us immediately
> by return e-mail or 
> by telephone (919-466-6700), and please delete this
> message and all 
> attachments from your system.
> Thank you. 
> -Original Message-
> Sent: Monday, October 06, 2003 3:40 PM
> To: David Wagoner
> 
> 
>  
>  
>  
>  
> 
>  
> 
>  
> 
> 
> 
>  
>  
> 
> 
> Do something about it.
> Download a free trial of VERITAS Indepth(tm) for
> Oracle.
> Easier said than done. Usually it's difficult, if
> not impossible, to 
> pinpoint the root cause of performance slowdowns.
> Countless hours are 
> spent troubleshooting and analyzing applications
> with few results to show 
> for it.
> That's about to change. With VERITAS Indepth for
> Oracle, you can identify specific application 
> bottlenecks, resolve them faster, and maintain
> promised service levels to 
> users.
> Download VERITAS Indepth for Oracle to see how you
> can:
> Monitor the Oracle environment continuously and
> capture performance data for 
> current, short term, and long-term performance
> analysis. 
> Drill down and identify a performance problem caused
> by a resource bottleneck or a poorly written 
> SQL statement. 
> Resolve performance problems faster with detailed
> steps and displays statistics relevant to each step 
> in the Oracle access path. 
> Download Now
>  
>  
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  
> 
> 
> Why we contacted you and how to opt-out:
> We know your time is valuable and that we (and
> others) are placing 
> increasing demands on it. We contacted you about
> this news because we 
> believe that the content of this message would be
> interesting and valuable 
> to you.
> If you do not wish to receive future VERITAS
> notifications, please click 
> on the link below, and send us the e-mail:
>
mailto:[EMAIL PROTECTED]
> 
> Please review our online Privacy Policy and Terms of
> Use.
> © Copyright 2003 VERITAS Software. All rights
> reserved. 
> VERITAS Software, 350 Ellis Street, Mountain View,
> CA 94043, United 
> States.
> We welcome your comments. Send email to
> [EMAIL PROTECTED]
> 
> 
>  
>  
> 
> 
> > The previous attachment was filtered out by the
> ListGuru mailing
> software at fatcity.com because binary attachments
> are not appropriate
> for mailing lists.  If you want a copy of the
> attachment which was
> removed, contact the sender directly and ask for it
> to be sent to
> you by private E-mail.
> 
> This warning is inserted into all messages
> containing binary
> attachments which have been removed by ListGuru.  If
> you have questions
> about this message, contact [EMAIL PROTECTED]
> for clarification.
> > The previous attachment was filtered out by the
> ListGuru mailing
> software at fatcity.com because binary attachments
> are not appropriate
> for mailing lists.  If you want a copy of the
> attachment which was
> removed, contact the sender directly and ask for it
> to be sent to
> you by private E-mail.
> 
> This warning is inserted into all messages
> containing binary
> attachments which have been removed by ListGuru.  If
> you have questions
> about this message, contact [EMAIL PROTECTED]
> for clarification.
> > The previous attachment was filtered out by the
> ListGuru mailing
> software at fatcity.com because binary attachments
> are not appropriate
> for mailing lists.  If you want a copy of the
> attachment which was
> removed, contact the sender directly and ask for it
> to be sent to
> you by private E-mail.
> 
> This warning is inserted into all messages
> containing binary
> attachments which have been removed by ListGuru.  If
> you have questions
> about this message, contact [EMAIL PROTECTED]
> for clarification.
> > The previous attachment was filtered out by the
> ListGuru mailing
> software at fatcity.com because binary attachments
> are not appro

RE: QUIESCING - Waiting for 1 hr - Solved

2003-10-06 Thread quriyat

 
Hi list I had done dbms_defer_sys.set_disabled('MASTER_SITE',TRUE);  I just set it to FALSE and repeated the command and now the group is quiesced. Thx--- On Mon 10/06, quriyat < [EMAIL PROTECTED] > wrote:
From: quriyat [mailto: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Date: Mon, 06 Oct 2003 16:19:26 -0800Subject: QUIESCING - Waiting for 1 hr




I didSQL> begin2 DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY('MY_GRP');3 end;4 /PL/SQL procedure successfully completed.
SQL> SELECT GNAME, STATUS FROM DBA_REPGROUP;GNAME STATUS-- -MY_GRP QUIESCINGSQL> /
It is one hour but still Quiescing. Any ideas?
Thx


No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com
No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com

RE: QUIESCING - Waiting for 1 hr

2003-10-06 Thread quriyat

 
Hi list I had done dbms_defer_sys.set_disabled('MASTER_SITE',TRUE);  I just set it to FALSE and repeated the command and now the group is quiesced. Thx--- On Mon 10/06, quriyat < [EMAIL PROTECTED] > wrote:
From: quriyat [mailto: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Date: Mon, 06 Oct 2003 16:19:26 -0800Subject: QUIESCING - Waiting for 1 hr




I didSQL> begin2 DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY('MY_GRP');3 end;4 /PL/SQL procedure successfully completed.
SQL> SELECT GNAME, STATUS FROM DBA_REPGROUP;GNAME STATUS-- -MY_GRP QUIESCINGSQL> /
It is one hour but still Quiescing. Any ideas?
Thx


No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com
No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com

RE: Oracle analog to xp_fixeddrives

2003-10-06 Thread Josh Collier

9i has this functionality in dbms_storage_map

-Original Message-
Sent: Monday, October 06, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


Hi Everyone!

I recently read an article about a SQL-Server stored procedure called 
'xp_fixeddrives'.  What it does is return a structure to the database user
that contains relevant information about specific disks.  I was wondering 
if anyone has ever seen, dreamed about, written, borrowed, bought or
stolen a utility like this for Oracle.  I know it's easier for SQL-Server
because it's only gotta work on one platform, where Oracle is much broader,
but I could sure imagine some usefulness around that sort of thing.

Curious,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  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: Josh Collier
  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).

QUIESCING - Waiting for 1 hr

2003-10-06 Thread quriyat

 I didSQL> begin  2  DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY('MY_GRP');  3  end;  4  /PL/SQL procedure successfully completed.
SQL> SELECT GNAME, STATUS FROM DBA_REPGROUP;GNAME  STATUS-- -MY_GRPQUIESCINGSQL> /
It is one hour but still Quiescing. Any ideas?
ThxNo banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com

RE: sid/serial# vs. audsid: why both?

Thank you John. I guess I can revise my question, then, to say "Why not use 
SID/SERIAL# all the time?" :)
I suppose there are reasons but it seems unnecessary to have two sets of values that 
uniquely identify a session. Though of course, from the documentation, AUDSID is 
unique over the lifetime of the database (generated from sequence SYS.AUDSES$) and 
SID/SERIAL# would not be unique over the lifetime of the database.

> -Original Message-
> John Kanagaraj
> Sent: lundi, 6. octobre 2003 15:59
> 
> >In what cases does the SERIAL# need to be used? Can someone 
> give an example
> where a session-level command would be 
> >applied to an incorrect session object if SERIAL# were not available?
> 
> For backward compatibility reasons :) Looks like AUDSID 
> wasn't generated 7.2
> and prior unless AUDIT_TRAIL was TRUE (even if you don't use 
> auditing). A
> lot of scripts use SERIAL# and the ALTER SYSTEM KILL SESSION uses the
> serial#, which should always be available.
> 
> >Why not use AUDSID all the time? Is there a reason why the 
> database keeps
> track of two session identifying numbers?
> 
> AUDSID is 0 if connecting as internal. Notes 123128.1 and 
> 122230.1 may help!
-- 
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).

Oracle analog to xp_fixeddrives

2003-10-06 Thread Vergara, Michael (TEM)

Hi Everyone!

I recently read an article about a SQL-Server stored procedure called 
'xp_fixeddrives'.  What it does is return a structure to the database user
that contains relevant information about specific disks.  I was wondering 
if anyone has ever seen, dreamed about, written, borrowed, bought or
stolen a utility like this for Oracle.  I know it's easier for SQL-Server
because it's only gotta work on one platform, where Oracle is much broader,
but I could sure imagine some usefulness around that sort of thing.

Curious,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  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 7.3 & 8 upgrade to 9i

Thanks, didn't know this was available.

Ora NT DBA <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 02:54 PM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: OCP 7.3 & 8 upgrade to 9i

Hi All,

>From the Oracle Education Certification Page:

http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html

Shows 4 possible tests:
Oracle9i DBA OCP Upgrade Path
Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs.
In order to make the process of staying current as an Oracle Certified technical professional, those already certified on previous releases of Oracle may upgrade to each future release by simply completing one migration exam. Listed below are the migration exams that are currently available to previously certified Oracle DBAs.
Please review the listings below for more specific information. Generally, one exam is required for OCPs to upgrade to each new release of an Oracle DBA track. For example, one exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to Oracle9i.
Oracle7.3 and Oracle8 DBA OCPs now have another option to upgrade their DBA OCP credential directly to Oracle9i: Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs. This exam will be available beginning October 2003.
Select the exam title below to view the exam objectives.

Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i
Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs
Available October 2003
Upgrade Exam: Oracle7.3 to Oracle8 DBA OCP
Exam #1Z0-010 Oracle8 New Features for Administrators
Upgrade Exam: Oracle8 to Oracle8i DBA OCP
Exam #1Z0-020 Oracle8i New Features for Administrators
Upgrade Exam: Oracle8i to Oracle9i DBA OCP
Exam #1Z0-030 Oracle9i Database: New Features for Administrators
Hope this helps,
John

[EMAIL PROTECTED] wrote:

That sounds very interesting.

I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i.

Being able to skip the 8/8i exams should make this attractive to many folks.

Jared

"Ron Rogers" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 08:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: OCP 7.3 & 8 upgrade to 9i

List,
While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"

Of the list members that attended Open World in San Francisco, was this
available there also?
I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.

It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?

Ron

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
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: FW: Oracle Performance Software from Veritas


Our good friend Gaja Vaidyanatha is now with Veritas,
so this isn't really too surprising.  :)

Jared








David Wagoner <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 01:59 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        FW: Oracle Performance Software from Veritas


Just got this email from Veritas...apparently they are getting into the database performance business for Oracle (and SQL Server too I think).
 
Best regards, 
David B. Wagoner 
Database Administrator 
Arsenal Digital Solutions 
"the most trusted source for 
            STORAGE MANAGEMENT SERVICES" 

The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.
Thank you. 
-Original Message-
From: VERITAS Software [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 3:40 PM
To: David Wagoner
Subject: Trial Software for Oracle environment






 
 
 
 


 

 





 
 




Do something about it.
Download a free trial of VERITAS Indepth(tm) for Oracle.
Easier said than done. Usually it's difficult, if not impossible, to pinpoint the root cause of performance slowdowns. Countless hours are spent troubleshooting and analyzing applications with few results to show for it.
That's about to change. With VERITAS Indepth for Oracle, you can identify specific application bottlenecks, resolve them faster, and maintain promised service levels to users.
Download VERITAS Indepth for Oracle to see how you can:

Monitor the Oracle environment continuously and capture performance data for current, short term, and long-term performance analysis. 
Drill down and identify a performance problem caused by a resource bottleneck or a poorly written SQL statement. 
Resolve performance problems faster with detailed steps and displays statistics relevant to each step in the Oracle access path. 
Download Now
  
 














  





Why we contacted you and how to opt-out:
We know your time is valuable and that we (and others) are placing increasing demands on it. We contacted you about this news because we believe that the content of this message would be interesting and valuable to you.
If you do not wish to receive future VERITAS notifications, please click on the link below, and send us the e-mail: mailto:[EMAIL PROTECTED] 
Please review our online Privacy Policy and Terms of Use.

© Copyright 2003 VERITAS Software. All rights reserved. 
VERITAS Software, 350 Ellis Street, Mountain View, CA 94043, United States.
We welcome your comments. Send email to [EMAIL PROTECTED]


 
 


The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the

Desupport of RBO


First time I've seen this note:  189702.1

Jared

Locally managed System Tablespace

2003-10-06 Thread Thomas Jeff

Is it really worth the effort to convert dictionary-managed system
tablespaces to 
locally-managed in 9.2?  Ostensibly, I should see some performance
improvements due 
to less recursive sql, etc; but from Googling/Metalink in looking for more
info, it 
doesn't appear as though many sites have bothered to convert.

The process is like this:

a) Convert all dictionary-managed to LMTs.
b) - cold backup 
   - DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL
   - another cold backup

Seems as though it might be better to wait until 10G when I assume Oracle
will convert 
to LMT as part of the migration process; unless anyone can offer some
compelling reasons?



Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.

Email: [EMAIL PROTECTED]

Indy DBA Master Documentation available at:
http://gkmqp.tce.com/tis_dba



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Jeff
  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: sid/serial# vs. audsid: why both?

2003-10-06 Thread John Kanagaraj

Jacques,

>In what cases does the SERIAL# need to be used? Can someone give an example
where a session-level command would be 
>applied to an incorrect session object if SERIAL# were not available?

For backward compatibility reasons :) Looks like AUDSID wasn't generated 7.2
and prior unless AUDIT_TRAIL was TRUE (even if you don't use auditing). A
lot of scripts use SERIAL# and the ALTER SYSTEM KILL SESSION uses the
serial#, which should always be available.

>Why not use AUDSID all the time? Is there a reason why the database keeps
track of two session identifying numbers?

AUDSID is 0 if connecting as internal. Notes 123128.1 and 122230.1 may help!

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  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: Import/Export file is limited to 2,147,483,647 Bytes for Oracle 9i on Sun Solaris (32-bit)?

2003-10-06 Thread Gary W. Parker

Another option is to list multiple *dmp files in the FILE parameter; ie
FILE=(file1.dmp, file2.dmp, ...)
along with the FILESIZE parameter.  When the file1.dmp reaches the size specified in
FILESIZE, then file2.dmp
is created, and so on.  The trick is to list enough files in the FILE parameter to
complete the export.

GWP

-Original Message-
Pena, Carol A
Sent: Monday, October 06, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L
Oracle 9i on Sun Solaris (32-bit)?


Yes, I have a 4.5G export file on a Solaris box.

Have your System Admininstrator check to ensure the filesystem you are
writing the export file to is configured for "large files".

Once you've verified that, then you can export (or import) via a named
pipe. See Note #30528.1 or one of many other Metalink notes. If named
pipes are not sufficient for your export you may also use the
combination of named pipe and "file= & filesize=" parameters.

Carol

-Original Message-
Guang Mei
Sent: Monday, October 06, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
9i on Sun Solaris (32-bit)?


Hi,

I am reading the following doc:

Oracle9i
Release Notes
Release 2 (9.2.0.1.0) for Sun Solaris (32-bit)
April 2003
Part No. A97348-04


and I found that it says the Import/Export file is limited to
2,147,483,647
Bytes (see below). Does this mean the max dump file size. I don't have
9i to
try now, but has anyone have dump file size bigger than 2G in this
situation?

Guang



The following table lists the Oracle file size limits. Block size is
defined
in
the db_block_size parameter of the
$ORACLE_HOME/dbs/initsid.ora file.

File Type Maximum Size in Bytes
data file with block size 2048 8,589,932,544
data file with block size 4096 17,179,865,088
data file with block size 8196 34,359,730,176
data file with block size 16,384 68,719,460,352
data file with block size 32,768 137,438,920,704
Import/Export file 2,147,483,647
SQL*Loader file 2,147,483,647

File Type Maximum Size in Bytes
--

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
  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: Pena, Carol A
  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: Gary W. Parker
  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: Can I execute an exe from a stored Procedure

2003-10-06 Thread Goulet, Dick

Yes, but only from an EXTPROC.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Monday, October 06, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L


Hello,
Is it possible to execute an exe from a stored procedure?  If so can you please 
provide an exmple?

Thanks
Jake
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jake Johnson
  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).

Can I execute an exe from a stored Procedure

2003-10-06 Thread Jake Johnson

Hello,
Is it possible to execute an exe from a stored procedure?  If so can you please 
provide an exmple?

Thanks
Jake
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jake Johnson
  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: data loading

If you choose to implement this method, make sure that all the tables can be in the 
exchange partition command. The exchange partition command has certain requirements to 
be able to complete the exchange (similarity of indexes and constraints), and the 
table has to be suitable for building a "copy" as a partitioned table.
For example, the method would not work with this table (because of the two unique 
keys):
create table t (a number unique, b number unique) ;
If your database version is 8.0 there are even more restrictions on what kind of table 
you can use in an exchange partition command (IIRC any FK constraint will prevent you 
from using the table in an exchange partition.)

> -Original Message-
> Stephane Paquette
> 
> You can use the partitionning option.
> 
> Load into a 1 partitionned table then do a partition exchange with the
> target table.
> 
> It allows you to have the current data live while loading into the
> partitionned table.
> Once the load is loaded just exchange the partition with the 
> table, it is
> fast as it is just an update in the data dictionnary. No data 
> is physically
> moved.
> 
> -Original Message-
> Nancy Hu
> 
> We have an Oracle database that is a kind of data warehouse.  
> We load data
> from mainframe into the database every day.  The following 
> are the steps how
> we load data currently:
> 
> 1. get the data file from Datacom
> 2. ftp the data file from mainframe to the Sun machine where 
> the Oracle
> database resides
> 3. truncate all tables in Oracle database
> 4. load the data into Oracle with SQL LOADER
> 
> Most tables in the Oracle database don't have primary key.  
> Tables are not
> available during the loading that gives us problem for our 24x7
> availability.  Therefore, we would like to change our loading 
> method.  Any
> ideas would be highly appreciated.
-- 
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: Import/Export file is limited to 2,147,483,647 Bytes for Oracle 9i on Sun Solaris (32-bit)?

2003-10-06 Thread Pena, Carol A

Yes, I have a 4.5G export file on a Solaris box.

Have your System Admininstrator check to ensure the filesystem you are
writing the export file to is configured for "large files".

Once you've verified that, then you can export (or import) via a named
pipe. See Note #30528.1 or one of many other Metalink notes. If named
pipes are not sufficient for your export you may also use the
combination of named pipe and "file= & filesize=" parameters.

Carol

-Original Message-
Guang Mei
Sent: Monday, October 06, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
9i on Sun Solaris (32-bit)?


Hi,

I am reading the following doc:

Oracle9i
Release Notes
Release 2 (9.2.0.1.0) for Sun Solaris (32-bit)
April 2003
Part No. A97348-04


and I found that it says the Import/Export file is limited to
2,147,483,647
Bytes (see below). Does this mean the max dump file size. I don't have
9i to
try now, but has anyone have dump file size bigger than 2G in this
situation?

Guang



The following table lists the Oracle file size limits. Block size is
defined
in
the db_block_size parameter of the
$ORACLE_HOME/dbs/initsid.ora file.

File Type Maximum Size in Bytes
data file with block size 2048 8,589,932,544
data file with block size 4096 17,179,865,088
data file with block size 8196 34,359,730,176
data file with block size 16,384 68,719,460,352
data file with block size 32,768 137,438,920,704
Import/Export file 2,147,483,647
SQL*Loader file 2,147,483,647

File Type Maximum Size in Bytes
--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  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: Pena, Carol A
  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: FW: Oracle Performance Software from Veritas

2003-10-06 Thread Stephane Faroult

> David Wagoner wrote:
> 
> Just got this email from Veritas...apparently they are getting into
> the database performance business for Oracle (and SQL Server too I
> think).
> 
> 
> Best regards,
> 
> David B. Wagoner
> Database Administrator
> Arsenal Digital Solutions
> "the most trusted source for
> STORAGE MANAGEMENT SERVICES"
> 
> The contents of this e-mail message may be privileged and/or
> confidential. If you are not the intended recipient, any review,
> dissemination, copying, distribution or other use of the contents of
> this message or any attachment by you is strictly prohibited. If you
> receive this communication in error, please notify us immediately by
> return e-mail or by telephone (919-466-6700), and please delete this
> message and all attachments from your system.
> Thank you.
> 

Used to be Precise SQL.
As it happens, Veritas is in the hands of some old Oracle hands - Gary
Bloom most obviously but also Geoff Squire.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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 7.3 & 8 upgrade to 9i

2003-10-06 Thread Ora NT DBA





Hi All,

>From the Oracle Education Certification Page:

http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html

Shows 4 possible tests:
Oracle9i
DBA OCP Upgrade Path
Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs.

In order to make the process of staying
current as an Oracle Certified technical professional, those already
certified on previous releases of Oracle may upgrade to each future
release by simply completing one migration exam. Listed below are the
migration exams that are currently available to previously certified
Oracle DBAs. 
 Please review the listings below for more
specific information. Generally, one exam is required for OCPs to
upgrade to each new release of an Oracle DBA track. For example, one
exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades
the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to
Oracle9i.  
Oracle7.3 and Oracle8 DBA OCPs now have
another option to upgrade their DBA OCP credential directly to Oracle9i: Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs.
This exam will be available beginning October 2003. 
Select the exam title below to view the exam
objectives.  

  Upgrade Exam: Oracle7.3 and Oracle8 DBA
OCPs to Oracle9i
Exam #1Z0-035 Oracle9i DBA New Features
for Oracle7.3 and Oracle8 OCPs
Available October 2003
  Upgrade Exam: Oracle7.3 to Oracle8 DBA OCP

Exam #1Z0-010 Oracle8 New Features for
Administrators
  Upgrade Exam: Oracle8 to Oracle8i DBA OCP
Exam #1Z0-020 Oracle8i New Features for
Administrators 
  Upgrade Exam: Oracle8i to Oracle9i DBA OCP
Exam #1Z0-030 Oracle9i Database: New
Features for Administrators

Hope this helps,
John

[EMAIL PROTECTED] wrote:

  That sounds very interesting.
  
  
  I have an 7.3 OCP ( beta exams at
OOW ), but don't have 8.0 or 8i.
  
  
  Being able to skip the 8/8i exams
should make this attractive to many folks.
  
  
  Jared
  
  
  
  
  

  



"Ron Rogers"
<[EMAIL PROTECTED]>

Sent by: [EMAIL PROTECTED]
 10/06/2003 08:39 AM

 Please respond to ORACLE-L



        

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

        cc:        

        Subject:        OCP
7.3 & 8 upgrade to 9i
  

  
  
  
  
  List,
While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"
  
Of the list members that attended Open World in San Francisco, was this
available there also? 
I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.
  
It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?
  
Ron
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
 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: FW: Oracle Performance Software from Veritas

Well, they've just acquired OraPerf. I don't know whether Anjo Kolk
is now a veritable Veritas employee, but if he is, then Veritas is
a very serious contender in oracle performance tools/consulting market.
If they acquire hotsos, everybody else, including Quest, is done for.

On Mon, 2003-10-06 at 16:59, David Wagoner wrote:
> Just got this email from Veritas...apparently they are getting into
> the database performance business for Oracle (and SQL Server too I
> think).
>  
> 
> Best regards,
> 
> David B. Wagoner
> Database Administrator
> Arsenal Digital Solutions
> "the most trusted source for
> STORAGE MANAGEMENT SERVICES"
> 
> 
> The contents of this e-mail message may be privileged and/or
> confidential. If you are not the intended recipient, any review,
> dissemination, copying, distribution or other use of the contents of
> this message or any attachment by you is strictly prohibited. If you
> receive this communication in error, please notify us immediately by
> return e-mail or by telephone (919-466-6700), and please delete this
> message and all attachments from your system.
> Thank you.
> 
> -Original Message-
> From: VERITAS Software [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 06, 2003 3:40 PM
> To: David Wagoner
> Subject: Trial Software for Oracle environment
> 
> 
> 
> 
> 
> 
>[image]
> 
>[image]
>   
>[image]
>[image]
>[image]
> 
> 
>[image]
> 
> 
>Do
>  something
>  about it.
> 
>  Download a
>  free trial
>  of VERITAS
>Indepth(tm) for Oracle.
> 
> Easier
>  said than
> done.
>Usually
>  it's
>  difficult,
> if not
> impossible, to pinpoint the root cause of performance slowdowns. Countless hours are 
> spent troubleshooting and analyzing applications with few results to show for it.
> 
> That's
>   about to
>change.
>  With
>VERITAS
>Indepth
>   for
>Oracle,
>you can
>   identify
>   specific
> application bottlenecks, resolve them faster, and maintain promised service levels 
> to users.
> 
>   Download
>VERITAS
>Indepth
>  for Oracle
>  to see how
>   you can:
> 
>   * Monitor the Oracle environment continuously and capture performance data for 
> current, short term, and long-term performance analysis. 
>   * Drill down and identify a performance problem caused by a resource 
> bottleneck or a poorly written SQL statement. 
>   * Resolve performance problems faster with detailed steps and displays 
> statistics relevant to each step in the Oracle access path. 
>

RE: Oracle Performance Software from Veritas

2003-10-06 Thread Tony Johnson




This 
is the renamed Precise Software tools they bought earlier this year 
.

  -Original Message-From: David Wagoner 
  [mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 
  1:59 PMTo: Multiple recipients of list ORACLE-LSubject: 
  FW: Oracle Performance Software from Veritas
  Just 
  got this email from Veritas...apparently they are getting into the database 
  performance business for Oracle (and SQL Server too I 
  think).
   
  Best regards, 
  David B. Wagoner Database Administrator Arsenal 
  Digital Solutions "the most trusted source for     STORAGE 
  MANAGEMENT SERVICES" 
  The contents of this e-mail message may be 
  privileged and/or confidential. If you are not the intended recipient, any 
  review, dissemination, copying, distribution or other use of the contents of 
  this message or any attachment by you is strictly prohibited. If you receive 
  this communication in error, please notify us immediately by return e-mail or 
  by telephone (919-466-6700), and please delete this message and all 
  attachments from your system.Thank you. 
  -Original Message-From: VERITAS Software 
  [mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 3:40 
  PMTo: David WagonerSubject: Trial Software for Oracle 
  environment
  


  

  
  
 
 
 
 
  

 

 
  



  
 
 

  


  

  Do something about it.
  Download a free 
  trial of VERITAS Indepth(tm) for Oracle.
  Easier said than done. Usually it's difficult, if not 
  impossible, to pinpoint the root cause of performance slowdowns. 
  Countless hours are spent troubleshooting and analyzing 
  applications with few results to show for it.
  That's about to change. With 
  VERITAS Indepth for Oracle, you can identify specific application 
  bottlenecks, resolve them faster, and maintain promised service 
  levels to users.
  Download VERITAS Indepth for Oracle to see how you can:
  
Monitor the Oracle environment 
continuously and capture performance data for current, short 
term, and long-term performance analysis. 
Drill down and identify a 
performance problem caused by a resource bottleneck or a poorly 
written SQL statement. 
Resolve performance problems 
faster with detailed steps and displays statistics relevant to 
each step in the Oracle access path. 
  Download 
  Now
  
 
  







  

  

  

  

  

  


  
Why we contacted you and how to opt-out:
We know your time is valuable and that we 
(and others) are placing increasing demands on it. We 
contacted you about this news because we believe that the 
content of this message would be interesting and valuable to 
you.
If you do not wish to receive future VERITAS 
notifications, please click on the link below, and send us 
the e-mail: mailto:[EMAIL PROTECTED] 

Please review our online Privacy Policy and Terms of Use.

  
© Copyright 2003 VERITAS Software. All 
rights reserved. VERITAS Software, 350 Ellis Street, 
Mountain View, CA 94043, United States.We welcome your 
comments. Send email to 
[EMAIL PROTECTED]

RE: Unintentional Humor

2003-10-06 Thread Melanie Caffrey










Dan,

 

It was never my intention to make you or anyone
else feel bad.  

 

And I certainly feel the same frustrations
that you felt when looking at the Web site to begin with.

 

I agree completely that the page in
question showed a significant lack of attention to the information presented
and that the overall impression is one of carelessness on the part of those who
put the piece together.

 

No argument here, trust me.

 

I guess what I was saying here was that
ultimately, the author, is the one who suffers in such a circumstance.

 

And I was trying to give him the benefit
of the doubt by saying that perhaps he wasn’t even aware that the advertisement
had been put together yet, let alone placed in full visible view of everyone.

 

When I found out more about all parties
involved with this particular book (information I was admittedly ignorant about
when I wrote my original response – lucky for me someone emailed me
personally and set me straight), then I understood better that this never
really should have taken place to begin with.  And, of course, I knew that *ideally* this never should have taken
place.  But, I was told that in this
particular instance, it *really*
should never have taken place.

 

Trust me, your point and everyone else’s
is well taken.

 

I respect the opinions and viewpoints of
the folks here at Oracle-L.

 

It’s why I subscribe.

 

Melanie

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Daniel
Fink
Sent: Monday, October 06, 2003 5:15 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Unintentional Humor

 

Melanie, 

There is truth in what you said originally. As soon as
I read your original email, I felt bad. I appreciate your willingness
to stand up and disagree. Some of us take issue, rightly so, with the content
of the page, but  we (me included!) should do a better job of
critiquing the page in a more constructive manner. 

While we did not explicitly paint the author with the
same brush that we used to go after the web page, the implications are pretty
clear. Yes, the page contains many egregious errors and has probably been
written by someone in marketing without a clue as to what Oracle is. The text
makes no sense in several places and the program listing is just plain wrong. 

I don't mean to justify what we did, but we all get
frustrated with the bad information or lazy people out there who don't take the
time to look at something critically or even RTFM. Cary's
earlier story about the drill sergeant hit home with many of us. As a result,
we have short fuses for this kind of 'crap'. And it is not just on the list,
but it is with many of our colleagues and coworkers...even managers.  It
fits well in the 'professional development' category of interpersonal skills. 

I'll shut up now...  
Dan 

Melanie Caffrey wrote: 





Well all, I've been
corrected in my statements below, and I am always one to own up to my mistakes
(or misstatements).



I guess what
I should have said is that in SOME cases, there is not always a clear
communication between all parties involved when an advertisement is made.


In this
case, I have been informed otherwise. 

So, what initially
looked to me like innocent, albeit egregious, mistakes in a book advertisement,
were apparently just plain egregious. 

So, you are
all correct. 

-Original
Message- 
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Melanie Caffrey 
Sent:Monday,
October 06, 20033:54 PM 
To: Multiple recipients of list
ORACLE-L 
Subject: RE: Unintentional Humor


Alright.Now,
I feel I have to defend this poor guy.For if I don't, who will?


First
of all, the book title lists the covered items as 

Hidden
programs - COMMA - export/import - COMMA 

And
so forth. 

VERY
different from something like 

Hidden
programs:export/import, SQL*Loader, etc. 

Secondly,
I'm sure the author didn't mock up his own press page.


These
things are typically created by some "editor" of sorts at the
accompanying publisher. 

And,
if any of you have ever published a book before, you should be intimately
familiar with the fact that, nine times out of ten, the people writing these
press releases *really* don't know
what they're writing about. 

A
few catch phrases thrown around here and there and it's assumed to be good
enough. 

What
somebody should have told Dave Moore is "NEVER let any press mockups or
releases go out without you having gone over them with a fine-toothed
comb". 

Otherwise,
what just took place in this thread is bound to happen ..


Now
I can't speak to the efficacy or accuracy of his book.All I'm saying is take
Web pages, particularly Web pages on publisher Web sites that are touting books
they want to sell, with a grain of salt.And don't dump on the poor author until
you've read his book ... 

-Original
Message- 
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Stephane Paquette 
Sent:Monday,
October 06, 20033:19

RE: data loading

2003-10-06 Thread Stephane Paquette

You can use the partitionning option.

Load into a 1 partitionned table then do a partition exchange with the
target table.

It allows you to have the current data live while loading into the
partitionned table.
Once the load is loaded just exchange the partition with the table, it is
fast as it is just an update in the data dictionnary. No data is physically
moved.


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 



-Original Message-
Nancy Hu
Sent: Monday, October 06, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L


Hi All,

We have an Oracle database that is a kind of data warehouse.  We load data
from mainframe into the database every day.  The following are the steps how
we load data currently:

1. get the data file from Datacom
2. ftp the data file from mainframe to the Sun machine where the Oracle
database resides
3. truncate all tables in Oracle database
4. load the data into Oracle with SQL LOADER

Most tables in the Oracle database don't have primary key.  Tables are not
available during the loading that gives us problem for our 24x7
availability.  Therefore, we would like to change our loading method.  Any
ideas would be highly appreciated.

Nancy

_
Instant message with integrated webcam using MSN Messenger 6.0. Try it now
FREE!  http://msnmessenger-download.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nancy Hu
  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: Stephane Paquette
  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).

data loading

2003-10-06 Thread Nancy Hu

Hi All,

We have an Oracle database that is a kind of data warehouse.  We load data 
from mainframe into the database every day.  The following are the steps how 
we load data currently:

1. get the data file from Datacom
2. ftp the data file from mainframe to the Sun machine where the Oracle 
database resides
3. truncate all tables in Oracle database
4. load the data into Oracle with SQL LOADER

Most tables in the Oracle database don't have primary key.  Tables are not 
available during the loading that gives us problem for our 24x7 
availability.  Therefore, we would like to change our loading method.  Any 
ideas would be highly appreciated.

Nancy

_
Instant message with integrated webcam using MSN Messenger 6.0. Try it now 
FREE!  http://msnmessenger-download.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nancy Hu
 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: Unintentional Humor

2003-10-06 Thread Daniel Fink




Melanie,
There is truth in what you said originally. As soon as I read your
original email, I felt bad. I appreciate your willingness to stand
up and disagree. Some of us take issue, rightly so, with the content of
the page, but  we (me included!) should do a better job of critiquing
the page in a more constructive manner.
While we did not explicitly paint the author with the same brush that
we used to go after the web page, the implications are pretty clear. Yes,
the page contains many egregious errors and has probably been written by
someone in marketing without a clue as to what Oracle is. The text makes
no sense in several places and the program listing is just plain wrong.
I don't mean to justify what we did, but we all get frustrated with
the bad information or lazy people out there who don't take the time to
look at something critically or even RTFM. Cary's earlier story about the
drill sergeant hit home with many of us. As a result, we have short fuses
for this kind of 'crap'. And it is not just on the list, but it is with
many of our colleagues and coworkers...even managers.  It fits well
in the 'professional development' category of interpersonal skills.
I'll shut up now... 
Dan
Melanie Caffrey wrote:



Well
all, I've been corrected in my statements below, and I am always one to
own up to my mistakes (or misstatements).




I
guess what I should have said is that in SOME cases, there is not always
a clear communication between all parties involved when an advertisement
is made.



In
this case, I have been informed otherwise.



So,
what initially looked to me like innocent, albeit egregious, mistakes in
a book advertisement, were apparently just plain egregious.



So,
you are all correct.



-Original
Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Melanie Caffrey
Sent:Monday,
October 06, 20033:54
PM
To:
Multiple recipients of list ORACLE-L
Subject:
RE: Unintentional Humor



Alright.Now,
I feel I have to defend this poor guy.For
if I don't, who will?



First
of all, the book title lists the covered items as



Hidden
programs - COMMA - export/import - COMMA



And
so forth.



VERY
different from something like



Hidden
programs:export/import, SQL*Loader,
etc.



Secondly,
I'm sure the author didn't mock up his own press page.



These
things are typically created by some "editor" of sorts at the accompanying
publisher.



And,
if any of you have ever published a book before, you should be intimately
familiar with the fact that, nine times out of ten, the people writing
these press releases *really*
don't know what they're writing about.



A
few catch phrases thrown around here and there and it's assumed to be good
enough.



What
somebody should have told Dave Moore is "NEVER let any press mockups or
releases go out without you having gone over them with a fine-toothed comb".



Otherwise,
what just took place in this thread is bound to happen ...



Now
I can't speak to the efficacy or accuracy of his book.All
I'm saying is take Web pages, particularly Web pages on publisher Web sites
that are touting books they want to sell, with a grain of salt.And
don't dump on the poor author until you've read his book ...





-Original
Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Stephane Paquette
Sent:Monday,
October 06, 20033:19
PM
To:
Multiple recipients of list ORACLE-L
Subject:
RE: Unintentional Humor


You
mean the hidden $ORACLE_HOME/bin directory




Stephane
Paquette

Administrateur
de bases de donnees


Database
Administrator

Standard
Life

www.standardlife.ca

Tel.
(514) 499-7999 7470 and (514) 925-7187

[EMAIL PROTECTED]

-Original
Message-

From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Daniel Fink
Sent:Monday,
October 06, 20033:04
PM
To:
Multiple recipients of list ORACLE-L
Subject:
Re: Unintentional Humor

I
see what you mean. Too funny! 

Hmm...I
guess I've been wrong all these years. And all that time I wasted reading
the official documentation on such "undocumented" and "hidden" programs
like export/import, sql*loader, tkprof...


[EMAIL PROTECTED]
wrote: 



OK,
well I thought it was funny.

Doing
a google search on some Oracle stuff, I found the following page.

http://www.dba-oracle.com/bp/bp_book6_utils.htm

Scroll
down a bit?  Do you see the funny part?


Jared






begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

9.2.0.4 on linux

2003-10-06 Thread becker . bill


>>
Have any of you experienced similar problems with XDB while patching or 
upgrading?

Jared
>>

Yes. In our case, the XDB tablespace was simply too small. We were not
planning on using it, but installed it anyway, and had set the XDB tblspc
size to somethin like 32M. We wound up setting autoextend on, and the
re-install consumed about 800M, just to support the initial set of XDB objects.

-- 
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).

Import/Export file is limited to 2,147,483,647 Bytes for Oracle 9i on Sun Solaris (32-bit)?

2003-10-06 Thread Guang Mei

Hi,

I am reading the following doc:

Oracle9i
Release Notes
Release 2 (9.2.0.1.0) for Sun Solaris (32-bit)
April 2003
Part No. A97348-04


and I found that it says the Import/Export file is limited to 2,147,483,647
Bytes (see below). Does this mean the max dump file size. I don't have 9i to
try now, but has anyone have dump file size bigger than 2G in this
situation?

Guang



The following table lists the Oracle file size limits. Block size is defined
in
the db_block_size parameter of the
$ORACLE_HOME/dbs/initsid.ora file.

File Type Maximum Size in Bytes
data file with block size 2048 8,589,932,544
data file with block size 4096 17,179,865,088
data file with block size 8196 34,359,730,176
data file with block size 16,384 68,719,460,352
data file with block size 32,768 137,438,920,704
Import/Export file 2,147,483,647
SQL*Loader file 2,147,483,647

File Type Maximum Size in Bytes
--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  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).

SUMMARY: Top Issues faced by Oracle DBAs in a SAN/NAS Environment

2003-10-06 Thread Gaja Krishna Vaidyanatha

Dear list,

As promised, I have summarized the issues that folks
on this list are dealing with, when deploying Oracle
in a SAN/NAS enviroment. I really appreciate the time
that you took to respond to my questions. Thanks to
everyone who responded.


Issues:
--
1) Lack of performance consistency in multiple volume
groups. For example, if there are 2 volume groups v1
and v2 and they both are 4-way striped and mirrored,
v1 should not outperform v2 in any way shape or form.
2) Volume Groups that require rebuilds during
extension (growth). 
3) Lack of simplicity in what the DBA needs to
interface. Too many components...require just mount
points or directories to put stuff. 
4) Lack of storage throughput capacity planning (IOPS,
Transfer rate) in the volume groups, regardless of
h/w cache present.
5) Lack of functionality that proactively eliminates
(prevents) single point of failures.
6) Lack of logical-to-physical mapping of volumes.
Need to know whether multiple logical volumes are
sharing the same physical disks.
7) Lack of Oracle performance data correlation through
the various layers of a SAN. 
8) Lack of automation in filesystem placement and
management. Ideally, it should be done based on I/O
consumption and data criticality.
9) Lack of segregating NAS traffic from regular LAN
traffic (underlying problem  single LAN segment).
10) Not considering REDO and UNDO as corporate data
and NOT placing them in a SAN.
11) Lack of ease in administration functions such as
adding new mount points in a SAN.
12) Lack of automation of backups in a SAN
environment.
13) Lack of proactive detection of configuration
issues such as dynamic multi path (DMP) and the
impact of that on controller/fibre-card utilization.
14) Not recommending the amount of zoning that is
required for a given environment.

Cheers,

Gaja


=
Gaja Krishna Vaidyanatha
Principal Technical Product Manager, 
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  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: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!

2003-10-06 Thread Cunningham, Gerald

Title: Message

I
haven't used or thought about these scripts since version 7.0, until one day
last year.
Another DBA at our shop had written a script called "startdb", which
starts up your current ORACLE_SID. So, thinking I'd be efficient and save maybe
10 -15 keystokes in starting a database, I type "dbstart".
D'oh!! :P
That
script shutdown every instance on the box (6-8 of em'). Luckily it was
dev...
-
Anonymous
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent:
Monday, October 06, 2003 4:24 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: STUPID
LD_LIBRARY_PATHING!!@@@[EMAIL PROTECTED]@[EMAIL PROTECTED]
You
have listed the reasons why many folks don't use the supplied oraenv scripts. It has long been necessary to modify the dbshut and
dbstart scripts as well, if you use
them, as they have in the past not
worked so well. Been awhile since
I've even used them, so they may have
improved while I wasn't looking. Jared

<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
10/06/2003 10:44 AM
Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> cc:
Subject: RE: STUPID
LD_LIBRARY_PATHING!!@@@[EMAIL PROTECTED]@[EMAIL PROTECTED]Guys,I setup lsnrstartstop scripts for
root that does the su -c to oracle and runs them. I could run as oracle
successfully but using the su - c command brought me this
error:"Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal:
libclntsh.so.9.0: open failed: No such file or
directory/usr/oracle/tools/bin/lsnrstart[12]: 398 Killed"I quickly
verified that the file libclntsh.so.0.0 existed. Therefore, I felt that
it might have something to do with relinking. I tried relinking
after shutting everything down and got the same type of ld.so.1 error.
Then with my experience I realized that this usually related to
LD_LIBRARY_PATH. I looked up relinking and found a note that states
this:Doc ID: Note:131321.1 The note says:Oracle
9.X.X (64Bit) on Solaris (64Bit) OS - Set
LD_LIBRARY_PATH=$ORACLE_HOME/lib32 - Set
LD_LIBRARY_PATH_64=$ORACLE_HOME/lib I did this and it worked.I
then verified that Oracle's environmental scripts (out-of-the-box) set
LD_LIBRARY_PATH as I have always used these environment scripts.
However, they do not set the path as listed above. In fact, the
environment variable will overwrite LD_LIBRARY_PATH to the wrong
setting.So, do I set LD_LIBRARY_PATH as above, I am a little confused
since the environment script and this note do not match as to which setting is
correct. For relinking I definitely know only the one above will
work!! GAny opinions?-- 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.comSan Diego, California
-- Mailing list and web hosting
services-To
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing
list you want to be removed from). You mayalso send the HELP command
for other information (like
subscribing).

FW: Oracle Performance Software from Veritas

2003-10-06 Thread David Wagoner




Just 
got this email from Veritas...apparently they are getting into the database 
performance business for Oracle (and SQL Server too I 
think).
 
Best regards, 
David B. Wagoner Database Administrator Arsenal Digital 
Solutions "the 
most trusted source for     STORAGE 
MANAGEMENT SERVICES" 
The contents of this e-mail message may be privileged 
and/or confidential. If you are not the intended recipient, any review, 
dissemination, copying, distribution or other use of the contents of this 
message or any attachment by you is strictly prohibited. If you receive this 
communication in error, please notify us immediately by return e-mail or by 
telephone (919-466-6700), and please delete this message and all attachments 
from your system.Thank you. 
-Original Message-From: VERITAS Software 
[mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 3:40 
PMTo: David WagonerSubject: Trial Software for Oracle 
environment

  
  

  


   
   
   
   

  
   
  
   

  
  
  

   
   
  

  
  

  
Do something about it.
Download a free 
trial of VERITAS Indepth(tm) for Oracle.
Easier said than done. Usually it's difficult, if not impossible, 
to pinpoint the root cause of performance slowdowns. Countless hours 
are spent troubleshooting and analyzing applications with few 
results to show for it.
That's about to change. With VERITAS 
Indepth for Oracle, you can identify specific application 
bottlenecks, resolve them faster, and maintain promised service 
levels to users.
Download VERITAS Indepth for Oracle to see how you can:

  Monitor the Oracle environment 
  continuously and capture performance data for current, short term, 
  and long-term performance analysis. 
  Drill down and identify a 
  performance problem caused by a resource bottleneck or a poorly 
  written SQL statement. 
  Resolve performance problems 
  faster with detailed steps and displays statistics relevant to 
  each step in the Oracle access path. 
Download 
Now
    
   

  
  
  
  
  
  
  

  

  

  
    
  

  

  
  

  Why we contacted you and how to opt-out:
  We know your time is valuable and that we (and 
  others) are placing increasing demands on it. We contacted you 
  about this news because we believe that the content of this 
  message would be interesting and valuable to you.
  If you do not wish to receive future VERITAS 
  notifications, please click on the link below, and send us the 
  e-mail: mailto:[EMAIL PROTECTED] 
  
  Please review our online Privacy Policy and Terms of Use.
  

  © Copyright 2003 VERITAS Software. All 
  rights reserved. VERITAS Software, 350 Ellis Street, 
  Mountain View, CA 94043, United States.We welcome your 
  comments. Send email to 
  [EMAIL PROTECTED]

RE: Cary's book - Rapidly moving OT....

2003-10-06 Thread Bob Lofstrand

Sorry
Jared, I responded before I got far enough in the list to see your
post.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 2:59
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Cary's book - Rapidly moving OTHey folks, move it to the OT list, or just keep it
private. Jared

Bob Lofstrand
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
10/06/2003 10:39 AM Please
respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> cc:
Subject:
RE: Cary's book - Rapidly moving
OTWe have 5 also. All teens now. Very scary. Braces, learning to drive,
starting college. I hope yours were more spred out.
Why? How? Three little girls, that's
about right, then Surprise, twin boys. Uh oh.
Wouldn't trade them for anything but
wouldn't have planned it this way either.
-Original Message- Sent: Friday, October 03, 2003 12:09 PM To: Multiple recipients of list ORACLE-L

>> Yes, unfortunately those of us
who have had the courage and accepted >> the responsibility of
bringing children to the world have to sometimes >> take the bad with
the good.
Well I've brought my share of
children into the world, thats for
sure I'd wager I have more
than just about anyone else here on Oracle-L in fact... Anyone have
more than 5?? Also, I'm rapidly becomming a single parent, as my wife and I are divorcing after 15 years of mariage and
I'm taking custody of the kids. However, I can
assure you that those facts will
not change my voice or it's use
one jot. :-) (any single DBA ladies out there??!!)
LOL.
At any rate, I do choose my battles
that is a lesson I learned long ago.
You choose what is important to
battle and what to leave behind. I used to take up every gauntlet
thrown at my feet, problem was that I'd have so many battles going on that I'd loose them all Now, I pick and choose
the important ones.
Our future is unknown, and always born in
pain,
Robert
-Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/3/2003 11:49 AM

- Original Message -
> education and my life in general.
No, until there aren't more jobs,
I'll > keep on the safe side. That's the part where crisis and
CYA methodology > jump in. I have no
solution, but, unfortunately, I don't have > Christ-like
qualities that are asked from me in every new performance > tuning book. And the blonde down the isle is so
attractive.

Well, at least she'll never accuse you of
having an "on-going issue"...
:)

Yes, unfortunately those of us who have
had the courage and accepted the responsibility of bringing children to the
world have to sometimes take the bad with the good. For the sake of
getting those kids out the door with a good education. Worse yet if we
also have to support mums
and dads way past the age where
they can take care of themselves.
Much worse yet if they are on the
other side of the world. It's all part of
that thing they call "responsibility".

Doesn't mean we cannot speak up.
But it has to be done in a slightly different way. The art is in
learning how far you can push. And where. And when.
It's hard, but a few hard knocks are the best lesson.

Has the role of DBA changed? Hell
yeah! I've been claiming that for years, and why. But
few have listened to the warning signs. Now, it's hit with a thud. Wake up call time. I agree with
Robert: move to a place where you can be effective. Or change the
world.

Now, those of us with kids cannot afford
to change the world. And even without kids, at 50 is not my idea of
fun to form a union. Way past
that. So, moving is the option. And all that comes with it like you
pointed out: learning the ropes in the new
organization. It ain't easy.
Been there done that for the last
3 years. Much better now, but it was a shock. One
hint: pick the organization very carefully. Last thing you want is to be outsourced...

Then of course, there are those of us
that were allowed to keep all
their Oracle shares when they
left. Real estate is the way to go.

Cheers Nuno Souto [EMAIL PROTECTED]
-- Please see the official
ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno
Souto 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
ORA

Re: KGMGR

Well, I have to prove that I know few other things besides 
stirring trouble...

On Mon, 2003-10-06 at 15:49, [EMAIL PROTECTED] wrote:
> Nice work Mladen!
> 
> Thanks for doing this, let us know what else you find.
> 
> I haven't had time yet to play with it.
> 
> Jared
> 
> 
> 
> 
> 
> Mladen Gogala
> <[EMAIL PROTECTED]>
> Sent by:
> [EMAIL PROTECTED]
> 
>  10/06/2003 01:34 PM
>  Please respond to
> ORACLE-L
> 
> To:  
> Multiple recipients of
> list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:  
> KGMGR
> 
> 
> It looks like a promising undocumented utility.Below is what I managed
> to get by running it. I also asked the question on metalink.forum.
> Later, I'll ask it  on asktom.oracle.com.
> 
> inst = "compldb" app = "sqlplus" home = "help"
> KGMGR> help
> Commands:
>  STARTUP PFILE=param file: Startup instance
>  CONNECT: Connect to instance
>  SHUTDOWN [NORMAL | ABORT]: Shutdown instance (default normal)
>  SET 'event name':  Set an event
>  STAT stat name [+str to include] [-str to exclude]: Print statistics
>  KILL: kill the process running the instance (threaded model only)
>  HELP STAT for list of statistics
> KGMGR> help stat
> Statistics:
>  CC: cursor cache statistics
>  EVENT: event statistics
>  ASO: address space objects
>  THREAD: connected threads
>  LATCHDS: latch descriptors
>  LATCHOB: latch object statistics
>  LATCHHOLD: latch holders
>  EVENTDS: event descriptors
>  KGL: library cache statistics
>  SYSPARAM: system parameters
>  SGA : SGA usage
>  KGLOB: library cache objects
>  LOCK: library cache locks
>  PIN: library cache pins
>  DEP: library cache dependencies
> KGMGR>
> 
> 
> -- 
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistransmission.
> If you receive this message in error, please immediately delete it and
> all copies of it from your system, destroy any hard copies of it and
> notify the sender.  You must not, directly or indirectly, use,
> disclose, distribute, print, or copy any part of this message if you
> are not the intended recipient. Wang Trading LLC and any of its
> subsidiaries each reserve the right to monitor all e-mail
> communications through its networks.
> Any views expressed in this message are those of the individual
> sender, except where the message states otherwise and the sender is
> authorized to state them to be the views of any such entity.
> 
> -- 
> 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).
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
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: KGMGR


Nice work Mladen!

Thanks for doing this, let us know what else you find.

I haven't had time yet to play with it.

Jared








Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 01:34 PM
 Please respond to ORACLE-L

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


It looks like a promising undocumented utility.Below is what I managed
to get by running it. I also asked the question on metalink.forum.
Later, I'll ask it  on asktom.oracle.com.

inst = "compldb" app = "sqlplus" home = "help"
KGMGR> help
Commands:
  STARTUP PFILE=param file: Startup instance
  CONNECT: Connect to instance
  SHUTDOWN [NORMAL | ABORT]: Shutdown instance (default normal)
  SET 'event name':  Set an event
  STAT stat name [+str to include] [-str to exclude]: Print statistics
  KILL: kill the process running the instance (threaded model only)
  HELP STAT for list of statistics
KGMGR> help stat
Statistics:
  CC: cursor cache statistics
  EVENT: event statistics
  ASO: address space objects
  THREAD: connected threads
  LATCHDS: latch descriptors
  LATCHOB: latch object statistics
  LATCHHOLD: latch holders
  EVENTDS: event descriptors
  KGL: library cache statistics
  SYSPARAM: system parameters
  SGA : SGA usage
  KGLOB: library cache objects
  LOCK: library cache locks
  PIN: library cache pins
  DEP: library cache dependencies
KGMGR>


-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

-- 
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).

9.2.0.4 patch on linux


List,

I ran into some difficulties today while applying the 9.2.0.4 patch to a
9.2.0.1 db on RH 8.0, and was curious if anyone else had seen 
similar problems.

After installing the 9.2.0.4 sw ( after installing the 2.2.0.18 OUI of course ) , I 
started the database via 'startup migrate' and then ran catpatch.sql.

An ORA-3113 would consistently occur when the following statement was
reached in the catmetx.sql script:

create or replace force view sys.ku$_xmlschema_view of sys.ku$_xmlschema_t
  with object identifier (owner_name, url) as
  select '1','0',
        u.user#, u.name, extractvalue(VALUE(s), '/schema/@schemaURL'),
        s.sys_nc_oid$,
           case when under_path(value(r), '/sys/schemas/PUBLIC') = 1
                then 0 else 1 end,
   s.getclobval(),                    -- unstripped
   xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()),
                                                    u.name)         -- stripped
    from sys.user$ u, xdb.xdb$schema s, xdb.xdb$resource r
    where extractvalue(VALUE(r), '/Resource/XMLRef') = ref(s)
    and u.user# = sys_op_rawtonum(extractvalue(VALUE(r),'/Resource/OwnerID'))
        AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
                EXISTS ( SELECT * FROM session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))


Running this statement from the command line netted the same results.

Querying the dba_registry view didn't reveal anything unusual:  XML stuff was in
the 'LOADED' or 'LOADING' state.

Poking around MetaLink a bit revealed the others had at times had different trouble
with XDB, and had resolved them by recreating the XDB schema.

After running catnoqm.sql ( drops the XDB user ), catpatch.sql was again ran, and 
everything finished to completion.  ( catpatch calls catproc, which eventually calls
catqm.sql, which recreates XDB if needed )

Have any of you experienced similar problems with XDB while patching or upgrading?

Jared

Re: RE: Unintentional Humor

I haven't seen this book, but I occasionally do technical reviews for
Rampant and I must say that the books that I've seen so far are rather
good and make good sense (I've seen chapters of Arup's book and Stpehen
Andert's book about wait event interface). I seriously intend to buy
both of those books when they appear on the market. Knowing the company,
I seriously doubt that they would be publishing rubbish. It probably is
a good and useful book.

On Mon, 2003-10-06 at 16:19, [EMAIL PROTECTED] wrote:
> more terrific work from Don Burleson. I believe he is the editor on the series. 
> 
> is it jsut more or is most of the stuff from this guy redundant material you can get 
> for free from the docs? I hear his Unix for DBAs and Wait Statistic books are pretty 
> good(though have some inaccuracies).
> 
> most of it seems like garbage. 
> > 
> > From: Mladen Gogala <[EMAIL PROTECTED]>
> > Date: 2003/10/06 Mon PM 03:39:26 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: Unintentional Humor
> > 
> > Nope, it's in $ORACLE_HOME/wmd.
> > 
> > On Mon, 2003-10-06 at 15:19, Stephane Paquette wrote:
> > > You mean the hidden $ORACLE_HOME/bin directory
> > >  
> > > Stephane Paquette
> > > Administrateur de bases de donnees
> > > 
> > > Database Administrator
> > > 
> > > Standard Life
> > > 
> > > www.standardlife.ca
> > > 
> > > Tel. (514) 499-7999 7470 and (514) 925-7187
> > > 
> > > [EMAIL PROTECTED]
> > > 
> > > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > > Behalf Of Daniel Fink
> > > Sent: Monday, October 06, 2003 3:04 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Unintentional Humor
> > > 
> > > 
> > > I see what you mean. Too funny! 
> > > 
> > > Hmm...I guess I've been wrong all these years. And all that
> > > time I wasted reading the official documentation on such
> > > "undocumented" and "hidden" programs like export/import,
> > > sql*loader, tkprof... 
> > >   
> > > 
> > > [EMAIL PROTECTED] wrote: 
> > > > OK, well I thought it was funny.
> > > > 
> > > > Doing a google search on some Oracle stuff, I found the
> > > > following page.
> > > > 
> > > > http://www.dba-oracle.com/bp/bp_book6_utils.htm
> > > > 
> > > > Scroll down a bit?  Do you see the funny part?
> > > >   
> > > > 
> > > > Jared
> > -- 
> > Mladen Gogala
> > Oracle DBA
> > 
> > 
> > 
> > 
> > Note:
> > This message is for the named person's use only.  It may contain confidential, 
> > proprietary or legally privileged information.  No confidentiality or privilege is 
> > waived or lost by any mistransmission.  If you receive this message in error, 
> > please immediately delete it and all copies of it from your system, destroy any 
> > hard copies of it and notify the sender.  You must not, directly or indirectly, 
> > use, disclose, distribute, print, or copy any part of this message if you are not 
> > the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve 
> > the right to monitor all e-mail communications through its networks.
> > Any views expressed in this message are those of the individual sender, except 
> > where the message states otherwise and the sender is authorized to state them to 
> > be the views of any such entity.
> > 
> > -- 
> > 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
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expr

RE: Unintentional Humor

2003-10-06 Thread Melanie Caffrey










Well all, I’ve been corrected in my
statements below, and I am always one to own up to my mistakes (or
misstatements).

 

I guess what I should have said is that in
SOME cases, there is not always a clear communication between all parties
involved when an advertisement is made.

 

In this case, I have been informed
otherwise.

 

So, what initially looked to me like
innocent, albeit egregious, mistakes in a book advertisement, were apparently
just plain egregious.

 

So, you are all correct.

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Melanie
Caffrey
Sent: Monday, October 06, 2003 3:54 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Unintentional Humor

 

Alright.  Now, I feel I have to defend this poor
guy.  For if I don’t, who
will?

 

First of all, the book
title lists the covered items as

 

Hidden programs –
COMMA – export/import – COMMA

 

And so forth.

 

VERY different from
something like

 

Hidden programs:  export/import, SQL*Loader, etc.

 

Secondly, I’m sure
the author didn’t mock up his own press page.

 

These things are
typically created by some “editor” of sorts at the accompanying
publisher.

 

And, if any of you have
ever published a book before, you should be intimately familiar with the fact
that, nine times out of ten, the people writing these press releases *really* don’t know what they’re
writing about.

 

A few catch phrases
thrown around here and there and it’s assumed to be good enough.

 

What somebody should have
told Dave Moore is “NEVER let any press mockups or releases go out
without you having gone over them with a fine-toothed comb”.

 

Otherwise, what just took
place in this thread is bound to happen …

 

Now I can’t speak
to the efficacy or accuracy of his book. 
All I’m saying is take Web pages, particularly Web pages on
publisher Web sites that are touting books they want to sell, with a grain of
salt.  And don’t dump on the
poor author until you’ve read his book …

 

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stephane
Paquette
Sent: Monday, October 06, 2003 3:19 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Unintentional Humor

 



You mean
the hidden $ORACLE_HOME/bin directory





 









Stephane
Paquette

Administrateur de bases de donnees

Database Administrator

Standard
Life

www.standardlife.ca

Tel. (514) 499-7999 7470 and (514) 925-7187

[EMAIL PROTECTED]









-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Daniel
Fink
Sent: Monday, October 06, 2003 3:04 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Unintentional Humor

I see what you mean. Too funny! 

Hmm...I guess I've been wrong all these years.
And all that time I wasted reading the official documentation on such
"undocumented" and "hidden" programs like export/import,
sql*loader, tkprof... 
  

[EMAIL PROTECTED] wrote: 




OK, well I thought it was funny. 

Doing a google search on some Oracle stuff, I found
the following page. 

http://www.dba-oracle.com/bp/bp_book6_utils.htm


Scroll down a bit?  Do you see the funny part?

  

Jared

KGMGR

It looks like a promising undocumented utility.Below is what I managed
to get by running it. I also asked the question on metalink.forum.
Later, I'll ask it  on asktom.oracle.com.

inst = "compldb" app = "sqlplus" home = "help"
KGMGR> help
Commands:
  STARTUP PFILE=param file: Startup instance
  CONNECT: Connect to instance
  SHUTDOWN [NORMAL | ABORT]: Shutdown instance (default normal)
  SET 'event name':  Set an event
  STAT stat name [+str to include] [-str to exclude]: Print statistics
  KILL: kill the process running the instance (threaded model only)
  HELP STAT for list of statistics
KGMGR> help stat
Statistics:
  CC: cursor cache statistics
  EVENT: event statistics
  ASO: address space objects
  THREAD: connected threads
  LATCHDS: latch descriptors
  LATCHOB: latch object statistics
  LATCHHOLD: latch holders
  EVENTDS: event descriptors
  KGL: library cache statistics
  SYSPARAM: system parameters
  SGA : SGA usage
  KGLOB: library cache objects
  LOCK: library cache locks
  PIN: library cache pins
  DEP: library cache dependencies
KGMGR>


-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
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).

how to increase the number of parallel slaves?

2003-10-06 Thread Olga Gurevich

Hi.

I am trying to speed up the following query:
update table X set col1=2; I set the degree of
parallelism for the table X to 16 and added a hint:
update /*+ parallel(X,16) */ table X set col1=2;
I only got 4 parallel slaves - one for each partition
in the table. When I do that same operation for a
table
with just one partition, I'm getting as many slaves
as I want - up to 32. Is there anything I can do to
force ORacle to create more than one parallel process
per partition?

thanks
Gene

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Olga Gurevich
  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: what's the size of a date field?


It's 7 bytes







"elain he" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 11:44 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        what's the size of a date field?


Hi,
I'm trying to figure out the size (in bytes) of a DATE column. Executing the 
three queries below returned me three different values. Is there any way of 
finding the size of a date column in the database?

Thanks.

elain

select * from testing;
DOB
-
06-OCT-03


desc testing
Name                                                                     
Null?    Type
 
 -
DOB                                                                          
      DATE


select avg_row_len from user_tables where table_name='TESTING';
AVG_ROW_LEN
---
         11


select data_length from dba_Tab_columns where table_name='TESTING';
DATA_LENGTH
---
          7


select length (timestamp) from abc;
LENGTH(TIMESTAMP)
-
                9

_
Get McAfee virus scanning and cleaning of incoming attachments.  Get Hotmail 
Extra Storage!   http://join.msn.com/?PAGE=features/es

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: elain he
  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: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!

You have listed the reasons why many folks
don't use the supplied oraenv scripts.

It has long been necessary to modify the dbshut and
dbstart scripts as well, if you use them, as they have
in the past not worked so well.

Been awhile since I've even used them, so they may
have improved while I wasn't looking.

Jared

<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 10:44 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: STUPID LD_LIBRARY_PATHING!!@@@[EMAIL PROTECTED]@[EMAIL PROTECTED]

Guys,

I setup lsnrstartstop scripts for root that does the su -c to oracle and runs them. I could run as oracle successfully but using the su - c command brought me this error:

"Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal: libclntsh.so.9.0: open failed: No such file or directory
/usr/oracle/tools/bin/lsnrstart[12]: 398 Killed"

I quickly verified that the file libclntsh.so.0.0 existed. Therefore, I felt that it might have something to do with relinking.

I tried relinking after shutting everything down and got the same type of ld.so.1 error. Then with my experience I realized that this usually related to LD_LIBRARY_PATH. I looked up relinking and found a note that states this:

Doc ID: Note:131321.1

The note says:
Oracle 9.X.X (64Bit) on Solaris (64Bit) OS
- Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32
- Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib

I did this and it worked.

I then verified that Oracle's environmental scripts (out-of-the-box) set LD_LIBRARY_PATH as I have always used these environment scripts. However, they do not set the path as listed above. In fact, the environment variable will overwrite LD_LIBRARY_PATH to the wrong setting.

So, do I set LD_LIBRARY_PATH as above, I am a little confused since the environment script and this note do not match as to which setting is correct. For relinking I definitely know only the one above will work!! G

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

RE: Unintentional Humor


Well, I have published a book, but just one.

I wasn't necessarily poking fun at the author, but the web page is a hoot.

Time for this thread to die, I guess.

Jared







"Melanie Caffrey" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 12:54 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Unintentional Humor


Alright.  Now, I feel I have to defend this poor guy.  For if I don't, who will?
 
First of all, the book title lists the covered items as
 
Hidden programs – COMMA – export/import – COMMA
 
And so forth.
 
VERY different from something like
 
Hidden programs:  export/import, SQL*Loader, etc.
 
Secondly, I'm sure the author didn't mock up his own press page.
 
These things are typically created by some "editor" of sorts at the accompanying publisher.
 
And, if any of you have ever published a book before, you should be intimately familiar with the fact that, nine times out of ten, the people writing these press releases *really* don't know what they're writing about.
 
A few catch phrases thrown around here and there and it's assumed to be good enough.
 
What somebody should have told Dave Moore is "NEVER let any press mockups or releases go out without you having gone over them with a fine-toothed comb".
 
Otherwise, what just took place in this thread is bound to happen …
 
Now I can't speak to the efficacy or accuracy of his book.  All I'm saying is take Web pages, particularly Web pages on publisher Web sites that are touting books they want to sell, with a grain of salt.  And don't dump on the poor author until you've read his book …
 
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette
Sent: Monday, October 06, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unintentional Humor
 
You mean the hidden $ORACLE_HOME/bin directory
 
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Daniel Fink
Sent: Monday, October 06, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Unintentional Humor
I see what you mean. Too funny! 
Hmm...I guess I've been wrong all these years. And all that time I wasted reading the official documentation on such "undocumented" and "hidden" programs like export/import, sql*loader, tkprof... 
  
[EMAIL PROTECTED] wrote: 

OK, well I thought it was funny. 
Doing a google search on some Oracle stuff, I found the following page. 
http://www.dba-oracle.com/bp/bp_book6_utils.htm 
Scroll down a bit?  Do you see the funny part? 
  
Jared

Re: RE: Unintentional Humor

more terrific work from Don Burleson. I believe he is the editor on the series. 

is it jsut more or is most of the stuff from this guy redundant material you can get 
for free from the docs? I hear his Unix for DBAs and Wait Statistic books are pretty 
good(though have some inaccuracies).

most of it seems like garbage. 
> 
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Date: 2003/10/06 Mon PM 03:39:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Unintentional Humor
> 
> Nope, it's in $ORACLE_HOME/wmd.
> 
> On Mon, 2003-10-06 at 15:19, Stephane Paquette wrote:
> > You mean the hidden $ORACLE_HOME/bin directory
> >  
> > Stephane Paquette
> > Administrateur de bases de donnees
> > 
> > Database Administrator
> > 
> > Standard Life
> > 
> > www.standardlife.ca
> > 
> > Tel. (514) 499-7999 7470 and (514) 925-7187
> > 
> > [EMAIL PROTECTED]
> > 
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Behalf Of Daniel Fink
> > Sent: Monday, October 06, 2003 3:04 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Unintentional Humor
> > 
> > 
> > I see what you mean. Too funny! 
> > 
> > Hmm...I guess I've been wrong all these years. And all that
> > time I wasted reading the official documentation on such
> > "undocumented" and "hidden" programs like export/import,
> > sql*loader, tkprof... 
> >   
> > 
> > [EMAIL PROTECTED] wrote: 
> > > OK, well I thought it was funny.
> > > 
> > > Doing a google search on some Oracle stuff, I found the
> > > following page.
> > > 
> > > http://www.dba-oracle.com/bp/bp_book6_utils.htm
> > > 
> > > Scroll down a bit?  Do you see the funny part?
> > >   
> > > 
> > > Jared
> -- 
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain confidential, 
> proprietary or legally privileged information.  No confidentiality or privilege is 
> waived or lost by any mistransmission.  If you receive this message in error, please 
> immediately delete it and all copies of it from your system, destroy any hard copies 
> of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you are not the intended 
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
> monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender, except where 
> the message states otherwise and the sender is authorized to state them to be the 
> views of any such entity.
> 
> -- 
> 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: <[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: OCP 7.3 & 8 upgrade to 9i


That sounds very interesting.

I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i.

Being able to skip the 8/8i exams should make this attractive to many folks.

Jared







"Ron Rogers" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 08:39 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        OCP 7.3 & 8 upgrade to 9i


List,
 While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"

Of the list members that attended Open World in San Francisco, was this
available there also? 
 I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.

It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?

Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  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: what's the size of a date field?

2003-10-06 Thread Stephane Faroult

elain he wrote:
> 
> Hi,
> I'm trying to figure out the size (in bytes) of a DATE column. Executing the
> three queries below returned me three different values. Is there any way of
> finding the size of a date column in the database?
> 
> Thanks.
> 
> elain
> 
> select * from testing;
> DOB
> -
> 06-OCT-03
> 
> desc testing
> Name
> Null?Type
> 
>  -
> DOB
>   DATE
> 
> select avg_row_len from user_tables where table_name='TESTING';
> AVG_ROW_LEN
> ---
>  11
> 
> select data_length from dba_Tab_columns where table_name='TESTING';
> DATA_LENGTH
> ---
>   7
> 
> select length (timestamp) from abc;
> LENGTH(TIMESTAMP)
> -
> 9
> 

select vsize(dob), dump(dob) from testing;

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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: Cary's book - Rapidly moving OT....


Hey folks, move it to the OT list, or just keep it private.

Jared







Bob Lofstrand <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 10:39 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Cary's book - Rapidly moving OT


We have 5 also. All teens now. Very scary. Braces, learning to drive, starting college. I hope yours were more spred out. 
Why? How? Three little girls, that's about right, then Surprise, twin boys. Uh oh. 
Wouldn't trade them for anything but wouldn't have planned it this way either. 
-Original Message- 
Sent: Friday, October 03, 2003 12:09 PM 
To: Multiple recipients of list ORACLE-L 

>> Yes, unfortunately those of us who have had the courage and accepted 
>> the responsibility of bringing children to the world have to sometimes 
>> take the bad with the good.  
Well I've brought my share of children into the world, thats for 
sure I'd wager I have more than just about anyone else here on Oracle-L 
in fact... Anyone have more than 5?? Also, I'm rapidly becomming a single 
parent, as my wife and I are divorcing after 15 years of mariage and I'm 
taking custody of the kids. However, I can assure you that those facts will 
not change my voice or it's use one jot. :-) (any single DBA ladies out 
there??!!) LOL. 
At any rate, I do choose my battles that is a lesson I learned long ago. 
You choose what is important to battle and what to leave behind. I used to 
take up every gauntlet thrown at my feet, problem was that I'd have so many 
battles going on that I'd loose them all Now, I pick and choose the 
important ones. 
Our future is unknown, and always born in pain, 
Robert 
-Original Message- 
To: Multiple recipients of list ORACLE-L 
Sent: 10/3/2003 11:49 AM 
- Original Message - 
> education and my life in general. No, until there aren't more jobs, 
I'll 
> keep on the safe side. That's the part where crisis and CYA 
methodology 
> jump in. I have no solution, but, unfortunately, I don't have 
> Christ-like qualities that are asked from me in every new performance 
> tuning book. And the blonde down the isle is so attractive. 

Well, at least she'll never accuse you of having an "on-going issue"... 
:) 

Yes, unfortunately those of us who have had the courage and accepted 
the responsibility of bringing children to the world have to sometimes 
take the bad with the good.  For the sake of getting those kids out the 
door with a good education.  Worse yet if we also have to support mums 
and dads way past the age where they can take care of themselves. 
Much worse yet if they are on the other side of the world.  It's all 
part 
of that thing they call "responsibility". 

Doesn't mean we cannot speak up.  But it has to be done in a 
slightly different way.  The art is in learning how far you can 
push.  And where.  And when.  It's hard, but a few hard knocks are the 
best lesson. 

Has the role of DBA changed?  Hell yeah!  I've been claiming that for 
years, and why.  But few have listened to the warning signs.  Now, 
it's hit with a thud.  Wake up call time.  I agree with Robert: 
move to a place where you can be effective.  Or change the world. 

Now, those of us with kids cannot afford to change the world.  And even 
without kids, at 50 is not my idea of fun to form a union.  Way past 
that. 
So, moving is the option.  And all that comes with it like you pointed 
out: learning the ropes in the new organization.  It ain't easy. 
Been there done that for the last 3 years.  Much better now, but it 
was a shock.  One hint: pick the organization very carefully.  Last 
thing 
you want is to be outsourced... 

Then of course, there are those of us that were allowed to keep all 
their Oracle shares when they left.  Real estate is the way to go. 

Cheers 
Nuno Souto 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Nuno Souto 
  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: Freeman Robert - IL 
  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-M

RE: Cary's book[Scanned]


OT list please.







Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/04/2003 11:09 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Cary's book[Scanned]


I look better in a skirt than you do :)


--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> Sure, I can take it.  ;-)
> 
> --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > you REALLY want an answer to that?
> > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> > > 
> > > --- Bob Metelsky <[EMAIL PROTECTED]> wrote:
> > > >[snip]
> > > 
> > > > 
> > > > Its funny, I attended the recent NYOUG (Rachael where were
> > > you???)
> > > 
> > > Hey, I was there, I even presented.  What am I, chopped liver?
> > > 
> > > ;-)
> > > 
> > > PB
> > > 
> > > __
> > > Do you Yahoo!?
> > > The New Yahoo! Shopping - with improved product search
> > > http://shopping.yahoo.com
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Paul Baumgartel
> > >   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!?
> > The New Yahoo! Shopping - with improved product search
> > http://shopping.yahoo.com
> > -- 
> > 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).
> 
> 
> __
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Paul Baumgartel
>   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!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
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: Unintentional Humor

2003-10-06 Thread Rachel Carmichael

why does the song "and Bingo was his name-o" keep echoing through my
mind now?


--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote:
> Hey...I don't have a "tnsping0"!  Heck, I don't have 
> "agtctl0" or any of the other "*0" programs!  How do I
> install them?  Where is the hidden $ORACLE_HOME/bin?  If
> my management finds out that I bungled the install of 9i
> I could be in deep doo-doo.
>  
> 
> ...or not...
> 
> 
> -Original Message-
> Sent: Monday, October 06, 2003 12:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> You mean the hidden $ORACLE_HOME/bin directory
>  
> 
> 
> Stephane Paquette
> 
> 
> Administrateur de bases de donnees
> 
> Database Administrator
> 
> Standard Life
> 
> www.standardlife.ca
> 
> Tel. (514) 499-7999 7470 and (514) 925-7187
> 
> [EMAIL PROTECTED]
> 
> -Original Message-
> Daniel Fink
> Sent: Monday, October 06, 2003 3:04 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I see what you mean. Too funny! 
> 
> Hmm...I guess I've been wrong all these years. And all that time I
> wasted reading the official documentation on such "undocumented" and
> "hidden" programs like export/import, sql*loader, tkprof... 
>   
> 
> 
> [EMAIL PROTECTED] wrote: 
> 
> 
> 
> OK, well I thought it was funny. 
> 
> Doing a google search on some Oracle stuff, I found the following
> page. 
> 
> 
> http://www.dba-oracle.com/bp/bp_book6_utils.htm 
> 
> 
> Scroll down a bit?  Do you see the funny part? 
>   
> 
> 
> Jared
> 
> 


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
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: what's the size of a date field?

The size is 7.

avg_row_len includes the row header.

dba_tab_columns.data_length has the "correct" result 7.

The length function applies to varchar2 fields, so the date is converted to a 
character using your default date format, and the length of the string is returned. 
length ('06-OCT-03') = 9


> -Original Message-
> elain he
> 
> I'm trying to figure out the size (in bytes) of a DATE 
> column. Executing the 
> three queries below returned me three different values. Is 
> there any way of 
> finding the size of a date column in the database?
> 
> select * from testing;
> DOB
> -
> 06-OCT-03
> 
> 
> desc testing
> Name  
>
> Null?Type
> --
> -- 
>  -
> DOB   
>
>   DATE
> 
> 
> select avg_row_len from user_tables where table_name='TESTING';
> AVG_ROW_LEN
> ---
>  11
> 
> 
> select data_length from dba_Tab_columns where table_name='TESTING';
> DATA_LENGTH
> ---
>   7
> 
> 
> select length (timestamp) from abc;
> LENGTH(TIMESTAMP)
> -
> 9
-- 
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: Unintentional Humor

2003-10-06 Thread Melanie Caffrey










Alright.  Now, I feel I have to
defend this poor guy.  For if I don’t,
who will?

 

First of all, the book title lists the
covered items as

 

Hidden programs – COMMA –
export/import – COMMA

 

And so forth.

 

VERY different from something like

 

Hidden programs:  export/import, SQL*Loader, etc.

 

Secondly, I’m sure the author didn’t
mock up his own press page.

 

These things are typically created by some
“editor” of sorts at the accompanying publisher.

 

And, if any of you have ever published a
book before, you should be intimately familiar with the fact that, nine times
out of ten, the people writing these press releases *really* don’t know what they’re writing about.

 

A few catch phrases thrown around here and
there and it’s assumed to be good enough.

 

What somebody should have told Dave Moore
is “NEVER let any press mockups or releases go out without you having
gone over them with a fine-toothed comb”.

 

Otherwise, what just took place in this
thread is bound to happen …

 

Now I can’t speak to the efficacy or
accuracy of his book.  All I’m
saying is take Web pages, particularly Web pages on publisher Web sites that
are touting books they want to sell, with a grain of salt.  And don’t dump on the poor author
until you’ve read his book …

 

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stephane
Paquette
Sent: Monday, October 06, 2003 3:19 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Unintentional Humor

 



You mean the hidden
$ORACLE_HOME/bin directory





 









Stephane
Paquette

Administrateur de bases de donnees

Database Administrator

Standard
Life

www.standardlife.ca

Tel. (514) 499-7999 7470 and (514) 925-7187

[EMAIL PROTECTED]









-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Daniel
Fink
Sent: Monday, October 06, 2003 3:04 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Unintentional Humor

I see what you mean. Too funny! 

Hmm...I guess I've been wrong all these years.
And all that time I wasted reading the official documentation on such
"undocumented" and "hidden" programs like export/import,
sql*loader, tkprof... 
  

[EMAIL PROTECTED] wrote: 




OK, well I thought it was funny. 

Doing a google search on some
Oracle stuff, I found the following page. 

http://www.dba-oracle.com/bp/bp_book6_utils.htm


Scroll down a bit?  Do you
see the funny part? 
  

Jared

sid/serial# vs. audsid: why both?

>From the Fine Manual:
Oracle9i Database Performance Tuning Guide and Reference, Release 2 (9.2)
Part Number A96533-02
Chapter 24 Dynamic Performance Views for Tuning
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/sqlviews.htm#32598
V$SESSION
. SID: Session identifier, used to join to other columns 
. SERIAL#: Counter, which is incremented each time a SID is reused by another session 
(when a session ends and another session starts and uses the same SID) 
. AUDSID: Auditing session ID uniquely identifies a session over the life of a 
database. It is also useful when finding the parallel query slaves for a query 
coordinator (during the PQ execution they have the same AUDSID)

Oracle9i Database Reference Release 2 (9.2)
Part Number A96536-02 
V$SESSION
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch3171.htm
SERIAL# ... Session serial number. Used to identify uniquely a session's objects. 
Guarantees that session-level commands are applied to the correct session objects if 
the session ends and another session begins with the same session ID.

 
In what cases does the SERIAL# need to be used? Can someone give an example where a 
session-level command would be applied to an incorrect session object if SERIAL# were 
not available?

Why not use AUDSID all the time? Is there a reason why the database keeps track of two 
session identifying numbers?
-- 
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: Unintentional Humor

2003-10-06 Thread Vergara, Michael (TEM)




Hey...I don't have a "tnsping0"!  Heck, I don't have 

"agtctl0" or any of the other "*0" programs!  How do 
I
install them?  Where is the hidden 
$ORACLE_HOME/bin?  If
my management finds out that I bungled the install of 
9i
I could be in deep doo-doo.
 

...or not...


  -Original Message-From: Stephane Paquette 
  [mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 
  2003 12:19 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Unintentional Humor
  You 
  mean the hidden $ORACLE_HOME/bin directory
   
  
  
  
  Stephane 
  Paquette
  Administrateur 
  de bases de donnees
  Database 
  Administrator
  Standard 
  Life
  www.standardlife.ca
  Tel. 
  (514) 499-7999 7470 and (514) 925-7187
  [EMAIL PROTECTED]
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Daniel 
FinkSent: Monday, October 06, 2003 3:04 PMTo: Multiple 
recipients of list ORACLE-LSubject: Re: Unintentional 
HumorI see what you mean. Too funny! 
Hmm...I guess I've been wrong all these years. And all that time 
I wasted reading the official documentation on such "undocumented" and 
"hidden" programs like export/import, sql*loader, tkprof...   
[EMAIL PROTECTED] wrote: 
OK, well I 
  thought it was funny. 
  Doing a google search on some 
  Oracle stuff, I found the following page. 
  http://www.dba-oracle.com/bp/bp_book6_utils.htm 

  Scroll down a bit?  Do you see 
  the funny part?   
  Jared

Re: Unintentional Humor

2003-10-06 Thread Jay Hostetter

You mean the ls on the $ORACLE_HOME/bin directory (imported directly into the 
documentation without editing)?

I always wanted to know how to get those secret ckpcch.ora and ncomp.log utilities to 
work.

Jay

>>> [EMAIL PROTECTED] 10/06/03 02:39PM >>>
OK, well I thought it was funny.

Doing a google search on some Oracle stuff, I found the following page.

http://www.dba-oracle.com/bp/bp_book6_utils.htm 

Scroll down a bit?  Do you see the funny part?


Jared



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the 
individual or entity to which they are addressed and may contain information that is 
privileged, proprietary and confidential. If you are not the intended recipient, you 
may not use, copy or disclose to anyone the message or any information contained in 
the message. If you have received this communication in error, please notify the 
sender and delete this e-mail message. The contents do not represent the opinion of 
D&E except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  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: kgmgr

2003-10-06 Thread Jesse, Rich

Perhaps a 

grep -i kgmgr $ORACLE_HOME/bin/*

might be of help.  I'm not sure what a "KGMGR iterator context" is, but the
"mig" utility is an intesting hit...


Rich

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

-Original Message-
Sent: Monday, October 06, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L



Oracle 9.2 on Linux RH8:  who knows what the kgmgr utility is? 

I can't find any useful references to it. 

Here's the usage:  usage: KGMGR[KEY=key]
[IFILE=file name | command] 

Thanks, 

Jared 
-- 
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: Unintentional Humor

Nope, it's in $ORACLE_HOME/wmd.

On Mon, 2003-10-06 at 15:19, Stephane Paquette wrote:
> You mean the hidden $ORACLE_HOME/bin directory
>  
> Stephane Paquette
> Administrateur de bases de donnees
> 
> Database Administrator
> 
> Standard Life
> 
> www.standardlife.ca
> 
> Tel. (514) 499-7999 7470 and (514) 925-7187
> 
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Daniel Fink
> Sent: Monday, October 06, 2003 3:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Unintentional Humor
> 
> 
> I see what you mean. Too funny! 
> 
> Hmm...I guess I've been wrong all these years. And all that
> time I wasted reading the official documentation on such
> "undocumented" and "hidden" programs like export/import,
> sql*loader, tkprof... 
>   
> 
> [EMAIL PROTECTED] wrote: 
> > OK, well I thought it was funny.
> > 
> > Doing a google search on some Oracle stuff, I found the
> > following page.
> > 
> > http://www.dba-oracle.com/bp/bp_book6_utils.htm
> > 
> > Scroll down a bit?  Do you see the funny part?
> >   
> > 
> > Jared
-- 
Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
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: Unintentional Humor

2003-10-06 Thread Rachel Carmichael

how about that "Oracle utility" unzip?

and of course, oerr should be kept out of the hands of newbie DBAs


--- Joe Testa <[EMAIL PROTECTED]> wrote:
> Geez at least get rid of the "old linked programs from the dir/ls 
> listing"   oracleO
> 
> :)
> 
> joe
> 
> 
> Daniel Fink wrote:
> 
> > I see what you mean. Too funny!
> >
> > Hmm...I guess I've been wrong all these years. And all that time 
> > I wasted reading the official documentation on such "undocumented"
> and 
> > "hidden" programs like export/import, sql*loader, tkprof...
> >  
> >
> > [EMAIL PROTECTED] wrote:
> >
> >>  
> >> OK, well I thought it was funny.
> >>
> >> Doing a google search on some Oracle stuff, I found the following
> page.
> >>
> >> http://www.dba-oracle.com/bp/bp_book6_utils.htm
> >>
> >> Scroll down a bit?  Do you see the funny part?
> >>  
> >>
> >> Jared
> >>
> 
> -- 
> 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).


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
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: Unintentional Humor

2003-10-06 Thread Joe Testa

Geez at least get rid of the "old linked programs from the dir/ls 
listing"   oracleO

:)

joe

Daniel Fink wrote:

I see what you mean. Too funny!

Hmm...I guess I've been wrong all these years. And all that time 
I wasted reading the official documentation on such "undocumented" and 
"hidden" programs like export/import, sql*loader, tkprof...
 

[EMAIL PROTECTED] wrote:

 
OK, well I thought it was funny.

Doing a google search on some Oracle stuff, I found the following page.

http://www.dba-oracle.com/bp/bp_book6_utils.htm

Scroll down a bit?  Do you see the funny part?
 

Jared

--
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: Unintentional Humor

2003-10-06 Thread Stephane Paquette




You 
mean the hidden $ORACLE_HOME/bin directory
 



Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tel. 
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Daniel FinkSent: 
  Monday, October 06, 2003 3:04 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: Unintentional 
  HumorI see what you mean. Too funny! 
  Hmm...I guess I've been wrong all these years. And all that time 
  I wasted reading the official documentation on such "undocumented" and 
  "hidden" programs like export/import, sql*loader, tkprof...   
  [EMAIL PROTECTED] wrote: 
   OK, well I 
thought it was funny. 
Doing a google search on some Oracle 
stuff, I found the following page. 
http://www.dba-oracle.com/bp/bp_book6_utils.htm 

Scroll down a bit?  Do you see 
the funny part?   
Jared

Re: Basic question about controlfile recovery

Actually, Velpuri explains precisely why do you need to do that. 
Backup controlfile does not contain last SCN, so one has to do
recovery to bring all datafiles to the same SCN. As there is always 
a possibility that log files have some other SCNs, they need to be reset
and cleaned or those SCNs will end up in database during the next
instance recovery (not necessarily media recovery).
If you put RMAN into the mixture, be aware that when one does "alter 
database open resetlogs", he ends up with a new database incarnation
which is no longer registered and needs to be synchronized. In other
words, you will not be able to perform backups until your database is
re-registered.
On Mon, 2003-10-06 at 14:49, Govindan K wrote:
> Hi Scott
>  
> Answer to Question 1 (answers Question 2, 3 too).
> Bkp & Rcvry by Rama Velpuri - Case 8:Recovery with a Bkp control file
> 
> If you use a backup control file, you need to perform media recovery.
> Also, Oracle will force you to use the 'using backup controlfile'
> option.
> Once recovery is done, you must start up the database with the
> RESETLOGS
> option, and have to take a complete backup of your database. The
> reason
> for this is that, Oracle needs to update certain data structures in
> the
> backup controlfile before opening the database, and this is done
> during
> RESETLOGS. After the database is open, you should immediately take a
> full online or offline backup of the database because you cannot
> restore
> any of the datafiles from before RESETLOGS and try to rollforward.
> 
> 
> The book is arguably one of the BEST written on Oracle Backup and
> Recovery ever.
> Better get one.
>  
> HTH
> GovindanK
> <-Original Message->
>  
>  
> From: scott scott
> Sent: 10/6/2003 2:37:24
> AM
> To:
> [EMAIL PROTECTED]
> Subject: Re: Basic
> question about
> controlfile recovery 
> 
> Listers, 
> 
> sorry for this basic
> questionnare. 
> 
> ...was reading the RMAN
> B&R docs (9iR2).got
> these 
> doubts and thought of
> claryfying it with u
> experts. 
> 
> Q1.after a controlfile
> recovery from backup,is
> "open 
> resetlogs" always
> necessary ? 
> 
> Q2.is there any
> scenario,where "open
> resetlogs" is not 
> necessary after
> controlfile recovery ? 
> 
> Q3.i have backup ( one
> day old ) of all my 
> datafiles/archivelogs/controlfile.now,when all my 
> controlfiles are lost
> with online redologs
> intact, 
> is complete recovery
> possible ? if so, is
> "open 
> resetlogs" reqd. & why
> ? 
> 
> Please enlighten me. 
> i'll c! ontinue
> RTF(ine)M. 
> 
> Regards, 
> Scott. 
> 
> 
> 
> 
> Author: scott scott 
> INET:
> [EMAIL PROTECTED] 
> 
> 
> ___
> Get Your 10MB account for FREE at http://mail.arabia.com !
> [image]Access MILLIONS of JOBS NOW!
-- 
Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
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: Unintentional Humor

2003-10-06 Thread Daniel Fink



I see what you mean. Too funny!
Hmm...I guess I've been wrong all these years. And all that time
I wasted reading the official documentation on such "undocumented"
and "hidden" programs like export/import, sql*loader, tkprof...
 
[EMAIL PROTECTED] wrote:
 
OK, well I thought it was funny.
Doing a google search on some
Oracle stuff, I found the following page.
http://www.dba-oracle.com/bp/bp_book6_utils.htm
Scroll down a bit?  Do you
see the funny part?
 
Jared

begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

kgmgr


Oracle 9.2 on Linux RH8:  who knows what the kgmgr utility is?

I can't find any useful references to it.

Here's the usage:  usage: KGMGR[KEY=key] [IFILE=file name | command]

Thanks,

Jared

Re: Basic question about controlfile recovery

2003-10-06 Thread Govindan K



Hi Scott
 
Answer to Question 1 (answers Question 2, 3 too).
Bkp & Rcvry by Rama Velpuri - Case 8:Recovery with a Bkp control fileIf you use a backup control file, you need to perform media recovery.Also, Oracle will force you to use the 'using backup controlfile' option.Once recovery is done, you must start up the database with the RESETLOGSoption, and have to take a complete backup of your database. The reasonfor this is that, Oracle needs to update certain data structures in thebackup controlfile before opening the database, and this is done duringRESETLOGS. After the database is open, you should immediately take afull online or offline backup of the database because you cannot restoreany of the datafiles from before RESETLOGS and try to rollforward.
The book is arguably one of the BEST written on Oracle Backup and Recovery ever.
Better get one.
 
HTH
GovindanK
<-Original Message->



 
 
From: scott scottSent: 10/6/2003 2:37:24 AMTo: [EMAIL PROTECTED]Subject: Re: Basic question about controlfile recovery Listers, sorry for this basic questionnare. ...was reading the RMAN B&R docs (9iR2).got these doubts and thought of claryfying it with u experts. Q1.after a controlfile recovery from backup,is "open resetlogs" always necessary ? Q2.is there any scenario,where "open resetlogs" is not necessary after controlfile recovery ? Q3.i have backup ( one day old ) of all my datafiles/archivelogs/controlfile.now,when all my controlfiles are lost with online redologs intact, is complete recovery possible ? if so, is "open resetlogs" reqd. & why ? Please enlighten me. i'll c!
ontinue RTF(ine)M. Regards, Scott. Author: scott scott INET: [EMAIL PROTECTED] 

___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

what's the size of a date field?

2003-10-06 Thread elain he

Hi,
I'm trying to figure out the size (in bytes) of a DATE column. Executing the 
three queries below returned me three different values. Is there any way of 
finding the size of a date column in the database?

Thanks.

elain

select * from testing;
DOB
-
06-OCT-03
desc testing
Name 
Null?Type
 
 -
DOB  
 DATE

select avg_row_len from user_tables where table_name='TESTING';
AVG_ROW_LEN
---
11
select data_length from dba_Tab_columns where table_name='TESTING';
DATA_LENGTH
---
 7
select length (timestamp) from abc;
LENGTH(TIMESTAMP)
-
   9
_
Get McAfee virus scanning and cleaning of incoming attachments.  Get Hotmail 
Extra Storage!   http://join.msn.com/?PAGE=features/es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: elain he
 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).

Unintentional Humor


OK, well I thought it was funny.

Doing a google search on some Oracle stuff, I found the following page.

http://www.dba-oracle.com/bp/bp_book6_utils.htm

Scroll down a bit?  Do you see the funny part?


Jared

RE: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!

2003-10-06 Thread Paula_Stankus

Hehe

Found a posting from Michael Ault on same subject. Michael - are you there?

Thread Status: Active 


RDBMS Version: 9.2.0.1
Operating System and Version: Solaris 2.8 64 bit
Error Number (if applicable): 
Product (i.e. SQL*Loader, Import, etc.): OCI
Product Version: 9.2.0.1

Library Paths 32 bit on 64 bit 9.2.0.1 Solaris 2.8

I have been through about 16 different postings on this topic concerning linking/using 
32 bit applications on 64 bit Oracle. The situation here is that the applicaiton ran 
fine against 8.1.7.4 64 bit with /lib as 32 bit and /lib64 as 64 bit now Oracle gets a 
bee and makes the libraries /lib a 64 bit and /lib32 as 32 bit and every thing breaks. 
Come on Oracle get a clue, don't mess with such basic things as library directory 
names! Geesh! 

Now every other post seems to contridict each other: 

Set LD_LIBRARY_PATH with $ORACLE_HOME/lib and not with lib32 
Set SHLIB_PATH with $ORACLE_HOME/lib32 and not lib 

Set LD_LIBRARY_PATH with both 
Unset LIBPATH 

Set LD_LIBRARY_PATH with /lib32 first, then /lib 

No...do it the other way 

and last but not least: 

LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/ctx/lib 
LD_LIBRARY_PATH_64=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib 

(Where in the heck did LD_LIBRARY_PATH_64 come from? And why is it not mentioned in 
any other post about this?) 

Anyway, which is correct for running a prelinked 32 bit application using OCI against 
a 9.2.0.1 Oracle 64 bit database on Solaris 2.8? 

And, where can I get a proper coly of the ldflags file for the lib32 directory? 

Mike 










Micheal, 

bet you a pint you'll see this as a bug fix in 9.2.0.3 

Andrew Parkyns 
Senior DBA 
Thomson Derwent 
[EMAIL PROTECTED] 

P.S. do you ascribe to the "Oracle version skipping theory" e.g. bug in 8.1.6.1 fixed 
in 8.1.6.3 recurs in 8.1.7.0, fix backported from 9.0.1, bug recurs in 9.2.0.1  
fixed in 9.2.0.3 ? You could give it a try. 











Yep...sure do. Just a pint? 

Mike 









Hi, 

Kindly post your queries to OCI forum. 

Thanks 
Niranjan 






 


 
 Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and 
Terms of Use.  



-Original Message-
Sent: Monday, October 06, 2003 12:42 PM
To: '[EMAIL PROTECTED]'


Guys,

I setup lsnrstartstop scripts for root that does the su -c to oracle and runs 
them.  I could run as oracle successfully but using the su - c command brought me this 
error:

"Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal: libclntsh.so.9.0: open 
failed: No such file or directory
/usr/oracle/tools/bin/lsnrstart[12]: 398 Killed"

I quickly verified that the file libclntsh.so.0.0 existed.  Therefore, I felt that it 
might have something to do with relinking.  

I tried relinking after shutting everything down and got the same type of ld.so.1 
error.  Then with my experience I realized that this usually related to 
LD_LIBRARY_PATH.  I looked up relinking and found a note that states this:

Doc ID:  Note:131321.1 

The note says:
Oracle 9.X.X (64Bit) on Solaris (64Bit) OS 
- Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 
- Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib 

I did this and it worked.

I then verified that Oracle's environmental scripts (out-of-the-box) set 
LD_LIBRARY_PATH as I have always used these environment scripts.  However, they do not 
set the path as listed above.  In fact, the environment variable will overwrite 
LD_LIBRARY_PATH to the wrong setting.

So, do I set LD_LIBRARY_PATH as above, I am a little confused since the environment 
script and this note do not match as to which setting is correct.  For relinking I 
definitely know only the one above will work!!  G

Any opinions?
-- 
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).

BROKEN_PIPE during Weblogic J2EE deployment

2003-10-06 Thread MacGregor, Ian A.

As Weblogic is not an Oracle product, it is not surprising that Metalink  returned 
nothing.  Try your query on Google.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, October 06, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L


Our web administrator was deploying a new J2EE application to production and received 
the error broken_pipe. We are using the thin client. Apparently Weblogic tries to 
verify existence the tables the application uses. The deployment was otherwise 
successful in that the error occurred several times when deployment was retried but 
testing the app worked fine. They feel it was a database error, but I don't see 
anything on my end. Naturally they are nervous about this error just going into a 
critical new application. Apparently if the database was down, this is the error 
returned on the Weblogic side, but the database was fine and I couldn't find any 
errors. I searched for broken_pipe on Metalink and the search returned empty. Has 
anyone had any experience with this Weblogic error?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: MacGregor, Ian A.
  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: BROKEN_PIPE during Weblogic J2EE deployment

did it have an accompanying ORA- message or some such? If not than its either a 
Weblogic error, a weblogic translation of an oracle error, or your developers trapped 
the oracle error and translated it to something else(I hate when they do that). 
> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/10/06 Mon PM 01:19:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: BROKEN_PIPE during Weblogic J2EE deployment
> 
> Our web administrator was deploying a new J2EE application to production and
> received the error broken_pipe. We are using the thin client. Apparently
> Weblogic tries to verify existence the tables the application uses. The
> deployment was otherwise successful in that the error occurred several times
> when deployment was retried but testing the app worked fine. They feel it
> was a database error, but I don't see anything on my end. Naturally they are
> nervous about this error just going into a critical new application.
> Apparently if the database was down, this is the error returned on the
> Weblogic side, but the database was fine and I couldn't find any errors. I
> searched for broken_pipe on Metalink and the search returned empty. Has
> anyone had any experience with this Weblogic error?
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   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: Cary's book - Rapidly moving OT....

2003-10-06 Thread Freeman Robert - IL

Mine are all from 1.5 to 2 years apart. 10 to 18 woo hoo!

Of course, about 1/2 of the available women in the world run yelling when I
tell them I have custody of 5 kids. Since the other 1/2 are married, that
leaves me high and dry! ;-)

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/6/2003 12:39 PM

We have 5 also. All teens now. Very scary. Braces, learning to drive,
starting college. I hope yours were more spred out. 

Why? How? Three little girls, that's about right, then Surprise, twin
boys. Uh oh. 

Wouldn't trade them for anything but wouldn't have planned it this way
either. 

-Original Message- 
 ] 
Sent: Friday, October 03, 2003 12:09 PM 
To: Multiple recipients of list ORACLE-L 


>> Yes, unfortunately those of us who have had the courage and accepted 
>> the responsibility of bringing children to the world have to
sometimes 
>> take the bad with the good.  

Well I've brought my share of children into the world, thats for 
sure I'd wager I have more than just about anyone else here on
Oracle-L 
in fact... Anyone have more than 5?? Also, I'm rapidly becomming a
single 
parent, as my wife and I are divorcing after 15 years of mariage and I'm

taking custody of the kids. However, I can assure you that those facts
will 
not change my voice or it's use one jot. :-) (any single DBA ladies out 
there??!!) LOL. 

At any rate, I do choose my battles that is a lesson I learned long
ago. 
You choose what is important to battle and what to leave behind. I used
to 
take up every gauntlet thrown at my feet, problem was that I'd have so
many 
battles going on that I'd loose them all Now, I pick and choose the 
important ones. 

Our future is unknown, and always born in pain, 

Robert 

-Original Message- 
To: Multiple recipients of list ORACLE-L 
Sent: 10/3/2003 11:49 AM 

- Original Message - 

> education and my life in general. No, until there aren't more jobs, 
I'll 
> keep on the safe side. That's the part where crisis and CYA 
methodology 
> jump in. I have no solution, but, unfortunately, I don't have 
> Christ-like qualities that are asked from me in every new performance 
> tuning book. And the blonde down the isle is so attractive. 


Well, at least she'll never accuse you of having an "on-going issue"... 

:) 


Yes, unfortunately those of us who have had the courage and accepted 
the responsibility of bringing children to the world have to sometimes 
take the bad with the good.  For the sake of getting those kids out the 
door with a good education.  Worse yet if we also have to support mums 
and dads way past the age where they can take care of themselves. 
Much worse yet if they are on the other side of the world.  It's all 
part 
of that thing they call "responsibility". 


Doesn't mean we cannot speak up.  But it has to be done in a 
slightly different way.  The art is in learning how far you can 
push.  And where.  And when.  It's hard, but a few hard knocks are the 
best lesson. 


Has the role of DBA changed?  Hell yeah!  I've been claiming that for 
years, and why.  But few have listened to the warning signs.  Now, 
it's hit with a thud.  Wake up call time.  I agree with Robert: 
move to a place where you can be effective.  Or change the world. 


Now, those of us with kids cannot afford to change the world.  And even 
without kids, at 50 is not my idea of fun to form a union.  Way past 
that. 
So, moving is the option.  And all that comes with it like you pointed 
out: learning the ropes in the new organization.  It ain't easy. 
Been there done that for the last 3 years.  Much better now, but it 
was a shock.  One hint: pick the organization very carefully.  Last 
thing 
you want is to be outsourced... 


Then of course, there are those of us that were allowed to keep all 
their Oracle shares when they left.  Real estate is the way to go. 


Cheers 
Nuno Souto 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
  
-- 
Author: Nuno Souto 
  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: Freeman Robert - IL 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  
San Diego, California-- Mailing list and web hosting

Re: Cannot use Order By with XMLAGG()

2003-10-06 Thread Jake Johnson

I found the issue.  I was only running 9.2.0.1 and it successfully worked on 9.2.0.3.  
I know this will help someone in the future.  Good luck!


On Mon, Oct 06, 2003 at 08:49:30AM -0800, Jake Johnson wrote:
> No, the correct field is atrb_srt_ord.  I also tried order by 1 and that didn't work 
> either.  The field names are in the describe below.
> 
> Thanks
> Jake
> 
> 
> On Fri, Oct 03, 2003 at 01:29:33PM -0800, Dave Hau wrote:
> > Is it because you misspelled "atrb_srt_ord" as "atrb_str_ord" in the 
> > ORDER BY clause?
> > 
> > HTH,
> > 
> > Dave
> > 
> > 
> > 
> > 
> > 
> > [EMAIL PROTECTED] wrote:
> > >Hello,
> > >I cannot use order by in with my xmlagg clause.  Any ideas???
> > >
> > >Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 
> > >Production
> > >With the OLAP and Oracle Data Mining options
> > >JServer Release 9.2.0.1.0 - Production
> > >
> > >
> > >SELECT XMLELEMENT("Department",
> > >   XMLAGG(
> > >XMLELEMENT("Employee", e.atrb_cd||' '||e.vw_cd)
> > >ORDER BY atrb_str_ord --this works if I -- it out
> > >))
> > >  as "Dept_list" 
> > >FROM dim_vw_atrb e;
> > >
> > >QL> desc dim_vw_atrb;
> > > Name  Null?Type
> > > -  
> > > 
> > > CLNT_CD   NOT NULL NUMBER(2)
> > > DIM_CDNOT NULL NUMBER(2)
> > > VW_CD NOT NULL NUMBER(2)
> > > ATRB_CD   NOT NULL NUMBER(3)
> > > ATRB_SRT_ORD  NOT NULL NUMBER(2)
> > > CRE_DTNOT NULL DATE
> > > CRE_IDSID NOT NULL VARCHAR2(8)
> > > LAST_MOD_DT   NOT NULL DATE
> > > LAST_MOD_IDSIDNOT NULL VARCHAR2(8)
> > >
> > >Thanks,
> > >Jake
> > >
> > >
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Dave Hau
> >  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: Jake Johnson
>   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: Jake Johnson
  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: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!

2003-10-06 Thread Paula_Stankus

Guys,

I setup lsnrstartstop scripts for root that does the su -c to oracle and runs 
them.  I could run as oracle successfully but using the su - c command brought me this 
error:

"Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal: libclntsh.so.9.0: open 
failed: No such file or directory
/usr/oracle/tools/bin/lsnrstart[12]: 398 Killed"

I quickly verified that the file libclntsh.so.0.0 existed.  Therefore, I felt that it 
might have something to do with relinking.  

I tried relinking after shutting everything down and got the same type of ld.so.1 
error.  Then with my experience I realized that this usually related to 
LD_LIBRARY_PATH.  I looked up relinking and found a note that states this:

Doc ID:  Note:131321.1 

The note says:
Oracle 9.X.X (64Bit) on Solaris (64Bit) OS 
- Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 
- Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib 

I did this and it worked.

I then verified that Oracle's environmental scripts (out-of-the-box) set 
LD_LIBRARY_PATH as I have always used these environment scripts.  However, they do not 
set the path as listed above.  In fact, the environment variable will overwrite 
LD_LIBRARY_PATH to the wrong setting.

So, do I set LD_LIBRARY_PATH as above, I am a little confused since the environment 
script and this note do not match as to which setting is correct.  For relinking I 
definitely know only the one above will work!!  G

Any opinions?
-- 
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: Cary's book - Rapidly moving OT....

2003-10-06 Thread Bob Lofstrand

Title: RE: Cary's book - Rapidly moving OT





We have 5 also. All teens now. Very scary. Braces, learning to drive, starting college. I hope yours were more spred out. 

Why? How? Three little girls, that's about right, then Surprise, twin boys. Uh oh.


Wouldn't trade them for anything but wouldn't have planned it this way either. 


-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 03, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Cary's book - Rapidly moving OT



>> Yes, unfortunately those of us who have had the courage and accepted 
>> the responsibility of bringing children to the world have to sometimes 
>> take the bad with the good.  


Well I've brought my share of children into the world, thats for
sure I'd wager I have more than just about anyone else here on Oracle-L
in fact... Anyone have more than 5?? Also, I'm rapidly becomming a single
parent, as my wife and I are divorcing after 15 years of mariage and I'm
taking custody of the kids. However, I can assure you that those facts will
not change my voice or it's use one jot. :-) (any single DBA ladies out
there??!!) LOL.


At any rate, I do choose my battles that is a lesson I learned long ago.
You choose what is important to battle and what to leave behind. I used to
take up every gauntlet thrown at my feet, problem was that I'd have so many
battles going on that I'd loose them all Now, I pick and choose the
important ones.


Our future is unknown, and always born in pain,


Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/3/2003 11:49 AM


- Original Message - 


> education and my life in general. No, until there aren't more jobs,
I'll
> keep on the safe side. That's the part where crisis and CYA
methodology 
> jump in. I have no solution, but, unfortunately, I don't have
> Christ-like qualities that are asked from me in every new performance
> tuning book. And the blonde down the isle is so attractive.



Well, at least she'll never accuse you of having an "on-going issue"...


:)



Yes, unfortunately those of us who have had the courage and accepted 
the responsibility of bringing children to the world have to sometimes 
take the bad with the good.  For the sake of getting those kids out the 
door with a good education.  Worse yet if we also have to support mums
and dads way past the age where they can take care of themselves.
Much worse yet if they are on the other side of the world.  It's all
part
of that thing they call "responsibility".



Doesn't mean we cannot speak up.  But it has to be done in a 
slightly different way.  The art is in learning how far you can
push.  And where.  And when.  It's hard, but a few hard knocks are the 
best lesson.



Has the role of DBA changed?  Hell yeah!  I've been claiming that for
years, and why.  But few have listened to the warning signs.  Now,
it's hit with a thud.  Wake up call time.  I agree with Robert: 
move to a place where you can be effective.  Or change the world.



Now, those of us with kids cannot afford to change the world.  And even 
without kids, at 50 is not my idea of fun to form a union.  Way past
that.
So, moving is the option.  And all that comes with it like you pointed
out: learning the ropes in the new organization.  It ain't easy.
Been there done that for the last 3 years.  Much better now, but it
was a shock.  One hint: pick the organization very carefully.  Last
thing
you want is to be outsourced...



Then of course, there are those of us that were allowed to keep all
their Oracle shares when they left.  Real estate is the way to go.



Cheers
Nuno Souto
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuno Souto
  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: Freeman Robert - IL
  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

Re: RE: Question with lock script - phantom objects

i think one of the reasons utllock.sql is slow is because it joins data dictionary 
views instead of just hitting the underlying tables.

does anyone have a modified utlock.sql that hits the underlying tables? dba_blockers 
is instanely slow sometimes. 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/06 Mon PM 12:24:27 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Question with lock script - phantom objects
> 
> MG,
> 
> the one you mention is slow... that's why this script.
> 
> 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: Monday, October 06, 2003 12:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> The script as such works, but I do not like user scripts
> accessing objects owned by SYS directly. I normally use
> modified version of utlockt.sql in which dba_locks_temp 
> and  lock_holders are global temporary tables in my schema
> which do not get dropped & re-created every time.
> 
> 
> On Mon, 2003-10-06 at 11:29, Jamadagni, Rajendra wrote:
> > Hi all,
> > 
> > I am using following script to see locks in the DB. Do you see any
> > problems with it? 
> > 
> >   cut here  =
> > connect / as sysdba
> > set linesize 200 feedback off heading on  pagesize 100
> > column sid format a9
> > column res heading 'Resource Type' format a15 trunc
> > column id1 format 999 noprint
> > column id2 format 999 noprint
> > column lmode heading 'Lock Held' format a14
> > column request heading 'Lock Req.' format a14
> > column serial# format 9
> > column username  format a10
> > column terminal heading Term format a8
> > column table_name format a20 trunc
> > column owner format a10
> > column inst_id format a5
> > select  --+ no_merge(l) no_merge(s)
> > (select instance_name 
> >   from sys.gv_$instance 
> >  where instance_number = l.inst_id) inst_id,
> > l.sid || ',' || s.serial# sid,
> > s.username,
> > replace(s.terminal,'WTS-') terminal,
> > decode(l.type,
> >'RW','RW-Row Wait Enq',
> >'TM','TM-DML Enq',
> >'TX','TX-Trans Enq',
> >'UL','UL-User',l.type||'-System') res,
> > t.name table_name,u.name owner,
> > l.id1,l.id2,
> > decode(l.lmode,1,'No Lock',
> > 2,'Row Share',
> > 3,'Row Excl',
> > 4,'Share',
> > 5,'Shr Row Excl',
> > 6,'Excl',null) lmode,
> > decode(l.request,1,'No Lock',
> > 2,'Row Share',
> > 3,'Row Excl',
> > 4,'Share',
> > 5,'Shr Row Excl',
> > 6,'Excl',null) request
> > from sys.gv_$lock l, sys.gv_$session s, sys.user$ u,sys.obj$ t
> > where l.sid = s.sid
> > and s.type != 'BACKGROUND'
> > and t.obj# = l.id1
> > and u.user# = t.owner#
> > and l.inst_id = s.inst_id
> > /
> > prompt
> > set feedback on
> > prompt
> > exit
> >   cut here  =
> > 
> > Btu here is the problem ... once in a while (aka many times a day)
> > when we run this script, we see objects as locked by some user which
> > should NEVER be even accessed. We have one schema that deals with out
> > affiliates, and it is practically independent of other schema in the
> > database. Still sometimes we see objects within the affiliate schema
> > beign accesses by other users who have nothing to do (or the code they
> > execute has nothing to do) with the objects displayed in the list.
> > 
> > One peculier thing I have noted, is affiliate schema used private
> > synonyms and the objects listed in the lock scripts are _always_
> > private synonyms pointing to objects in the affiliate schema and the
> > private synonym belongs to the user who is _not_ the locking user.
> > 
> > e.g.
> > 
> > ABC1  47,820BROWNBRE   BRS02TX-Trans Enq   
> > SYSTEM_NETWORK_HIST  MURPHYMExcl
> > 
> > here locking user ius brownbre locking system_network_hist owned by
> > murphym. Actually the table is owned by affiliate and murphym has a
> > private synonym to the table.
> > 
> > Any clues? DB is 9202 RAC.
> > TIA
> > 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 !
> -- 
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistran

BROKEN_PIPE during Weblogic J2EE deployment

2003-10-06 Thread DENNIS WILLIAMS

Our web administrator was deploying a new J2EE application to production and
received the error broken_pipe. We are using the thin client. Apparently
Weblogic tries to verify existence the tables the application uses. The
deployment was otherwise successful in that the error occurred several times
when deployment was retried but testing the app worked fine. They feel it
was a database error, but I don't see anything on my end. Naturally they are
nervous about this error just going into a critical new application.
Apparently if the database was down, this is the error returned on the
Weblogic side, but the database was fine and I couldn't find any errors. I
searched for broken_pipe on Metalink and the search returned empty. Has
anyone had any experience with this Weblogic error?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: Cannot use Order By with XMLAGG()

2003-10-06 Thread Jake Johnson

No, the correct field is atrb_srt_ord.  I also tried order by 1 and that didn't work 
either.  The field names are in the describe below.

Thanks
Jake


On Fri, Oct 03, 2003 at 01:29:33PM -0800, Dave Hau wrote:
> Is it because you misspelled "atrb_srt_ord" as "atrb_str_ord" in the 
> ORDER BY clause?
> 
> HTH,
> 
> Dave
> 
> 
> 
> 
> 
> [EMAIL PROTECTED] wrote:
> >Hello,
> >I cannot use order by in with my xmlagg clause.  Any ideas???
> >
> >Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 
> >Production
> >With the OLAP and Oracle Data Mining options
> >JServer Release 9.2.0.1.0 - Production
> >
> >
> >SELECT XMLELEMENT("Department",
> >   XMLAGG(
> >XMLELEMENT("Employee", e.atrb_cd||' '||e.vw_cd)
> >ORDER BY atrb_str_ord --this works if I -- it out
> >))
> >  as "Dept_list" 
> >FROM dim_vw_atrb e;
> >
> >QL> desc dim_vw_atrb;
> > Name  Null?Type
> > -  
> > 
> > CLNT_CD   NOT NULL NUMBER(2)
> > DIM_CDNOT NULL NUMBER(2)
> > VW_CD NOT NULL NUMBER(2)
> > ATRB_CD   NOT NULL NUMBER(3)
> > ATRB_SRT_ORD  NOT NULL NUMBER(2)
> > CRE_DTNOT NULL DATE
> > CRE_IDSID NOT NULL VARCHAR2(8)
> > LAST_MOD_DT   NOT NULL DATE
> > LAST_MOD_IDSIDNOT NULL VARCHAR2(8)
> >
> >Thanks,
> >Jake
> >
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dave Hau
>  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: Jake Johnson
  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: Question with lock script - phantom objects

2003-10-06 Thread Jamadagni, Rajendra

Title: RE: Question with lock script - phantom objects





MG,


the one you mention is slow... that's why this script.


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-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 06, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Question with lock script - phantom objects



The script as such works, but I do not like user scripts
accessing objects owned by SYS directly. I normally use
modified version of utlockt.sql in which dba_locks_temp 
and  lock_holders are global temporary tables in my schema
which do not get dropped & re-created every time.



On Mon, 2003-10-06 at 11:29, Jamadagni, Rajendra wrote:
> Hi all,
> 
> I am using following script to see locks in the DB. Do you see any
> problems with it? 
> 
>   cut here  =
> connect / as sysdba
> set linesize 200 feedback off heading on  pagesize 100
> column sid format a9
> column res heading 'Resource Type' format a15 trunc
> column id1 format 999 noprint
> column id2 format 999 noprint
> column lmode heading 'Lock Held' format a14
> column request heading 'Lock Req.' format a14
> column serial# format 9
> column username  format a10
> column terminal heading Term format a8
> column table_name format a20 trunc
> column owner format a10
> column inst_id format a5
> select  --+ no_merge(l) no_merge(s)
> (select instance_name 
>   from sys.gv_$instance 
>  where instance_number = l.inst_id) inst_id,
> l.sid || ',' || s.serial# sid,
> s.username,
> replace(s.terminal,'WTS-') terminal,
> decode(l.type,
>    'RW','RW-Row Wait Enq',
>    'TM','TM-DML Enq',
>    'TX','TX-Trans Enq',
>    'UL','UL-User',l.type||'-System') res,
> t.name table_name,u.name owner,
> l.id1,l.id2,
> decode(l.lmode,1,'No Lock',
> 2,'Row Share',
> 3,'Row Excl',
> 4,'Share',
> 5,'Shr Row Excl',
> 6,'Excl',null) lmode,
> decode(l.request,1,'No Lock',
> 2,'Row Share',
> 3,'Row Excl',
> 4,'Share',
> 5,'Shr Row Excl',
> 6,'Excl',null) request
> from sys.gv_$lock l, sys.gv_$session s, sys.user$ u,sys.obj$ t
> where l.sid = s.sid
> and s.type != 'BACKGROUND'
> and t.obj# = l.id1
> and u.user# = t.owner#
> and l.inst_id = s.inst_id
> /
> prompt
> set feedback on
> prompt
> exit
>   cut here  =
> 
> Btu here is the problem ... once in a while (aka many times a day)
> when we run this script, we see objects as locked by some user which
> should NEVER be even accessed. We have one schema that deals with out
> affiliates, and it is practically independent of other schema in the
> database. Still sometimes we see objects within the affiliate schema
> beign accesses by other users who have nothing to do (or the code they
> execute has nothing to do) with the objects displayed in the list.
> 
> One peculier thing I have noted, is affiliate schema used private
> synonyms and the objects listed in the lock scripts are _always_
> private synonyms pointing to objects in the affiliate schema and the
> private synonym belongs to the user who is _not_ the locking user.
> 
> e.g.
> 
> ABC1  47,820    BROWNBRE   BRS02    TX-Trans Enq   
> SYSTEM_NETWORK_HIST  MURPHYM    Excl
> 
> here locking user ius brownbre locking system_network_hist owned by
> murphym. Actually the table is owned by affiliate and murphym has a
> private synonym to the table.
> 
> Any clues? DB is 9202 RAC.
> TIA
> 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 !
-- 
Mladen Gogala
Oracle DBA





Note:
This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.

Any views expressed in this message are those of the individual sender, except where the message states otherwise

Re: More info about _db_writer_max_writes

2003-10-06 Thread K Gopalakrishnan

Hans:

This parameter limits the max # of buffers can be pending for an AIO
operation. Usually you never need to tune (!) this parameter as the default
holds good for most platforms.

BTW what is the size of the log buffer? You will never have more than 4k
pending buffers unless you have a really huge (!) log buffer.

KG

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 9:19 PM


> Hi All,
>
> The current value for my AIX 4.3.3 / 8.1.7.4 instance parameter
> _db_writer_max_writes is 4096. I've just raised my aio maxreqs to 16384.
> Would it be beneficial to increase _db_writer_max_writes?
>
> HTH,
> Hans de Git
>
> _
> MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Hans de Git
>   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: K Gopalakrishnan
  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: Question with lock script - phantom objects

2003-10-06 Thread Stephane Faroult

Raj,

  Are you certain that in all the cases id1 is an obj#? Its meaning depends on the 
type of lock. An unfortunate coincidence might make it match an obj# when it is 
actually something else.

HTH

SF

>- --- Original Message --- -
>From: "Jamadagni, Rajendra"
><[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 06 Oct 2003 07:29:30
>
>--_=_NextPart_001_01C38C16.3B1E156B
>Content-Type: text/plain;
>charset="iso-8859-1"
>
>Hi all,
>
>I am using following script to see locks in the DB.
>Do you see any problems
>with it? 
>
>  cut here 
>=
>connect / as sysdba
>set linesize 200 feedback off heading on  pagesize
>100
>column sid format a9
>column res heading 'Resource Type' format a15 trunc
>
>column id1 format 999 noprint
>column id2 format 999 noprint
>column lmode heading 'Lock Held' format a14
>column request heading 'Lock Req.' format a14
>column serial# format 9
>column username  format a10
>column terminal heading Term format a8
>column table_name format a20 trunc
>column owner format a10
>column inst_id format a5
>select  --+ no_merge(l) no_merge(s)
>(select instance_name 
>  from sys.gv_$instance 
> where instance_number = l.inst_id)
>inst_id,
>l.sid || ',' || s.serial# sid,
>s.username,
>replace(s.terminal,'WTS-') terminal,
>decode(l.type,
>   'RW','RW-Row Wait Enq',
>   'TM','TM-DML Enq',
>   'TX','TX-Trans Enq',
>   'UL','UL-User',l.type||'-System')
>res,
>t.name table_name,u.name owner,
>l.id1,l.id2,
>decode(l.lmode,1,'No Lock',
>2,'Row Share',
>3,'Row Excl',
>4,'Share',
>5,'Shr Row Excl',
>6,'Excl',null) lmode,
>decode(l.request,1,'No Lock',
>2,'Row Share',
>3,'Row Excl',
>4,'Share',
>5,'Shr Row Excl',
>6,'Excl',null) request
>from sys.gv_$lock l, sys.gv_$session s, sys.user$
>u,sys.obj$ t
>where l.sid = s.sid
>and s.type != 'BACKGROUND'
>and t.obj# = l.id1
>and u.user# = t.owner#
>and l.inst_id = s.inst_id
>/
>prompt
>set feedback on
>prompt
>exit
>  cut here 
>=
>
>Btu here is the problem ... once in a while (aka
>many times a day) when we
>run this script, we see objects as locked by some
>user which should NEVER be
>even accessed. We have one schema that deals with
>out affiliates, and it is
>practically independent of other schema in the
>database. Still sometimes we
>see objects within the affiliate schema beign
>accesses by other users who
>have nothing to do (or the code they execute has
>nothing to do) with the
>objects displayed in the list.
>
>One peculier thing I have noted, is affiliate
>schema used private synonyms
>and the objects listed in the lock scripts are
>_always_ private synonyms
>pointing to objects in the affiliate schema and the
>private synonym belongs
>to the user who is _not_ the locking user.
>
>e.g.
>
>ABC1  47,820BROWNBRE   BRS02TX-Trans Enq   
>SYSTEM_NETWORK_HIST
>MURPHYMExcl
>
>here locking user ius brownbre locking
>system_network_hist owned by murphym.
>Actually the table is owned by affiliate and
>murphym has a private synonym
>to the table.
>
>Any clues? DB is 9202 RAC.
>TIA
>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 !
>
>
>--_=_NextPart_001_01C38C16.3B1E156B
>Content-Type: text/html;
>charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>
>
>
>CONTENT=3D"text/html; =
>charset=3Diso-8859-1">
>Server version =
>5.5.2654.45">
>Question with lock script - phantom
>objects
>
>
>
>Hi
>all,
>
>
>I am using
>following script to =
>see locks in the DB. Do you see any problems with
>it? 
>
>
>=3D  cut here  =
>connect /
>as sysdba
>set
>linesize 200 feedback off =
>heading on  pagesize 100
>column sid
>format a9
>column res
>heading 'Resource =
>Type' format a15 trunc
>column id1
>format 999 =
>noprint
>column id2
>format 999 =
>noprint
>column
>lmode heading 'Lock =
>Held' format a14
>column
>request heading 'Lock =
>Req.' format a14
>column
>serial# format =
>9
>column
>username  format =
>a10
>column
>terminal heading Term =
>format a8
>column
>table_name format a20 =
>trunc
>column
>owner format a10
>column
>inst_id format a5
>New">select  --+ no_merge(l) =
>no_merge(s)
>New">   
>(select instance_name =
>
>sys.gv_$instance 
>instance_number =3D l.inst_id) inst_id,
>New">   
>l.sid || ',' || =
>s.serial# sid,
>New">   
>s.username,
>New">    =
>replace(s.terminal,'WTS-') terminal,
>New">   
>decode(l.type,
>nbsp;   'RW','RW-Row Wait Enq',
>nbsp;   'TM','TM-DML Enq',
>nbsp;   'TX','TX-Trans Enq',
>n

RE: OCP 7.3 & 8 upgrade to 9i

2003-10-06 Thread Brian McGraw

I actually sat for the beta of that exam, the week before OracleWorld.  I
haven't received my scores yet, so I doubt that it is actually being offered
to the general public yet.  But that *is* the plan.

Brian

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

-Original Message-
Rogers
Sent: Monday, October 06, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L

List,
 While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram200
3.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"

Of the list members that attended Open World in San Francisco, was this
available there also? 
 I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.

It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?

Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  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: Brian McGraw
  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: Question with lock script - phantom objects

The script as such works, but I do not like user scripts
accessing objects owned by SYS directly. I normally use
modified version of utlockt.sql in which dba_locks_temp 
and  lock_holders are global temporary tables in my schema
which do not get dropped & re-created every time.


On Mon, 2003-10-06 at 11:29, Jamadagni, Rajendra wrote:
> Hi all,
> 
> I am using following script to see locks in the DB. Do you see any
> problems with it? 
> 
>   cut here  =
> connect / as sysdba
> set linesize 200 feedback off heading on  pagesize 100
> column sid format a9
> column res heading 'Resource Type' format a15 trunc
> column id1 format 999 noprint
> column id2 format 999 noprint
> column lmode heading 'Lock Held' format a14
> column request heading 'Lock Req.' format a14
> column serial# format 9
> column username  format a10
> column terminal heading Term format a8
> column table_name format a20 trunc
> column owner format a10
> column inst_id format a5
> select  --+ no_merge(l) no_merge(s)
> (select instance_name 
>   from sys.gv_$instance 
>  where instance_number = l.inst_id) inst_id,
> l.sid || ',' || s.serial# sid,
> s.username,
> replace(s.terminal,'WTS-') terminal,
> decode(l.type,
>'RW','RW-Row Wait Enq',
>'TM','TM-DML Enq',
>'TX','TX-Trans Enq',
>'UL','UL-User',l.type||'-System') res,
> t.name table_name,u.name owner,
> l.id1,l.id2,
> decode(l.lmode,1,'No Lock',
> 2,'Row Share',
> 3,'Row Excl',
> 4,'Share',
> 5,'Shr Row Excl',
> 6,'Excl',null) lmode,
> decode(l.request,1,'No Lock',
> 2,'Row Share',
> 3,'Row Excl',
> 4,'Share',
> 5,'Shr Row Excl',
> 6,'Excl',null) request
> from sys.gv_$lock l, sys.gv_$session s, sys.user$ u,sys.obj$ t
> where l.sid = s.sid
> and s.type != 'BACKGROUND'
> and t.obj# = l.id1
> and u.user# = t.owner#
> and l.inst_id = s.inst_id
> /
> prompt
> set feedback on
> prompt
> exit
>   cut here  =
> 
> Btu here is the problem ... once in a while (aka many times a day)
> when we run this script, we see objects as locked by some user which
> should NEVER be even accessed. We have one schema that deals with out
> affiliates, and it is practically independent of other schema in the
> database. Still sometimes we see objects within the affiliate schema
> beign accesses by other users who have nothing to do (or the code they
> execute has nothing to do) with the objects displayed in the list.
> 
> One peculier thing I have noted, is affiliate schema used private
> synonyms and the objects listed in the lock scripts are _always_
> private synonyms pointing to objects in the affiliate schema and the
> private synonym belongs to the user who is _not_ the locking user.
> 
> e.g.
> 
> ABC1  47,820BROWNBRE   BRS02TX-Trans Enq   
> SYSTEM_NETWORK_HIST  MURPHYMExcl
> 
> here locking user ius brownbre locking system_network_hist owned by
> murphym. Actually the table is owned by affiliate and murphym has a
> private synonym to the table.
> 
> Any clues? DB is 9202 RAC.
> TIA
> 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 !
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
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: UN

More info about _db_writer_max_writes

2003-10-06 Thread Hans de Git

Hi All,

The current value for my AIX 4.3.3 / 8.1.7.4 instance parameter 
_db_writer_max_writes is 4096. I've just raised my aio maxreqs to 16384. 
Would it be beneficial to increase _db_writer_max_writes?

HTH,
Hans de Git
_
MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
 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).

OCP 7.3 & 8 upgrade to 9i

2003-10-06 Thread Ron Rogers

List,
 While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"

Of the list members that attended Open World in San Francisco, was this
available there also? 
 I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.

It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?

Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  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).

Question with lock script - phantom objects

2003-10-06 Thread Jamadagni, Rajendra

Title: Question with lock script - phantom objects





Hi all,


I am using following script to see locks in the DB. Do you see any problems with it? 


  cut here  =
connect / as sysdba
set linesize 200 feedback off heading on  pagesize 100
column sid format a9
column res heading 'Resource Type' format a15 trunc
column id1 format 999 noprint
column id2 format 999 noprint
column lmode heading 'Lock Held' format a14
column request heading 'Lock Req.' format a14
column serial# format 9
column username  format a10
column terminal heading Term format a8
column table_name format a20 trunc
column owner format a10
column inst_id format a5
select  --+ no_merge(l) no_merge(s)
    (select instance_name 
  from sys.gv_$instance 
 where instance_number = l.inst_id) inst_id,
    l.sid || ',' || s.serial# sid,
    s.username,
    replace(s.terminal,'WTS-') terminal,
    decode(l.type,
   'RW','RW-Row Wait Enq',
   'TM','TM-DML Enq',
   'TX','TX-Trans Enq',
   'UL','UL-User',l.type||'-System') res,
    t.name table_name,u.name owner,
    l.id1,l.id2,
    decode(l.lmode,1,'No Lock',
    2,'Row Share',
    3,'Row Excl',
    4,'Share',
    5,'Shr Row Excl',
    6,'Excl',null) lmode,
    decode(l.request,1,'No Lock',
    2,'Row Share',
    3,'Row Excl',
    4,'Share',
    5,'Shr Row Excl',
    6,'Excl',null) request
from sys.gv_$lock l, sys.gv_$session s, sys.user$ u,sys.obj$ t
where l.sid = s.sid
and s.type != 'BACKGROUND'
and t.obj# = l.id1
and u.user# = t.owner#
and l.inst_id = s.inst_id
/
prompt
set feedback on
prompt
exit
  cut here  =


Btu here is the problem ... once in a while (aka many times a day) when we run this script, we see objects as locked by some user which should NEVER be even accessed. We have one schema that deals with out affiliates, and it is practically independent of other schema in the database. Still sometimes we see objects within the affiliate schema beign accesses by other users who have nothing to do (or the code they execute has nothing to do) with the objects displayed in the list.

One peculier thing I have noted, is affiliate schema used private synonyms and the objects listed in the lock scripts are _always_ private synonyms pointing to objects in the affiliate schema and the private synonym belongs to the user who is _not_ the locking user.

e.g.


ABC1  47,820    BROWNBRE   BRS02    TX-Trans Enq    SYSTEM_NETWORK_HIST  MURPHYM    Excl


here locking user ius brownbre locking system_network_hist owned by murphym. Actually the table is owned by affiliate and murphym has a private synonym to the table.

Any clues? DB is 9202 RAC.
TIA
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 !



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.*2

RE: Re: Physical I/O and databases other than oracle