to_char(sysdate) problem on 8.1.7.

[Daniel Wisser]

hi!

8.1.7. on WIN:

due to a bug - it seems - the following query returns an error:

SQL> SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual;
SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual
 *
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [538241312], [], [],
[],
[], [], []

while it works fine on 8.0.5. and 8.1.6.!

does anyone know a way to change the query, so it will work on all
version and there is no need for a patch?


tia & regards
daniel
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

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

RE: to_char(sysdate) problem on 8.1.7.

[Nirmal Kumar Muthu Kumaran]

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

SQL> select to_char(sysdate,'dd.mm.') from dual;

TO_CHAR(SY
--
15.10.2002
---

It's doing fine... on Win2k.

Nirmal.



-Original Message-
Sent: Tuesday, October 15, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L


hi!

8.1.7. on WIN:

due to a bug - it seems - the following query returns an error:

SQL> SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual;
SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual
 *
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [538241312], [], [],
[],
[], [], []

while it works fine on 8.0.5. and 8.1.6.!

does anyone know a way to change the query, so it will work on all
version and there is no need for a patch?


tia & regards
daniel
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

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

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

Re: CodeNotes for Oracle9i...

[Connor McDonald]

There's always some idiot who wants to rain on the
parade, so it may as well be me.  I can't remember the
specifics but a recent test in London showed that
people on (hands-free) phones in their cars were 'x'%
more likely to crash ('x' was somewhere like 50%!),
the test being designed to show that its not the phone
in your hand, its the fact that you're
talking/listening that ends up killing you...

I can't begin to imagine the traffic carnage when the
CD "DBA101: The sensual sultry sounds of Carmichael"
hits the charts!

Does Rachel really want that kind of responsbility :-)

Cheers
Connor

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> It's a little difficult to see how code samples and
> illustrations
> (which I find invaluable) could be translated to
> audio
> 
> It's technically copyright infringement (I believe)
> to translate the
> books. I don't own the copyright, so I'm not about
> to call out the
> lawyers. I am supposed to contact my publisher for
> permission (never
> been refused, as it's publicity) when I want to use
> part of a chapter
> for an article or presentation.
> 
> Besides, I have problems concentrating when I listen
> to books on tape,
> so I'm not the best person to advocate this!
> 
> 
> --- Joe Testa <[EMAIL PROTECTED]> wrote:
> > I would think the authors should read and publish
> the books in .mp3 
> > format, you can get like 10 hours worth on one cd.
> > 
> > Rachel how about you start,
> > 
> > bwahahahahahahaha
> > 
> > 
> > joe
> > 
> > 
> > DENNIS WILLIAMS wrote:
> > 
> > >I have an odd question about these on-line books.
> Can I
> > copy-and-paste the
> > >text? 
> > >   Like many of you, I seem to end up with long
> commutes (why are
> > the best
> > >jobs never in your neighborhood?). I find
> listening to books on CD
> > to be a
> > >better use of time than reading bumper stickers.
> Nobody ever seems
> > to issue
> > >Oracle books on audio. So I got a text-to-voice
> program, and it
> > works pretty
> > >good to create an audio version of a book. But
> many of these eBooks
> > >zealously protect their text and prevent you from
> doing
> > copy-and-paste on
> > >the text. Fortunately Oracle makes their books
> readily available.
> > Any ideas
> > >are welcome. And my apologies to the authors on
> the list that are
> > going "he
> > >wants to do WHAT with my book!!".
> > >Dennis Williams
> > >DBA
> > >Lifetouch, Inc.
> > >[EMAIL PROTECTED] 
> > >
> > >-Original Message-
> > >Sent: Thursday, October 10, 2002 7:54 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >I believe the Book Safari is changing.  It is
> supposed
> > >to be more flexible now.
> > >
> > >http://www.oreilly.com/news/new_safari_0902.html
> > >
> > >Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > >"Grabowy, Chris" <[EMAIL PROTECTED]>
> > >Sent by: [EMAIL PROTECTED]
> > > 10/08/2002 01:04 PM
> > > Please respond to ORACLE-L
> > >
> > > 
> > >To: Multiple recipients of list
> ORACLE-L
> > <[EMAIL PROTECTED]>
> > >cc: 
> > >Subject:CodeNotes for Oracle9i...
> > >
> > >
> > >So every few months my Lookout reminder pops up
> to remind me to
> > check out 
> > >what new Oracle books have been released.  I
> stumbled upon a new
> > book 
> > >called CodeNotes for Oracle9i on Amazon.com, but
> the interesting
> > part is 
> > >that it is available in eBook format.  Here's the
> (probably broken) 
> > >link...
> > >
> >
>
>http://www.amazon.com/exec/obidos/tg/detail/-/B6ISCN/qid=1034101493/sr=1
> > >-25/ref=sr_1_25/104-5919725-7522346?v=glance
> > >
> > >The eBook version is $9.95 and the shipping is
> free (big grin),
> > while the 
> > >paperback is $13.97 plus shipping.  Are you
> comfortable reading an
> > eBook? 
> > >You decide. 
> > >
> > >At any rate, I will probably break down and buy
> the eBook.  Not so
> > much 
> > >because the book is great (or not) but because I
> hope to send a
> > message to 
> > >publishers to publish more books in the eBook
> format, which is also
> > why I 
> > >posted this message.
> > >
> > >I know that O'Reilly has the Safari Bookshelf
> website, but I found
> > it to 
> > >be restrictive and pricey.
> > >
> > >BTW, if for some reason you are or will be using
> .Net, the CodeNotes
> > eBook 
> > >version is free...
> > >
> >
>
>http://www.codenotes.com/do/downloads/downloadsNETbook
> > >
> > >
> > >
> > 
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Joe Testa
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mai

RE: No Nulls? (was: Warehouse design: snowflake vs star schemas)

[Robson, Peter]

If you go back to that site, and take the 'Content' page (
http://www.dbdebunk.com/content.htm ) you will find two articles by Fabian
Pascal on nulls. Chris Date has also written frequently on the subject of
nulls. Use Google to search on <"chris date" nulls> and you will find more.
(The reference to the site www.pgro.uk7.net is actually www.dbdebunk.com,
just an irritating feature of the forwarding domain registration - sigh,
they are the same site.)

Chris's statement that nulls are a disaster could not be more true - take
note!

peter
edinburgh

> -Original Message-
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
> Sent: 14 October 2002 18:34
> To: Multiple recipients of list ORACLE-L
> Subject: No Nulls? (was: Warehouse design: snowflake vs star schemas)
> 
> 
> On the link below is this quote from C.J.Date:
> 
> "I don't want you to think that my SQL solution to your 
> problem means I
> advocate the use of nulls.  Nulls are a disaster."
> 
> Of course, he doesn't expound upon it (probably not a need except for
> dummies like me).  Anyone care to comment?  (On the quote, not on my
> dumminess...)
> 
> 
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> 
> > -Original Message-
> > From: Robson, Peter [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 14, 2002 4:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Warehouse design: snowflake vs star schemas
> > 
> > 
> > Just for the record (and perhaps to confirm that there are 
> > always two sides
> > to a story). Readers may like to see the article Chris Date 
> > wrote to Ralph
> > Kemball on the subject of business rules and integrity constraints:
> > 
> > http://www.dbdebunk.com/kimball1.htm
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> 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).
> 


*
This  e-mail   message,  and  any  files  transmitted   with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not  necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS  accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. The BGS cannot accept any responsibility  for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

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

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

RE: Elementary question about triggers

[Charu Joshi]

It is meant to be a 'selective' deletion i.e. some rows should be allowed to
delete where as others shouldn't be. Thanks for your replies.

Regards,
Charu.

-Original Message-
Sent: Monday, October 14, 2002 8:30 PM
To: Multiple recipients of list ORACLE-L

Why not just remove delete authority from anyone not authorized to delete
from it ??

-Original Message-
Sent: Monday, October 14, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L

CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW
BEGIN
RAISE_APPLICATION_ERROR(-2,'Do not delete ...');
END;
/

Bala.
-Original Message-
Sent: Monday, October 14, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L

Dear Listers,

I hope you won't mind a question that (I think) looks unfit for this list:

"Can we prevent a delete trigger from deleting a row?"

To make it clear, here's the code for a trigger:

CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW

???

END;

What statement should I write in the PL/SQL block, that will prevent the
deletion of the row.

Thanks & regards,
Charu.

*
Disclaimer

This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message and are hereby notified that
any disclosure, copying, or distribution of this
message, or the taking of any action based on it,
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com

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

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

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

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

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com


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

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

SQL Joins vs Sub Queries vs Cursors

[VIVEK_SHARMA]

Which is best Joins vs. Sub Queries vs. Cursors if all options are possible in a given 
situation? from a performance perspective)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

RE: Double Take and Oracle

[Bishop Lewis]

I'm always dubious of these types of products (especially when there are no
reference sites available) and would opt for a batched up standby database
solution (syncing every 5/10/15 minutes or so) myself. I'm not saying
Double-Take is not good - I've got no experience of it and am sorry it's not
any help but you have an option should Double-Take not work correctly.

Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 08:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--
Hello Esteemed Gurus 
Pls advise... 
We are trying to get Double Take to work on our site. Does anyone actually
have this product working??? 
Salesperson claims Double Take is certified by Oracle - does anyone know?
Where could I find out, other than the company itself?
For those of you who don't know this product pls give your opinion. Double
Take is a software that copies your database files and parameter files etc
across to a disaster recovery machine, bit for bit. At failure of the
production the recovery becomes the production system and starts up the
database. Basicly the datafiles are still open??
We get the following error when we start up the database on the recovery
system in tests: 
ORA-01172: recovery of thread 1 stuck at bloack 176624 of file 2. 
I would just like to add that when this happens we resync the databases and
try again to test and guess what - it is the turn of file 3 to give the
above error, and so back and forth we go.
To say the very least I am frustrated beyond comprihension. To make this
worse there is no one else in South Africa that uses this software with
Oracle, apparently in France. Convienant - I'd say. So I have no one to turn
to about this. (Apparently it works well with MSSQL). Anyone any ideas?
The Enviroment is Windows 2K SP3. 
Oracle 817 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 

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


This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit www.marshalsoftware.com 

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

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

RE: Re[2]: No Nulls? (was: Warehouse design: snowflake vs star s

[Robson, Peter]

Ho Ho Ho - never heard of companies with dead persons on the payroll?

peter


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 14 October 2002 21:49
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: No Nulls? (was: Warehouse design: snowflake vs star s
> 
> 
> I'll agree with Igor.  Actually my 'preferred' option would 
> be to use their
> birth date + 80 years which is the generally accepted life 
> expectancy of a human
> being.  Lets face it, you aren't going to employ the guy/girl 
> after their dead! 
> And if their not dead by then, then sure as heck they'll be retired.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Igor Neyman" <[EMAIL PROTECTED]>
> Date:   10/14/2002 12:14 PM
> 
> RE: No Nulls? (was: Warehouse design: snowflake vs star 
> schemEND_EMPLOYEMENT
> date for still employed employees equals to "01/01/4000" (or any other
> pre-defined date in distant future).
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>   
> 
> 
>   - Original Message - 
>   From: Adams, Matthew (GECP, MABG, 088130) 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Monday, October 14, 2002 3:39 PM
>   Subject: RE: No Nulls? (was: Warehouse design: snowflake vs 
> star schem
> 
> 
>   "No application that I can reasonably think of should 
>   use NULLS, except those pre-81 
>   where there are obsolete columns." 
> 
>   Everytime somebody says this to me, I ask them: 
> 
>   How do you handle still employed employees in an EMPLOYEE table 
>   that contains a END_EMPLOYEMENT date column? 
> 
>   What's your take? 
>    
>   Matt Adams - GE Appliances - [EMAIL PROTECTED] 
>   Write a poem about a haircut! But lofty, noble, tragic, 
> full of love, 
>   treachery, retribution, quiet heroism in the face of certain doom! 
>   Six lines, cleverly rhymed, and every word beginning with 
> the letter s! 
> 
>   -Original Message- 
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
>   Sent: Monday, October 14, 2002 2:29 PM 
>   To: Multiple recipients of list ORACLE-L 
>   Subject: Re:No Nulls? (was: Warehouse design: snowflake vs 
> star schem 
> 
> 
> 
>   Jesse, 
> 
>   I'll refrain from personal comments, but on CJ's quote, 
> he's correct. 
> Nulls 
>   are an oddity.  They cannot be true or false ( 
> = NULL or 
>!= NULL), nor can they equal anything.  They 
> are in effect a
> third 
>   logical state of nothingness.  You also have to code most 
> applications with 
>   indicator variables to check for their existence.  All in 
> all a real pain in
> the 
>   backside.  BUT, if you give me the possibility that nulls 
> exist in the data I 
>   much prefer using them vs. many a third party solution of a 
> single space.  No 
>   application that I can reasonably think of should use 
> NULLS, except those
> pre-81 
>   where there are obsolete columns. 
> 
>   Dick Goulet 
> 
>   Reply Separator 
>   Author: "Jesse; Rich" <[EMAIL PROTECTED]> 
>   Date:   10/14/2002 9:33 AM 
> 
>   On the link below is this quote from C.J.Date: 
> 
>   "I don't want you to think that my SQL solution to your 
> problem means I 
>   advocate the use of nulls.  Nulls are a disaster." 
> 
>   Of course, he doesn't expound upon it (probably not a need 
> except for 
>   dummies like me).  Anyone care to comment?  (On the quote, 
> not on my 
>   dumminess...) 
> 
> 
> 
>   Rich 
> 
> 
> 
>   Rich Jesse   System/Database Administrator 
>   [EMAIL PROTECTED]  Quad/Tech 
> International, Sussex, WI USA 
> 
>   > -Original Message- 
>   > From: Robson, Peter [mailto:[EMAIL PROTECTED]] 
>   > Sent: Monday, October 14, 2002 4:59 AM 
>   > To: Multiple recipients of list ORACLE-L 
>   > Subject: RE: Warehouse design: snowflake vs star schemas 
>   > 
>   > 
>   > Just for the record (and perhaps to confirm that there are 
>   > always two sides 
>   > to a story). Readers may like to see the article Chris Date 
>   > wrote to Ralph 
>   > Kemball on the subject of business rules and integrity 
> constraints: 
>   > 
>   > http://www.dbdebunk.com/kimball1.htm 
>   -- 
>   Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>   -- 
>   Author: Jesse, Rich 
> INET: [EMAIL PROTECTED] 
> 
>   Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
>   San Diego, California-- Mailing list and web 
> hosting services 
>   
> - 
>   To REMOVE yourself from this mailing list, send an E-Mail message 
>   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
>   the message BODY, include a line containing: UNSUB ORACLE-L 
>   (or the name of mailing list you want to be removed from).  You may 
>   also send the HELP command for other information (like 
> subscribing). 
>   -- 
>   Please see the official ORACLE-L FAQ: http://www

RE: Oracle9i upgrade exam - Recommended books/material? (Borderin

[Bishop Lewis]

Thanks Robert... I must admit that I did see the 9i upgrade books appear
earlier that they used to - I remember waiting quite a while for the 8i
upgrade books to come out.

Thanks for the response...
 
Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 

-Original Message-
Sent: 14 October 2002 19:08
To: Multiple recipients of list ORACLE-L
(Borderin

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

>> Didn't cover all of the 9i upgrade material? Why not? 

Because the we wanted to get the book out as quickly as possible to the
Oracle community so they could start using the more important 9i New
Features ASAP. We were trying to be a first strike new features book (as
evidenced by the availability of the book some 3 months before Daniel's). 
The idea was to get fokls up to speed on the more important new features of
9i. In fact, as I recall, when I started writing the book, the 9i Upgrade
Exam wasn't yet available, but became available during the writing process.
I actually wanted to do the 9i Upgrade Exam cram for them, but they had
already contracted it out, and they agreed that this book was a good idea. 
RF




Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Monday, October 14, 2002 5:29 AM
To: Multiple recipients of list ORACLE-L
(Borderin


Didn't cover all of the 9i upgrade material? Why not? As one who is soon to
purchase some 9i upgrade preparation materials then I would be interested to
know the reasoning behind this (offline if necessary).

Are the missed topics from Robert's book covered in the book by Daniel
Benjamin?

Thanks,

Lewis Bishop
Oracle Database Consultant
Open Plan Technical Support
Tel: 020 8298 4498
Email: [EMAIL PROTECTED]

-Original Message-
Sent: 11 October 2002 21:09
To: Multiple recipients of list ORACLE-L
(Borderin

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Actually there were some specific reasons we *didn't* cover all the OCP
stuff in that book.
It's a long story

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Friday, October 11, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
(Borderin


Excellent idea but try to cover more for OCP candidates for 10i upgrade..

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 11 Oct 2002 07:53:42 -0800

Thanks a bunch! I'm Looking forward to 10i!!

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.

 



-Original Message-
Sent: Thursday, October 10, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L
(Borderin


Robert,

If you don't mind , both books are good as I passed my 9i upgarde with the
help of both books and I shall give credit to you and Daniel for writing
these books.  However, yours was the first one which I bought sometime in
Jan'2002 and his book was released end March, 2002.

Thanks again for your excellent effort. Now will wait for your book on Rman
as you already given the url for that.

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 10 Oct 2002 10:28:16 -0800

Thanks Dennis! I'm sitting here dying because one of my stereo headphone
speakers i do ng t is t m ri gt n w.

ARRRUUU.

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.

 



-Original Message-
Sent: Friday, September 13, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L


Kieran - I haven't read it because I am still working out the 8i OCP tests,
but here is a link to a book by Robert Freeman, who participates on this
list. It has been recommended by other list members in the past

RE: No Nulls? (was: Warehouse design: snowflake vs star schem

[Robson, Peter]

Yes - the right answer. And can be validated with a little basic
normalisation.


peter
edinburgh

> 
> 
> Thinking about Matt's question, would it be "proper" to move 
> the column to a
> EMP_TERMINATED table with an outer join on EMPNO?  There 
> wouldn’t be any
> NULLs...
> 
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> 
> -Original Message-
> Sent: Monday, October 14, 2002 4:53 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Both would likely do FTS since at any given time more than 
> 50% of your employees will be current (have an end date
> of 1/1/4000' making it very unlikely that the cbo would choose
> this index.  The RBO, would, but it would likely degrade 
> not improve your performance.  
> 
> John
> 
> Grabowy, Chris wrote:
> 
> Hmmm...but what about the index?  Which is faster?
>  
> select * from table where END_EMPLOYMENT IS NULL;
>  
> OR
>  
> select * from table where END_EMPLOYMENT = '01/01/4000';
>  
> I like NULL, but I am leaning towards Igor, and others, to 
> agree upon and
> use a default value, or a "business sense" replacement value 
> for NULL.  I
> want to be able to take the awesome advantage of an 
> index...versus FTS?  
>  
> Am I headed in the wrong direction??  Any other thoughts??
> -Original Message-
> Sent: Monday, October 14, 2002 4:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> The problem I see with NO NULLS is that artificial data must 
> be created,
> where the data is truly not known. Whether you deal with 
> NULLs or artificial
> data, you will always have to code accordingly, so it is a 
> wash. Igor's
> example is an good one. When I write an app to access the 
> END_EMPLOYMENT
> date, I must handle a date of '01/01/4000'. Or I can handle the NULL
> condition. As a person who has had to support some very 
> convoluted code, I'd
> rather deal with NULL. What if the employee record contained 
> TERM_CODE? I
> would rather have the value NULL, meaning they have not been 
> terminated
> rather than dealing with hard-coded or lookup values.
> -Original Message-
> Sent: Monday, October 14, 2002 2:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> END_EMPLOYEMENT date for still employed employees equals to 
> "01/01/4000" (or
> any other pre-defined date in distant future).
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>   
> 
> 
> - Original Message - 
> To: Multiple recipients of list ORACLE-L 
> Sent: Monday, October 14, 2002 3:39 PM
> 
> 
> "No application that I can reasonably think of should 
> use NULLS, except those pre-81 
> where there are obsolete columns." 
> Everytime somebody says this to me, I ask them: 
> How do you handle still employed employees in an EMPLOYEE table 
> that contains a END_EMPLOYEMENT date column? 
> What's your take? 
>  
> Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> Write a poem about a haircut! But lofty, noble, tragic, full of love, 
> treachery, retribution, quiet heroism in the face of certain doom! 
> Six lines, cleverly rhymed, and every word beginning with the 
> letter s! 
> -Original Message- 
> Sent: Monday, October 14, 2002 2:29 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> Jesse, 
> I'll refrain from personal comments, but on CJ's quote, 
> he's correct.
> Nulls 
> are an oddity.  They cannot be true or false ( = NULL or > 
> != NULL), nor can they equal anything.  They 
> are in effect a
> third 
> logical state of nothingness.  You also have to code most 
> applications with 
> indicator variables to check for their existence.  All in all 
> a real pain in
> the 
> backside.  BUT, if you give me the possibility that nulls 
> exist in the data
> I 
> much prefer using them vs. many a third party solution of a 
> single space.
> No 
> application that I can reasonably think of should use NULLS, 
> except those
> pre-81 
> where there are obsolete columns. 
> Dick Goulet 
> Reply Separator 
> Author: "Jesse; Rich" <[EMAIL PROTECTED]> 
> Date:   10/14/2002 9:33 AM 
> On the link below is this quote from C.J.Date: 
> "I don't want you to think that my SQL solution to your 
> problem means I 
> advocate the use of nulls.  Nulls are a disaster." 
> Of course, he doesn't expound upon it (probably not a need except for 
> dummies like me).  Anyone care to comment?  (On the quote, not on my 
> dumminess...) 
> 
> 
> Rich 
> 
> 
> Rich Jesse   System/Database Administrator 
> [EMAIL PROTECTED]  Quad/Tech International, Susse
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> 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
> -

RE: SQL Joins vs Sub Queries vs Cursors

[Toepke, Kevin M]

The answer, as always is: it depends. Each situation is different. The only
way to tell is to run all versions of the query each time.

-Original Message-
Sent: Tuesday, October 15, 2002 6:19 AM
To: Multiple recipients of list ORACLE-L



Which is best Joins vs. Sub Queries vs. Cursors if all options are possible
in a given situation? from a performance perspective)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

NO ANALYZE STATS FOR TABLE

[moyam]

Title: Phew ... Finally Migrated




  Hi 
  gurus, 
   
  I 
  have analyzed my table A but I get no stats for the table. What could be the 
  problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE before issuing the 
  ANALYZE TABLE A COMPUTE STATISTICS command.
   
  This 
  table has over 8 million records.
   
   
  Moses 
Ngati

Over Consumption of CPU ?

[VIVEK_SHARMA]

On Moving the Storage Box from a SF6800 machine to SF15000 machine CPU Consumption has 
Shot 
by 25 %

Particulars :-
Number of CPUs on  SF6800 = 24 with 750 MHz Clock Speed
Number of CPUs on SF15000 = 24 with 900 MHz Clock Speed

Both %usr & %sys CPU Utilization components seem to have gone up 

Solaris 8
Oracle 8.1.7.2 (+ Some Stand-Alone 1 Off patches)
Database Size 500 GB
Nature of Application Database = Hybrid (Banking application)
Number of Concurrent User processes = 2500

Qs How may the Following problem be approached towards resolution ?
Qs Is using truss Command to identify the Cause a Good approach ?
Qs Are there any parameters / Switches which may given with the truss Command to get 
the % CPU consumed by the underlying system Calls ? 
Qs Are there any preferred parameters Specific to SF15000 ?

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

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

[Toepke, Kevin M]

Title: Message



Use 
your friendly FBI (function-based indexes)
 
create 
index my_fbi on my_table (
    nvl(end_employment, 
TO_DATE('01-jan-4000'));
 
Then 
the following select will use the index.
select * from table where 
NVL(END_EMPLOYMENT, TO_DATE('01-jan-4000') = 
to_date('01-jan-4000');
 
 
 -Original Message-From: 
Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 
2002 5:11 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: No Nulls? (was: Warehouse design: snowflake vs 
star schem

  Hmmm...but what about the index?  Which is 
  faster?
   
  select * from table where END_EMPLOYMENT IS NULL;
   
  OR
   
  select * from table where END_EMPLOYMENT = 
  '01/01/4000';
   
  I 
  like NULL, but I am leaning towards Igor, and others, to agree upon and use a 
  default value, or a "business sense" replacement value for NULL.  I want 
  to be able to take the awesome advantage of an index...versus FTS?  
  
   
  Am I headed in the wrong direction??  Any other 
  thoughts??
  

-Original Message-From: Fink, Dan 
[mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 4:49 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
No Nulls? (was: Warehouse design: snowflake vs star 
schem
The problem I see with NO NULLS is that artificial data must be 
created, where the data is truly not known. Whether you deal with NULLs or 
artificial data, you will always have to code accordingly, so it is a wash. 
Igor's example is an good one. When I write an app to access the 
END_EMPLOYMENT date, I must handle a date of '01/01/4000'. Or I can handle 
the NULL condition. As a person who has had to support some very convoluted 
code, I'd rather deal with NULL. What if the employee record contained 
TERM_CODE? I would rather have the value NULL, meaning they have not been 
terminated rather than dealing with hard-coded or lookup 
values.

  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 
  2:14 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: No Nulls? (was: Warehouse design: 
  snowflake vs star schem
  END_EMPLOYEMENT date for still employed employees equals 
  to "01/01/4000" (or any other pre-defined date in distant 
  future).
   
  Igor Neyman, OCP DBA[EMAIL PROTECTED]  
  
   
   
  
- Original Message - 
From: 
Adams, Matthew (GECP, MABG, 
088130) 
To: Multiple recipients of list 
ORACLE-L 
Sent: Monday, October 14, 2002 3:39 
PM
Subject: RE: No Nulls? (was: 
Warehouse design: snowflake vs star schem

"No application that I can reasonably think of should 
use NULLS, except those pre-81 where there are obsolete columns." 
Everytime somebody says this to me, I ask them: 

How do you handle still employed employees in an 
EMPLOYEE table that contains a END_EMPLOYEMENT 
date column? 
What's your take?  
Matt Adams - GE Appliances - 
[EMAIL PROTECTED] Write a poem about a 
haircut! But lofty, noble, tragic, full of love, treachery, retribution, quiet heroism in the face of certain 
doom! Six lines, cleverly rhymed, and every word 
beginning with the letter s! 
-Original Message- From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 14, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject: Re:No Nulls? (was: Warehouse design: snowflake vs star 
schem 
Jesse, 
    I'll refrain from personal comments, 
but on CJ's quote, he's correct.  Nulls are 
an oddity.  They cannot be true or false ( = 
NULL or  != NULL), nor can 
they equal anything.  They are in effect a third logical state of nothingness.  You also have to code most 
applications with indicator variables to check 
for their existence.  All in all a real pain in the 
backside.  BUT, if you give me the possibility 
that nulls exist in the data I much prefer using 
them vs. many a third party solution of a single space.  No 
application that I can reasonably think of should use 
NULLS, except those pre-81 where there are 
obsolete columns. 
Dick Goulet 
Reply 
Separator Author: "Jesse; 
Rich" <[EMAIL PROTECTED]> Date:   10/14/2002 9:33 
AM 
On the link below is this quote from C.J.Date: 

"I don't want you to think that my SQL solution to your 
problem means I advocate the use of nulls.  
Nulls are a disaster." 
Of course, he doesn't expound upon it (probably not a 
need except for dummies like me).  Anyone 
c

Re: NO ANALYZE STATS FOR TABLE

[Joe Raube]

How do you know you have no statistics?

What does 

select table_name, num_rows, last_analyzed
from user_tables;

give you?

Also, setting TIMED_STATISTICS and SQL_TRACE has nothing to do with
running ANALYZE TABLE...

-Joe

--- [EMAIL PROTECTED] wrote:
> Hi gurus, 
>  
> I have analyzed my table A but I get no stats for the table. What
> could be
> the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE
> before issuing
> the ANALYZE TABLE A COMPUTE STATISTICS command.
>  
> This table has over 8 million records.
>  
> Moses Ngati


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

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

Data Purging - Approaches

[prem]

Dear List,

We need to remove data from our database everyday, so we are plannning to have a scheduled process for this. But the case is that we cannot simply remove the data. This data has to be made available at a later time if required. So this is the process that we have designed.


The background process would first insert all the required data from the main database to another database.
Now if this successfull, it would be deleted from the main database.
The selection criteria on which the data to be purged is found is a business requirement. It is based on some date, but we cannot partition the data based on the date, otherwise we could have done with paritioning and dropping the partition could have been easily done.
The data in the second database would be archived in a normal sequence
If any user request for the data already purged, the data would be read from the second database and shown to him.


Now the issue, the data that has to be moved or deleted in such a way would mount to more that 10 GB of data, so is this method a good solution. Can anybody suggest a better approach for doing this.


We are using Oracle 9i database, Weblogic Application server and Java client. We have list partitioned our database. 

Any other data purging techniques would be greatly appreciated.

Regards
Prem Chandran N

designer autolayout

[Boivin, Patrice J]

Title: Phew ... Finally Migrated



Is 
there a way to make the autolayout feature produce a concise layout in Designer 
Entity Relationship Diagrammer?
 
Regards,

Patrice Boivin Systems Analyst (Oracle Certified DBA) 
Systems Admin & Operations | Admin. et 
Exploit. des systèmes Technology 
Services    | Services 
technologiques Informatics 
Branch | Direction de 
l'informatique Maritimes Region, 
DFO  | Région des Maritimes, MPO 
E-Mail: [EMAIL PROTECTED] 

RE: NO ANALYZE STATS FOR TABLE

[DENNIS WILLIAMS]

Moses - What were you expecting? ANALYZE will produce nothing at the
terminal, when it completes it just returns the cursor. Try this:
select last_analyzed from user_tables where table_name = 'A';
You should see the date that you performed the analysis. The main reason you
analyze tables is to provide information for the CBO.
Oh, and you don't need to turn on tracing or timed statistics.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L



Hi gurus, 
 
I have analyzed my table A but I get no stats for the table. What could be
the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE before issuing
the ANALYZE TABLE A COMPUTE STATISTICS command.
 
This table has over 8 million records.
 
 
Moses Ngati

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: CodeNotes for Oracle9i...

[Yechiel Adar]

The studies I remember on the subject say that talking while driving put you
in the same risk factor as drunk driving .

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 12:03 PM


> There's always some idiot who wants to rain on the
> parade, so it may as well be me.  I can't remember the
> specifics but a recent test in London showed that
> people on (hands-free) phones in their cars were 'x'%
> more likely to crash ('x' was somewhere like 50%!),
> the test being designed to show that its not the phone
> in your hand, its the fact that you're
> talking/listening that ends up killing you...
>
> I can't begin to imagine the traffic carnage when the
> CD "DBA101: The sensual sultry sounds of Carmichael"
> hits the charts!
>
> Does Rachel really want that kind of responsbility :-)
>
> Cheers
> Connor
>
>  --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > It's a little difficult to see how code samples and
> > illustrations
> > (which I find invaluable) could be translated to
> > audio
> >
> > It's technically copyright infringement (I believe)
> > to translate the
> > books. I don't own the copyright, so I'm not about
> > to call out the
> > lawyers. I am supposed to contact my publisher for
> > permission (never
> > been refused, as it's publicity) when I want to use
> > part of a chapter
> > for an article or presentation.
> >
> > Besides, I have problems concentrating when I listen
> > to books on tape,
> > so I'm not the best person to advocate this!
> >
> >
> > --- Joe Testa <[EMAIL PROTECTED]> wrote:
> > > I would think the authors should read and publish
> > the books in .mp3
> > > format, you can get like 10 hours worth on one cd.
> > >
> > > Rachel how about you start,
> > >
> > > bwahahahahahahaha
> > >
> > >
> > > joe
> > >
> > >
> > > DENNIS WILLIAMS wrote:
> > >
> > > >I have an odd question about these on-line books.
> > Can I
> > > copy-and-paste the
> > > >text?
> > > >   Like many of you, I seem to end up with long
> > commutes (why are
> > > the best
> > > >jobs never in your neighborhood?). I find
> > listening to books on CD
> > > to be a
> > > >better use of time than reading bumper stickers.
> > Nobody ever seems
> > > to issue
> > > >Oracle books on audio. So I got a text-to-voice
> > program, and it
> > > works pretty
> > > >good to create an audio version of a book. But
> > many of these eBooks
> > > >zealously protect their text and prevent you from
> > doing
> > > copy-and-paste on
> > > >the text. Fortunately Oracle makes their books
> > readily available.
> > > Any ideas
> > > >are welcome. And my apologies to the authors on
> > the list that are
> > > going "he
> > > >wants to do WHAT with my book!!".
> > > >Dennis Williams
> > > >DBA
> > > >Lifetouch, Inc.
> > > >[EMAIL PROTECTED]
> > > >
> > > >-Original Message-
> > > >Sent: Thursday, October 10, 2002 7:54 PM
> > > >To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >I believe the Book Safari is changing.  It is
> > supposed
> > > >to be more flexible now.
> > > >
> > > >http://www.oreilly.com/news/new_safari_0902.html
> > > >
> > > >Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >"Grabowy, Chris" <[EMAIL PROTECTED]>
> > > >Sent by: [EMAIL PROTECTED]
> > > > 10/08/2002 01:04 PM
> > > > Please respond to ORACLE-L
> > > >
> > > >
> > > >To: Multiple recipients of list
> > ORACLE-L
> > > <[EMAIL PROTECTED]>
> > > >cc:
> > > >Subject:CodeNotes for Oracle9i...
> > > >
> > > >
> > > >So every few months my Lookout reminder pops up
> > to remind me to
> > > check out
> > > >what new Oracle books have been released.  I
> > stumbled upon a new
> > > book
> > > >called CodeNotes for Oracle9i on Amazon.com, but
> > the interesting
> > > part is
> > > >that it is available in eBook format.  Here's the
> > (probably broken)
> > > >link...
> > > >
> > >
> >
>
>http://www.amazon.com/exec/obidos/tg/detail/-/B6ISCN/qid=1034101493/sr=
1
> > > >-25/ref=sr_1_25/104-5919725-7522346?v=glance
> > > >
> > > >The eBook version is $9.95 and the shipping is
> > free (big grin),
> > > while the
> > > >paperback is $13.97 plus shipping.  Are you
> > comfortable reading an
> > > eBook?
> > > >You decide.
> > > >
> > > >At any rate, I will probably break down and buy
> > the eBook.  Not so
> > > much
> > > >because the book is great (or not) but because I
> > hope to send a
> > > message to
> > > >publishers to publish more books in the eBook
> > format, which is also
> > > why I
> > > >posted this message.
> > > >
> > > >I know that O'Reilly has the Safari Bookshelf
> > website, but I found
> > > it to
> > > >be restrictive and pricey.
> > > >
> > > >BTW, if for some reason you are or will be using
> > .Net, the CodeNotes
> > > eBook
> > > >version is free...
> > > >
> > >
> >
> >http://www.codenotes.com/do/downloads/downloadsNETbook
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --

Re:Double Take and Oracle

[dgoulet]

Humm,  Sounds like the software is correctly named.  My first question would be
is it suppose to work with a database that is open?  Are you possibly forgetting
to put the database in hot backup mode?  First step I would try is copying the
database while it is shutdown.  At least that way one knows it is not Double
Take that is screwing with the files.

Dick Goulet

Reply Separator
Author: Denham Eva <[EMAIL PROTECTED]>
Date:   10/14/2002 11:28 PM

Hello Esteemed Gurus

Pls advise...
We are trying to get Double Take to work on our site. Does anyone actually
have this product working???

Salesperson claims Double Take is certified by Oracle - does anyone know?
Where could I find out, other than the company itself?

For those of you who don't know this product pls give your opinion. Double
Take is a software that copies your database files and parameter files etc
across to a disaster recovery machine, bit for bit. At failure of the
production the recovery becomes the production system and starts up the
database. Basicly the datafiles are still open??
We get the following error when we start up the database on the recovery
system in tests:
ORA-01172: recovery of thread 1 stuck at bloack 176624 of file 2.
I would just like to add that when this happens we resync the databases and
try again to test and guess what - it is the turn of file 3 to give the
above error, and so back and forth we go.
To say the very least I am frustrated beyond comprihension. To make this
worse there is no one else in South Africa that uses this software with
Oracle, apparently in France. Convienant - I'd say. So I have no one to turn
to about this. (Apparently it works well with MSSQL). Anyone any ideas?

The Enviroment is Windows 2K SP3.
Oracle 817

Regards
Denham Eva
Oracle DBA
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity."
Dennis Ritchie.


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

Any views expressed in this message are those of the individual sender, 
except where the message states otherwise and the sender is authorized 
to state them to be the views of any such entity.



_
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal

For more information please visit www.marshalsoftware.com

_






Double Take and Oracle 



Hello Esteemed Gurus


Pls advise...
We are trying to get Double Take to work on our
site. Does anyone actually have this product working???


Salesperson claims Double Take is certified by
Oracle - does anyone know? Where could I find out, other than the company
itself?

For those of you who don't know this product pls
give your opinion. Double Take is a software that copies your database files and
parameter files etc across to a disaster recovery machine, bit for bit. At
failure of the production the recovery becomes the production system and starts
up the database. Basicly the datafiles are still open??

We get the following error when we start up the
database on the recovery system in tests:
ORA-01172: recovery of thread 1 stuck at bloack
176624 of file 2.
I would just like to add that when this happens we
resync the databases and try again to test and guess what - it is the turn of
file 3 to give the above error, and so back and forth we go.

To say the very least I am frustrated beyond
comprihension. To make this worse there is no one else in South Africa that uses
this software with Oracle, apparently in France. Convienant - I'd say. So I have
no one to turn to about this. (Apparently it works well with MSSQL). Anyone any
ideas?

The Enviroment is Windows 2K SP3.
Oracle 817


Regards
Denham Eva
Oracle DBA
"UNIX is basically a
simple operating system, but you have to be a genius to understand the
simplicity."
Dennis Ritchie.






DISCLAIMER 

This message is for the named person's use 
only. It may contain confidential, proprietary or legally privileged 
information. No confidentiality or privilege is waived or lost by any 
mistra

Re:iSeries Production Database

[dgoulet]

RPG, AS400???  Didn't they die along with Cobol and Vax/VMS?

Seriously the choice of platform I believe is more of a business decision than
anything given the applications and associated software that one wants to run
thereon.  Then the use of a language is more predicated on what is available,
usable, and most cost effective for the platform.  Probably why I happen to like
C.  It's almost completely platform and OS independent.

Dick Goulet

Reply Separator
Author: Lyndon Tiu <[EMAIL PROTECTED]>
Date:   10/14/2002 8:58 PM

Hello,

How many people here have RPG - AS400 - iSeries in their shops? Curious 
question: What makes your shop use the IBM iSeries?

Do you use RPG or SQL for your database?

Thank you.

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

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

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

Re:RE: Double Take and Oracle

[dgoulet]

Lewis,

I can understand where Eva is coming from.  I had a demo of a similar
product some time ago.  Their BIG selling point is that you have a production
server and a backup that is close in time with your production server at half
(or less) the cost of a hot standby.  Their reasoning is that you don't have
Oracle running on the standby and consequently don't have to pay Oracle a
license fee for the second server since only one server is running at any point
in time.  Logically their point is well taken.  Regrettably and understandably
that is NOT Oracle's point of view.

Dick Goulet

Reply Separator

Author: Bishop Lewis <[EMAIL PROTECTED]>
Date:   10/15/2002 2:23 AM

I'm always dubious of these types of products (especially when there are no
reference sites available) and would opt for a batched up standby database
solution (syncing every 5/10/15 minutes or so) myself. I'm not saying
Double-Take is not good - I've got no experience of it and am sorry it's not
any help but you have an option should Double-Take not work correctly.

Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 08:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--
Hello Esteemed Gurus 
Pls advise... 
We are trying to get Double Take to work on our site. Does anyone actually
have this product working??? 
Salesperson claims Double Take is certified by Oracle - does anyone know?
Where could I find out, other than the company itself?
For those of you who don't know this product pls give your opinion. Double
Take is a software that copies your database files and parameter files etc
across to a disaster recovery machine, bit for bit. At failure of the
production the recovery becomes the production system and starts up the
database. Basicly the datafiles are still open??
We get the following error when we start up the database on the recovery
system in tests: 
ORA-01172: recovery of thread 1 stuck at bloack 176624 of file 2. 
I would just like to add that when this happens we resync the databases and
try again to test and guess what - it is the turn of file 3 to give the
above error, and so back and forth we go.
To say the very least I am frustrated beyond comprihension. To make this
worse there is no one else in South Africa that uses this software with
Oracle, apparently in France. Convienant - I'd say. So I have no one to turn
to about this. (Apparently it works well with MSSQL). Anyone any ideas?
The Enviroment is Windows 2K SP3. 
Oracle 817 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 

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


This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit www.marshalsoftware.com 

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California 

A little OT, but somewhat relevant

[dgoulet]

To ALL,

The following came in the mail this morning.  I visited the web site
(www.topcoder.com) and find it somewhat odd, but!!!  It could spawn into a lot
of things, like sparing on a database recovery so that your next employer knows
your capable & not just slinging it.

Dick Goulet

PS: Jared, sorry about the OT, but it IS interesting.


---
Code-Jousting For Jobs
A startup that gives software developers the opportunity to test 
their skills against their peers in online competitions is 
launching its own recruiting service.
http://update.informationweek.com/cgi-bin4/flo?y=eJIQ0BdFGA0V20Bj330AH

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Data Purging - Approaches

[DENNIS WILLIAMS]

Prem - Since you seem to just be asking for ideas, the following are some
random thoughts for your consideration.
  - I wouldn't give up on partitioning so easily. I felt stymied by
partitions for several years. I had a table that I needed to partition, but
couldn't figure it out. Finally I made another attempt and was successful.
Now we are getting considerable benefit from partitioning. Frankly, there
aren't a lot of resources that really show you what partitioning is capable
of. The manual examples are rudimentary, to be kindly.
 - 10-gig/day is a daunting amount of data, any way you cut it.
 - Deleting 10-gig of data each day will take a terrific amount of
resources, which points back to partitioning.
 - The best way to move this amount of data will be transportable
tablespaces, hence take another look at partitioning. Also, you will need to
delete this amount of data
  - You could consider Standby Database to move the data.
  - Your next problem is that you will need to delete the same amount of
data from the second database.
  - I am assuming that both databases will run on the same platform type so
transportable tablespaces are a possibility.
  - In the end, I think you will discover that, like most archive/purging
solutions, this one will prove to be more effort and expense than the
benefits provided.
  - Consider whether the second database is okay with more summarized data.
I'm guessing that 10-gig of data represents some pretty detailed data. I
find it hard to believe that you need the same amount of data in both
locations. Surely one side could get by with summarized data, and use the
other system when details are required. This would reduce the processing
burden greatly.


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L



Dear List, 

We need to remove data from our database everyday, so we are plannning to
have a scheduled process for this. But the case is that we cannot simply
remove the data. This data has to be made available at a later time if
required. So this is the process that we have designed. 


1.  The background process would first insert all the required data from
the main database to another database. 

2.  Now if this successfull, it would be deleted from the main database.


3.  The selection criteria on which the data to be purged is found is a
business requirement. It is based on some date, but we cannot partition the
data based on the date, otherwise we could have done with paritioning and
dropping the partition could have been easily done. 

4.  The data in the second database would be archived in a normal
sequence 

5.  If any user request for the data already purged, the data would be
read from the second database and shown to him. 


Now the issue, the data that has to be moved or deleted in such a way would
mount to more that 10 GB of data, so is this method a good solution. Can
anybody suggest a better approach for doing this. 


We are using Oracle 9i database, Weblogic Application server and Java
client. We have list partitioned our database. 

Any other data purging techniques would be greatly appreciated. 

Regards 
Prem Chandran N 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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[2]: No Nulls? (was: Warehouse design: snowflake vs star s

[dgoulet]

Allow me to put one more point into the discussion, that being in my experience
NULLS invite updates.  By that I mean, and I'll borrow from my 'favorite' ERP
application namely PeopleSoft.  
PeopleSoft does not by itself allow NULLS, replacing them with a single space,
but one particular table has a column of type DESC VARCHAR2(255) that gets
initially populated by a PeopleSoft NULL.  This seems to be a panel processor
activity because none of our developers can find out why.  It is subsequently
updated with any number of characters and seeing that PeopleSoft is not too
bright on setting storage parameters, ESPECIALLY pctfree and pctused, we have
99% of the table chained into multiple blocks, even though the average row size
if only 312 bytes!

Therefore, kill the NULL because NULLS invite updates and chaining.

Dick Goulet
Reply Separator
Author: "Marc Perkowitz" <[EMAIL PROTECTED]>
Date:   10/14/2002 2:09 PM

RE: No Nulls? (was: Warehouse design: snowflake vs star schemThis is true.  But
you still need to add logic to your application to suppress displaying the
termination date when it is = "01/01/4000".  I can pretty well guarantee your
users will not like seeing a "dummy" date on their reports and screens.

And in this case, you cannot use sysdate, as they will want to see if someone is
scheduled for termination in the near future, say for one of the too frequent
layoffs that are happening these days.  

You will also need to protect against someone inputting this value or a higher
value as that will complicate things.

The point is that using defaults or dummy values is not a pain-free alternative
to nulls.  If you do use these, be sure to be consistent and, as usual, document
these.  Probably a good approach, if you use PL/SQL, is to create a
package-level variable that can be used globally.  That way you can avoid using
hard-coded values.  You could also use this approach with languages that are
using embedded SQL or ODBC/JDBC.  Alternatively, you could use a construct
within the language like Java's final static constants.

Marc Perkowitz
  - Original Message - 
  From: Igor Neyman 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, October 14, 2002 4:10 PM
  Subject: Re: No Nulls? (was: Warehouse design: snowflake vs star schem


  Actually, you don't have to deal with "01/01/4000" date (at least on
"select"), all you have to do in order find currently employed employees, is:

  where END_EMPLOYMENT > sysdate

  as for inserts, all you have to do, is define "01/01/4000" as a default value
for END_EMPLOYMENT,
  also, not allowing NULLs, makes it easier for indexing.

  Igor Neyman, OCP DBA
  [EMAIL PROTECTED]



- Original Message - 
From: Fink, Dan 
To: Multiple recipients of list ORACLE-L 
Sent: Monday, October 14, 2002 4:49 PM
Subject: RE: No Nulls? (was: Warehouse design: snowflake vs star schem


The problem I see with NO NULLS is that artificial data must be created,
where the data is truly not known. Whether you deal with NULLs or artificial
data, you will always have to code accordingly, so it is a wash. Igor's example
is an good one. When I write an app to access the END_EMPLOYMENT date, I must
handle a date of '01/01/4000'. Or I can handle the NULL condition. As a person
who has had to support some very convoluted code, I'd rather deal with NULL.
What if the employee record contained TERM_CODE? I would rather have the value
NULL, meaning they have not been terminated rather than dealing with hard-coded
or lookup values.
  -Original Message-
  From: Igor Neyman [mailto:[EMAIL PROTECTED]]
  Sent: Monday, October 14, 2002 2:14 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: No Nulls? (was: Warehouse design: snowflake vs star schem


  END_EMPLOYEMENT date for still employed employees equals to "01/01/4000"
(or any other pre-defined date in distant future).

  Igor Neyman, OCP DBA
  [EMAIL PROTECTED]



- Original Message - 
From: Adams, Matthew (GECP, MABG, 088130) 
To: Multiple recipients of list ORACLE-L 
Sent: Monday, October 14, 2002 3:39 PM
Subject: RE: No Nulls? (was: Warehouse design: snowflake vs star schem


"No application that I can reasonably think of should 
use NULLS, except those pre-81 
where there are obsolete columns." 

Everytime somebody says this to me, I ask them: 

How do you handle still employed employees in an EMPLOYEE table 
that contains a END_EMPLOYEMENT date column? 

What's your take? 
 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
Write a poem about a haircut! But lofty, noble, tragic, full of love, 
treachery, retribution, quiet heroism in the face of certain doom! 
Six lines, cleverly rhymed, and every word beginning with the letter s! 

Re: SQL Joins vs Sub Queries vs Cursors

[paquette stephane]

Usually sub-queries are not the fastest way to do
things. 
When a developper is talking about doing things using
cursors the big red light flashes : ho ho 3gl thinking
ahead !

The only way to know for sure is to test them. Do not
just check the elapsed time. I've tested 2 scenarios
once and they were taking the same time but one was
having twice the buffer gets than the other one.

 --- VIVEK_SHARMA <[EMAIL PROTECTED]> a écrit :
> 
> Which is best Joins vs. Sub Queries vs. Cursors if
> all options are possible in a given situation? from
> a performance perspective)
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: VIVEK_SHARMA
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

RE: Double Take and Oracle

[DENNIS WILLIAMS]

Denham - I searched Oracle's site and could find no mention of Double Take.
My guess is that they work successfully with SQL Server, but that has a
different architecture that lends itself to being backed up without it being
aware of it. I hope you haven't mailed that check yet.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 2:28 AM
To: Multiple recipients of list ORACLE-L



Hello Esteemed Gurus 

Pls advise... 
We are trying to get Double Take to work on our site. Does anyone actually
have this product working??? 

Salesperson claims Double Take is certified by Oracle - does anyone know?
Where could I find out, other than the company itself?

For those of you who don't know this product pls give your opinion. Double
Take is a software that copies your database files and parameter files etc
across to a disaster recovery machine, bit for bit. At failure of the
production the recovery becomes the production system and starts up the
database. Basicly the datafiles are still open??

We get the following error when we start up the database on the recovery
system in tests: 
ORA-01172: recovery of thread 1 stuck at bloack 176624 of file 2. 
I would just like to add that when this happens we resync the databases and
try again to test and guess what - it is the turn of file 3 to give the
above error, and so back and forth we go.

To say the very least I am frustrated beyond comprihension. To make this
worse there is no one else in South Africa that uses this software with
Oracle, apparently in France. Convienant - I'd say. So I have no one to turn
to about this. (Apparently it works well with MSSQL). Anyone any ideas?

The Enviroment is Windows 2K SP3. 
Oracle 817 

Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 



  _  

DISCLAIMER 



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

Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity. 

  _  




  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
 www.marshalsoftware.com 
  _  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: NO ANALYZE STATS FOR TABLE

[moyam]

I don't get any results when I run the query provided. I have done this but
all I get are results for other tables otherthan table A. The analyze has
gone on for 24 hours.

-Original Message-
Sent: Tuesday, October 15, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L


Moses - What were you expecting? ANALYZE will produce nothing at the
terminal, when it completes it just returns the cursor. Try this:
select last_analyzed from user_tables where table_name = 'A';
You should see the date that you performed the analysis. The main reason you
analyze tables is to provide information for the CBO.
Oh, and you don't need to turn on tracing or timed statistics.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L



Hi gurus, 
 
I have analyzed my table A but I get no stats for the table. What could be
the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE before issuing
the ANALYZE TABLE A COMPUTE STATISTICS command.
 
This table has over 8 million records.
 
 
Moses Ngati

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
--
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: DW setup

[Yechiel Adar]

Forgive me for asking, but if you have enough CPU for all why do you need
control?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 12:03 AM


Thats what we are planning on doing here with our data warehouse.
Unfortunately, your CPU's have to be at 100% for resource manager
to become effective. I'd like to be able to have a bit more control
over sessions than that.

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.





-Original Message-
Sent: Monday, October 14, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L


Rich - Good point! I haven't used Oracle Resource Manager, but in theory it
should be able to do a better job of implementing priorities than the
operating system can.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, October 14, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


Why seperate instances?  Why not seperate schemas in the same instance?


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L



Hello,

BACKGROUND:
We've been planning a 300GB datawarehouse architecture for Oracle 9.2 on
Solaris, and have proposed the following:
1) 2 separate instances of Oracle 9.2,
   - Instance A will be the staging instance, all ETL processing will
 take place here
   - Instance B will be the query instance, all reporting activity will
 take place here
2) Once data has been transformed, copy the tablespace metadata from
   Instance A to Instance B using transportable tablespaces feature
3) The physical datafiles will be fast-copied from Instance A to Instance B
   using a vendor feature called Checkpoints (not Oracle's definition of
checkpoints).

Point 3 needs further explanation: both of these instances will be connected
to
Network Attached Storage (NAS) from a vendor named Procom. They have a
feature
called Checkpoints, which quickly creates a read-only copy of a data volume
(I believe this is similar to network appliance's snapshot feature, and EMC
also
has something like this, but the name escapes me). Checkpoints are very fast
to
create, and can result in a read-only copy of 200GB of data in 1 - 2
minutes.
At present, we use them for backup purposes only, and they work well.

Instance A, the staging instance, will use the read-write Oracle datafiles
located on the procom read-write volumes. Instance B, the query instance,
will use datafiles located on a read-only procom volume, which also happens
to
be the checkpoint volume of the read-write volume used by Instance A. The
checkpoint volume will be refreshed daily, from the staging volume, when the
daily ETL stream has completed. The query instance datafiles will be dropped
and re-created daily via the procom checkpoint, and the tablespace metadata
will be plugged in using transportable tablespaces.

We have verified that Oracle works OK using plugged-in read only tablespaces
located on a procom read-only checkpoint volume.

QUESTIONS:

 (too much to hope for)
1) Is anyone else out there using this type of configuration with procom?
   If so, how well does this work? Any comments, problems?

 (more realistic)
2) Is anyone else out there using a similar configuration with a comparable
   vendor feature like checkpoints? Any performance problems? Any comments,
problems?

 (more desperate)
3) Is anyone running a large Oracle data warehouse using primarily read-only

   tablespaces? Any comments, problems? How do you refresh them?

 (last resort)
4) Does anyone care to comment on the above configuration? good idea...bad
idea?

Thanks

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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.com
--
Author: Gesler, 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 mes

Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

[Yechiel Adar]

Title: Message



An update:
 
We finished the creation of the database in the morning in 
time for business day.
 
We found that the file system was performing at about 
30-50% efficiency.
On Sunday we moved the database to a new server and all is 
OK.
 
Now we are starting to prepare new server so we can return 
to replication.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Yechiel 
  Adar 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, October 10, 2002 11:53 
  PM
  Subject: Re: ora-01115 after datafile 
  autoexetend from 3.9 GB to 4.1 GB
  
  Thanks for all the replies.
   
  We called Oracle support and they come with the DUL 
  utility and
  extracted the data.
   
  As I write this e-mail imports are 
  running.
   
  Concurrently we tried to restore the last full 
  backup from more then 2 weeks ago\
  and found about 1 day worth of archive logs missing, so 
  this option is out.
   
  We now also restoring last night export to a separate 
  database so in case
  of logical errors in the imported data they will be able 
  to input the deals again
  and bring the system up to date.
   
  So now, eleven hours later we hope to finish in a few 
  hours.
   
  Yechiel AdarMehish

Re:iSeries Production Database

[Lyndon Tiu]

It is shocking to note that a lot of big shops use AS400 and RPG still.
650,000 units are in use IBM claims. It just boggles me why. Keeping legacy code
alive perhaps since it's too expensive to migrate.

As for languages, Java is platform independent too. Actually, every language
except VB is platform independent.

On Tue, 15 Oct 2002, [EMAIL PROTECTED] wrote:
> RPG, AS400???  Didn't they die along with Cobol and Vax/VMS?
> 
> Seriously the choice of platform I believe is more of a business decision than
> anything given the applications and associated software that one wants to run
> thereon.  Then the use of a language is more predicated on what is available,
> usable, and most cost effective for the platform.  Probably why I happen to like
> C.  It's almost completely platform and OS independent.
> 
> Dick Goulet
> 
> Reply Separator
> Subject:iSeries Production Database
> Author: Lyndon Tiu <[EMAIL PROTECTED]>
> Date:   10/14/2002 8:58 PM
> 
> Hello,
> 
> How many people here have RPG - AS400 - iSeries in their shops? Curious 
> question: What makes your shop use the IBM iSeries?
> 
> Do you use RPG or SQL for your database?
> 
> Thank you.
> 
> --
> Lyndon Tiu
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Lyndon Tiu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]

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

Re:RE: Re[2]: No Nulls? (was: Warehouse design: snowflake vs

[dgoulet]

See logical, isn't it!!  *-)

Dick Goulet

Reply Separator
Author: "Robson; Peter" <[EMAIL PROTECTED]>
Date:   10/15/2002 2:43 AM

Ho Ho Ho - never heard of companies with dead persons on the payroll?

peter


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 14 October 2002 21:49
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: No Nulls? (was: Warehouse design: snowflake vs star s
> 
> 
> I'll agree with Igor.  Actually my 'preferred' option would 
> be to use their
> birth date + 80 years which is the generally accepted life 
> expectancy of a human
> being.  Lets face it, you aren't going to employ the guy/girl 
> after their dead! 
> And if their not dead by then, then sure as heck they'll be retired.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Igor Neyman" <[EMAIL PROTECTED]>
> Date:   10/14/2002 12:14 PM
> 
> RE: No Nulls? (was: Warehouse design: snowflake vs star 
> schemEND_EMPLOYEMENT
> date for still employed employees equals to "01/01/4000" (or any other
> pre-defined date in distant future).
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>   
> 
> 
>   - Original Message - 
>   From: Adams, Matthew (GECP, MABG, 088130) 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Monday, October 14, 2002 3:39 PM
>   Subject: RE: No Nulls? (was: Warehouse design: snowflake vs 
> star schem
> 
> 
>   "No application that I can reasonably think of should 
>   use NULLS, except those pre-81 
>   where there are obsolete columns." 
> 
>   Everytime somebody says this to me, I ask them: 
> 
>   How do you handle still employed employees in an EMPLOYEE table 
>   that contains a END_EMPLOYEMENT date column? 
> 
>   What's your take? 
>    
>   Matt Adams - GE Appliances - [EMAIL PROTECTED] 
>   Write a poem about a haircut! But lofty, noble, tragic, 
> full of love, 
>   treachery, retribution, quiet heroism in the face of certain doom! 
>   Six lines, cleverly rhymed, and every word beginning with 
> the letter s! 
> 
>   -Original Message- 
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
>   Sent: Monday, October 14, 2002 2:29 PM 
>   To: Multiple recipients of list ORACLE-L 
>   Subject: Re:No Nulls? (was: Warehouse design: snowflake vs 
> star schem 
> 
> 
> 
>   Jesse, 
> 
>   I'll refrain from personal comments, but on CJ's quote, 
> he's correct. 
> Nulls 
>   are an oddity.  They cannot be true or false ( 
> = NULL or 
>!= NULL), nor can they equal anything.  They 
> are in effect a
> third 
>   logical state of nothingness.  You also have to code most 
> applications with 
>   indicator variables to check for their existence.  All in 
> all a real pain in
> the 
>   backside.  BUT, if you give me the possibility that nulls 
> exist in the data I 
>   much prefer using them vs. many a third party solution of a 
> single space.  No 
>   application that I can reasonably think of should use 
> NULLS, except those
> pre-81 
>   where there are obsolete columns. 
> 
>   Dick Goulet 
> 
>   Reply Separator 
>   Author: "Jesse; Rich" <[EMAIL PROTECTED]> 
>   Date:   10/14/2002 9:33 AM 
> 
>   On the link below is this quote from C.J.Date: 
> 
>   "I don't want you to think that my SQL solution to your 
> problem means I 
>   advocate the use of nulls.  Nulls are a disaster." 
> 
>   Of course, he doesn't expound upon it (probably not a need 
> except for 
>   dummies like me).  Anyone care to comment?  (On the quote, 
> not on my 
>   dumminess...) 
> 
> 
> 
>   Rich 
> 
> 
> 
>   Rich Jesse   System/Database Administrator 
>   [EMAIL PROTECTED]  Quad/Tech 
> International, Sussex, WI USA 
> 
>   > -Original Message- 
>   > From: Robson, Peter [mailto:[EMAIL PROTECTED]] 
>   > Sent: Monday, October 14, 2002 4:59 AM 
>   > To: Multiple recipients of list ORACLE-L 
>   > Subject: RE: Warehouse design: snowflake vs star schemas 
>   > 
>   > 
>   > Just for the record (and perhaps to confirm that there are 
>   > always two sides 
>   > to a story). Readers may like to see the article Chris Date 
>   > wrote to Ralph 
>   > Kemball on the subject of business rules and integrity 
> constraints: 
>   > 
>   > http://www.dbdebunk.com/kimball1.htm 
>   -- 
>   Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>   -- 
>   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 yo

RE: RE: Re[2]: No Nulls? (was: Warehouse design: snowflake vs

[Toepke, Kevin M]

I was once a consultant on a large Payroll project and ran into a case where
someone had entered a date of death 1 year in advance (something like
8/17/1999 instead of 8/17/1998). I found it in the middle of November.
Because of this, the person was still getting paid. I sent email to payroll,
HR and my manager questioning this "planned death"! Shortly thereafter I
left the project for about 3 months and when I came back the data hadn't
been changed!

-Original Message-
Sent: Tuesday, October 15, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


See logical, isn't it!!  *-)

Dick Goulet

Reply Separator
Author: "Robson; Peter" <[EMAIL PROTECTED]>
Date:   10/15/2002 2:43 AM

Ho Ho Ho - never heard of companies with dead persons on the payroll?

peter


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 14 October 2002 21:49
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: No Nulls? (was: Warehouse design: snowflake vs star s
> 
> 
> I'll agree with Igor.  Actually my 'preferred' option would 
> be to use their
> birth date + 80 years which is the generally accepted life 
> expectancy of a human
> being.  Lets face it, you aren't going to employ the guy/girl 
> after their dead! 
> And if their not dead by then, then sure as heck they'll be retired.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Igor Neyman" <[EMAIL PROTECTED]>
> Date:   10/14/2002 12:14 PM
> 
> RE: No Nulls? (was: Warehouse design: snowflake vs star 
> schemEND_EMPLOYEMENT
> date for still employed employees equals to "01/01/4000" (or any other
> pre-defined date in distant future).
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>   
> 
> 
>   - Original Message - 
>   From: Adams, Matthew (GECP, MABG, 088130) 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Monday, October 14, 2002 3:39 PM
>   Subject: RE: No Nulls? (was: Warehouse design: snowflake vs 
> star schem
> 
> 
>   "No application that I can reasonably think of should 
>   use NULLS, except those pre-81 
>   where there are obsolete columns." 
> 
>   Everytime somebody says this to me, I ask them: 
> 
>   How do you handle still employed employees in an EMPLOYEE table 
>   that contains a END_EMPLOYEMENT date column? 
> 
>   What's your take? 
>    
>   Matt Adams - GE Appliances - [EMAIL PROTECTED] 
>   Write a poem about a haircut! But lofty, noble, tragic, 
> full of love, 
>   treachery, retribution, quiet heroism in the face of certain doom! 
>   Six lines, cleverly rhymed, and every word beginning with 
> the letter s! 
> 
>   -Original Message- 
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
>   Sent: Monday, October 14, 2002 2:29 PM 
>   To: Multiple recipients of list ORACLE-L 
>   Subject: Re:No Nulls? (was: Warehouse design: snowflake vs 
> star schem 
> 
> 
> 
>   Jesse, 
> 
>   I'll refrain from personal comments, but on CJ's quote, 
> he's correct. 
> Nulls 
>   are an oddity.  They cannot be true or false ( 
> = NULL or 
>!= NULL), nor can they equal anything.  They 
> are in effect a
> third 
>   logical state of nothingness.  You also have to code most 
> applications with 
>   indicator variables to check for their existence.  All in 
> all a real pain in
> the 
>   backside.  BUT, if you give me the possibility that nulls 
> exist in the data I 
>   much prefer using them vs. many a third party solution of a 
> single space.  No 
>   application that I can reasonably think of should use 
> NULLS, except those
> pre-81 
>   where there are obsolete columns. 
> 
>   Dick Goulet 
> 
>   Reply Separator 
>   Author: "Jesse; Rich" <[EMAIL PROTECTED]> 
>   Date:   10/14/2002 9:33 AM 
> 
>   On the link below is this quote from C.J.Date: 
> 
>   "I don't want you to think that my SQL solution to your 
> problem means I 
>   advocate the use of nulls.  Nulls are a disaster." 
> 
>   Of course, he doesn't expound upon it (probably not a need 
> except for 
>   dummies like me).  Anyone care to comment?  (On the quote, 
> not on my 
>   dumminess...) 
> 
> 
> 
>   Rich 
> 
> 
> 
>   Rich Jesse   System/Database Administrator 
>   [EMAIL PROTECTED]  Quad/Tech 
> International, Sussex, WI USA 
> 
>   > -Original Message- 
>   > From: Robson, Peter [mailto:[EMAIL PROTECTED]] 
>   > Sent: Monday, October 14, 2002 4:59 AM 
>   > To: Multiple recipients of list ORACLE-L 
>   > Subject: RE: Warehouse design: snowflake vs star schemas 
>   > 
>   > 
>   > Just for the record (and perhaps to confirm that there are 
>   > always two sides 
>   > to a story). Readers may like to see the article Chris Date 
>   > wrote to Ralph 
>   > Kemball on the subject of business rules and integrity 
> constraints: 
>   > 
>   > http://www.dbdebunk.com/kimball1.htm 
>   -- 
>   Please see the official ORACLE-

RE: A little OT, but somewhat relevant

[DENNIS WILLIAMS]

Dick - Isn't that what the new Masters Practicum Exam for Oracle all about?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L


To ALL,

The following came in the mail this morning.  I visited the web site
(www.topcoder.com) and find it somewhat odd, but!!!  It could spawn into a
lot
of things, like sparing on a database recovery so that your next employer
knows
your capable & not just slinging it.

Dick Goulet

PS: Jared, sorry about the OT, but it IS interesting.



---
Code-Jousting For Jobs
A startup that gives software developers the opportunity to test 
their skills against their peers in online competitions is 
launching its own recruiting service.
http://update.informationweek.com/cgi-bin4/flo?y=eJIQ0BdFGA0V20Bj330AH

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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: No Nulls? (was: Warehouse design: snowflake vs

[Ora NT DBA]

Sounds like they needed a business rule, enforced by a constraint saying
the date of death
must be less than or equal to sysdate :-).

John

Toepke, Kevin M wrote:

  I was once a consultant on a large Payroll project and ran into a case where
someone had entered a date of death 1 year in advance (something like
8/17/1999 instead of 8/17/1998). I found it in the middle of November.
Because of this, the person was still getting paid. I sent email to payroll,
HR and my manager questioning this "planned death"! Shortly thereafter I
left the project for about 3 months and when I came back the data hadn't
been changed!

-Original Message-
Sent: Tuesday, October 15, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


See logical, isn't it!!  *-)

Dick Goulet

Reply Separator
Author: "Robson; Peter" <[EMAIL PROTECTED]>
Date:   10/15/2002 2:43 AM

Ho Ho Ho - never heard of companies with dead persons on the payroll?

peter


  
  
-Original Message-
Sent: 14 October 2002 21:49
To: Multiple recipients of list ORACLE-L


I'll agree with Igor.  Actually my 'preferred' option would 
be to use their
birth date + 80 years which is the generally accepted life 
expectancy of a human
being.  Lets face it, you aren't going to employ the guy/girl 
after their dead! 
And if their not dead by then, then sure as heck they'll be retired.

Dick Goulet

Reply Separator
Author: "Igor Neyman" <[EMAIL PROTECTED]>
Date:   10/14/2002 12:14 PM

RE: No Nulls? (was: Warehouse design: snowflake vs star 
schemEND_EMPLOYEMENT
date for still employed employees equals to "01/01/4000" (or any other
pre-defined date in distant future).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  


  - Original Message - 
  From: Adams, Matthew (GECP, MABG, 088130) 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, October 14, 2002 3:39 PM
  Subject: RE: No Nulls? (was: Warehouse design: snowflake vs 
star schem


  "No application that I can reasonably think of should 
  use NULLS, except those pre-81 
  where there are obsolete columns." 

  Everytime somebody says this to me, I ask them: 

  How do you handle still employed employees in an EMPLOYEE table 
  that contains a END_EMPLOYEMENT date column? 

  What's your take? 
   
  Matt Adams - GE Appliances - [EMAIL PROTECTED] 
  Write a poem about a haircut! But lofty, noble, tragic, 
full of love, 
  treachery, retribution, quiet heroism in the face of certain doom! 
  Six lines, cleverly rhymed, and every word beginning with 
the letter s! 

  -Original Message- 
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, October 14, 2002 2:29 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: Re:No Nulls? (was: Warehouse design: snowflake vs 
star schem 



  Jesse, 

  I'll refrain from personal comments, but on CJ's quote, 
he's correct. 
Nulls 
  are an oddity.  They cannot be true or false ( 
= NULL or 
   != NULL), nor can they equal anything.  They 
are in effect a
third 
  logical state of nothingness.  You also have to code most 
applications with 
  indicator variables to check for their existence.  All in 
all a real pain in
the 
  backside.  BUT, if you give me the possibility that nulls 
exist in the data I 
  much prefer using them vs. many a third party solution of a 
single space.  No 
  application that I can reasonably think of should use 
NULLS, except those
pre-81 
  where there are obsolete columns. 

  Dick Goulet 

  Reply Separator 
  Author: "Jesse; Rich" <[EMAIL PROTECTED]> 
  Date:   10/14/2002 9:33 AM 

  On the link below is this quote from C.J.Date: 

  "I don't want you to think that my SQL solution to your 
problem means I 
  advocate the use of nulls.  Nulls are a disaster." 

  Of course, he doesn't expound upon it (probably not a need 
except for 
  dummies like me).  Anyone care to comment?  (On the quote, 
not on my 
  dumminess...) 



  Rich 



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

  > -Original Message- 
  > From: Robson, Peter [mailto:[EMAIL PROTECTED]] 
  > Sent: Monday, October 14, 2002 4:59 AM 
  > To: Multiple recipients of list ORACLE-L 
  > Subject: RE: Warehouse design: snowflake vs star schemas 
  > 
  > 
  > Just for the record (and perhaps to confirm that there are 
  > always two sides 
  > to a story). Readers may like to see the article Chris Date 
  > wrote to Ralph 
  > Kemball on the subject of business rules and integrity 
constraints: 
  > 
  > http://www.dbdebunk.com/kimball1.htm 
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- 
  Author: Jesse, Rich 
INET: [EMAIL PROTECTED] 

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

RE: CodeNotes for Oracle9i...

[Jesse, Rich]

Thank Goodness.  Now I can go back to that 4-pak of Guinness on my 25-mile
drive to work.  Whew!  THAT'll make the day go easier.

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
http://society.servebeer.com

Disclaimer:  As President of The Beer Ale Lager Lovers Society, I'd like to 
remind everyone that...oh, you know the schpeel -- don't be stupid.

> -Original Message-
> From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 8:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: CodeNotes for Oracle9i...
> 
> 
> The studies I remember on the subject say that talking while 
> driving put you
> in the same risk factor as drunk driving .
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: RE: Double Take and Oracle

[Denham Eva]

Title: RE: RE: Double Take and Oracle





Thanks for the input so far. Double-Take works real time so the database is never down.
I also followed their setup direction to the letter. Problem on our site is that this product is being used for SQL Server and Exchange (Appears to work fine there, but Oracle is a beast of another color compared to these "Access on Steroids" databases), management are insisting for the sake of conformity that this must work. At ever attempted startup another file gives an error, most frustrating of all is that there is almost no consistency to the errors.

Denham Eva 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Double Take and Oracle



Lewis,


    I can understand where Eva is coming from.  I had a demo of a similar
product some time ago.  Their BIG selling point is that you have a production
server and a backup that is close in time with your production server at half
(or less) the cost of a hot standby.  Their reasoning is that you don't have
Oracle running on the standby and consequently don't have to pay Oracle a
license fee for the second server since only one server is running at any point
in time.  Logically their point is well taken.  Regrettably and understandably
that is NOT Oracle's point of view.


Dick Goulet


Reply Separator


Author: Bishop Lewis <[EMAIL PROTECTED]>
Date:   10/15/2002 2:23 AM


I'm always dubious of these types of products (especially when there are no
reference sites available) and would opt for a batched up standby database
solution (syncing every 5/10/15 minutes or so) myself. I'm not saying
Double-Take is not good - I've got no experience of it and am sorry it's not
any help but you have an option should Double-Take not work correctly.


Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 08:28
To: Multiple recipients of list ORACLE-L


This header confirms that this email message has been swept for the
presence of computer viruses. 


Corporate IT
THE WOOLWICH
--
Hello Esteemed Gurus 
Pls advise... 
We are trying to get Double Take to work on our site. Does anyone actually
have this product working??? 
Salesperson claims Double Take is certified by Oracle - does anyone know?
Where could I find out, other than the company itself?
For those of you who don't know this product pls give your opinion. Double
Take is a software that copies your database files and parameter files etc
across to a disaster recovery machine, bit for bit. At failure of the
production the recovery becomes the production system and starts up the
database. Basicly the datafiles are still open??
We get the following error when we start up the database on the recovery
system in tests: 
ORA-01172: recovery of thread 1 stuck at bloack 176624 of file 2. 
I would just like to add that when this happens we resync the databases and
try again to test and guess what - it is the turn of file 3 to give the
above error, and so back and forth we go.
To say the very least I am frustrated beyond comprihension. To make this
worse there is no one else in South Africa that uses this software with
Oracle, apparently in France. Convienant - I'd say. So I have no one to turn
to about this. (Apparently it works well with MSSQL). Anyone any ideas?
The Enviroment is Windows 2K SP3. 
Oracle 817 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 


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



This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit www.marshalsoftware.com 


-- 
Please see the officia

SET ORACLE-L NOMAIL

[Brigitte . Tuerk]

Title: SET ORACLE-L NOMAIL





SET ORACLE-L NOMAIL


Mit freundlichen Grüßen,


Brigitte Türk
KAUFHOF WARENHAUS AG
IT-Controlling Datenbankadm.
Leonhard-Tietz-Str. 1
D-50676 Köln
Tel.:+49 (0)221 223-21 88
eMail: [EMAIL PROTECTED]

RE: NO ANALYZE STATS FOR TABLE

[Hemant K Chitale]

You will see statistics only after the ANALYZE is completed.
8 million records certainly shouldn't take 24hours, though.

Try doing an ANALYZE with a SAMPLE or ESTIMATE.  Better, use DBMS_STATS.

At 06:49 AM 15-10-02 -0800, you wrote:
>I don't get any results when I run the query provided. I have done this but
>all I get are results for other tables otherthan table A. The analyze has
>gone on for 24 hours.
>
>-Original Message-
>Sent: Tuesday, October 15, 2002 4:39 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Moses - What were you expecting? ANALYZE will produce nothing at the
>terminal, when it completes it just returns the cursor. Try this:
> select last_analyzed from user_tables where table_name = 'A';
>You should see the date that you performed the analysis. The main reason you
>analyze tables is to provide information for the CBO.
>Oh, and you don't need to turn on tracing or timed statistics.
>
>
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>-Original Message-
>Sent: Tuesday, October 15, 2002 7:19 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Hi gurus,
>
>I have analyzed my table A but I get no stats for the table. What could be
>the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE before issuing
>the ANALYZE TABLE A COMPUTE STATISTICS command.
>
>This table has over 8 million records.
>
>
>Moses Ngati
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>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.com
>--
>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).

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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

RE: CodeNotes for Oracle9i... Destress on the way home!...OT

[Fink, Dan]

I almost used that one.

The real problem is finding celebrities with the following last names:
Niemiec
Velpuri
Testa
Kolk
Vaidyanatha

-Original Message-
Sent: Monday, October 14, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L


Hoagy Carmichael reads DBA 101 by Rachel Carmichael?


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> We could put together a whole Namesakes series about Oracle stuff...
> Morgan Freeman reads Oracle 9i New Features by Robert Freeman
> Patch Adams reads Oracle8i Internal Services by Steve Adams
> 
> Apologies to Spinal Tap for the distorted idea...
> 
> -Original Message-
> Sent: Monday, October 14, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> I also have a driving commute, and I was also thinking about asking
> her
> to voice record her book.  But I think I would get into an accident
> hearing her sexy voice describing how to recover a database...:P :)
> :P
> :)
> 
> -Original Message-
> Sent: Monday, October 14, 2002 5:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> John - Wow! An impressive memory tour de force! 
>My problem is that I am driving during my commute. You get the
> strangest looks when the next driver glances over and sees your face
> buried in a PDA. Actually that last phrase might become prophetic. I
> was
> just asking if there was a way to get a talking e-book. For example,
> you
> can download just about any book whose copyright has expired, copy,
> paste into my text-to-voice, and there you have an audio version.
> I'll
> be long dead before the copyrights on any books about Oracle expire.
> Most e-book publishers protect their material as zealously as the
> Secret
> Service protects the president. Which often renders them unusable for
> any purpose.
>Personally, I liked the suggestion to ask the noted authors on
> this
> list to read their books just like the fiction superstars do.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Monday, October 14, 2002 4:11 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> See below is an email conversation that I had with the 'Goddess' in
> 2000
> on the same subject. Those were the days when Goddesses had to sleep
> and
> de-stress on their way home
> 
> (Ducking as the Goddess takes out her six-shooter magic wand)
> 
> John
> 
> Reply from Rachel:
> ==
> Geek! 
> 
> The concept you are thinking of exists in some form already --
> e-books.
> PDA
> 
> sized computer that you can download a book into.
> 
> Destressing is important -- but more so is the nap I took on the
> train
> on my
> 
> way home tonight!
> 
> Rachel
> 
> 
> >From: <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: RE: Using your commute time
> >Date: Fri, 3 Mar 2000 08:41:26 +0800
> >
> > > I use the time to talk to the people I know on the train, or to 
> > > read. Fiction or otherwise. Others have their laptops, I see them
> 
> > > working with > them. Or they read the newspapers, or sleep.
> >
> >Granted, but the difference as against a push-technology such as a 
> >Radio station (which many people listen to while commuting) is that 
> >this is a pull-technology, i.e. optional availability. However, I do
> 
> >conceed to the need to decompress/destress/plan/communicate with 
> >others, energize, etc.
> >
> > > I think technical books need visual interfaces. For diagrams,
> tables
> >etc.
> >
> >Which brings me to my next brain-wave (or sizzled-brain-wave :) - 
> >Computers have drastically reduced in size while increasing in
> capacity
> 
> >and capability. However, the restraining factor has been (and will
> be) 
> >the size of the Input/Output area (i.e. Screen/Keyboard size) which 
> >cannot reduce below a threshold. What if someone discovers how to
> use a
> 
> >hologram to perform the same input/output? These hologram enabled
> PDA 
> >and Web based 'appliances' can shrink to the size of a plastic 
> >'smart-card'! Just project everything onto a virtual screen which
> can 
> >be virtually touched and pointed to, etc!! You could probably have
> your
> 
> >personal (private) view using special glasses if required. I
> wouldn't 
> >rule out something like this being made available within the next 
> >decade...
> >
> >So far, I have only talked about the tech side of things here -
> there 
> >are many dangers and negative side effects to the personal and
> societal
> 
> >aspects. More of that later!
> >
> >Slightly crazy today, aren't I?
> >John
> ><< WINMAIL.DAT >>
> 
> > 
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> 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 m

RE: NO ANALYZE STATS FOR TABLE

[DENNIS WILLIAMS]

Moses - Ah, another clue. Yes, no results provided until the analyze
completes. Your problem isn't getting results, but getting the analyze to
complete. Analyze also sorts  the data, so your TEMP file is probably
getting hit like crazy also. Kill that command. Try again with ANALYZE TABLE
A ESTIMATE STATISTICS. 
   There is no reason to analyze each and every row in an 8 million row
table. Just take a sample. Read the documentation on ANALYZE and decide what
type of sample is appropriate for your table. Personally, I favor analyze a
fixed number of rows, having studied statistics in the past. The best would
be to do a baseline analysis, note the statistics reported and how long it
took to complete. Then increase the estimate, note the new statistics and
the completion time. After a few tries, you'll notice the statistics aren't
changing much. You will decide the best cost/benefit tradeoff between number
of rows and the results obtained. 
   On a smaller table, you can perform this experiment in reverse, first
doing a complete analysis, then comparing the results with varying sizes of
estimates.
   Also, depending on your Oracle version, check out DBMS_STATS. Oracle is
now focusing its efforts on that package.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L


I don't get any results when I run the query provided. I have done this but
all I get are results for other tables otherthan table A. The analyze has
gone on for 24 hours.

-Original Message-
Sent: Tuesday, October 15, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L


Moses - What were you expecting? ANALYZE will produce nothing at the
terminal, when it completes it just returns the cursor. Try this:
select last_analyzed from user_tables where table_name = 'A';
You should see the date that you performed the analysis. The main reason you
analyze tables is to provide information for the CBO.
Oh, and you don't need to turn on tracing or timed statistics.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L



Hi gurus, 
 
I have analyzed my table A but I get no stats for the table. What could be
the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE before issuing
the ANALYZE TABLE A COMPUTE STATISTICS command.
 
This table has over 8 million records.
 
 
Moses Ngati

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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.com
-- 
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: How to fix ORA-03113 error

[Nguyen, David M]

I have oracle8.0.5 running on Solaris8.  Here's trace file.  I don't think
there is problem with I/O.  How do I recover this error?


$more ssdb_lgwr_272.trc

Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /export/home/oracle/product/8.0.5
System name:SunOS
Node name:  plab1
Release:5.8
Version:Generic_108528-03
Machine:sun4u
Instance name: SSDB
Redo thread mounted by this instance: 1
Oracle process number: 4
Unix process pid: 272, image: ora_lgwr_SSDB

*** SESSION ID:(3.1) 2002.10.13.02.19.02.000
error 204 detected in background process



-Original Message-
Sent: Monday, October 14, 2002 7:58 PM
To: Multiple recipients of list ORACLE-L


Your instance crashed because the lgwr died...  There should be a trace file
for lgwr in the bdump directory...  What does it say in the trace file?  Are
you having any filesystem issues?  The "LGWR: terminating instance due to
error 204" means that there is an I/O error when accessing the
controlfile...  What version is your database...  What O/S are you on...
etc...  There seems to be some known bugs in this area...  Check
Note:1069812.6 on Metalink...

Tim

-Original Message-
Sent: Monday, October 14, 2002 8:19 PM
To: Multiple recipients of list ORACLE-L


I could not start database due to ORA-03113 error, someone please advise
what it means and how to fix it ASAP.  I really appreciate your help.

Thanks,
David



SVRMGR> startup  
ORACLE instance started. 
Total System Global Area285236752 bytes  
Fixed Size  48656 bytes  
Variable Size75390976 bytes  
Database Buffers209715200 bytes  
Redo Buffers81920 bytes  
Database mounted.
ORA-03113: end-of-file on communication channel


***Alert.log:

Mon Oct 14 17:57:27 2002
Database mounted in Exclusive Mode. 
Completed: alter database  mount
Mon Oct 14 17:57:27 2002
alter database open 
Picked broadcast on commit scheme to generate SCNs  
Mon Oct 14 17:57:27 2002
Rolling back half complete log switch of thread 1   
LGWR: terminating instance due to error 204 
Instance terminated by LGWR, pid = 483  

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

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

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

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

Re:RE: A little OT, but somewhat relevant

[dgoulet]

Dennis,

To a degree, but it isn't done as a sporting event over the internet.  These
guys/gals connect to the web site in what they call a stadium.  Their all given
the same problem at the same time & then have to code their answers.  Not sure
what the criteria of judgement are.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   10/15/2002 6:58 AM

Dick - Isn't that what the new Masters Practicum Exam for Oracle all about?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L


To ALL,

The following came in the mail this morning.  I visited the web site
(www.topcoder.com) and find it somewhat odd, but!!!  It could spawn into a
lot
of things, like sparing on a database recovery so that your next employer
knows
your capable & not just slinging it.

Dick Goulet

PS: Jared, sorry about the OT, but it IS interesting.



---
Code-Jousting For Jobs
A startup that gives software developers the opportunity to test 
their skills against their peers in online competitions is 
launching its own recruiting service.
http://update.informationweek.com/cgi-bin4/flo?y=eJIQ0BdFGA0V20Bj330AH

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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.com
-- 
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: CodeNotes for Oracle9i... Destress on the way home!...OT

[Weaver, Walt]

"_Oracle 8i Backup And Recovery_, a Rendezvous With Rama"

--Walt Weaver

(Not exactly a namesake, but the best I could do)

-Original Message-
Sent: Tuesday, October 15, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L


I almost used that one.

The real problem is finding celebrities with the following last names:
Niemiec
Velpuri
Testa
Kolk
Vaidyanatha

-Original Message-
Sent: Monday, October 14, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L


Hoagy Carmichael reads DBA 101 by Rachel Carmichael?


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> We could put together a whole Namesakes series about Oracle stuff...
> Morgan Freeman reads Oracle 9i New Features by Robert Freeman
> Patch Adams reads Oracle8i Internal Services by Steve Adams
> 
> Apologies to Spinal Tap for the distorted idea...
> 
> -Original Message-
> Sent: Monday, October 14, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> I also have a driving commute, and I was also thinking about asking
> her
> to voice record her book.  But I think I would get into an accident
> hearing her sexy voice describing how to recover a database...:P :)
> :P
> :)
> 
> -Original Message-
> Sent: Monday, October 14, 2002 5:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> John - Wow! An impressive memory tour de force! 
>My problem is that I am driving during my commute. You get the
> strangest looks when the next driver glances over and sees your face
> buried in a PDA. Actually that last phrase might become prophetic. I
> was
> just asking if there was a way to get a talking e-book. For example,
> you
> can download just about any book whose copyright has expired, copy,
> paste into my text-to-voice, and there you have an audio version.
> I'll
> be long dead before the copyrights on any books about Oracle expire.
> Most e-book publishers protect their material as zealously as the
> Secret
> Service protects the president. Which often renders them unusable for
> any purpose.
>Personally, I liked the suggestion to ask the noted authors on
> this
> list to read their books just like the fiction superstars do.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Monday, October 14, 2002 4:11 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> See below is an email conversation that I had with the 'Goddess' in
> 2000
> on the same subject. Those were the days when Goddesses had to sleep
> and
> de-stress on their way home
> 
> (Ducking as the Goddess takes out her six-shooter magic wand)
> 
> John
> 
> Reply from Rachel:
> ==
> Geek! 
> 
> The concept you are thinking of exists in some form already --
> e-books.
> PDA
> 
> sized computer that you can download a book into.
> 
> Destressing is important -- but more so is the nap I took on the
> train
> on my
> 
> way home tonight!
> 
> Rachel
> 
> 
> >From: <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: RE: Using your commute time
> >Date: Fri, 3 Mar 2000 08:41:26 +0800
> >
> > > I use the time to talk to the people I know on the train, or to 
> > > read. Fiction or otherwise. Others have their laptops, I see them
> 
> > > working with > them. Or they read the newspapers, or sleep.
> >
> >Granted, but the difference as against a push-technology such as a 
> >Radio station (which many people listen to while commuting) is that 
> >this is a pull-technology, i.e. optional availability. However, I do
> 
> >conceed to the need to decompress/destress/plan/communicate with 
> >others, energize, etc.
> >
> > > I think technical books need visual interfaces. For diagrams,
> tables
> >etc.
> >
> >Which brings me to my next brain-wave (or sizzled-brain-wave :) - 
> >Computers have drastically reduced in size while increasing in
> capacity
> 
> >and capability. However, the restraining factor has been (and will
> be) 
> >the size of the Input/Output area (i.e. Screen/Keyboard size) which 
> >cannot reduce below a threshold. What if someone discovers how to
> use a
> 
> >hologram to perform the same input/output? These hologram enabled
> PDA 
> >and Web based 'appliances' can shrink to the size of a plastic 
> >'smart-card'! Just project everything onto a virtual screen which
> can 
> >be virtually touched and pointed to, etc!! You could probably have
> your
> 
> >personal (private) view using special glasses if required. I
> wouldn't 
> >rule out something like this being made available within the next 
> >decade...
> >
> >So far, I have only talked about the tech side of things here -
> there 
> >are many dangers and negative side effects to the personal and
> societal
> 
> >aspects. More of that later!
> >
> >Slightly crazy today, aren't I?
> >John
> ><< WINMAIL.DAT >>
> 
> > 
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-53

RE: to_char(sysdate) problem on 8.1.7.

[Johnston, Tim]

17182 is a heap corruption issue...  Is this only occurring on one box?  Are
you having any OS memory issues?  I'd open an iTar and work through it with
support...

-Original Message-
Sent: Tuesday, October 15, 2002 5:03 AM
To: Multiple recipients of list ORACLE-L


hi!

8.1.7. on WIN:

due to a bug - it seems - the following query returns an error:

SQL> SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual;
SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual
 *
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [538241312], [], [],
[],
[], [], []

while it works fine on 8.0.5. and 8.1.6.!

does anyone know a way to change the query, so it will work on all
version and there is no need for a patch?


tia & regards
daniel
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

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

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

Codifying keys

[Muru]

Hi Oracle Gurus,

Is there a difference in terms of performance or any
in using alpha numeric codes for employee codes such
as EM1 rather than just 1? Please note that
this is the key of the table. I am using Oracle9i.

Any input is hightly appreciated.

Thanks,
Muru

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muru
  INET: [EMAIL PROTECTED]

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

RE: SET ORACLE-L NOMAIL

[Farnsworth, Dave]

Title: SET ORACLE-L NOMAIL



HILFE

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 2002 
  10:34 AMTo: Multiple recipients of list ORACLE-LSubject: 
  SET ORACLE-L NOMAIL
  SET ORACLE-L NOMAIL 
  Mit freundlichen Grüßen, 
  Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 
  Köln Tel.:+49 (0)221 223-21 88 
  eMail: [EMAIL PROTECTED] 

RE: How to fix ORA-03113 error

[Johnston, Tim]

Did you read Note:1069812.6 on Metalink yet?

Tim

-Original Message-
Sent: Tuesday, October 15, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


I have oracle8.0.5 running on Solaris8.  Here's trace file.  I don't think
there is problem with I/O.  How do I recover this error?


$more ssdb_lgwr_272.trc

Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /export/home/oracle/product/8.0.5
System name:SunOS
Node name:  plab1
Release:5.8
Version:Generic_108528-03
Machine:sun4u
Instance name: SSDB
Redo thread mounted by this instance: 1
Oracle process number: 4
Unix process pid: 272, image: ora_lgwr_SSDB

*** SESSION ID:(3.1) 2002.10.13.02.19.02.000
error 204 detected in background process



-Original Message-
Sent: Monday, October 14, 2002 7:58 PM
To: Multiple recipients of list ORACLE-L


Your instance crashed because the lgwr died...  There should be a trace file
for lgwr in the bdump directory...  What does it say in the trace file?  Are
you having any filesystem issues?  The "LGWR: terminating instance due to
error 204" means that there is an I/O error when accessing the
controlfile...  What version is your database...  What O/S are you on...
etc...  There seems to be some known bugs in this area...  Check
Note:1069812.6 on Metalink...

Tim

-Original Message-
Sent: Monday, October 14, 2002 8:19 PM
To: Multiple recipients of list ORACLE-L


I could not start database due to ORA-03113 error, someone please advise
what it means and how to fix it ASAP.  I really appreciate your help.

Thanks,
David



SVRMGR> startup  
ORACLE instance started. 
Total System Global Area285236752 bytes  
Fixed Size  48656 bytes  
Variable Size75390976 bytes  
Database Buffers209715200 bytes  
Redo Buffers81920 bytes  
Database mounted.
ORA-03113: end-of-file on communication channel


***Alert.log:

Mon Oct 14 17:57:27 2002
Database mounted in Exclusive Mode. 
Completed: alter database  mount
Mon Oct 14 17:57:27 2002
alter database open 
Picked broadcast on commit scheme to generate SCNs  
Mon Oct 14 17:57:27 2002
Rolling back half complete log switch of thread 1   
LGWR: terminating instance due to error 204 
Instance terminated by LGWR, pid = 483  

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

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

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

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

RE: RE: Double Take and Oracle

[Bishop Lewis]

Eva - just checking - from their docs have you verified that the
transactional applications option is selected on the optimisations screen?
This seems the most likely omission - and are you also sure that you are
including all necessary files in the selected copy?

Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 16:09
To: Multiple recipients of list ORACLE-L

Thanks for the input so far. Double-Take works real time so the database is
never down. 
I also followed their setup direction to the letter. Problem on our site is
that this product is being used for SQL Server and Exchange (Appears to work
fine there, but Oracle is a beast of another color compared to these "Access
on Steroids" databases), management are insisting for the sake of conformity
that this must work. At ever attempted startup another file gives an error,
most frustrating of all is that there is almost no consistency to the
errors.
Denham Eva 
-Original Message- 
Sent: Tuesday, October 15, 2002 4:04 PM 
To: Multiple recipients of list ORACLE-L 

Lewis, 
    I can understand where Eva is coming from.  I had a demo of a similar 
product some time ago.  Their BIG selling point is that you have a
production 
server and a backup that is close in time with your production server at
half 
(or less) the cost of a hot standby.  Their reasoning is that you don't have

Oracle running on the standby and consequently don't have to pay Oracle a 
license fee for the second server since only one server is running at any
point 
in time.  Logically their point is well taken.  Regrettably and
understandably 
that is NOT Oracle's point of view. 
Dick Goulet 

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

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

RE: SET ORACLE-L NOMAIL

[Nastase, Mr. C. (Catalin)]

Title: SET ORACLE-L NOMAIL



Sind 
Sie ein Idiot?

  -Message 
  d'origine-De: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Date: mardi 15 octobre 2002 
  18:20À: Multiple recipients of list ORACLE-LObjet: RE: 
  SET ORACLE-L NOMAIL
  HILFE
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 2002 
10:34 AMTo: Multiple recipients of list 
ORACLE-LSubject: SET ORACLE-L NOMAIL
SET ORACLE-L NOMAIL 
Mit freundlichen Grüßen, 
Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 
223-21 88 eMail: [EMAIL PROTECTED] 

RE: SET ORACLE-L NOMAIL

[Mercadante, Thomas F]

Title: SET ORACLE-L NOMAIL




Sind 
Sie und Idiot? 
 

  -Original Message-From: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 
  2002 12:20 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: SET ORACLE-L NOMAIL
  HILFE
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 2002 
10:34 AMTo: Multiple recipients of list 
ORACLE-LSubject: SET ORACLE-L NOMAIL
SET ORACLE-L NOMAIL 
Mit freundlichen Grüßen, 
Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 
223-21 88 eMail: [EMAIL PROTECTED] 

DW Setup

[becker . bill]

Thanks for the response, Don. RichG. also wondered why 2 instances.
I should have included the fact these will be running on 2 different
platforms as well. Apologies for the omission. Actually, I didn't include
that fact because the hardware is still under discussion; we're talking
to Sun about one machine that allows separate domains, each with its 
dedicated CPUs and memory, vs two separate machines. We are aware of the
network issues, and the network folks are considering multiple channels.
Procom is an Oracle-approved vendor, although I would have preferred a
more popular vendor like Network Appliance or EMC, but that was
management's decision ($$):

http://otn.oracle.com/deploy/availability/htdocs/vendors_nfs.html

Assuming the machine resources will be adequate, how does this setup sound?

*** Original message by [EMAIL PROTECTED]
Bill,

Why use two instances?  If you believe that the second instance can be
protected against performance degradation during ETL processing your wrong. 
Both instances will be looking for the same resources (CPU & memory) and worse
if your using net attached storage, they will end up competing for the same
network card.  OUCH!!!  If you really want this type of setup, use two servers
to shield one from the other.  Otherwise use a single instance of Oracle which
also gets away from having to have multiple copies of the data.

Procom is not, I believe, an Oracle approved net app vendor, so beware when
there's a problem.  OTS may not be inclined to help you.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   10/14/2002 9:48 AM


Hello,

BACKGROUND:
We've been planning a 300GB datawarehouse architecture for Oracle 9.2 on
Solaris, and have proposed the following:
1) 2 separate instances of Oracle 9.2,
   - Instance A will be the staging instance, all ETL processing will
 take place here
   - Instance B will be the query instance, all reporting activity will
 take place here
2) Once data has been transformed, copy the tablespace metadata from 
   Instance A to Instance B using transportable tablespaces feature
3) The physical datafiles will be fast-copied from Instance A to Instance B
   using a vendor feature called Checkpoints (not Oracle's definition of
checkpoints).

Point 3 needs further explanation: both of these instances will be connected to
Network Attached Storage (NAS) from a vendor named Procom. They have a feature
called Checkpoints, which quickly creates a read-only copy of a data volume
(I believe this is similar to network appliance's snapshot feature, and EMC also
has something like this, but the name escapes me). Checkpoints are very fast to
create, and can result in a read-only copy of 200GB of data in 1 - 2 minutes.
At present, we use them for backup purposes only, and they work well.

Instance A, the staging instance, will use the read-write Oracle datafiles
located on the procom read-write volumes. Instance B, the query instance,
will use datafiles located on a read-only procom volume, which also happens to
be the checkpoint volume of the read-write volume used by Instance A. The
checkpoint volume will be refreshed daily, from the staging volume, when the
daily ETL stream has completed. The query instance datafiles will be dropped
and re-created daily via the procom checkpoint, and the tablespace metadata 
will be plugged in using transportable tablespaces.

We have verified that Oracle works OK using plugged-in read only tablespaces
located on a procom read-only checkpoint volume.

QUESTIONS:

 (too much to hope for)
1) Is anyone else out there using this type of configuration with procom?
   If so, how well does this work? Any comments, problems?

 (more realistic)
2) Is anyone else out there using a similar configuration with a comparable
   vendor feature like checkpoints? Any performance problems? Any comments,
problems?

 (more desperate)
3) Is anyone running a large Oracle data warehouse using primarily read-only 
   tablespaces? Any comments, problems? How do you refresh them?

 (last resort)
4) Does anyone care to comment on the above configuration? good idea...bad idea?

Thanks



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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[2]:iSeries Production Database

[dgoulet]

One should take the numbers the sales droids preach with a shovel full of salt. 
I remember MicroSlop claiming that they had more than a million copies of
SQL*Server in use not too many years ago.  Seems that what they were counting is
the number of installs, which came with NT 3.51 advanced server whether you
wanted it or not. It was therefore an overly inflated number that was
meaningless.  It would be like them calling Outlook the only used mail package
on the Windows platform just because they bundle it in.  In IBM's case how many
of these units have been retired to the third party market & are consequently no
longer in use or have been migrated to another OS??  Just because someone bought
it does not mean they are using it.

Dick Goulet

Reply Separator
Author: Lyndon Tiu <[EMAIL PROTECTED]>
Date:   10/15/2002 6:28 AM

It is shocking to note that a lot of big shops use AS400 and RPG still.
650,000 units are in use IBM claims. It just boggles me why. Keeping legacy code
alive perhaps since it's too expensive to migrate.

As for languages, Java is platform independent too. Actually, every language
except VB is platform independent.

On Tue, 15 Oct 2002, [EMAIL PROTECTED] wrote:
> RPG, AS400???  Didn't they die along with Cobol and Vax/VMS?
> 
> Seriously the choice of platform I believe is more of a business decision than
> anything given the applications and associated software that one wants to run
> thereon.  Then the use of a language is more predicated on what is available,
> usable, and most cost effective for the platform.  Probably why I happen to
like
> C.  It's almost completely platform and OS independent.
> 
> Dick Goulet
> 
> Reply Separator
> Subject:iSeries Production Database
> Author: Lyndon Tiu <[EMAIL PROTECTED]>
> Date:   10/14/2002 8:58 PM
> 
> Hello,
> 
> How many people here have RPG - AS400 - iSeries in their shops? Curious 
> question: What makes your shop use the IBM iSeries?
> 
> Do you use RPG or SQL for your database?
> 
> Thank you.
> 
> --
> Lyndon Tiu
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Lyndon Tiu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]

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

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

Re:RE: RE: Double Take and Oracle

[dgoulet]

Eva,

First things first, Oracle gets to be a bear when your trying to move a
database as you are while it's running.  The first point to settle is that
Double Take is not doing something that is incompatible with Oracle, like making
an ASCII vs. BINARY copy of the datafiles.  To determine that you need to do a
move with the source/production database shutdown.  Yeah, I know that can be
hard to schedule but it's necessary.  If the copy won't start at that point then
Double Take is completely incompatible with Oracle and you can't go much
further.  Now if that passes, allow Double Take to copy the production DB to the
backup server and while it's doing so check the hotbackup status of the database
using the following:

SELECT COUNT(*)
FROM DBA_DATA_FILES DF, SYS.V_$BACKUP B
WHERE FILE_ID = FILE#
AND DF.STATUS = 'AVAILABLE'
AND B.STATUS = 'ACTIVE';

The number you get back should equal the number of datafiles in your database. 
If it comes back as 0 then the database has not switched and the backup is
worthless.  You may have to do this manually before running Double Take.  Also
your production/source DB has to be in archive log mode or else hotbackup does
not work.

The reasons for this are wrapped around Oracle's "write as little as needed and
do so as seldomly as possible" idea.  With this idea data block changes are not
sent to the datafiles until there is a need to.  MicroSlop and Exchange work on
the exact opposite idea which makes them IO hogs, although Oracle can be the
same.  In your case I would suspect that the hotbackup is the problem.

Dick Goulet

Reply Separator
Author: Denham Eva <[EMAIL PROTECTED]>
Date:   10/15/2002 7:08 AM

Thanks for the input so far. Double-Take works real time so the database is
never down.
I also followed their setup direction to the letter. Problem on our site is
that this product is being used for SQL Server and Exchange (Appears to work
fine there, but Oracle is a beast of another color compared to these "Access
on Steroids" databases), management are insisting for the sake of conformity
that this must work. At ever attempted startup another file gives an error,
most frustrating of all is that there is almost no consistency to the
errors.

Denham Eva 

-Original Message-
Sent: Tuesday, October 15, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Lewis,

I can understand where Eva is coming from.  I had a demo of a similar
product some time ago.  Their BIG selling point is that you have a
production
server and a backup that is close in time with your production server at
half
(or less) the cost of a hot standby.  Their reasoning is that you don't have
Oracle running on the standby and consequently don't have to pay Oracle a
license fee for the second server since only one server is running at any
point
in time.  Logically their point is well taken.  Regrettably and
understandably
that is NOT Oracle's point of view.

Dick Goulet

Reply Separator

Author: Bishop Lewis <[EMAIL PROTECTED]>
Date:   10/15/2002 2:23 AM

I'm always dubious of these types of products (especially when there are no
reference sites available) and would opt for a batched up standby database
solution (syncing every 5/10/15 minutes or so) myself. I'm not saying
Double-Take is not good - I've got no experience of it and am sorry it's not
any help but you have an option should Double-Take not work correctly.

Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 08:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--
Hello Esteemed Gurus 
Pls advise... 
We are trying to get Double Take to work on our site. Does anyone actually
have this product working??? 
Salesperson claims Double Take is certified by Oracle - does anyone know?
Where could I find out, other than the company itself?
For those of you who don't know this product pls give your opinion. Double
Take is a software that copies your database files and parameter files etc
across to a disaster recovery machine, bit for bit. At failure of the
production the recovery becomes the production system and starts up the
database. Basicly the datafiles are still open??
We get the following error when we start up the database on the recovery
system in tests: 
ORA-01172: recovery of thread 1 stuck at bloack 176624 of file 2. 
I would just like to add that when this happens we resync the databases and
try again t

RE: CodeNotes for Oracle9i... Destress on the way home!...OT

[Johnston, Tim]

And don't forget Still!

-Original Message-
Sent: Tuesday, October 15, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


I almost used that one.

The real problem is finding celebrities with the following last names:
Niemiec
Velpuri
Testa
Kolk
Vaidyanatha

-Original Message-
Sent: Monday, October 14, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L


Hoagy Carmichael reads DBA 101 by Rachel Carmichael?


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> We could put together a whole Namesakes series about Oracle stuff...
> Morgan Freeman reads Oracle 9i New Features by Robert Freeman
> Patch Adams reads Oracle8i Internal Services by Steve Adams
> 
> Apologies to Spinal Tap for the distorted idea...
> 
> -Original Message-
> Sent: Monday, October 14, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> I also have a driving commute, and I was also thinking about asking
> her
> to voice record her book.  But I think I would get into an accident
> hearing her sexy voice describing how to recover a database...:P :)
> :P
> :)
> 
> -Original Message-
> Sent: Monday, October 14, 2002 5:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> John - Wow! An impressive memory tour de force! 
>My problem is that I am driving during my commute. You get the
> strangest looks when the next driver glances over and sees your face
> buried in a PDA. Actually that last phrase might become prophetic. I
> was
> just asking if there was a way to get a talking e-book. For example,
> you
> can download just about any book whose copyright has expired, copy,
> paste into my text-to-voice, and there you have an audio version.
> I'll
> be long dead before the copyrights on any books about Oracle expire.
> Most e-book publishers protect their material as zealously as the
> Secret
> Service protects the president. Which often renders them unusable for
> any purpose.
>Personally, I liked the suggestion to ask the noted authors on
> this
> list to read their books just like the fiction superstars do.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Monday, October 14, 2002 4:11 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> See below is an email conversation that I had with the 'Goddess' in
> 2000
> on the same subject. Those were the days when Goddesses had to sleep
> and
> de-stress on their way home
> 
> (Ducking as the Goddess takes out her six-shooter magic wand)
> 
> John
> 
> Reply from Rachel:
> ==
> Geek! 
> 
> The concept you are thinking of exists in some form already --
> e-books.
> PDA
> 
> sized computer that you can download a book into.
> 
> Destressing is important -- but more so is the nap I took on the
> train
> on my
> 
> way home tonight!
> 
> Rachel
> 
> 
> >From: <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: RE: Using your commute time
> >Date: Fri, 3 Mar 2000 08:41:26 +0800
> >
> > > I use the time to talk to the people I know on the train, or to 
> > > read. Fiction or otherwise. Others have their laptops, I see them
> 
> > > working with > them. Or they read the newspapers, or sleep.
> >
> >Granted, but the difference as against a push-technology such as a 
> >Radio station (which many people listen to while commuting) is that 
> >this is a pull-technology, i.e. optional availability. However, I do
> 
> >conceed to the need to decompress/destress/plan/communicate with 
> >others, energize, etc.
> >
> > > I think technical books need visual interfaces. For diagrams,
> tables
> >etc.
> >
> >Which brings me to my next brain-wave (or sizzled-brain-wave :) - 
> >Computers have drastically reduced in size while increasing in
> capacity
> 
> >and capability. However, the restraining factor has been (and will
> be) 
> >the size of the Input/Output area (i.e. Screen/Keyboard size) which 
> >cannot reduce below a threshold. What if someone discovers how to
> use a
> 
> >hologram to perform the same input/output? These hologram enabled
> PDA 
> >and Web based 'appliances' can shrink to the size of a plastic 
> >'smart-card'! Just project everything onto a virtual screen which
> can 
> >be virtually touched and pointed to, etc!! You could probably have
> your
> 
> >personal (private) view using special glasses if required. I
> wouldn't 
> >rule out something like this being made available within the next 
> >decade...
> >
> >So far, I have only talked about the tech side of things here -
> there 
> >are many dangers and negative side effects to the personal and
> societal
> 
> >aspects. More of that later!
> >
> >Slightly crazy today, aren't I?
> >John
> ><< WINMAIL.DAT >>
> 
> > 
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> 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 servic

RE: to_char(sysdate) problem on 8.1.7.

[Jamadagni, Rajendra]

Title: RE: to_char(sysdate) problem on 8.1.7.





Do you have cursor_sharing set to force?
It sometimes happens ... we have seen it on 901 as well.


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!




*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: SET ORACLE-L NOMAIL

[Scott Stefick]

ORA-00SORRY:  INVALID RECIPIENT(S).  "SET ORACLE-L
NOMAIL" HAS NO EFFECT WHEN SENT TO THE LIST. MAIL MUST BE SENT TO
[EMAIL PROTECTED]     :O)

FYI:

5) Commonly used mailing list server commands 
The mailing list server software in use at fatcity.com is ListGuru.
ListGuru 
accepts most commands from all major mailing list servers, including
Listserv, 
ListProc, Majordomo, MailBase and SmartList (among others). All messages
to 
the mailing list server MUST be addressed to only one address, however:

[EMAIL PROTECTED] <-- Note EXACT spelling of 'ListGuru' 
Mailing list commands must be included in the message body, not the
Subject 
line. Commands on the Subject line are ignored. Multiple commands can be

included in a single message. You may send as many messages as you wish.

A short description of the most commonly used commands follows. For a

complete list of all commands available, use the HELP command to obtain
more 
detailed information. In all commands below,  refers to a
name of a 
valid mailing list name (for example, ORACLE-L ). 
Command Format What it does 
-- --- 
HELP Sends complete ListGuru command information 
LISTS Sends a list of all available lists at this site 
UNSUB  Unsubscribes the subscriber from the list 
SET  NOMAIL Temporarily turns off messages to the subscriber

SET  MAIL Resumes mail flow to the subscriber 
CONFIRM  Confirms a subscription to a particular list 
WHICH Shows ALL lists that a user is subscribed to 
SET  DIGEST Turns on DIGEST mode for a list (if available)

SET  NODIGEST Returns to normal (single message) mode for a
list 
INDEX  Lists all available archive files for a list 
END Discontinues further command processing (useful if 
you have long signature sections). 
There are more than 50 commands which can be used with ListGuru. The HELP

command details all commands and their function. In addition, it
specifies 
which commands from other mailing list server software may be used. 

Note that the two most common mistakes when using mailing list servers
are 
misspellings of addresses or list names, and posting mailing list server

commands to the list itself (a major no-no). When in doubt, ask for HELP.




At 07:33 AM 10/15/02 -0800, you wrote:

SET ORACLE-L NOMAIL 

Mit freundlichen Grüßen, 

Brigitte Türk 
KAUFHOF WARENHAUS AG 
IT-Controlling Datenbankadm. 
Leonhard-Tietz-Str. 1 
D-50676 Köln 
Tel.:+49 (0)221 223-21 88 
eMail:
[EMAIL PROTECTED] 



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**

Re: CodeNotes for Oracle9i...

[Rachel Carmichael]

God no! I'd better let my (male) co-author do the audiotaping :)

I've never understood why talking on a hands-free phone is less
distracting than talking on a phone you have to hold


--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> There's always some idiot who wants to rain on the
> parade, so it may as well be me.  I can't remember the
> specifics but a recent test in London showed that
> people on (hands-free) phones in their cars were 'x'%
> more likely to crash ('x' was somewhere like 50%!),
> the test being designed to show that its not the phone
> in your hand, its the fact that you're
> talking/listening that ends up killing you...
> 
> I can't begin to imagine the traffic carnage when the
> CD "DBA101: The sensual sultry sounds of Carmichael"
> hits the charts!
> 
> Does Rachel really want that kind of responsbility :-)
> 
> Cheers
> Connor
> 
>  --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > It's a little difficult to see how code samples and
> > illustrations
> > (which I find invaluable) could be translated to
> > audio
> > 
> > It's technically copyright infringement (I believe)
> > to translate the
> > books. I don't own the copyright, so I'm not about
> > to call out the
> > lawyers. I am supposed to contact my publisher for
> > permission (never
> > been refused, as it's publicity) when I want to use
> > part of a chapter
> > for an article or presentation.
> > 
> > Besides, I have problems concentrating when I listen
> > to books on tape,
> > so I'm not the best person to advocate this!
> > 
> > 
> > --- Joe Testa <[EMAIL PROTECTED]> wrote:
> > > I would think the authors should read and publish
> > the books in .mp3 
> > > format, you can get like 10 hours worth on one cd.
> > > 
> > > Rachel how about you start,
> > > 
> > > bwahahahahahahaha
> > > 
> > > 
> > > joe
> > > 
> > > 
> > > DENNIS WILLIAMS wrote:
> > > 
> > > >I have an odd question about these on-line books.
> > Can I
> > > copy-and-paste the
> > > >text? 
> > > >   Like many of you, I seem to end up with long
> > commutes (why are
> > > the best
> > > >jobs never in your neighborhood?). I find
> > listening to books on CD
> > > to be a
> > > >better use of time than reading bumper stickers.
> > Nobody ever seems
> > > to issue
> > > >Oracle books on audio. So I got a text-to-voice
> > program, and it
> > > works pretty
> > > >good to create an audio version of a book. But
> > many of these eBooks
> > > >zealously protect their text and prevent you from
> > doing
> > > copy-and-paste on
> > > >the text. Fortunately Oracle makes their books
> > readily available.
> > > Any ideas
> > > >are welcome. And my apologies to the authors on
> > the list that are
> > > going "he
> > > >wants to do WHAT with my book!!".
> > > >Dennis Williams
> > > >DBA
> > > >Lifetouch, Inc.
> > > >[EMAIL PROTECTED] 
> > > >
> > > >-Original Message-
> > > >Sent: Thursday, October 10, 2002 7:54 PM
> > > >To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >I believe the Book Safari is changing.  It is
> > supposed
> > > >to be more flexible now.
> > > >
> > > >http://www.oreilly.com/news/new_safari_0902.html
> > > >
> > > >Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >"Grabowy, Chris" <[EMAIL PROTECTED]>
> > > >Sent by: [EMAIL PROTECTED]
> > > > 10/08/2002 01:04 PM
> > > > Please respond to ORACLE-L
> > > >
> > > > 
> > > >To: Multiple recipients of list
> > ORACLE-L
> > > <[EMAIL PROTECTED]>
> > > >cc: 
> > > >Subject:CodeNotes for Oracle9i...
> > > >
> > > >
> > > >So every few months my Lookout reminder pops up
> > to remind me to
> > > check out 
> > > >what new Oracle books have been released.  I
> > stumbled upon a new
> > > book 
> > > >called CodeNotes for Oracle9i on Amazon.com, but
> > the interesting
> > > part is 
> > > >that it is available in eBook format.  Here's the
> > (probably broken) 
> > > >link...
> > > >
> > >
> >
>
>http://www.amazon.com/exec/obidos/tg/detail/-/B6ISCN/qid=1034101493/sr=1
> > > >-25/ref=sr_1_25/104-5919725-7522346?v=glance
> > > >
> > > >The eBook version is $9.95 and the shipping is
> > free (big grin),
> > > while the 
> > > >paperback is $13.97 plus shipping.  Are you
> > comfortable reading an
> > > eBook? 
> > > >You decide. 
> > > >
> > > >At any rate, I will probably break down and buy
> > the eBook.  Not so
> > > much 
> > > >because the book is great (or not) but because I
> > hope to send a
> > > message to 
> > > >publishers to publish more books in the eBook
> > format, which is also
> > > why I 
> > > >posted this message.
> > > >
> > > >I know that O'Reilly has the Safari Bookshelf
> > website, but I found
> > > it to 
> > > >be restrictive and pricey.
> > > >
> > > >BTW, if for some reason you are or will be using
> > .Net, the CodeNotes
> > > eBook 
> > > >version is free...
> > > >
> > >
> >
> >http://www.codenotes.com/do/downloads/downloadsNETbook
> > > >
> > > >
> > > >
> > > 
> > > 
> > > 
> > > -- 
> > > P

RE: CodeNotes for Oracle9i...

[Scott . Shafer]

Yeah, hearing the Goddess describe "massaging the 'data'" in sultry detail
would surely be a distraction...  

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 5:03 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: CodeNotes for Oracle9i...
> 
> There's always some idiot who wants to rain on the
> parade, so it may as well be me.  I can't remember the
> specifics but a recent test in London showed that
> people on (hands-free) phones in their cars were 'x'%
> more likely to crash ('x' was somewhere like 50%!),
> the test being designed to show that its not the phone
> in your hand, its the fact that you're
> talking/listening that ends up killing you...
> 
> I can't begin to imagine the traffic carnage when the
> CD "DBA101: The sensual sultry sounds of Carmichael"
> hits the charts!
> 
> Does Rachel really want that kind of responsbility :-)
> 
> Cheers
> Connor
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

OT: RE: CodeNotes for Oracle9i...

[MacGregor, Ian A.]

Does the great IAM still exist.   For those who have not heard of it IAM  is the 
Institute of Advanced Motoring.  I had thought it an invention of Monty Python,  but 
it's a real.  Members of
the "great" IAM pay less for their auto insurance policies.  Can  one retain  
membership whilst talking on a cell phone and  listening  to riveting code fragments?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 3:03 AM
To: Multiple recipients of list ORACLE-L


There's always some idiot who wants to rain on the
parade, so it may as well be me.  I can't remember the
specifics but a recent test in London showed that
people on (hands-free) phones in their cars were 'x'%
more likely to crash ('x' was somewhere like 50%!),
the test being designed to show that its not the phone
in your hand, its the fact that you're
talking/listening that ends up killing you...

I can't begin to imagine the traffic carnage when the
CD "DBA101: The sensual sultry sounds of Carmichael"
hits the charts!

Does Rachel really want that kind of responsbility :-)

Cheers
Connor

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> It's a little difficult to see how code samples and
> illustrations
> (which I find invaluable) could be translated to
> audio
> 
> It's technically copyright infringement (I believe)
> to translate the
> books. I don't own the copyright, so I'm not about
> to call out the
> lawyers. I am supposed to contact my publisher for
> permission (never
> been refused, as it's publicity) when I want to use
> part of a chapter
> for an article or presentation.
> 
> Besides, I have problems concentrating when I listen
> to books on tape,
> so I'm not the best person to advocate this!
> 
> 
> --- Joe Testa <[EMAIL PROTECTED]> wrote:
> > I would think the authors should read and publish
> the books in .mp3 
> > format, you can get like 10 hours worth on one cd.
> > 
> > Rachel how about you start,
> > 
> > bwahahahahahahaha
> > 
> > 
> > joe
> > 
> > 
> > DENNIS WILLIAMS wrote:
> > 
> > >I have an odd question about these on-line books.
> Can I
> > copy-and-paste the
> > >text? 
> > >   Like many of you, I seem to end up with long
> commutes (why are
> > the best
> > >jobs never in your neighborhood?). I find
> listening to books on CD
> > to be a
> > >better use of time than reading bumper stickers.
> Nobody ever seems
> > to issue
> > >Oracle books on audio. So I got a text-to-voice
> program, and it
> > works pretty
> > >good to create an audio version of a book. But
> many of these eBooks
> > >zealously protect their text and prevent you from
> doing
> > copy-and-paste on
> > >the text. Fortunately Oracle makes their books
> readily available.
> > Any ideas
> > >are welcome. And my apologies to the authors on
> the list that are
> > going "he
> > >wants to do WHAT with my book!!".
> > >Dennis Williams
> > >DBA
> > >Lifetouch, Inc.
> > >[EMAIL PROTECTED] 
> > >
> > >-Original Message-
> > >Sent: Thursday, October 10, 2002 7:54 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >I believe the Book Safari is changing.  It is
> supposed
> > >to be more flexible now.
> > >
> > >http://www.oreilly.com/news/new_safari_0902.html
> > >
> > >Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > >"Grabowy, Chris" <[EMAIL PROTECTED]>
> > >Sent by: [EMAIL PROTECTED]
> > > 10/08/2002 01:04 PM
> > > Please respond to ORACLE-L
> > >
> > > 
> > >To: Multiple recipients of list
> ORACLE-L
> > <[EMAIL PROTECTED]>
> > >cc: 
> > >Subject:CodeNotes for Oracle9i...
> > >
> > >
> > >So every few months my Lookout reminder pops up
> to remind me to
> > check out 
> > >what new Oracle books have been released.  I
> stumbled upon a new
> > book 
> > >called CodeNotes for Oracle9i on Amazon.com, but
> the interesting
> > part is 
> > >that it is available in eBook format.  Here's the
> (probably broken) 
> > >link...
> > >
> >
>
>http://www.amazon.com/exec/obidos/tg/detail/-/B6ISCN/qid=1034101493/sr=1
> > >-25/ref=sr_1_25/104-5919725-7522346?v=glance
> > >
> > >The eBook version is $9.95 and the shipping is
> free (big grin),
> > while the 
> > >paperback is $13.97 plus shipping.  Are you
> comfortable reading an
> > eBook? 
> > >You decide. 
> > >
> > >At any rate, I will probably break down and buy
> the eBook.  Not so
> > much 
> > >because the book is great (or not) but because I
> hope to send a
> > message to 
> > >publishers to publish more books in the eBook
> format, which is also
> > why I 
> > >posted this message.
> > >
> > >I know that O'Reilly has the Safari Bookshelf
> website, but I found
> > it to 
> > >be restrictive and pricey.
> > >
> > >BTW, if for some reason you are or will be using
> .Net, the CodeNotes
> > eBook 
> > >version is free...
> > >
> >
>
>http://www.codenotes.com/do/downloads/downloadsNETbook
> > >
> > >
> > >
> > 
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://

RE: local Bimap indexes -- thanks

[sat0789]

Thanks Kirti for the suggestion..it works now.

Sathish.

On Mon, 14 Oct 2002 19:53:23 -0800, "Deshpande, Kirti"
<[EMAIL PROTECTED]> said:
> Create logon triggers for these Informatica user id to alter session
> set... 
> 
> - Kirti
> 
> -Original Message-
> Sent: Monday, October 14, 2002 7:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Thats what we exactly did except that iniformatica starts a separate
> session when it is loading the target
> which results in the error "unusable state" .
> 
> sathish
> 
> On Mon, 14 Oct 2002 15:44:02 -0800, "Khedr, Waleed"
> <[EMAIL PROTECTED]> said:
> > In Informatica there is a stored procedure transform (runs any Oracle SP)
> > that you can make it "pre source load".
> > So the SP would be called before loading the table.
> > 
> > Regards,
> > 
> > Waleed
> > 
> > -Original Message-
> > Sent: Monday, October 14, 2002 7:04 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello All,
> > This problem pertains to local bitmap index in dw env.
> > 
> > We are using informatica to load our fact tables.
> > 
> > i have a fact table partitioned on period key (range partition).
> > We have built local bitmap indexes on the foreign keys.
> > During the loading of the fact table for month 1, we are making the local
> > bitmap index partition pertaining to month 1 
> > as UNUSABLE (through stored procedure being called at just before the
> > target is being loaded). In that same procedure
> > we also set ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE.
> > Once informatica starts to load the target, it opens up a new session
> > which in turn invalidates the alter session
> > and hence oracle terminates with an error saying "0ra-1052 index in
> > unusable state"
> > Please let me know if there is any workaround to this. 
> > Is droping and recreating the bitmap index the ONLY option ???. this fact
> > table is going to grow to about 150 mill rows in
> > 12 month time frame , avg row length being 100 bytes)
> > 
> > 
> > oracle ver 9.2.,
> > 
> > 
> > TIA,
> > 
> > sathish.
> > 
> > -- 
> > http://fastmail.fm - The way an email service should be
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > 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.com
> > -- 
> > Author: Khedr, Waleed
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> -- 
> http://fastmail.fm - Access all of your messages and folders wherever you
> are
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> 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.com
> -- 
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscrib

Re: A little OT, but somewhat relevant

[Jared . Still]

Hmmm

Throw them all into an arena, the top coder
gets to survive.  I think this has already been
done in Rome.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/15/2002 07:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:A little OT, but somewhat relevant


To ALL,

The following came in the mail this morning.  I visited the web site
(www.topcoder.com) and find it somewhat odd, but!!!  It could spawn into a 
lot
of things, like sparing on a database recovery so that your next employer 
knows
your capable & not just slinging it.

Dick Goulet

PS: Jared, sorry about the OT, but it IS interesting.


---
Code-Jousting For Jobs
A startup that gives software developers the opportunity to test 
their skills against their peers in online competitions is 
launching its own recruiting service.
http://update.informationweek.com/cgi-bin4/flo?y=eJIQ0BdFGA0V20Bj330AH

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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: SET ORACLE-L NOMAIL

[Jared . Still]

Brigitte,

You need to send this command to [EMAIL PROTECTED]

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/15/2002 08:33 AM
 Please respond to ORACLE-L

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


SET ORACLE-L NOMAIL 
Mit freundlichen Grüßen, 
Brigitte Türk 
KAUFHOF WARENHAUS AG 
IT-Controlling Datenbankadm. 
Leonhard-Tietz-Str. 1 
D-50676 Köln 
Tel.:+49 (0)221 223-21 88 
eMail: [EMAIL PROTECTED] 




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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: A little OT, but somewhat relevant

[Fink, Dan]

It sounds a lot like 'Survivor:Silicon Valley'

-Original Message-
Sent: Tuesday, October 15, 2002 11:20 AM
To: Multiple recipients of list ORACLE-L


Hmmm

Throw them all into an arena, the top coder
gets to survive.  I think this has already been
done in Rome.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/15/2002 07:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:A little OT, but somewhat relevant


To ALL,

The following came in the mail this morning.  I visited the web site
(www.topcoder.com) and find it somewhat odd, but!!!  It could spawn into a 
lot
of things, like sparing on a database recovery so that your next employer 
knows
your capable & not just slinging it.

Dick Goulet

PS: Jared, sorry about the OT, but it IS interesting.



---
Code-Jousting For Jobs
A startup that gives software developers the opportunity to test 
their skills against their peers in online competitions is 
launching its own recruiting service.
http://update.informationweek.com/cgi-bin4/flo?y=eJIQ0BdFGA0V20Bj330AH

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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.com
-- 
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: Replication

[Rajesh . Rao]

This is definitely possible with RMAN. The only hitch is that in case you
use RMAN to write to disk, the same directory structure must exist on the
target server. The workaround would be to create soft links. Also, in case,
you are moving the datafiles to a different destination, then one needs to
use the 'set newname' in RMAN. If you are looking for the fastest way to
replicate a db, and $$ aint a problem, I would recommend BCV splits.

If you only plan to use it as a reporting database only, and periodic
refreshes, why not use standby databases, instead of replication.

Raj






   
 
Jared.Still@r  
 
adisys.com   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
root@fatcity.Subject: Re: Replication  
 
com
 
   
 
   
 
October 14,
 
2002 04:44 PM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




How about:

Copy your database to the new server.  This needs to be
done in real time.  I've done this a number of times by
putting the database in hot backup mode, copying the
datafiles to the new server.

Then when you're ready to switch, shutdown the old
database, copy all archive logs generated during the
backup to the new server.

Also, copy all unarchived redo logs to the new server
as well.  Open the new database, apply media recovery
using all the archive logs you copied, as well as the
unarchived redo logs.

Applying the redo logs from the old database allows
you to open the database without 'RESETLOGS'.

This may be possible with RMAN, but I suspect the
hot backup method is simpler.

Jared







"Robin Li" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/14/2002 12:53 PM
 Please respond to ORACLE-L


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


Thanks to all who replied.

The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over,
he is going to use the DB on the old server as reporting.

Robin

[EMAIL PROTECTED] wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose?  High Availability?  Querying and
reporting?
>
> Jared
>
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/14/2002 06:58 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Replication
>
> Hi all,
>
> Does anyone have the appropriate time on implementing replication for a
> newbe?
>
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
>
> TIA
>
> Robin


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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 your

Re: Data Purging - Approaches

[Jared . Still]

I'm not a proponent of purging data.

Unless of course, you expect to never see it again.

That word 'archive' rolls of the tongues of managers
and consultants pretty easily, but what's behind it?

There are a few gotchas with purging and archiving.

Let's assume you have some 3 year old data that 
you need to see again, and it has been purged.

Here are some of the possible problems:

*  Your backup tapes are corrupted
*  Your new backup hardware can't read the old tapes
*  Your software no longer understands the format that
the data is in.
* You have the correct software, but it won't work on the
   current version of OS on your hardware.
* The data format/software/whatever is not well documented
*  The employees that understood the data 3 years ago
   have been laid off.
* ... lots more stuff

Read Bryon Bergeron's "Dark Ages II: When the Digital Data Die"
http://www.powells.com/cgi-bin/biblio?inkey=2-0130661074-0

Perhaps much better than archiving the data, is to stick with the
idea of moving it to another database, and using lots of cheap
disk storage (NAS) or a heirarchical file system to store it.

The point being that if it's online somewhere, it will be maintained.

Don't purge it till Finance, HR, the IRS and any other stakeholder
says it's ok.  Only then purge it and archive it to offline tape with the
knowledge that you may never see that data again.

Jared







[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/15/2002 05:38 AM
 Please respond to ORACLE-L

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



Dear List, 

We need to remove data from our database everyday, so we are plannning to 
have a scheduled process for this. But the case is that we cannot simply 
remove the data. This data has to be made available at a later time if 
required. So this is the process that we have designed. 
1.  The background process would first insert all the required data 
from the main database to another database. 
2.  Now if this successfull, it would be deleted from the main 
database. 
3.  The selection criteria on which the data to be purged is found is 
a business requirement. It is based on some date, but we cannot partition 
the data based on the date, otherwise we could have done with paritioning 
and dropping the partition could have been easily done. 
4.  The data in the second database would be archived in a normal 
sequence 
5.  If any user request for the data already purged, the data would be 
read from the second database and shown to him. 


Now the issue, the data that has to be moved or deleted in such a way 
would mount to more that 10 GB of data, so is this method a good solution. 
Can anybody suggest a better approach for doing this. 


We are using Oracle 9i database, Weblogic Application server and Java 
client. We have list partitioned our database. 

Any other data purging techniques would be greatly appreciated. 

Regards 
Prem Chandran N 


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

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

RE: RE: RE: Double Take and Oracle

[Denham Eva]

Title: RE: RE: RE: Double Take and Oracle





Dick,


Thank you, atleast you have given me something to work with. I had already began making plans of approaching management for some serious downtime. I have been holding back as I am awaiting response from Double-Take's Source - Sunbelt Software on this issue, I have logged a call with them about 8hrs ago already!

But you have given me alot to chew on until I do that - Many Thanks!!!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 6:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: Double Take and Oracle



Eva,


    First things first, Oracle gets to be a bear when your trying to move a
database as you are while it's running.  The first point to settle is that
Double Take is not doing something that is incompatible with Oracle, like making
an ASCII vs. BINARY copy of the datafiles.  To determine that you need to do a
move with the source/production database shutdown.  Yeah, I know that can be
hard to schedule but it's necessary.  If the copy won't start at that point then
Double Take is completely incompatible with Oracle and you can't go much
further.  Now if that passes, allow Double Take to copy the production DB to the
backup server and while it's doing so check the hotbackup status of the database
using the following:


    SELECT COUNT(*)
    FROM DBA_DATA_FILES DF, SYS.V_$BACKUP B
    WHERE FILE_ID = FILE#
    AND DF.STATUS = 'AVAILABLE'
    AND B.STATUS = 'ACTIVE';


The number you get back should equal the number of datafiles in your database. 
If it comes back as 0 then the database has not switched and the backup is
worthless.  You may have to do this manually before running Double Take.  Also
your production/source DB has to be in archive log mode or else hotbackup does
not work.


The reasons for this are wrapped around Oracle's "write as little as needed and
do so as seldomly as possible" idea.  With this idea data block changes are not
sent to the datafiles until there is a need to.  MicroSlop and Exchange work on
the exact opposite idea which makes them IO hogs, although Oracle can be the
same.  In your case I would suspect that the hotbackup is the problem.


Dick Goulet


Reply Separator
Author: Denham Eva <[EMAIL PROTECTED]>
Date:   10/15/2002 7:08 AM


Thanks for the input so far. Double-Take works real time so the database is
never down.
I also followed their setup direction to the letter. Problem on our site is
that this product is being used for SQL Server and Exchange (Appears to work
fine there, but Oracle is a beast of another color compared to these "Access
on Steroids" databases), management are insisting for the sake of conformity
that this must work. At ever attempted startup another file gives an error,
most frustrating of all is that there is almost no consistency to the
errors.


Denham Eva 


-Original Message-
Sent: Tuesday, October 15, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L



Lewis,


    I can understand where Eva is coming from.  I had a demo of a similar
product some time ago.  Their BIG selling point is that you have a
production
server and a backup that is close in time with your production server at
half
(or less) the cost of a hot standby.  Their reasoning is that you don't have
Oracle running on the standby and consequently don't have to pay Oracle a
license fee for the second server since only one server is running at any
point
in time.  Logically their point is well taken.  Regrettably and
understandably
that is NOT Oracle's point of view.


Dick Goulet


Reply Separator


Author: Bishop Lewis <[EMAIL PROTECTED]>
Date:   10/15/2002 2:23 AM


I'm always dubious of these types of products (especially when there are no
reference sites available) and would opt for a batched up standby database
solution (syncing every 5/10/15 minutes or so) myself. I'm not saying
Double-Take is not good - I've got no experience of it and am sorry it's not
any help but you have an option should Double-Take not work correctly.


Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 08:28
To: Multiple recipients of list ORACLE-L


This header confirms that this email message has been swept for the
presence of computer viruses. 


Corporate IT
THE WOOLWICH
--
Hello Esteemed Gurus 
Pls advise... 
We are trying to get Double Take to work on our site. Does anyone actually
have this product working??? 
Salesperson claims Double Take is certified by Orac

RE: RE: Double Take and Oracle

[Denham Eva]

Title: RE: RE: Double Take and Oracle





Yes I believe that I have all the files necessary. The database does not complain about missing files but corrupt files ie the redolog etc.

I'll have to check on the transactional applications options though, if you mean Oracle they are exact, but I'll take it up with the Double-Take techie.

Thanks


-Original Message-
From: Bishop Lewis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: Double Take and Oracle



Eva - just checking - from their docs have you verified that the
transactional applications option is selected on the optimisations screen?
This seems the most likely omission - and are you also sure that you are
including all necessary files in the selected copy?


Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 16:09
To: Multiple recipients of list ORACLE-L


Thanks for the input so far. Double-Take works real time so the database is
never down. 
I also followed their setup direction to the letter. Problem on our site is
that this product is being used for SQL Server and Exchange (Appears to work
fine there, but Oracle is a beast of another color compared to these "Access
on Steroids" databases), management are insisting for the sake of conformity
that this must work. At ever attempted startup another file gives an error,
most frustrating of all is that there is almost no consistency to the
errors.
Denham Eva 
-Original Message- 
Sent: Tuesday, October 15, 2002 4:04 PM 
To: Multiple recipients of list ORACLE-L 


Lewis, 
    I can understand where Eva is coming from.  I had a demo of a similar 
product some time ago.  Their BIG selling point is that you have a
production 
server and a backup that is close in time with your production server at
half 
(or less) the cost of a hot standby.  Their reasoning is that you don't have


Oracle running on the standby and consequently don't have to pay Oracle a 
license fee for the second server since only one server is running at any
point 
in time.  Logically their point is well taken.  Regrettably and
understandably 
that is NOT Oracle's point of view. 
Dick Goulet 


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






DISCLAIMER 

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





This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - 
For more information please visit  
  www.marshalsoftware.com 

Re: designer autolayout

[Jared . Still]

No.

Though I'm not currently using Designer, I've worked with it
quite a bit in the past for data modeling.  Don't use the autolayout.

I'm currently using Embarcadero ER Studio.  If Designer wasn't
such a pig, I would have bought it instead, and am currently
wishing I had anyway.

ER Studio is very fast, but not *nearly* the tool that Designer is.

Jared






"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/15/2002 06:28 AM
 Please respond to ORACLE-L

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


Is there a way to make the autolayout feature produce a concise layout in 
Designer Entity Relationship Diagrammer?
 
Regards,
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 
Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services| Services technologiques 
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO 
E-Mail: [EMAIL PROTECTED] 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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: Over Consumption of CPU ?

[VIVEK_SHARMA]

The back end storage box is :-

HP Storage Box Model = XP512 
1 Volume only (RAID 5) exists across ALL the underlying Disks 
Total Number of Underlying Disks = 56
Veritas File System (VXFS) partitions Sit above the Volume (RAID 5)

Thus the hardware is a Hybrid Setup combining a SUN Machine with a HP Storage

ORACLE_HOME , Database Both Exist on the Storage Box.

NOTE - The Storage Box Continues to be the SAME . 
It has simply moved from the previous SF6800 machine to SF15K machine .

The CPU Utilizations of BOTH APP & DB Server machines has Shot UP by 25 % .

Both APP & DB Server machines have identical configuration i.e. SF15K machines , 
while previously Both used to be SF6800 machines

Thanks


-Original Message-
Sent: Tuesday, October 15, 2002 8:06 PM
To: VIVEK_SHARMA


Vivek,

Please clarify... a Sun Fire 6800 and a Sun Fire 15000 are not storage boxes - they 
are CPUS/RAM/interfaces to storage.  What is the actual back end storage (EMC, Sun 
Storage, ?)

Steve

-- "VIVEK_SHARMA" <[EMAIL PROTECTED]> writes:

To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
Date: Tue, 15 Oct 2002 17:33:02 +0530


On Moving the Storage Box from a SF6800 machine to SF15000 machine CPU Consumption has 
Shot UP
by 25 %

Particulars :-
Number of CPUs on  SF6800 = 24 with 750 MHz Clock Speed
Number of CPUs on SF15000 = 24 with 900 MHz Clock Speed

Both %usr & %sys CPU Utilization components seem to have gone up 

Solaris 8
Oracle 8.1.7.2 (+ Some Stand-Alone 1 Off patches)
Database Size 500 GB
Nature of Application Database = Hybrid (Banking application)
Number of Concurrent User processes = 2500

Qs How may the problem be approached towards resolution ?
Qs Is using truss Command to identify the Cause a Good approach ?
Qs Are there any parameters / Switches which may given with the truss Command to get 
the % CPU consumed by the underlying system Calls ? 
Qs Are there any preferred parameters Specific to SF15000 ?





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

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

RE: CodeNotes for Oracle9i... Destress on the way home!...OT

[Connor McDonald]

"A near-miss with Niemiec"


 --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: >
"_Oracle 8i Backup And Recovery_, a Rendezvous With
> Rama"
> 
> --Walt Weaver
> 
> (Not exactly a namesake, but the best I could do)
> 
> -Original Message-
> Sent: Tuesday, October 15, 2002 9:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I almost used that one.
> 
> The real problem is finding celebrities with the
> following last names:
> Niemiec
> Velpuri
> Testa
> Kolk
> Vaidyanatha
> 
> -Original Message-
> Sent: Monday, October 14, 2002 6:58 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hoagy Carmichael reads DBA 101 by Rachel Carmichael?
> 
> 
> --- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> > We could put together a whole Namesakes series
> about Oracle stuff...
> > Morgan Freeman reads Oracle 9i New Features by
> Robert Freeman
> > Patch Adams reads Oracle8i Internal Services by
> Steve Adams
> > 
> > Apologies to Spinal Tap for the distorted idea...
> > 
> > -Original Message-
> > Sent: Monday, October 14, 2002 3:53 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Dennis,
> > 
> > I also have a driving commute, and I was also
> thinking about asking
> > her
> > to voice record her book.  But I think I would get
> into an accident
> > hearing her sexy voice describing how to recover a
> database...:P :)
> > :P
> > :)
> > 
> > -Original Message-
> > Sent: Monday, October 14, 2002 5:34 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > John - Wow! An impressive memory tour de force! 
> >My problem is that I am driving during my
> commute. You get the
> > strangest looks when the next driver glances over
> and sees your face
> > buried in a PDA. Actually that last phrase might
> become prophetic. I
> > was
> > just asking if there was a way to get a talking
> e-book. For example,
> > you
> > can download just about any book whose copyright
> has expired, copy,
> > paste into my text-to-voice, and there you have an
> audio version.
> > I'll
> > be long dead before the copyrights on any books
> about Oracle expire.
> > Most e-book publishers protect their material as
> zealously as the
> > Secret
> > Service protects the president. Which often
> renders them unusable for
> > any purpose.
> >Personally, I liked the suggestion to ask the
> noted authors on
> > this
> > list to read their books just like the fiction
> superstars do.
> > 
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Monday, October 14, 2002 4:11 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Dennis,
> > 
> > See below is an email conversation that I had with
> the 'Goddess' in
> > 2000
> > on the same subject. Those were the days when
> Goddesses had to sleep
> > and
> > de-stress on their way home
> > 
> > (Ducking as the Goddess takes out her six-shooter
> magic wand)
> > 
> > John
> > 
> > Reply from Rachel:
> > ==
> > Geek! 
> > 
> > The concept you are thinking of exists in some
> form already --
> > e-books.
> > PDA
> > 
> > sized computer that you can download a book into.
> > 
> > Destressing is important -- but more so is the nap
> I took on the
> > train
> > on my
> > 
> > way home tonight!
> > 
> > Rachel
> > 
> > 
> > >From: <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: RE: Using your commute time
> > >Date: Fri, 3 Mar 2000 08:41:26 +0800
> > >
> > > > I use the time to talk to the people I know on
> the train, or to 
> > > > read. Fiction or otherwise. Others have their
> laptops, I see them
> > 
> > > > working with > them. Or they read the
> newspapers, or sleep.
> > >
> > >Granted, but the difference as against a
> push-technology such as a 
> > >Radio station (which many people listen to while
> commuting) is that 
> > >this is a pull-technology, i.e. optional
> availability. However, I do
> > 
> > >conceed to the need to
> decompress/destress/plan/communicate with 
> > >others, energize, etc.
> > >
> > > > I think technical books need visual
> interfaces. For diagrams,
> > tables
> > >etc.
> > >
> > >Which brings me to my next brain-wave (or
> sizzled-brain-wave :) - 
> > >Computers have drastically reduced in size while
> increasing in
> > capacity
> > 
> > >and capability. However, the restraining factor
> has been (and will
> > be) 
> > >the size of the Input/Output area (i.e.
> Screen/Keyboard size) which 
> > >cannot reduce below a threshold. What if someone
> discovers how to
> > use a
> > 
> > >hologram to perform the same input/output? These
> hologram enabled
> > PDA 
> > >and Web based 'appliances' can shrink to the size
> of a plastic 
> > >'smart-card'! Just project everything onto a
> virtual screen which
> > can 
> > >be virtually touched and pointed to, etc!! You
> could probably have
> > your
> > 
> > >personal (private) view using special glasses if
> required. I
> > wouldn't 
> > >rule out something like this being made available

Re: Replication

[Jared . Still]

The directory structure was the problem I had in mind actually.

Moving to a different disk layout is easy with hot backup.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/15/2002 10:24 AM
 Please respond to ORACLE-L

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



This is definitely possible with RMAN. The only hitch is that in case you
use RMAN to write to disk, the same directory structure must exist on the
target server. The workaround would be to create soft links. Also, in 
case,
you are moving the datafiles to a different destination, then one needs to
use the 'set newname' in RMAN. If you are looking for the fastest way to
replicate a db, and $$ aint a problem, I would recommend BCV splits.

If you only plan to use it as a reporting database only, and periodic
refreshes, why not use standby databases, instead of replication.

Raj






  
Jared.Still@r  
adisys.com   To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]> 
Sent by: cc:   
root@fatcity.Subject: Re: Replication  
 
com  
  
  
October 14,  
2002 04:44 PM  
Please  
respond to  
ORACLE-L  
  
  




How about:

Copy your database to the new server.  This needs to be
done in real time.  I've done this a number of times by
putting the database in hot backup mode, copying the
datafiles to the new server.

Then when you're ready to switch, shutdown the old
database, copy all archive logs generated during the
backup to the new server.

Also, copy all unarchived redo logs to the new server
as well.  Open the new database, apply media recovery
using all the archive logs you copied, as well as the
unarchived redo logs.

Applying the redo logs from the old database allows
you to open the database without 'RESETLOGS'.

This may be possible with RMAN, but I suspect the
hot backup method is simpler.

Jared







"Robin Li" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/14/2002 12:53 PM
 Please respond to ORACLE-L


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


Thanks to all who replied.

The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over,
he is going to use the DB on the old server as reporting.

Robin

[EMAIL PROTECTED] wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose?  High Availability?  Querying and
reporting?
>
> Jared
>
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/14/2002 06:58 AM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Replication
>
> Hi all,
>
> Does anyone have the appropriate time on implementing replication for a
> newbe?
>
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
>
> TIA
>
> Robin


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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 info

Password_grace_time and JDBC

[Kieran Murray]

Hi friends,
 
We're having a spot of bother with our product and Oracle's password
management.
We have a java front end which is installed on a client site.  The client
site
uses Oracle profiles to handle their password security.  In the profile they
have
set up a Password_life_time of 30 days and a Password_grace_time of 5 days.
 
The problem is that our front end is not able to handle the Oracle message
(I think it's ORA-28002),
which states that the password will expire in x days.  As no connection has
been established through
JDBC we have no way of allowing the user to change their password.
 
Unfortunately, the client DBAs are adamant that the profiles cannot be
changed (which is fair enough),
but does anyone have any idea how we could handle this situation on the
Program/JDBC side?
 
Thanks a lot,
Kieran Murray
Cardbase Technologies,
Crofton Road,
Dun Laoghaire,
Co. Dublin.
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kieran Murray
  INET: [EMAIL PROTECTED]

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

RE: designer autolayout

[Grabowy, Chris]

Ok, I'll bite.  Can you name a few Designer features that ER Studio is missing?

I have not used either product, I am stuck with an ancient version of ERwin.  Mgmt 
almost purchased ER Studio, but then the economy, and business, crashed...

-Original Message-
Sent: Tuesday, October 15, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L


No.

Though I'm not currently using Designer, I've worked with it quite a bit in the past 
for data modeling.  Don't use the autolayout.

I'm currently using Embarcadero ER Studio.  If Designer wasn't such a pig, I would 
have bought it instead, and am currently wishing I had anyway.

ER Studio is very fast, but not *nearly* the tool that Designer is.

Jared






"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/15/2002 06:28 AM
 Please respond to ORACLE-L

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


Is there a way to make the autolayout feature produce a concise layout in 
Designer Entity Relationship Diagrammer?
 
Regards,
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 
Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services| Services technologiques 
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO 
E-Mail: [EMAIL PROTECTED] 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
--
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

RE: Over Consumption of CPU ?

[VIVEK_SHARMA]

NOTE - The Storage Box Continues to be the SAME . 
It has simply moved (UNPlugged ) from the previous SF6800 machine & Plugged (Attached) 
to the SF15K machine.

The back end storage box is :-

HP Storage Box Model = XP512 
1 Volume only (RAID 5) exists across ALL the underlying Disks 
Total Number of Underlying Disks = 56
Veritas File System (VXFS) partitions Sit above the Volume (RAID 5)

Thus the hardware is a Hybrid Setup combining a SUN Machine with a HP Storage

ORACLE_HOME , Database Both Exist on the Storage Box.

The CPU Utilizations of BOTH APP & DB Server machines has Shot UP by 25 % .

Both APP & DB Server machines have identical configuration i.e. SF15K machines , 
while previously Both used to be SF6800 machines

Thanks indeed 


P.S. Interpretations can be so different in English


-Original Message-
Sent: Tuesday, October 15, 2002 5:50 PM
To: VIVEK_SHARMA


Vivek

What's Oracle up to on this new box. Have you looked at the tuning 
options in Oracle, and particularly the tracing stuff to see what's 
happening? (ie sql_trace and tkprof).

It could be that you've got fragmented tables or indexes which is 
slowing the whole thing up, or even forgot to recreate an index when you 
moved the DB across.

-- 
Martin Hepworth
Senior Systems Administrator
Solid State Logic Ltd
+44 (0)1865 842300

VIVEK_SHARMA wrote:
> On Moving the Storage Box from a SF6800 machine to SF15000 machine CPU
> Consumption has Shot
> by 25 %
> 
> Particulars :-
> Number of CPUs on  SF6800 = 24 with 750 MHz Clock Speed
> Number of CPUs on SF15000 = 24 with 900 MHz Clock Speed
> 
> Both %usr & %sys CPU Utilization components seem to have gone up
> 
> Solaris 8
> Oracle 8.1.7.2 (+ Some Stand-Alone 1 Off patches)
> Database Size 500 GB
> Nature of Application Database = Hybrid (Banking application)
> Number of Concurrent User processes = 2500
> 
> Qs How may the Following problem be approached towards resolution ?
> Qs Is using truss Command to identify the Cause a Good approach ?
> Qs Are there any parameters / Switches which may given with the truss Command
> to get the % CPU consumed by the underlying system Calls ?
> Qs Are there any preferred parameters Specific to SF15000 ?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

RE: Password_grace_time and JDBC

[Stephen Lee]

Password aging was invented by the makers of Post-It note pads.  This
encourages greater use of the product when people, because they have to keep
changing their passwords, must write down their latest password and stick it
on their monitor.  Definitely a security enhancement.


> -Original Message-
> set up a Password_life_time of 30 days and a 
> Password_grace_time of 5 days.
>  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: designer autolayout

[Boivin, Patrice J]

For fun, check out the iDS 9i Rel 2 suite at
http://otn.oracle.com/products/ids/content.html


Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

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

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

RE: Over Consumption of CPU ?

[VIVEK_SHARMA]

Solaris 8 always Existed on Internal Disks on Both SF15K & SF6800 machines

Patch Levels same on Both SF15K & SF6800 (though I will RE-Check it)

Oracle Binaries NOT recompiled after moving the Storage Box . 
Would you advise it ?

Thanks


-Original Message-
Sent: Tuesday, October 15, 2002 10:38 PM
To: VIVEK_SHARMA


I am wondering: is Solaris on the XP512 as well or is it on internal storage on the 
SF15000?

If it is on the SF15000 itself, are the patch levels the same as what was on the 
SF6800?  and did you recompile the Oracle binaries?

Steve

-- "VIVEK_SHARMA" <[EMAIL PROTECTED]> writes:

To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
Date: Tue, 15 Oct 2002 22:17:15 +0530


The back end storage box is :-

HP Storage Box Model = XP512 
1 Volume only (RAID 5) exists across ALL the underlying Disks 
Total Number of Underlying Disks = 56
Veritas File System (VXFS) partitions Sit above the Volume (RAID 5)

Thus the hardware is a Hybrid Setup combining a SUN Machine with a HP Storage

ORACLE_HOME , Database Both Exist on the Storage Box.

NOTE - The Storage Box Continues to be the SAME . 
It has simply moved from the previous SF6800 machine to SF15K machine .

The CPU Utilizations of BOTH APP & DB Server machines has Shot UP by 25 % .

Both APP & DB Server machines have identical configuration i.e. SF15K machines , 
while previously Both used to be SF6800 machines

Thanks


-Original Message-
Sent: Tuesday, October 15, 2002 8:06 PM
To: VIVEK_SHARMA


Vivek,

Please clarify... a Sun Fire 6800 and a Sun Fire 15000 are not storage boxes - they 
are CPUS/RAM/interfaces to storage.  What is the actual back end storage (EMC, Sun 
Storage, ?)

Steve

-- "VIVEK_SHARMA" <[EMAIL PROTECTED]> writes:

To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
Date: Tue, 15 Oct 2002 17:33:02 +0530


On Moving the Storage Box from a SF6800 machine to SF15000 machine CPU Consumption has 
Shot UP
by 25 %

Particulars :-
Number of CPUs on  SF6800 = 24 with 750 MHz Clock Speed
Number of CPUs on SF15000 = 24 with 900 MHz Clock Speed

Both %usr & %sys CPU Utilization components seem to have gone up 

Solaris 8
Oracle 8.1.7.2 (+ Some Stand-Alone 1 Off patches)
Database Size 500 GB
Nature of Application Database = Hybrid (Banking application)
Number of Concurrent User processes = 2500

Qs How may the problem be approached towards resolution ?
Qs Is using truss Command to identify the Cause a Good approach ?
Qs Are there any parameters / Switches which may given with the truss Command to get 
the % CPU consumed by the underlying system Calls ? 
Qs Are there any preferred parameters Specific to SF15000 ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

RE: RE: RE: Double Take and Oracle

[Nick Wagner]

Title: RE: RE: RE: Double Take and Oracle





A little clarification


---cut---
The reasons for this are wrapped around Oracle's "write as little as needed and
do so as seldomly as possible" idea.
---end cut---


is not really true.  


When a tablespace is placed into hot backup mode, Oracle does not delay any writes to the datafiles.  It continues to write to them like nothing changed.  However, the major change (and performance hit) occurs because Oracle write more info to the redo logs.  Instead of just writing the changes for that row to the redo log, it will now write the entire database block to the redo log.  This is a reason why a lot of hot backup scripts, place only the tablespaces your are currently copying into hot backup mode.    




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 9:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: Double Take and Oracle



Eva,


    First things first, Oracle gets to be a bear when your trying to move a
database as you are while it's running.  The first point to settle is that
Double Take is not doing something that is incompatible with Oracle, like making
an ASCII vs. BINARY copy of the datafiles.  To determine that you need to do a
move with the source/production database shutdown.  Yeah, I know that can be
hard to schedule but it's necessary.  If the copy won't start at that point then
Double Take is completely incompatible with Oracle and you can't go much
further.  Now if that passes, allow Double Take to copy the production DB to the
backup server and while it's doing so check the hotbackup status of the database
using the following:


    SELECT COUNT(*)
    FROM DBA_DATA_FILES DF, SYS.V_$BACKUP B
    WHERE FILE_ID = FILE#
    AND DF.STATUS = 'AVAILABLE'
    AND B.STATUS = 'ACTIVE';


The number you get back should equal the number of datafiles in your database. 
If it comes back as 0 then the database has not switched and the backup is
worthless.  You may have to do this manually before running Double Take.  Also
your production/source DB has to be in archive log mode or else hotbackup does
not work.


The reasons for this are wrapped around Oracle's "write as little as needed and
do so as seldomly as possible" idea.  With this idea data block changes are not
sent to the datafiles until there is a need to.  MicroSlop and Exchange work on
the exact opposite idea which makes them IO hogs, although Oracle can be the
same.  In your case I would suspect that the hotbackup is the problem.


Dick Goulet


Reply Separator
Author: Denham Eva <[EMAIL PROTECTED]>
Date:   10/15/2002 7:08 AM


Thanks for the input so far. Double-Take works real time so the database is
never down.
I also followed their setup direction to the letter. Problem on our site is
that this product is being used for SQL Server and Exchange (Appears to work
fine there, but Oracle is a beast of another color compared to these "Access
on Steroids" databases), management are insisting for the sake of conformity
that this must work. At ever attempted startup another file gives an error,
most frustrating of all is that there is almost no consistency to the
errors.


Denham Eva 


-Original Message-
Sent: Tuesday, October 15, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L



Lewis,


    I can understand where Eva is coming from.  I had a demo of a similar
product some time ago.  Their BIG selling point is that you have a
production
server and a backup that is close in time with your production server at
half
(or less) the cost of a hot standby.  Their reasoning is that you don't have
Oracle running on the standby and consequently don't have to pay Oracle a
license fee for the second server since only one server is running at any
point
in time.  Logically their point is well taken.  Regrettably and
understandably
that is NOT Oracle's point of view.


Dick Goulet


Reply Separator


Author: Bishop Lewis <[EMAIL PROTECTED]>
Date:   10/15/2002 2:23 AM


I'm always dubious of these types of products (especially when there are no
reference sites available) and would opt for a batched up standby database
solution (syncing every 5/10/15 minutes or so) myself. I'm not saying
Double-Take is not good - I've got no experience of it and am sorry it's not
any help but you have an option should Double-Take not work correctly.


Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 
-Original Message-
Sent: 15 October 2002 08:28
To: Multiple recipients of list ORACLE-L


This header confirms that this email message has been swept for the
pres

TEST pls-ignore

[dcutrone]

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

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

Re: How to fix ORA-03113 error

[Tim Gorman]

Please don't "think" about whether there is I/O 
trouble -- test it.  There is no sense in eliminating possible clues based 
on hoping.  To paraphrase Thomas Edison, troubleshooting is 98% 
perspiration and 2% inspiration...
 
Please chase down *all* of the clues 
you've been provided:

  Have you attempted to read your control 
  files?  Just use the UNIX "dd" or "od" commands to make sure that a read 
  can be performed without an error...
  Have you performed the "cksum" (checksum) command 
  against all of the control files to verify that they are exactly 
  identical?
  Are there any other ".trc" files in the BDUMP 
  directory created around the same time?  What does it say?
  Are there any other ".trc" files in the UDUMP 
  directory created around the same time?
  Are there any "core" files in the CDUMP directory 
  created around the same time?
Hopefully, the first thing you did was log a TAR on 
MetaLink, right?
 
- Original Message - 
From: "Nguyen, David M" <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 9:54 
AM
Subject: RE: How to fix ORA-03113 
error
> I have oracle8.0.5 running on Solaris8.  Here's trace 
file.  I don't think> there is problem with I/O.  How do I 
recover this error?> > > $more ssdb_lgwr_272.trc> 
> Dump file 
/export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc> Oracle8 
Enterprise Edition Release 8.0.5.2.1 - Production> PL/SQL Release 
8.0.5.2.0 - Production> ORACLE_HOME = 
/export/home/oracle/product/8.0.5> System name:    
SunOS> Node name:  plab1> 
Release:    5.8> 
Version:    Generic_108528-03> 
Machine:    sun4u> Instance name: 
SSDB> Redo thread mounted by this instance: 1> Oracle process 
number: 4> Unix process pid: 272, image: ora_lgwr_SSDB> > 
*** SESSION ID:(3.1) 2002.10.13.02.19.02.000> error 204 detected in 
background process> > > > -Original 
Message-> Sent: Monday, October 14, 2002 7:58 PM> To: Multiple 
recipients of list ORACLE-L> > > Your instance crashed 
because the lgwr died...  There should be a trace file> for lgwr in 
the bdump directory...  What does it say in the trace file?  
Are> you having any filesystem issues?  The "LGWR: terminating 
instance due to> error 204" means that there is an I/O error when 
accessing the> controlfile...  What version is your 
database...  What O/S are you on...> etc...  There seems to be 
some known bugs in this area...  Check> Note:1069812.6 on 
Metalink...> > Tim> > -Original 
Message-> Sent: Monday, October 14, 2002 8:19 PM> To: Multiple 
recipients of list ORACLE-L> > > I could not start database 
due to ORA-03113 error, someone please advise> what it means and how to 
fix it ASAP.  I really appreciate your help.> > 
Thanks,> David> > > > SVRMGR> 
startup  
> ORACLE instance 
started. 
> Total System Global 
Area    
285236752 bytes  > Fixed 
Size  
48656 bytes  > Variable 
Size    
75390976 bytes  > Database 
Buffers    
209715200 bytes  > Redo 
Buffers    
81920 bytes  > Database 
mounted.    
> ORA-03113: end-of-file on communication channel    
> > > ***Alert.log:> > Mon Oct 14 17:57:27 
2002    
> Database mounted in Exclusive 
Mode. 
> Completed: alter database  
mount    
> Mon Oct 14 17:57:27 
2002    
> alter database 
open 
> Picked broadcast on commit scheme to generate 
SCNs  > Mon Oct 14 17:57:27 
2002    
> Rolling back half complete log switch of thread 
1   > LGWR: terminating instance due to 
error 
204 
> Instance terminated by LGWR, pid = 
483  
> 
    
> 
  
> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- 
> Author: Nguyen, David M>   INET: [EMAIL PROTECTED]> > 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com> San 
Diego, California    -- Mailing list and 
web hosting services> 
-> To 
REMOVE yourself from this mailing list, send an E-Mail message> to: 
[EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in> the message BODY, include a line 
containing: UNSUB ORACLE-L> (or the name of mailing list you want to be 
removed from).  You may> also send the HELP command for other 
information (like subscribing).> -- > Please see the official 
ORACLE-L FAQ: http://www.orafaq.com> -- 
> Author: Johnston, Tim>   INET: [EMAIL PROTECTED]> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com> San 
Diego, Cali

RE: CPU WAIT I/O statistic

[Pablo Rodriguez]

Dennis,
Thanks for your answers and your time.

I was interested in how the OS (Sun, AIX, HP, etc)
classifies the CPU time used by the processes.
Taking a look at the WAIT I/O statistic taken with
sar -u I started wondering what they really meant: 

ie
%usr  %sys  %wio  %idl
30 5 60 5

Does 60% (WIO column) mean that the processes actually
used 60 percent of the CPU time (while they were
waiting for I/O) ? If this is the correct answer, How
did the consume this time?

OR 

May be this means that the I/O primitives (kaio,
pwrite, write..) used the 60% of the CPU time...

OR 

it simple means that 60% of the processes that were
executed have incurred in an I/O


I Hope someone can shed some light on this.
Thanks.


___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

RE: Over Consumption of CPU ?

[Stephen Lee]

One possibility: I would think that the 15000 is capable of moving data
through memory and along the "main bus" (for want of a better term) at a
higher rate; hence the CPU's stay busier ... which is a GOOD thing (if this
is actually what is going on).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: CPU WAIT I/O statistic

[DENNIS WILLIAMS]

Pablo - You may be able to find some of the answers in Oracle and the O.S.
  - What does the O.S. I/O stats look like when you see this situation. Are
the disks about to burn off the spindles? Or are they sitting idle?
  - What do the Oracle Wait statistics look like? What are the 3 big wait
times?

Other than that, to get more specific definitions, I think you may want to
find an O.S. list and ask the system administrators and system developers.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 15, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L


Dennis,
Thanks for your answers and your time.

I was interested in how the OS (Sun, AIX, HP, etc)
classifies the CPU time used by the processes.
Taking a look at the WAIT I/O statistic taken with
sar -u I started wondering what they really meant: 

ie
%usr  %sys  %wio  %idl
30 5 60 5

Does 60% (WIO column) mean that the processes actually
used 60 percent of the CPU time (while they were
waiting for I/O) ? If this is the correct answer, How
did the consume this time?

OR 

May be this means that the I/O primitives (kaio,
pwrite, write..) used the 60% of the CPU time...

OR 

it simple means that 60% of the processes that were
executed have incurred in an I/O


I Hope someone can shed some light on this.
Thanks.


___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

[dgoulet]

Eva,

Your welcome.  Please let all of us know how things work out for future
reference.  And don't be afraid to ask for more.

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

Son of Exam Cram

[DENNIS WILLIAMS]

The following information is from Datamation:

Exam Cram Series to be Reborn as Exam Cram2

The certification group at Que Publishing has acquired and will breathe new
life into the Exam Cram series of certification preparation guides. The Exam
Cram books, popular among certification candidates preparing for exams, were
originally published by the Coriolis Group, which was shut down in April by
its majority owner Haights Cross Communications. New books in the series
will carry the name Exam Cram2. 

The first Exam Cram2 books are already listed on the QUE Web site as: 

MCSA Managing a Windows 2000 Network Environment Exam Cram2 (70-218) 
J2EE Web Component Developer Exam Cram2 (310-080) 
MCSE Windows XP Professional Exam Cram2 (70-270) 
Network+ Exam Cram2 
A+ Exam Cram2 (220-201, 220-202) 
Solaris 9 System Administrator Exam Cram2 (310-014 & 310-015) 
The first five are slated for publication in November. The Solaris 9 title
has a December publication date. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Data Purging - Approaches

[Gogala, Mladen]

One other nice thing is to use partitioning option. You
put a partition offline, you back it up and drop it. Life goes on,
you add few columns to the table and - voila , your backup tape is useless,
you cannot actually bring the partition back. A very good tool to facilitate
archiving is produced by Princeton Softech
(http://www.princetonsoftech.com).
That tool does make life a lot easier. That tool solves the incompatibility
problem.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 1:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Data Purging - Approaches
> 
> 
> I'm not a proponent of purging data.
> 
> Unless of course, you expect to never see it again.
> 
> That word 'archive' rolls of the tongues of managers
> and consultants pretty easily, but what's behind it?
> 
> There are a few gotchas with purging and archiving.
> 
> Let's assume you have some 3 year old data that 
> you need to see again, and it has been purged.
> 
> Here are some of the possible problems:
> 
> *  Your backup tapes are corrupted
> *  Your new backup hardware can't read the old tapes
> *  Your software no longer understands the format that
> the data is in.
> * You have the correct software, but it won't work on the
>current version of OS on your hardware.
> * The data format/software/whatever is not well documented
> *  The employees that understood the data 3 years ago
>have been laid off.
> * ... lots more stuff
> 
> Read Bryon Bergeron's "Dark Ages II: When the Digital Data Die"
> http://www.powells.com/cgi-bin/biblio?inkey=2-0130661074-0
> 
> Perhaps much better than archiving the data, is to stick with the
> idea of moving it to another database, and using lots of cheap
> disk storage (NAS) or a heirarchical file system to store it.
> 
> The point being that if it's online somewhere, it will be maintained.
> 
> Don't purge it till Finance, HR, the IRS and any other stakeholder
> says it's ok.  Only then purge it and archive it to offline 
> tape with the
> knowledge that you may never see that data again.
> 
> Jared
> 
> 
> 
> 
> 
> 
> 
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
>  10/15/2002 05:38 AM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L 
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Data Purging - Approaches
> 
> 
> 
> Dear List, 
> 
> We need to remove data from our database everyday, so we are 
> plannning to 
> have a scheduled process for this. But the case is that we 
> cannot simply 
> remove the data. This data has to be made available at a 
> later time if 
> required. So this is the process that we have designed. 
> 1.  The background process would first insert all the 
> required data 
> from the main database to another database. 
> 2.  Now if this successfull, it would be deleted from the main 
> database. 
> 3.  The selection criteria on which the data to be purged 
> is found is 
> a business requirement. It is based on some date, but we 
> cannot partition 
> the data based on the date, otherwise we could have done with 
> paritioning 
> and dropping the partition could have been easily done. 
> 4.  The data in the second database would be archived in a normal 
> sequence 
> 5.  If any user request for the data already purged, the 
> data would be 
> read from the second database and shown to him. 
> 
> 
> Now the issue, the data that has to be moved or deleted in such a way 
> would mount to more that 10 GB of data, so is this method a 
> good solution. 
> Can anybody suggest a better approach for doing this. 
> 
> 
> We are using Oracle 9i database, Weblogic Application server and Java 
> client. We have list partitioned our database. 
> 
> Any other data purging techniques would be greatly appreciated. 
> 
> Regards 
> Prem Chandran N 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> 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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note 

RE: designer autolayout

[Jared . Still]

This is just the stuff I've run into with a few hours work.

Supertypes/subtypes.  Creating a relation so a subtype does
not work in a suitable manner.  I ran into this last week, and don't
recall the details.  The solution was not to use super/sub types, 
though I would have preferred it.

Creating a FK relationship to table A from table B and C, where 
B and C have the same primary key.  I use PK for the primary
key on entities/tables, and assign the UID as an alternate key.

When trying to do this, ER doesn't do it properly.  It uses the same
attribute/column for the FK to both B and C.

Creating >1 relations between 2 tables using the same primary
key from the parent.  This is very common. ER doesn't like this.

I struggled with it a bit last week, don't yet have it resolved.

All of the above are quite easy in Oracle Designer.

I'll probably find more...

Jared






"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/15/2002 11:26 AM
 Please respond to ORACLE-L

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


Ok, I'll bite.  Can you name a few Designer features that ER Studio is 
missing?

I have not used either product, I am stuck with an ancient version of 
ERwin.  Mgmt almost purchased ER Studio, but then the economy, and 
business, crashed...

-Original Message-
Sent: Tuesday, October 15, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L


No.

Though I'm not currently using Designer, I've worked with it quite a bit 
in the past for data modeling.  Don't use the autolayout.

I'm currently using Embarcadero ER Studio.  If Designer wasn't such a pig, 
I would have bought it instead, and am currently wishing I had anyway.

ER Studio is very fast, but not *nearly* the tool that Designer is.

Jared






"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/15/2002 06:28 AM
 Please respond to ORACLE-L

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


Is there a way to make the autolayout feature produce a concise layout in 
Designer Entity Relationship Diagrammer?
 
Regards,
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 
Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services| Services technologiques 
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO 
E-Mail: [EMAIL PROTECTED] 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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



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

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

What happened?

[Scott Stefick]

As of 11am I have not received any email from the list.  That isn't normal 
for this group.  Being a newbie, I really learn a lot from the suggestions, 
ideas and comments from all of you.  If anyone knows what could have 
possibly happened, please email me at [EMAIL PROTECTED]

Thank you so much in advance!


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

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

Oracle DBA with Data Warehouse experience needed in San Antonio

[OraStaff]

Established company in San Antonio Texas needs an Oracle DBA with solid Data
Warehouse
experience to join its IT team.

*Candidates living in Texas will be given proirity however some relocation
assistance
may be available for the right candidate.

PLEASE Do Not send your resume for this position UNLESS you have the
qualifications for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

Requirements:
-Bachelors degree in Computer Science or related business discipline.
-Must Have several years experience as an Oracle DBA with Datawarehousing
skills. 
-Performance tuning experience.
-HPUX platform experience required.
-SQL/PLSQL skills.
-Works well in groups/teamwork a must.
-EXCELLENT communication skills.
-Oracle applications 11.0.3/11i - upgrade experience a plus.
-U.S. citizenship or permanent residency.

The base salary range depends on experience...but in the 70-75K range.
Note: San Antonio is a very low cost of living area.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/San Antonio/DBA/Data W./Vicki

ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact us if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks.

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

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

RE: iSeries Production Database

[Gogala, Mladen]

If it isn't broken, do not fix it. A good program written
in COBOL and using a TP monitor like IMS or CICS (IMS is dead
for a long time) can run circles around Java and VB alike.
We used to do IPL (reboot) of a 3084 (it was a long time ago)
once a year. No blue screen of  death, no kernel panics.
Those boxes, if maintained properly can run forever and 
do their job well. AS400 will typically outperform any fancy-schmancy
NT or Unix box, just as VAX 6460 used to do, once upon a time.
Unfortunately, Ken Olsen swed up the company and, afterwards, 
David Cutler produced the abomination that is still haunting us.


> -Original Message-
> From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 10:29 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:iSeries Production Database
> 
> 
> It is shocking to note that a lot of big shops use AS400 and 
> RPG still.
> 650,000 units are in use IBM claims. It just boggles me why. 
> Keeping legacy code
> alive perhaps since it's too expensive to migrate.
> 
> As for languages, Java is platform independent too. Actually, 
> every language
> except VB is platform independent.
> 
> On Tue, 15 Oct 2002, [EMAIL PROTECTED] wrote:
> > RPG, AS400???  Didn't they die along with Cobol and Vax/VMS?
> > 
> > Seriously the choice of platform I believe is more of a 
> business decision than
> > anything given the applications and associated software 
> that one wants to run
> > thereon.  Then the use of a language is more predicated on 
> what is available,
> > usable, and most cost effective for the platform.  Probably 
> why I happen to like
> > C.  It's almost completely platform and OS independent.
> > 
> > Dick Goulet
> > 
> > Reply Separator
> > Subject:iSeries Production Database
> > Author: Lyndon Tiu <[EMAIL PROTECTED]>
> > Date:   10/14/2002 8:58 PM
> > 
> > Hello,
> > 
> > How many people here have RPG - AS400 - iSeries in their 
> shops? Curious 
> > question: What makes your shop use the IBM iSeries?
> > 
> > Do you use RPG or SQL for your database?
> > 
> > Thank you.
> > 
> > --
> > Lyndon Tiu
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Lyndon Tiu
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Lyndon Tiu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

RE: SET ORACLE-L NOMAIL

[Gogala, Mladen]

Title: SET ORACLE-L NOMAIL



Brigitte, you need to send this command to 
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 2002 
  11:34 AMTo: Multiple recipients of list ORACLE-LSubject: 
  SET ORACLE-L NOMAIL
  SET ORACLE-L NOMAIL 
  Mit freundlichen Grüßen, 
  Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 
  Köln Tel.:+49 (0)221 223-21 88 
  eMail: [EMAIL PROTECTED] 

Can I index this query?

[Carle, William T (Bill), ALCAS]

Howdy,

I have a table that has almost 2 million rows called eventqueueentry. The layout 
looks like this:

Name  Null?Type
 -  
 EVENTID   NOT NULL NUMBER(10)
 VER   NOT NULL NUMBER(10)
 QUEUETYPE NOT NULL CHAR(16)
 PUBLISHER NOT NULL CHAR(16)
 CREATETIMENOT NULL DATE
 LASTREADTIME   DATE
 REMOVETIME DATE
 CONTENTS  NOT NULL VARCHAR2(4000)

The users do a query that looks like this:

SELECT  EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime,
  Contents, Ver
from
 EventQueueEntry  where QueueType = 'CodeUpdate' AND Contents LIKE
  '%TrackingEventId=27668677%' ORDER BY EventId

The queuetype field has only 3 different values. The value in the contents field is 
close to being unique (high cardinality) but, as you can see, they are picking off a 
value somewhere in the middle of a varchar2(4000) field. Understandably, their query 
is slow. Is there anything I can do with an index to speed this up?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

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

RE: iSeries Production Database

[Jesse, Rich]

H...it wasn't too long ago -- 5 years -- that I was talking with a
friend of a friend who ran an AS400 shop.  They rebooted nightly because of
a memory leak where they'd run out of pointers or stack space or some such
nonsense if they didn't.

Even after the leak was patched, I believe they continued the archaic
practice because a reboot "cleaned things up"!!!




Rich

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

> -Original Message-
> From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 5:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: iSeries Production Database
> 
> 
> If it isn't broken, do not fix it. A good program written
> in COBOL and using a TP monitor like IMS or CICS (IMS is dead
> for a long time) can run circles around Java and VB alike.
> We used to do IPL (reboot) of a 3084 (it was a long time ago)
> once a year. No blue screen of  death, no kernel panics.
> Those boxes, if maintained properly can run forever and 
> do their job well. AS400 will typically outperform any fancy-schmancy
> NT or Unix box, just as VAX 6460 used to do, once upon a time.
> Unfortunately, Ken Olsen swed up the company and, afterwards, 
> David Cutler produced the abomination that is still haunting us.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

Oracle DBA with Data Warehouse experience needed in Texas

[OraStaff]

Established company in San Antonio Texas needs an Oracle DBA with solid Data
Warehouse
experience to join its IT team.

*Candidates living in Texas will be given proirity however some relocation
assistance
may be available for the right candidate.

PLEASE Do Not send your resume for this position UNLESS you have the
qualifications for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

Requirements:
-Bachelors degree in Computer Science or related business discipline.
-Must Have several years experience as an Oracle DBA with Datawarehousing
skills. 
-Performance tuning experience.
-HPUX platform experience required.
-SQL/PLSQL skills.
-Works well in groups/teamwork a must.
-EXCELLENT communication skills.
-Oracle applications 11.0.3/11i - upgrade experience a plus.
-U.S. citizenship or permanent residency.

The base salary range depends on experience...but in the 70-75K range.
Note: San Antonio is a very low cost of living area.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: Employon//San Antonio/DBA/Data W./Vicki

ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact us if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks.

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

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

Access with ACCESS

[Burton, Laura L.]

Title: Access with ACCESS





How do I stop users from accessing Oracle tables with Access?  They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an access database.  Is it possible to stop this without taking their privileges to the Oracle tables away?

Thank you,

Laura

RE: How to fix ORA-03113 error

[Johnson, Michael]

I am working with Oracle right now on a similar problem
which looks to be like a network problem depending on the
versions of what you are running.   There is a bug that
was fixed in 8.1.7.3 dealing with 3113 errors.  Dont
know what version you are running, but that could
have something to do with it.

fwiw. Mike

-Original Message-
Sent: Monday, October 14, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


I could not start database due to ORA-03113 error, someone please advise
what it means and how to fix it ASAP.  I really appreciate your help.

Thanks,
David



SVRMGR> startup  
ORACLE instance started. 
Total System Global Area285236752 bytes  
Fixed Size  48656 bytes  
Variable Size75390976 bytes  
Database Buffers209715200 bytes  
Redo Buffers81920 bytes  
Database mounted.
ORA-03113: end-of-file on communication channel


***Alert.log:

Mon Oct 14 17:57:27 2002
Database mounted in Exclusive Mode. 
Completed: alter database  mount
Mon Oct 14 17:57:27 2002
alter database open 
Picked broadcast on commit scheme to generate SCNs  
Mon Oct 14 17:57:27 2002
Rolling back half complete log switch of thread 1   
LGWR: terminating instance due to error 204 
Instance terminated by LGWR, pid = 483  

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

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

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

## Keeping Skills Current

[Warkentien, Stephen]

I am looking for suggestions on how to brush up my skills and continue
learning on a regular basis.
Large blocks of "free time" are hard to come by, but if I had only 30
minutes (or an hour) a day, what would you recommend?

Thanks to all.

Stephen Warkentien 
 <<...OLE_Obj...>> 
Senior Database Administrator
Northrop Grumman Information Technology
5500 Canoga Avenue M/S W91
Woodland Hills CA 91367-6698

818-715-2860 voice
818-715-2617 FAX 



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

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

RE: Can I index this query?

[Wong, Bing]

If that content is statics, create a column that called TRACKINGEVENTID
stores 'TrackingEventId='.  Is EVENTID the same as TRACKINGEVENTID?

Partition it by QUEUETYPE so that it only goes after one patition instead
the entire table if partition does not affect other SQLs.

Bing Wong


-Original Message-
Sent: Tuesday, October 15, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L


Howdy,

I have a table that has almost 2 million rows called eventqueueentry.
The layout looks like this:

Name  Null?Type
 - 

 EVENTID   NOT NULL NUMBER(10)
 VER   NOT NULL NUMBER(10)
 QUEUETYPE NOT NULL CHAR(16)
 PUBLISHER NOT NULL CHAR(16)
 CREATETIMENOT NULL DATE
 LASTREADTIME   DATE
 REMOVETIME DATE
 CONTENTS  NOT NULL VARCHAR2(4000)

The users do a query that looks like this:

SELECT  EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime,
  Contents, Ver
from
 EventQueueEntry  where QueueType = 'CodeUpdate' AND Contents LIKE
  '%TrackingEventId=27668677%' ORDER BY EventId

The queuetype field has only 3 different values. The value in the contents
field is close to being unique (high cardinality) but, as you can see, they
are picking off a value somewhere in the middle of a varchar2(4000) field.
Understandably, their query is slow. Is there anything I can do with an
index to speed this up?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

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

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

RE: Data Purging - Approaches

[Craig Munday]

Title: RE: Data Purging - Approaches





...and when the archiving takes place, make sure that the simplest file format is chosen to store the data.  A file format that can be read with a text editor is probably a good choice - in ten years time, at least someone will be able to browse the file.

   


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 16 October 2002 3:30 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Data Purging - Approaches



I'm not a proponent of purging data.


Unless of course, you expect to never see it again.


That word 'archive' rolls of the tongues of managers
and consultants pretty easily, but what's behind it?


There are a few gotchas with purging and archiving.


Let's assume you have some 3 year old data that 
you need to see again, and it has been purged.


Here are some of the possible problems:


*  Your backup tapes are corrupted
*  Your new backup hardware can't read the old tapes
*  Your software no longer understands the format that
    the data is in.
* You have the correct software, but it won't work on the
   current version of OS on your hardware.
* The data format/software/whatever is not well documented
*  The employees that understood the data 3 years ago
   have been laid off.
* ... lots more stuff


Read Bryon Bergeron's "Dark Ages II: When the Digital Data Die"
http://www.powells.com/cgi-bin/biblio?inkey=2-0130661074-0


Perhaps much better than archiving the data, is to stick with the
idea of moving it to another database, and using lots of cheap
disk storage (NAS) or a heirarchical file system to store it.


The point being that if it's online somewhere, it will be maintained.


Don't purge it till Finance, HR, the IRS and any other stakeholder
says it's ok.  Only then purge it and archive it to offline tape with the
knowledge that you may never see that data again.


Jared








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/15/2002 05:38 AM
 Please respond to ORACLE-L


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




Dear List, 


We need to remove data from our database everyday, so we are plannning to 
have a scheduled process for this. But the case is that we cannot simply 
remove the data. This data has to be made available at a later time if 
required. So this is the process that we have designed. 
1.  The background process would first insert all the required data 
from the main database to another database. 
2.  Now if this successfull, it would be deleted from the main 
database. 
3.  The selection criteria on which the data to be purged is found is 
a business requirement. It is based on some date, but we cannot partition 
the data based on the date, otherwise we could have done with paritioning 
and dropping the partition could have been easily done. 
4.  The data in the second database would be archived in a normal 
sequence 
5.  If any user request for the data already purged, the data would be 
read from the second database and shown to him. 



Now the issue, the data that has to be moved or deleted in such a way 
would mount to more that 10 GB of data, so is this method a good solution. 
Can anybody suggest a better approach for doing this. 



We are using Oracle 9i database, Weblogic Application server and Java 
client. We have list partitioned our database. 


Any other data purging techniques would be greatly appreciated. 


Regards 
Prem Chandran N 



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