date:20030106

Hi,

Allow me to be the first of many to ask - why do you want to cache a huge
table in memory?  Important questions include:

* Define huge (both in depth [row count] and width [row size])?
* What type of queries are you running against this table?
* What access paths are being used (ie: via index or frequent full table
scans)?
* What is currently in memory and going to be thrown out to make room for
this table?  (RAM is a bit like a bus - there are a set number of seats and
you can't let more people on without kicking someone out [despite what
those wierd products in the early 90's tried to convince us])

"alter table [table_name] cache;" is a valid command as far as I know but
I'm sure some experts here will better explain the inner workings of
Oracle.  Reading Oracle documentation talks about caching small tables
which are subject to full table scans.  The cache instruction (I believe)
simply tells Oracle to put them at the end of the list of things to throw
out, instead of the start.  If Oracle had the room is would cache the huge
table anyway without that parameter.

It sounds a little like a developer has told you to cache the table because
someone told him to make the query run faster.  Unfortunately it's rarely
that simple.

Regards,
 Mark.



   
  
"Krishnaswamy, Ranganath"  
  
<[EMAIL PROTECTED]   To: Multiple recipients 
of list ORACLE-L <[EMAIL PROTECTED]>   
lobal.com> cc: 
  
Sent by: [EMAIL PROTECTED]  Subject: Caching a huge 
table's data in memory
   
  
   
  
07/01/2003 15:53   
  
Please respond to ORACLE-L 
  
   
  
   
  




Hi List,

   I have a requirement for caching the data of a huge table in
memory.
Is it just running the command Alter table  cache or something
else?  What are the pros and cons of caching a table's data?  Could anybody
advise me in this regard?  Any help in this regard is very much
appreciated.

Thanks and Regards,

Ranganath
WARNING: The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee.  Access to this
message
by anyone else is unauthorised.  If you are not the intended recipient, any
disclosure, copying, or distribution of the message, or any action or
omission taken by you in reliance on it, is prohibited and may be unlawful.
Please immediately contact the sender if you have received this message in
error. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Krishnaswamy, Ranganath
  INET: [EMAIL PROTECTED]

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




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

Re: ORA-00600: [2662]

2003-01-06 Thread K Gopalakrishnan

Other than the allow_resetlogs_corruption, _disable_logging also will
greet you with OERI-2662 if the shutdown is not normal. 

KG

--- Sinardy Xing <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> I hit by this error
> 
> ORA-00600: internal error code, arguments: [2662], [0], [54151123],
> [0], 
> [54173017], [16781180], [], []
> 
> 
> Can you help me where to find info about this error 
> 
> 
> 
> 
> Sinardy
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

Re: ORA-00600: [2662]

2003-01-06 Thread K Gopalakrishnan

Sinardy:

Have you force opened the database? (_allow_resetlogs_corruption).
In this case the SCN Mismatch (block SCN vs Currnet SCN) is causing the
OERI-2662, and you need to bump the SCNS globally to get the database
up. 

Speak to Oracle Support and ask for the details to bump the SCN, then
you can open the database. You need to rebuild the database after force
opening.

KG

--- Sinardy Xing <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> I hit by this error
> 
> ORA-00600: internal error code, arguments: [2662], [0], [54151123],
> [0], 
> [54173017], [16781180], [], []
> 
> 
> Can you help me where to find info about this error 
> 
> 
> 
> 
> Sinardy
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

RE: ORA-00600: [2662]

2003-01-06 Thread mantfield

Sinardy

ORA-0600 is really an encoded message from Oracle that reads :

'Thank you for helping find yet another bug in our software. You can now 
release your sphincter (some herbal tea might help), especially if this has 
cropped up in production. We suggest you do not try to solve this one by 
yourself, which is why the arguments are supplied. Kindly call OWWS with 
your CSI number, tell them exactly which version and platform you ran this 
on, and if we have encountered this previously, there is a small chance 
that we could have a patch. If not, please do not hold your breath waiting, 
while we assign this to an experienced software engineer, or perhaps a 
recent college grad, in which case, you're toast !' However, we will ask 
you to ftp up to our ftp site loads of dumps and traces which might prove 
useful.

Seriously though, ORA-0600 are mysteries. Your best chance is to get Tim 
Gorman to look at it, he has an amazing knowledge of these. And of course, 
Tim should not work for free either. (Tim, it was 10% commission we agreed 
on, right ? ) :-)

Ferenc Mantfeld

-Original Message-
From:   Sinardy Xing [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, January 07, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L
Subject:ORA-00600: [2662]

Hi all,

I hit by this error

ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0],
[54173017], [16781180], [], []


Can you help me where to find info about this error




Sinardy

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: mantfield
  INET: [EMAIL PROTECTED]

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

Caching a huge table's data in memory

2003-01-06 Thread Krishnaswamy, Ranganath

Hi List,

I have a requirement for caching the data of a huge table in memory.
Is it just running the command Alter table  cache or something
else?  What are the pros and cons of caching a table's data?  Could anybody
advise me in this regard?  Any help in this regard is very much appreciated.

Thanks and Regards,

Ranganath
WARNING: The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee.  Access to this message
by anyone else is unauthorised.  If you are not the intended recipient, any
disclosure, copying, or distribution of the message, or any action or
omission taken by you in reliance on it, is prohibited and may be unlawful.
Please immediately contact the sender if you have received this message in
error. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Krishnaswamy, Ranganath
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: No logging question

2003-01-06 Thread Jared Still


That's also my understanding of it. 

Not a good way to run a database you care about.  

Jared

On Monday 06 January 2003 13:03, Burke, William F (Bill) wrote:
> It is an all or nothing shutdown of logging however and cannot be applied
> to a limited set of DML, correct?
>
> Regards,
>
> Bill Burke
> "The Kinder and Gentler DBA"
> www.OracleGuru.com
> www.KBMotorsports.biz
>
>
>
> -Original Message-
> Sent: Monday, January 06, 2003 1:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Welcome to the dark side, heh heh heh !
>
> There is a hidden parameter that will achieve this . it is
> _disable_logging. Be warned though, if you set it to true, you have lost
> your ability to recover, and the only way you will recover is with full
> cold backup and would lose all subsequent work (not generally popular with
> the users), so the whole point of running in ARCHIVELOG mode becomes moot.
>
> I have used this while still at Siebel, when doing very large installs or
> upgrades of large databases in a tight time-window, and the customers
> refused to move the redo logs over to solid state storage, I got about a
> 40% - 100% performance improvment, especially if the clients were conned
> into placing the redo logs onto RAID-5 storage (bad for serial
> write-intensive operations).
>
> Nevertheless, if you have a specific need to disable all redo generation
> for a specific time, this is the way to do it. BTW, it does not work on
> Orale for Windows.
>
> You have been warned, don't go trying this in production first thing, it
> could cost you your job or more.
>
> Regards :
>
> Ferenc Mantfeld
>
> -Original Message-
> From: GL2Z/ INF  DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, January 06, 2003 8:34 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  No logging question
>
> Hi All,
>
>
>   I want to avoid generation of archivelogs against all the DML applied
> to some tables.
>
> Thank you
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: GL2Z/ INF  DBA BENLATRECHE
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

Re: True inner peace

2003-01-06 Thread Jared Still


Amen.

On Monday 06 January 2003 19:28, Rachel Carmichael wrote:
> I *knew* I was forgetting something. damn, where did I leave that box
> of chocolates? The rest of your list are already long gone.
>
> :)
>
> Come to the dark side Ferenc, join us on the OT list before Jared and
> the members here get annoyed with the non-technical posts :)
>
> --- mantfield <[EMAIL PROTECTED]> wrote:
> > By following the simple advice I read in an article, I have finally
> > found inner peace...
> >
> > It said: "The way to achieve inner peace is to finish all the things
> > I had started".
> >
> > So, today I have finished one bottle of cognac, two bottles of red
> > wine, a bottle of Jack Daniels, my Prozac's, and a box of chocolates.
> >
> > Amazing, I feel better already!
> >
> > Pass this on to all those in need of Inner Peace!
> >
> > Ferenc Mantfeld
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: mantfield
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
-- 
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: Are too many Foreign Keys in one table bad?

2003-01-06 Thread Deshpande, Kirti

I am flattered as well
I am not in the league of the heavy weights like Jonathan, Connor, Cary, Anjo, Mogens, 
Gaja, Dan, Jared, Tom, James etc... and certainly not presenting in the upcoming 
Hotsos Symposium, just attending. I have a full time day (and night) job as 'Dumb But 
Acceptable' at Verizon Corp. I will present a couple of Quick Tip sessions at the IOUG 
Live! in Orlando. 

I would love to visit Australia (and NZ as well), but just don't know when. Ferenc has 
graciously offered his guest bedroom down there :) so I think I am half way there, 
just need to find a sponsor for the airline ticket ;) 

Thanks for thinking of my name, though ;) 

Regards,

- Kirti 

-Original Message-
Sent: Monday, January 06, 2003 9:29 PM
To: Multiple recipients of list ORACLE-L

I'm flattered you put me in the same category as Kirti, Dan, Jared,
Connor and Jonathan.

If I recall the cost of my (one) trip to Australia, it would be cheaper
to import you to IOUG than it would be to get us there!  I'm not sure
about Jared and Connor, the rest of us will be at IOUG. And for the
price of a drink of Black Adder Scotch I'm sure you could get Dan to
expound on Oracle and backup and recovery and blockcentric tuning all
night long. Okay, make that a bottle of BlackAdder and make sure he
isn't presenting first thing the next morning :)

--- Mark Richard <[EMAIL PROTECTED]> wrote:
> All,
> 
> Point well taken (both Rachel's and Jared's).  I should have said
> (and was
> even thinking - although the brain and hands sometimes act
> independently)
> "might not be worth indexing".  It sounds like a helpdesk system for
> a
> pretty small customer base so I was assuming that system load isn't
> likely
> to be a problem.  My experience has always been that if the fact is
> 1000
> rows and the reference are maybe 3 - 10 then Oracle is going to eat
> it up
> for lunch no matter how it's structured unless a large number of
> concurrent
> user come along.
> 
> Now on a more serious note, when is the week-long Rachel Carmichael,
> Dan
> Fink, Jonathan Lewis, Connor, Jared, Kirti, et al "How to well and
> truly
> beat Oracle into Submission" seminar coming down under to Australia? 
> I
> need to know so that I can start selling my soul to raise enough
> money to
> attend...  With our dollar the way it is a seminar like that would
> cost
> about the same as my house.
> 
> 
> 
>  
>  
> Rachel   
>  
> Carmichael   To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>   
>   
> ahoo.com>Subject: Re: Are too
> many Foreign Keys in one table bad?  
> Sent by: 
>  
> [EMAIL PROTECTED]   
>  
> om   
>  
>  
>  
>  
>  
> 07/01/2003   
>  
> 12:33
>  
> Please respond   
>  
> to ORACLE-L  
>  
>  
>  
>  
>  
> 
> 
> 
> 
> Mark,
> 
> Based on the presentation and testing Dan Fink did for the last NYOUG
> meeting, it's possible that the ref tables SHOULD be indexed, and
> that
> it will help performance to index them.
> 
> Rachel
> 
> --- Mark Richard <[EMAIL PROTECTED]> wrote:
> > Greg,
> >
> > I don't think Oracle will have a real problem with 15 tables or
> 1,000
> > rows.
> > If the ref tables are quite small then they won't even be worth
> > indexing -
> > Oracle will just read the entire table at one anyway.  You might
> want
> > to
> > tell Oracle to CACHE the reference tables, although I don't think
> > you'll
> > see a performance gain really.  Unfortunately I can't give any
> > performance
> > suggestions because I am us

ORA-00600: [2662]

2003-01-06 Thread Sinardy Xing

Hi all,

I hit by this error

ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], 
[54173017], [16781180], [], []


Can you help me where to find info about this error 




Sinardy

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: encrypted user/passwd connection

2003-01-06 Thread Jared Still

Andre,

Oracle does not send passwords across the network
in clear text, they are encrypted by default.

Jared

On Monday 06 January 2003 05:43, Andrey Bronfin wrote:
> Dear list !
> I have just been asked the following question:
> is it possible to make a connection from an Oracle client to an Oracle
> instance (both are 8.1.7) in an "encrypted" way.
> I.e. if someone is sitting with a sniffer between the server and the
> client, then i don't want him to be able to see the user/passwd i'm
> connecting with. Again , i am NOT asking how store the data in the DB in an
> "encrypted" way, but how to connect to an instance without showing my
> passwd.
> Thanks a lot!
> Andrey.

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 

-- 
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: True inner peace

I *knew* I was forgetting something. damn, where did I leave that box
of chocolates? The rest of your list are already long gone.

:)

Come to the dark side Ferenc, join us on the OT list before Jared and
the members here get annoyed with the non-technical posts :)


--- mantfield <[EMAIL PROTECTED]> wrote:
> By following the simple advice I read in an article, I have finally
> found inner peace...
> 
> It said: "The way to achieve inner peace is to finish all the things
> I had started".
> 
> So, today I have finished one bottle of cognac, two bottles of red
> wine, a bottle of Jack Daniels, my Prozac's, and a box of chocolates.
> 
> Amazing, I feel better already!
> 
> Pass this on to all those in need of Inner Peace!
> 
> Ferenc Mantfeld
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: mantfield
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Re: Are too many Foreign Keys in one table bad?

I'm flattered you put me in the same category as Kirti, Dan, Jared,
Connor and Jonathan.

If I recall the cost of my (one) trip to Australia, it would be cheaper
to import you to IOUG than it would be to get us there!  I'm not sure
about Jared and Connor, the rest of us will be at IOUG. And for the
price of a drink of Black Adder Scotch I'm sure you could get Dan to
expound on Oracle and backup and recovery and blockcentric tuning all
night long. Okay, make that a bottle of BlackAdder and make sure he
isn't presenting first thing the next morning :)


--- Mark Richard <[EMAIL PROTECTED]> wrote:
> All,
> 
> Point well taken (both Rachel's and Jared's).  I should have said
> (and was
> even thinking - although the brain and hands sometimes act
> independently)
> "might not be worth indexing".  It sounds like a helpdesk system for
> a
> pretty small customer base so I was assuming that system load isn't
> likely
> to be a problem.  My experience has always been that if the fact is
> 1000
> rows and the reference are maybe 3 - 10 then Oracle is going to eat
> it up
> for lunch no matter how it's structured unless a large number of
> concurrent
> user come along.
> 
> Now on a more serious note, when is the week-long Rachel Carmichael,
> Dan
> Fink, Jonathan Lewis, Connor, Jared, Kirti, et al "How to well and
> truly
> beat Oracle into Submission" seminar coming down under to Australia? 
> I
> need to know so that I can start selling my soul to raise enough
> money to
> attend...  With our dollar the way it is a seminar like that would
> cost
> about the same as my house.
> 
> 
> 
>  
>  
> Rachel   
>  
> Carmichael   To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>   
>   
> ahoo.com>Subject: Re: Are too
> many Foreign Keys in one table bad?  
> Sent by: 
>  
> [EMAIL PROTECTED]   
>  
> om   
>  
>  
>  
>  
>  
> 07/01/2003   
>  
> 12:33
>  
> Please respond   
>  
> to ORACLE-L  
>  
>  
>  
>  
>  
> 
> 
> 
> 
> Mark,
> 
> Based on the presentation and testing Dan Fink did for the last NYOUG
> meeting, it's possible that the ref tables SHOULD be indexed, and
> that
> it will help performance to index them.
> 
> Rachel
> 
> --- Mark Richard <[EMAIL PROTECTED]> wrote:
> > Greg,
> >
> > I don't think Oracle will have a real problem with 15 tables or
> 1,000
> > rows.
> > If the ref tables are quite small then they won't even be worth
> > indexing -
> > Oracle will just read the entire table at one anyway.  You might
> want
> > to
> > tell Oracle to CACHE the reference tables, although I don't think
> > you'll
> > see a performance gain really.  Unfortunately I can't give any
> > performance
> > suggestions because I am used to the other end of the scale (ie:
> 250
> > million rows in data)
> >
> > You probably could store CODE in the main table, but if you are
> going
> > to
> > need the description frequently then all benefit is lost anyway.
> > Either
> > way though I'm sure that you'll have more problems getting the 15
> > joins
> > right when writing the queries than Oracle's CBO will have when
> > looking at
> > the query - I've seen some real nasty queries get pushed into
> > Oracle's
> > optimisor and as long at the statistics are valid then it does a
> > pretty
> > good job.
> >
> > Cheers,
> >  Mark.
> >
> > PS:  Why would the reference CODE change instead of the
> DESCRIPTION?
> > I'm
> > guessing the code will be meaningful such as "HIGH", "CRITICAL",
> etc
> > and
> > description mig

SQL*Plus core dump

Dear List,

Apologies in advance for the long message, but the error messages are no
doubt significant to the problem.

As part of our testing procedures we kill SQL scripts (anonymous PL/SQL
blocks normally) during execution using the following:

 SQL> alter system kill session '18,44329';

 System altered.

Recently, however SQL*Plus is core dumping rather than politely reporting
session killed.  The error given to screen is (The SP2-0642 message appears
hundreds of times, here are the last two):

 SP2-0642: SQL*Plus internal error state 2167, context 4294967294:2:0
 Unable to proceed
 SP2-0642: SQL*Plus internal error state 2167, context 4294967294:2:0
 Unable to proceed
 Segmentation Fault(coredump)
 $

The script is also being spooled to a file, which shows:

 ERROR:
 ORA-01012: not logged on

 ERROR:
 ORA-01012: not logged on


 SP2-0359: memory exhausted
 Error accessing package DBMS_APPLICATION_INFO
 ERROR:
 ORA-01012: not logged on

 SP2-0359: memory exhausted
 SP2-0359: memory exhausted

The all important version numbers are (all running on Solaris - both
database and SQL*Plus) :

 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 7 11:46:35 2003

 (c) Copyright 2000 Oracle Corporation.  All rights reserved.


 Connected to:
 Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
 With the Partitioning option
 JServer Release 8.1.7.4.0 - Production

Has anyone experienced SQL*Plus core dumping like this?  Any advice would
be welcomed.

Thanks,
 Mark.

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

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

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

Re: Are too many Foreign Keys in one table bad?

All,

Point well taken (both Rachel's and Jared's).  I should have said (and was
even thinking - although the brain and hands sometimes act independently)
"might not be worth indexing".  It sounds like a helpdesk system for a
pretty small customer base so I was assuming that system load isn't likely
to be a problem.  My experience has always been that if the fact is 1000
rows and the reference are maybe 3 - 10 then Oracle is going to eat it up
for lunch no matter how it's structured unless a large number of concurrent
user come along.

Now on a more serious note, when is the week-long Rachel Carmichael, Dan
Fink, Jonathan Lewis, Connor, Jared, Kirti, et al "How to well and truly
beat Oracle into Submission" seminar coming down under to Australia?  I
need to know so that I can start selling my soul to raise enough money to
attend...  With our dollar the way it is a seminar like that would cost
about the same as my house.

Rachel 

Carmichael   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Subject: Re: Are too many Foreign Keys in 
one table bad?  
Sent by:   

[EMAIL PROTECTED] 

om 

07/01/2003 

12:33  

Please respond 

to ORACLE-L

Mark,

Based on the presentation and testing Dan Fink did for the last NYOUG
meeting, it's possible that the ref tables SHOULD be indexed, and that
it will help performance to index them.

Rachel

--- Mark Richard <[EMAIL PROTECTED]> wrote:
> Greg,
>
> I don't think Oracle will have a real problem with 15 tables or 1,000
> rows.
> If the ref tables are quite small then they won't even be worth
> indexing -
> Oracle will just read the entire table at one anyway.  You might want
> to
> tell Oracle to CACHE the reference tables, although I don't think
> you'll
> see a performance gain really.  Unfortunately I can't give any
> performance
> suggestions because I am used to the other end of the scale (ie: 250
> million rows in data)
>
> You probably could store CODE in the main table, but if you are going
> to
> need the description frequently then all benefit is lost anyway.
> Either
> way though I'm sure that you'll have more problems getting the 15
> joins
> right when writing the queries than Oracle's CBO will have when
> looking at
> the query - I've seen some real nasty queries get pushed into
> Oracle's
> optimisor and as long at the statistics are valid then it does a
> pretty
> good job.
>
> Cheers,
>  Mark.
>
> PS:  Why would the reference CODE change instead of the DESCRIPTION?
> I'm
> guessing the code will be meaningful such as "HIGH", "CRITICAL", etc
> and
> description might be "Must fix within 1 hr".  Even still, I think you
> are
> right when you said that CODE isn't likely to change often, if at
> all.
>
>
>
>
>
> Gregory Norris
>
>  of list ORACLE-L <[EMAIL PROTECTED]>
> brain.com>   cc:
>
> Sent by: Subject: Are too many
> Foreign Keys in one table bad?
> [EMAIL PROTECTED]
>
> om
>
>
>
>
>
> 07/01/2003
>
> 07:03
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
>
> I am designing some tables to store Customer Support Data.
> The main table (SUPPORT_DATA) contains many (up to 15) foreign key
> links to
> other tables.
> Most of the other tables are small lookup REFTABLES (eg Priority
> Type).
> A few bigger tables store up to 1000

Re: Are too many Foreign Keys in one table bad?

2003-01-06 Thread Jared . Still

> I don't think Oracle will have a real problem with 15 tables or 1,000 
rows.
> If the ref tables are quite small then they won't even be worth indexing 
-
> Oracle will just read the entire table at one anyway. 

Not necessarily.  There can be quite a difference between using
an index on a small table, and not using one.

The following will illustrate:

#---

drop table fts1;
drop table fts2;

create table fts1 (
   refcode varchar2 (6) not null
   , description varchar2(30) not null
);


begin
   for i in 1..100
   loop
  execute immediate
 'insert into fts1 values('
 ||  || 'C' || i ||  || ','
 ||  || 'Code ' || i || 
 || ')';
   end loop;
   commit;
end;
/

create table fts2
as
select *
from fts1;

create index fts2_code_idx
on fts2(refcode);

analyze table fts1 compute statistics;
analyze table fts2 compute statistics;

#---

Now the test harness is run.  This is based on Tom Kytes
run_stats test harness.  http://asktom.oracle.com/~tkyte/runstats.html

#---


-- test_harness.sql
-- from Tom Kyte - asktom.oracle.com/~tkyte/runstats.html
-- see ~/oracle/dba/run_stats for all files


declare
l_start number;
--add any other variables you need here for the test...
begin
delete from run_stats;
commit;
-- start by getting a snapshot of the v$ tables
insert into run_stats select 'before', stats.* from stats;

-- and start timing...
l_start := dbms_utility.get_time;

-- for things that take a very small amount of time, I like to
-- loop over it time and time again, to measure something "big"
-- if what you are testing takes a long time, loop less or maybe
-- not at all
for i in 1 .. 1000
loop

-- your code here for approach #1
declare
r_code fts1%rowtype;
begin

select refcode, description into r_code
from fts1
where refcode = 'C25';

select refcode, description into r_code
from fts1
where refcode = 'C50';

select refcode, description into r_code
from fts1
where refcode = 'C75';

select refcode, description into r_code
from fts1
where refcode = 'C99';

end;

end loop;

dbms_output.put_line( (dbms_utility.get_time-l_start) || ' hsecs' 
);

-- get another snapshot and start timing again...
insert into run_stats select 'after 1', stats.* from stats;

l_start := dbms_utility.get_time;

for i in 1 .. 1000
loop
-- your code here for approach #2
declare
r_code fts2%rowtype;
begin

select /*+ index(fts2, fts2_code_idx) */
refcode, description into r_code
from fts2
where refcode = 'C25';

select /*+ index(fts2, fts2_code_idx) */
refcode, description into r_code
from fts2
where refcode = 'C50';

select /*+ index(fts2, fts2_code_idx) */
refcode, description into r_code
from fts2
where refcode = 'C75';

select /*+ index(fts2, fts2_code_idx) */
refcode, description into r_code
from fts2
where refcode = 'C99';

end;
end loop;

dbms_output.put_line( (dbms_utility.get_time-l_start) || ' hsecs' 
);
insert into run_stats select 'after 2', stats.* from stats;
end;
/

#---

The results:

17:56:17 rsysdevdb.radisys.com - jkstill@dv01 SQL> @th
57 hsecs
44 hsecs

PL/SQL procedure successfully completed.

The code using the index was only marginally faster.  The
real savings are in resources not consumed when an index is used.

17:56:14 rsysdevdb.radisys.com - jkstill@dv01 SQL> @run_stats

NAME   RUN1   RUN2   DIFF
 -- -- --
STAT...calls to get snapshot scn: kcmgss   4002   4001 -1
STAT...deferred (CURRENT) block cleanout  3  2 -1
 applications

STAT...enqueue requests   1  0 -1
STAT...free buffer requested

True inner peace

2003-01-06 Thread mantfield

By following the simple advice I read in an article, I have finally found inner 
peace...

It said: "The way to achieve inner peace is to finish all the things I had started".

So, today I have finished one bottle of cognac, two bottles of red wine, a bottle of 
Jack Daniels, my Prozac's, and a box of chocolates.

Amazing, I feel better already!

Pass this on to all those in need of Inner Peace!

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Are too many Foreign Keys in one table bad?

Mark,

Based on the presentation and testing Dan Fink did for the last NYOUG
meeting, it's possible that the ref tables SHOULD be indexed, and that
it will help performance to index them.

Rachel

--- Mark Richard <[EMAIL PROTECTED]> wrote:
> Greg,
> 
> I don't think Oracle will have a real problem with 15 tables or 1,000
> rows.
> If the ref tables are quite small then they won't even be worth
> indexing -
> Oracle will just read the entire table at one anyway.  You might want
> to
> tell Oracle to CACHE the reference tables, although I don't think
> you'll
> see a performance gain really.  Unfortunately I can't give any
> performance
> suggestions because I am used to the other end of the scale (ie: 250
> million rows in data)
> 
> You probably could store CODE in the main table, but if you are going
> to
> need the description frequently then all benefit is lost anyway. 
> Either
> way though I'm sure that you'll have more problems getting the 15
> joins
> right when writing the queries than Oracle's CBO will have when
> looking at
> the query - I've seen some real nasty queries get pushed into
> Oracle's
> optimisor and as long at the statistics are valid then it does a
> pretty
> good job.
> 
> Cheers,
>  Mark.
> 
> PS:  Why would the reference CODE change instead of the DESCRIPTION? 
> I'm
> guessing the code will be meaningful such as "HIGH", "CRITICAL", etc
> and
> description might be "Must fix within 1 hr".  Even still, I think you
> are
> right when you said that CODE isn't likely to change often, if at
> all.
> 
> 
> 
>  
>  
> Gregory Norris   
>  
>  of list ORACLE-L <[EMAIL PROTECTED]>   
> brain.com>   cc: 
>  
> Sent by: Subject: Are too many
> Foreign Keys in one table bad?  
> [EMAIL PROTECTED]   
>  
> om   
>  
>  
>  
>  
>  
> 07/01/2003   
>  
> 07:03
>  
> Please respond   
>  
> to ORACLE-L  
>  
>  
>  
>  
>  
> 
> 
> 
> 
> 
> I am designing some tables to store Customer Support Data.
> The main table (SUPPORT_DATA) contains many (up to 15) foreign key
> links to
> other tables.
> Most of the other tables are small lookup REFTABLES (eg Priority
> Type).
> A few bigger tables store up to 1000 records eg CUSTOMER_DATA.
> 
> I am concerned that to get data for one Support record will involve a
> join
> of 15 Tables and possibly more for reports, and that this many tables
> may
> confuse the Cost Based Optimiser.
> 
> I am considering storing the CODE in the SUPPORT_DATA table instead
> of the
> ID for the reference tables.  This will reduce the number of joins
> greatly.
> 
> _
> Design Proposed
> 
> SUPPORT_DATA
>   Id (PK)
>   _code (FK)
>support_data_desc
> 
> 
> 
>   _id (PK)
>   _code (Unique Constraint)
>   _description
> _
> 
> The Main problems I see with this are that DATA storage increases (I
> can
> deal with that) and  that I will have to create a trigger to update
> all
> SUPPORT_DATA if one of the CODES in a REFTABLE is updated (this would
> be
> rare and so not a great concern).
> 
> Is storing the CODE a sound option?
> Any hints or comments would be appreciated =)
> 
> THX Greg
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gregory Norris
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mai

Re: RE: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread oraora oraora

Thanx Mike.
Had a look at the contents of the book.
seems to be good.
hope i will have a copy of it soon.

Thanx once again.

Regards,
Jp.

On Mon, 06 Jan 2003 Hately, Mike (NESL-IT) wrote :
>If you want to understand how Oracle uses Unix get a copy of 
>James Morle's
>"Scaling Oracle".
>It's not a beginner's Unix book but it's accurate and detailed.
>
>regards,
>Mike Hately

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Prevent FTS

2003-01-06 Thread chao_ping

manoj.gurnani,
hI, It seems that you do not need this clause:
and y.col_1 = z.col_1   
and y.col_2 = z.col_2
right?
Is your table z rather small? If your table have different size or your 
optimizer mode is different, oracle will show different plan. It is not necessary that 
index scan is better than fts.It depends . Test the result and see it:)  





Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)

=== 2003-01-06 09:39:00 ,you wrote£º===
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is 
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
.

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj



= = = = = = = = = = = = = = = = = = = =




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Are too many Foreign Keys in one table bad?

Greg,

I don't think Oracle will have a real problem with 15 tables or 1,000 rows.
If the ref tables are quite small then they won't even be worth indexing -
Oracle will just read the entire table at one anyway.  You might want to
tell Oracle to CACHE the reference tables, although I don't think you'll
see a performance gain really.  Unfortunately I can't give any performance
suggestions because I am used to the other end of the scale (ie: 250
million rows in data)

You probably could store CODE in the main table, but if you are going to
need the description frequently then all benefit is lost anyway.  Either
way though I'm sure that you'll have more problems getting the 15 joins
right when writing the queries than Oracle's CBO will have when looking at
the query - I've seen some real nasty queries get pushed into Oracle's
optimisor and as long at the statistics are valid then it does a pretty
good job.

Cheers,
 Mark.

PS:  Why would the reference CODE change instead of the DESCRIPTION?  I'm
guessing the code will be meaningful such as "HIGH", "CRITICAL", etc and
description might be "Must fix within 1 hr".  Even still, I think you are
right when you said that CODE isn't likely to change often, if at all.



   

Gregory Norris 

   
brain.com>   cc:   

Sent by: Subject: Are too many Foreign Keys in one 
table bad?  
[EMAIL PROTECTED] 

om 

   

   

07/01/2003 

07:03  

Please respond 

to ORACLE-L

   

   






I am designing some tables to store Customer Support Data.
The main table (SUPPORT_DATA) contains many (up to 15) foreign key links to
other tables.
Most of the other tables are small lookup REFTABLES (eg Priority Type).
A few bigger tables store up to 1000 records eg CUSTOMER_DATA.

I am concerned that to get data for one Support record will involve a join
of 15 Tables and possibly more for reports, and that this many tables may
confuse the Cost Based Optimiser.

I am considering storing the CODE in the SUPPORT_DATA table instead of the
ID for the reference tables.  This will reduce the number of joins greatly.

_
Design Proposed

SUPPORT_DATA
  Id (PK)
  _code (FK)
   support_data_desc



  _id (PK)
  _code (Unique Constraint)
  _description
_

The Main problems I see with this are that DATA storage increases (I can
deal with that) and  that I will have to create a trigger to update all
SUPPORT_DATA if one of the CODES in a REFTABLE is updated (this would be
rare and so not a great concern).

Is storing the CODE a sound option?
Any hints or comments would be appreciated =)

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

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




<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery

Re: rbs' maxextents in LMT

2003-01-06 Thread Arup Nanda

Guang,

You should use LMTs with UNFORM extent allocation of some size So create the 
tablespaces and the rollback segments but not the INITIAL or NEXT.

I am not sure what you meamn by runaway processes. If a transaction needs 
rollback segment space, it will need to extend it. You can still specify 
MAXEXTENTS to limit the number of extents.

HTH

Arup






From: "Guang Mei" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: rbs' maxextents in LMT Date: Mon, 06 Jan 2003 13:33:53 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by 
mc3-f32.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 6 Jan 
2003 14:06:48 -0800
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
(8.9.3/8.9.3) with UUCP id OAA03860;Mon, 6 Jan 2003 14:05:48 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00527F5F; 
Mon, 06 Jan 2003 13:33:53 -0800
Message-ID: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Guang Mei" <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 06 Jan 2003 22:06:48.0984 (UTC) 
FILETIME=[E8E2F180:01C2B5CF]

Hi:

Oracle 8173 on Sun Solaris 2.8.

I am in the process of converting rollback segments from DMT to LMT (to see 
how much performance we can get, if any). The tablespace size is 8G and I 
used to create rbs like:

create rollback segment RBS00X storage(initial 2048K next 2048K minextents 
20 maxextents 800) tablespace rbs;

I set maxextents to avoid "run away transaction". But now with rbs in LMT, 
there is no way to set maxextents, how can we avoid "run away transaction" 
in this situation?

Thanks.

Guang Mei


_
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail

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

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


_
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Help with Import

Hi,

We use a slightly different approach here...

We have a couple of development environments which get refreshed with a
subset of data (using Princeton Softech's "Move for Servers") every so
often.  The system testers also have a couple of environments like this.
These environments are good for checking basic functionality and for
creating specific scenario's to test exception handling, etc.

We also have a full volume test environment (about 1TB) which is a complete
replica of production - same hardware, same data, only passwords changed.
The is refreshed before any significant performance testing where a clean
environment is required.  The refresh is created by restoring database and
archive log files from production and then recovering the database (sorry,
I don't know the real nitty gritty since this is not something I do
personally).

The system test teams verify any database scripts against this environment
(after they have been unit tested in one of the development environments).
Naturally the volume test environment is the playground for any scripts
where performance is a concern.  Also, since the environment is normally
only a couple of weeks old a lot of data investigations can be done in this
environment, saving some load on production.

To be honest, having a replica of production like this is a god send.
Previously I worked on a large data warehouse where all testing /
development environments were tiny by comparison and it was much harder to
make any guarantee of performance.  Here I can say "this script is going to
take 25-35 minutes when run in production" with confidence.

I don't know who convinced the business to duplicate all hardware, but my
thanks go out to them.  I do know that the volume test servers are
nominated as failover servers if for some reason production was down for
several days - our system can effectively operate for 2-3 days without a
database before data is lost so instant failover isn't required.

Regards,
 Mark.



   
 
DENNIS WILLIAMS
 
   
TOUCH.COM>cc:  
 
Sent by:  Subject: RE: Help with Import
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
07/01/2003 
 
08:33  
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Raj - Thanks for sharing the details of how this method works in practice
for you.



Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]

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



Dennis,

We do almost the same thing that you described.

We have a 140G database. Everyday we *clone* that production database and
call it 'DAYOLD'. This database is used by app support to investigate data
related issues and bugs. But a day before release, we run *all* scripts
sent
in by developers on this database. It they fail on dayold database, the
whole request (and any dependencies) are pulled from the release, if not
fixed within 30 minutes from reporting.

It has been working very well for us for more than 8 months. We clone 4
such
databases of varying sizes everyday. These usually get refreshed after the
hot backup on the specific database. The cloning process (and locking down
of schema and scrambling of sensitive information is part of cloning) is
usually finished by 5:30am except Sunday.

Yes, and we use the same script on production ... with different passwords.
What do you do for multi-schema releases? We change passwords of all schema
to a known value and put "conn blah/blah" like statements in the script
that
calls all develo

Re: Are too many Foreign Keys in one table bad?

2003-01-06 Thread BigP

If the code is unique its not a problem.  Only part that can give trouble is
u r allowing to update code in reftable . That's not coool .

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


>
> I am designing some tables to store Customer Support Data.
> The main table (SUPPORT_DATA) contains many (up to 15) foreign key links
to
> other tables.
> Most of the other tables are small lookup REFTABLES (eg Priority Type).
> A few bigger tables store up to 1000 records eg CUSTOMER_DATA.
>
> I am concerned that to get data for one Support record will involve a join
> of 15 Tables and possibly more for reports, and that this many tables may
> confuse the Cost Based Optimiser.
>
> I am considering storing the CODE in the SUPPORT_DATA table instead of the
> ID for the reference tables.  This will reduce the number of joins
greatly.
>
> _
> Design Proposed
>
> SUPPORT_DATA
>   Id (PK)
>   _code (FK)
>support_data_desc
> 
>
> 
>   _id (PK)
>   _code (Unique Constraint)
>   _description
> _
>
> The Main problems I see with this are that DATA storage increases (I can
> deal with that) and  that I will have to create a trigger to update all
> SUPPORT_DATA if one of the CODES in a REFTABLE is updated (this would be
> rare and so not a great concern).
>
> Is storing the CODE a sound option?
> Any hints or comments would be appreciated =)
>
> THX Greg
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gregory Norris
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: BigP
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: rbs' maxextents in LMT

2003-01-06 Thread Gilles PARC

Hi,

the trick is to use package dbms_space_admin (Cf Oracle Doc)
to convert from DMT to LMT.
With this method, you obtain a "USER" allocation type as seen in
dba_tablespaces view that allow you to use maxextents clause.

N.B. to ease  the conversion, it's better to have DMT tablespaces already
using "minimum_extent" clause

Hope this helps

At 13:33 06/01/2003 -0800, you wrote:
>Hi:
>
>Oracle 8173 on Sun Solaris 2.8.
>
>I am in the process of converting rollback segments from DMT to LMT (to see 
>how much performance we can get, if any). The tablespace size is 8G and I 
>used to create rbs like:
>
>create rollback segment RBS00X storage(initial 2048K next 2048K minextents 
>20 maxextents 800) tablespace rbs;
>
>I set maxextents to avoid "run away transaction". But now with rbs in LMT, 
>there is no way to set maxextents, how can we avoid "run away transaction" 
>in this situation?
>
>Thanks.
>
>Guang Mei
>
>
>_
>Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
>http://join.msn.com/?page=features/featuredemail
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: Guang Mei
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>

Gilles Parc

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Automatic backup on Oracle 9i -- For Jared

2003-01-06 Thread KENNETH JANUSZ

-.-. --.-  -.. . -.-

WA9CAM/0


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 8:58 AM


> 
> I should have mentioned that another useful one could be QRM.
> 
> QRM = I am experiencing interference.
> QRM? = Are you experiencing interference?
> 
> Look across the table at your DBA-mates during your next meeting with
> management and say or ask QRM(?).  Or blink your eyes.
> 
> --.-  .-.  --
> 
> 
> > -Original Message-
> > 
> > Yea but I never see a "what's your QTH"
> > 
> > joe
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stephen Lee
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: KENNETH JANUSZ
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database/system Crashing

2003-01-06 Thread Webber Valerie H

Title: RE: Database/system Crashing

Richard,
Yes this is a SUN platform. One SA now believes it is
independent of the database since it happens when the database isn't running. I
moved the background dest files to the other disk (other than the root disk.)
Normally it would have crashed by now after starting the database and using
Designer but so far so good.
There are no error messages in /var/adm/messages. There's
no core dump file either. Its like the system gets corrupt before it can write
to the /var/adm/messages file.
What were the symptoms of your Sun NFS related crashed and
how did you diagnois the problem and what was the solution (if it were that
simple)
Val

-Original Message-From: Richard Ji
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003
4:19 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Database/system Crashing
Val,
Sorry I missed the previous messages. Was this
a Sun platform? Did the system crash with a CPU
panic
in
/var/adm/messages? We resovled a Sun NFS related crashes a couple of
months ago.
Richard Ji

-Original Message-From: Webber Valerie H
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003
11:40 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Database/system
Crashing
Yes there are NFS mounts involved. What you said about the
OS locks on the audit directory makes a lot of sense. My SA's are back to
thinking it's a OS problem because it crashed again with the database shut
down.
The odd thing is that there is nothing written to the Oracle
alert log file nor are there any entries in the trace files. But when the
system is rebooted and I bring the db back up, Oracle knows it previously
crashed and recovers itself. That's in the alert log file. Its like the
system is losing its pointers or something. I suggested reinstalling the OS
and Oracle then put my database back and see if that helps. Are there huge
risks with this scenario?
Another odd thing that the SA's can't figure out is there
are no entries in the message file nor can they get a dump file to determine
why the system crashed. There is nothing. It crashed over the weekend with
no activity and they got some sort of i-nodes error.
Thanks for all your replies. Any ideas are helpful and I
will relay them to our SA's...
Val
-Original Message- From:
Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To:
Multiple recipients of list ORACLE-L Subject: RE:
Database/system Crashing
I wonder if a file lock is being left in place when the
instance crashes, and the OS does not clear the lock
until a reboot. I would think the OS should
clear this without a reboot, but stranger things have been seen with
OS's ... even Unix. This doesn't explain why the
instance crashes. I wonder if fuser would show
anything. Are there any NFS mounts involved?
-Original Message- Yes,
you're correct and it can write the file to $ORACLE_HOME/rdbms/audit
once the system is rebooted. Its just that when the
database crashes, it can't write to that location
until its rebooted. Is it possible that I need to
beef up my init.ora parameters? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California --
Mailing list and web hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and in the message BODY,
include a line containing: UNSUB ORACLE-L (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: Prevent FTS

2003-01-06 Thread Govind.Arumugam

Please check Jonathan Lewis book 'Practice Oracle 8i'.  This book provides lot more 
details about these two optimizer related parameters that could significantly affect 
FTS situations.

optimizer_index_caching 
optimizer_index_cost_adj

The general 'harmless' guidelines could be setting 10 to optimizer_index_caching  and 
35 to optimizer_index_cost_adj.

HTH.

Govind


-Original Message-
Sent: Monday, January 06, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L


What is the significance of parameter  OPTIMIZER_INDEX_COST_ADJ ?
When I tried to change the value the explain plan has changed .

alter session set OPTIMIZER_INDEX_COST_ADJ = 10

table access for Z was by index rowid

alter session set OPTIMIZER_INDEX_COST_ADJ = 100

table access for Z was full

How can I make effective use of this parameter .
If i dont want to use this in alter session,can this value be
set elsewhere.
what is the difference between setting this parameter to some other value than 
default
compared to using hints in sql stmt.
I've tried some hints like rowid,index but it did not work for the join stmt
as it still used the FTS of Z before I tried to change the above parameter to 
10.







-Original Message-
Sent: Monday, January 06, 2003 11:03 PM
To: '[EMAIL PROTECTED]'


Hi All,
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is 
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
..

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj

-- 
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: <[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: Prevent FTS

Go to http://www.evdbt.com/papers.htm and read "The Search for Intelligent
Life in the Cost-Based Optimizer" and "How to Improve Database Performance
Using Full Table-Scans". They have very good explanations about the
situation you are facing. They are also excellent reads!

-Original Message-
Sent: Monday, January 06, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L


What is the significance of parameter  OPTIMIZER_INDEX_COST_ADJ ?
When I tried to change the value the explain plan has changed .

alter session set OPTIMIZER_INDEX_COST_ADJ = 10

table access for Z was by index rowid

alter session set OPTIMIZER_INDEX_COST_ADJ = 100

table access for Z was full

How can I make effective use of this parameter .
If i dont want to use this in alter session,can this value be
set elsewhere.
what is the difference between setting this parameter to some other value
than 
default
compared to using hints in sql stmt.
I've tried some hints like rowid,index but it did not work for the join stmt
as it still used the FTS of Z before I tried to change the above parameter
to 
10.







-Original Message-
Sent: Monday, January 06, 2003 11:03 PM
To: '[EMAIL PROTECTED]'


Hi All,
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is 
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
..

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj

-- 
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: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Help with Import

Raj - Thanks for sharing the details of how this method works in practice
for you.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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



Dennis, 

We do almost the same thing that you described. 

We have a 140G database. Everyday we *clone* that production database and
call it 'DAYOLD'. This database is used by app support to investigate data
related issues and bugs. But a day before release, we run *all* scripts sent
in by developers on this database. It they fail on dayold database, the
whole request (and any dependencies) are pulled from the release, if not
fixed within 30 minutes from reporting.

It has been working very well for us for more than 8 months. We clone 4 such
databases of varying sizes everyday. These usually get refreshed after the
hot backup on the specific database. The cloning process (and locking down
of schema and scrambling of sensitive information is part of cloning) is
usually finished by 5:30am except Sunday.

Yes, and we use the same script on production ... with different passwords.
What do you do for multi-schema releases? We change passwords of all schema
to a known value and put "conn blah/blah" like statements in the script that
calls all developer supplied scripts. Once the release is complete, it
re-sets all passwords back to what they were, and fires a compile_all script
to fix all the invalid stuff.

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

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


-Original Message- 
 ] 
Sent: Monday, January 06, 2003 2:14 PM 
To: Multiple recipients of list ORACLE-L 


Michael - Yeah but the developers are always whining about something anyway 
:-) Just kidding. Yes, timing of the refresh can be an issue. We are looking

toward a staging environment. Now that will be identical to production. Then

we can execute a script that will create or modify tables and other objects,

and test the new release. If all goes well, then the same script can be used

on production. The actual test system where the developers play should have 
more modest requirements in terms of amount of data, frequency of refresh, 
etc. Anyway, this is the environment we are moving toward. 

Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

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

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

RE: Prevent FTS

2003-01-06 Thread babu . nagarajan


Read Tim Gorman's The Search For Intelligent Life in the Cost-Based
Optimizer. I think its on his website - http://www.evdbt.com/papers.htm

Babu



   
 
  manoj.gurnani@orb
 
  itech.co.in  To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  RE: Prevent FTS   
 
   
 
   
 
  01/06/03 02:49 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




What is the significance of parameter  OPTIMIZER_INDEX_COST_ADJ ?
When I tried to change the value the explain plan has changed .

alter session set OPTIMIZER_INDEX_COST_ADJ = 10

table access for Z was by index rowid

alter session set OPTIMIZER_INDEX_COST_ADJ = 100

table access for Z was full

How can I make effective use of this parameter .
If i dont want to use this in alter session,can this value be
set elsewhere.
what is the difference between setting this parameter to some other value
than
default
compared to using hints in sql stmt.
I've tried some hints like rowid,index but it did not work for the join
stmt
as it still used the FTS of Z before I tried to change the above parameter
to
10.







-Original Message-
Sent: Monday, January 06, 2003 11:03 PM
To: '[EMAIL PROTECTED]'


Hi All,
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
..

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj

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




_
This e-mail transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may contain
confidential and privileged information.  If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited.  If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.


-- 
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 (li

Re: FW: IOUG-A

2003-01-06 Thread Stephen Andert

I too will attend that class, even if I can't get my boss to spring for
it.  They are sending me there, but they don't have to pay for the
conference, so I should be able to talk them into it.

Stephen Andert

>>> [EMAIL PROTECTED] 01/06/03 12:14PM >>>
Jonathan, if you do decide to give that class, I am definately
interested.
$250 I can talk my boss into.  $1300 for IOUG-A, I can't.  

(Ah, the joys of working for a non-IT-centric company.) 

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063



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


If you make the reservation, I will send you the money.  All credit
cards
are maxed, not from Christmas but ...

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 12:39 PM


>
> Grosvernor might be a good place.  Don't know the price... but it is
close
> (right next to Downtown Disney, and is a very nice Resort Hotel) 
Cheaper
> than the Swan and Dolphin... but very nice.
>
> 1850 Hotel Plaza Blvd.
> Lake Buena Vista, Florida 32830
> Reservations: 1.800.624.4109
>
> April Wells
> Oracle DBA
> Great spirits have always encountered violent opposition from
mediocre
minds
> -- Albert Einstein
>
>
>
> -Original Message-
> Sent: Monday, January 06, 2003 4:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> I've finally managed to fit IOUG-A into my
> timetable, after years of thinking that I really
> ought to go some day.
>
> I see from the 'University Class' listings that
> no-one is doing anything about specific on
> how the cost based optimizer works.
>
> Two questions -
> If I found some place in the locale to
> run the one-day tutorial that I did at the
> UKOUG this December (see URL below),
> would there be much interest in attending ?
> I'd probably keep the class size at around
> 40 people, with a cost of around $250, and
> plan to run it on the Sunday before the main
> event. (Or maybe on the Friday, when all
> the fuss has died down).
>
> Second - does anyone know the general
> area well enough to suggest a couple of
> reasonable hotels that might do a nice
> job of hosting such an event ?
>
>
> Thanks for any feedback.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk 
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> England__January 21/23
> USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html 
>
>
>
>
>
> --
> 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).
>
>
>
> The information contained in this communication,
> including attachments, is strictly confidential
> and for the intended use of the addressee only;
> it may also contain proprietary, price sensitive,
> or legally privileged information. Notice is
> hereby given that any disclosure, distribution,
> dissemination, use, or copying of the information
> by anyone other than the intended recipient is
> strictly prohibited and may be illegal. If you
> have received this communication in error, please
> notify the sender immediately by reply e-mail, delete
> this communication, and destroy all copies.
>
>
> Corporate Systems, Inc. has taken reasonable precautions
> to ensure that any attachment to this e-mail has been
> swept for viruses. We specifically disclaim all liability
> and will accept no responsibility for any damage sustained
> as a result of software viruses and advise you to carry out
> your own virus checks before opening any attachment.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author: April Wells
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
> San Diego, California-- Mailing list and web hosting
services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).

RE: Database/system Crashing

2003-01-06 Thread Richard Ji

Title: RE: Database/system Crashing

Val,
Sorry
I missed the previous messages. Was this a Sun platform? Did the
system crash with a CPU panic
in
/var/adm/messages? We resovled a Sun NFS related crashes a couple of
months ago.
Richard Ji

-Original Message-From: Webber Valerie H
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003
11:40 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Database/system Crashing
Yes there are NFS mounts involved. What you said about the OS
locks on the audit directory makes a lot of sense. My SA's are back to
thinking it's a OS problem because it crashed again with the database shut
down.
The odd thing is that there is nothing written to the Oracle
alert log file nor are there any entries in the trace files. But when the
system is rebooted and I bring the db back up, Oracle knows it previously
crashed and recovers itself. That's in the alert log file. Its like the system
is losing its pointers or something. I suggested reinstalling the OS and
Oracle then put my database back and see if that helps. Are there huge risks
with this scenario?
Another odd thing that the SA's can't figure out is there are
no entries in the message file nor can they get a dump file to determine why
the system crashed. There is nothing. It crashed over the weekend with no
activity and they got some sort of i-nodes error.
Thanks for all your replies. Any ideas are helpful and I will
relay them to our SA's...
Val
-Original Message- From:
Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To:
Multiple recipients of list ORACLE-L Subject: RE:
Database/system Crashing
I wonder if a file lock is being left in place when the
instance crashes, and the OS does not clear the lock
until a reboot. I would think the OS should
clear this without a reboot, but stranger things have been seen with
OS's ... even Unix. This doesn't explain why the
instance crashes. I wonder if fuser would show
anything. Are there any NFS mounts involved?
-Original Message- Yes, you're
correct and it can write the file to $ORACLE_HOME/rdbms/audit once the system is rebooted. Its just that when the database crashes,
it can't write to that location until its
rebooted. Is it possible that I need to beef up my
init.ora parameters? -- Please
see the official ORACLE-L FAQ: http://www.orafaq.net --
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (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: No logging question

It is an all or nothing shutdown of logging however and cannot be applied to
a limited set of DML, correct?

Regards,

Bill Burke
"The Kinder and Gentler DBA"
www.OracleGuru.com
www.KBMotorsports.biz



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


Welcome to the dark side, heh heh heh !

There is a hidden parameter that will achieve this . it is 
_disable_logging. Be warned though, if you set it to true, you have lost 
your ability to recover, and the only way you will recover is with full 
cold backup and would lose all subsequent work (not generally popular with 
the users), so the whole point of running in ARCHIVELOG mode becomes moot.

I have used this while still at Siebel, when doing very large installs or 
upgrades of large databases in a tight time-window, and the customers 
refused to move the redo logs over to solid state storage, I got about a 
40% - 100% performance improvment, especially if the clients were conned 
into placing the redo logs onto RAID-5 storage (bad for serial 
write-intensive operations).

Nevertheless, if you have a specific need to disable all redo generation 
for a specific time, this is the way to do it. BTW, it does not work on 
Orale for Windows.

You have been warned, don't go trying this in production first thing, it 
could cost you your job or more.

Regards :

Ferenc Mantfeld

-Original Message-
From:   GL2Z/ INF  DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, January 06, 2003 8:34 PM
To: Multiple recipients of list ORACLE-L
Subject:No logging question

Hi All,


  I want to avoid generation of archivelogs against all the DML applied
to some tables.

Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: mantfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Burke, William F (Bill)
  INET: [EMAIL PROTECTED]

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

rbs' maxextents in LMT

2003-01-06 Thread Guang Mei

Hi:

Oracle 8173 on Sun Solaris 2.8.

I am in the process of converting rollback segments from DMT to LMT (to see 
how much performance we can get, if any). The tablespace size is 8G and I 
used to create rbs like:

create rollback segment RBS00X storage(initial 2048K next 2048K minextents 
20 maxextents 800) tablespace rbs;

I set maxextents to avoid "run away transaction". But now with rbs in LMT, 
there is no way to set maxextents, how can we avoid "run away transaction" 
in this situation?

Thanks.

Guang Mei


_
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail

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

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

RE: No logging question

Ferenc...  You're still kicking buddy.  Where are you now?  I'm at Avaya in
Carrolton, TX, Sr. Tech Lead for their operations group.

Regards,

Bill Burke
"The Kinder and Gentler DBA"
www.OracleGuru.com
www.KBMotorsports.biz



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


Welcome to the dark side, heh heh heh !

There is a hidden parameter that will achieve this . it is 
_disable_logging. Be warned though, if you set it to true, you have lost 
your ability to recover, and the only way you will recover is with full 
cold backup and would lose all subsequent work (not generally popular with 
the users), so the whole point of running in ARCHIVELOG mode becomes moot.

I have used this while still at Siebel, when doing very large installs or 
upgrades of large databases in a tight time-window, and the customers 
refused to move the redo logs over to solid state storage, I got about a 
40% - 100% performance improvment, especially if the clients were conned 
into placing the redo logs onto RAID-5 storage (bad for serial 
write-intensive operations).

Nevertheless, if you have a specific need to disable all redo generation 
for a specific time, this is the way to do it. BTW, it does not work on 
Orale for Windows.

You have been warned, don't go trying this in production first thing, it 
could cost you your job or more.

Regards :

Ferenc Mantfeld

-Original Message-
From:   GL2Z/ INF  DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, January 06, 2003 8:34 PM
To: Multiple recipients of list ORACLE-L
Subject:No logging question

Hi All,


  I want to avoid generation of archivelogs against all the DML applied
to some tables.

Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: mantfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Burke, William F (Bill)
  INET: [EMAIL PROTECTED]

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

Prueba

2003-01-06 Thread Natalia Laracca

RE: Prevent FTS

2003-01-06 Thread manoj . gurnani

What is the significance of parameter  OPTIMIZER_INDEX_COST_ADJ ?
When I tried to change the value the explain plan has changed .

alter session set OPTIMIZER_INDEX_COST_ADJ = 10

table access for Z was by index rowid

alter session set OPTIMIZER_INDEX_COST_ADJ = 100

table access for Z was full

How can I make effective use of this parameter .
If i dont want to use this in alter session,can this value be
set elsewhere.
what is the difference between setting this parameter to some other value than 
default
compared to using hints in sql stmt.
I've tried some hints like rowid,index but it did not work for the join stmt
as it still used the FTS of Z before I tried to change the above parameter to 
10.







-Original Message-
Sent: Monday, January 06, 2003 11:03 PM
To: '[EMAIL PROTECTED]'


Hi All,
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is 
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
..

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj

-- 
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: Help with Import

2003-01-06 Thread Jamadagni, Rajendra

Title: RE: Help with Import 





Dennis,


We do almost the same thing that you described.


We have a 140G database. Everyday we *clone* that production database and call it 'DAYOLD'. This database is used by app support to investigate data related issues and bugs. But a day before release, we run *all* scripts sent in by developers on this database. It they fail on dayold database, the whole request (and any dependencies) are pulled from the release, if not fixed within 30 minutes from reporting.

It has been working very well for us for more than 8 months. We clone 4 such databases of varying sizes everyday. These usually get refreshed after the hot backup on the specific database. The cloning process (and locking down of schema and scrambling of sensitive information is part of cloning) is usually finished by 5:30am except Sunday.

Yes, and we use the same script on production ... with different passwords. What do you do for multi-schema releases? We change passwords of all schema to a known value and put "conn blah/blah" like statements in the script that calls all developer supplied scripts. Once the release is complete, it re-sets all passwords back to what they were, and fires a compile_all script to fix all the invalid stuff.

Raj
__
Rajendra Jamadagni      MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help with IMPort 



Michael - Yeah but the developers are always whining about something anyway
:-) Just kidding. Yes, timing of the refresh can be an issue. We are looking
toward a staging environment. Now that will be identical to production. Then
we can execute a script that will create or modify tables and other objects,
and test the new release. If all goes well, then the same script can be used
on production. The actual test system where the developers play should have
more modest requirements in terms of amount of data, frequency of refresh,
etc. Anyway, this is the environment we are moving toward.


Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[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.*1

Are too many Foreign Keys in one table bad?

2003-01-06 Thread Gregory Norris


I am designing some tables to store Customer Support Data.  
The main table (SUPPORT_DATA) contains many (up to 15) foreign key links to
other tables.  
Most of the other tables are small lookup REFTABLES (eg Priority Type).  
A few bigger tables store up to 1000 records eg CUSTOMER_DATA.

I am concerned that to get data for one Support record will involve a join
of 15 Tables and possibly more for reports, and that this many tables may
confuse the Cost Based Optimiser.

I am considering storing the CODE in the SUPPORT_DATA table instead of the
ID for the reference tables.  This will reduce the number of joins greatly.

_
Design Proposed

SUPPORT_DATA
  Id (PK)
  _code (FK)  
   support_data_desc



  _id (PK)
  _code (Unique Constraint) 
  _description
_

The Main problems I see with this are that DATA storage increases (I can
deal with that) and  that I will have to create a trigger to update all
SUPPORT_DATA if one of the CODES in a REFTABLE is updated (this would be
rare and so not a great concern).

Is storing the CODE a sound option? 
Any hints or comments would be appreciated =)

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: No logging question

2003-01-06 Thread mantfield

Welcome to the dark side, heh heh heh !

There is a hidden parameter that will achieve this . it is 
_disable_logging. Be warned though, if you set it to true, you have lost 
your ability to recover, and the only way you will recover is with full 
cold backup and would lose all subsequent work (not generally popular with 
the users), so the whole point of running in ARCHIVELOG mode becomes moot.

I have used this while still at Siebel, when doing very large installs or 
upgrades of large databases in a tight time-window, and the customers 
refused to move the redo logs over to solid state storage, I got about a 
40% - 100% performance improvment, especially if the clients were conned 
into placing the redo logs onto RAID-5 storage (bad for serial 
write-intensive operations).

Nevertheless, if you have a specific need to disable all redo generation 
for a specific time, this is the way to do it. BTW, it does not work on 
Orale for Windows.

You have been warned, don't go trying this in production first thing, it 
could cost you your job or more.

Regards :

Ferenc Mantfeld

-Original Message-
From:   GL2Z/ INF  DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, January 06, 2003 8:34 PM
To: Multiple recipients of list ORACLE-L
Subject:No logging question

Hi All,


  I want to avoid generation of archivelogs against all the DML applied
to some tables.

Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: mantfield
  INET: [EMAIL PROTECTED]

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

FW: IOUG-A

2003-01-06 Thread Koivu, Lisa

Title: FW: IOUG-A





Jonathan, if you do decide to give that class, I am definately interested.  $250 I can talk my boss into.  $1300 for IOUG-A, I can't.  

(Ah, the joys of working for a non-IT-centric company.) 


Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063




-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: IOUG-A



If you make the reservation, I will send you the money.  All credit cards
are maxed, not from Christmas but ...


Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 12:39 PM



>
> Grosvernor might be a good place.  Don't know the price... but it is close
> (right next to Downtown Disney, and is a very nice Resort Hotel)  Cheaper
> than the Swan and Dolphin... but very nice.
>
> 1850 Hotel Plaza Blvd.
> Lake Buena Vista, Florida 32830
> Reservations: 1.800.624.4109
>
> April Wells
> Oracle DBA
> Great spirits have always encountered violent opposition from mediocre
minds
> -- Albert Einstein
>
>
>
> -Original Message-
> Sent: Monday, January 06, 2003 4:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> I've finally managed to fit IOUG-A into my
> timetable, after years of thinking that I really
> ought to go some day.
>
> I see from the 'University Class' listings that
> no-one is doing anything about specific on
> how the cost based optimizer works.
>
> Two questions -
> If I found some place in the locale to
> run the one-day tutorial that I did at the
> UKOUG this December (see URL below),
> would there be much interest in attending ?
> I'd probably keep the class size at around
> 40 people, with a cost of around $250, and
> plan to run it on the Sunday before the main
> event. (Or maybe on the Friday, when all
> the fuss has died down).
>
> Second - does anyone know the general
> area well enough to suggest a couple of
> reasonable hotels that might do a nice
> job of hosting such an event ?
>
>
> Thanks for any feedback.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> England__January 21/23
> USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> --
> 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).
>
>
>
> The information contained in this communication,
> including attachments, is strictly confidential
> and for the intended use of the addressee only;
> it may also contain proprietary, price sensitive,
> or legally privileged information. Notice is
> hereby given that any disclosure, distribution,
> dissemination, use, or copying of the information
> by anyone other than the intended recipient is
> strictly prohibited and may be illegal. If you
> have received this communication in error, please
> notify the sender immediately by reply e-mail, delete
> this communication, and destroy all copies.
>
>
> Corporate Systems, Inc. has taken reasonable precautions
> to ensure that any attachment to this e-mail has been
> swept for viruses. We specifically disclaim all liability
> and will accept no responsibility for any damage sustained
> as a result of software viruses and advise you to carry out
> your own virus checks before opening any attachment.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: April Wells
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ruth

Re: Prevent FTS

2003-01-06 Thread Stephane Faroult

[EMAIL PROTECTED] wrote:
> 
> Hi All,
>   I've  3 tables   table x,y,z
> pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is
> (col_1,col_2)
> 
> where clause is :
> 
> where x.col_1 = y.col_1
> and x.col_2 = y.col_2
> and x.col_1 = z.col_1
> and x.col_2 = z.col_2
> and y.col_1 = z.col_1
> and y.col_2 = z.col_2
> and  x.col_3 in ('val1','val2','val3')
> and.
> ..
> 
> Explain plan shows that there is a FTS of table z .
> what can be the reason for this and how to prevent this.
> 
> Thanks
> Manoj
> 
> --

Manoj,

Look at the way you have written your conditions : you join x to z
and y to z too. A bit redundant since you also have the x to y join. Can
confuse Oracle. ASSUMING THAT THE CONDITION ON X.COL_3 IS SELECTIVE add
/*+ ORDERED */ after SELECT and list 
  from x, y, z
in this order. And remove the unnecessary join between x and z (just
keep x to y and y to z). As Dan remarked, don't forget that FTS are not
necessarily bad, and even are sometimes much more efficient than
something else (especially when used in a hash join, typically). The
proof of the pudding is in
 SET TIMING ON
 SET AUTOTRACE TRACEONLY
and compare the number of logical reads in both cases (and of course
elapsed time, but run each query twice to avoid measuring the effect of
parsing and bringing data into the cache)..

-- 
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: audit user activities

Audrey,

Are these direct connections or coming through JVM or some other middle tier
server where the userid cannot be discerned.

You can use the audit statement for SQL statements to look at any of the
following:

specific SQL statements
only system priv statements
any statement issued by a particular user
any statement of the same type issued during a particular session
you can also extend this to audit only those statements which succeed for
only those which fail.

HTH

Regards,

Bill Burke
"The Kinder and Gentler DBA"
www.OracleGuru.com
www.KBMotorsports.biz



-Original Message-
Sent: Monday, January 06, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L


>Dear list !
>I need to audit / log several activities of users
>against the DB .
>I need to trace a user's login/logout as well as
>DML operations on certain
>tables.
>I understand that there are more than one way to
>achieve these.
>Could you please share your experiences / tricks on
>the matter. 
>Thanks a lot !
>Andrey.

Andrey,

   Really depends on the level of detail you need. If you only need to know
which _oracle_user_ has connect and which tables s/he has modified, AUDIT is
enough. If you want to know more (eg who was connected at the OS level, from
which client or terminal, which row was deleted or what was modified)
triggers are the only way to go IMHO.

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Burke, William F (Bill)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database/system Crashing

Title: RE: Database/system Crashing



I'd 
agree with Dan.  You need to find the root cause of the crash.  If you 
rebuild to the current state from scratch, the odds are you'll see the same 
problem reoccur.  Secondly, while NFS mounted volumes will work, they 
should always be a last resort as any network, remote IO load on the server 
where the NFS mounted volume lives "could" cause IO corruption and panic the 
host server.  I didn't see the start of this thread so these are after the 
thought comments.  Maybe they're helpful.
 
Regards, 
Bill Burke "The 
Kinder and Gentler DBA" www.OracleGuru.com www.KBMotorsports.biz 

  -Original Message-From: Fink, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:55 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Database/system Crashing
  Val,
      Not having an entry in the alert 
  log or having trace files is not all that odd. This indicates a hard crash of 
  the instance, where the background processes were unable to write to the 
  files. This could be a result of the instance being forcefully terminated 
  without using the Oracle shutdown process or it could be the result of the 
  processes being unable to write to the device containing the log and trace 
  files. Try moving the background_dump_dest to another device (preferably 
  internally connected to the server).
      I would not reinstall the OS and 
  Oracle unless it can be reasonably determined that the OS is causing the 
  problem. What are the reasons the SAs say it is the OS? It is a lot of work to 
  recreate the system and you have no guarantee that this will solve it. It 
  sounds like a more detailed inspection of all the systems is in order instead 
  of spinning the 'Wheel Of Blame' to stop on the 'most likely' suspect. More 
  troubleshooting is called for, not the drastic step of "wipe it clean and 
  start over"
   
  Dan 
  Fink
  
-Original Message-From: Webber Valerie H 
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 
9:40 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Database/system 
Crashing
Yes there are NFS mounts involved. What you said about the 
OS locks on the audit directory makes a lot of sense. My SA's are back to 
thinking it's a OS problem because it crashed again with the database shut 
down. 
The odd thing is that there is nothing written to the Oracle 
alert log file nor are there any entries in the trace files. But when the 
system is rebooted and I bring the db back up, Oracle knows it previously 
crashed and recovers itself. That's in the alert log file. Its like the 
system is losing its pointers or something. I suggested reinstalling the OS 
and Oracle then put my database back and see if that helps. Are there huge 
risks with this scenario?
Another odd thing that the SA's can't figure out is there 
are no entries in the message file nor can they get a dump file to determine 
why the system crashed. There is nothing. It crashed over the weekend with 
no activity and they got some sort of i-nodes error. 
Thanks for all your replies. Any ideas are helpful and I 
will relay them to our SA's... 
Val

RE: Help with IMPort

Michael - Yeah but the developers are always whining about something anyway
:-) Just kidding. Yes, timing of the refresh can be an issue. We are looking
toward a staging environment. Now that will be identical to production. Then
we can execute a script that will create or modify tables and other objects,
and test the new release. If all goes well, then the same script can be used
on production. The actual test system where the developers play should have
more modest requirements in terms of amount of data, frequency of refresh,
etc. Anyway, this is the environment we are moving toward.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, January 06, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L

Dennis, Amar -

My interpretation of the environment was that dev/test has a different set
of tables, some of the tables match production table names but may not have
the same columns or data.  In this case, my first suggestion to drop
matching table names from dev/test is insufficient.  Maybe truncating those
tables would be a better approach.  Copying/cloning production would, of
course, wipe out dev/test.  If there is ongoing development there, that
would be a problem ;)

Mike

-Original Message-
Sent: Monday, January 06, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L

Amar - I was just thinking about suggesting. And as a bonus, you can test
your backups, always a good idea.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

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

You will need to apply the structural changes before
importing for existing tables. If you want to make a
test db as copy of original one try cloning! It is
easy and quick.

--- [EMAIL PROTECTED] wrote:
> I have 2 8i database out of which one is production
> and the other is for
> development and testing.
> 
> How can I update the data of the second one as the
> first one? tried import
> but it didnt update the data nor capture some change
> made directly to the
> table structure of the first ones.
> 
> 
> 
> Thanks
> -- 
> 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).
> 

=
cool 
amar
The best way to express yourself is to be yourself.

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Amar Kumar Padhi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

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

Re: encrypted user/passwd connection

2003-01-06 Thread Stephane Faroult

"Jesse, Rich" wrote:
> 
> Yet another reason HTML isn't a good idea for e-mail.  Try a "View Source"
> on the message and you'll see:
> 
> 
> 
> A virus perhaps
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
> 
> -Original Message-
> Sent: Monday, January 06, 2003 8:29 AM
> To: Multiple recipients of list ORACLE-L
> 
> WOW! This Encryption was GOOOD!!
> 
> Happy New Year!
> -Original Message-

Rich,

   You have read too fast, I got this with 'view source' - but I share
your view about HTML.

-- 
Dear list !
I have just been asked the following question:
is it possible to make a connection from an Oracle client to an Oracle
instance (both are 8.1.7) in an "encrypted" way.
I.e. if someone is sitting with a sniffer between the server and the
client,
then i don't want him to be able to see the user/passwd i'm connecting
with.
Again , i am NOT asking how store the data in the DB in an "encrypted"
way,
but how to connect to an instance without showing my passwd.
Thanks a lot!
Andrey.

Now Andrey RTF SQL*Net M.

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: No logging question

One option is using the create table unrecoverable as select...  While not
DML, in some circumstances it can accomplish the same thing depending on
your desired result set.  It's not a perfect solution.  I don't know of
anyway off the top of my head to simply avoid generating redo on generic dml
statements which manipulate data.

HTH

Regards,

Bill Burke
"The Kinder and Gentler DBA"
www.OracleGuru.com
www.KBMotorsports.biz



-Original Message-
Sent: Monday, January 06, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L


If you use the NOLOGGING option, you still generate redo entries (which
become archive log entries). Even if the DML is not logged, the generation
of UNDO is still logged for rollback purposes.

-Original Message-
Sent: Monday, January 06, 2003 2:34 AM
To: Multiple recipients of list ORACLE-L


Hi All,


  I want to avoid generation of archivelogs against all the DML applied
to some tables.

Thank you
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Burke, William F (Bill)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: IOUG-A

2003-01-06 Thread Ruth Gramolini

You're making the reservation, you get to choose.  But I prefer sports over
movies.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 1:35 PM


>
> Mine are only about 2/3 there... from our trip... but I will make
> reservation.  Preference music-movie or sports?
>
> April Wells
> Oracle DBA
> Great spirits have always encountered violent opposition from mediocre
minds
> -- Albert Einstein
>
>
>
> -Original Message-
> Sent: Monday, January 06, 2003 12:18 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If you make the reservation, I will send you the money.  All credit cards
> are maxed, not from Christmas but ...
>
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, January 06, 2003 12:39 PM
>
>
> >
> > Grosvernor might be a good place.  Don't know the price... but it is
close
> > (right next to Downtown Disney, and is a very nice Resort Hotel)
Cheaper
> > than the Swan and Dolphin... but very nice.
> >
> > 1850 Hotel Plaza Blvd.
> > Lake Buena Vista, Florida 32830
> > Reservations: 1.800.624.4109
> >
> > April Wells
> > Oracle DBA
> > Great spirits have always encountered violent opposition from mediocre
> minds
> > -- Albert Einstein
> >
> >
> >
> > -Original Message-
> > Sent: Monday, January 06, 2003 4:14 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >
> > I've finally managed to fit IOUG-A into my
> > timetable, after years of thinking that I really
> > ought to go some day.
> >
> > I see from the 'University Class' listings that
> > no-one is doing anything about specific on
> > how the cost based optimizer works.
> >
> > Two questions -
> > If I found some place in the locale to
> > run the one-day tutorial that I did at the
> > UKOUG this December (see URL below),
> > would there be much interest in attending ?
> > I'd probably keep the class size at around
> > 40 people, with a cost of around $250, and
> > plan to run it on the Sunday before the main
> > event. (Or maybe on the Friday, when all
> > the fuss has died down).
> >
> > Second - does anyone know the general
> > area well enough to suggest a couple of
> > reasonable hotels that might do a nice
> > job of hosting such an event ?
> >
> >
> > Thanks for any feedback.
> >
> >
> > Regards
> >
> > Jonathan Lewis
> > http://www.jlcomp.demon.co.uk
> >
> > Coming soon a new one-day tutorial:
> > Cost Based Optimisation
> > (see http://www.jlcomp.demon.co.uk/tutorial.html )
> >
> > Next Seminar dates:
> > (see http://www.jlcomp.demon.co.uk/seminar.html )
> >
> > England__January 21/23
> > USA_(CA, TX)_August
> >
> >
> > The Co-operative Oracle Users' FAQ
> > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> >
> >
> >
> >
> >
> > --
> > 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).
> >
> >
> >
> > The information contained in this communication,
> > including attachments, is strictly confidential
> > and for the intended use of the addressee only;
> > it may also contain proprietary, price sensitive,
> > or legally privileged information. Notice is
> > hereby given that any disclosure, distribution,
> > dissemination, use, or copying of the information
> > by anyone other than the intended recipient is
> > strictly prohibited and may be illegal. If you
> > have received this communication in error, please
> > notify the sender immediately by reply e-mail, delete
> > this communication, and destroy all copies.
> >
> >
> > Corporate Systems, Inc. has taken reasonable precautions
> > to ensure that any attachment to this e-mail has been
> > swept for viruses. We specifically disclaim all liability
> > and will accept no responsibility for any damage sustained
> > as a result of software viruses and advise you to carry out
> > your own virus checks before opening any attachment.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: April Wells
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED]

RE: Help with IMPort

2003-01-06 Thread Hand, Michael T

Dennis, Amar -

My interpretation of the environment was that dev/test has a different set
of tables, some of the tables match production table names but may not have
the same columns or data.  In this case, my first suggestion to drop
matching table names from dev/test is insufficient.  Maybe truncating those
tables would be a better approach.  Copying/cloning production would, of
course, wipe out dev/test.  If there is ongoing development there, that
would be a problem ;)

Mike

-Original Message-
Sent: Monday, January 06, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L

Amar - I was just thinking about suggesting. And as a bonus, you can test
your backups, always a good idea.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

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

You will need to apply the structural changes before
importing for existing tables. If you want to make a
test db as copy of original one try cloning! It is
easy and quick.

--- [EMAIL PROTECTED] wrote:
> I have 2 8i database out of which one is production
> and the other is for
> development and testing.
> 
> How can I update the data of the second one as the
> first one? tried import
> but it didnt update the data nor capture some change
> made directly to the
> table structure of the first ones.
> 
> 
> 
> Thanks
> -- 
> 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).
> 

=
cool 
amar
The best way to express yourself is to be yourself.

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Amar Kumar Padhi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: IOUG-A

2003-01-06 Thread April Wells


Sorry... that was for just Ruth... 

April Wells
Oracle DBA 
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein



-Original Message-
Sent: Monday, January 06, 2003 12:18 PM
To: Multiple recipients of list ORACLE-L


If you make the reservation, I will send you the money.  All credit cards
are maxed, not from Christmas but ...

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 12:39 PM


>
> Grosvernor might be a good place.  Don't know the price... but it is close
> (right next to Downtown Disney, and is a very nice Resort Hotel)  Cheaper
> than the Swan and Dolphin... but very nice.
>
> 1850 Hotel Plaza Blvd.
> Lake Buena Vista, Florida 32830
> Reservations: 1.800.624.4109
>
> April Wells
> Oracle DBA
> Great spirits have always encountered violent opposition from mediocre
minds
> -- Albert Einstein
>
>
>
> -Original Message-
> Sent: Monday, January 06, 2003 4:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> I've finally managed to fit IOUG-A into my
> timetable, after years of thinking that I really
> ought to go some day.
>
> I see from the 'University Class' listings that
> no-one is doing anything about specific on
> how the cost based optimizer works.
>
> Two questions -
> If I found some place in the locale to
> run the one-day tutorial that I did at the
> UKOUG this December (see URL below),
> would there be much interest in attending ?
> I'd probably keep the class size at around
> 40 people, with a cost of around $250, and
> plan to run it on the Sunday before the main
> event. (Or maybe on the Friday, when all
> the fuss has died down).
>
> Second - does anyone know the general
> area well enough to suggest a couple of
> reasonable hotels that might do a nice
> job of hosting such an event ?
>
>
> Thanks for any feedback.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> England__January 21/23
> USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> --
> 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).
>
>
>
> The information contained in this communication,
> including attachments, is strictly confidential
> and for the intended use of the addressee only;
> it may also contain proprietary, price sensitive,
> or legally privileged information. Notice is
> hereby given that any disclosure, distribution,
> dissemination, use, or copying of the information
> by anyone other than the intended recipient is
> strictly prohibited and may be illegal. If you
> have received this communication in error, please
> notify the sender immediately by reply e-mail, delete
> this communication, and destroy all copies.
>
>
> Corporate Systems, Inc. has taken reasonable precautions
> to ensure that any attachment to this e-mail has been
> swept for viruses. We specifically disclaim all liability
> and will accept no responsibility for any damage sustained
> as a result of software viruses and advise you to carry out
> your own virus checks before opening any attachment.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: April Wells
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

RE: encrypted user/passwd connection

2003-01-06 Thread Jesse, Rich

Yet another reason HTML isn't a good idea for e-mail.  Try a "View Source"
on the message and you'll see:



A virus perhaps

Rich

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

-Original Message-
Sent: Monday, January 06, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L


WOW! This Encryption was GOOOD!!
 
Happy New Year!
-Original Message-
Sent: 06 January 2003 13:44
To: Multiple recipients of list ORACLE-L
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: IOUG-A

2003-01-06 Thread April Wells


Mine are only about 2/3 there... from our trip... but I will make
reservation.  Preference music-movie or sports?

April Wells
Oracle DBA 
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein



-Original Message-
Sent: Monday, January 06, 2003 12:18 PM
To: Multiple recipients of list ORACLE-L


If you make the reservation, I will send you the money.  All credit cards
are maxed, not from Christmas but ...

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 12:39 PM


>
> Grosvernor might be a good place.  Don't know the price... but it is close
> (right next to Downtown Disney, and is a very nice Resort Hotel)  Cheaper
> than the Swan and Dolphin... but very nice.
>
> 1850 Hotel Plaza Blvd.
> Lake Buena Vista, Florida 32830
> Reservations: 1.800.624.4109
>
> April Wells
> Oracle DBA
> Great spirits have always encountered violent opposition from mediocre
minds
> -- Albert Einstein
>
>
>
> -Original Message-
> Sent: Monday, January 06, 2003 4:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> I've finally managed to fit IOUG-A into my
> timetable, after years of thinking that I really
> ought to go some day.
>
> I see from the 'University Class' listings that
> no-one is doing anything about specific on
> how the cost based optimizer works.
>
> Two questions -
> If I found some place in the locale to
> run the one-day tutorial that I did at the
> UKOUG this December (see URL below),
> would there be much interest in attending ?
> I'd probably keep the class size at around
> 40 people, with a cost of around $250, and
> plan to run it on the Sunday before the main
> event. (Or maybe on the Friday, when all
> the fuss has died down).
>
> Second - does anyone know the general
> area well enough to suggest a couple of
> reasonable hotels that might do a nice
> job of hosting such an event ?
>
>
> Thanks for any feedback.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> England__January 21/23
> USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> --
> 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).
>
>
>
> The information contained in this communication,
> including attachments, is strictly confidential
> and for the intended use of the addressee only;
> it may also contain proprietary, price sensitive,
> or legally privileged information. Notice is
> hereby given that any disclosure, distribution,
> dissemination, use, or copying of the information
> by anyone other than the intended recipient is
> strictly prohibited and may be illegal. If you
> have received this communication in error, please
> notify the sender immediately by reply e-mail, delete
> this communication, and destroy all copies.
>
>
> Corporate Systems, Inc. has taken reasonable precautions
> to ensure that any attachment to this e-mail has been
> swept for viruses. We specifically disclaim all liability
> and will accept no responsibility for any damage sustained
> as a result of software viruses and advise you to carry out
> your own virus checks before opening any attachment.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: April Wells
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

RE: Prevent FTS

2003-01-06 Thread manoj . gurnani

col_1 and col_2 are primary key columns in all 3 tables.
There is no implicit data type conversion.
col_1 is varchar2 and col_2 is varchar2  in all 3 tables.
col width is also same in all 3 tables.



-Original Message-
Sent: Monday, January 06, 2003 11:52 PM
To: Gurnani, Manoj


If an implicit data type conversion occurs within the WHERE clause, a Full
Table Scan will always results.
It is equivalent to placing a function on an index.

Are all the columns involved indexed?

- Forwarded by Charlie Mengler/THD on 01/06/2003 10:15 AM -


  manoj.gurnani@orb 

  itech.co.in  To:   Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc:  

  [EMAIL PROTECTED] Subject:  Prevent FTS





  01/06/2003 09:39  

  AM

  Please respond to 

  ORACLE-L  









Hi All,
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
..

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: IOUG-A

2003-01-06 Thread Ruth Gramolini

If you make the reservation, I will send you the money.  All credit cards
are maxed, not from Christmas but ...

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 12:39 PM


>
> Grosvernor might be a good place.  Don't know the price... but it is close
> (right next to Downtown Disney, and is a very nice Resort Hotel)  Cheaper
> than the Swan and Dolphin... but very nice.
>
> 1850 Hotel Plaza Blvd.
> Lake Buena Vista, Florida 32830
> Reservations: 1.800.624.4109
>
> April Wells
> Oracle DBA
> Great spirits have always encountered violent opposition from mediocre
minds
> -- Albert Einstein
>
>
>
> -Original Message-
> Sent: Monday, January 06, 2003 4:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> I've finally managed to fit IOUG-A into my
> timetable, after years of thinking that I really
> ought to go some day.
>
> I see from the 'University Class' listings that
> no-one is doing anything about specific on
> how the cost based optimizer works.
>
> Two questions -
> If I found some place in the locale to
> run the one-day tutorial that I did at the
> UKOUG this December (see URL below),
> would there be much interest in attending ?
> I'd probably keep the class size at around
> 40 people, with a cost of around $250, and
> plan to run it on the Sunday before the main
> event. (Or maybe on the Friday, when all
> the fuss has died down).
>
> Second - does anyone know the general
> area well enough to suggest a couple of
> reasonable hotels that might do a nice
> job of hosting such an event ?
>
>
> Thanks for any feedback.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> England__January 21/23
> USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> --
> 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).
>
>
>
> The information contained in this communication,
> including attachments, is strictly confidential
> and for the intended use of the addressee only;
> it may also contain proprietary, price sensitive,
> or legally privileged information. Notice is
> hereby given that any disclosure, distribution,
> dissemination, use, or copying of the information
> by anyone other than the intended recipient is
> strictly prohibited and may be illegal. If you
> have received this communication in error, please
> notify the sender immediately by reply e-mail, delete
> this communication, and destroy all copies.
>
>
> Corporate Systems, Inc. has taken reasonable precautions
> to ensure that any attachment to this e-mail has been
> swept for viruses. We specifically disclaim all liability
> and will accept no responsibility for any damage sustained
> as a result of software viruses and advise you to carry out
> your own virus checks before opening any attachment.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: April Wells
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

RE: Help with IMPort

2003-01-06 Thread Jamadagni, Rajendra

Title: RE: Help with IMPort 





Yeah ... yeah ... but after cloning will you submit the databases for a DNA test to prove that it is a true clone?


Oops ... Sorry ... I almost forgot we are talking databases here ... is cloning legal yet?
Raj
__
Rajendra Jamadagni      MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!


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



You will need to apply the structural changes before
importing for existing tables. If you want to make a
test db as copy of original one try cloning! It is
easy and quick.



*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: Prevent FTS

Wny do you say that a FTS of table Z is bad? How many blocks has the table
allocated (user_tables.blocks)? How many blocks will the query be returning?
Is an index read really better? Use hints to test the different access paths
and prove it.

FTS are not always bad. I have examples where a FTS is better when returning
<1% of the rows of a table. I also have examples where returning 100% of the
rows is more efficient when you use an index. It all depends on how many
blocks you need to read, not the percentage of rows.

Dan Fink

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


Hi All,
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is 
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
..

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj

-- 
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: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database/system Crashing

Title: RE: Database/system Crashing



Val,
    Not having an entry in the alert log 
or having trace files is not all that odd. This indicates a hard crash of the 
instance, where the background processes were unable to write to the files. This 
could be a result of the instance being forcefully terminated without using the 
Oracle shutdown process or it could be the result of the processes being unable 
to write to the device containing the log and trace files. Try moving the 
background_dump_dest to another device (preferably internally connected to the 
server).
    I would not reinstall the OS and 
Oracle unless it can be reasonably determined that the OS is causing the 
problem. What are the reasons the SAs say it is the OS? It is a lot of work to 
recreate the system and you have no guarantee that this will solve it. It sounds 
like a more detailed inspection of all the systems is in order instead of 
spinning the 'Wheel Of Blame' to stop on the 'most likely' suspect. More 
troubleshooting is called for, not the drastic step of "wipe it clean and start 
over"
 
Dan 
Fink

  -Original Message-From: Webber Valerie H 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 
  9:40 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Database/system Crashing
  Yes there are NFS mounts involved. What you said about the OS 
  locks on the audit directory makes a lot of sense. My SA's are back to 
  thinking it's a OS problem because it crashed again with the database shut 
  down. 
  The odd thing is that there is nothing written to the Oracle 
  alert log file nor are there any entries in the trace files. But when the 
  system is rebooted and I bring the db back up, Oracle knows it previously 
  crashed and recovers itself. That's in the alert log file. Its like the system 
  is losing its pointers or something. I suggested reinstalling the OS and 
  Oracle then put my database back and see if that helps. Are there huge risks 
  with this scenario?
  Another odd thing that the SA's can't figure out is there are 
  no entries in the message file nor can they get a dump file to determine why 
  the system crashed. There is nothing. It crashed over the weekend with no 
  activity and they got some sort of i-nodes error. 
  Thanks for all your replies. Any ideas are helpful and I will 
  relay them to our SA's... 
  Val

RE: Help with IMPort

Amar - I was just thinking about suggesting. And as a bonus, you can test
your backups, always a good idea.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

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

You will need to apply the structural changes before
importing for existing tables. If you want to make a
test db as copy of original one try cloning! It is
easy and quick.

--- [EMAIL PROTECTED] wrote:
> I have 2 8i database out of which one is production
> and the other is for
> development and testing.
> 
> How can I update the data of the second one as the
> first one? tried import
> but it didnt update the data nor capture some change
> made directly to the
> table structure of the first ones.
> 
> 
> 
> Thanks
> -- 
> 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).
> 

=
cool 
amar
The best way to express yourself is to be yourself.

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Amar Kumar Padhi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: IOUG-A

2003-01-06 Thread April Wells


Grosvernor might be a good place.  Don't know the price... but it is close
(right next to Downtown Disney, and is a very nice Resort Hotel)  Cheaper
than the Swan and Dolphin... but very nice.

1850 Hotel Plaza Blvd. 
Lake Buena Vista, Florida 32830
Reservations: 1.800.624.4109

April Wells
Oracle DBA 
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein



-Original Message-
Sent: Monday, January 06, 2003 4:14 AM
To: Multiple recipients of list ORACLE-L




I've finally managed to fit IOUG-A into my
timetable, after years of thinking that I really
ought to go some day.

I see from the 'University Class' listings that
no-one is doing anything about specific on 
how the cost based optimizer works.

Two questions -
If I found some place in the locale to
run the one-day tutorial that I did at the
UKOUG this December (see URL below),
would there be much interest in attending ?
I'd probably keep the class size at around
40 people, with a cost of around $250, and
plan to run it on the Sunday before the main
event. (Or maybe on the Friday, when all
the fuss has died down).

Second - does anyone know the general
area well enough to suggest a couple of
reasonable hotels that might do a nice
job of hosting such an event ?


Thanks for any feedback.


Regards

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

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

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

England__January 21/23
USA_(CA, TX)_August


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





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



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


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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database/system Crashing

2003-01-06 Thread Stephen Lee

Title: RE: Database/system Crashing

If the database
has data files on NFS mounts, then any network problems or problems on the NFS
server can crash things. Disappearing NFS mounts can be very nasty.
That's why it's a big no-no to put ANY files related to the database --
data files, log files, oracle binaries, etc. -- on NFS
mounts.

-Original Message-From: Webber Valerie H
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003
10:40 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Database/system Crashing
Yes there are NFS mounts involved. What you said about the OS
locks on the audit directory makes a lot of sense. My SA's are back to
thinking it's a OS problem because it crashed again with the database shut
down.
The odd thing is that there is nothing written to the Oracle
alert log file nor are there any entries in the trace files. But when the
system is rebooted and I bring the db back up, Oracle knows it previously
crashed and recovers itself. That's in the alert log file. Its like the system
is losing its pointers or something. I suggested reinstalling the OS and
Oracle then put my database back and see if that helps. Are there huge risks
with this scenario?
Another odd thing that the SA's can't figure out is there are
no entries in the message file nor can they get a dump file to determine why
the system crashed. There is nothing. It crashed over the weekend with no
activity and they got some sort of i-nodes error.
Thanks for all your replies. Any ideas are helpful and I will
relay them to our SA's...
Val
-Original Message- From:
Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To:
Multiple recipients of list ORACLE-L Subject: RE:
Database/system Crashing
I wonder if a file lock is being left in place when the
instance crashes, and the OS does not clear the lock
until a reboot. I would think the OS should
clear this without a reboot, but stranger things have been seen with
OS's ... even Unix. This doesn't explain why the
instance crashes. I wonder if fuser would show
anything. Are there any NFS mounts involved?
-Original Message- Yes, you're
correct and it can write the file to $ORACLE_HOME/rdbms/audit once the system is rebooted. Its just that when the database crashes,
it can't write to that location until its
rebooted. Is it possible that I need to beef up my
init.ora parameters? -- Please
see the official ORACLE-L FAQ: http://www.orafaq.net --
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

Prevent FTS

2003-01-06 Thread manoj . gurnani

Hi All,
  I've  3 tables   table x,y,z
pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is 
(col_1,col_2)

where clause is :

where x.col_1 = y.col_1
and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2
and  x.col_3 in ('val1','val2','val3')
and.
..

Explain plan shows that there is a FTS of table z .
what can be the reason for this and how to prevent this.


Thanks
Manoj

-- 
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: Database/system Crashing

Val - I had a horrible problem using RMAN over NFS. Just hanging. Eventually
it turned out that NFS was configured for only a few connections (I can't
recall the exact term used). The assumption was that if we were only doing
one thing, then that should be adequate. It turned out this needed to be
increased. Hope that is some help.


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED]   

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



Yes there are NFS mounts involved. What you said about the OS locks on the
audit directory makes a lot of sense. My SA's are back to thinking it's a OS
problem because it crashed again with the database shut down. 

The odd thing is that there is nothing written to the Oracle alert log file
nor are there any entries in the trace files. But when the system is
rebooted and I bring the db back up, Oracle knows it previously crashed and
recovers itself. That's in the alert log file. Its like the system is losing
its pointers or something. I suggested reinstalling the OS and Oracle then
put my database back and see if that helps. Are there huge risks with this
scenario?

Another odd thing that the SA's can't figure out is there are no entries in
the message file nor can they get a dump file to determine why the system
crashed. There is nothing. It crashed over the weekend with no activity and
they got some sort of i-nodes error. 

Thanks for all your replies. Any ideas are helpful and I will relay them to
our SA's... 

Val 

-Original Message- 
Sent: Friday, January 03, 2003 10:09 AM 
To: Multiple recipients of list ORACLE-L 



I wonder if a file lock is being left in place when the instance crashes, 
and the OS does not clear the lock until a reboot.  I would think the OS 
should clear this without a reboot, but stranger things have been seen with 
OS's ... even Unix.  This doesn't explain why the instance crashes.  I 
wonder if fuser would show anything.  Are there any NFS mounts involved? 

-Original Message- 
Yes, you're correct and it can write the file to $ORACLE_HOME/rdbms/audit 
once the system is rebooted. Its just that when the database crashes, it 
can't write to that location until its rebooted. 
Is it possible that I need to beef up my init.ora parameters? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
  
-- 
Author: Stephen Lee 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  
San Diego, California-- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread Hately, Mike (NESL-IT)

If you want to understand how Oracle uses Unix get a copy of James Morle's
"Scaling Oracle".
It's not a beginner's Unix book but it's accurate and detailed.

regards,
Mike Hately

-Original Message-
Sent: 06 January 2003 15:59
To: Multiple recipients of list ORACLE-L



Doesn't anyone read the manuals any more?!

Oracle9i Installation Guide - Unix
  http://download-east.oracle.com/docs/html/A96167_01/toc.htm
Oracle9i Administrator's Reference - Unix
  http://download-east.oracle.com/docs/html/A97297_01/toc.htm




 

  "James Damiano"

  <[EMAIL PROTECTED]To:   Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]> 
  .nh.us>  cc:

  Sent by: Subject:  Re: Unix for oracle
dba -- Suggest a book ? 
  [EMAIL PROTECTED]

 

 

  01/06/03 06:28 AM

  Please respond to

  ORACLE-L

 

 





I've found a wonderful resource in the following book:

"Oracle DBA on Unix and Linux"
by Michael Wessler
http://www.samspublishing.com

It covers some of the differences in features between 8i and 9i as well as
handling the specifics of administrating Oracle specifically on Unix
platforms.  Highly recommended (at least by me).

Jim Damiano


> Guys,

> i know a bit of Linux.and not completely a newbie to Unix.

> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.

> any such book available ?
> kindly let me know guys.

> TIA.
> Jp.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Hately, Mike (NESL-IT)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sun HA Monitoring and Oracle 9

Scott - My sys admin is out today, but I believe he found TeamQuest to be a
better tool. He was getting hints that Sun may switch to that product as
their standard. Just consider this an unconfirmed rumor.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


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


Here's a little background.  We are currently running Oracle
8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster.  We use HA monitoring
for failover, in case there is a problem with any of the nodes.  The
version of HA is 2.2.  We installed Oracle 9.2.0.1 on the cluster and
created a new database using it.  When the SA tried to start the HA
monitoring, it wouldn't run.  We ended up recreating the database in
8.1.7.4.  When the SA contacted Sun, he was told that HA version 2.2
only supports up to Oracle 8.1.7.  In order to monitor Oracle 9, we had
to buy (not upgrade to) HA 3.0, which would require a rebuild of the
entire cluster.

Has anyone else run into this problem?  If so, what have you done to
get around it?  Let me know if I forgot any important piece of
information.

Thank you.

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

Re: Help with IMPort

2003-01-06 Thread Amar Kumar Padhi

You will need to apply the structural changes before
importing for existing tables. If you want to make a
test db as copy of original one try cloning! It is
easy and quick.

--- [EMAIL PROTECTED] wrote:
> I have 2 8i database out of which one is production
> and the other is for
> development and testing.
> 
> How can I update the data of the second one as the
> first one? tried import
> but it didnt update the data nor capture some change
> made directly to the
> table structure of the first ones.
> 
> 
> 
> Thanks
> -- 
> 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).
> 

=
cool 
amar
The best way to express yourself is to be yourself.

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Amar Kumar Padhi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: IOUG-A

2003-01-06 Thread John Kanagaraj

Hi Jonathan,

As I am not from that area, I won't comment. However, it would be a nice
opportunity to meet the Guru!

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

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

RE: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread Richard Ji

And if you are running on Solaris, get "Solaris Internals" from Sun.
"Unix System Administartor Handbook" is a good Unix book too.

-Original Message-
Sent: Monday, January 06, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L


Oracle8i and Unix Performance Tuning by Ahmed Alomari

--- oraora  oraora <[EMAIL PROTECTED]> wrote:
> Guys,
> 
> i know a bit of Linux.and not completely a newbie to Unix.
> 
> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.
> 
> any such book available ?
> kindly let me know guys.
> 
> TIA.
> Jp.
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread Craig Healey

> >I like this one as a general (but in depth) one for Unix Admins, 
> >because it
> >has lots of real life stuff:
> >
UNIX System Administration Handbook (3rd Edition)

> >Paperback: 896 pages ; Dimensions (in inches): 1.30 x 9.23 x 
> >7.06
> >Publisher: Prentice Hall PTR; ISBN: 0130206016; 3rd edition 
> >(August 2000)
> >
> >Also this little booklet for Oracle DBAs:
> >
Unix for Oracle DBAs Pocket Reference 

> >Paperback: 104 pages ; Dimensions (in inches): 0.33 x 7.04 x 
> >4.50
> >Publisher: O'Reilly & Associates; ISBN: 0596000669; 1st edition 
> >(May 2001)
> >
> >Regards,
> >Stefan
 
Amazing what a search on Amazon brings up :-)

Craig


**

This email and any files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed and may contain
confidential and/or privileged material.  Any review, retransmission, dissemination
or other use of, or taking of any action in reliance upon, this information by 
persons or entities other than the intended recipient is prohibited.  Statements
and opinions expressed in this e-mail may not represent those of the company.
  
If you have received this email in error please notify [EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database/system Crashing

2003-01-06 Thread Webber Valerie H

Title: RE: Database/system Crashing





Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down. 

The odd thing is that there is nothing written to the Oracle alert log file nor are there any entries in the trace files. But when the system is rebooted and I bring the db back up, Oracle knows it previously crashed and recovers itself. That's in the alert log file. Its like the system is losing its pointers or something. I suggested reinstalling the OS and Oracle then put my database back and see if that helps. Are there huge risks with this scenario?

Another odd thing that the SA's can't figure out is there are no entries in the message file nor can they get a dump file to determine why the system crashed. There is nothing. It crashed over the weekend with no activity and they got some sort of i-nodes error. 

Thanks for all your replies. Any ideas are helpful and I will relay them to our SA's...


Val


-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database/system Crashing




I wonder if a file lock is being left in place when the instance crashes,
and the OS does not clear the lock until a reboot.  I would think the OS
should clear this without a reboot, but stranger things have been seen with
OS's ... even Unix.  This doesn't explain why the instance crashes.  I
wonder if fuser would show anything.  Are there any NFS mounts involved?


-Original Message-
Yes, you're correct and it can write the file to $ORACLE_HOME/rdbms/audit
once the system is rebooted. Its just that when the database crashes, it
can't write to that location until its rebooted.
Is it possible that I need to beef up my init.ora parameters?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: encrypted user/passwd connection

2003-01-06 Thread Khedr, Waleed




LOL 
:)

  -Original Message-From: Mark Leith 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 9:29 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  encrypted user/passwd connection
  WOW! 
  This Encryption was GOOOD!!
   
  Happy New Year!
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Andrey BronfinSent: 
06 January 2003 13:44To: Multiple recipients of list 
ORACLE-LSubject: encrypted user/passwd 
  connection

RE: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread Farnsworth, Dave

Hallo,

What is manuals?

TIA

-Original Message-
Sent: Monday, January 06, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L



Doesn't anyone read the manuals any more?!

Oracle9i Installation Guide - Unix
  http://download-east.oracle.com/docs/html/A96167_01/toc.htm
Oracle9i Administrator's Reference - Unix
  http://download-east.oracle.com/docs/html/A97297_01/toc.htm




   
  
  "James Damiano"  
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .nh.us>  cc: 
  
  Sent by: Subject:  Re: Unix for oracle dba -- 
Suggest a book ? 
  [EMAIL PROTECTED] 
  
   
  
   
  
  01/06/03 06:28 AM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




I've found a wonderful resource in the following book:

"Oracle DBA on Unix and Linux"
by Michael Wessler
http://www.samspublishing.com

It covers some of the differences in features between 8i and 9i as well as
handling the specifics of administrating Oracle specifically on Unix
platforms.  Highly recommended (at least by me).

Jim Damiano


> Guys,

> i know a bit of Linux.and not completely a newbie to Unix.

> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.

> any such book available ?
> kindly let me know guys.

> TIA.
> Jp.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Statspack Viewer

2003-01-06 Thread Jamadagni, Rajendra

Title: RE: Statspack Viewer





It is good, and for me, it is worth the money.


Raj
__
Rajendra Jamadagni      MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: Tracy Rahmlow [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Statspack Viewer




http://www.geocities.com/alexdabr/


I have not seen any comments about this product from anyone yet.  I am not sure if it is too new, unknown or what.  Again, I am looking for any comments from

anyone
who has used or evaluated it.  Thanks



*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: Statspack Viewer

2003-01-06 Thread Igor Neyman

http://www.statsviewer.narod.ru/

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  


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


> 
> What is the URL for this product?
> 
> RWB
> 
> -- 
> 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: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: audit user activities

2003-01-06 Thread Farnsworth, Dave




I seem 
to be drawing a blank on this one.

  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 
  8:19 AMTo: Multiple recipients of list ORACLE-LSubject: 
  audit user activities

Sun HA Monitoring and Oracle 9

2003-01-06 Thread Scott Canaan

Here's a little background.  We are currently running Oracle
8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster.  We use HA monitoring
for failover, in case there is a problem with any of the nodes.  The
version of HA is 2.2.  We installed Oracle 9.2.0.1 on the cluster and
created a new database using it.  When the SA tried to start the HA
monitoring, it wouldn't run.  We ended up recreating the database in
8.1.7.4.  When the SA contacted Sun, he was told that HA version 2.2
only supports up to Oracle 8.1.7.  In order to monitor Oracle 9, we had
to buy (not upgrade to) HA 3.0, which would require a rebuild of the
entire cluster.

Has anyone else run into this problem?  If so, what have you done to
get around it?  Let me know if I forgot any important piece of
information.

Thank you.

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Statspack Viewer

2003-01-06 Thread Tracy Rahmlow


http://www.geocities.com/alexdabr/

I have not seen any comments about this product from anyone yet.  I am not sure if it 
is too new, unknown or what.  Again, I am looking for any comments from
anyone
who has used or evaluated it.  Thanks






Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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



What is the URL for this product?

RWB

--
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: Tracy Rahmlow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: audit user activities

2003-01-06 Thread Stephane Faroult

>Dear list !
>I need to audit / log several activities of users
>against the DB .
>I need to trace a user's login/logout as well as
>DML operations on certain
>tables.
>I understand that there are more than one way to
>achieve these.
>Could you please share your experiences / tricks on
>the matter. 
>Thanks a lot !
>Andrey.

Andrey,

   Really depends on the level of detail you need. If you only need to know which 
_oracle_user_ has connect and which tables s/he has modified, AUDIT is enough. If you 
want to know more (eg who was connected at the OS level, from which client or 
terminal, which row was deleted or what was modified) triggers are the only way to go 
IMHO.

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread Brian_P_MacLean


Doesn't anyone read the manuals any more?!

Oracle9i Installation Guide - Unix
  http://download-east.oracle.com/docs/html/A96167_01/toc.htm
Oracle9i Administrator's Reference - Unix
  http://download-east.oracle.com/docs/html/A97297_01/toc.htm




   
  
  "James Damiano"  
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .nh.us>  cc: 
  
  Sent by: Subject:  Re: Unix for oracle dba -- 
Suggest a book ? 
  [EMAIL PROTECTED] 
  
   
  
   
  
  01/06/03 06:28 AM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




I've found a wonderful resource in the following book:

"Oracle DBA on Unix and Linux"
by Michael Wessler
http://www.samspublishing.com

It covers some of the differences in features between 8i and 9i as well as
handling the specifics of administrating Oracle specifically on Unix
platforms.  Highly recommended (at least by me).

Jim Damiano


> Guys,

> i know a bit of Linux.and not completely a newbie to Unix.

> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.

> any such book available ?
> kindly let me know guys.

> TIA.
> Jp.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Help with IMPort

2003-01-06 Thread Hand, Michael T


To fine tune the suggestions aready made, you probably don't want to drop
all the table but just tables both in production and development/test.  I
would create a list of tables exported from production via export / show and
use this to create a drop table script.

Mike

-Original Message-
Sent: Monday, January 06, 2003 4:29 AM
To: Multiple recipients of list ORACLE-L


The best method that I know is:

1) export from production.
2) drop user cascade in development or at least drop all tables.
3) create user in development.
4) import into development with indexes=n and constraint=n.
5) import again into development with rows = n and ignore = y.

Step 4 will build all the tables with the data.
Step 5 will build indexes and enable constraints.

If the tables already exist in the target database then import will not
recreate them.
As for the data you may have constraints that reject the insert of records.

Lets say you have a fact table and a lookup table that contain the branches
names.
On the fact table you have constraint: branch id must be in the branch
table.
When you import the fact table before the branch table all the records will
be rejected because the branch table does not have the ids yet.

Yechiel Adar
Mehish
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hand, Michael T
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: encrypted user/passwd connection

2003-01-06 Thread Mark Leith




WOW! 
This Encryption was GOOOD!!
 
Happy 
New Year!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey BronfinSent: 06 
  January 2003 13:44To: Multiple recipients of list 
  ORACLE-LSubject: encrypted user/passwd 
connection

RE: No logging question

If you use the NOLOGGING option, you still generate redo entries (which
become archive log entries). Even if the DML is not logged, the generation
of UNDO is still logged for rollback purposes.

-Original Message-
Sent: Monday, January 06, 2003 2:34 AM
To: Multiple recipients of list ORACLE-L


Hi All,


  I want to avoid generation of archivelogs against all the DML applied
to some tables.

Thank you
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix for oracle dba -- Suggest a book ?

A second book you will find very helpful is from Sun...  Configuration and
Capacity Planning for Solaris Servers.  Also, my Unix bookshelf has the
following references..

The New Kornshell - Bolsky & Korn
PERL in a Nutshell - Siever
sed & awk - Dougherty
UNIX Programming Tools - Johnson
UNIX Unleashed (an excellent general reference)

One other very valuable reference source is man on the UNIX servers.  For
finger tip reference I dump the man pages for sar, iostat, vmstat, glance
(if you're on HP) plus the vi man pages.

HTH.

Regards,

Bill Burke
"The Kinder and Gentler DBA"
www.OracleGuru.com
www.KBMotorsports.biz



-Original Message-
Sent: Monday, January 06, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L


Oracle8i and Unix Performance Tuning by Ahmed Alomari

--- oraora  oraora <[EMAIL PROTECTED]> wrote:
> Guys,
> 
> i know a bit of Linux.and not completely a newbie to Unix.
> 
> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.
> 
> any such book available ?
> kindly let me know guys.
> 
> TIA.
> Jp.
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread oraora oraora

Thanx Stefan.
can u mention the title of the book please ?
i would like to buy it as soon as possible !

TIA.
Jp.

On Mon, 06 Jan 2003 Stefan Jahnke wrote :
>Hi oraora
>
>I like this one as a general (but in depth) one for Unix Admins, 
>because it
>has lots of real life stuff:
>
>Paperback: 896 pages ; Dimensions (in inches): 1.30 x 9.23 x 
>7.06
>Publisher: Prentice Hall PTR; ISBN: 0130206016; 3rd edition 
>(August 2000)
>
>Also this little booklet for Oracle DBAs:
>
>Paperback: 104 pages ; Dimensions (in inches): 0.33 x 7.04 x 
>4.50
>Publisher: O'Reilly & Associates; ISBN: 0596000669; 1st edition 
>(May 2001)
>
>Regards,
>Stefan
>
>-Ursprüngliche Nachricht-
>Von: oraora oraora [mailto:[EMAIL PROTECTED]]
>Gesendet: Montag, 6. Januar 2003 11:14
>An: Multiple recipients of list ORACLE-L
>Betreff: Unix for oracle dba -- Suggest a book ?
>
>
>Guys,
>
>i know a bit of Linux.and not completely a newbie to Unix.
>
>Can u suggest me a good/best book for Unix ?
>..Unix for oracle DBA.
>i.e,tuning unix for good performance of oracle.
>
>any such book available ?
>kindly let me know guys.
>
>TIA.
>Jp.
>
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 
>http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting 
>services
>-
>To REMOVE yourself from this mailing list, send an E-Mail 
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 
>http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting 
>services
>-
>To REMOVE yourself from this mailing list, send an E-Mail 
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: oraora  oraora
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Statspack Viewer

2003-01-06 Thread Reginald . W . Bailey


What is the URL for this product?

RWB

-- 
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: Statspack Viewer

2003-01-06 Thread Leonard, George

http://www.geocities.com/alexdabr/

George

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Cell: 082 655 2466
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:[EMAIL PROTECTED]
Web:   http://www.didata.co.za
 
You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
or Injure Themselves as They See Fit!

-Original Message-

Sent: 06 January 2003 14:59 PM
To: Multiple recipients of list ORACLE-L


What is the URL for this product?

RWB

-- 
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: Leonard, George
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Automatic backup on Oracle 9i -- For Jared

2003-01-06 Thread Stephen Lee


I should have mentioned that another useful one could be QRM.

QRM = I am experiencing interference.
QRM? = Are you experiencing interference?

Look across the table at your DBA-mates during your next meeting with
management and say or ask QRM(?).  Or blink your eyes.

--.-  .-.  --


> -Original Message-
> 
> Yea but I never see a "what's your QTH"
> 
> joe
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

encrypted user/passwd connection

2003-01-06 Thread Andrey Bronfin

Re: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread James Damiano

I've found a wonderful resource in the following book:

"Oracle DBA on Unix and Linux"
by Michael Wessler
http://www.samspublishing.com

It covers some of the differences in features between 8i and 9i as well as
handling the specifics of administrating Oracle specifically on Unix
platforms.  Highly recommended (at least by me).

Jim Damiano


> Guys,

> i know a bit of Linux.and not completely a newbie to Unix.

> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.

> any such book available ?
> kindly let me know guys.

> TIA.
> Jp.


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

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

audit user activities

2003-01-06 Thread Andrey Bronfin

max open files

2003-01-06 Thread Jeroen van Sluisdam

Hi,

Do you know about any limits for max. open files concerning use of utl_file.
I'm writing a plsql program to dum several tables and make use of utl_file.
I'm getting invalid operation when opening 12 files sequentially and
when I rewrite the program to do this only when needed it disappears.
Any idea, maybe this OS-dependent ?

Details: 7.3.4 HP-UX 10.20

Tia,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix for oracle dba -- Suggest a book ?

2003-01-06 Thread David Wagoner

This is the latest one that I've seen.  I have it and the parts that I've
read are good.


http://www.amazon.com/exec/obidos/ASIN/0072223049/qid%3D1041862110/sr%3D11-1
/ref%3Dsr%5F11%5F1/103-3312873-7713423


"Oracle 9i UNIX Administration Handbook", by Don Burleson (ISBN 0072223049),
2002


David Wagoner
Oracle DBA



-Original Message-
Sent: Monday, January 06, 2003 5:14 AM
To: Multiple recipients of list ORACLE-L

Guys,

i know a bit of Linux.and not completely a newbie to Unix.

Can u suggest me a good/best book for Unix ?
..Unix for oracle DBA.
i.e,tuning unix for good performance of oracle.

any such book available ?
kindly let me know guys.

TIA.
Jp.






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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: David Wagoner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix for oracle dba -- Suggest a book ?

Stefan,

would you mind posting the names of the books, as well as the authors?
:)

Rachel

--- Stefan Jahnke <[EMAIL PROTECTED]> wrote:
> Hi oraora
> 
> I like this one as a general (but in depth) one for Unix Admins,
> because it
> has lots of real life stuff:
> 
> Paperback: 896 pages ; Dimensions (in inches): 1.30 x 9.23 x 7.06 
> Publisher: Prentice Hall PTR; ISBN: 0130206016; 3rd edition (August
> 2000)
> 
> Also this little booklet for Oracle DBAs:
> 
> Paperback: 104 pages ; Dimensions (in inches): 0.33 x 7.04 x 4.50 
> Publisher: O'Reilly & Associates; ISBN: 0596000669; 1st edition (May
> 2001) 
> 
> Regards,
> Stefan
> 
> -Ursprüngliche Nachricht-
> Von: oraora oraora [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 6. Januar 2003 11:14
> An: Multiple recipients of list ORACLE-L
> Betreff: Unix for oracle dba -- Suggest a book ?
> 
> 
> Guys,
> 
> i know a bit of Linux.and not completely a newbie to Unix.
> 
> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.
> 
> any such book available ?
> kindly let me know guys.
> 
> TIA.
> Jp.
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Re: MTS / Dedicated

2003-01-06 Thread chao_ping

S Anandan,
I think for 75 connections, dedicated server is good enough.
75 connection is nothing for a database, and you said your user never 
idle at any time, so dediacted server is better .





Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(ChinaOracle User Group)

=== 2003-01-06 14:28:00 ,you wrote£º===

>Dear All,
>
> I have 75 concurrent MTS user sessions for my database.All users 
>never be idle at any time. Can anybody suggest me how many Dispatcher 
>process and Shared server process should I have, so that there should not be 
>any response delay because of MTS.Or if u think for 75 users Dedicated 
>server model will do, please tell me the Idea behind this.
>
>   Waiting for valueble reply!!!
>
>Thanks In Advance.
>
>Regards,
>Anandan S
>
>
>
>
>
>
>
>
>
>_
>STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
>http://join.msn.com/?page=features/junkmail
>
>
>
>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to [EMAIL PROTECTED]
>To subscribe:   send a blank email to [EMAIL PROTECTED]
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html

= = = = = = = = = = = = = = = = = = = =




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix for oracle dba -- Suggest a book ?