RE: SCOTT/TIGER - the rumor mill

[Lord, David - CS]

LoL

 -Original Message-
 From: Bellows, Bambi [mailto:[EMAIL PROTECTED]]
 Sent: 23 January 2002 19:40
 To: Multiple recipients of list ORACLE-L
 Subject: RE: SCOTT/TIGER - the rumor mill
 
 
 I heard that CALVIN/HOBBS was taken.  No seriously, the 
 girlfriend's cat
 story is at least 18 years old.  Never heard of a pet iguana 
 named CAPSLOCK
 though.
 
 Bambi.
 


**
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lord, David - CS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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:

The problem is that these kinds of operations can have a timed delayed fuse.
By the time your leg explodes the old leg does not feet (could not resist
:-) )

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Bellows, Bambi [SMTP:[EMAIL PROTECTED]]
 Sent: Wed, January 23, 2002 7:51 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: 
 
 Oh, anything is possible if you want to do it badly enough and don't mind
 screwing with the protections Oracle's put in place to stop you from
 shooting yourself in the foot. Of course, if you wind up shooting yourself
 in the foot because of it, it's best to have a cold backup of the foot to
 sew back on to the end of your leg.  
 
 Lessons learned in the trenches...
 Bambi.
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 10:40 AM
 To: Multiple recipients of list ORACLE-L
 
 Ahh - but he let the cat out of the bag!  So it IS possible!
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 10:11 AM
 To: Multiple recipients of list ORACLE-L
 
 
 wow, Dick, pretty counterculture for you!  ;-)
 
 Glad you didn't post it, so the list nannies
 didn't have to tsk, tsk you!
 
 
 -Original Message-
 
 There is an undocumented, unsupported method of doing so by manipulating
 the
 data dictionary.  I was brave enough to try it some years ago on a test
 instance
 created just for the purpose.  IF you hit it just right it works.  But if
 you
 make just ONE mistake it's history.  Consequently I do NOT recommend it.
 It's a
 whole lot easier, and much less error prone, to either create a view that
 does
 the column rename or rebuild the table.
 
 Dick Goulet
 
 Reply Separator
 Author: [EMAIL PROTECTED]
 Date:   1/23/2002 3:25 AM
 
 Hello
 
 Is it possible to rename a column in Oracle 8 ( Release 8.0.3.0.0 )?
 
 Regards
 Systems
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 -- 
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 -- 
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 -- 
 Author: Bellows, Bambi
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, 

RE: SCOTT/TIGER

[SARKAR, Samir]

Whats all this about a cat (they hardly make good pets) I definitely
heard from 'reliable sources'
that Tiger was Scott's dog.and a German Shepherd at that !!

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 23 January 2002 18:46
To: Multiple recipients of list ORACLE-L


well I've heard several versions of this.

all of them agree that Scott was one of the early developers

but tiger has been variously attributed to:

scott's girlfriend's cat
scott had a stuffed tiger on his desk
larry walking by and saying make it tiger


--- [EMAIL PROTECTED] wrote:
 Yes.  Scott was an early developer of the Oracle DB and 
 Tiger was the name of his girlfriend's cat.  Or so the 
 story went when I worked for Oracle.
 
 Ken
  Anyone out there know the history of this?
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Mohan, Ross
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
 Lists
 
 
  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.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[rpapnoi]

Can you send me one (NT backup strategy)

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

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

Please send me one. (NT) Thank,

grace wrote:
 
 can u also send me a copy on backup strategy on  nt.
 thanks
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, January 23, 2002 3:25 PM
 
  Hello Hamid
 
  I would like to have this paper as well.
  We are now revising our Backup strategy.
 
  Yechiel Adar, Mehish Computer Services
  [EMAIL PROTECTED]
 
   -Original Message-
   From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
   Sent: Tue, January 22, 2002 6:35 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: Backup Strategy
  
   Hamid,
  
   Would you be willing to forward a copy of
   this paper?
  
   Thanks,
  
   Ross Mohan
  
   -Original Message-
   Sent: Thursday, January 17, 2002 12:27 PM
   To: Multiple recipients of list ORACLE-L
  
  
   Hi List,
   I have a white paper for Backup Strategy on Microsoft NT but I am
 looking
   for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or
   link
   I realy appreciate.
  
  
  
  
   Hamid Alavi
   Office 818 737-0526
   Cell818 402-1987
  
   The information contained in this message and any attachments is
 intended
   only for the use of the individual or entity to which it is addressed,
 and
   may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
   disclosure under applicable law. If you have received this message in
   error,
   you are prohibited from copying, distributing, or using the information.
   Please contact the sender immediately by return e-mail and delete the
   original message from your system.
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Hamid Alavi
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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.com
   --
   Author: Mohan, Ross
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like subscribing).
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This e-mail was scanned by the eSafe Mail Gateway
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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.com
 --
 Author: grace
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City 

Re: Backup Strategy

[Bunyamin K. Karadeniz]

If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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.com
  --
  Author: grace
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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, 

RE: Magic

[Shreeni]

Nope, the MAGIC I want to know is the one developed by some Isroil
Technologies or somesuch  The one by magicsoftware is RAD for Linux.

Shreenivasa Rao
e-Zing Technologies, Inc..
41-43 Beekman Street, 3rd Floor
New York, NY 10038.
Tel: (212)233-9861 xt.241
Fax: (212)233-9862
Cell:(917)861-4966
[EMAIL PROTECTED] 
***
**Your IT Solutions Provider
*** *** http://www.e-zingtech.com  ***
Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail
can
not be considered spam as long as we include contact information and a
remove link for removal from our mailing list. To be removed from our
mailing list reply with remove in the subject heading and your email
address in the body. Include complete address and/or domain to be
removed.




-Original Message-
Benjamins
Sent: Wednesday, January 23, 2002 1:35 AM
To: Multiple recipients of list ORACLE-L


Magic is a RAD development tool

see: http://www.magicsoftware.com


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 22, 2002 10:57 PM


 
 Hi Guys/Gals
 
 Anybody tell me about what Magic 7.0 is all about ?? I know for sure
it
 is something to large Data loads ?? Please enlighten.  Google/Lycos
 didnt turnup anything useful either except for Pwoer Quest's Partition
 Magic 7.0 :)
 
 Shreeni
 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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


BEGIN:VCARD
VERSION:2.1
N:Kodikal Bhaskar Rao;Shreenivasa;R
FN:Shreenivasa Rao
NICKNAME:Seena
ORG:e-Zing Technologies Inc
TITLE:Oracle DBA
TEL;WORK;VOICE:(212) 233-9861
TEL;HOME;VOICE:(732) 326-1899
TEL;CELL;VOICE:732-670-7066
TEL;WORK;FAX:(212) 233-9862
ADR;WORK:;;41-43, Beekman Street;NY;NY;10010;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:41-43, Beekman Street=0D=0ANY, NY 10010=0D=0AUnited States of America
ADR;HOME:;;741, Cheryl Dr;Iselin;NJ;08830-3110;USA
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:741, Cheryl Dr=0D=0AIselin, NJ 08830-3110=0D=0AUSA
X-WAB-GENDER:2
URL;HOME:http://www.sritri.com
URL;WORK:http://www.e-zingtech.com
BDAY:19630202
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
EMAIL;INTERNET:[EMAIL PROTECTED]
REV:20011230T034250Z
END:VCARD

RE: multiple extents are OK, dagnabbit!

[Wiegand, Kurt]

Sorry Jeremiah, I don't have a clue...

got the same error (after the same 2 hours) after purging the 
shared pool; there was no activity at all on the database, so
I thought about increasing the size of the shared pool (~10.5MB)
but had a need, and the option, of simply replacing the database
with a backup.

SQL alter tablespace USR2 coalesce
*
ERROR at line 1:
ORA-04031: unable to allocate 4180 bytes of shared memory (shared
pool,unknown object,sga heap,state objects)
 
 

-Original Message-
Sent: Wednesday, January 23, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L


On Tue, 22 Jan 2002, Wiegand, Kurt wrote:

 sort of on the subject.I once had a table with ~88000 extents
 (most 1 block!)  it took 8 hours to delete and a subsequent coalesce
 ran for 2 hours before failing as it ran out of shared
 memory(8.1.5).

Kurt,

What component of the SGA becomes exhausted by a long-running
coalesce?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

 -Original Message-
 Sent: Tuesday, January 22, 2002 11:55 AM
 To: Multiple recipients of list ORACLE-L
 
   The problem arose in the catalog upgrade script. It would never
 return. My diary says we let one attempt run for 36 hours. The process 
 showed CPU usage and I/O but nothing happened. Some of the Oracle guys 
 figured the problem was with the $fet (or whatever tables hold the
 extent
 info, I never bother with  the internals of the data dictionary) having
 problems while being restructured. Once the tables were changed from 40K
 to 500M
 extents the upgrade took less than 2 hours.
 
 One of the suggestions I did not use was to edit sql.bsq to provide much
 larger
 extents for the table holding the extent info. Even though I do this for
 the SOURCE$ table I am a big fan of the KISS principle and rebuilding
 the tables 
 needed to be done anyways.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Wiegand, Kurt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[Mark Leith]

Why doesn't somebody get smart and post this to a web site somewhere, post
the link to the list and everybody can have a free for all?

Sounds good to me - as I wouldn't mind a copy of this myself.

Any takers? If not - send it to me and I'll post it (unlinked) on to the
cool-tools site for the list..

Cheers

Mark

-Original Message-
Karadeniz
Sent: 24 January 2002 11:25
To: Multiple recipients of list ORACLE-L


If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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: 

Re: Backup Strategy

[C.S.Venkata Subramanian]

Hi All,

 http://www.geocities.com/tbcox23/

Go here and get the paper.

Regards
Venkat
--

On Thu, 24 Jan 2002 03:25:17  
 Bunyamin K. Karadeniz wrote:
If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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.com
  --
  Author: grace
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To 

Start - end time of procedure

[Roland . Skoldblom]

Hallo,

any one who canhelp me?

How can I find out which time a pl/sql procedure starts and which time it ends?(Ends 
by any reason at all).


Thanks in advance


Roland



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Access to Oracle

[Roland . Skoldblom]

Anyone who can help me with this:

I have  a Microsoft routin, whic calls oracle procedure in database servername, 
which have a databaselink to other databases(located on computers with Linux 
system).That procedure is supposed to pick up  data from tables which exist in the 
other
databases. It works fine when I run the oracle procedure from oracle, but when I make 
the call from oracle I get the following error message:

Why doesnt this work. If I make an ordinary call to rhe database servername and just 
picks data from the same database then it is no problem at all.


SQLCODE = -2041
SQLERRM = ORA-02041 client database did not begin a transaction

the query that is executed is: SELECT TABLE_NAME FROM [EMAIL PROTECTED] WHERE 
TABLE_NAME='ICA_ARTIKEL' AND OWNER='A111640'
and that doesnt seem so strange to me.

I  can run this query separately from oracle too but when i run it from Access 
application(by the call) then I get the errormessage according above.

Really appreciate if anyone could help me with this.

Thanks in  advance

Roland

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Eval copy of 91

[kjanusz]

Joe:

I belong to OTN and tried that route.  But I only have 
a regular speed phone line and it would have taken 
about two weeks to download the three zip files.  So it 
was just easier to pay $39.95 plus shipping.  And I 
also get other tools and doc. in the CD Pack.

Ken
 Yes your PC melts down.
 
 my question is why would you purchase an eval copy when you can join 
 technet and download the latest version and play with it to your heart's 
 content(single user developer license)?
 
 
 joe
 
 
 [EMAIL PROTECTED] wrote:
 
  I have purchased an eval copy of 9i for my PC using XP 
  Prof.  The eval is for 30 days.  What happens at the 
  end of the eval period?  Does my PC melt, does the DB 
  lock up, or nothing?
  
  TIA, 
  
  Ken Janusz, CPIM
  
 
 
 -- 
 Joe Testa, Oracle DBA
 Want to have a good time with a bunch of geeks? Check out:
 http://www.geekcruises.com/standard_interface/future_cruises.html
 I'm presenting, when registering drop my name :)
 
 
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Start - end time of procedure

[Igor Neyman]

Create your custom procedure_audit table with the columns to store procedure
name and timestamp, and write into it in the very beginning and very end of
each procedure.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 8:00 AM


 Hallo,

 any one who canhelp me?

 How can I find out which time a pl/sql procedure starts and which time it
ends?(Ends by any reason at all).


 Thanks in advance


 Roland



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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Trace/Event Info

[Rachel Carmichael]

Um Jared dear it's not the admin directory, at least not on my
Solaris/8.1.6 box

$ORACLE_HOME/rdbms/mesg  is the correct directory :)


--- [EMAIL PROTECTED] wrote:
 If you have access to Oracle on a unix system, take a look at 
 $ORACLE_HOME/rdbms/admin/oraus.msg.
 
 Events 1 - 10999 are of interest here.  You may also note
 that it says they are for debugging Oracle.  As such you will 
 likely never find documentation for some of them.
 
 A few of them are documented in the file.
 
 Jared
 
 
 
 
 
 Walter K [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 01/23/02 06:50 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Trace/Event Info
 
 
 Howdy!
 
 Is a document available somewhere that explains the
 different trace levels and also the commonly used
 events for tracing? For instance, I know to use event
 10046 with level 4 to get the bind variable values in
 a trace, but why this particular combination of event
 and trace level? What are the different levels and how
 are they used? How are process state and system state
 dumps performed? I'm also interested in some info that
 explains how to interpret the various trace files that
 are produced, other than just looking for SQL in them.
 Etc...
 
 Thanks again!
 -w
 
 __
 Do You Yahoo!?
 Send FREE video emails in Yahoo! Mail!
 http://promo.yahoo.com/videomail/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Walter K
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: performance problem with partitioned table query.

[Igor Neyman]

Jessica,

It looks like your query has to deal with all 14 partitions, because the
column 'poid_id0', which your table partitioned on, is not in 'where'
clause.
That's why Oracle can not eliminate other (not populated) 13 partitions.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 23, 2002 6:15 PM


 Oracle 8.1.7.0.0

 table event_t range partitioned by column poid_id0. only 1 partition
called p_1 out of the 14 contains data. A query on event_t became
significantly slow after rows increase:

 select   poid_DB, poid_ID0, poid_TYPE, poid_REV, start_t, end_t, sys_descr
 from  event_t
 where event_t.end_t = :1 and event_t.end_t  :2 and
   event_t.poid_TYPE like :3 and (event_t.account_obj_ID0 = :4 and
   event_t.account_obj_DB = 1 ) order by event_t.end_t desc

 Rows Execution Plan
 ---  ---
   0  SELECT STATEMENT   GOAL: CHOOSE
   0   SORT (ORDER BY)
   0PARTITION RANGE (ALL) PARTITION: START=1 STOP=14
   0 TABLE ACCESS   GOAL: ANALYZED (BY LOCAL INDEX ROWID) OF
 'EVENT_T' PARTITION: START=1 STOP=14
   0  INDEX   GOAL: ANALYZED (RANGE SCAN) OF
'I_EVENT__ACCTOBJ_END_T' (NON-UNIQUE) PARTITION: START=1
  STOP=14

 Index I_EVENT__ACCTOBJ_END_T was created on event_t ( account_obj_id0,
end_t ) using LOCAL.
 Other 2 columns involved in the where clause have either only one distinct
value or a few. So are not indexed.
 column account_obj_id0 has 1 million unique values in event_t and remain
unchanged during the tests. when rows insert, average rows per
account_obj_id0 value increase as well.

 Trace shows always the same execution plan but elapsed time increased
enormously!
 I did 2 rounds of tests, every round I dropped and recreated event_t
empty:

 In test round 1:
 1.) inserted 1 million rows into event_t with same end_t value. Query
returned:
 call count   cpuelapsed   disk  querycurrent
rows
 --- --   -- -- -- --  
--
 Parse   23  0.02   0.09  0  0  0
0
 Execute156  0.02   0.29  0  0  0
0
 Fetch  156  0.14   1.09  8   2698  0
195
 --- --   -- -- -- --  
--
 total  335  0.18   1.47  8   2698  0
195

 2.) inserted ANOTHER 1.5 million rows into event_t with 10,000+ different
end_t values. Query returned:
 Parse   36  0.00   0.04  0  0  0
0
 Execute118  0.01   0.01  0  0  0
0
 Fetch  118  0.61  86.71   1385   5045  0
587
 --- --   -- -- -- --  
--
 total  272  0.62  86.76   1385   5045  0
587

 In test round 2:
 1.) inserted 1 million rows into event_t with same end_t value. Query
returned as round1 step 1.)

 2.) inserted ANOTHER 5 million rows into event_t with ANOTHER end_t value.
Query returned:
 Parse   40  0.00   0.11  0  0  0
0
 Execute139  0.02   0.12  0  0  0
0
 Fetch  139  0.25   4.66303   2868  0
761
 --- --   -- -- -- --  
--
 total  318  0.27   4.89303   2868  0
761

 3.) inserted ANOTHER 2 million rows into event_t with 12,000+ different
end_t values. Query returned:
 Parse   34  0.01   0.01  0  0  0
0
 Execute 97  0.00   0.06  0  0  0
0
 Fetch   97  0.58  89.93   1257   4260  0
614
 --- --   -- -- -- --  
--
 total  228  0.59  90.00   1257   4260  0
614


 In test round 1 elapsed time increased 60 times from 1 million to 2.5
million rows. In round 2 it increased 3 times from 1 to 6 million rows, and
18 times from 6 to 8 million rows. So #-of-rows in event_t is not the #1
convict for large physical reads. It's more likely the
#-of-different-end_t-values. Before I always thought that to an indexed
column the more different values the better. But what's going on in this
case? Am I missing anything?

 Top wait event in statspack report is 'db file sequential read'. oradebug
event 10046 shows 'db file sequential read' is waiting on object event_t.

 Thank you!

 Jessica Mao
 Portal Software, Inc.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jessica Mao
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing 

Re: Ang: Re: Ang: Re: PL/SQL procedure - error

[Joe Raube]

I believe you will need to code it into your procedure

i.e.

beginning of proc

get start time (via sql below)

do work

get end time


then either store the elapsed time somewhere, or print it out.

-Joe

--- [EMAIL PROTECTED] wrote:
 
 But which query asks for the start date of the procedure an dwhich
 selectstatement is to display th etime when th eprocedure starts.
 
 Roland
 
 
 
 
 
 [EMAIL PROTECTED]@fatcity.com den 2002-01-22 08:25 PST
 
 Sänd svar till [EMAIL PROTECTED]
 
 Sänt av:  [EMAIL PROTECTED]
 
 
 Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Kopia:
 
 
 Use SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS FROM dual;
 
 Rick
 
 
 
 Roland.Skoldb
 [EMAIL PROTECTED]   To: Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent by: cc:
 root@fatcity.Subject: Ang: Re:
 PL/SQL procedure - error
 com
 
 
 01/22/2002
 09:15 AM
 Please
 respond to
 ORACLE-L
 
 
 
 
 
 
 
 Thanks,
 
 and can you please tell me how to get hold of the time when the
 procedures
 starts and finishes.?
 
 Thanks in advance.
 
 
 Roland
 
 
 
 
 
 
 Pullikol Kumar [EMAIL PROTECTED]@fatcity.com den
 2002-01-22
 04:40 PST
 
 Sänd svar till [EMAIL PROTECTED]
 
 Sänt av:  [EMAIL PROTECTED]
 
 
 Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Kopia:
 
 
  hi  Roland
 
   Hope below code will help u,
 
 BEGIN
 p1;
 p2;
 p3;
 p4;
   COMMIT;
  EXCEPTION
  WHEN OTHERS THEN
   ROLLBACK;
 END;
 
 procedure p1
 is
 BEGIN
  insert into aa values (1,'1');
 END;
 procedure p2
 is
 BEGIN
  insert into aa values (2,'2');
 END;
 procedure p3
 is
 BEGIN
  insert into aa values (3,'3');
 END;
 
 procedure p4
 is
 BEGIN
  insert into aa values (4,'4');
 END;
 
 Nitheesh
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Pullikol Kumar
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists


 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.com
 --
 Author:
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists


 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.com
 --
 Author:
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists


 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.com
 --
 Author:
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists


 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet 

webdba from BMC

[Jeffrey Beckstrom]

I was looking at their site today and came across a free product called 
WEBDBA. Any opinions on it.



Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

RE: multiple extents are OK, dagnabbit!

[A. Bardeen]

Kurt,

If you're on 8.1.6.3, 8.1.7.0.0 or 8.1.7.1.0  this
sounds suspiciouslly like either bug 1640583 or bug
1397603, both of which are fixed in 8.1.7.2+

The workaround for bug 1397603 is to set
_db_handles_cached = 0 in the init.ora.

HTH,

-- Anita

--- Wiegand, Kurt [EMAIL PROTECTED] wrote:
 Sorry Jeremiah, I don't have a clue...
 
 got the same error (after the same 2 hours) after
 purging the 
 shared pool; there was no activity at all on the
 database, so
 I thought about increasing the size of the shared
 pool (~10.5MB)
 but had a need, and the option, of simply replacing
 the database
 with a backup.
 
 SQL alter tablespace USR2 coalesce
 *
 ERROR at line 1:
 ORA-04031: unable to allocate 4180 bytes of shared
 memory (shared
 pool,unknown object,sga heap,state objects)
  
  
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 11:56 AM
 To: Multiple recipients of list ORACLE-L
 
 
 On Tue, 22 Jan 2002, Wiegand, Kurt wrote:
 
  sort of on the subject.I once had a table with
 ~88000 extents
  (most 1 block!)  it took 8 hours to delete and a
 subsequent coalesce
  ran for 2 hours before failing as it ran out of
 shared
  memory(8.1.5).
 
 Kurt,
 
 What component of the SGA becomes exhausted by a
 long-running
 coalesce?
 
 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton
 
  -Original Message-
  Sent: Tuesday, January 22, 2002 11:55 AM
  To: Multiple recipients of list ORACLE-L
  
  The problem arose in the catalog upgrade script.
 It would never
  return. My diary says we let one attempt run for
 36 hours. The process 
  showed CPU usage and I/O but nothing happened.
 Some of the Oracle guys 
  figured the problem was with the $fet (or whatever
 tables hold the
  extent
  info, I never bother with  the internals of the
 data dictionary) having
  problems while being restructured. Once the tables
 were changed from 40K
  to 500M
  extents the upgrade took less than 2 hours.
  
  One of the suggestions I did not use was to edit
 sql.bsq to provide much
  larger
  extents for the table holding the extent info.
 Even though I do this for
  the SOURCE$ table I am a big fan of the KISS
 principle and rebuilding
  the tables 
  needed to be done anyways.
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Jeremiah Wilton
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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.com
 -- 
 Author: Wiegand, Kurt
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Start - end time of procedure

[G . Plivna]

If you run procedure from SQLPlus then you can use option set time (or
timing, didn't remember) on and simply count the difference

If you need this info inside the procedure
then just simply in the fisrt line of procedure remember the start time in
some variable either from sysdate or dbms_utilty.get_time

and (surprise, surprise :-) in the last line of procedure get end time
and calculate the difference

Exact implementation is up to You...

Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/



   
 
Roland.Skoldbl 
 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Start - end time of procedure
 
om 
 
   
 
   
 
2002.01.24 
 
15:00  
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hallo,

any one who canhelp me?

How can I find out which time a pl/sql procedure starts and which time it
ends?(Ends by any reason at all).


Thanks in advance


Roland



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Connecting INGRES using database link

[Jenner Mike]

Holly,
I subscribe to the [EMAIL PROTECTED] ingres dba list. I can't find
out how you can subscribe though, sorry! (no, It's not in any trailer or
signature) Maybe a search engine will find something.
It's fairly low traffic compared to this list but there are some
peeps who know their ingres stuff (unlike me).

- Mike.

-Original Message-
Sent: 24 January 2002 03:55
To: Multiple recipients of list ORACLE-L


Dear Bambi,
Unfortunatly, 10 years ago I still a kid.. ^_^
Did you know any web site/mailing list/or other resources relate with
this problem (INGRES), so I can solve this problem?

Thanks in advance

Holly

-Original Message-
Sent: Thursday, January 24, 2002 1:02 AM
To: Multiple recipients of list ORACLE-L


Golly, that looks an awful lot like VMS.  I think what it's trying to
tell
you is that the node you specified is not reachable, or that the SID
you've
specified is not on the node listed.  There's some kind of connection
problem there.  Try doing a select from the Ingres side over the
connection.
If it works, I don't know what to tell you.  If it fails, drop and
recreate
the connection string.

The important thing is that this error is NOT an Oracle error... it is a
wrapper around what it's getting from the Ingres side... and it looks
for
all the world like it's not purely an Ingres error either.  That E_ is
a
VMS level error (W would be warning, F would be fatal).
Unfortunately,
I've been largely off of VMS since 93, so I'm not going to be able to
help a
lot there either.

Wish you would have asked this question about 10 years ago...  ;)
Bambi.

-Original Message-
Sent: Tuesday, January 22, 2002 9:05 PM
To: Multiple recipients of list ORACLE-L

thank you Bambi.

I already tried to create database link using HSODBC, but failed. It
returned this messages :

==
SQL select * from cond@hsodbc;
select * from cond@hsodbc
 *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES
driver][INGRES]E_LQ0001 Failed to connect to DBMS session.
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GC0132 -- User provided a vnode as part of the
database name (vnode::dbname), but connection information for that vnode
i (SQL State: S1000; SQL Code: -38100)
ORA-02063: preceding 6 lines from HSODBC

==
Is someone familiar with this kind of error...

TIA,

Holly

-Original Message-
Sent: Wednesday, January 23, 2002 4:20 AM
To: Multiple recipients of list ORACLE-L


Holly --

It has been a long time since I have done Oracle and Ingres at the same
time
(about 12 years (Oracle v6/Ingres v5)).  Back then, while there was
kinda-sorta ODBC to and from both Oracle and Ingres, they weren't able
to
access each other directly.  Generally, data transfers were to and from
flat
files, and queries between objects in the two databases utilized a third
party tool (Passport).

HTH,
Bambi.

-Original Message-
Sent: Monday, January 21, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L

Dear all,
Can I create database link using generic connectivity (ODBC)? Was there
someony already try this?
I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on
VAX/VMS.

TIA,

Holly
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ahmadsyah Alghozi Nugroho
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Ahmadsyah Alghozi Nugroho
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 

Re: Start - end time of procedure

[Ruth Gramolini]

Put some extra statements like 'select to_char(sysdate,'mmddyy hh24:mi:ss')
from dual;' in you code at the beginning and end of the procedure.

HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 8:00 AM


 Hallo,

 any one who canhelp me?

 How can I find out which time a pl/sql procedure starts and which time it
ends?(Ends by any reason at all).


 Thanks in advance


 Roland



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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SCOTT/TIGER

[Babich , Sergey]

Obviously, that was Scott's sYster... And she had to change after installing
Oracle on some dirty boxes...

 -Original Message-
Sent:   Wednesday, January 23, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SCOTT/TIGER

So who was SYS, and why on earth did s/he name his/her pet
CHANGE_ON_INSTALL???

:-)

 [EMAIL PROTECTED] 24/1/2002 12:00:27 
This message has been scanned by MAILSweeper.


The name I was given is Scott Gossett.  My team leader and one 
of our team members took the advanced seminars last year, and 
their instructor was Scott, and he admitted his notoriety.

-Original Message-
Sent: Wednesday, January 23, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L


there are several instructors named Scott how do you know which one
it is or even if it's one of the instructors?


--- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
 Ok...it's true.  Take the Oracle Technical seminars and you too may
 get to meet Scott, Live and In Person.  Unfortunately, Tiger is
 waiting
 for Scott at the Rainbow Bridge, but Scott is still there (at least
 he was last year...you know how Oracle's been lately).
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 10:26 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I was once told with certainty from an Oracle instructor that Scott
 was
 an early developer, and Tiger was his cat.  But without actually
 meeting
 Scott I take this with a grain of salt.  I expect there are many
 urban
 legends surrounding this.  
 
 Jim
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 11:45 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Anyone out there know the history of this?
 -- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Babich , Sergey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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[2]: How to calculate Last and First Day of Month?

[dgoulet]

Hey Folks,

The function last_day is there to handle all of that stuff, if you'll RTFM. 
Then using that and adding 1 day will always give you the first day of the next
month without all of that substringing stuff.  

Sheesh, maybe we need a new 'obfuscated sql' contest again?  Like who can
come up with the most obscene way of calculating the 1st, or last, of the
current month from sysdate.

Dick Goulet

PS: actually the answers could be very interesting.

Reply Separator
Author: Stephane Faroult [EMAIL PROTECTED]
Date:   1/23/2002 1:31 PM

Charlie Mengler wrote:
 
 I would have thought that the first day of the month
 is ALWAYS the 1st, as in 1 (ONE)!
 
 Please explain why it needs to be calculated or
 could be a value other than ONE.
 
 
   [EMAIL PROTECTED] 01/23/02 10:35AM 
  Hey guys,
 
  I know this is propablby easy, but I'm a bit
  overwhelmed here this week. Can you please tell me how
  to get first and last days of the month given SYSDATE?
 
  thanks a lot
 
  Regards
 

Another case of 'On what day does Xmas fall this year? - on December
25th'.

I think that using the TRUNC() function with the suitable parameter must
help you truncate SYSDATE to the first day of the month - perhaps
TRUNC(SYSDATE, 'MM') or similar (too tired to RTFM). Then TO_CHAR with
the suitable format should return whatever you want.
For the last day, I presume that identifying the first day of the NEXT
month and substracting 1 must simplify the 'is this 30/31/28/29'
question.
-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: webdba from BMC

[Smith, Ron L.]

I tried it and although it was very neat it was way too slow.
 
Ron Smith

-Original Message-
Sent: Thursday, January 24, 2002 8:05 AM
To: Multiple recipients of list ORACLE-L


I was looking at their site today and came across a free product called
WEBDBA.  Any opinions on it.
 
 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: How to calculate Last and First Day of Month?

[Viktor]

Thanks to Jared and others for a quick assistance.

Regards,

Viktor

--- [EMAIL PROTECTED] wrote:
 Well, yes the first day of the month is always 1.
 
 Representing it as the first day of the current
 month requires
 you to use the SYSDATE function. 
 
 Returning the first day of the month can be done in
 several
 ways, some more reasonable than others.
 
 there's the new to SQL basic programmer DBA wannabe
 method:
 
 select
substr(to_char(sysdate,'MM/DD/'), 1,2) ||
'/01/' ||
substr(to_char(sysdate,'MM/DD/'), 7)
 from dual;
 
 There's the slightly better:
 
 select
to_date(to_char(sysdate,'MM') ||
 '01','MMDD')
 from dual;
 
 The obtuse date math method ( my favorite ):
 
 select
last_day(add_months(sysdate,-1))+1
 from dual;
 
 ( there are several variations on this method )
 
 A little RTFM will reveal a much cleaner method:
 
 select
trunc(sysdate,'mm')
 from dual;
 
 So, the answer is always 1, but there is more than
 one way to get there.
 
 Jared
 SA, OCP, and Part Time Perl Evangelist
 
 
 
 
 
 
 
 
 
 Charlie Mengler [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 01/23/02 12:59 PM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Re: How to calculate Last
 and First Day of Month?
 
 
 I would have thought that the first day of the
 month
 is ALWAYS the 1st, as in 1 (ONE)!
 
 Please explain why it needs to be calculated or 
 could be a value other than ONE.
 
  
   [EMAIL PROTECTED] 01/23/02 10:35AM 
  Hey guys,
  
  I know this is propablby easy, but I'm a bit
  overwhelmed here this week. Can you please tell me
 how
  to get first and last days of the month given
 SYSDATE?
  
  thanks a lot
  
  Regards
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Charlie Mengler
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Hello 

Nope to your NOPE.

This is the site. Checked it just now with one of our magic developers.
It is a RAD tool and it works also on wintel machines (maybe more, I do not
know).
If you want some more info contact me directly and I will be happy to
assist.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Shreeni [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 24, 2002 2:00 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Magic
 
 Nope, the MAGIC I want to know is the one developed by some Isroil
 Technologies or somesuch  The one by magicsoftware is RAD for Linux.
 
 Shreenivasa Rao
 e-Zing Technologies, Inc..
 41-43 Beekman Street, 3rd Floor
 New York, NY 10038.
 Tel: (212)233-9861 xt.241
 Fax: (212)233-9862
 Cell:(917)861-4966
 [EMAIL PROTECTED] 
 ***
 **Your IT Solutions Provider
 *** *** http://www.e-zingtech.com  ***
 Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail
 can
 not be considered spam as long as we include contact information and a
 remove link for removal from our mailing list. To be removed from our
 mailing list reply with remove in the subject heading and your email
 address in the body. Include complete address and/or domain to be
 removed.
 
 
 
 
 -Original Message-
 Benjamins
 Sent: Wednesday, January 23, 2002 1:35 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Magic is a RAD development tool
 
 see: http://www.magicsoftware.com
 
 
 - Original Message - 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, January 22, 2002 10:57 PM
 
 
  
  Hi Guys/Gals
  
  Anybody tell me about what Magic 7.0 is all about ?? I know for sure
 it
  is something to large Data loads ?? Please enlighten.  Google/Lycos
  didnt turnup anything useful either except for Pwoer Quest's Partition
  Magic 7.0 :)
  
  Shreeni
  
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jan Benjamins
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  File:
 Shreenivasa Rao.vcf  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Searching Inside CLOBs

[sundeep maini]

Our developers store XML docuements inside CLOBS and
want to search the CLOB contents based on a search
string. I have lot of concern about such queries but
could benefit from someone on the list who has already
solved the performnce issues with such searches.

Typical existing queries I have come across are:

Select columns
  FROM list of tables
 WHERE join conditions
   AND UPPER(tab1.varcharcol) LIKE '%:in_string%'
   OR  UPPER(tab2.varcharcol) LIKE '%:in_string%'
   OR  . 
   OR  dbms_lob.instr(lobcol,:in_string,1,1)  0;

Note: 

in_string is always upper case but the columns are 
Concerns:

1. Poor index selection due to UPPER 
2. CLOB searches are obviously wrong. To do a mixed
case string match one needs to read chunks of the lob
in a user defined function of some sort, convert it to
upper and then do string matches. Any tips on this
one?



=

Sundeep Maini 
Consultant 
Currently on Assignement at Marshfield Clinic WI 
[EMAIL PROTECTED] 

__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sundeep maini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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:Eval copy of 91

[dgoulet]

Ken,

To Oracle's good and bad, no nothing will happen.  For a number of years now
Oracle has allowed us (the user community) to experiment with their software for
nothing as long as that tinkering only results in understanding of how the
software works and it's potential applications.  Once you really start making
use of it, they expect you to pay for it which is only fair.  Now in your case,
if all your doing is tinkering/experimenting fine.  Start using it to track your
collection of CD's and you owe someone.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   1/23/2002 7:15 PM

I have purchased an eval copy of 9i for my PC using XP 
Prof.  The eval is for 30 days.  What happens at the 
end of the eval period?  Does my PC melt, does the DB 
lock up, or nothing?

TIA, 

Ken Janusz, CPIM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SCOTT/TIGER

[Rachel Carmichael]

Well, Scott Gossett has certainly been with Oracle a long time, he
definitely teaches the advanced seminars (take them if you can), he's
one of the best instructors with Oracle University (and for the other
instructors I know that haunt this list, please note one of -- you
guys are great as well)

I'll have to ask him the next time I talk to him.


Rachel

--- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
 The name I was given is Scott Gossett.  My team leader and one 
 of our team members took the advanced seminars last year, and 
 their instructor was Scott, and he admitted his notoriety.
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 4:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 there are several instructors named Scott how do you know which
 one
 it is or even if it's one of the instructors?
 
 
 --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
  Ok...it's true.  Take the Oracle Technical seminars and you too may
  get to meet Scott, Live and In Person.  Unfortunately, Tiger is
  waiting
  for Scott at the Rainbow Bridge, but Scott is still there (at least
  he was last year...you know how Oracle's been lately).
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 10:26 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I was once told with certainty from an Oracle instructor that Scott
  was
  an early developer, and Tiger was his cat.  But without actually
  meeting
  Scott I take this with a grain of salt.  I expect there are many
  urban
  legends surrounding this.  
  
  Jim
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 11:45 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Anyone out there know the history of this?
  -- 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

8.1.7.2.5 interMedia Text Slow Sync

[Jack C. Applewhite]

We are experiencing very slow interMedia Text resyncs ( CTX_DDL.Sync_Index )
under 8.1.7.2.5 on Win2k Server.

We upgraded from 8.1.6.0.0 to 8.1.7.2.5 earlier this month (both under Win2k
Server) on essentially the same hardware.  We used to see about 700-2000
CLOB documents per second indexed under 8.1.6, but now see only about
400-800.  The low-high numbers relate to the size of the index being
sync'd - low just before we roll out a monthly partition (total 2 million
CLOBs), high just after (total 1 million CLOBs).

Query performance is better under 8.1.7 - partly because I spread the
DR$$I table across 3 drives.  By the looks of the I/O pattern, I should
spread DR$$X (the index on DR$$I table) across 2 or 3 drives as well.

Anybody have any words of wisdom as to what I can do to speed things up?

BTW, I'm curious at how 8.1.7 balances I/O.  While it's writing to the
DR$$X segment, it doesn't write to the online redo logs - it waits until
it's reading from DR$$X segment before it writes to the redo logs.  I
wonder why it doesn't do the writes to redo in parallel with the writes to
DR$$X.

Thanks.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Re: Ang: Re: PL/SQL procedure - error

Just put the select before the activation of each procedure in your program 
  and after the last one:
BEGIN
SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS') FROM dual;
p1;
SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS') FROM dual;
p2;
SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS') FROM dual;
p3;
SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS') FROM dual;
p4;
SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS') FROM dual;
  COMMIT;
 EXCEPTION
 WHEN OTHERS THEN
  ROLLBACK;
END;



Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 24, 2002 3:00 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Ang: Re: Ang: Re: PL/SQL procedure - error
 
 
 But which query asks for the start date of the procedure an dwhich
 selectstatement is to display th etime when th eprocedure starts.
 
 Roland
 
 
 
 
 
 [EMAIL PROTECTED]@fatcity.com den 2002-01-22 08:25 PST
 
 Sänd svar till [EMAIL PROTECTED]
 
 Sänt av:  [EMAIL PROTECTED]
 
 
 Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Kopia:
 
 
 Use SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS FROM dual;
 
 Rick
 
 
 
 Roland.Skoldb
 [EMAIL PROTECTED]   To: Multiple recipients of
 list ORACLE-L [EMAIL PROTECTED]
 Sent by: cc:
 root@fatcity.Subject: Ang: Re: PL/SQL
 procedure - error
 com
 
 
 01/22/2002
 09:15 AM
 Please
 respond to
 ORACLE-L
 
 
 
 
 
 
 
 Thanks,
 
 and can you please tell me how to get hold of the time when the procedures
 starts and finishes.?
 
 Thanks in advance.
 
 
 Roland
 
 
 
 
 
 
 Pullikol Kumar [EMAIL PROTECTED]@fatcity.com den 2002-01-22
 04:40 PST
 
 Sänd svar till [EMAIL PROTECTED]
 
 Sänt av:  [EMAIL PROTECTED]
 
 
 Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Kopia:
 
 
  hi  Roland
 
   Hope below code will help u,
 
 BEGIN
 p1;
 p2;
 p3;
 p4;
   COMMIT;
  EXCEPTION
  WHEN OTHERS THEN
   ROLLBACK;
 END;
 
 procedure p1
 is
 BEGIN
  insert into aa values (1,'1');
 END;
 procedure p2
 is
 BEGIN
  insert into aa values (2,'2');
 END;
 procedure p3
 is
 BEGIN
  insert into aa values (3,'3');
 END;
 
 procedure p4
 is
 BEGIN
  insert into aa values (4,'4');
 END;
 
 Nitheesh
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Pullikol Kumar
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 --
 Author:
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 --
 Author:
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an 

Re: Backup Strategy

[Jan Pruner]

http://www.sun.com/storage/white-papers/backup-planning.html

JP

On Thursday 17 January 2002 18:26, you wrote:
 Hi List,
 I have a white paper for Backup Strategy on Microsoft NT but I am looking
 for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or
 link I realy appreciate.




 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987

 The information contained in this message and any attachments is intended
 only for the use of the individual or entity to which it is addressed, and
 may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
 disclosure under applicable law. If you have received this message in
 error, you are prohibited from copying, distributing, or using the
 information. Please contact the sender immediately by return e-mail and
 delete the original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fwd: Re: Backup Strategy

[Jan Pruner]

http://www.stormgt.org/white.html

JP

On Thursday 17 January 2002 18:26, you wrote:
 Hi List,
 I have a white paper for Backup Strategy on Microsoft NT but I am looking
 for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or
 link I realy appreciate.




 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987

 The information contained in this message and any attachments is intended
 only for the use of the individual or entity to which it is addressed, and
 may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
 disclosure under applicable law. If you have received this message in
 error, you are prohibited from copying, distributing, or using the
 information. Please contact the sender immediately by return e-mail and
 delete the original message from your system.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORACLE-L Digest -- Volume 2002, Number 023

[Mohan, Ross]

ARE YOU AN IDIOT?

-Original Message-
Sent: Wednesday, January 23, 2002 3:21 PM
To: Multiple recipients of list ORACLE-L


??

ORACLE-L Digest -- Volume 2002, Number 023
 --
 
  From: [EMAIL PROTECTED]
  Date: Tue, 22 Jan 2002 11:00:47 -0800
  Subject: RE: Yet Another Off Topic Discussion
 
 VGhhbmsgeW91LiAgOikNCg0KSmFyZWQNCg0KDQoNCg0KDQrXkNeT16gg15nXl9eZ15DXnCA8YW
 Rh
 cnlAbWVoaXNoLmNvLmlsPg0KU2VudCBieTogcm9vdEBmYXRjaXR5LmNvbQ0KMDEvMjIvMDIgMD
 U6
 MzAgQU0NClBsZWFzZSByZXNwb25kIHRvIE9SQUNMRS1MDQoNCiANCiAgICAgICAgVG86ICAgIC
 BN

... snipped several hundred lines of encoded stuff

 5j
 bHVkZSBhIGxpbmUgY29udGFpbmluZzogVU5TVUIgT1JBQ0xFLUwNCihvciB0aGUgbmFtZSBvZi
 Bt
 YWlsaW5nIGxpc3QgeW91IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4gIFlvdSBtYXkNCmFsc2
 8g
 c2VuZCB0aGUgSEVMUCBjb21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3
 Jp YmluZykuDQoNCg0KDQo=
 
 
 --
 


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Henry Poras]

#   Script for analyzing Oracle Trace files with WAIT statistics
#   Usage:  wait_scan.awk filename
#   Written:Henry Poras
#   5/16/00
#   Modified:   12/3/01 Initially assumes all wait states for a
cursor are between
#   parse statements.
#
#
nawk'
# need nawk, not awk
BEGIN   {N=
 PARSE_FLAG=0
# PARSE_FLAG = 0 (normal state)
 printf(\n\n%-35s %-12s %-18s\n\n,
# PARSE_FLAG = 1 (previous line PARSING)
WAIT EVENT, # OF TIMES, ELAPSED TIME (sec))
# print column headers 
}

{if (PARSE_FLAG==1)
# if previous line started
{SQL[N]=$0
# with PARSING, print 
 PARSE_FLAG=0
# the SQL. 
 N=

}

}

/^PARSING/  {FS= 
 N=$4
 sub(#,,N)
 if (N in SQL)
prinfo(N)
 PARSE_FLAG=1
}
/^WAIT/ {FS=#| nam=|ela=|p1=
 N=$2
 sub(:,,N)
 PARSE_FLAG=2
 n_wait[N,$3] += 1
 ela_wait[N,$3] += $4
}   
END {for (N in SQL)  {
# Print Wait statistics for final
printf \n\n\n%s\n\n, SQL[N]
# SQL statement in file
for (k in n_wait) {
 split(k,arg,SUBSEP)
 if (arg[1]==N  n_wait[k]!=0) {
printf %-35s %-12s %12.2f\n,
arg[2],n_wait[k],ela_wait[k]/100
n_wait[k]=0
ela_wait[k]=0
 }
}   
 printf \n\n
}
for (k in n_wait) {
split(k,arg,SUBSEP)
if (n_wait[k] != 0) {
printf %-35s %-12s %12.2f\n,
arg[2],n_wait[k],ela_wait[k]/100
n_wait[k]=0
ela_wait[k]=0
}
}
}

function prinfo(N,   k) {
printf \n\n\n%s\n\n, SQL[N]
for (k in n_wait){
split(k,arg,SUBSEP)
if (arg[1]==N  n_wait[k]!=0) {
printf %-35s %-12s %12.2f\n,
arg[2],n_wait[k],ela_wait[k]/100
n_wait[k]=0
ela_wait[k]=0
}
}   
}
' $1

-Original Message-
Sent: Wednesday, January 23, 2002 1:56 PM
To: Multiple recipients of list ORACLE-L


Hi, Henry,
Please, post it. I am terribly sorry for asking dumb questions, but hey!
I've come a long way to be a part of this country, learned the language,
become a DBA and proud of it! Time to learn! Thanks a bunch in advance!

Sincerely,
Sergey

 -Original Message-
Sent:   Wednesday, January 23, 2002 1:02 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

Couldn't hurt. Also why not do some deltas of your session statistics
(before and after snapshots)

Henry

PS: After you have the trace file, I put together an awk statement to sum up
the number and elapsed time of the wait states for each SQL statement. I can
post that if you would like. 

-Original Message-
Sent: Wednesday, January 23, 2002 11:21 AM
To: Multiple recipients of list ORACLE-L


Hi, Henry,
Since I didn't expect that to happen, I had just SQL trace turned on for
that particular session. Do you suggest entering
event=10046 trace name errorstack level 12 into init.ora?
Thanks,
Regards,
Sergey

 -Original Message-
Sent:   Wednesday, January 23, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

Sergey,
At what level did you trace?

Henry

-Original Message-
Sent: Wednesday, January 23, 2002 8:15 AM
To: Multiple recipients of list ORACLE-L


Thank you, guys, for your help, just got back to work. Unfortunately, it's
too late to run the query, but later on we'll run the OLTP again, and then
I'll do it and post the output. Currently I'm analyzing the trace file which
is about 130M (did not tkprof it yet), 

Oracle Names Server

[David Ehresmann]

I am looking under my \network\names folder and I don't see a namesini.sql
file.  Do you have to buy Oracle Names Server separate from Oracle?

David Ehresmann
Oracle DBA 8  8i OCP
MCI Worldcom
[EMAIL PROTECTED]
972.656.1015

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[Kimberly Smith]

I have a very simple NT backup strategy.  Move the database to Unix.

-Original Message-
Karadeniz
Sent: Thursday, January 24, 2002 3:25 AM
To: Multiple recipients of list ORACLE-L


If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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.com
  --
  Author: grace
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  

RE: SCOTT/TIGER

[Shaw John-P55297]

Back when I used GUPTA (now I think it's called Centura), those guys claimed
it was Bruce Scott (one of the co founders of Oracle) and the ever popular
cat .

-Original Message-
Sent: Thursday, January 24, 2002 7:51 AM
To: Multiple recipients of list ORACLE-L


Well, Scott Gossett has certainly been with Oracle a long time, he
definitely teaches the advanced seminars (take them if you can), he's
one of the best instructors with Oracle University (and for the other
instructors I know that haunt this list, please note one of -- you
guys are great as well)

I'll have to ask him the next time I talk to him.


Rachel

--- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
 The name I was given is Scott Gossett.  My team leader and one 
 of our team members took the advanced seminars last year, and 
 their instructor was Scott, and he admitted his notoriety.
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 4:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 there are several instructors named Scott how do you know which
 one
 it is or even if it's one of the instructors?
 
 
 --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
  Ok...it's true.  Take the Oracle Technical seminars and you too may
  get to meet Scott, Live and In Person.  Unfortunately, Tiger is
  waiting
  for Scott at the Rainbow Bridge, but Scott is still there (at least
  he was last year...you know how Oracle's been lately).
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 10:26 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I was once told with certainty from an Oracle instructor that Scott
  was
  an early developer, and Tiger was his cat.  But without actually
  meeting
  Scott I take this with a grain of salt.  I expect there are many
  urban
  legends surrounding this.  
  
  Jim
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 11:45 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Anyone out there know the history of this?
  -- 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Shaw John-P55297
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Inserting data from XML

[Schauss, Peter]

Is anyone actually using Oracle's XML parsing features?
I have an application where we will need to input data
which is being sent to us in XML format.  (Oracle version
8.1.x).  I'm interested to know if Oracle's XML tools
will give us any leverage.

Thanks,

Peter Schauss
Northrop Grumman Corporation
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Access to Oracle

[MacGregor, Ian A.]

Whose ODBC DRIVER are you using?  If it is Microsoft's ,go to the workaround options 
for the DSN; once there, turn of muti-threaded server support.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, January 24, 2002 4:55 AM
To: Multiple recipients of list ORACLE-L




Anyone who can help me with this:

I have  a Microsoft routin, whic calls oracle procedure in database servername, 
which have a databaselink to other databases(located on computers with Linux 
system).That procedure is supposed to pick up  data from tables which exist in the 
other
databases. It works fine when I run the oracle procedure from oracle, but when I make 
the call from oracle I get the following error message:

Why doesnt this work. If I make an ordinary call to rhe database servername and just 
picks data from the same database then it is no problem at all.


SQLCODE = -2041
SQLERRM = ORA-02041 client database did not begin a transaction

the query that is executed is: SELECT TABLE_NAME FROM [EMAIL PROTECTED] WHERE 
TABLE_NAME='ICA_ARTIKEL' AND OWNER='A111640'
and that doesnt seem so strange to me.

I  can run this query separately from oracle too but when i run it from Access 
application(by the call) then I get the errormessage according above.

Really appreciate if anyone could help me with this.

Thanks in  advance

Roland

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Re: Backup Strategy

[Nick Wagner]

Title: RE: Re: Backup Strategy





here is a pretty good one as well... The paper is on building a 24x7 database. 


http://www.quest.com/whitepapers/Building_WP.pdf




-Original Message-
From: Jan Pruner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 6:10 AM
To: Multiple recipients of list ORACLE-L
Subject: Fwd: Re: Backup Strategy



http://www.stormgt.org/white.html


JP


On Thursday 17 January 2002 18:26, you wrote:
 Hi List,
 I have a white paper for Backup Strategy on Microsoft NT but I am looking
 for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or
 link I realy appreciate.




 Hamid Alavi
 Office 818 737-0526
 Cell 818 402-1987

 The information contained in this message and any attachments is intended
 only for the use of the individual or entity to which it is addressed, and
 may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
 disclosure under applicable law. If you have received this message in
 error, you are prohibited from copying, distributing, or using the
 information. Please contact the sender immediately by return e-mail and
 delete the original message from your system.


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


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

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: Electrical background

[Mohan, Ross]

Is it natural for relays to hum?

-Original Message-

SO, what did you want?

Dick Goulet
Ancient Electronics Tech  tinkerer, Also certified relay NUT

Reply Separator
Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
Date:   1/23/2002 10:30 AM

Sorry folks, that went to the wrong list. I apologize.  We now return you to
your 
regularly scheduled Oracle discussion.


Matt Adams - GE Appliances - [EMAIL PROTECTED]

 -Original Message-
 From: Adams, Matthew (GEA, 088130) 
 
 
 Anybody got a EE or electronics background?
 I've got a question about relays.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Searching Inside CLOBs

[Joe Raube]

Read the fine docs on Technet on Intermedia text, as well as the
XML development kit.

-Joe

On Thu, 2002-01-24 at 10:20, sundeep maini wrote:
 Our developers store XML docuements inside CLOBS and
 want to search the CLOB contents based on a search
 string. I have lot of concern about such queries but
 could benefit from someone on the list who has already
 solved the performnce issues with such searches.
 
 Typical existing queries I have come across are:
 
 Select columns
   FROM list of tables
  WHERE join conditions
AND UPPER(tab1.varcharcol) LIKE '%:in_string%'
OR  UPPER(tab2.varcharcol) LIKE '%:in_string%'
OR  . 
OR  dbms_lob.instr(lobcol,:in_string,1,1)  0;
 
 Note: 
 
 in_string is always upper case but the columns are 
 Concerns:
 
 1. Poor index selection due to UPPER 
 2. CLOB searches are obviously wrong. To do a mixed
 case string match one needs to read chunks of the lob
 in a user defined function of some sort, convert it to
 upper and then do string matches. Any tips on this
 one?
 
 
 
 =
 
 Sundeep Maini 
 Consultant 
 Currently on Assignement at Marshfield Clinic WI 
 [EMAIL PROTECTED] 
 
 __
 Do You Yahoo!?
 Great stuff seeking new owners in Yahoo! Auctions! 
 http://auctions.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: sundeep maini
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[Rick_Cale]

I hope your customer is not a member!!!


   
  
Kimberly  
  
Smith To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
ksmith2@myfirscc: 
  
tlink.net Subject: RE: Backup Strategy
  
Sent by:   
  
[EMAIL PROTECTED]
  
m  
  
   
  
   
  
01/24/2002 
  
10:35 AM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




I have a very simple NT backup strategy.  Move the database to Unix.

-Original Message-
Karadeniz
Sent: Thursday, January 24, 2002 3:25 AM
To: Multiple recipients of list ORACLE-L


If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any
doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
   

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 

RE: Backup Strategy

[Mercadante, Thomas F]

Another NT-bigot!   Let's not get started on THIS again!  :)


-Original Message-
Sent: Thursday, January 24, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L


I have a very simple NT backup strategy.  Move the database to Unix.

-Original Message-
Karadeniz
Sent: Thursday, January 24, 2002 3:25 AM
To: Multiple recipients of list ORACLE-L


If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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.com
  --
  Author: grace
INET: [EMAIL PROTECTED]
 
  Fat 

RE: Inserting data from XML

[Grabowy, Chris]

Peter,

Send me your questions, I will forward them onto the developer that was/is
working on a Oracle project(s) parsing XML.  If you send me a specific set
of questions, then I'm sure he can find some time to answer them.

Thanks.

Chris
May Oracle be with you...always

-Original Message-
Sent: Thursday, January 24, 2002 10:00 AM
To: Multiple recipients of list ORACLE-L


Is anyone actually using Oracle's XML parsing features?
I have an application where we will need to input data
which is being sent to us in XML format.  (Oracle version
8.1.x).  I'm interested to know if Oracle's XML tools
will give us any leverage.

Thanks,

Peter Schauss
Northrop Grumman Corporation
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Names Server

[Molina, Gerardo]

Oracle Names Server is on Oracle CD but has to be explicitly selected on
installation.  You have to go with Management Server install (on later
versions).

Are you sure Oracle Names was installed?

I believe there is no extra license fee for Oracle Names.

Have you considered going with Oracle Internet Directory?  This is the
successor to Oracle Names.

HTH,
Gerardo

-Original Message-
Sent: Thursday, January 24, 2002 7:25 AM
To: Multiple recipients of list ORACLE-L


I am looking under my \network\names folder and I don't see a namesini.sql
file.  Do you have to buy Oracle Names Server separate from Oracle?

David Ehresmann
Oracle DBA 8  8i OCP
MCI Worldcom
[EMAIL PROTECTED]
972.656.1015

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Molina, Gerardo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Standby database foible

[Steve McClure]

Allright listers,

I have been experimenting with creating a standby database for our
production server.  After moving all the required files files, configuring
the init files, and initiating recovery on the standby instance, I saw the
following error.
01547:warning RECOVER succeeded but OPEN RESETLOGS would get error below.
01152:file 1 was not restored from a sufficiently old backup

So apparently I mucked up my SYSTEM tablespace somehow in the interim.  Here
are the steps I followed.  I am curious where I went wrong.

I twice started to bring up the standby database. both times I was able to
issue 'startup nomount'.  The first time I attempted to mount the standby
database I was greeted with a message that the control file I was pointing
to was not a standby control file.  I had used the control file from my hot
backup, instead of following my instructions.  So shutdown the DB 'shutdown
normal', and created a standby control file, copied it to the three control
file locations on my standby box, and started again.  'startup nomount' went
as expected, then I mounted the DB in stanby mode, and then issued the
recover command.  Upon this completing, I was greeted with the warning I
quoted above.

In writing this I am pretty sure that I screwed myself up by issuing a
'shutdown normal' after my first mount attempt failed, but I figured I would
go ahead and send this off to the list anyway.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

CHECKPOINT?

[Seema Singh]

Hi
When i check alert log the log switching normally between 20 min or 30 
minutes.But when I do truncate for big table.The chekcpoint started but not 
completed.I chekced the
background checkpoints completed  and background checkpoints started 
diffrence was high during truncate.
My redo log file size is 20m.I THINK i need to resize the redo log and 
increase the value of LOG_CHECKPOINT_INTERVAL parameter.
Please suggest me
-Seema


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: multiple extents are OK, dagnabbit!

[Rajesh . Rao]

On the topic, I once had a tablespace with 300,000+ free extents and 0 used
extents. We executed a drop tablespace command, and looking at fet$ and the
rate at which it was dropping extents from the table, we estimated it would
take us 64 hours. This was on a 7.3.4 db, and we thought it better to trash
the database, and recreate. That was much much faster ;-)

I once remember reading an artice at Jonathan Lewis site,  which basically
talked of stopping smon from coalescing, deleting all the rows from fet$
and adding one row for all the free extents. Of course, this was not
supported by Oracle. Did anyone from this list ever really try that? Just
curious.

Raj






Wiegand, Kurt [EMAIL PROTECTED]@fatcity.com on 01/24/2002 06:45:17
AM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


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


Sorry Jeremiah, I don't have a clue...

got the same error (after the same 2 hours) after purging the
shared pool; there was no activity at all on the database, so
I thought about increasing the size of the shared pool (~10.5MB)
but had a need, and the option, of simply replacing the database
with a backup.

SQL alter tablespace USR2 coalesce
*
ERROR at line 1:
ORA-04031: unable to allocate 4180 bytes of shared memory (shared
pool,unknown object,sga heap,state objects)



-Original Message-
Sent: Wednesday, January 23, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L


On Tue, 22 Jan 2002, Wiegand, Kurt wrote:

 sort of on the subject.I once had a table with ~88000 extents
 (most 1 block!)  it took 8 hours to delete and a subsequent coalesce
 ran for 2 hours before failing as it ran out of shared
 memory(8.1.5).

Kurt,

What component of the SGA becomes exhausted by a long-running
coalesce?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

 -Original Message-
 Sent: Tuesday, January 22, 2002 11:55 AM
 To: Multiple recipients of list ORACLE-L

The problem arose in the catalog upgrade script. It would never
 return. My diary says we let one attempt run for 36 hours. The process
 showed CPU usage and I/O but nothing happened. Some of the Oracle guys
 figured the problem was with the $fet (or whatever tables hold the
 extent
 info, I never bother with  the internals of the data dictionary) having
 problems while being restructured. Once the tables were changed from 40K
 to 500M
 extents the upgrade took less than 2 hours.

 One of the suggestions I did not use was to edit sql.bsq to provide much
 larger
 extents for the table holding the extent info. Even though I do this for
 the SOURCE$ table I am a big fan of the KISS principle and rebuilding
 the tables
 needed to be done anyways.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Wiegand, Kurt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SCOTT/TIGER

[Bellows, Bambi]

_ON_INSTALL was the name of Bruce Scott's mother-in-law's hedgehog... her
guppy, MANAGER, having olfactory powers beyond those of normal guppies,
would always get upset by the smell coming out of _ON_INSTALL's bin, and
would mouth Change _ON_INSTALL's bin litter!  But, you know, reading guppy
lips is a long and complicated affair, and Scott's mother-in-law's contact
lenses would fog up about half way through.  

Sheesh.  I thought this was in all the books.

HTH,
Bambi.

-Original Message-
Sent:   Wednesday, January 23, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SCOTT/TIGER

So who was SYS, and why on earth did s/he name his/her pet
CHANGE_ON_INSTALL???

:-)

 [EMAIL PROTECTED] 24/1/2002 12:00:27 
This message has been scanned by MAILSweeper.


The name I was given is Scott Gossett.  My team leader and one 
of our team members took the advanced seminars last year, and 
their instructor was Scott, and he admitted his notoriety.

-Original Message-
Sent: Wednesday, January 23, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L


there are several instructors named Scott how do you know which one
it is or even if it's one of the instructors?


--- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
 Ok...it's true.  Take the Oracle Technical seminars and you too may
 get to meet Scott, Live and In Person.  Unfortunately, Tiger is
 waiting
 for Scott at the Rainbow Bridge, but Scott is still there (at least
 he was last year...you know how Oracle's been lately).
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 10:26 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I was once told with certainty from an Oracle instructor that Scott
 was
 an early developer, and Tiger was his cat.  But without actually
 meeting
 Scott I take this with a grain of salt.  I expect there are many
 urban
 legends surrounding this.  
 
 Jim
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 11:45 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Anyone out there know the history of this?
 -- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Babich , Sergey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, 

RE: FW: Electrical background

[tday6]

Only when they don't know the words.



   

Mohan, Ross  

MohanR  To: Multiple recipients of list ORACLE-L  

@STARS-SMI.co[EMAIL PROTECTED]

m   cc:   

Sent by: rootSubject: RE: FW: Electrical background

   

   

01/24/2002 

10:15 AM   

Please 

respond to 

ORACLE-L   

   

   





Is it natural for relays to hum?

-Original Message-

SO, what did you want?

Dick Goulet
Ancient Electronics Tech  tinkerer, Also certified relay NUT

Reply Separator
Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
Date:   1/23/2002 10:30 AM

Sorry folks, that went to the wrong list. I apologize.  We now return you
to
your
regularly scheduled Oracle discussion.


Matt Adams - GE Appliances - [EMAIL PROTECTED]

 -Original Message-
 From: Adams, Matthew (GEA, 088130)


 Anybody got a EE or electronics background?
 I've got a question about relays.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Electrical background

[Khedr, Waleed]

Regular relays do not hum. If it does this means it's switching on and off
at certain frequency on which it's designed. Then it's not a relay it could
be one of these devices that convert DC to AC.

-Original Message-
Sent: Thursday, January 24, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L


Is it natural for relays to hum?

-Original Message-

SO, what did you want?

Dick Goulet
Ancient Electronics Tech  tinkerer, Also certified relay NUT

Reply Separator
Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
Date:   1/23/2002 10:30 AM

Sorry folks, that went to the wrong list. I apologize.  We now return you to
your 
regularly scheduled Oracle discussion.


Matt Adams - GE Appliances - [EMAIL PROTECTED]

 -Original Message-
 From: Adams, Matthew (GEA, 088130) 
 
 
 Anybody got a EE or electronics background?
 I've got a question about relays.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[JoJo Al-Zawawi]

They all suck!  Let's go back to using the abacus.

Hahaha!
--JoJo


-Original Message-
Thomas F
Sent: Thursday, January 24, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L


Another NT-bigot!   Let's not get started on THIS again!  :)


-Original Message-
Sent: Thursday, January 24, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L


I have a very simple NT backup strategy.  Move the database to Unix.

-Original Message-
Karadeniz
Sent: Thursday, January 24, 2002 3:25 AM
To: Multiple recipients of list ORACLE-L


If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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 

Upgrade 8.1.6 to 8.1.7

[Hamid Alavi]

Hi List,
I want to know what the routine for upgrading 8.1.6 to 8.1.7 on unix?
Any link or url or document will be grate.
Thanks ALL



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: multiple extents are OK, dagnabbit!

[Post, Ethan]

I hit 1397603 (think that was the one) and with it you completely lose
service to the database.  By the way, my understanding is that purging the
shared pool when you hit 4031 errors is not always going to solve the
problem because if there was SQL available to age out Oracle would do it.  I
run this query which will return the age of the SQL in the shared pool.
If you see 30-50% of the statements getting aged out within 10-30 minutes
and you have a high parse rate it might just be your shared pool is too
small to handle the load.  If you were stating that your shared pool was
going to be increased to 10.5 MB, that is very small.  By the time your data
dictionary et al. gets loaded there is not much room for SQL.  Check
V$SGASTAT for space used by SQL.  You can modify the SQL to round to a more
precise time period if you like.

- Ethan

select sql_statements, hours_in_pool,
round(sql_statements/total_statements*100,0) percent_of_total
from (
select 
   count(*) sql_statements, 
   round((sysdate-(to_date(first_load_time, '-mm-dd/hh24:mi:ss')))* 1440
/ 60,0)  hours_in_pool,
   total_statements
from 
   v$sqlarea a,
   (select count(*) total_statements from v$sqlarea) b
group by 
round((sysdate-(to_date(first_load_time, '-mm-dd/hh24:mi:ss')))* 1440 /
60,0),
total_statements)
where
round(sql_statements/total_statements*100,0)  0;

-Original Message-
Sent: Thursday, January 24, 2002 7:45 AM
To: Multiple recipients of list ORACLE-L


Kurt,

If you're on 8.1.6.3, 8.1.7.0.0 or 8.1.7.1.0  this
sounds suspiciouslly like either bug 1640583 or bug
1397603, both of which are fixed in 8.1.7.2+

The workaround for bug 1397603 is to set
_db_handles_cached = 0 in the init.ora.

HTH,

-- Anita

--- Wiegand, Kurt [EMAIL PROTECTED] wrote:
 Sorry Jeremiah, I don't have a clue...
 
 got the same error (after the same 2 hours) after
 purging the 
 shared pool; there was no activity at all on the
 database, so
 I thought about increasing the size of the shared
 pool (~10.5MB)
 but had a need, and the option, of simply replacing
 the database
 with a backup.
 
 SQL alter tablespace USR2 coalesce
 *
 ERROR at line 1:
 ORA-04031: unable to allocate 4180 bytes of shared
 memory (shared
 pool,unknown object,sga heap,state objects)
  
  
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 11:56 AM
 To: Multiple recipients of list ORACLE-L
 
 
 On Tue, 22 Jan 2002, Wiegand, Kurt wrote:
 
  sort of on the subject.I once had a table with
 ~88000 extents
  (most 1 block!)  it took 8 hours to delete and a
 subsequent coalesce
  ran for 2 hours before failing as it ran out of
 shared
  memory(8.1.5).
 
 Kurt,
 
 What component of the SGA becomes exhausted by a
 long-running
 coalesce?
 
 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton
 
  -Original Message-
  Sent: Tuesday, January 22, 2002 11:55 AM
  To: Multiple recipients of list ORACLE-L
  
  The problem arose in the catalog upgrade script.
 It would never
  return. My diary says we let one attempt run for
 36 hours. The process 
  showed CPU usage and I/O but nothing happened.
 Some of the Oracle guys 
  figured the problem was with the $fet (or whatever
 tables hold the
  extent
  info, I never bother with  the internals of the
 data dictionary) having
  problems while being restructured. Once the tables
 were changed from 40K
  to 500M
  extents the upgrade took less than 2 hours.
  
  One of the suggestions I did not use was to edit
 sql.bsq to provide much
  larger
  extents for the table holding the extent info.
 Even though I do this for
  the SOURCE$ table I am a big fan of the KISS
 principle and rebuilding
  the tables 
  needed to be done anyways.
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Jeremiah Wilton
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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.com
 -- 
 Author: Wiegand, Kurt
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 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 

RE: Session_wait

[Babich , Sergey]

Thanks a lot.
Regards,
Sergey


 -Original Message-
Sent:   Thursday, January 24, 2002 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

#   Script for analyzing Oracle Trace files with WAIT statistics
#   Usage:  wait_scan.awk filename
#   Written:Henry Poras
#   5/16/00
#   Modified:   12/3/01 Initially assumes all wait states for a
cursor are between
#   parse statements.
#
#
nawk'
# need nawk, not awk
BEGIN   {N=
 PARSE_FLAG=0
# PARSE_FLAG = 0 (normal state)
 printf(\n\n%-35s %-12s %-18s\n\n,
# PARSE_FLAG = 1 (previous line PARSING)
WAIT EVENT, # OF TIMES, ELAPSED TIME (sec))
# print column headers 
}

{if (PARSE_FLAG==1)
# if previous line started
{SQL[N]=$0
# with PARSING, print 
 PARSE_FLAG=0
# the SQL. 
 N=

}

}

/^PARSING/  {FS= 
 N=$4
 sub(#,,N)
 if (N in SQL)
prinfo(N)
 PARSE_FLAG=1
}
/^WAIT/ {FS=#| nam=|ela=|p1=
 N=$2
 sub(:,,N)
 PARSE_FLAG=2
 n_wait[N,$3] += 1
 ela_wait[N,$3] += $4
}   
END {for (N in SQL)  {
# Print Wait statistics for final
printf \n\n\n%s\n\n, SQL[N]
# SQL statement in file
for (k in n_wait) {
 split(k,arg,SUBSEP)
 if (arg[1]==N  n_wait[k]!=0) {
printf %-35s %-12s %12.2f\n,
arg[2],n_wait[k],ela_wait[k]/100
n_wait[k]=0
ela_wait[k]=0
 }
}   
 printf \n\n
}
for (k in n_wait) {
split(k,arg,SUBSEP)
if (n_wait[k] != 0) {
printf %-35s %-12s %12.2f\n,
arg[2],n_wait[k],ela_wait[k]/100
n_wait[k]=0
ela_wait[k]=0
}
}
}

function prinfo(N,   k) {
printf \n\n\n%s\n\n, SQL[N]
for (k in n_wait){
split(k,arg,SUBSEP)
if (arg[1]==N  n_wait[k]!=0) {
printf %-35s %-12s %12.2f\n,
arg[2],n_wait[k],ela_wait[k]/100
n_wait[k]=0
ela_wait[k]=0
}
}   
}
' $1

-Original Message-
Sent: Wednesday, January 23, 2002 1:56 PM
To: Multiple recipients of list ORACLE-L


Hi, Henry,
Please, post it. I am terribly sorry for asking dumb questions, but hey!
I've come a long way to be a part of this country, learned the language,
become a DBA and proud of it! Time to learn! Thanks a bunch in advance!

Sincerely,
Sergey

 -Original Message-
Sent:   Wednesday, January 23, 2002 1:02 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

Couldn't hurt. Also why not do some deltas of your session statistics
(before and after snapshots)

Henry

PS: After you have the trace file, I put together an awk statement to sum up
the number and elapsed time of the wait states for each SQL statement. I can
post that if you would like. 

-Original Message-
Sent: Wednesday, January 23, 2002 11:21 AM
To: Multiple recipients of list ORACLE-L


Hi, Henry,
Since I didn't expect that to happen, I had just SQL trace turned on for
that particular session. Do you suggest entering
event=10046 trace name errorstack level 12 into init.ora?
Thanks,
Regards,
Sergey

 -Original Message-
Sent:   Wednesday, January 23, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

Sergey,
At what level did you trace?

Henry

-Original Message-
Sent: Wednesday, January 23, 2002 8:15 AM
To: Multiple recipients of list ORACLE-L


Thank you, guys, for your help, just got back to work. Unfortunately, it's
too late 

RE: SCOTT/TIGER

[Rachel Carmichael]

not everyone here has read the docs, remember? :)


--- Bellows, Bambi [EMAIL PROTECTED] wrote:
 _ON_INSTALL was the name of Bruce Scott's mother-in-law's hedgehog...
 her
 guppy, MANAGER, having olfactory powers beyond those of normal
 guppies,
 would always get upset by the smell coming out of _ON_INSTALL's bin,
 and
 would mouth Change _ON_INSTALL's bin litter!  But, you know,
 reading guppy
 lips is a long and complicated affair, and Scott's mother-in-law's
 contact
 lenses would fog up about half way through.  
 
 Sheesh.  I thought this was in all the books.
 
 HTH,
 Bambi.
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 10:50 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: SCOTT/TIGER
 
 So who was SYS, and why on earth did s/he name his/her pet
 CHANGE_ON_INSTALL???
 
 :-)
 
  [EMAIL PROTECTED] 24/1/2002 12:00:27 
 This message has been scanned by MAILSweeper.
 
 
 The name I was given is Scott Gossett.  My team leader and one 
 of our team members took the advanced seminars last year, and 
 their instructor was Scott, and he admitted his notoriety.
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 4:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 there are several instructors named Scott how do you know which
 one
 it is or even if it's one of the instructors?
 
 
 --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
  Ok...it's true.  Take the Oracle Technical seminars and you too may
  get to meet Scott, Live and In Person.  Unfortunately, Tiger is
  waiting
  for Scott at the Rainbow Bridge, but Scott is still there (at least
  he was last year...you know how Oracle's been lately).
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 10:26 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I was once told with certainty from an Oracle instructor that Scott
  was
  an early developer, and Tiger was his cat.  But without actually
  meeting
  Scott I take this with a grain of salt.  I expect there are many
  urban
  legends surrounding this.  
  
  Jim
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 11:45 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Anyone out there know the history of this?
  -- 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 

**
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 
 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.
 
 www.mimesweeper.com

**
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Arn Klammer
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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.com
 -- 
 Author: Babich , Sergey
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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.com
 -- 
 Author: Bellows, Bambi
   INET: [EMAIL PROTECTED]
 
 Fat City Network 

Re: Trace/Event Info (iOraDumpReader)

[Danisment Gazi Unal (Unal Bilisim)]

Hello,

you can use itrprof (web based, and free) to analyze event10046 raw trace
files. The product is at
http://www.unal-bilisim.com/products/itrprof/itrprof.html.

I'm currently developing a new web based product named iOraDumpReader.
This tool will intreprete many Oracle trace files such as:

- control file dump
- file header dump
- redo header dump
- redo block dump
- data block dump
- rbs dump
- etc.

I'll lunch beta version next week.

regards...

Walter K wrote:

 Howdy!

 Is a document available somewhere that explains the
 different trace levels and also the commonly used
 events for tracing? For instance, I know to use event
 10046 with level 4 to get the bind variable values in
 a trace, but why this particular combination of event
 and trace level? What are the different levels and how
 are they used? How are process state and system state
 dumps performed? I'm also interested in some info that
 explains how to interpret the various trace files that
 are produced, other than just looking for SQL in them.
 Etc...

 Thanks again!
 -w

 __
 Do You Yahoo!?
 Send FREE video emails in Yahoo! Mail!
 http://promo.yahoo.com/videomail/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Walter K
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

--
Danisment Gazi Unal
http://www.unal-bilisim.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Symbian Mobile OS, OUI or non?

[Mohan, Ross]

Symbian?

http://www.symbian.com/technology/why-diff-os.html

Will Oracle Lite run on this? 

Will my relays stop humming?

Will Jeannie ever get back into that snappy little outfit from the Kasbah?

-Original Message-
Sent: Thursday, January 24, 2002 11:35 AM
To: Multiple recipients of list ORACLE-L


Another NT-bigot!   Let's not get started on THIS again!  :)


-Original Message-
Sent: Thursday, January 24, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L


I have a very simple NT backup strategy.  Move the database to Unix.

-Original Message-
Karadeniz
Sent: Thursday, January 24, 2002 3:25 AM
To: Multiple recipients of list ORACLE-L


If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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, 

RE: Trace/Event Info (iOraDumpReader)

[Mohan, Ross]

I'll lunch beta version next week.

||  eating your own dog food,eh?   Admirable!

-Original Message-
Sent: Thursday, January 24, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L


Hello,

you can use itrprof (web based, and free) to analyze event10046 raw trace
files. The product is at
http://www.unal-bilisim.com/products/itrprof/itrprof.html.

I'm currently developing a new web based product named iOraDumpReader.
This tool will intreprete many Oracle trace files such as:

- control file dump
- file header dump
- redo header dump
- redo block dump
- data block dump
- rbs dump
- etc.

I'll lunch beta version next week.

regards...

Walter K wrote:

 Howdy!

 Is a document available somewhere that explains the
 different trace levels and also the commonly used
 events for tracing? For instance, I know to use event
 10046 with level 4 to get the bind variable values in
 a trace, but why this particular combination of event
 and trace level? What are the different levels and how
 are they used? How are process state and system state
 dumps performed? I'm also interested in some info that
 explains how to interpret the various trace files that
 are produced, other than just looking for SQL in them.
 Etc...

 Thanks again!
 -w

 __
 Do You Yahoo!?
 Send FREE video emails in Yahoo! Mail!
 http://promo.yahoo.com/videomail/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Walter K
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

--
Danisment Gazi Unal
http://www.unal-bilisim.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[Bellows, Bambi]

JoJo --

Sure, but be aware that Unix abaci are better than NT abaci.

HTH,
Bambi.

-Original Message-
Sent: Thursday, January 24, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L

They all suck!  Let's go back to using the abacus.

Hahaha!
--JoJo


-Original Message-
Thomas F
Sent: Thursday, January 24, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L


Another NT-bigot!   Let's not get started on THIS again!  :)


-Original Message-
Sent: Thursday, January 24, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L


I have a very simple NT backup strategy.  Move the database to Unix.

-Original Message-
Karadeniz
Sent: Thursday, January 24, 2002 3:25 AM
To: Multiple recipients of list ORACLE-L


If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM


 Can you send me one (NT backup strategy)

 Regards,
 Ramesh D Papnoi
 Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
 (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
 http://www22.Brinkster.com/rpapnoi

 -- Original Text --

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

 Please send me one. (NT) Thank,

 grace wrote:
 
  can u also send me a copy on backup strategy on  nt.
  thanks
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, January 23, 2002 3:25 PM
 
   Hello Hamid
  
   I would like to have this paper as well.
   We are now revising our Backup strategy.
  
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
  
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 22, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Strategy
   
Hamid,
   
Would you be willing to forward a copy of
this paper?
   
Thanks,
   
Ross Mohan
   
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
   
   
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am
  looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc
or
link
I realy appreciate.
   
   
   
   
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
   
The information contained in this message and any attachments is
  intended
only for the use of the individual or entity to which it is
addressed,
  and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message
in
error,
you are prohibited from copying, distributing, or using the
information.
Please contact the sender immediately by return e-mail and delete
the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL 

Re: RE: FW: Electrical background

[sdlockhart]

Yes, especially if they don't know the words. :)

Scott Lockhart
Oracle DBA
I-Link
Draper, UT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fwd: Databases on Solaris: Online Forum Jan. 22-28

[Jared . Still]

Discuss Configuring  Tuning Databases on the Solaris[tm]
Platform 22-28 January 2002.  Join a special online
discussion forum with Sun engineer, Allan N. Packer, author
of Configuring  Tuning Databases on the Solaris[tm]
Platform.  Database professionals can take this opportunity
to ask questions relating to optimizing the performance and
cost-effectiveness of virtually any database application
running on the Solaris platform.

Learn more at:

http://www.sun.com/forums/disc-012202/



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Trace/Event Info (iOraDumpReader)

[Danisment Gazi Unal (Unal Bilisim)]

Hi,

I head meant 'launch'.

Mohan, Ross wrote:

 I'll lunch beta version next week.

 ||  eating your own dog food,eh?   Admirable!

 -Original Message-
 Sent: Thursday, January 24, 2002 1:39 PM
 To: Multiple recipients of list ORACLE-L

 Hello,

 you can use itrprof (web based, and free) to analyze event10046 raw trace
 files. The product is at
 http://www.unal-bilisim.com/products/itrprof/itrprof.html.

 I'm currently developing a new web based product named iOraDumpReader.
 This tool will intreprete many Oracle trace files such as:

 - control file dump
 - file header dump
 - redo header dump
 - redo block dump
 - data block dump
 - rbs dump
 - etc.

 I'll lunch beta version next week.

 regards...

 Walter K wrote:

  Howdy!
 
  Is a document available somewhere that explains the
  different trace levels and also the commonly used
  events for tracing? For instance, I know to use event
  10046 with level 4 to get the bind variable values in
  a trace, but why this particular combination of event
  and trace level? What are the different levels and how
  are they used? How are process state and system state
  dumps performed? I'm also interested in some info that
  explains how to interpret the various trace files that
  are produced, other than just looking for SQL in them.
  Etc...
 
  Thanks again!
  -w
 
  __
  Do You Yahoo!?
  Send FREE video emails in Yahoo! Mail!
  http://promo.yahoo.com/videomail/
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Walter K
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).

 --
 Danisment Gazi Unal
 http://www.unal-bilisim.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Danisment Gazi Unal (Unal Bilisim)
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 --
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

--
Danisment Gazi Unal
http://www.unal-bilisim.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Time Question

[Lance Prais]

I am not sure how to ask this or if it is even possible.  I have a stored
procedure that runs every five minutes and writes the data to a table.  I
want to query every thirty minutes and group the rows from the last half
our.

would I used date difference?


Thank you in advance
lance

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[bill thater]

[EMAIL PROTECTED] wrote:

JoJo --

Sure, but be aware that Unix abaci are better than NT abaci.

don't forget the VMS abaci.;-)



-- 
--
Bill Shrek Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

When you want to test the depths of a stream, don't use both feet.   - Chinese Proverb 






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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Time Question

[Jamadagni, Rajendra]

Select col_1, col_2
from my_table
where col_timestamp is between sysdate and (sysdate - 30/1440)
group by col_1

Assuming col_timestamp is a column in your table with datatype of DATE.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!



*1

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.

*1

Re: Oracle 9i installation Java RunTime Environment was not found.

[Neil Khot]

Hello Onder,

I have JRE Installed here is what I 
get 

$: java -versionjava version 
"1.3.0_02"Java(TM) 2 Runtime Environment, Standard Edition (build 
1.3.0_02)Java HotSpot(TM) Client VM (build 1.3.0_02, mixed 
mode)

There fore Java is 
installed.

I think this might have something to 
do with Oracle not able to create /tmp/Orainstall/jre/bin/jre on its own even 
thought there are enough permission and disk space.

Any help is appreciated


  Neil Khot

  - Original Message - 
  From: 
  E.Onder 
  Kokturk 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, January 24, 2002 1:10 
  AM
  Subject: Re: Oracle 9i installation Java 
  RunTime Environment was not found.
  
  Dear Friends, I am 
  trying to install Oracle 9i on Sun Solaris 5.8.But while installting i get the following 
  error
  
  hi,
  you need JRE 
  for installation. I think your system didn't installed or have a problem. You 
  can download , install and try to install Oracle again.
  -Onder 
  Kokturk

Mirroring REDO logs to an nfs drive

[Steve McClure]

Our site is preparing to fail over to our backup server.  We need to do
maintenance on our production server, and will be running on the backup for
about 24 hours.  One issue I brought up was that our backup server is not
equiped with mirrored drives, thus there was the possibility that a drive
failure could destroy an online redo log.  On our production box the logs
are not software mirrored, because of the physical mirroring in our drive
cabinet.

As a result I was told to multiplex the redo logs once we had failed over to
the backup server.  Furthermore I would add the new members to an nfs drive,
so that even a pesky controller couldn't foil our mirrored log files.

I have some questions about this.  First, am I just looking for problems by
doing this?  I would appreciate any tips or warnings on this subject.
Secondly, researching this topic made me curious as to my DB's settings for
MAXLOGFILES and MAXLOGMEMBERS.  Where can I find these parameters?  I was
sure I would find them in v$parameter, but they were not there.

Thanks for any response,
Steve McClure

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Trace/Event Info (iOraDumpReader)

[Mohan, Ross]

I know. It was a joke. Don't bite my head off! ;-)

eating your own dog food is a compliment...meaning
a company that uses its own products in doing its
business. 

I will you and the business good luck!

- Ross


-Original Message-
Sent: Thursday, January 24, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


Hi,

I head meant 'launch'.

Mohan, Ross wrote:

 I'll lunch beta version next week.

 ||  eating your own dog food,eh?   Admirable!

 -Original Message-
 Sent: Thursday, January 24, 2002 1:39 PM
 To: Multiple recipients of list ORACLE-L

 Hello,

 you can use itrprof (web based, and free) to analyze event10046 raw trace
 files. The product is at
 http://www.unal-bilisim.com/products/itrprof/itrprof.html.

 I'm currently developing a new web based product named iOraDumpReader.
 This tool will intreprete many Oracle trace files such as:

 - control file dump
 - file header dump
 - redo header dump
 - redo block dump
 - data block dump
 - rbs dump
 - etc.

 I'll lunch beta version next week.

 regards...

 Walter K wrote:

  Howdy!
 
  Is a document available somewhere that explains the
  different trace levels and also the commonly used
  events for tracing? For instance, I know to use event
  10046 with level 4 to get the bind variable values in
  a trace, but why this particular combination of event
  and trace level? What are the different levels and how
  are they used? How are process state and system state
  dumps performed? I'm also interested in some info that
  explains how to interpret the various trace files that
  are produced, other than just looking for SQL in them.
  Etc...
 
  Thanks again!
  -w
 
  __
  Do You Yahoo!?
  Send FREE video emails in Yahoo! Mail!
  http://promo.yahoo.com/videomail/
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Walter K
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).

 --
 Danisment Gazi Unal
 http://www.unal-bilisim.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Danisment Gazi Unal (Unal Bilisim)
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 --
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

--
Danisment Gazi Unal
http://www.unal-bilisim.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an 

RE: Time Question

[Post, Ethan]

Lance,

My performance monitor aggregates frequent samples into smaller tables using
this method.  I create a function then write a query using the function and
pass in the date column.  The group by averages the values for me.

CREATE OR REPLACE FUNCTION nearest_even_hour (p_date IN DATE) RETURN DATE AS

 l_date DATE;

BEGIN

 IF MOD(TO_NUMBER(TO_CHAR(TRUNC(p_date, 'HH24'), 'HH24')), 2) = 0 THEN
l_date := TRUNC(p_date, 'HH24'); -- truncate to hour
 ELSE
l_date := TRUNC(p_date, 'HH24')+1/24; -- round to hour and add one
 END IF;

 RETURN l_date;

EXCEPTION
   WHEN OTHERS THEN
RAISE;

END;

insert into SOME_TABLE (
   select avg(value), nearest_even_hour(date_column)
   from OTHER_TABLE 
   group by nearest_even_hour(date_column));

- Ethan

-Original Message-
Sent: Thursday, January 24, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L


I am not sure how to ask this or if it is even possible.  I have a stored
procedure that runs every five minutes and writes the data to a table.  I
want to query every thirty minutes and group the rows from the last half
our.

would I used date difference?


Thank you in advance
lance

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Trace/Event Info (iOraDumpReader)

[Mohan, Ross]

That's because compilers can't recognize quality when they C it. 

har de har har

-Original Message-
Sent: Thursday, January 24, 2002 2:35 PM
To: Mohan Ross
Cc: '[EMAIL PROTECTED]'


Hi Mohan and others,

Thank you for your compliment.

If a compiler has an option to compile or not to compile my products, I know
I
could never develop a product with my typo errors. Compilers would quit
after
the first attempt(joke...).



I'm developing my products

Mohan, Ross wrote:

 I know. It was a joke. Don't bite my head off! ;-)

 eating your own dog food is a compliment...meaning
 a company that uses its own products in doing its
 business.

 I will you and the business good luck!

 - Ross

 -Original Message-
 From: Danisment Gazi Unal (Unal Bilisim) [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 24, 2002 2:13 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Trace/Event Info (iOraDumpReader)

 Hi,

 I head meant 'launch'.

 Mohan, Ross wrote:

  I'll lunch beta version next week.
 
  ||  eating your own dog food,eh?   Admirable!
 
  -Original Message-
  Sent: Thursday, January 24, 2002 1:39 PM
  To: Multiple recipients of list ORACLE-L
 
  Hello,
 
  you can use itrprof (web based, and free) to analyze event10046 raw
trace
  files. The product is at
  http://www.unal-bilisim.com/products/itrprof/itrprof.html.
 
  I'm currently developing a new web based product named iOraDumpReader.
  This tool will intreprete many Oracle trace files such as:
 
  - control file dump
  - file header dump
  - redo header dump
  - redo block dump
  - data block dump
  - rbs dump
  - etc.
 
  I'll lunch beta version next week.
 
  regards...
 
  Walter K wrote:
 
   Howdy!
  
   Is a document available somewhere that explains the
   different trace levels and also the commonly used
   events for tracing? For instance, I know to use event
   10046 with level 4 to get the bind variable values in
   a trace, but why this particular combination of event
   and trace level? What are the different levels and how
   are they used? How are process state and system state
   dumps performed? I'm also interested in some info that
   explains how to interpret the various trace files that
   are produced, other than just looking for SQL in them.
   Etc...
  
   Thanks again!
   -w
  
   __
   Do You Yahoo!?
   Send FREE video emails in Yahoo! Mail!
   http://promo.yahoo.com/videomail/
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Walter K
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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).
 
  --
  Danisment Gazi Unal
  http://www.unal-bilisim.com
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Danisment Gazi Unal (Unal Bilisim)
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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.com
  --
  Author: Mohan, Ross
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).

 --
 Danisment Gazi Unal
 http://www.unal-bilisim.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Danisment Gazi Unal (Unal Bilisim)
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 

Re: Mirroring REDO logs to an nfs drive

[Jared . Still]

Steve,

'alter database backup controlfile to trace;'

The values will be in the trace file.

Jared





Steve McClure [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/02 11:48 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Mirroring REDO logs to an nfs drive


Our site is preparing to fail over to our backup server.  We need to do
maintenance on our production server, and will be running on the backup 
for
about 24 hours.  One issue I brought up was that our backup server is not
equiped with mirrored drives, thus there was the possibility that a drive
failure could destroy an online redo log.  On our production box the logs
are not software mirrored, because of the physical mirroring in our drive
cabinet.

As a result I was told to multiplex the redo logs once we had failed over 
to
the backup server.  Furthermore I would add the new members to an nfs 
drive,
so that even a pesky controller couldn't foil our mirrored log files.

I have some questions about this.  First, am I just looking for problems 
by
doing this?  I would appreciate any tips or warnings on this subject.
Secondly, researching this topic made me curious as to my DB's settings 
for
MAXLOGFILES and MAXLOGMEMBERS.  Where can I find these parameters?  I was
sure I would find them in v$parameter, but they were not there.

Thanks for any response,
Steve McClure

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RE: FW: Electrical background

[Mohan, Ross]

Ross,

You've got to define hum.  

||  It's in my Rotel preamp. Personally, I think it should
shut the hell up. As for the sound...it's kind of a
nyah nyah nyah nyah nayaaah nayh 

snip

BTW: Definition of 'VERY faint' is in a closed almost sound 
proof room with your ear right next to the relay.

||  this is sitting *across* the room with the kids playing 
Where's Osama? in the next room. Too loud, methinks. 

||  thanks...moving to OT rather than face a Jared Fatwah..


Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   1/24/2002 7:15 AM

Is it natural for relays to hum?



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Databases on Solaris: Online Forum Jan. 22-28

[Steve McClure]

This list pays for itself once again.

Jared is charging the rest of you too, right?

Steve
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L


Discuss Configuring  Tuning Databases on the Solaris[tm]
Platform 22-28 January 2002.  Join a special online
discussion forum with Sun engineer, Allan N. Packer, author
of Configuring  Tuning Databases on the Solaris[tm]
Platform.  Database professionals can take this opportunity
to ask questions relating to optimizing the performance and
cost-effectiveness of virtually any database application
running on the Solaris platform.

Learn more at:

http://www.sun.com/forums/disc-012202/



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Electrical background

[Guidry, Chris]

That would be a Rectifier. Inverters change AC to DC.
Converters change the frequency of AC to AC.

--
Chris J. Guidry  P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


 -Original Message-
 From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, January 24, 2002 10:56 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: FW: Electrical background
 
 Regular relays do not hum. If it does this means it's switching on and off
 at certain frequency on which it's designed. Then it's not a relay it
 could
 be one of these devices that convert DC to AC.
 
 -Original Message-
 Sent: Thursday, January 24, 2002 10:15 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Is it natural for relays to hum?
 
 -Original Message-
 
 SO, what did you want?
 
 Dick Goulet
 Ancient Electronics Tech  tinkerer, Also certified relay NUT
 
 Reply Separator
 Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
 Date:   1/23/2002 10:30 AM
 
 Sorry folks, that went to the wrong list. I apologize.  We now return you
 to
 your 
 regularly scheduled Oracle discussion.
 
 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 
  -Original Message-
  From: Adams, Matthew (GEA, 088130) 
  
  
  Anybody got a EE or electronics background?
  I've got a question about relays.
 
  
  Matt Adams - GE Appliances - [EMAIL PROTECTED]
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 -- 
 Author: Khedr, Waleed
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[Henry Poras]

You can count on it.

Henry

-Original Message-
Sent: Thursday, January 24, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


[EMAIL PROTECTED] wrote:

JoJo --

Sure, but be aware that Unix abaci are better than NT abaci.

don't forget the VMS abaci.;-)



-- 
--
Bill Shrek Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

When you want to test the depths of a stream, don't use both feet.   -
Chinese Proverb 






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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Mirroring REDO logs to an nfs drive

[Rachel Carmichael]

easiest way to see the values is to do a backup controlfile to trace...
they will be there


--- Steve McClure [EMAIL PROTECTED] wrote:
 Our site is preparing to fail over to our backup server.  We need to
 do
 maintenance on our production server, and will be running on the
 backup for
 about 24 hours.  One issue I brought up was that our backup server is
 not
 equiped with mirrored drives, thus there was the possibility that a
 drive
 failure could destroy an online redo log.  On our production box the
 logs
 are not software mirrored, because of the physical mirroring in our
 drive
 cabinet.
 
 As a result I was told to multiplex the redo logs once we had failed
 over to
 the backup server.  Furthermore I would add the new members to an nfs
 drive,
 so that even a pesky controller couldn't foil our mirrored log files.
 
 I have some questions about this.  First, am I just looking for
 problems by
 doing this?  I would appreciate any tips or warnings on this subject.
 Secondly, researching this topic made me curious as to my DB's
 settings for
 MAXLOGFILES and MAXLOGMEMBERS.  Where can I find these parameters?  I
 was
 sure I would find them in v$parameter, but they were not there.
 
 Thanks for any response,
 Steve McClure
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Steve McClure
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Trace/Event Info (iOraDumpReader)

[Danisment Gazi Unal (Unal Bilisim)]

Hi Mohan and others,

Thank you for your compliment.

If a compiler has an option to compile or not to compile my products, I know I
could never develop a product with my typo errors. Compilers would quit after
the first attempt(joke...).



I'm developing my products

Mohan, Ross wrote:

 I know. It was a joke. Don't bite my head off! ;-)

 eating your own dog food is a compliment...meaning
 a company that uses its own products in doing its
 business.

 I will you and the business good luck!

 - Ross

 -Original Message-
 From: Danisment Gazi Unal (Unal Bilisim) [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 24, 2002 2:13 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Trace/Event Info (iOraDumpReader)

 Hi,

 I head meant 'launch'.

 Mohan, Ross wrote:

  I'll lunch beta version next week.
 
  ||  eating your own dog food,eh?   Admirable!
 
  -Original Message-
  Sent: Thursday, January 24, 2002 1:39 PM
  To: Multiple recipients of list ORACLE-L
 
  Hello,
 
  you can use itrprof (web based, and free) to analyze event10046 raw trace
  files. The product is at
  http://www.unal-bilisim.com/products/itrprof/itrprof.html.
 
  I'm currently developing a new web based product named iOraDumpReader.
  This tool will intreprete many Oracle trace files such as:
 
  - control file dump
  - file header dump
  - redo header dump
  - redo block dump
  - data block dump
  - rbs dump
  - etc.
 
  I'll lunch beta version next week.
 
  regards...
 
  Walter K wrote:
 
   Howdy!
  
   Is a document available somewhere that explains the
   different trace levels and also the commonly used
   events for tracing? For instance, I know to use event
   10046 with level 4 to get the bind variable values in
   a trace, but why this particular combination of event
   and trace level? What are the different levels and how
   are they used? How are process state and system state
   dumps performed? I'm also interested in some info that
   explains how to interpret the various trace files that
   are produced, other than just looking for SQL in them.
   Etc...
  
   Thanks again!
   -w
  
   __
   Do You Yahoo!?
   Send FREE video emails in Yahoo! Mail!
   http://promo.yahoo.com/videomail/
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Walter K
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   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).
 
  --
  Danisment Gazi Unal
  http://www.unal-bilisim.com
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Danisment Gazi Unal (Unal Bilisim)
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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.com
  --
  Author: Mohan, Ross
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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).

 --
 Danisment Gazi Unal
 http://www.unal-bilisim.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Danisment Gazi Unal (Unal Bilisim)
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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 

RE: Backup Strategy

[JoJo Al-Zawawi]

Now you're really stretching it!  :D

--JoJo


[EMAIL PROTECTED] wrote:

JoJo --

Sure, but be aware that Unix abaci are better than NT abaci.

don't forget the VMS abaci.;-)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: JoJo Al-Zawawi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Time Question

[Ron Rogers]

Lance,
 Does you table load include a date field with the hh:mm:ss. If it does
not than how do you propose to find when a row was inserted. You could
use logminer and check the archivelogs if there was a crutial need to
know. I would add a column to the table that would hold a datetime stamp
and then use that column for your query.
ROR mª¿ªm

 [EMAIL PROTECTED] 01/24/02 01:55PM 
I am not sure how to ask this or if it is even possible.  I have a
stored
procedure that runs every five minutes and writes the data to a table. 
I
want to query every thirty minutes and group the rows from the last
half
our.

would I used date difference?


Thank you in advance
lance

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

Fat City Network Services-- (858) 538-5051  FReceived: from CONNECT-MTA by 
galotterAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Trace/Event Info (iOraDumpReader)

[Jamadagni, Rajendra]

How about this error message,

You can't modify a constant, float upstream, win an argument with the IRS,
or satisfy this compiler
--- From apple MPW C compiler (an old version)

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Thursday, January 24, 2002 3:25 PM
To: Multiple recipients of list ORACLE-L


That's because compilers can't recognize quality when they C it. 
har de har har




*2

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: FW: Electrical background

[Cornio, Georgette Ms USACFSC]

A Rectifier changes AC to DC, usually handled by a Diode
 and an Inverter DC to AC.


-Original Message-
Sent: Thursday, January 24, 2002 16:10
To: Multiple recipients of list ORACLE-L


That would be a Rectifier. Inverters change AC to DC.
Converters change the frequency of AC to AC.

--
Chris J. Guidry  P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


 -Original Message-
 From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, January 24, 2002 10:56 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: FW: Electrical background
 
 Regular relays do not hum. If it does this means it's switching on and off
 at certain frequency on which it's designed. Then it's not a relay it
 could
 be one of these devices that convert DC to AC.
 
 -Original Message-
 Sent: Thursday, January 24, 2002 10:15 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Is it natural for relays to hum?
 
 -Original Message-
 
 SO, what did you want?
 
 Dick Goulet
 Ancient Electronics Tech  tinkerer, Also certified relay NUT
 
 Reply Separator
 Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
 Date:   1/23/2002 10:30 AM
 
 Sorry folks, that went to the wrong list. I apologize.  We now return you
 to
 your 
 regularly scheduled Oracle discussion.
 
 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 
  -Original Message-
  From: Adams, Matthew (GEA, 088130) 
  
  
  Anybody got a EE or electronics background?
  I've got a question about relays.
 
  
  Matt Adams - GE Appliances - [EMAIL PROTECTED]
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 -- 
 Author: Khedr, Waleed
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Cornio, Georgette Ms USACFSC
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Time Question

[Jared . Still]

An easier and more accurate method would be to create a column
in the table and populate it with a sequence.

When you run your query, include in the WHERE clause
' and my_sequence_num  sequence_last_time_i_checked '

You would just need to record the last sequence number 
checked in a single row table.

Jared





Lance Prais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/02 10:55 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Time Question


I am not sure how to ask this or if it is even possible.  I have a stored
procedure that runs every five minutes and writes the data to a table.  I
want to query every thirty minutes and group the rows from the last half
our.

would I used date difference?


Thank you in advance
lance

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Henry Poras]

Let me try again (using expand -t 3 as suggested by Jared)

#  Script for analyzing Oracle Trace files with WAIT statistics
#  Usage:  wait_scan.awk filename
#  Written:Henry Poras
#  5/16/00
#  Modified:   12/3/01  Initially assumes all wait states for a cursor are
between
#   parse statements.
#
#
nawk  '# need nawk,
not awk 
   BEGIN{N=
  PARSE_FLAG=0 # PARSE_FLAG
= 0 (normal state)
  printf(\n\n%-35s %-12s %-18s\n\n,  # PARSE_FLAG
= 1 (previous line PARSING)
 WAIT EVENT, # OF TIMES, ELAPSED TIME (sec)) # print
column headers 
 }

 {if (PARSE_FLAG==1)   # if previous
line started
{SQL[N]=$0 # with
PARSING, print 
 PARSE_FLAG=0  # the SQL. 
N=
}
 }  
   /^PARSING/  {FS= 
  N=$4
  sub(#,,N)
  if (N in SQL)
prinfo(N)
  PARSE_FLAG=1
 }
   /^WAIT/ {FS=#| nam=|ela=|p1=
  N=$2
   sub(:,,N)
  PARSE_FLAG=2
  n_wait[N,$3] += 1
  ela_wait[N,$3] += $4
 }  
   END  {for (N in SQL){   # Print Wait
statistics for final
printf \n\n\n%s\n\n, SQL[N]  # SQL
statement in file
for (k in n_wait) {
 split(k,arg,SUBSEP)
 if (arg[1]==N  n_wait[k]!=0) {
   printf %-35s %-12s %12.2f\n,
   arg[2],n_wait[k],ela_wait[k]/100
   n_wait[k]=0
   ela_wait[k]=0
 }
} 
  printf \n\n
 }
 for (k in n_wait) {
split(k,arg,SUBSEP)
if (n_wait[k] != 0) {
   printf %-35s %-12s %12.2f\n,
   arg[2],n_wait[k],ela_wait[k]/100
   n_wait[k]=0
   ela_wait[k]=0
}
 }
 }

   function prinfo(N,   k) {
 printf \n\n\n%s\n\n, SQL[N]
 for (k in n_wait){
split(k,arg,SUBSEP)
if (arg[1]==N  n_wait[k]!=0) {
   printf %-35s %-12s %12.2f\n,
   arg[2],n_wait[k],ela_wait[k]/100
   n_wait[k]=0
   ela_wait[k]=0
}
 }  
  }
   ' $1



-Original Message-
Sent: Thursday, January 24, 2002 11:00 AM
To: Multiple recipients of list ORACLE-L


#   Script for analyzing Oracle Trace files with WAIT statistics
#   Usage:  wait_scan.awk filename
#   Written:Henry Poras
...
-Original Message-
Sent: Wednesday, January 23, 2002 1:56 PM
To: Multiple recipients of list ORACLE-L


Hi, Henry,
Please, post it. I am terribly sorry for asking dumb questions, but hey!
I've come a long way to be a part of this country, learned the language,
become a DBA and proud of it! Time to learn! Thanks a bunch in advance!

Sincerely,
Sergey

 -Original Message-
Sent:   Wednesday, January 23, 2002 1:02 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

Couldn't hurt. Also why not do some deltas of your session statistics
(before and after snapshots)

Henry

PS: After you have the trace file, I put together an awk statement to sum up
the number and elapsed time of the wait states for each SQL statement. I can
post that if you would like. 

-Original Message-
Sent: Wednesday, January 23, 2002 11:21 AM
To: Multiple recipients of list ORACLE-L


Hi, Henry,
Since I didn't expect that to happen, I had just SQL trace turned on for
that particular session. Do you suggest entering
event=10046 trace name errorstack level 12 into init.ora?
Thanks,
Regards,
Sergey

 -Original Message-
Sent:   Wednesday, January 23, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

Sergey,
At what level did you trace?

Henry

-Original Message-
Sent: Wednesday, January 23, 2002 8:15 AM
To: Multiple recipients of list ORACLE-L


Thank you, guys, for your help, just got back to work. Unfortunately, it's
too late to run the query, but later on we'll run the OLTP again, and then
I'll do it and post the output. Currently I'm analyzing the trace file which
is about 130M (did not tkprof it yet), and that size does NOT sound healthy
to me. 
Best regards,
Sergey Babich

 -Original Message-
Sent:   Tuesday, January 22, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait

Sergey, please run this and post values. Just curious. 

select 
name, value 
from 
v$sesstat vs, v$statname sn 
where 
vs.statistic#=sn.statistic# and 
value is NOT NULL and 
value0 and 
sid=11;


hth, 

- Ross

p.s. shadow process - your client 

RE: SCOTT/TIGER

[Loughmiller, Greg]

And there is documentation that comes with Oracle?   

:-)

Greg

-Original Message-
Sent: Thursday, January 24, 2002 1:31 PM
To: Multiple recipients of list ORACLE-L


not everyone here has read the docs, remember? :)


--- Bellows, Bambi [EMAIL PROTECTED] wrote:
 _ON_INSTALL was the name of Bruce Scott's mother-in-law's hedgehog...
 her
 guppy, MANAGER, having olfactory powers beyond those of normal
 guppies,
 would always get upset by the smell coming out of _ON_INSTALL's bin,
 and
 would mouth Change _ON_INSTALL's bin litter!  But, you know,
 reading guppy
 lips is a long and complicated affair, and Scott's mother-in-law's
 contact
 lenses would fog up about half way through.  
 
 Sheesh.  I thought this was in all the books.
 
 HTH,
 Bambi.
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 10:50 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: SCOTT/TIGER
 
 So who was SYS, and why on earth did s/he name his/her pet
 CHANGE_ON_INSTALL???
 
 :-)
 
  [EMAIL PROTECTED] 24/1/2002 12:00:27 
 This message has been scanned by MAILSweeper.
 
 
 The name I was given is Scott Gossett.  My team leader and one 
 of our team members took the advanced seminars last year, and 
 their instructor was Scott, and he admitted his notoriety.
 
 -Original Message-
 Sent: Wednesday, January 23, 2002 4:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 there are several instructors named Scott how do you know which
 one
 it is or even if it's one of the instructors?
 
 
 --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
  Ok...it's true.  Take the Oracle Technical seminars and you too may
  get to meet Scott, Live and In Person.  Unfortunately, Tiger is
  waiting
  for Scott at the Rainbow Bridge, but Scott is still there (at least
  he was last year...you know how Oracle's been lately).
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 10:26 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I was once told with certainty from an Oracle instructor that Scott
  was
  an early developer, and Tiger was his cat.  But without actually
  meeting
  Scott I take this with a grain of salt.  I expect there are many
  urban
  legends surrounding this.  
  
  Jim
  
  -Original Message-
  Sent: Wednesday, January 23, 2002 11:45 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Anyone out there know the history of this?
  -- 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 

**
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 
 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.
 
 www.mimesweeper.com

**
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Arn Klammer
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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.com
 -- 
 Author: Babich , Sergey
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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 

export the schema exclude two tables?

[CC Harvest]

Anyone knows how to do it in Oracle8.1.7?

__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

time issue

[Lance Prais]

I am using the following Statement:  I am getting no records returned.  Any
idea what is wrong?
thanks again
Lance

Select count(User_name) users
from cp_license_use
where Time_Stamp between SYSDATE and (sysdate - 30/1440)
group by Time_stamp

To grab data from the following table:  SYSDATE = 1/24/2002 9:33:16 PM
User_Name   Time_stamp
dsilver 1/24/2002 9:31:33 PM
cnelson 1/24/2002 9:31:33 PM
eho   1/24/2002 9:31:33 PM
mreza 1/24/2002 9:31:33 PM
kjuneja 1/24/2002 9:31:33 PM
sislam  1/24/2002 9:31:33 PM
dkotha  1/24/2002 9:31:33 PM
mbalthrop   1/24/2002 9:31:33 PM
tchung  1/24/2002 9:31:33 PM
cnifong 1/24/2002 9:31:33 PM
sluc1/24/2002 9:31:33 PM
dtrevino1/24/2002 9:31:33 PM
ddobson 1/24/2002 9:31:33 PM
echinwub1/24/2002 9:31:33 PM
dmoses  1/24/2002 9:31:33 PM
gpratt  1/24/2002 9:31:33 PM
syahmed 1/24/2002 9:31:33 PM
mreza   1/24/2002 9:31:33 PM

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Time Question

[Bellows, Bambi]

Yep, so long as there was a timestamp on the records.

-Original Message-
Sent: Thursday, January 24, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L

I am not sure how to ask this or if it is even possible.  I have a stored
procedure that runs every five minutes and writes the data to a table.  I
want to query every thirty minutes and group the rows from the last half
our.

would I used date difference?


Thank you in advance
lance

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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:RE: FW: Electrical background

[dgoulet]

Ross,

You've got to define hum.  A relay that is run off of an AC current can have
a VERY faint hum.  A relay that is running on AC current when designed for DC
current has a distinctive 'hum' sometimes more similar to a high speed clicking.
 Also a relay that has a coil nearing the end of it's life will 'hum' as defined
before.  The best test I know of in this case is to observe the relay's contacts
(possible only on open frame relays) in the dark.  If there is a faint arc
visible when the relay is suppose to be closed, it's time for a replacement.

Dick Goulet

BTW: Definition of 'VERY faint' is in a closed almost sound proof room with your
ear right next to the relay.

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   1/24/2002 7:15 AM

Is it natural for relays to hum?

-Original Message-

SO, what did you want?

Dick Goulet
Ancient Electronics Tech  tinkerer, Also certified relay NUT

Reply Separator
Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
Date:   1/23/2002 10:30 AM

Sorry folks, that went to the wrong list. I apologize.  We now return you to
your 
regularly scheduled Oracle discussion.


Matt Adams - GE Appliances - [EMAIL PROTECTED]

 -Original Message-
 From: Adams, Matthew (GEA, 088130) 
 
 
 Anybody got a EE or electronics background?
 I've got a question about relays.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Databases on Solaris: Online Forum Jan. 22-28

[Jesse, Rich]

Hmmm...many (most?  all?) of the answers given in the forum however, seem to
be pointers to chapters in Mr. Packer's book.

Just an observation.

:)

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


-Original Message-
Sent: Thursday, January 24, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L



This list pays for itself once again.

Jared is charging the rest of you too, right?

Steve
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L


Discuss Configuring  Tuning Databases on the Solaris[tm]
Platform 22-28 January 2002.  Join a special online
discussion forum with Sun engineer, Allan N. Packer, author
of Configuring  Tuning Databases on the Solaris[tm]
Platform.  Database professionals can take this opportunity
to ask questions relating to optimizing the performance and
cost-effectiveness of virtually any database application
running on the Solaris platform.

Learn more at:

http://www.sun.com/forums/disc-012202/

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ROLLBACK SEGMENT?

[Rajesh . Rao]

 Export doesn't generate any rollback, right, so what is it supposed to
 accomplish by doing this incantation?

Sorry to press the point, but could you elaborate on how that COULD
possibly make any difference for 'snapshot too old'?

For the same reason, any other transaction could end up with a snapshot too
old error. Export does not generate any rollback, but there could be users
performing DML operations on the table  that is being exported, and the
export needs to be redirected to read from the rollback segments. The
likelihood of the error being thrown up especially if one uses the
consistent parameter could be very high, if you dont have a large enough
rollback segment without an optimal clause.

Raj





Jeremiah Wilton [EMAIL PROTECTED]@fatcity.com on 01/23/2002 11:20:40
AM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


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


On Tue, 22 Jan 2002, [EMAIL PROTECTED] wrote:

 H ... COULD help in avoiding snapshot too old errors.

Sorry to press the point, but could you elaborate on how that COULD
possibly make any difference for 'snapshot too old'?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

 Jeremiah Wilton [EMAIL PROTECTED] wrote:

 So what does it accomplish to assign export [to] a particular
 rollback segment?

 Export doesn't generate any rollback, right, so what is it supposed to
 accomplish by doing this incantation?

 On Tue, 22 Jan 2002, Jason Rowski wrote:

  ... you can use the following trick to assign export a
  particular rollback segment -
 
  1) Create a rollback segment tablespace with one large
  segment and bring it online before export.
  2) Offline all existing rollback segments.
  3) Export the database
  4) Offline the large tablespace created earlier.
  5) Bring back the orginals rollback segments online.
 
 
  --- Seema Singh [EMAIL PROTECTED] wrote:
   Can I use one rollback segment at time of export?Is
   yes,then
   SET TRANSACTION USE ROLLBACK SEGMENT
   rollbacksegmentname;

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: performance problem with partitioned table query.

[Jessica Mao]

Thank you Igor. But only 1 of the 14 partitions contains data during all the tests. 
Why should the extra 13 empty partitions slows down the query? I also tried to drop 12 
of the empty partitions. Results didn't change. -Jessica

-Original Message-
Sent: Thursday, January 24, 2002 5:37 AM
To: Multiple recipients of list ORACLE-L


Jessica,

It looks like your query has to deal with all 14 partitions, because the
column 'poid_id0', which your table partitioned on, is not in 'where'
clause.
That's why Oracle can not eliminate other (not populated) 13 partitions.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 23, 2002 6:15 PM


 Oracle 8.1.7.0.0

 table event_t range partitioned by column poid_id0. only 1 partition
called p_1 out of the 14 contains data. A query on event_t became
significantly slow after rows increase:

 select   poid_DB, poid_ID0, poid_TYPE, poid_REV, start_t, end_t, sys_descr
 from  event_t
 where event_t.end_t = :1 and event_t.end_t  :2 and
   event_t.poid_TYPE like :3 and (event_t.account_obj_ID0 = :4 and
   event_t.account_obj_DB = 1 ) order by event_t.end_t desc

 Rows Execution Plan
 ---  ---
   0  SELECT STATEMENT   GOAL: CHOOSE
   0   SORT (ORDER BY)
   0PARTITION RANGE (ALL) PARTITION: START=1 STOP=14
   0 TABLE ACCESS   GOAL: ANALYZED (BY LOCAL INDEX ROWID) OF
 'EVENT_T' PARTITION: START=1 STOP=14
   0  INDEX   GOAL: ANALYZED (RANGE SCAN) OF
'I_EVENT__ACCTOBJ_END_T' (NON-UNIQUE) PARTITION: START=1
  STOP=14

 Index I_EVENT__ACCTOBJ_END_T was created on event_t ( account_obj_id0,
end_t ) using LOCAL.
 Other 2 columns involved in the where clause have either only one distinct
value or a few. So are not indexed.
 column account_obj_id0 has 1 million unique values in event_t and remain
unchanged during the tests. when rows insert, average rows per
account_obj_id0 value increase as well.

 Trace shows always the same execution plan but elapsed time increased
enormously!
 I did 2 rounds of tests, every round I dropped and recreated event_t
empty:

 In test round 1:
 1.) inserted 1 million rows into event_t with same end_t value. Query
returned:
 call count   cpuelapsed   disk  querycurrent
rows
 --- --   -- -- -- --  
--
 Parse   23  0.02   0.09  0  0  0
0
 Execute156  0.02   0.29  0  0  0
0
 Fetch  156  0.14   1.09  8   2698  0
195
 --- --   -- -- -- --  
--
 total  335  0.18   1.47  8   2698  0
195

 2.) inserted ANOTHER 1.5 million rows into event_t with 10,000+ different
end_t values. Query returned:
 Parse   36  0.00   0.04  0  0  0
0
 Execute118  0.01   0.01  0  0  0
0
 Fetch  118  0.61  86.71   1385   5045  0
587
 --- --   -- -- -- --  
--
 total  272  0.62  86.76   1385   5045  0
587

 In test round 2:
 1.) inserted 1 million rows into event_t with same end_t value. Query
returned as round1 step 1.)

 2.) inserted ANOTHER 5 million rows into event_t with ANOTHER end_t value.
Query returned:
 Parse   40  0.00   0.11  0  0  0
0
 Execute139  0.02   0.12  0  0  0
0
 Fetch  139  0.25   4.66303   2868  0
761
 --- --   -- -- -- --  
--
 total  318  0.27   4.89303   2868  0
761

 3.) inserted ANOTHER 2 million rows into event_t with 12,000+ different
end_t values. Query returned:
 Parse   34  0.01   0.01  0  0  0
0
 Execute 97  0.00   0.06  0  0  0
0
 Fetch   97  0.58  89.93   1257   4260  0
614
 --- --   -- -- -- --  
--
 total  228  0.59  90.00   1257   4260  0
614


 In test round 1 elapsed time increased 60 times from 1 million to 2.5
million rows. In round 2 it increased 3 times from 1 to 6 million rows, and
18 times from 6 to 8 million rows. So #-of-rows in event_t is not the #1
convict for large physical reads. It's more likely the
#-of-different-end_t-values. Before I always thought that to an indexed
column the more different values the better. But what's going on in this
case? Am I missing anything?

 Top wait event in statspack report is 'db file sequential read'. oradebug
event 10046 shows 'db file sequential 

RE: FW: Electrical background

[DBarbour]

Ooops ... Rectifiers convert  AC to DC,  Inverters convert DC to AC (My
wife would be lost when we go car camping without my handy Inverter!).


   
   
Guidry, Chris
   
chris.guidry@atcoele   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
ctric.com  cc:
   
Sent by:Subject: RE: FW: Electrical 
background
[EMAIL PROTECTED]   
   
   
   
   
   
01/24/2002 03:10 PM
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




That would be a Rectifier. Inverters change AC to DC.
Converters change the frequency of AC to AC.

--
Chris J. Guidry  P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


 -Original Message-
 From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, January 24, 2002 10:56 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:   RE: FW: Electrical background

 Regular relays do not hum. If it does this means it's switching on and
off
 at certain frequency on which it's designed. Then it's not a relay it
 could
 be one of these devices that convert DC to AC.

 -Original Message-
 Sent: Thursday, January 24, 2002 10:15 AM
 To: Multiple recipients of list ORACLE-L


 Is it natural for relays to hum?

 -Original Message-

 SO, what did you want?

 Dick Goulet
 Ancient Electronics Tech  tinkerer, Also certified relay NUT

 Reply Separator
 Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
 Date:   1/23/2002 10:30 AM

 Sorry folks, that went to the wrong list. I apologize.  We now return you
 to
 your
 regularly scheduled Oracle discussion.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]

  -Original Message-
  From: Adams, Matthew (GEA, 088130)
 
 
  Anybody got a EE or electronics background?
  I've got a question about relays.

  
  Matt Adams - GE Appliances - [EMAIL PROTECTED]
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
 --
 Author: Khedr, Waleed
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
--
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 

RE: Time Question

[Kevin Lange]

If you have a field in the data that keeps track of when it was inserted
then you could always add a line in the where to check for a 30 minute
difference.  Something like :

where sysdate-time_field = 30/1440

This should get you all data 30 minutes or less old.



-Original Message-
Sent: Thursday, January 24, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L


I am not sure how to ask this or if it is even possible.  I have a stored
procedure that runs every five minutes and writes the data to a table.  I
want to query every thirty minutes and group the rows from the last half
our.

would I used date difference?


Thank you in advance
lance

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Trace/Event Info

[Jared . Still]

guess I should cut and paste, huh?

Jared





Rachel Carmichael [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/02 05:37 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: Trace/Event Info


Um Jared dear it's not the admin directory, at least not on my
Solaris/8.1.6 box

$ORACLE_HOME/rdbms/mesg  is the correct directory :)


--- [EMAIL PROTECTED] wrote:
 If you have access to Oracle on a unix system, take a look at 
 $ORACLE_HOME/rdbms/admin/oraus.msg.
 
 Events 1 - 10999 are of interest here.  You may also note
 that it says they are for debugging Oracle.  As such you will 
 likely never find documentation for some of them.
 
 A few of them are documented in the file.
 
 Jared
 
 
 
 
 
 Walter K [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 01/23/02 06:50 AM
 Please respond to ORACLE-L
 
 
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Trace/Event Info
 
 
 Howdy!
 
 Is a document available somewhere that explains the
 different trace levels and also the commonly used
 events for tracing? For instance, I know to use event
 10046 with level 4 to get the bind variable values in
 a trace, but why this particular combination of event
 and trace level? What are the different levels and how
 are they used? How are process state and system state
 dumps performed? I'm also interested in some info that
 explains how to interpret the various trace files that
 are produced, other than just looking for SQL in them.
 Etc...
 
 Thanks again!
 -w
 
 __
 Do You Yahoo!?
 Send FREE video emails in Yahoo! Mail!
 http://promo.yahoo.com/videomail/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Walter K
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 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!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: time issue

[Igor Neyman]

Just

Select count(*) users
from cp_license_use
where Time_Stamp between SYSDATE and (sysdate - 30/1440);

should do it (no 'group by').

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 4:35 PM



 I am using the following Statement:  I am getting no records returned.
Any
 idea what is wrong?
 thanks again
 Lance

 Select count(User_name) users
 from cp_license_use
 where Time_Stamp between SYSDATE and (sysdate - 30/1440)
 group by Time_stamp

 To grab data from the following table:  SYSDATE = 1/24/2002 9:33:16 PM
 User_Name Time_stamp
 dsilver 1/24/2002 9:31:33 PM
 cnelson 1/24/2002 9:31:33 PM
 eho   1/24/2002 9:31:33 PM
 mreza   1/24/2002 9:31:33 PM
 kjuneja 1/24/2002 9:31:33 PM
 sislam 1/24/2002 9:31:33 PM
 dkotha 1/24/2002 9:31:33 PM
 mbalthrop 1/24/2002 9:31:33 PM
 tchung 1/24/2002 9:31:33 PM
 cnifong 1/24/2002 9:31:33 PM
 sluc 1/24/2002 9:31:33 PM
 dtrevino 1/24/2002 9:31:33 PM
 ddobson 1/24/2002 9:31:33 PM
 echinwub 1/24/2002 9:31:33 PM
 dmoses 1/24/2002 9:31:33 PM
 gpratt 1/24/2002 9:31:33 PM
 syahmed 1/24/2002 9:31:33 PM
 mreza 1/24/2002 9:31:33 PM

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

system call error while attempting to execute a c program which c

[Bonnie Crittington]

I'm trying to execute a simple C program from the command prompt window.
The program is suppose to call sqlplus and update a table.  The program
works on an gateway e-1400 with win2000 professional and it works on a pc
running win95.  The program aborts with the following error on a gateway
e-3400 running win2000 professional:

Error issuing system call
File or directory not found

I have checked to path statement to make sure the oracle directory and
programs can be found.  I can execute plus80 and sqlplus from the command
prompt with no problem.  Does anyone have any ideas as to what I can check?
Unfortunately, I only have the C executable.  I don't have the source code.
Has anyone seen this error before?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bonnie Crittington
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Backup Strategy

[Igor Neyman]

I took a quick look at this paper, and found right away, that it's not very
accurate, at least in one issue.
i.e., it states :
 quote
The Windows NT command COPY can be used to create a cold backup of a
database. It cannot be used to make a
hot backup. Attempting to perform a hot backup with COPY will usually result
in an error message being generated
as the COPY command fails - during a hot backup the database is running and
thus the database files are locked by
the Oracle database process, and COPY cannot work on a file that is so
locked.
 /quote

Wrong. NT 'COPY' has no problems copying 'opened' oracle db files.
I'm using it in 'hot backup' scripts on many dozens systems, and it works
fine.

Don't know about the accuracy of the rest of the paper, didn't have time to
read it all.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 7:35 AM


 Hi All,

  http://www.geocities.com/tbcox23/

 Go here and get the paper.

 Regards
 Venkat
 --

 On Thu, 24 Jan 2002 03:25:17
  Bunyamin K. Karadeniz wrote:
 If possible , I want one copy too.
 Bunyamin
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, January 24, 2002 12:30 PM
 
 
  Can you send me one (NT backup strategy)
 
  Regards,
  Ramesh D Papnoi
  Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
  (BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
  http://www22.Brinkster.com/rpapnoi
 
  -- Original Text --
 
  To: internet[Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]]
 
  Please send me one. (NT) Thank,
 
  grace wrote:
  
   can u also send me a copy on backup strategy on  nt.
   thanks
  
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Wednesday, January 23, 2002 3:25 PM
  
Hello Hamid
   
I would like to have this paper as well.
We are now revising our Backup strategy.
   
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
   
 -Original Message-
 From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
 Sent: Tue, January 22, 2002 6:35 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Backup Strategy

 Hamid,

 Would you be willing to forward a copy of
 this paper?

 Thanks,

 Ross Mohan

 -Original Message-
 Sent: Thursday, January 17, 2002 12:27 PM
 To: Multiple recipients of list ORACLE-L


 Hi List,
 I have a white paper for Backup Strategy on Microsoft NT but I am
   looking
 for Backup Strategy for Oracle8i on Solaris, If anybody have any
doc
 or
 link
 I realy appreciate.




 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987

 The information contained in this message and any attachments is
   intended
 only for the use of the individual or entity to which it is
 addressed,
   and
 may contain information that is PRIVILEGED, CONFIDENTIAL and
exempt
 from
 disclosure under applicable law. If you have received this
message
 in
 error,
 you are prohibited from copying, distributing, or using the
 information.
 Please contact the sender immediately by return e-mail and delete
 the
 original message from your system.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Hamid Alavi
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
   
 
 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.com
 --
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
   
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You
may
 also send the HELP command for other information (like
subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway