date:20030307

Title: RE: Anyone looking fora  Developer/DBA in Wash DC area?





This site explains some of the details on how to get a security clearance.
http://www.taonline.com/securityclearances/scdetails.asp
If you want to get one your employer has to apply for you.
It can help you get jobs for a government agency or a company that contracts with a government agency. So it increases your job opportunities.

> -Original Message-
> From: Scott Stefick [mailto:[EMAIL PROTECTED]]
> 
> How do you get government clearance and why does it help with 
> being a DBA 
> other than working for a government agnecy?
> 
> Just wondering.

RE: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Scott Stefick

How do you get government clearance and why does it help with being a DBA 
other than working for a government agnecy?

Just wondering.

At 01:44 PM 3/7/03 -0800, you wrote:
Well, I'm not sure that you want to get into a bondage agreement, unless you
like getting kinda kinky. You can get 'bonded' through a bonding agency
(that does a background check of varying depth and intensity depending on
the scope of the job's responsibilities. Not the same as getting a
government clearance, though.
Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 07, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
clearance takes a long time to get. Ran into this before. I had to sign a
bondage agreement before they do the background check. Cant stay unemployed
for that long and its unethical for me to take a job with another company
and quit on them.
How are the bondage agreements with CSC? Everyone who wanted me to get one
requires them.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 07, 2003 2:48 PM
>
> Send resume as word attachment to [EMAIL PROTECTED]  I can't guarantee
> anything and you will have to be clearable but there's sure a lot of work
> going on here.
>
>
>
>  @cox.net>To:  Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   Sent by: rootcc:
>Subject: Anyone looking
fora  Developer/DBA in Wash DC area?
>
>   03/07/2003 01:09
>   PM
>   Please respond
>   to ORACLE-L
>
>
>
>
>
>
> Yes, I know this isnt a job board and this is the one and only time Ill do
> it. The market is tight.
>
>  My current contract is up in two weeks. Im a US Citizen(no clearance) and
> Im more developer than DBA. I have a good track record with strong
> references.
>
>  Anyone know of anything? Preferably something long term? I want to get
out
> of contracting. My only hang-up is that Im working on a Masters so travel
> out of the area would be limited.
>
>  As I said this is the one and only time Ill send this. I hope you all
> understand.
>
> The first day hints are gone, I will change my career!
>
> I do not think it will go away, since Oracle itself uses them to control
> the way PQ slaves and other background processes work.
>
> Also stored outlines is part of it.
>
> Regards,
>
> Waleed
>   -Original Message-
>   From: Stephane Paquette [mailto:[EMAIL PROTECTED]
>   Sent: Friday, March 07, 2003 11:04 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Oracle position on hints
>
>   Hi,
>
>   Does Oracle have an official position on hints ?
>   Will they go away as the optimiser is becoming bettre or they are
>   there to stay ?
>
>   TIA
>
>
>   Stephane Paquette
>   Administrateur de bases de donnees
>   Database Administrator
>   Standard Life
>   www.standardlife.ca
>   Tél. (514) 925-7187
>   [EMAIL PROTECTED]
>
>
>
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thomas Day
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ryan
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PRO

RE: monitor transactions over time

Title: RE: monitor transactions over time





I wrote a script to fix the problem in 9202, but don't tell Oracle ... we want them to fix the bug. as soon as they know there is a workaround, the priority on the bug will go down. Log a iTar and request a patch ... the bug# is 2506744

Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
Subject: monitor transactions over time



List,


Does anybody know a way to monitor the number of transactions occurring over
time, say 5 minute or 10 minute intervals?  I am looking at v$undostat and
it appears to have a problem accumulating transactions under txncount when
it should report over a 10 minute interval ( metalink doc# 260990.995, query
v$undostat) 


BEGIN_TIM END_TIME    UNDOBLKS   TXNCOUNT


-      -   --   --


05-MAR-03 05-MAR-03 38      161519


05-MAR-03 05-MAR-03 24      161468


05-MAR-03 05-MAR-03  1      161227


05-MAR-03 05-MAR-03  4  161075


05-MAR-03 05-MAR-03 71  160881


05-MAR-03 05-MAR-03   6932  160748


05-MAR-03 05-MAR-03  8  160073


05-MAR-03 05-MAR-03  14545  159887


05-MAR-03 05-MAR-03  19588  159010


05-MAR-03 05-MAR-03   2333  157084


05-MAR-03 05-MAR-03   6972  152649  


the undo blocks appear correct, but transactions are accumulating.  Does
anybody know how to use v$transaction or another view to do this? This is
9iRel2 on Unix and the application is geared toward transaction processing.


thanks,    


David Ehresmann 


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


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



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Jared . Still

NetApp SAN?

My understanding of NetApps was that is strictly NAS: Network Attached 
Storage.

Basically, JBOD with NIC.

SAN's offer quite a few more management and configuration options than 
NAS.


Jared






"Spears, Brian" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/07/2003 12:19 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle on a SAN Good, Bad or Proceed with caution?


We ran ORacle on NETapps... about a 100 Production Databases and I spent a
massive
amount (6months) of time verifying that Certain applications were not
hindered by the
Netapp SAN...  There was alot of doubt buy everyone... but in the end it 
was
clear the
San preformed fine..and all the glitches proved to be solved by 
application
redesign.

This vendor told me everything was journalled in memory and pointers were
changing rather
than direct hitting disk becoming an issue.

 I looked at the specs of the disks...ie megs per second capability.. and
compare that
 to what your database is out putting per mount point/ie disk.
 
Bottom line... I was a doubter ...but converted :)

Brian Spears
 





-Original Message-
Sent: Friday, March 07, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L


Darrell,

Could I have a copy of that white paper if you still have it?

Thanks,
Scott


At 08:19 AM 3/7/03 -0800, you wrote:
>Amen!  For several years we heard from EMC reps, don't worry about it, 
>don't worry about it, then recently we we're given a white paper from EMC 

>on striping for Oracle.
>
>
> >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
>SAN is fine as long as you keep track of what's mapping to what physical
>disks. I for one don't believe the SAN vendors that say their caching 
takes
>care of performance for you and you don't need to worry about where data 
is
>stored physically. Place datafiles the same way you would for local 
storage
>and you will do well - striped, with data, indexes, temp, and rollback
>physically separated.
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, March 06, 2003 4:39 PM
>
>
> > Hello,
> >
> > We are currently spec'ing out hardware for our new ERP system.  It is
> > either going to be Peoplesoft or Oracle.  We are also debating on 
using
a
> > SAN rather than attached storage.  I'm just looking for any
> > positives/negatives/rules of thumb I should be aware of when running
>Oracle
> > on a SAN architecture provided that management goes that way.  The SAN
box
> > we are looking at right now is the EVA3000 from HP (although this 
isn't
a
> > definite) not sure if this matters.
> >
> > TIA,
> > -Scott Stefick
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Scott Stefick
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Chuck Hamilton
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Darrell Landrum
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other i

RE: Date format is unreadable

Title: RE: Date format is unreadable





to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400
is a DATE expression
formatting of DATE values is done with the TO_CHAR function (see SQL Reference Manual)


for example:
to_char (to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400,
 '/MM/DD HH24:MI:SS')


-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: vendredi, 7. mars 2003 13:24
To: Multiple recipients of list ORACLE-L
Subject: RE: Date format is unreadable



It works better but it still does give correct output.  I'd like to see hour,min,sec as well. 
    
  1  select user_name,node_name,to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400 from user_activity_log 
  2  from user_activity_log 
  3  where user_name = 'admin'  
  4* order by time_stamp    
SQL> /  
    
USER_NAME    NODE_NAME    TO_DATE(' 
  - 
admin    Insight Server   01-MAY-19 
admin    Insight Server   11-MAY-03 
admin    Insight Server   11-NOV-01 
admin    Insight Server   24-DEC-13 
Thanks, 
David 



-Original Message- 
From: Stephane Faroult [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 05, 2003 4:40 PM 
To: Multiple recipients of list ORACLE-L 
Subject: Re: Date format is unreadable 
Ooops. Should have written 
 to_date('01/01/1970', 'MM/DD/') + TIME_STAMP / 86400 
The timestamp is in seconds since 1/1/1970, while Oracle date arithmetic 
is in days. 
Sorry. 



"Nguyen, David M" wrote: 
> 
> Yes, it is a Unix timestamp.  I use your syntax and I got following error. 
> 
>   1  select 
> user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/')+tig 
>   2  where user_name = 'admin' 
> 
>   3* order by time_stamp 
> 
> SQL> / 
> 
> select user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/') + 
> time_stamp from user_activity_log 
>    * 
> 
> ERROR at line 1: 
> 
> ORA-01841: (full) year must be between -4713 and +, and not be 0 
> 
> 
> 
> -Original Message- 
> Sent: Wednesday, March 05, 2003 3:25 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> David, 
> 
>  I presume that your date is a Unix timestamp. 
> 
> Try to see whether 
> 
>  to_date('01/01/1970', 'MM/DD/') + TIME_STAMP 
> 
> yields something more meaningful to you ... 
> 
> -- 
> Regards, 
> 
> Stephane Faroult 
> Oriole Software 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Stephane Faroult 
  INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California    -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing).

[no subject]

2003-03-07 Thread Schafer, Connie J

SET ORACLE-L NOMAIL
SET RMOUG-L NOMAIL
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Schafer, Connie J
  INET: [EMAIL PROTECTED]

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

Re: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Ryan

sorry about that one... didnt realize it went to you guys. :(
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 07, 2003 3:43 PM


> clearance takes a long time to get. Ran into this before. I had to sign a
> bondage agreement before they do the background check. Cant stay
unemployed
> for that long and its unethical for me to take a job with another company
> and quit on them.
>
> How are the bondage agreements with CSC? Everyone who wanted me to get one
> requires them.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 07, 2003 2:48 PM
>
>
> >
> > Send resume as word attachment to [EMAIL PROTECTED]  I can't guarantee
> > anything and you will have to be clearable but there's sure a lot of
work
> > going on here.
> >
> >
> >
> >>   @cox.net>To:  Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >   Sent by: rootcc:
> >Subject: Anyone looking
> fora  Developer/DBA in Wash DC area?
> >
> >   03/07/2003 01:09
> >   PM
> >   Please respond
> >   to ORACLE-L
> >
> >
> >
> >
> >
> >
> > Yes, I know this isnt a job board and this is the one and only time Ill
do
> > it. The market is tight.
> >
> >  My current contract is up in two weeks. Im a US Citizen(no clearance)
and
> > Im more developer than DBA. I have a good track record with strong
> > references.
> >
> >  Anyone know of anything? Preferably something long term? I want to get
> out
> > of contracting. My only hang-up is that Im working on a Masters so
travel
> > out of the area would be limited.
> >
> >  As I said this is the one and only time Ill send this. I hope you all
> > understand.
> >
> > The first day hints are gone, I will change my career!
> >
> > I do not think it will go away, since Oracle itself uses them to control
> > the way PQ slaves and other background processes work.
> >
> > Also stored outlines is part of it.
> >
> > Regards,
> >
> > Waleed
> >   -Original Message-
> >   From: Stephane Paquette [mailto:[EMAIL PROTECTED]
> >   Sent: Friday, March 07, 2003 11:04 AM
> >   To: Multiple recipients of list ORACLE-L
> >   Subject: Oracle position on hints
> >
> >   Hi,
> >
> >   Does Oracle have an official position on hints ?
> >   Will they go away as the optimiser is becoming bettre or they are
> >   there to stay ?
> >
> >   TIA
> >
> >
> >   Stephane Paquette
> >   Administrateur de bases de donnees
> >   Database Administrator
> >   Standard Life
> >   www.standardlife.ca
> >   Tél. (514) 925-7187
> >   [EMAIL PROTECTED]
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Thomas Day
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ryan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

RE: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Sherman, Paul R.

Well, I'm not sure that you want to get into a bondage agreement, unless you
like getting kinda kinky. You can get 'bonded' through a bonding agency
(that does a background check of varying depth and intensity depending on
the scope of the job's responsibilities. Not the same as getting a
government clearance, though.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 07, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L


clearance takes a long time to get. Ran into this before. I had to sign a
bondage agreement before they do the background check. Cant stay unemployed
for that long and its unethical for me to take a job with another company
and quit on them.

How are the bondage agreements with CSC? Everyone who wanted me to get one
requires them.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 07, 2003 2:48 PM


>
> Send resume as word attachment to [EMAIL PROTECTED]  I can't guarantee
> anything and you will have to be clearable but there's sure a lot of work
> going on here.
>
>
>
>  @cox.net>To:  Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   Sent by: rootcc:
>Subject: Anyone looking
fora  Developer/DBA in Wash DC area?
>
>   03/07/2003 01:09
>   PM
>   Please respond
>   to ORACLE-L
>
>
>
>
>
>
> Yes, I know this isnt a job board and this is the one and only time Ill do
> it. The market is tight.
>
>  My current contract is up in two weeks. Im a US Citizen(no clearance) and
> Im more developer than DBA. I have a good track record with strong
> references.
>
>  Anyone know of anything? Preferably something long term? I want to get
out
> of contracting. My only hang-up is that Im working on a Masters so travel
> out of the area would be limited.
>
>  As I said this is the one and only time Ill send this. I hope you all
> understand.
>
> The first day hints are gone, I will change my career!
>
> I do not think it will go away, since Oracle itself uses them to control
> the way PQ slaves and other background processes work.
>
> Also stored outlines is part of it.
>
> Regards,
>
> Waleed
>   -Original Message-
>   From: Stephane Paquette [mailto:[EMAIL PROTECTED]
>   Sent: Friday, March 07, 2003 11:04 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Oracle position on hints
>
>   Hi,
>
>   Does Oracle have an official position on hints ?
>   Will they go away as the optimiser is becoming bettre or they are
>   there to stay ?
>
>   TIA
>
>
>   Stephane Paquette
>   Administrateur de bases de donnees
>   Database Administrator
>   Standard Life
>   www.standardlife.ca
>   Tél. (514) 925-7187
>   [EMAIL PROTECTED]
>
>
>
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thomas Day
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

RE: Who Owns Unix?

2003-03-07 Thread Brian Dunbar

-Original Message-
Sent: Friday, March 07, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L


Per the below link, SCO owns Unix and they're suing IBM for a paltry
$1Billion: 
http://www.infoworld.com/article/03/03/06/HNsco_1.html 
How can this be? 

Which part?  SCO owning 'Unix' or SCO suing IBM for the paltry $1 billion?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Brian Dunbar
  INET: [EMAIL PROTECTED]

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

monitor transactions over time

2003-03-07 Thread Ehresmann, David

List,

Does anybody know a way to monitor the number of transactions occurring over
time, say 5 minute or 10 minute intervals?  I am looking at v$undostat and
it appears to have a problem accumulating transactions under txncount when
it should report over a 10 minute interval ( metalink doc# 260990.995, query
v$undostat) 

BEGIN_TIM END_TIMEUNDOBLKS   TXNCOUNT

-  -   --   --

05-MAR-03 05-MAR-03 38  161519

05-MAR-03 05-MAR-03 24  161468

05-MAR-03 05-MAR-03  1  161227

05-MAR-03 05-MAR-03  4  161075

05-MAR-03 05-MAR-03 71  160881

05-MAR-03 05-MAR-03   6932  160748

05-MAR-03 05-MAR-03  8  160073

05-MAR-03 05-MAR-03  14545  159887

05-MAR-03 05-MAR-03  19588  159010

05-MAR-03 05-MAR-03   2333  157084

05-MAR-03 05-MAR-03   6972  152649  

the undo blocks appear correct, but transactions are accumulating.  Does
anybody know how to use v$transaction or another view to do this? This is
9iRel2 on Unix and the application is geared toward transaction processing.

thanks,

David Ehresmann 

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

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

Re: OT: Who Owns Unix?

2003-03-07 Thread Lyndon Tiu

But GNU is not UNIX.

-- 
Lyndon Tiu


Quoting "Orr, Steve" <[EMAIL PROTECTED]>:

> Per the below link, SCO owns Unix and they're suing IBM for a
> paltry
> $1Billion:
> > http://www.infoworld.com/article/03/03/06/HNsco_1.html
> > 
> How can this be?
> 
> 


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

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

RE: Who Owns Unix?

Title: RE: Who Owns Unix?





Computerworld says:


http://computerworld.com/governmenttopics/government/legalissues/story/0,10801,79153,00.html


"IBM has built its own AIX Unix under license since February 1985, when the company entered into a Unix license agreement with AT&T Bell Laboratories, which owned Unix at the time. Ten years later, SCO bought the rights and ownership of Unix from AT&T, including source code, source documentation, software development contracts, licenses and other related intellectual property. After the purchase from AT&T, SCO became the licensee to all Unix distributors, including Hewlett-Packard Co., IBM, Silicon Graphics Inc. and Sun Microsystems Inc., according to SCO. The licensing agreements require that the Unix software code be held in confidence and prohibit unauthorized distribution or transfer."

-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]


Per the below link, SCO owns Unix and they're suing IBM for a paltry $1Billion: 
http://www.infoworld.com/article/03/03/06/HNsco_1.html 
How can this be?

Re: Fine Grained Access Control (FGCA)

2003-03-07 Thread Murali Menon

Hi Madhavan
Thanks to you and Jonathan for the input.  
Another question on the same subject.  How are policies defined for child tables. For example if you have an parent table which has say company id so you define a policy on this column. now a parent child related table, the child table is related to the parent and thus has no company id. Now how would one define a policy on this table to take into account the policy defined on the parent table.
Basically select from child table where foreign key matches the rows of the parent and also meets the policy defined on the parent.
Menon
 Madhavan Amruthur <[EMAIL PROTECTED]> wrote:
Hi Murali,In our case since the predicats are generated dynamically and a call tothe function from outside will give me the predicate being applied.Thanks to Jonathan Lews, I will also make sure now using event 10730.Regards,Madhavanhttp://www.dpapps.com> Thanks for the response. I did get it working. However I have another> question. Have you tried to capture what happens behind the scene. I> turned on trace however could not trace the actual query that gets added> to the SQL statement. Only the function call could be traced not the> actual SQL condition> > Thanks> > Menon-- Madhavan AmruthurDecisionPoint Applications-- http://www.fastmail.fm - Choose from over 50 domains or use your own-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Au!
thor: Madhavan AmruthurINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

RE: Date format is unreadable

2003-03-07 Thread Nguyen, David M

Title: RE: Date format is unreadable





It works better but it still does give correct output.  I'd like to see hour,min,sec as well.


    
  1  select user_name,node_name,to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400 from user_activity_log
  2  from user_activity_log 
  3  where user_name = 'admin'  
  4* order by time_stamp    
SQL> /  
    
USER_NAME    NODE_NAME    TO_DATE(' 
  - 
admin    Insight Server   01-MAY-19 
admin    Insight Server   11-MAY-03 
admin    Insight Server   11-NOV-01 
admin    Insight Server   24-DEC-13 


Thanks,
David



-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 05, 2003 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Date format is unreadable


Ooops. Should have written


 to_date('01/01/1970', 'MM/DD/') + TIME_STAMP / 86400


The timestamp is in seconds since 1/1/1970, while Oracle date arithmetic
is in days.


Sorry.



"Nguyen, David M" wrote:
> 
> Yes, it is a Unix timestamp.  I use your syntax and I got following error.
> 
>   1  select
> user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/')+tig
>   2  where user_name = 'admin'
> 
>   3* order by time_stamp
> 
> SQL> /
> 
> select user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/') +
> time_stamp from user_activity_log
>    *
> 
> ERROR at line 1:
> 
> ORA-01841: (full) year must be between -4713 and +, and not be 0
> 
> 
> 
> -Original Message-
> Sent: Wednesday, March 05, 2003 3:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> David,
> 
>  I presume that your date is a Unix timestamp.
> 
> Try to see whether
> 
>  to_date('01/01/1970', 'MM/DD/') + TIME_STAMP
> 
> yields something more meaningful to you ...
> 
> --
> Regards,
> 
> Stephane Faroult
> Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]


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

Re: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Ryan

clearance takes a long time to get. Ran into this before. I had to sign a
bondage agreement before they do the background check. Cant stay unemployed
for that long and its unethical for me to take a job with another company
and quit on them.

How are the bondage agreements with CSC? Everyone who wanted me to get one
requires them.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 07, 2003 2:48 PM


>
> Send resume as word attachment to [EMAIL PROTECTED]  I can't guarantee
> anything and you will have to be clearable but there's sure a lot of work
> going on here.
>
>
>
>  @cox.net>To:  Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   Sent by: rootcc:
>Subject: Anyone looking
fora  Developer/DBA in Wash DC area?
>
>   03/07/2003 01:09
>   PM
>   Please respond
>   to ORACLE-L
>
>
>
>
>
>
> Yes, I know this isnt a job board and this is the one and only time Ill do
> it. The market is tight.
>
>  My current contract is up in two weeks. Im a US Citizen(no clearance) and
> Im more developer than DBA. I have a good track record with strong
> references.
>
>  Anyone know of anything? Preferably something long term? I want to get
out
> of contracting. My only hang-up is that Im working on a Masters so travel
> out of the area would be limited.
>
>  As I said this is the one and only time Ill send this. I hope you all
> understand.
>
> The first day hints are gone, I will change my career!
>
> I do not think it will go away, since Oracle itself uses them to control
> the way PQ slaves and other background processes work.
>
> Also stored outlines is part of it.
>
> Regards,
>
> Waleed
>   -Original Message-
>   From: Stephane Paquette [mailto:[EMAIL PROTECTED]
>   Sent: Friday, March 07, 2003 11:04 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Oracle position on hints
>
>   Hi,
>
>   Does Oracle have an official position on hints ?
>   Will they go away as the optimiser is becoming bettre or they are
>   there to stay ?
>
>   TIA
>
>
>   Stephane Paquette
>   Administrateur de bases de donnees
>   Database Administrator
>   Standard Life
>   www.standardlife.ca
>   Tél. (514) 925-7187
>   [EMAIL PROTECTED]
>
>
>
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thomas Day
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

Metalink related question

Title: Metalink related question





Call me whatever, but how the heck one find out what changes when the note on "Metalink|My Headlines" says "Performance Locking Library Index" changed on 2003/03/07. What changed? maybe I need glasses, but it hasn't been easy to find exactly which documents changed ...

Does anyone know?
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

OT: Who Owns Unix?

2003-03-07 Thread Orr, Steve

Title: OT: Who Owns Unix?





Per the below link, SCO owns Unix and they're suing IBM for a paltry $1Billion:
http://www.infoworld.com/article/03/03/06/HNsco_1.html


How can this be?

RE: perl DBI question: fetchrow_array

2003-03-07 Thread gmei

I tried "fetch" (which is same as fetchrow_arrayref):

$dat->bind_columns(undef,\($row));
while($dat->fetch) {
print DATA "$row\n";
}

And it seems the performance improved a bit (about 5%). Using RowCacheSize
or not does not seem to matter. The size of the table can vary from 1 row to
1 million rows. So I won't use fetchall_arrayref.

Thanks for your help.

Guang

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
> Sent: Thursday, March 06, 2003 5:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: perl DBI question: fetchrow_array
>
>
> 1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted.
>
> 2) I see you've already set RowCacheSize.  Anecdotal evidence
> ( not just
> mine)
> suggests that the diminished returns obtained by setting this
> >100 aren't
> worth it.
>
> 3)  try selectall_arrayref if you're data is not really
> large.  'really
> large' depends
> on your environment.
>
> 4) join DBI users list, found at lists.perl.org.
>
> Jared
>
>
>
>
>
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  03/06/2003 01:34 PM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:Re: perl DBI question: fetchrow_array
>
>
> try using fetchrow_arrayref and see if its faster or less resource
> intensive.
>
>
>
> On Thu, 6 Mar 2003, gmei wrote:
>
> > I have some perl code which selects table data and write it
> into a file.
> I
> > have something like:
> >
> > ---
> > $dbh->{RowCacheSize} = 1;
> > open(DATA, ">$tn") || die "Can't open file\n";
> > $dat=$dbh->prepare("select
> id||chr(9)||FUNCTIONID||chr(9)||GENEID from
> > FUNCTION2GENE");
> > $dat->execute();
> > while(($row) = $dat->fetchrow_array) {
> > print DATA "$row\n";
> > }
> > close(DATA);
> > -
> >
> > I am trying to see if there is any way to speed up the process.
> >
> > So here is my question:
> >
> > Is "fetchrow_array" the fatest way to get the data?
> >
> > TIA.
> >
> > Guang
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: gmei
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Alex
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

RE: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Spears, Brian

We ran ORacle on NETapps... about a 100 Production Databases and I spent a
massive
amount (6months) of time verifying that Certain applications were not
hindered by the
Netapp SAN...  There was alot of doubt buy everyone... but in the end it was
clear the
San preformed fine..and all the glitches proved to be solved by application
redesign.

This vendor told me everything was journalled in memory and pointers were
changing rather
than direct hitting disk becoming an issue.

 I looked at the specs of the disks...ie megs per second capability.. and
compare that
 to what your database is out putting per mount point/ie disk.
 
Bottom line... I was a doubter ...but converted :)

Brian Spears
 





-Original Message-
Sent: Friday, March 07, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L


Darrell,

Could I have a copy of that white paper if you still have it?

Thanks,
Scott


At 08:19 AM 3/7/03 -0800, you wrote:
>Amen!  For several years we heard from EMC reps, don't worry about it, 
>don't worry about it, then recently we we're given a white paper from EMC 
>on striping for Oracle.
>
>
> >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
>SAN is fine as long as you keep track of what's mapping to what physical
>disks. I for one don't believe the SAN vendors that say their caching takes
>care of performance for you and you don't need to worry about where data is
>stored physically. Place datafiles the same way you would for local storage
>and you will do well - striped, with data, indexes, temp, and rollback
>physically separated.
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, March 06, 2003 4:39 PM
>
>
> > Hello,
> >
> > We are currently spec'ing out hardware for our new ERP system.  It is
> > either going to be Peoplesoft or Oracle.  We are also debating on using
a
> > SAN rather than attached storage.  I'm just looking for any
> > positives/negatives/rules of thumb I should be aware of when running
>Oracle
> > on a SAN architecture provided that management goes that way.  The SAN
box
> > we are looking at right now is the EVA3000 from HP (although this isn't
a
> > definite) not sure if this matters.
> >
> > TIA,
> > -Scott Stefick
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Scott Stefick
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Chuck Hamilton
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Darrell Landrum
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Stefick
  INET: [EMAIL PROTECTED]

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

RE: nt script

2003-03-07 Thread Branimir Petrovic

Title: RE: nt script



Do yourself a 
favour - resist temptation of even considering DOS batch "language" (as it 
is nothing more than a horrid pile of I-won't-say-what;-) 

 
Better 
choice is WSH and VBScript or JScript. Windows Scripting Host comes with 
every IE - therefore every Windows machine. Should you go this way keep on mind 
that you will be painting yourself (using M$ proprietary paints) in corner with 
your own hands.
 
It makes the most 
sense to choose cross platform scripting language then use it wherever you go. 
Down side - you'd have to ensure this particular scripting environment is 
installed on all platforms/systems you support.
 
Python and Perl 
are two mature beasts that pack (more than) enough power, and yet are 
platform agnostic. Worth learning? You bet.
 
Branimir

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]Sent: March 7, 2003 1:34 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  nt script
  Can anyone recommend a book / website on the DOS batch file 
  language? I usually try to install cygwin and write shell scripts but some of 
  our database servers don't have cygwin.
  For example, I have no idea what this statement does: 
  FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B 
  and when I tried it I received an error H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B 
  %%A was unexpected at this time.

Re: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Thomas Day


Send resume as word attachment to [EMAIL PROTECTED]  I can't guarantee
anything and you will have to be clearable but there's sure a lot of work
going on here.


   

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

   Subject: Anyone looking fora  
Developer/DBA in Wash DC area?
   

  03/07/2003 01:09 

  PM   

  Please respond   

  to ORACLE-L  

   

   





Yes, I know this isnt a job board and this is the one and only time Ill do
it. The market is tight.

 My current contract is up in two weeks. Im a US Citizen(no clearance) and
Im more developer than DBA. I have a good track record with strong
references.

 Anyone know of anything? Preferably something long term? I want to get out
of contracting. My only hang-up is that Im working on a Masters so travel
out of the area would be limited.

 As I said this is the one and only time Ill send this. I hope you all
understand.

The first day hints are gone, I will change my career!

I do not think it will go away, since Oracle itself uses them to control
the way PQ slaves and other background processes work.

Also stored outlines is part of it.

Regards,

Waleed
  -Original Message-
  From: Stephane Paquette [mailto:[EMAIL PROTECTED]
  Sent: Friday, March 07, 2003 11:04 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Oracle position on hints

  Hi,

  Does Oracle have an official position on hints ?
  Will they go away as the optimiser is becoming bettre or they are
  there to stay ?

  TIA


  Stephane Paquette
  Administrateur de bases de donnees
  Database Administrator
  Standard Life
  www.standardlife.ca
  Tél. (514) 925-7187
  [EMAIL PROTECTED]











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

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

RE: nt script

One bump you might encounter is some of the more useful NT shell commands are only 
available from the NT resource kit.

>>> [EMAIL PROTECTED] 03/07/03 01:09PM >>>

C:\> HELP

and

C:\> HELP FOR

In there you'll find a note that the context variable should have
'%%' instead of '%' in front of it when running in a bat file.

You were using the bat file syntax from a command linewon't
work. The opposite is also true...ask me how I know  =8-)

Jeff Herrick

On Fri, 7 Mar 2003, Jacques Kilchoer wrote:

> Can anyone recommend a book / website on the DOS batch file language? I
> usually try to install cygwin and write shell scripts but some of our
> database servers don't have cygwin.
> For example, I have no idea what this statement does:
> FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> and when I tried it I received an error
> H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> %%A was unexpected at this time.
>
> > -Original Message-
> > From: Jose Luis Delgado [mailto:[EMAIL PROTECTED] 
> >
> > I'll try to help you between lines...
> >
> > i.e. I'll write the corresponding CMD line for your
> > script.
> >
> > Regards!
> > JL
> >
> > in a .CMD file:
> >
> > > echo Sending mail!!!
> > echo Sending mail!!!
> >
> > > dt=$(date '+%H%M_%m%d%y')
> > FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> >
> > > export ORACLE_SID=FMRPT
> > SET ORACLE_SID=FMRPT
> >
> > > sqlplus / < sqllog
> >
> > in a file: say a.sql put the code of your query and
> > type:
> >
> > sqlplus user/[EMAIL PROTECTED] < a.sql > sqllog.log
> >
> > >set heading off
> > > SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
> > >   WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
> > >  ...
> > >  ...
> >
> > > cat sqllog |egrep 'DOWN' > errfilelog
> >
> > type sqllog.log | findstr 'DOWN' > errfilelog.log
> >
> > > cat sqllog | egrep -q 'DOWN'
> >
> > I apologize for the previous line, I could not find a
> > -q parameter of the egrep command, in my OS.
> > anyway... 'guessing'
> >
> > type sqllog | findstr - 'DOWN'
> >
> > > if [ $? -eq 0 ] # found at least one
> >
> > if errorlevel 1 
>

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

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

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

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

LPAR on AIX and Oracle Licensing

2003-03-07 Thread Henry, Keith


Our systems folks are talking about consolidating a couple of machines by using LPARs.

If we have a machine running AIX with 6 processors, can we license Oracle with 2 
processors if those are segmented out within an LPAR?

It's always a challenge to get hold of our sales rep, so I thought I would ask here.

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

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

Re:RE: Oracle position on hints

2003-03-07 Thread dgoulet

Stephane,

I'm going to agree with many on the list in that I don't believe Oracle will
drop the concept.  But on the other hand I don't like them either, not do I like
the idea of stored outlines either.  The reason is that with both your trying to
ham string the optimizer into doing things your way, which may be just fine
today but when you add a gazillion rows of data things change & that highly
selective index you were sure you wanted to use is now less than useless.  I
don't think hints were introduced because Oracle's optimizer is immature, it
actually appears to be more matured than most other vendors, but that some
duhvelepors want things their way.

Dick Goulet

Reply Separator
Author: "Stephane Paquette" <[EMAIL PROTECTED]>
Date:   3/7/2003 10:19 AM

Hi,

I have to write a SQL and PL/SQL guide for our developpers.
Some are good but most of them can use help.

I'm not a big fan of hints except for insert append, I used them only if I
really need to.

In last october I went to a 3 days DB2 UDB course, unless I miss something
there are no hint with DB2 UDB.
So I was thinking that when the Oracle optimiser would be more mature maybe
hints would go away.

I just want to know what is Oracle direction with hints.

TIA

Stephane


-Original Message-
Robert - IL
Sent: Friday, March 07, 2003 12:01 PM
To: Multiple recipients of list ORACLE-L


This is facinating, where does this come from? This is the second time in a
week that I've heard this statement being made by someone. Hints will never
go away IMHO, and Oracle continues to add more and more of them. I was told
by someone at a client site that they were told by an Oracle instructor that
they should not use hints in 9i

RF

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

Hi,

Does Oracle have an official position on hints ?
Will they go away as the optimiser is becoming bettre or they are there
to stay ?

TIA



Stephane Paquette


Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tél. (514) 925-7187

[EMAIL PROTECTED]



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

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

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

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


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

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

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Scott Stefick

That's great!  Thanks a ton.

-Scott

At 10:44 AM 3/7/03 -0800, you wrote:
I'm pretty sure I only recieved a hard copy (I'm not in the office to 
check), but they publish a lot of pdf documents on their site.  I'll see 
if I can locate it there and send a URL.

>>> [EMAIL PROTECTED] 03/07/03 10:55AM >>>
Darrell,
Could I have a copy of that white paper if you still have it?

Thanks,
Scott
At 08:19 AM 3/7/03 -0800, you wrote:
>Amen!  For several years we heard from EMC reps, don't worry about it,
>don't worry about it, then recently we we're given a white paper from EMC
>on striping for Oracle.
>
>
> >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
>SAN is fine as long as you keep track of what's mapping to what physical
>disks. I for one don't believe the SAN vendors that say their caching takes
>care of performance for you and you don't need to worry about where data is
>stored physically. Place datafiles the same way you would for local storage
>and you will do well - striped, with data, indexes, temp, and rollback
>physically separated.
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, March 06, 2003 4:39 PM
>
>
> > Hello,
> >
> > We are currently spec'ing out hardware for our new ERP system.  It is
> > either going to be Peoplesoft or Oracle.  We are also debating on using a
> > SAN rather than attached storage.  I'm just looking for any
> > positives/negatives/rules of thumb I should be aware of when running
>Oracle
> > on a SAN architecture provided that management goes that way.  The 
SAN box
> > we are looking at right now is the EVA3000 from HP (although this isn't a
> > definite) not sure if this matters.
> >
> > TIA,
> > -Scott Stefick
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Scott Stefick
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Chuck Hamilton
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Darrell Landrum
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

RE: nt script

2003-03-07 Thread Kevin Lange

Title: RE: nt script



If you 
just do a HELP COMMAND, where command is the name of the command you need help 
on, you can find out as much as you really need to know about 
BATCH.
 
In 
your sample of  FOR /F 
"TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B 

They were trying to set a variable called 
DATE based on the system date.
 
First of all , %%A should be %A and %%B 
should be %B if you are running this command in a command line.   If 
you place it in a batch file the way you have it, it will work.
 
First 2 values from the DATE/T command are 
placed in the variables %A and %B.  Then, for each line returned in this 
command (1), you set the variable DATE equal to the second returned value 
(%B).
 
For example, today the DATE/T returns 'Fri 
03/07/2003".  Therefore, %A gets set to FRI and %B gets set to 
03/07/2003.  When your command completes, the variable DATE will be equal 
to %B or 03/07/2003.
 
--
This was determined by doing a help on the 
FOR command:
 
help for
 
FOR /F ["options"] %variable IN 
(file-set) DO command [command-parameters]FOR /F ["options"] %variable IN 
("string") DO command [command-parameters]FOR /F ["options"] %variable IN 
('command') DO command [command-parameters]
 
    or, if usebackq 
option present:
 
FOR /F ["options"] %variable IN 
(file-set) DO command [command-parameters]FOR /F ["options"] %variable IN 
('string') DO command [command-parameters]FOR /F ["options"] %variable IN 
(`command`) DO command [command-parameters]
 
    filenameset is one 
or more file names.  Each file is opened, read    and 
processed before going on to the next file in filenameset.    
Processing consists of reading in the file, breaking it up 
into    individual lines of text and then parsing each line 
into zero or    more tokens.  The body of the for loop 
is then called with the    variable value(s) set to the found 
token string(s).  By default, /F    passes the first 
blank separated token from each line of each file.    Blank 
lines are skipped.  You can override the default 
parsing    behavior by specifying the optional "options" 
parameter.  This    is a quoted string which contains 
one or more keywords to specify    different parsing 
options.  The keywords are:
 
    
eol=c   - specifies an 
end of line comment 
character  
(just one)    
skip=n  - specifies the 
number of lines to skip at 
the  
beginning of the file.    
delims=xxx  - specifies a delimiter set.  This 
replaces 
the  
default delimiter set of space and 
tab.    tokens=x,y,m-n  - 
specifies which tokens from each line are 
to  
be passed to the for body for each 
iteration.  
This will cause additional variable names 
to  
be allocated.  The m-n form is a 
range,  
specifying the mth through the nth tokens.  
If  
the last character in the tokens= string is 
an  
asterisk, then an additional variable 
is  
allocated and receives the remaining text 
on  
the line after the last token 
parsed.    
usebackq    - specifies that the new 
semantics are in 
force,  
where a back quoted string is executed as 
a  
command and a single quoted string is 
a  
literal string command and allows the use 
of  
double quotes to quote file names 
in  
filenameset.

ora-06512 errors - flushing shared_pool takes care of it - WHY?

2003-03-07 Thread Fedock, John (KAM.RHQ)





I have a perplexing issue that I hope someone may have 
some ideas on.
 
We have a Windows2000 server using COM+ 
applications to connect to a 8.1.7.4 OPFS HP-UX database to process large 
amounts of EDI records.  There is no pattern, but on average 2 times a 
week, this application that is processing heavy EDI 
will error off with "ORA-01858: a non-numeric 
character was found where a numeric was expected 
and ORA-06512: at line 1 errors."  
Note that these errors are showing up in the EDI load logs and are NOT generated 
in the database (8.1.7.4, HP-UX).  If I flush the shared_pool, and 
immediatly rerun the EDI load, the data will load correctly.  I cannot 
understand why flushing the shared_pool helps this and how to correct so our EDI 
processing does not error.  There are no shared_pool errors in the alert 
log (no 4031s, no 4030s).  
 
A few others 
on MetaLink have had similiar errors, but no resolution has been 
posted.
 
When this 
happens I am taking system state dumps and sending to 
Oracle.
 
So, in a 
nutshell, my EDI loading will stall (or error off with misc ora-6512s).  If 
I flush the shared_pool, it starts to process just fine.  Any ideas - 
besides just flushing the shared_pool often?
 
TIA.
 
JF
 
 
John Fedock "K" Line America, 
Inc. www.kline.com * [EMAIL PROTECTED]

RE: nt script

2003-03-07 Thread Jeff Herrick


C:\> HELP

and

C:\> HELP FOR

In there you'll find a note that the context variable should have
'%%' instead of '%' in front of it when running in a bat file.

You were using the bat file syntax from a command linewon't
work. The opposite is also true...ask me how I know  =8-)

Jeff Herrick

On Fri, 7 Mar 2003, Jacques Kilchoer wrote:

> Can anyone recommend a book / website on the DOS batch file language? I
> usually try to install cygwin and write shell scripts but some of our
> database servers don't have cygwin.
> For example, I have no idea what this statement does:
> FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> and when I tried it I received an error
> H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> %%A was unexpected at this time.
>
> > -Original Message-
> > From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]
> >
> > I'll try to help you between lines...
> >
> > i.e. I'll write the corresponding CMD line for your
> > script.
> >
> > Regards!
> > JL
> >
> > in a .CMD file:
> >
> > > echo Sending mail!!!
> > echo Sending mail!!!
> >
> > > dt=$(date '+%H%M_%m%d%y')
> > FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> >
> > > export ORACLE_SID=FMRPT
> > SET ORACLE_SID=FMRPT
> >
> > > sqlplus / < sqllog
> >
> > in a file: say a.sql put the code of your query and
> > type:
> >
> > sqlplus user/[EMAIL PROTECTED] < a.sql > sqllog.log
> >
> > >set heading off
> > > SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
> > >   WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
> > >  ...
> > >  ...
> >
> > > cat sqllog |egrep 'DOWN' > errfilelog
> >
> > type sqllog.log | findstr 'DOWN' > errfilelog.log
> >
> > > cat sqllog | egrep -q 'DOWN'
> >
> > I apologize for the previous line, I could not find a
> > -q parameter of the egrep command, in my OS.
> > anyway... 'guessing'
> >
> > type sqllog | findstr - 'DOWN'
> >
> > > if [ $? -eq 0 ] # found at least one
> >
> > if errorlevel 1 
>

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

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

RE: Oracle position on hints

2003-03-07 Thread Pete Sharman

Title: RE: Oracle position on hints









The hints,
actually, but then I haven't heard anything of the instructors going away
either!  J

 



Pete

 

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

 

"Oh no it's not.  It's much
harder than that!"

Bruce Pihlamae, long-term Oracle DBA.



 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni,
Rajendra
Sent: Friday, March 07, 2003 10:14
AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle position on
hints

 

Pete 
when you say ... "I haven't
heard anything about them going away." you mean the hints or them
instructors ?? 

Raj 
-

Rajendra dot Jamadagni at espn dot
com 
Any views expressed here are
strictly personal. 
QOTD: Any clod can have facts,
having an opinion is an art !! 

 

-Original Message- 
From: Pete Sharman [mailto:[EMAIL PROTECTED]]

Sent: Friday, March 07, 2003 12:29
PM 
To: Multiple recipients of list
ORACLE-L 
Subject: RE: Oracle position on
hints 

 

You just gotta wonder about some instructors.  :(


I haven't heard anything about them going away.


Pete

RE: nt script

Windows NT Shell Scripting by Tim Hill is a very good start.

>>> [EMAIL PROTECTED] 03/07/03 12:34PM >>>
Can anyone recommend a book / website on the DOS batch file language? I
usually try to install cygwin and write shell scripts but some of our
database servers don't have cygwin.
For example, I have no idea what this statement does:
FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
and when I tried it I received an error
H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
%%A was unexpected at this time.

> -Original Message-
> From: Jose Luis Delgado [mailto:[EMAIL PROTECTED] 
> 
> I'll try to help you between lines...
> 
> i.e. I'll write the corresponding CMD line for your
> script.
> 
> Regards!
> JL
> 
> in a .CMD file:
> 
> > echo Sending mail!!!
> echo Sending mail!!!
> 
> > dt=$(date '+%H%M_%m%d%y')
> FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> 
> > export ORACLE_SID=FMRPT
> SET ORACLE_SID=FMRPT
> 
> > sqlplus / < sqllog
> 
> in a file: say a.sql put the code of your query and
> type:
> 
> sqlplus user/[EMAIL PROTECTED] < a.sql > sqllog.log
> 
> >set heading off
> > SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
> >   WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
> >  ...
> >  ...
> 
> > cat sqllog |egrep 'DOWN' > errfilelog
> 
> type sqllog.log | findstr 'DOWN' > errfilelog.log
> 
> > cat sqllog | egrep -q 'DOWN'
> 
> I apologize for the previous line, I could not find a
> -q parameter of the egrep command, in my OS.
> anyway... 'guessing'
> 
> type sqllog | findstr - 'DOWN'
> 
> > if [ $? -eq 0 ] # found at least one
> 
> if errorlevel 1  

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

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

RE: Oracle position on hints

2003-03-07 Thread Molina, Gerardo

I have heard from Oracle that you should stop using RULE hints as the
Rule-based optimizer (RBO) will eventually be retired or totally
unsupported.

We are moving away from analyze as well and using dbms_stats instead because
analyze is also going away.  Migrating to dbms_stats is a first step for us
to shift from RULE hints to the CBO.

So maybe the message "Stop using hints" only applies to particular types of
hints like RULE hints.

Gerardo


-Original Message-
Sent: Friday, March 07, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L



There's always the possibility of a gap between
what was said and what was heard.

In my seminar, I tell people about hints, and
mention a useful ones - and then say they should
avoid using them if possible.  Perhaps the quoted
instructor said something more like "you shouldn't
use hints in 9i if you can avoid it" meaning "you
usually don't need to use hints, and they should
be the method of last resort".

It is certainly a good idea to use the UNNEST
hint from time to time in 9i.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
UK___April 8th
UK___April 22nd

USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


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


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 07 March 2003 17:01


This is facinating, where does this come from? This is the second time in a
week that I've heard this statement being made by someone. Hints will never
go away IMHO, and Oracle continues to add more and more of them. I was told
by someone at a client site that they were told by an Oracle instructor that
they should not use hints in 9i

RF




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

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

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

RE: Cannot delete datafile from O/S -- Help !!

Title: RE: Cannot delete datafile from O/S -- Help !!

(B
(B
(B
(B
(BAs others have said, it's probably because on Windows you sometimes have to wait a few minutes.
(BI did want to mention that this statment:
(Bselect * from v$datafile where name = 'DATA14.DBF';
(Bseems wrong to me, since the name column in v$datafile usually contains the path along with the filename, and running such a query might cause you to believe a file named data14.dbf is not one of your datafiles when in fact it is (preceded by the directory path.)
(B
(B> -Original Message-
(B> From: Prem Khanna J [mailto:[EMAIL PROTECTED]]
(B> 
(B> SQL> drop tablespace DATA14 including contents;
(B> Tablespace dropped.
(B> 
(B> the name of the datafile in DATA14 tablespace is DATA141.DBF
(B> 
(B> SQL>select * from v$tablespace where name = 'DATA14';
(B> no rows selected
(B> 
(B> SQL>select * from v$tdatafile where name = 'DATA14.DBF';
(B> no rows selected
(B> 
(B> when i try to delete the file DATA14.DBF from o/s , it says :
(B> "Cannot delete DATA14. There has been a sharing violation.The 
(B> source or destination file may be in use."
(B> 
(B> why is it so ? how can i delete the file from O/S ?
(B> can someone help me ?
(B> 
(B> the ENV is 8.1.6 / win2k.
(B
(B
(B
(B

RE: nt script

Title: RE: nt script



I have found http://www.calweb.com/~webspace/batch/index.htm to 
be useful.
 
Raj
- 
Rajendra dot Jamadagni at espn dot 
com Any views expressed here are 
strictly personal. QOTD: Any clod can 
have facts, having an opinion is an art !! 

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 07, 2003 
  1:34 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: nt script
  Can anyone recommend a book / website on the DOS batch file 
  language? I usually try to install cygwin and write shell scripts but some of 
  our database servers don't have cygwin.
  For example, I have no idea what this statement does: 
  FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B 
  and when I tried it I received an error H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B 
  %%A was unexpected at this time. 
  > -Original Message- > 
  From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]] 
  > > I'll try to help you 
  between lines... > > 
  i.e. I'll write the corresponding CMD line for your > script. > > 
  Regards! > JL > 
  > in a .CMD file: > 
  > > echo Sending mail!!! > echo Sending mail!!! > > > dt=$(date '+%H%M_%m%d%y') > FOR /F 
  "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B > 
  > > export ORACLE_SID=FMRPT > SET ORACLE_SID=FMRPT > > > sqlplus / < 
  sqllog > > in a file: 
  say a.sql put the code of your query and > 
  type: > > sqlplus 
  user/[EMAIL PROTECTED] < a.sql > sqllog.log > 
  > >    set heading off 
  > > SELECT 'FMRPT PSNTRP02 
  SCHEDULER DOWN' FROM DUAL > >   WHERE 
  EXISTS (SELECT 'X' FROM PSSERVERSTAT > >  
  ... > >  ... > 
  > > cat sqllog |egrep 'DOWN' > 
  errfilelog > > type 
  sqllog.log | findstr 'DOWN' > errfilelog.log > 
  > > cat sqllog | egrep -q 'DOWN' 
  > > I apologize for the 
  previous line, I could not find a > -q parameter of 
  the egrep command, in my OS. > anyway... 
  'guessing' > > type 
  sqllog | findstr - 'DOWN' > > 
  > if [ $? -eq 0 
  ] # found at least one 
  > > if errorlevel 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.*2

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they 
publish a lot of pdf documents on their site.  I'll see if I can locate it there and 
send a URL.

>>> [EMAIL PROTECTED] 03/07/03 10:55AM >>>
Darrell,

Could I have a copy of that white paper if you still have it?

Thanks,
Scott


At 08:19 AM 3/7/03 -0800, you wrote:
>Amen!  For several years we heard from EMC reps, don't worry about it, 
>don't worry about it, then recently we we're given a white paper from EMC 
>on striping for Oracle.
>
>
> >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
>SAN is fine as long as you keep track of what's mapping to what physical
>disks. I for one don't believe the SAN vendors that say their caching takes
>care of performance for you and you don't need to worry about where data is
>stored physically. Place datafiles the same way you would for local storage
>and you will do well - striped, with data, indexes, temp, and rollback
>physically separated.
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, March 06, 2003 4:39 PM
>
>
> > Hello,
> >
> > We are currently spec'ing out hardware for our new ERP system.  It is
> > either going to be Peoplesoft or Oracle.  We are also debating on using a
> > SAN rather than attached storage.  I'm just looking for any
> > positives/negatives/rules of thumb I should be aware of when running
>Oracle
> > on a SAN architecture provided that management goes that way.  The SAN box
> > we are looking at right now is the EVA3000 from HP (although this isn't a
> > definite) not sure if this matters.
> >
> > TIA,
> > -Scott Stefick
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> > --
> > Author: Scott Stefick
> >   INET: [EMAIL PROTECTED] 
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net 
>--
>Author: Chuck Hamilton
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net 
>--
>Author: Darrell Landrum
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Scott Stefick
  INET: [EMAIL PROTECTED] 

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
S

RE: remota / as sysdba

Title: RE: remota / as sysdba





I'm glad that worked for you, but I've never had to recreate the password file after a password change. (In my little part of the world we have password files on databases ranging from Oracle versions 8.0 to 9.2 on both Windows NT/2000 and Solaris).

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> 
> The solution seems to be dropping and re-creating the orapwd file.
> I had changed the sys password after I had created the password file;
> the docs say the file should pick up this password change without
> having to re-create it, but re-creating it fixed the problem.

Re: Oracle position on hints

2003-03-07 Thread Jonathan Lewis


There's always the possibility of a gap between
what was said and what was heard.

In my seminar, I tell people about hints, and
mention a useful ones - and then say they should
avoid using them if possible.  Perhaps the quoted
instructor said something more like "you shouldn't
use hints in 9i if you can avoid it" meaning "you
usually don't need to use hints, and they should
be the method of last resort".

It is certainly a good idea to use the UNNEST
hint from time to time in 9i.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
UK___April 8th
UK___April 22nd

USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


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


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 07 March 2003 17:01


This is facinating, where does this come from? This is the second time
in a
week that I've heard this statement being made by someone. Hints will
never
go away IMHO, and Oracle continues to add more and more of them. I was
told
by someone at a client site that they were told by an Oracle
instructor that
they should not use hints in 9i

RF




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

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

RE: nt script

Title: RE: nt script





Can anyone recommend a book / website on the DOS batch file language? I usually try to install cygwin and write shell scripts but some of our database servers don't have cygwin.

For example, I have no idea what this statement does:
FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
and when I tried it I received an error
H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
%%A was unexpected at this time.


> -Original Message-
> From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]]
> 
> I'll try to help you between lines...
> 
> i.e. I'll write the corresponding CMD line for your
> script.
> 
> Regards!
> JL
> 
> in a .CMD file:
> 
> > echo Sending mail!!!
> echo Sending mail!!!
> 
> > dt=$(date '+%H%M_%m%d%y')
> FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> 
> > export ORACLE_SID=FMRPT
> SET ORACLE_SID=FMRPT
> 
> > sqlplus / < sqllog
> 
> in a file: say a.sql put the code of your query and
> type:
> 
> sqlplus user/[EMAIL PROTECTED] < a.sql > sqllog.log
> 
> >    set heading off
> > SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
> >   WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
> >  ...
> >  ...
> 
> > cat sqllog |egrep 'DOWN' > errfilelog
> 
> type sqllog.log | findstr 'DOWN' > errfilelog.log
> 
> > cat sqllog | egrep -q 'DOWN'
> 
> I apologize for the previous line, I could not find a
> -q parameter of the egrep command, in my OS.
> anyway... 'guessing'
> 
> type sqllog | findstr - 'DOWN'
> 
> > if [ $? -eq 0 ] # found at least one
> 
> if errorlevel 1

RE: Oracle position on hints

2003-03-07 Thread Stephane Paquette

Hi,

I have to write a SQL and PL/SQL guide for our developpers.
Some are good but most of them can use help.

I'm not a big fan of hints except for insert append, I used them only if I
really need to.

In last october I went to a 3 days DB2 UDB course, unless I miss something
there are no hint with DB2 UDB.
So I was thinking that when the Oracle optimiser would be more mature maybe
hints would go away.

I just want to know what is Oracle direction with hints.

TIA

Stephane


-Original Message-
Robert - IL
Sent: Friday, March 07, 2003 12:01 PM
To: Multiple recipients of list ORACLE-L


This is facinating, where does this come from? This is the second time in a
week that I've heard this statement being made by someone. Hints will never
go away IMHO, and Oracle continues to add more and more of them. I was told
by someone at a client site that they were told by an Oracle instructor that
they should not use hints in 9i

RF

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

Hi,

Does Oracle have an official position on hints ?
Will they go away as the optimiser is becoming bettre or they are there
to stay ?

TIA



Stephane Paquette


Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tél. (514) 925-7187

[EMAIL PROTECTED]



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

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

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

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

RE: Oracle position on hints

Title: RE: Oracle position on hints





Pete
when you say ... "I haven't heard anything about them going away." you mean the hints or them instructors ??


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Pete Sharman [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle position on hints



You just gotta wonder about some instructors.  :(


I haven't heard anything about them going away.


Pete



*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: nt script

2003-03-07 Thread Joan Hsieh

Hi Jose,

Many many thanks to you. This is great.

Joan



Jose Luis Delgado wrote:
> 
> Hi!!
> 
> I'll try to help you between lines...
> 
> i.e. I'll write the corresponding CMD line for your
> script.
> 
> Regards!
> JL
> 
> in a .CMD file:
> 
> > echo Sending mail!!!
> echo Sending mail!!!
> 
> > dt=$(date '+%H%M_%m%d%y')
> FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
> 
> > export ORACLE_SID=FMRPT
> SET ORACLE_SID=FMRPT
> 
> > sqlplus / < sqllog
> 
> in a file: say a.sql put the code of your query and
> type:
> 
> sqlplus user/[EMAIL PROTECTED] < a.sql > sqllog.log
> 
> >set heading off
> > SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
> >   WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
> >  ...
> >  ...
> 
> > cat sqllog |egrep 'DOWN' > errfilelog
> 
> type sqllog.log | findstr 'DOWN' > errfilelog.log
> 
> > cat sqllog | egrep -q 'DOWN'
> 
> I apologize for the previous line, I could not find a
> -q parameter of the egrep command, in my OS.
> anyway... 'guessing'
> 
> type sqllog | findstr - 'DOWN'
> 
> > if [ $? -eq 0 ] # found at least one
> 
> if errorlevel 1 
> 
> Hope this helps!
> JL
> 
> __
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jose Luis Delgado
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

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

Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread rgaffuri

Yes, I know this isnt a job board and this is the one and only time Ill do
it. The market is tight.

 My current contract is up in two weeks. Im a US Citizen(no clearance) and
Im more developer than DBA. I have a good track record with strong
references.

 Anyone know of anything? Preferably something long term? I want to get out
of contracting. My only hang-up is that Im working on a Masters so travel
out of the area would be limited.

 As I said this is the one and only time Ill send this. I hope you all
understand.




The first day 
hints are gone, I will change my career!
 
I do not think it 
will go away, since Oracle itself uses them to control the way PQ slaves and 
other background processes work.
 
Also stored 
outlines is part of it.
 
Regards,
 
Waleed 

  -Original Message-From: Stephane Paquette 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 07, 
  2003 11:04 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Oracle position on hints
  Hi,
   
  Does Oracle have 
  an official position on hints ?
  Will they go away 
  as the optimiser is becoming bettre or they are there to stay 
  ?
   
  TIA
   
   
  
  
  Stephane 
  Paquette
  Administrateur 
  de bases de donnees
  Database 
  Administrator
  Standard 
  Life
  www.standardlife.ca
  Tél. 
  (514) 925-7187
  [EMAIL PROTECTED]

9iAS Hardware Questions

2003-03-07 Thread David . Schmoldt

I have three questions pertaining to the hardware for Oracle 9ias with the
infrastructure.

1) The server we are looking at purchasing comes with a choice of 2
processors. One is a 2.8 GHz with 512KB cache, the other is 2.0 GHz with 2MB
cache. Does anybody have any suggestions or experience with the difference
between those chips and which would be better for the 9ias environment?

2) How critical is having multiple drives versus a single drive (besides the
system disk) with Oracle 9ias?

3) We will be licensed for 2 cpus. Would we be better off with one server
with 9ias and infrastructure on it with 2 cpus or having 2 servers with one
cpu each splitting up the infrastructure from the application server?


Roland Fay
Database Administrator
Gazette Communications
500 3rd Ave SE
Cedar Rapids, IA 52401
319-399-5985
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

RE: Oracle position on hints

2003-03-07 Thread Paula_Stankus

Title: RE: Oracle position on hints





I heard this from a COTS vendor once.  I also thought it was ridiculous.  It is one of the useful ways to tune SQL Statements.  I have only gotten the impression from their inception into the Oracle RDBMS that they were advocated by Oracle.  

-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 12:01 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle position on hints



This is facinating, where does this come from? This is the second time in a
week that I've heard this statement being made by someone. Hints will never
go away IMHO, and Oracle continues to add more and more of them. I was told
by someone at a client site that they were told by an Oracle instructor that
they should not use hints in 9i


RF


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


Hi,
 
Does Oracle have an official position on hints ?
Will they go away as the optimiser is becoming bettre or they are there
to stay ?
 
TIA
 
 


Stephane Paquette



Administrateur de bases de donnees


Database Administrator


Standard Life


www.standardlife.ca


Tél. (514) 925-7187


[EMAIL PROTECTED]
 


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


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

RE: Oracle position on hints

2003-03-07 Thread Pete Sharman

You just gotta wonder about some instructors.  :(

I haven't heard anything about them going away.

Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA.


-Original Message-
Robert - IL
Sent: Friday, March 07, 2003 9:01 AM
To: Multiple recipients of list ORACLE-L

This is facinating, where does this come from? This is the second time
in a
week that I've heard this statement being made by someone. Hints will
never
go away IMHO, and Oracle continues to add more and more of them. I was
told
by someone at a client site that they were told by an Oracle instructor
that
they should not use hints in 9i

RF

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

Hi,
 
Does Oracle have an official position on hints ?
Will they go away as the optimiser is becoming bettre or they are there
to stay ?
 
TIA
 
 

Stephane Paquette


Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tél. (514) 925-7187

[EMAIL PROTECTED]
 

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

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


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

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

RE: Oracle position on hints




in 9202, oracle uses hard coded hints for recursive SQL ... and they say 
that analyzing SYS schema is okay ...
 
Ha !!
Raj
- 
Rajendra dot Jamadagni at espn dot 
com Any views expressed here are 
strictly personal. QOTD: Any clod can 
have facts, having an opinion is an art !! 

  -Original Message-From: Khedr, Waleed 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 07, 2003 12:25 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle position on hints
  The first day 
  hints are gone, I will change my career!
   
  I do not think 
  it will go away, since Oracle itself uses them to control the way PQ slaves 
  and other background processes work.
   
  Also stored 
  outlines is part of it.
   
  Regards,
   
  Waleed 
  
-Original Message-From: Stephane Paquette 
[mailto:[EMAIL PROTECTED]Sent: Friday, March 07, 
2003 11:04 AMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle position on hints
Hi,
 
Does Oracle have 
an official position on hints ?
Will they go 
away as the optimiser is becoming bettre or they are there to stay 
?
 
TIA
 
 


Stephane 
Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tél. 
(514) 925-7187
[EMAIL PROTECTED]
 
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: nt script

2003-03-07 Thread Jose Luis Delgado

Hi!!

I'll try to help you between lines...

i.e. I'll write the corresponding CMD line for your
script.

Regards!
JL

in a .CMD file:

> echo Sending mail!!!
echo Sending mail!!!

> dt=$(date '+%H%M_%m%d%y')
FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B

> export ORACLE_SID=FMRPT
SET ORACLE_SID=FMRPT

> sqlplus / < sqllog

in a file: say a.sql put the code of your query and
type:

sqlplus user/[EMAIL PROTECTED] < a.sql > sqllog.log

>set heading off
> SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
>   WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
>  ...
>  ...

> cat sqllog |egrep 'DOWN' > errfilelog

type sqllog.log | findstr 'DOWN' > errfilelog.log

> cat sqllog | egrep -q 'DOWN'

I apologize for the previous line, I could not find a
-q parameter of the egrep command, in my OS.
anyway... 'guessing'

type sqllog | findstr - 'DOWN'

> if [ $? -eq 0 ] # found at least one

if errorlevel 1  

Hope this helps!
JL


__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

RE: Oracle position on hints

2003-03-07 Thread Khedr, Waleed




The first day 
hints are gone, I will change my career!
 
I do not think it 
will go away, since Oracle itself uses them to control the way PQ slaves and 
other background processes work.
 
Also stored 
outlines is part of it.
 
Regards,
 
Waleed 

  -Original Message-From: Stephane Paquette 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 07, 
  2003 11:04 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Oracle position on hints
  Hi,
   
  Does Oracle have 
  an official position on hints ?
  Will they go away 
  as the optimiser is becoming bettre or they are there to stay 
  ?
   
  TIA
   
   
  
  
  Stephane 
  Paquette
  Administrateur 
  de bases de donnees
  Database 
  Administrator
  Standard 
  Life
  www.standardlife.ca
  Tél. 
  (514) 925-7187
  [EMAIL PROTECTED]

Re: Oracle position on hints

2003-03-07 Thread rgaffuri

Ive seen Tom Kyte post on his site that he doesnt like hints. However, even in 9i 
there are times when I need to use hints to improve performance. 




Hi,
 
Does Oracle have an 
official position on hints ?
Will they go away as 
the optimiser is becoming bettre or they are there to stay ?
 
TIA
 
 


Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tél. 
(514) 925-7187
[EMAIL PROTECTED]

RE: Oracle position on hints

2003-03-07 Thread Freeman Robert - IL

This is facinating, where does this come from? This is the second time in a
week that I've heard this statement being made by someone. Hints will never
go away IMHO, and Oracle continues to add more and more of them. I was told
by someone at a client site that they were told by an Oracle instructor that
they should not use hints in 9i

RF

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

Hi,
 
Does Oracle have an official position on hints ?
Will they go away as the optimiser is becoming bettre or they are there
to stay ?
 
TIA
 
 

Stephane Paquette


Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tél. (514) 925-7187

[EMAIL PROTECTED]
 

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

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

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Scott Stefick

Darrell,

Could I have a copy of that white paper if you still have it?

Thanks,
Scott
At 08:19 AM 3/7/03 -0800, you wrote:
Amen!  For several years we heard from EMC reps, don't worry about it, 
don't worry about it, then recently we we're given a white paper from EMC 
on striping for Oracle.

>>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
SAN is fine as long as you keep track of what's mapping to what physical
disks. I for one don't believe the SAN vendors that say their caching takes
care of performance for you and you don't need to worry about where data is
stored physically. Place datafiles the same way you would for local storage
and you will do well - striped, with data, indexes, temp, and rollback
physically separated.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 4:39 PM
> Hello,
>
> We are currently spec'ing out hardware for our new ERP system.  It is
> either going to be Peoplesoft or Oracle.  We are also debating on using a
> SAN rather than attached storage.  I'm just looking for any
> positives/negatives/rules of thumb I should be aware of when running
Oracle
> on a SAN architecture provided that management goes that way.  The SAN box
> we are looking at right now is the EVA3000 from HP (although this isn't a
> definite) not sure if this matters.
>
> TIA,
> -Scott Stefick
>
> **
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Scott Stefick
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Darrell Landrum
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


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

Re: remota / as sysdba

2003-03-07 Thread becker . bill

*** Comments by BECKER, BILL  Fri Mar 07, 2003 -- 10:56:38 AM
No Windows.

Env is Oracle Enterprise 9.2.0.2 on Solaris 5.9 (or 2.9 or 9, whatever
version number happens to be the version-du-jour)

*** Original message by Jared Still <[EMAIL PROTECTED]>
Interesting.  Was this on some flavor of windows?

I've found it necessary to create a new password file when
cloning a database, though according to the docs, that shouldn't
be necessary.

Jared

On Friday 07 March 2003 06:44, [EMAIL PROTECTED] wrote:
> I have got this working now; I am able to connect remotely
> using "connect sys/[EMAIL PROTECTED] as sysdba" and able to
> do remote imports with sys as the userid.
>
> Thanks to the four J's (Jacques,Jared,Julie,Jeremiah) for their
> suggestions.
>
> The solution seems to be dropping and re-creating the orapwd file.
> I had changed the sys password after I had created the password file;
> the docs say the file should pick up this password change without
> having to re-create it, but re-creating it fixed the problem.
>
> Thanks again.

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

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

Re: remota / as sysdba

Interesting.  Was this on some flavor of windows?

I've found it necessary to create a new password file when
cloning a database, though according to the docs, that shouldn't
be necessary.

Jared

On Friday 07 March 2003 06:44, [EMAIL PROTECTED] wrote:
> I have got this working now; I am able to connect remotely
> using "connect sys/[EMAIL PROTECTED] as sysdba" and able to
> do remote imports with sys as the userid.
>
> Thanks to the four J's (Jacques,Jared,Julie,Jeremiah) for their
> suggestions.
>
> The solution seems to be dropping and re-creating the orapwd file.
> I had changed the sys password after I had created the password file;
> the docs say the file should pick up this password change without
> having to re-create it, but re-creating it fixed the problem.
>
> Thanks again.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

RE: System tablespace Oracle 9202

2003-03-07 Thread Godlewski, Melissa

Title: RE: System tablespace Oracle 9202





Isn't that the truth.  GUI's don't seems to make our DBA work easier.


-Original Message-
From: Chuck Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: System tablespace Oracle 9202



Which is a good reason to save scripts from DBCA as opposed to having it
create the DB for you. I always do this. I can't tell you how many times I
tried to let DBCA create the DB directly only to have it crap out for one
reason or another, and then you need to go back and plug in all the custom
values all over again. If you save scripts, you can modify them to do
whatever you want.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 4:59 PM



> It was only in 9.2 that it was possible to create the system tablespace
> as locally managed, and rumour says that in 10i system tbs defaults to
> locally managed.
>
> The reason it's not default in 9.2 is most likely because..:
> 1. Most likely they just didn't update the DBCA default scripts to
> use this feature when they went from 9i R1 to 9i R2 (read: the scripts
> was just copied from the 9i R1 source tree)
> 2. The feature is brand new, so if some problems turn up, most
> databases wont have it set, because they are created from the DBCA.
>
> Regards,
> Morten Egan
>
> Godlewski, Melissa wrote:
>
> > List,
> >
> > System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent
> > Management. I thought all tablespaces defaulted to Local in this
release.
> >
> >
> > Thu Mar  6 15:29:43 2003
> > create tablespace SYSTEM datafile
> > '/oradb/DEV/system/system01.dbf' size 201M reuse
> >   default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY
> > online
> > Thu Mar  6 15:29:57 2003
> > Completed: create tablespace SYSTEM datafile
> > '/oradb/DEV
> > Thu Mar  6 15:29:57 2003
> > create rollback segment SYSTEM tablespace SYSTEM
> >   storage (initial 50K next 50K)
> > Completed: create rollback segment SYSTEM tablespace SYSTEM
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Morten Egan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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


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

Re: perl DBI question: fetchrow_array


Thanks Tim.

I'll have to play with that code a bit.

Jared

On Friday 07 March 2003 07:09, Tim Bunce wrote:
> On Thu, Mar 06, 2003 at 02:54:19PM -0800, [EMAIL PROTECTED] wrote:
> > 1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted.
> >
> > 2) I see you've already set RowCacheSize.  Anecdotal evidence ( not just
> > mine) suggests that the diminished returns obtained by setting this >100
> > aren't worth it.
> >
> > 3)  try selectall_arrayref if you're data is not really large.  'really
> > large' depends on your environment.
> >
> > 4) join DBI users list, found at lists.perl.org.
>
> That's all true.
>
> I'd just add that recent DBI versions let you specify a max_rows parameter
> to the fetchall_arrayref method. You can then call it in a loop to get
> rows on batches.
>
> This is now the fastest way to fetch rows in a loop using the DBI:
>
>   my $rows = []; # cache for batches of rows
>   while( my $row = ( shift(@$rows) || # get row from cache, or reload
> cache: shift(@{$rows=$sth->fetchall_arrayref(undef,10_000)||[]) ) ) {
> ...
>   }
>
> The code that implements fetchall_arrayref is written in C and,
> although there's a default implementation in the DBI, a faster one
> gets embedded into drivers like DBD::Oracle when it's (re)built
> (after you've upgraded the DBI).
>
> Several parts of the DBI have been optimized with this code-embedding
> technique so if you've not upgraded your DBI to >= 1.29, or not
> rebuilt your DBD::Oracle since then it may be worth doing so.
>
> (FYI, if this prompts you to upgrade your DBI installation, please
> note DBI 1.32 was a good release, but that 1.33 and 1.34 have problems,
> including a memory leak. I hope to release a 1.35 before Monday.)
>
> Tim.
>
> p.s. There's some signes of life returning to DBD::Oracle these days.
> Jeff Urlwin is helping me get the ball rolling again by integrating
> a selection of patches from the major backlog I have. I also have a
> new Solaris box and can now install Oracle 8 and 9 again...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

nt script

2003-03-07 Thread Joan Hsieh

Hi Dear list;

I don't have experience on NT scripting. but I have an urgent need for
nt script. Someone's help would be appreciated. Here is the question;
How to convert this script to nt script? I need to reboot the nt server
if there is any error on this sql statement instead of paging someone on
UNIX. 

Thanks a lot,

Joan

. $HOME/.profile

echo Sending mail!!!
dt=$(date '+%H%M_%m%d%y')
export ORACLE_SID=FMRPT
sqlplus / < sqllog
   set heading off
SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
  WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
 WHERE SERVERNAME = 'PSNTRP02'
   AND SERVERSTATUS <> 3)
 OR NOT EXISTS (SELECT 'X' FROM PSSERVERSTAT
 WHERE SERVERNAME = 'PSNTRP02')
UNION
SELECT 'FMRPT PSNTRP03 SCHEDULER DOWN' FROM DUAL
  WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
 WHERE SERVERNAME = 'PSNTRP03'
   AND SERVERSTATUS <> 3)
 OR NOT EXISTS (SELECT 'X' FROM PSSERVERSTAT
 WHERE SERVERNAME = 'PSNTRP03')
;
exit
EOF!
cat sqllog |egrep 'DOWN' > errfilelog
cat sqllog | egrep -q 'DOWN'
if [ $? -eq 0 ] # found at least one match
then
 mailx  -s  'FMRPT P.SCHEDULER IS DOWN'  [EMAIL PROTECTED]<
errfilelog
 
 exit -1
fi
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

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

Re: netappfilers

2003-03-07 Thread Chip

http://www.netapp.com/products
has Network Appliance (NetApp) product information.
Have Fun :)

kommareddy sreenivasa wrote:

Hi All:

OS: solaris 2.8
DB: 8i
I am new to the concept netappfilers. I dont know even
abc of this. 

What I know is, they are some sort of disks and used
to improve I/O.
Can somebody through some light on this ?
if anybody have any documentation, URLs etc, can you
pass it to me?
Thanks and Regards,
Srinivas
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
 



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

Oracle position on hints

2003-03-07 Thread Stephane Paquette




Hi,
 
Does Oracle have an 
official position on hints ?
Will they go away as 
the optimiser is becoming bettre or they are there to stay ?
 
TIA
 
 


Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tél. 
(514) 925-7187
[EMAIL PROTECTED]

RE: What privs are required to alter a trigger owned by SYS?

Title: RE: What privs are required to alter a trigger owned by SYS?





Rick,


My 2000 crashed yesterday and I lost my reply to you, so here it is ...


alter any trigger is the privilege ... but here is a better solution ...


create or replace sys.enable_trigg_proc is
begin
  execute immediate 'alter trigger sys.dbt_logon enable';
end;
/
create or replace sys.disable_trigg_proc is
begin
  execute immediate 'alter trigger sys.dbt_logon disable';
end;
/
create synonym your_favorite_user.enable_trigg_proc for sys.enable_trigg_proc
/
grant execute on sys.enable_trigg_proc to your_favorite_user
/
create synonym your_favorite_user.disable_trigg_proc for sys.enable_trigg_proc
/
grant execute on sys.disable_trigg_proc to your_favorite_user
/


I perfer this to granting privileges ...


Let me know if this will work for you.
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: What privs are required to alter a trigger owned by SYS?




Yes but do you have an answer to original question



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: Oracle on a SAN.... Good, Bad or Proceed with caution?

Amen!  For several years we heard from EMC reps, don't worry about it, don't worry 
about it, then recently we we're given a white paper from EMC on striping for Oracle.


>>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
SAN is fine as long as you keep track of what's mapping to what physical
disks. I for one don't believe the SAN vendors that say their caching takes
care of performance for you and you don't need to worry about where data is
stored physically. Place datafiles the same way you would for local storage
and you will do well - striped, with data, indexes, temp, and rollback
physically separated.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 4:39 PM


> Hello,
>
> We are currently spec'ing out hardware for our new ERP system.  It is
> either going to be Peoplesoft or Oracle.  We are also debating on using a
> SAN rather than attached storage.  I'm just looking for any
> positives/negatives/rules of thumb I should be aware of when running
Oracle
> on a SAN architecture provided that management goes that way.  The SAN box
> we are looking at right now is the EVA3000 from HP (although this isn't a
> definite) not sure if this matters.
>
> TIA,
> -Scott Stefick
>
> **
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author: Scott Stefick
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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


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

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

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Chuck Hamilton

SAN is fine as long as you keep track of what's mapping to what physical
disks. I for one don't believe the SAN vendors that say their caching takes
care of performance for you and you don't need to worry about where data is
stored physically. Place datafiles the same way you would for local storage
and you will do well - striped, with data, indexes, temp, and rollback
physically separated.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 4:39 PM


> Hello,
>
> We are currently spec'ing out hardware for our new ERP system.  It is
> either going to be Peoplesoft or Oracle.  We are also debating on using a
> SAN rather than attached storage.  I'm just looking for any
> positives/negatives/rules of thumb I should be aware of when running
Oracle
> on a SAN architecture provided that management goes that way.  The SAN box
> we are looking at right now is the EVA3000 from HP (although this isn't a
> definite) not sure if this matters.
>
> TIA,
> -Scott Stefick
>
> **
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Scott Stefick
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

Re: perl DBI question: fetchrow_array

2003-03-07 Thread Tim Bunce

On Thu, Mar 06, 2003 at 02:54:19PM -0800, [EMAIL PROTECTED] wrote:
> 1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted.
> 
> 2) I see you've already set RowCacheSize.  Anecdotal evidence ( not just mine)
> suggests that the diminished returns obtained by setting this >100 aren't 
> worth it.
> 
> 3)  try selectall_arrayref if you're data is not really large.  'really 
> large' depends on your environment.
> 
> 4) join DBI users list, found at lists.perl.org.

That's all true.

I'd just add that recent DBI versions let you specify a max_rows parameter
to the fetchall_arrayref method. You can then call it in a loop to get
rows on batches.

This is now the fastest way to fetch rows in a loop using the DBI:

  my $rows = []; # cache for batches of rows
  while( my $row = ( shift(@$rows) || # get row from cache, or reload cache:
 shift(@{$rows=$sth->fetchall_arrayref(undef,10_000)||[]) )
  ) {
...
  }

The code that implements fetchall_arrayref is written in C and,
although there's a default implementation in the DBI, a faster one
gets embedded into drivers like DBD::Oracle when it's (re)built
(after you've upgraded the DBI).

Several parts of the DBI have been optimized with this code-embedding
technique so if you've not upgraded your DBI to >= 1.29, or not
rebuilt your DBD::Oracle since then it may be worth doing so.

(FYI, if this prompts you to upgrade your DBI installation, please
note DBI 1.32 was a good release, but that 1.33 and 1.34 have problems,
including a memory leak. I hope to release a 1.35 before Monday.)

Tim.

p.s. There's some signes of life returning to DBD::Oracle these days.
Jeff Urlwin is helping me get the ball rolling again by integrating
a selection of patches from the major backlog I have. I also have a
new Solaris box and can now install Oracle 8 and 9 again...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Bunce
  INET: [EMAIL PROTECTED]

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

RE: What privs are required to alter a trigger owned by SYS?

2003-03-07 Thread Rick_Cale


Yes but do you have an answer to original question


   
  
"Jamadagni,
  
Rajendra" To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: What privs are required 
to alter a trigger owned by   
Sent by:   SYS?
  
[EMAIL PROTECTED]  
   
   
  
   
  
03/06/2003 04:24 PM
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




I'd rather own that trigger by someone other than *sys* ...


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!





-Original Message-
Sent: Thursday, March 06, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L





Hi all,


I have trigger owned by sys. It is actually an after login trigger. I want
certain users to be able to enable/disable this trigger. What privs are
required?
I have tried alter any trigger and I still get insufficient privs when
trying to enable trigger.


Thanks
Rick (See attached file: ESPN_Disclaimer.txt)







ESPN_Disclaimer.txt
Description: Binary data

Re: Re[2]: Export data to dbf

I don't know how to do this directly from Oracle, and I don't
think that you can via SQL or PL/SQL.

You could do so easily with Perl and the DBI, DBD::Oracle and
DBD::XBase modules.  DBD::XBase works with dbase files.

Jared

On Thursday 06 March 2003 20:58, Sergey V Dolgov wrote:
> Hello Jared,
>
> Friday, March 7, 2003, 2:09:33 AM, you wrote:
>
> JSrc> What type of file is 'dbf'?
>
> I think I should use ODBC but I don't know how to do it.
>
> JSrc> Hello,
> JSrc> I can't find out how to export some data (selected results) from
> oracle to JSrc> dbf file.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

Re: System tablespace Oracle 9202

2003-03-07 Thread Chuck Hamilton

Which is a good reason to save scripts from DBCA as opposed to having it
create the DB for you. I always do this. I can't tell you how many times I
tried to let DBCA create the DB directly only to have it crap out for one
reason or another, and then you need to go back and plug in all the custom
values all over again. If you save scripts, you can modify them to do
whatever you want.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 4:59 PM


> It was only in 9.2 that it was possible to create the system tablespace
> as locally managed, and rumour says that in 10i system tbs defaults to
> locally managed.
>
> The reason it's not default in 9.2 is most likely because..:
> 1. Most likely they just didn't update the DBCA default scripts to
> use this feature when they went from 9i R1 to 9i R2 (read: the scripts
> was just copied from the 9i R1 source tree)
> 2. The feature is brand new, so if some problems turn up, most
> databases wont have it set, because they are created from the DBCA.
>
> Regards,
> Morten Egan
>
> Godlewski, Melissa wrote:
>
> > List,
> >
> > System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent
> > Management. I thought all tablespaces defaulted to Local in this
release.
> >
> >
> > Thu Mar  6 15:29:43 2003
> > create tablespace SYSTEM datafile
> > '/oradb/DEV/system/system01.dbf' size 201M reuse
> >   default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY
> > online
> > Thu Mar  6 15:29:57 2003
> > Completed: create tablespace SYSTEM datafile
> > '/oradb/DEV
> > Thu Mar  6 15:29:57 2003
> > create rollback segment SYSTEM tablespace SYSTEM
> >   storage (initial 50K next 50K)
> > Completed: create rollback segment SYSTEM tablespace SYSTEM
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Morten Egan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

Re: AW: Cannot delete datafile from O/S -- Help !!


Though this is how it works on NT, I was pleasantly surprised
the other day when I was able to delete the files from a tablespace
that had just been dropped on Win2k.

Jared

On Friday 07 March 2003 04:53, Stefan Jahnke wrote:
> Hi Khanna(?)
>
> Happens alot. Windows still holds a handle to the file. Just wait 'till
> next scheduled reboot (shouldn't be too long;).
>
> Regards,
> Stefan
>
> Stefan Jahnke
> Consultant
> BOV Aktiengesellschaft
> Voice: +49 201 - 4513-298
> Fax: +49 201 - 4513-149
> mailto: [EMAIL PROTECTED]
> Please remove nospam to contact me via email.
>
> visit our website: http://www.bov.de
> subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
>
> Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
> Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
> mailto:[EMAIL PROTECTED]
>
> Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
> fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
> wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
> rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
> ausschliessen.
>
> As you are probably aware, e-mails sent via the Internet can easily be
> copied or manipulated by third parties. For this reason we would ask for
> your understanding that, for your own protection and ours, we must decline
> all legal responsibility for the validity of the statements and comments
> given above.
>
>
> -Ursprungliche Nachricht-
> Von: Prem Khanna J [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 7. Marz 2003 11:54
> An: Multiple recipients of list ORACLE-L
> Betreff: Cannot delete datafile from O/S -- Help !!
>
>
> Guys,
>
> SQL> drop tablespace DATA14 including contents;
> Tablespace dropped.
>
> the name of the datafile in DATA14 tablespace is DATA141.DBF
>
> SQL>select * from v$tablespace where name = 'DATA14';
> no rows selected
>
> SQL>select * from v$tdatafile where name = 'DATA14.DBF';
> no rows selected
>
> when i try to delete the file DATA14.DBF from o/s , it says :
> "Cannot delete DATA14. There has been a sharing violation.The source or
> destination file may be in use."
>
> why is it so ? how can i delete the file from O/S ?
> can someone help me ?
>
> the ENV is 8.1.6 / win2k.
>
> TIA.
> Jp.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

remota / as sysdba

2003-03-07 Thread becker . bill


I have got this working now; I am able to connect remotely
using "connect sys/[EMAIL PROTECTED] as sysdba" and able to
do remote imports with sys as the userid.

Thanks to the four J's (Jacques,Jared,Julie,Jeremiah) for their
suggestions.

The solution seems to be dropping and re-creating the orapwd file.
I had changed the sys password after I had created the password file;
the docs say the file should pick up this password change without
having to re-create it, but re-creating it fixed the problem.

Thanks again.

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

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

RE: RE: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread rgaffuri

I thought the accepted way to do this was to use SQLTRACE=TRUE and use TKPROF?


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

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

Re: Fudging outlines

2003-03-07 Thread Chuck Hamilton

Title: RE: Fudging outlines



I tried it but it's disabled in standard edition. 
It's the one instance I have running on standard edition and the only one I have 
a need to do this on. Murphy strikes again.

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, March 06, 2003 2:44 
  PM
  Subject: RE: Fudging outlines
  
  Chuck,
   
  You are right, they say it is 9i, but the update statement to exchange 
  between different plans should (I am guessing) work on 8i as well. Have you 
  already tried it?
   
  http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/outlines.htm#13135 links 
  you to 8i techniques from manuals using outln_pkg.
   
  HTH Some
  Raj
  - 
  Rajendra dot Jamadagni at espn dot 
  com Any views expressed here are 
  strictly personal. QOTD: Any clod 
  can have facts, having an opinion is an art !! 
  
-Original Message-From: Chuck Hamilton 
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 1:24 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Fudging outlines
The only document I found on metalink was doc 
id 144194.1 which pertains to 9i. I didn't mention it in my OP but I am 
using 8i. Also the database I want to do this on is SE not EE so it looks 
like it's a moot point 
anyway.

RE: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread Wolfgang Breitling

Title: RE: how to find elapsed time for a query in oracle 8.1.7 Database

LAST_CALL_ET is the time the last call was made. So for a session in status 
'INACTIVE' it shows since when it is inactive/idle, or if you subtract 
LAST_CALL_ET from sysdate, how long it has been inactive/idle.
If the session is active on the other hand, it shows how long it has been 
active, i.e. how long it has been processing the current sql.

At 03:58 AM 3/7/2003 -0800, you wrote:

>Stephane,
>    LAST_CALL_ET lets u know that user is idle for so long (correct me
>id i am wrong) and I want to know which queries are taking long time.
>Unfortunately I  cannot use Oracle trace for it.
>Regards,
>Kranti Pushkarna

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited.  If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately.  We honour similar requests relating to the privacy of email communications.

Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie.  Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit.  Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.

OS/390 Oracle Client TNS-3506

2003-03-07 Thread James Howerton

DBA's

We are trying to get an Oracle client running on OS/390 so CICS and (pro*COBOL) can 
connect to a remote Oracle DB. 

After install we are trying to run TNSPING as a first step to demonstrate something is 
working, here is the error:

   TNS-03506: Failed to create address binding

Any help would be appreciated, so far the TAR we have open hasn't produced anything. 

TIA
...JIM...  

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

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

RE: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Khedr, Waleed

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
(Base_id=NOT&p_id=222033.1
(B
(B
(BWaleed
(B
(B-Original Message-
(BSent: Friday, March 07, 2003 8:00 AM
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(BTry again after 5-15 minutes.
(B
(BWaleed
(B- Original Message -
(BTo: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
(BSent: Friday, March 07, 2003 5:54 AM
(B
(B
(B> Guys,
(B>
(B> SQL> drop tablespace DATA14 including contents;
(B> Tablespace dropped.
(B>
(B> the name of the datafile in DATA14 tablespace is DATA141.DBF
(B>
(B> SQL>select * from v$tablespace where name = 'DATA14';
(B> no rows selected
(B>
(B> SQL>select * from v$tdatafile where name = 'DATA14.DBF';
(B> no rows selected
(B>
(B> when i try to delete the file DATA14.DBF from o/s , it says :
(B> "Cannot delete DATA14. There has been a sharing violation.The source or
(Bdestination file may be in use."
(B>
(B> why is it so ? how can i delete the file from O/S ?
(B> can someone help me ?
(B>
(B> the ENV is 8.1.6 / win2k.
(B>
(B> TIA.
(B> Jp.
(B>
(B>
(B> --
(B> Please see the official ORACLE-L FAQ: http://www.orafaq.net
(B> --
(B> Author: Prem Khanna J
(B>   INET: [EMAIL PROTECTED]
(B>
(B> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
(B> San Diego, California-- Mailing list and web hosting services
(B> -
(B> To REMOVE yourself from this mailing list, send an E-Mail message
(B> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(B> the message BODY, include a line containing: UNSUB ORACLE-L
(B> (or the name of mailing list you want to be removed from).  You may
(B> also send the HELP command for other information (like subscribing).
(B>
(B
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Waleed Khedr
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Khedr, Waleed
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).

RE: Tricky SQL Question -- Solved

Title: RE: Tricky SQL Question -- Solved

Jonathan,

Thanks for the tips ... let me see how I incorporate this ... things to do ...

1. write a *clever* routine to look at sys.mon_mods$ with dbms_stats.flush_database_monitoring_info to decide which tables to analyze in the next session.

2. Split the groups automatically between two instances ... if once instance is down, other will pick up all streams .. *this is easy to do in pl/sql).

This allows me to have only two scripts to setup analysis on my 10 production and 24 other instances without a major maintenance. Now I am able to *predict* how much time it takes ... based on last analysis ... here is a sample input based on yesterday's data ...

[EMAIL PROTECTED]> . oraenv
ORACLE_SID = [CSI2] ? ABC
[EMAIL PROTECTED]> sys
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Mar 7 08:36:56 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected.
SQL> set serveroutput on
SQL> exec system.dbpk_statistics.refresh_rank;
Ranking based on analyze time is complete.
Select from view "V_ANALYSIS_INFO" for an *estimate*.

PL/SQL procedure successfully completed.
SQL> set line 200
SQL> select * from system.v_analysis_info;

Analysis Information
-
Group 01 includes 2160 tables, analysis should take approx 00134.10 seconds.
Group 02 includes 413 tables, analysis should take approx 00134.03 seconds.
Group 03 includes 33 tables, analysis should take approx 00130.91 seconds.
Group 04 includes 11 tables, analysis should take approx 00128.63 seconds.
Group 05 includes 4 tables, analysis should take approx 00113.87 seconds.
Group 06 includes 4 tables, analysis should take approx 00152.77 seconds.
Group 07 includes 2 tables, analysis should take approx 00098.63 seconds.
Group 08 includes 2 tables, analysis should take approx 00180.71 seconds.

8 rows selected.

I have configured it to make 8 parallel streams ..

Here are some things that I am doing ...

1. The information is stored in a index organized table
2. As soon as the script loads, it loads (bulk collect) the lost of tables belonging to the group specified into an array.

3. Start executing dbms_stats on the tables in the array based on their parameters, capture elapsed times for analysis
4. If any analysis errors out, it also captures error message
5. Update the index organized table with
a. last analyzed timestamp
b. time it took to analyze the table
c. error message if any
d. uses dbms_stats to get latest rowcount
6. Exits

The package has procedures to performs the set-up (tables/view/procedure/package creation). It also does two types of ranks, first time when analysis times are not available, it groups them by row count. After first analysis, it re-ranks them based on analysis time which is more accurate than row count.

Thanks once again for all the ideas ...
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!

*This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*1

Re: AW: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Prem Khanna J

thanks a lot stefan.
(Bjust fedup with MS-Win.
(B
(B
(B7-3-2003 21:53:50, Stefan Jahnke 
(B<[EMAIL PROTECTED]> wrote:
(B
(B>Hi Khanna(?)
(B>
(B>Happens alot. Windows still holds a handle to 
(Bthe file. Just wait 'till next
(B>scheduled reboot (shouldn't be too long;).
(B>
(B>Regards,
(B>Stefan
(B
(B
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Prem Khanna J
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).

Re: AW: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Prem Khanna J

thank u guys.
(Bthanks for letting me know this.
(B
(BWINDOSE :-
(B
(B
(B
(B7-3-2003 21:53:50, Stefan Jahnke 
(B<[EMAIL PROTECTED]> wrote:
(B
(B>Hi Khanna(?)
(B>
(B>Happens alot. Windows still holds a handle to 
(Bthe file. Just wait 'till next
(B>scheduled reboot (shouldn't be too long;).
(B>
(B>Regards,
(B>Stefan
(B>
(B>Stefan Jahnke
(B>Consultant
(B>BOV Aktiengesellschaft
(B>Voice: +49 201 - 4513-298
(B>Fax: +49 201 - 4513-149
(B>mailto: [EMAIL PROTECTED]
(B>Please remove nospam to contact me via email.
(B>
(B>visit our website: http://www.bov.de
(B>subscribe to our newsletter: 
(Bhttp://www.bov.de/presse/newsletter.asp
(B>
(B>Sicherheitsluecken mit IT-Security-Konzepten 
(Bvon BOV effizient schliessen!
(B>Weitere Informationen unter +49 201/45 13-240 
(Boder E-Mail an
(B>mailto:[EMAIL PROTECTED]
(B>
(B>Wie Sie wissen, koennen ueber das Internet 
(Bversandte E-Mails leicht unter
(B>fremden Namen  erstellt oder manipuliert 
(Bwerden. Aus diesem Grunde bitten
(B>wir um Verstaendnis dafuer, dass  wir zu 
(BIhrem und unserem Schutz die
(B>rechtliche Verbindlichkeit der vorstehenden 
(BErklaerungen und Aeusserungen
(B>ausschliessen.
(B>
(B>As you are probably aware, e-mails sent via 
(Bthe Internet can easily be
(B>copied or manipulated by third parties. For 
(Bthis reason we would ask for
(B>your understanding that, for your own 
(Bprotection and ours, we must decline
(B>all legal responsibility for the validity of 
(Bthe statements and comments
(B>given above.
(B>
(B>
(B>-Ursprungliche Nachricht-
(B>Von: Prem Khanna J 
(B[mailto:[EMAIL PROTECTED]
(B>Gesendet: Freitag, 7. Marz 2003 11:54
(B>An: Multiple recipients of list ORACLE-L
(B>Betreff: Cannot delete datafile from O/S -- 
(BHelp !!
(B>
(B>
(B>Guys,
(B>
(B>SQL> drop tablespace DATA14 including 
(Bcontents;
(B>Tablespace dropped.
(B>
(B>the name of the datafile in DATA14 tablespace 
(Bis DATA141.DBF
(B>
(B>SQL>select * from v$tablespace where name = 
(B'DATA14';
(B>no rows selected
(B>
(B>SQL>select * from v$tdatafile where name = 
(B'DATA14.DBF';
(B>no rows selected
(B>
(B>when i try to delete the file DATA14.DBF from 
(Bo/s , it says :
(B>"Cannot delete DATA14. There has been a 
(Bsharing violation.The source or
(B>destination file may be in use."
(B>
(B>why is it so ? how can i delete the file from 
(BO/S ?
(B>can someone help me ?
(B>
(B>the ENV is 8.1.6 / win2k.
(B>
(B>TIA.
(B>Jp. 
(B>
(B>
(B>-- 
(B>Please see the official ORACLE-L FAQ: 
(Bhttp://www.orafaq.net
(B>-- 
(B>Author: Prem Khanna J
(B>  INET: [EMAIL PROTECTED]
(B>
(B>Fat City Network Services-- 858-538-5051 
(Bhttp://www.fatcity.com
(B>San Diego, California-- Mailing list 
(Band web hosting services
(B>-
(B
(B>To REMOVE yourself from this mailing list, 
(Bsend an E-Mail message
(B>to: [EMAIL PROTECTED] (note EXACT spelling 
(Bof 'ListGuru') and in
(B>the message BODY, include a line containing: 
(BUNSUB ORACLE-L
(B>(or the name of mailing list you want to be 
(Bremoved from).  You may
(B>also send the HELP command for other 
(Binformation (like subscribing).
(B>
(B>
(B> 
(B>-- 
(B>Please see the official ORACLE-L FAQ: 
(Bhttp://www.orafaq.net
(B>-- 
(B>Author: Stefan Jahnke
(B>  INET: [EMAIL PROTECTED]
(B>
(B>Fat City Network Services-- 858-538-5051 
(Bhttp://www.fatcity.com
(B>San Diego, California-- Mailing list 
(Band web hosting services
(B>-
(B
(B>To REMOVE yourself from this mailing list, 
(Bsend an E-Mail message
(B>to: [EMAIL PROTECTED] (note EXACT spelling 
(Bof 'ListGuru') and in
(B>the message BODY, include a line containing: 
(BUNSUB ORACLE-L
(B>(or the name of mailing list you want to be 
(Bremoved from).  You may
(B>also send the HELP command for other 
(Binformation (like subscribing).
(B>
(B>
(BJp. 
(B
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Prem Khanna J
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).

RE: System tablespace Oracle 9202

2003-03-07 Thread Godlewski, Melissa

Title: RE: System tablespace Oracle 9202

This is a UNIX Solaris running 5.8  I created the database from sqlplus using scripts.  I somehow thought the default was LMT for system rather then DICTIONARY.  I changed the script to LMT and recreated, but I was surprised by the Dictionary system creation.

-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 06, 2003 9:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: System tablespace Oracle 9202

DBCA, by default in 92 will create SYSTEM as LMT. There is an option to do
dictionary if you prefer. CREATE DATABASE default is a dictionary managed
SYSTEM tablespace with LMT optioinal.

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/6/2003 6:43 PM

What platform is this?  I can't be sure (because my
laptop is miles away at the moment) but I think on 9.2
on NT when I used the creation assistant to generate
scripts for me, SYSTEM was an lmt.

hth
connor

 --- "Godlewski, Melissa"
<[EMAIL PROTECTED]> wrote: > List,
> 
> System tablespace for Oracle 9iR2 is defaulting to
> Dictionary Extent
> Management. I thought all tablespaces defaulted to
> Local in this release.
> 
> 
> Thu Mar  6 15:29:43 2003
> create tablespace SYSTEM datafile 
> '/oradb/DEV/system/system01.dbf'
> size 201M reuse
>   default storage (initial 10K next 10K) EXTENT
> MANAGEMENT DICTIONARY online
> Thu Mar  6 15:29:57 2003
> Completed: create tablespace SYSTEM datafile 
> '/oradb/DEV
> Thu Mar  6 15:29:57 2003
> create rollback segment SYSTEM tablespace SYSTEM
>   storage (initial 50K next 50K)
> Completed: create rollback segment SYSTEM tablespace
> SYSTEM
>  
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

RE: Tricky SQL Question