Re: Problem doing RMAN backup of Clone?

[Doug C]

Thanks to everyone .. all useful info.. this procedure worked like a charm!!
Thanks a lot!

- Dc.


On Mon, 25 Nov 2002 07:34:16 -0800, you wrote:

>Doug,
>I have successfully tested this method for changing the the dbid {gleaned
>from Ron Yount's procedure].
>
>Changing the Dbid of copied database: Ron Yount from the Oracle-L provided
>the following steps if it becomes necessary to change the Dbid of a copied
>database to allow an RMAN catalog to backup both source and target database.
>This should occur at the tail of the SAP Database Copy procedure.  [Tested
>successfully on GTS refresh 5/13/02]
>Use sqlplus to connect internal (if using sqlplus comment # must be changed
>to 'rem' or '--')
>SQL> startup nomount
>SQL> @c.sql /* create controlfile with set database & resetlogs */
>SQL> select name,dbid from v$database; (There should be a new name, but same
>dbid from step 3)
>SQL> shutdown normal
>SQL> startup mount
>SQL> exec dbms_backup_restore.zeroDbid(0);
>SQL> shutdown normal
>Rename the control files from the new instance, so they will appear to be
>missing.
>SQL> startup nomount
>SQL> @c.sql
>SQL> alter database open resetlogs;
>SQL> select name, dbid from v$database.  (There should be the new name, and
>new dbid)
>
>HTH
>
>Mike Hand
>Polaroid Corp.
>
>-Original Message-
>Sent: Sunday, November 24, 2002 10:14 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Someone has just told me you can't do an RMAN backup of a clone because it
>has
>the same database id as the original.   Is this true or not?  If so, how to
>get
>around it?
>
>Thanks,
>Doug
>**
>@@
>This transmission is intended only for use by the addressee(s) named herein and may 
>contain information that is proprietary, confidential and/or legally privileged. If 
>you are not the intended recipient, you are hereby notified that any disclosure, 
>copying, distribution, or use of the information contained herein (including any 
>reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, 
>please immediately contact the sender and destroy the material in its entirety, 
>whether in electronic or hard copy format. Thank you.  
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com


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

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

Monitoring Tool Evaluation methodology

[VIVEK_SHARMA]

We are evaluating a monitoring Tool (eGurkha) for Unix/NT/Oracle monitoring  

What features should be Looked into while Evaluating ? 
Are there any Best practices for doing this kind of Evaluation ?
Any Comments on this tool in particular by any who might have used this tool ?

eGurkha Monitoring Tool has the following Features :-

Operating System (NT / Unix)
CPU Utilization Pattern (Includes multi CPU support)
Memory / Swap / Paging pattern
Disk IO pattern per Partition
Process Limits and Monitor 
Daemon processes
Network 
Ports in use
Packets Traffic
Errors / Retries
Congestion, Network Delays

DATABASE
Status - Up / Down
Tablespace monitoring
Datafile monitoring
Locks monitoring
Session monitoring
Rollback Segment Monitoring
Memory structures monitoring
Sort Efficiency monitoring
Redo Log Monitoring
Oracle processes monitoring - CPU , Memory Utilized 

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

How to transfer data in different NLS_CHARACTER

[???]

Dear all ,

   How to transfer data from 2 oracle server with different NLS_LANG ?

NLS_LANG=Traditional Chinese_Taiwan.ZHT16BIG5
NLS_LANG=American_America.WE8ISO8859P1


Thanks in advance.
Martin Chen

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

oracle book

[Maria Aurora VT de la Vega]

Anybody read the book "Database Administration: The Complete Guide to
Practices and Procedures"
by Craig Miller?

any opinions?
i'm planning to buy it...i'd like to know if its worth it.

Thanks. =)



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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

[Rachel Carmichael]

Ferenc,

I work in the music industry, in Manhattan. There will a lot of men in
MY OFFICE who will be upset if I try to take that title from them.

:)

Rachel

--- mantfield <[EMAIL PROTECTED]> wrote:
> There will be a lot of blokes in Sydney who will be very upset if
> Rachel 
> tries to steal the title of Queen from them, goddess is much more
> apt. :-). 
> Go Rachel !
> 
> Ferenc Mantfeld
> 
> -Original Message-
> From: Babette Turner-Underwood [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 28, 2002 9:24 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: IOUG 2003
> 
> Yeah that was my thought too Rachel.
> Perhaps we have many new members on the list
> and they do not realize that your official
> and proper title is Goddess ;-)
> 
> Babette
> -Original Message-
> Carmichael
> Sent: Wednesday, November 27, 2002 1:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Queen? Is that a promotion or demotion? :)
> 
> One does not usually TEST something by releasing it to the public.
> Unless one is MS
> 
> and in earlier versions, Oracle.
> 
> :)
> 
> 
> --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> > Ah.  The Queen is ranting again.
> >
> > Confirmations have not been sent out by the IOUG as of yet.  Should
> > be
> > sometime within the next week or so.  The setup for the speakers is
> > to have
> > us test the registration and to have it ready when the
> confirmations
> > go out.
> > I would assume that registration will be comparable to last year.
> >
> > Thank You
> >
> > Stephen P. Karniotis
> > Product Architect
> > Compuware Corporation
> > Direct: (248) 865-4350
> > Mobile: (248) 408-2918
> > Email:  [EMAIL PROTECTED]
> > Web:www.compuware.com
> >
> >  -Original Message-
> > Sent:   Wednesday, November 27, 2002 10:04 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:IOUG 2003
> >
> > Okay, so I'm trying to get costs for conferences etc so my boss can
> > budget for them.
> >
> > I go to the IOUG site and look at costs for the 2003 conference. I
> > see
> > "register online" so I click on it. They have it set up for speaker
> > registration already, and ask for the email confirmation code you
> > received.
> >
> > Has anyone on this list, who submitted an abstract, actually
> RECEIVED
> > a
> > response? Either acceptance or rejection? I haven't.
> >
> > How can you set something up to allow people to register if they
> > don't
> > know which way to register?
> >
> > Sheesh. I can't even register for the University Session I want
> > because
> > I don't know what status I should use when registering.
> >
> > Rachel
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
> >
> >
> > The contents of this e-mail are intended for the named addressee
> > only. It
> > contains information that may be confidential. Unless you are the
> > named
> > addressee or an authorized designee, you may not copy or use it, or
> > disclose
> > it to anyone else. If you received it in error please notify us
> > immediately
> > and then destroy it.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Karniotis, 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).
> >
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: IOUG 2003

[Rachel Carmichael]

um "patience is a virtue and I've never been particularly virtuous" is
the one I usually use :)


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> Lord, grant me patience...RIGHT NOW!
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 11:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> yeah and I can't sign up for your session until I know how I'm
> signing
> up.
> 
> Okay, I'll try to be patient a little while longer. I'm not good at
> patience
> 
> 
> --- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> > I have heard about my university session, but not the regular
> > sessions. They
> > are scheduled to publish a schedule fairly soon, so we should be
> > finding out
> > shortly...I hope!
> > 
> > -Original Message-
> > Sent: Wednesday, November 27, 2002 8:04 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Okay, so I'm trying to get costs for conferences etc so my boss can
> > budget for them.
> > 
> > I go to the IOUG site and look at costs for the 2003 conference. I
> > see
> > "register online" so I click on it. They have it set up for speaker
> > registration already, and ask for the email confirmation code you
> > received.
> > 
> > Has anyone on this list, who submitted an abstract, actually
> RECEIVED
> > a
> > response? Either acceptance or rejection? I haven't.
> > 
> > How can you set something up to allow people to register if they
> > don't
> > know which way to register?
> > 
> > Sheesh. I can't even register for the University Session I want
> > because
> > I don't know what status I should use when registering.
> > 
> > Rachel
> > 
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.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).
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.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).
> 


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

Rachel = goddess

[mantfield]

There will be a lot of blokes in Sydney who will be very upset if Rachel 
tries to steal the title of Queen from them, goddess is much more apt. :-). 
Go Rachel !

Ferenc Mantfeld

-Original Message-
From:   Babette Turner-Underwood [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 28, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: IOUG 2003

Yeah that was my thought too Rachel.
Perhaps we have many new members on the list
and they do not realize that your official
and proper title is Goddess ;-)

Babette
-Original Message-
Carmichael
Sent: Wednesday, November 27, 2002 1:55 PM
To: Multiple recipients of list ORACLE-L


Queen? Is that a promotion or demotion? :)

One does not usually TEST something by releasing it to the public.
Unless one is MS

and in earlier versions, Oracle.

:)


--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> Ah.  The Queen is ranting again.
>
> Confirmations have not been sent out by the IOUG as of yet.  Should
> be
> sometime within the next week or so.  The setup for the speakers is
> to have
> us test the registration and to have it ready when the confirmations
> go out.
> I would assume that registration will be comparable to last year.
>
> Thank You
>
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED]
> Web:  www.compuware.com
>
>  -Original Message-
> Sent: Wednesday, November 27, 2002 10:04 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  IOUG 2003
>
> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
>
> I go to the IOUG site and look at costs for the 2003 conference. I
> see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
>
> Has anyone on this list, who submitted an abstract, actually RECEIVED
> a
> response? Either acceptance or rejection? I haven't.
>
> How can you set something up to allow people to register if they
> don't
> know which way to register?
>
> Sheesh. I can't even register for the University Session I want
> because
> I don't know what status I should use when registering.
>
> Rachel
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
> The contents of this e-mail are intended for the named addressee
> only. It
> contains information that may be confidential. Unless you are the
> named
> addressee or an authorized designee, you may not copy or use it, or
> disclose
> it to anyone else. If you received it in error please notify us
> immediately
> and then destroy it.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Karniotis, 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).
>


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

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

--
Please see the official ORA

Re: calling Oracle stored procedures from ASP/ADO

[Jay]

Not to all another reference point but if there is any place to use Oracle
Objects For OLE (oo4o).
A good reference is http://groups.yahoo.com/group/oo4ole/
This group has sample code and answers to most of the common   questions.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 4:44 PM


> I'm already in up to my neck supporting this developer.
>
> He knows next to nothing about Oracle, and it's been rather
> frustrating.  Partly my own fault, I thought he did OK in the interview
> and would pick up the Oracle differences.   Problem is, he doesn't
> seem to interested in doing so.
>
> sigh...
>
> I don't want to throw 'new' technology into the mix.
>
> Jared
>
>
>
>
>
>
> mantfield <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  11/27/2002 12:16 PM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:RE: calling Oracle stored procedures from ASP/ADO
>
>
> Why are you / he / sh using ODBC ? OO4O is far superior and can make
> native
> DB calls using OCI, etc, at least that is what the VB guru contrator I
> have
> hired tells me, and I trust him. He says that ODBC compared to OO4O is a
> POS.
>
> The code he has written for me works like a charm, calls Oracle functions
> and SP with no problems, using in, out and in/out arguments
>
> Ferenc Mantfeld
>
> -Original Message-
> Sent:Thursday, November 28, 2002 6:15 AM
> To:  Multiple recipients of list ORACLE-L
>
> Does anyone have a good example of this?
>
> We have a developer here that has been unable to
> figure out how to do this properly.  Numerous examples
> from support.microsoft.com are apparently no help.
>
> A particular problem seems to be declaring the args
> properly, as he consistently gets and 'invalid type on parameter'
> error from ODBC.
>
> Thanks,
>
> Jared
>
> --
> 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: mantfield
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.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: Jay
  INET: [EMAIL PROTECTED]

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

[Jesse, Rich]

Thanks!  I'll check them out.

Happy Thanksgiving if you're in the U.S.  If not, Happy Thursday!  :)

Rich


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


> -Original Message-
> From: Stephane Paquette [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 3:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Data Warehousing books for Oracle 9i (once again)
> 
> 
> Just to clarify.
> 
> The Oracle 8 Data Warehousing I feel that did not
> really cover what it was supposed was the one from
> Oracle Press not the one from Tim Gorman.
> 
> Tim Gorman has wrote 2 good books (maybe more ?) on DW
> : Oracle8 Data Warehousing, Essential Oracle8i Data
> Warehousing: Designing, Building, and Managing Oracle
> Data Warehouses .
-- 
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: Data Warehousing books for Oracle 9i (once again)

[Stephane Paquette]

According to Gartner, only 25% of DW are loaded using
ETL tools (Informatica, Datastage, Sagent, Data
Junction,...), that means that all the others are
loaded with good old cobol,pl/sql,...

ODBC to load ? 
Most ETL tools used ODBC to design the ETL mappings
but they're using the native DB driver to load the
data.


 --- DENNIS WILLIAMS <[EMAIL PROTECTED]> a écrit
: > Rich -
>I don't claim to be a DW expert. My impression is
> that what you have to
> do for a DW will vary widely from site to site.
> Also, much of the work may
> be done by people besides yourself, and they may
> elect to use tools besides
> Oracle.
> 
> I would consider a hierarchy of load/update tools to
> be as follows:
>   1. ODBC tools
>   2. Oracle - SQL, PL/SQL, etc.
>   3. O.S. tools
> The ODBC tools are the most convenient, and may give
> okay performance for
> small amounts of data. You probably won't be using
> them, so this means
> someone besides yourself may be doing much of the
> work. But for large data
> sets, the performance may not be adequate.
>For really large amounts of data, you may find it
> necessary to process
> data at the O.S. level before you load it into
> Oracle. For example, you
> might sort the data before loading it into Oracle.
> SyncSort makes its money
> by being faster than Oracle.
>Updating just adds more complexity and more
> variety to the tool set. You
> must select a method based on your situation.
>Bottom line, use whatever works, and the more
> tools in your tool chest
> the better.
>Next week I plan to make up a list of 9i new
> features that may be useful
> for DW, to brief my DW developers. I'll send you the
> list.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 10:20 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Yes, I know -- old topic, but a search thru the 440
> DW posts on the fatcity
> archives didn't reveal much.
> 
> Not having much of any knowledge on DW/DM, I picked
> up the Oracle Press'
> "Oracle8 Data Warehousing" book for $1 on the
> clearance rack in hopes that
> an overall view of the procedures necessary for
> DW/DM building and
> maintenance to give me some idea of what I'm up
> against.
> 
> I can't help but be completely confused by this book
> because it doesn't seem
> to cover DW/DM maintenance at all.  It has a chapter
> dedicated to various
> ways to populate the DW/DM, but not how to keep the
> data up-to-date.  Do DWs
> get completely regenerated on a
> daily/weekly/periodic basis?  This just
> doesn't seem feasible to me, especially for large
> (1T+) DWs.
> 
> Am I missing something?  Are newer revs of this book
> better?  Are there any
> better DW books geared specifically for Oracle9i? 
> Does Martha know that
> John is really her long-lost brother?
> 
> From past posts (Jared's?), I'm thinking that we'd
> be at least picking up
> Kimball's DW Toolkit, 2nd Ed. and hopefully we'll
> get some training in for
> this, too, but I would like something specific to
> DWs on Oracle 9i.
> 
> 
> TIA!  :)
> Rich
> 
> 
> Rich Jesse   System/Database
> Administrator
> [EMAIL PROTECTED]  Quad/Tech
> International, Sussex, WI USA
> 
> 
> -- 
> 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.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).
> 
>  

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

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?is

RE: logical tuning

[DENNIS WILLIAMS]

Ferenc 
   Thanks so much for providing an insight into what you do. Lawson uses
Oracle in quite a simpler method. No joins, just individual table access. No
table scans, each access is hinted to use a specific index. Crude but
effective. The first issue is that it doesn't use all of Oracle's
capabilities. The second issue is that it provides little opportunity for
Oracle tuning experts such as yourself. But customers keep pressing for
better use of Oracle, so there is hope yet. ;-)
   Based on what I've seen out of Lawson and wait statistics, I'm applying
my efforts to reducing physical I/O. I just configured several tables for
the KEEP and RECYCLE pools.

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


-Original Message-
Sent: Wednesday, November 27, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Dennis

as you know, there is no 'follow these steps to get a better performing 
application' guide when it comes to tuning. An intimate knowledge of what 
the application does is a must. I sell myself (tried the street corners but 
was not getting much intrest) as a Siebel performance tuning specialist, so 
when customers say 'Oh, you are an Oracle DBA !', I respond with 'No, 
Oracle DBA is just one of the things I do in order to get my job done'. 
there are plenty of DBA's out there, (and DBB's too), but understnading how 
the application (in my case Siebel) works and what it is trying to 
accomplish from a functional perspective helps me to know immediately what 
is the framework of limitations I can work in. For instance, Siebel is 
written for RBO, so when someone comes spouting partitions and bitmap 
indexes, I buzz them out on try 1.

now for Siebel specific EIM (Enterprise Integration Manager) type tuning , 
when I see that index range scans are killing me, I try to reduce the batch 
size first so that it will not have to go through as many records per value 
(think of a batch size of 20,000 records where it is doing a correlated 
subquery on just the batch_id). Now change this into 100 batches of 200 
rows each, and immediately you have a huge saving in logical IO, since each 
time excpet the first iteration, the index blocks and table blocks should 
be found in DBBC (Also see Cary's paper on www.hotsos.com which goes into 
deeper details on the latches needed and the recursive calls for buffer 
hits.) Other things include looking at SQL where you can see it is using an 
index to look up a row in the table to get a single value (column). In this 
case, for a large load, it may be beneficial to recreate this same index 
with the column concatenated on the end, and avoid the table lookup 
altogether. Also knowing EXACTLY how RBO works (there are only about 20 
rules and in reality only 5 or 6 get used in an application), will help you 
to know when it may even be beneficial to DROP an index (gasp ! can he be 
serious ? Youbetcha ! ). anyway, that is it for today, class dismissed.

Have a great day !

Ferenc Mantfeld

-Original Message-
From:   DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 28, 2002 3:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Using RECYCLE pool?

Thanks Denny, Connor, and Ferenc for your helpful suggestions.

Ferenc - I particularly appreciated your insights. This is also a packaged
app where I can't tune the SQL. It does no table scans (long story, but 
that
is the way this app works). My logic is that the biggest wait (85% of wait)
is "db file sequential read", and the BHR is fairly low, about 80%. So my
thought is to increase the buffer, and while I was at it, thought I would
try the KEEP and RECYCLE pools.
   But I find your comment about logical tuning very interesting. Can you
explain more, in case I'm missing something basic? Thanks.

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


-Original Message-
Sent: Tuesday, November 26, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L


Hi Dennis

I try to not think of the pool names as being descriptive of what they
should be allocated for. I regard them as pool 1 (default), of which I can
configure two other pools, (pool 2 and pool 3).

For Siebel applications (probably works similar for PSOFT [Joe, you in on
this thread ?] and SAP), knowing the application and what it does, the
repository tables, like the tables that define position based access,
views, responsibilities, position relationships (team-based visibility in
Siebel), broadcast messages, workflow rules and rule items, I put them into 
a separate smaller but very frequently accessed pool, knowing they are
going to get hit at least a few times every minute with a few hundred users 
logged on.

Then I try to identify those tables that DO get FTS, and if I cannot tune
the query by placing relevant indices (sometimes it is better to have FTS
than large index range scan to reduce logical IO, the big performance
killer), put these into a separate pool, and leave the 

Re: IOUG 2003

[Joe Testa]

Yea $125, since i wont be attending in 2003, i'm really thinking about 
unjoining at that price.

joe


Weaver, Walt wrote:

Speaking of IOUG, did anyone else get a membership renewal email recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
 Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
 


--
Please see the official ORACLE-L FAQ: http://www.orafaq.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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: IOUG 2003

[Babette Turner-Underwood]

Yeah that was my thought too Rachel.
Perhaps we have many new members on the list
and they do not realize that your official
and proper title is Goddess ;-)

Babette
-Original Message-
Carmichael
Sent: Wednesday, November 27, 2002 1:55 PM
To: Multiple recipients of list ORACLE-L


Queen? Is that a promotion or demotion? :)

One does not usually TEST something by releasing it to the public.
Unless one is MS

and in earlier versions, Oracle.

:)


--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> Ah.  The Queen is ranting again.
> 
> Confirmations have not been sent out by the IOUG as of yet.  Should
> be
> sometime within the next week or so.  The setup for the speakers is
> to have
> us test the registration and to have it ready when the confirmations
> go out.
> I would assume that registration will be comparable to last year.
> 
> Thank You
> 
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED]
> Web:  www.compuware.com
> 
>  -Original Message-
> Sent: Wednesday, November 27, 2002 10:04 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  IOUG 2003
> 
> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
> 
> I go to the IOUG site and look at costs for the 2003 conference. I
> see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
> 
> Has anyone on this list, who submitted an abstract, actually RECEIVED
> a
> response? Either acceptance or rejection? I haven't.
> 
> How can you set something up to allow people to register if they
> don't
> know which way to register?
> 
> Sheesh. I can't even register for the University Session I want
> because
> I don't know what status I should use when registering.
> 
> Rachel
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> The contents of this e-mail are intended for the named addressee
> only. It
> contains information that may be confidential. Unless you are the
> named
> addressee or an authorized designee, you may not copy or use it, or
> disclose
> it to anyone else. If you received it in error please notify us
> immediately
> and then destroy it. 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Karniotis, 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).
> 


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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Ma

RE: IOUG 2003

[James Howerton]

I paid $85 last year, which was suppose to include a hard copy of Select
Magazine, I think I got two one at IOUG and one in the mail.

...JIM... 

>>> [EMAIL PROTECTED] 11/27/02 1:26:39 PM >>>
Dues were $75.00  last year.





"Weaver, Walt" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 
 11/27/2002 07:54 AM
 Please respond to ORACLE-L

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


Speaking of IOUG, did anyone else get a membership renewal email
recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED
a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want
because
I don't know what status I should use when registering.

Rachel

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

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

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

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

RE: calling Oracle stored procedures from ASP/ADO

[Jared . Still]

I'm already in up to my neck supporting this developer.

He knows next to nothing about Oracle, and it's been rather
frustrating.  Partly my own fault, I thought he did OK in the interview
and would pick up the Oracle differences.   Problem is, he doesn't
seem to interested in doing so.

sigh...

I don't want to throw 'new' technology into the mix.

Jared






mantfield <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/27/2002 12:16 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: calling Oracle stored procedures from ASP/ADO


Why are you / he / sh using ODBC ? OO4O is far superior and can make 
native 
DB calls using OCI, etc, at least that is what the VB guru contrator I 
have 
hired tells me, and I trust him. He says that ODBC compared to OO4O is a 
POS.

The code he has written for me works like a charm, calls Oracle functions 
and SP with no problems, using in, out and in/out arguments

Ferenc Mantfeld

-Original Message-
Sent:Thursday, November 28, 2002 6:15 AM
To:  Multiple recipients of list ORACLE-L

Does anyone have a good example of this?

We have a developer here that has been unable to
figure out how to do this properly.  Numerous examples
from support.microsoft.com are apparently no help.

A particular problem seems to be declaring the args
properly, as he consistently gets and 'invalid type on parameter'
error from ODBC.

Thanks,

Jared

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

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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.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: calling Oracle stored procedures from ASP/ADO

[Jeff Herrick]

Hi Jared,

The following will work assuming you're using the Oracle OLE
DB Provider. Note that this is _not_ the same thing as
OO40 - Oracle Objects for OLE  or as I like to call
it Oracle Oily Objects  =8-)

I had a little trouble getting it going until I hard-coded
the enumerated values for datatype and command type. I'm not
an ASP whiz but it seems I'm probably just missing an include for
some ADO manifests

Cheers


Connected to:
Oracle8i Personal Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SQL> create table test_table (field1 varchar2(2000));

Table created.

SQL> create or replace procedure test_proc (param in varchar2) as
  2  begin
  3insert into test_Table values (param);
  4  end;
  5  /

ASP Code - begins




Your name: 


<%
set objConn = server.createObject("adodb.Connection")
ObjConn.ConnectionString="Provider=OraOLEDB.Oracle.1;Persist Security
Info=False;User ID=username;Password=password;Data Source=ORCL"
objConn.open

dim fname
fname=Request.QueryString("fname")
If fname<>"" Then
  set rs = Server.CreateObject("ADODB.command")
  set para = Server.CreateObject("ADODB.Parameter")

  para.Type=200
  para.Size=20
  para.Direction=1
  para.Value=fname

  rs.CommandText = "Test_Proc"
  rs.CommandType = 4
  rs.ActiveConnection = objConn
  rs.Parameters.Append para
  rs.execute

  set rs = nothing
  set para = nothing
  objConn.close
  set objConn = nothing
  Response.Write("Hello " & fname & "!")
  Response.Write("How are you today?")
End If
%>





HTH

Jeff Herrick

ps...good site is http://www.w3schools.com/ado/default.asp



On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote:

> Does anyone have a good example of this?
>
> We have a developer here that has been unable to
> figure out how to do this properly.  Numerous examples
> from support.microsoft.com are apparently no help.
>
> A particular problem seems to be declaring the args
> properly, as he consistently gets and 'invalid type on parameter'
> error from ODBC.
>
> Thanks,
>
> Jared
>
> --
> 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: Jeff Herrick
  INET: [EMAIL PROTECTED]

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

OT: Happy Thanksgiving all....

[Freeman, Robert]

Leaving the office for a very long extended vacation and to present at the
UKOUG.
Wanted to wish all the US folks here a very happy Thanksgiving. For you non
US'ers,
well, just have a great weekend...

See you on the flip side.

Robert

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. 

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

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

[Stephane Paquette]

Just to clarify.

The Oracle 8 Data Warehousing I feel that did not
really cover what it was supposed was the one from
Oracle Press not the one from Tim Gorman.

Tim Gorman has wrote 2 good books (maybe more ?) on DW
: Oracle8 Data Warehousing, Essential Oracle8i Data
Warehousing: Designing, Building, and Managing Oracle
Data Warehouses .



 --- Stephane Paquette <[EMAIL PROTECTED]> a
écrit : > Even 1$ is too much for "Oracle8 Data
Warehousing" !
> 
> We're not yet on 9i so I've not checked about that
> kind of book. 
> For DW only, check Ralph Kimball's book and the IBM
> red book site( http://www.redbooks.ibm.com/). There
> is
> an excellent document (PDF) about datawarehousing in
> general.
> The data warehouse institute
> (http://www.dw-institute.com) offers papers and
> training. 
> 
> On 8i, I can recommend Tim Gorman's book.
> 
> DW are never reorganised but updated on the
> frequency
> needed by the business needs.
> 
> HTH
> 
>  --- "Jesse, Rich" <[EMAIL PROTECTED]> a écrit
> :
> > Yes, I know -- old topic, but a search thru the
> 440
> > DW posts on the fatcity
> > archives didn't reveal much.
> > 
> > Not having much of any knowledge on DW/DM, I
> picked
> > up the Oracle Press'
> > "Oracle8 Data Warehousing" book for $1 on the
> > clearance rack in hopes that
> > an overall view of the procedures necessary for
> > DW/DM building and
> > maintenance to give me some idea of what I'm up
> > against.
> > 
> > I can't help but be completely confused by this
> book
> > because it doesn't seem
> > to cover DW/DM maintenance at all.  It has a
> chapter
> > dedicated to various
> > ways to populate the DW/DM, but not how to keep
> the
> > data up-to-date.  Do DWs
> > get completely regenerated on a
> > daily/weekly/periodic basis?  This just
> > doesn't seem feasible to me, especially for large
> > (1T+) DWs.
> > 
> > Am I missing something?  Are newer revs of this
> book
> > better?  Are there any
> > better DW books geared specifically for Oracle9i? 
> > Does Martha know that
> > John is really her long-lost brother?
> > 
> > From past posts (Jared's?), I'm thinking that we'd
> > be at least picking up
> > Kimball's DW Toolkit, 2nd Ed. and hopefully we'll
> > get some training in for
> > this, too, but I would like something specific to
> > DWs on Oracle 9i.
> > 
> > 
> > TIA!  :)
> > Rich
> > 
> > 
> > Rich Jesse  
> System/Database
> > Administrator
> > [EMAIL PROTECTED]  Quad/Tech
> > International, Sussex, WI USA
> > 
> > 
> > -- 
> > 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).
> >  
> 
> =
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> [EMAIL PROTECTED]
> 
>
__
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Stephane=20Paquette?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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 et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  INET: [EMAIL PROTECTED]

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

RE: Autoextend WAIT statistic?

[Cary Millsap]

It'll be in the book (Optimizing Oracle Response Time: O'Reilly), still
due out in about June. I'll be working on it pretty much all day, every
day through the end of December. I don't consider myself in the same
league as Lewis/Adams/Kolk/Wood/Holt/Hailey et al. in the V$ domain, but
I do at least have sense enough to ask for their assistance during
research and technical review :).


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- Hotsos Clinic 101, Jan 7-9 Knoxville
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas


-Original Message-
Sent: Wednesday, November 27, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L

I have heard from several sources that the v$ views are not as solid as
they
should be. With all the emphasis on wait and event based tuning, they
should
be more accurate. Has anyone done in-depth research on the collection
methods and accuracy of the x$ and v$ structures? Sounds like a project
for
some of the gurus on the list... 

-Original Message-
Sent: Tuesday, November 26, 2002 8:25 PM
To: Multiple recipients of list ORACLE-L


As much as the v$"wait" views are touted they do have problems.  First,
I
believe they are only updated every 3 seconds and can miss events.
Second,
examine enough samplings from the tables and you'll discover bizarre
data.
Events which managed to wait say 50 seconds in a single sampling period
when
the sampling rate was 5 Hz.  On the other hand, one may see events which
are
continuous over many samplings, but their wait times are not
incremented.

If you really want to know what's going on there's no substitute for a
10046
trace.

N.B., I am not stating the v$"wait" statistics tables are useless just
that
they have their shortcomings.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

 
  

-Original Message-
Sent: Tuesday, November 26, 2002 3:26 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I did some quick & dirty testing by creating a very small(10M)
datafile with a large(2000m) autoextend clause. On the insert, the
session
was waiting on 'file open' for most of the time. When I did a rollback
and
reinserted the data, there were no waits (that I saw) on file open.

Interestingly, this wait event does not appear to be accurately
tracked in v$session_event. In v$session_wait the seconds in wait (last
trapped) was 132. In v$session_event, it shows 0. Okay, gurus, why? Am I
missing something in this?

select * from v$session_wait where sid = 14
  SID   SEQ# EVENT
-- --

P1TEXT
P1
P1RAW

--

P2TEXT
P2
P2RAW

--

P3TEXT
P3
P3RAW WAIT_TIME SECONDS_IN_WAIT

--
 -- ---
STATE
---
14322 file open
fib
4327126592
000101EAB640
iov
4327069760
000101E9D840
0
0
00   -1 132
WAITED SHORT TIME

select * from v$session_event where sid = 14
   SID EVENT  TOTAL_WAITS TOTAL_TIMEOUTS
TIME_WAITED AVERAGE_WAIT   MAX_WAIT
-- -- --- --
---  --
14 rdbms ipc reply  4  1
210 52.5205
14 control file sequential read18  0
16   .9 15
14 local write wait 1  0
00  0
14 log buffer space72  0
124217.25 82
14 log file switch completion   6  0
250   41.667 72
14 log file sync4  0
6115.25 28
14 db file sequential read  7  0
1   .142857143  1
14 db file scattered read 164  0
152   .926829268  5
14 db file single write 2  0
1   .5  1
14 file identify4  0
00  0
14 file open6  0
00  0
14 SQL*Net message to client   41  0
00  0
14 SQL*Net message from client 40  0
67829 1695.725  19952


Dan Fink
-Original Message-
Sent: Tuesday, November 26, 2002 2:30 PM
To: Multiple recipients of list ORACLE-L


Oracle says that when a file autoextends, there is a sligh

RE: calling Oracle stored procedures from ASP/ADO

[Jared . Still]

Thanks Waleed, I've passed it on.

Jared






"Khedr, Waleed" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/27/2002 11:58 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: calling Oracle stored procedures from ASP/ADO


I found this,  I hope it helps, I will need this also some time soon:


http://groups.google.com/groups?q=stored%2Bprocedure%2Boracle%2Bado%2Bparame
ters&start=20&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=%23Q%23RLKqACHA.2228%40tkmsft
ngp02&rnum=21

-Original Message-
Sent: Wednesday, November 27, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L


Does anyone have a good example of this?

We have a developer here that has been unable to
figure out how to do this properly.  Numerous examples
from support.microsoft.com are apparently no help.

A particular problem seems to be declaring the args
properly, as he consistently gets and 'invalid type on parameter'
error from ODBC.

Thanks,

Jared

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




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

Cursor column name

[Kader Ben]

Hi listers,

  Can someone tell me how to get column's name using
cursor.

Thanks in advance,

Kader


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

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

[Khedr, Waleed]

I was told the OO4O is very rich and very slow.
Do not know if it's true.

Waleed

-Original Message-
Sent: Wednesday, November 27, 2002 3:16 PM
To: Multiple recipients of list ORACLE-L


Why are you / he / sh using ODBC ? OO4O is far superior and can make native 
DB calls using OCI, etc, at least that is what the VB guru contrator I have 
hired tells me, and I trust him. He says that ODBC compared to OO4O is a 
POS.

The code he has written for me works like a charm, calls Oracle functions 
and SP with no problems, using in, out and in/out arguments

Ferenc Mantfeld

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 28, 2002 6:15 AM
To: Multiple recipients of list ORACLE-L
Subject:calling Oracle stored procedures from ASP/ADO

Does anyone have a good example of this?

We have a developer here that has been unable to
figure out how to do this properly.  Numerous examples
from support.microsoft.com are apparently no help.

A particular problem seems to be declaring the args
properly, as he consistently gets and 'invalid type on parameter'
error from ODBC.

Thanks,

Jared

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

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

RE: calling Oracle stored procedures from ASP/ADO

[mantfield]

Why are you / he / sh using ODBC ? OO4O is far superior and can make native 
DB calls using OCI, etc, at least that is what the VB guru contrator I have 
hired tells me, and I trust him. He says that ODBC compared to OO4O is a 
POS.

The code he has written for me works like a charm, calls Oracle functions 
and SP with no problems, using in, out and in/out arguments

Ferenc Mantfeld

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 28, 2002 6:15 AM
To: Multiple recipients of list ORACLE-L
Subject:calling Oracle stored procedures from ASP/ADO

Does anyone have a good example of this?

We have a developer here that has been unable to
figure out how to do this properly.  Numerous examples
from support.microsoft.com are apparently no help.

A particular problem seems to be declaring the args
properly, as he consistently gets and 'invalid type on parameter'
error from ODBC.

Thanks,

Jared

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

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

RE: logical tuning

[mantfield]

Dennis

as you know, there is no 'follow these steps to get a better performing 
application' guide when it comes to tuning. An intimate knowledge of what 
the application does is a must. I sell myself (tried the street corners but 
was not getting much intrest) as a Siebel performance tuning specialist, so 
when customers say 'Oh, you are an Oracle DBA !', I respond with 'No, 
Oracle DBA is just one of the things I do in order to get my job done'. 
there are plenty of DBA's out there, (and DBB's too), but understnading how 
the application (in my case Siebel) works and what it is trying to 
accomplish from a functional perspective helps me to know immediately what 
is the framework of limitations I can work in. For instance, Siebel is 
written for RBO, so when someone comes spouting partitions and bitmap 
indexes, I buzz them out on try 1.

now for Siebel specific EIM (Enterprise Integration Manager) type tuning , 
when I see that index range scans are killing me, I try to reduce the batch 
size first so that it will not have to go through as many records per value 
(think of a batch size of 20,000 records where it is doing a correlated 
subquery on just the batch_id). Now change this into 100 batches of 200 
rows each, and immediately you have a huge saving in logical IO, since each 
time excpet the first iteration, the index blocks and table blocks should 
be found in DBBC (Also see Cary's paper on www.hotsos.com which goes into 
deeper details on the latches needed and the recursive calls for buffer 
hits.) Other things include looking at SQL where you can see it is using an 
index to look up a row in the table to get a single value (column). In this 
case, for a large load, it may be beneficial to recreate this same index 
with the column concatenated on the end, and avoid the table lookup 
altogether. Also knowing EXACTLY how RBO works (there are only about 20 
rules and in reality only 5 or 6 get used in an application), will help you 
to know when it may even be beneficial to DROP an index (gasp ! can he be 
serious ? Youbetcha ! ). anyway, that is it for today, class dismissed.

Have a great day !

Ferenc Mantfeld

-Original Message-
From:   DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 28, 2002 3:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Using RECYCLE pool?

Thanks Denny, Connor, and Ferenc for your helpful suggestions.

Ferenc - I particularly appreciated your insights. This is also a packaged
app where I can't tune the SQL. It does no table scans (long story, but 
that
is the way this app works). My logic is that the biggest wait (85% of wait)
is "db file sequential read", and the BHR is fairly low, about 80%. So my
thought is to increase the buffer, and while I was at it, thought I would
try the KEEP and RECYCLE pools.
   But I find your comment about logical tuning very interesting. Can you
explain more, in case I'm missing something basic? Thanks.

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


-Original Message-
Sent: Tuesday, November 26, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L


Hi Dennis

I try to not think of the pool names as being descriptive of what they
should be allocated for. I regard them as pool 1 (default), of which I can
configure two other pools, (pool 2 and pool 3).

For Siebel applications (probably works similar for PSOFT [Joe, you in on
this thread ?] and SAP), knowing the application and what it does, the
repository tables, like the tables that define position based access,
views, responsibilities, position relationships (team-based visibility in
Siebel), broadcast messages, workflow rules and rule items, I put them into 
a separate smaller but very frequently accessed pool, knowing they are
going to get hit at least a few times every minute with a few hundred users 
logged on.

Then I try to identify those tables that DO get FTS, and if I cannot tune
the query by placing relevant indices (sometimes it is better to have FTS
than large index range scan to reduce logical IO, the big performance
killer), put these into a separate pool, and leave the rest in default.
Alternatively, the hot smaller tables go into one pool, the indices in
another and the rest of the tables stay in default. There are various
tricks for this. Oracle 9 makes things easier because you can identify
which indexes are beig used, and then not waste your time with the others.

Just remember, you will get much further distance from reducing logical
IO's than playing with various buffer pools, though there is a minimal
argument for playing with buffer pools, once logical IO's have been
decreased.

Real-life example : using Siebel EIM, by placing EIM tables into separate
buffer pools, I saw a small advantage, say 5 - 10 % in buffer cache latch
reduction and more efficient use of cached IO. But after tuning the
structures so that I reduced logical IO's, I saw a 2000% throughput
improvement of EIM, to the amaze

Re: Mass updates to production tables (NULL to non-NULL)

[Jonathan Lewis]

Try using dbms_xplan with SQL_TRACE switched
on - the query it runs against the plan_table is
very interesting.  It includes code to pick up the
plan of the recursive SQL that Oracle uses to
populate temporary tables during (e.g. star
transformations, subquery factoring).


Regards

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

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

Denver___December 2/4
England__January 21/23


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





-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 27 November 2002 02:27


>Yes you can, but I still like to see it in action with my own eyes to
verify
>;-) Another cool thing that came of all this is that I wasn't aware
of the
>"select * from table(dbms_xplan.display());" used by 9iR2. I play
with the
>9i's off and on when I have time, but not dealing with 9iR2 (or R1)
on a
>daily basis I had no idea about the DBMS_XPLAN package in 9iR2.
>
>Regards,
>
>Larry G. Elkins
>[EMAIL PROTECTED]
>214.954.1781
>


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

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

Re: Autoextend WAIT statistic?

[Jonathan Lewis]

Dan,

Your sample from v$session_wait is showing
the state as "WAITED SHORT TIME", this
means the 132 'seconds in wait' is actually -
132 seconds since the "open file" wait ended
and  (in theory) the CPU has been thrashing
away ever since.

seconds in wait is only measuring wait time
(to a 3 second granularity - except in a set
of 8.1.6 NT databases I was looking at today)
whilst the state is WAITING.


Regards

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

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

Denver___December 2/4
England__January 21/23


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





-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 27 November 2002 00:36


>Dennis,
> I did some quick & dirty testing by creating a very small(10M)
>datafile with a large(2000m) autoextend clause. On the insert, the
session
>was waiting on 'file open' for most of the time. When I did a
rollback and
>reinserted the data, there were no waits (that I saw) on file open.
>
> Interestingly, this wait event does not appear to be accurately
>tracked in v$session_event. In v$session_wait the seconds in wait
(last
>trapped) was 132. In v$session_event, it shows 0. Okay, gurus, why?
Am I
>missing something in this?
>
>select * from v$session_wait where sid = 14
>  SID   SEQ# EVENT
>-- --
>
>P1TEXT
P1
>P1RAW
> 
--
>
>P2TEXT
P2
>P2RAW
> 
--
>
>P3TEXT
P3
>P3RAW WAIT_TIME SECONDS_IN_WAIT
> 
--
> -- ---
>STATE
>---
>14322 file open
>fib
4327126592
>000101EAB640
>iov
4327069760
>000101E9D840
>0
0
>00   -1 132
>WAITED SHORT TIME
>


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

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

RE: Open Source Security Comes Under Fire

[Fink, Dan]

Ah, what do we know... According to Microsoft, we are just glorified Order
Clerks...

"You want users with that database?"
"For another $1.00, I can Supersize that datafile."

-Original Message-
Sent: Wednesday, November 27, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L


Patrice - Amazing how these things happen. A few weeks ago a report listed
Microsoft products as among the worst security risks. Microsoft immediately
attacked the report. Then by an amazing coincidence, an "impartial"
organization releases a report stating that Microsoft's greatest competitor,
the "free" people, are actually the greatest security risk. 
Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry
hired the private eye to get some proof that they were just shills for
Microsoft, and the guy was caught dumpster diving?



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 27, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


FYI.
 
 
http://www.eweek.com/article2/0,3959,720533,00.asp

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: 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: 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: calling Oracle stored procedures from ASP/ADO

[Khedr, Waleed]

I found this,  I hope it helps, I will need this also some time soon:


http://groups.google.com/groups?q=stored%2Bprocedure%2Boracle%2Bado%2Bparame
ters&start=20&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=%23Q%23RLKqACHA.2228%40tkmsft
ngp02&rnum=21

-Original Message-
Sent: Wednesday, November 27, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L


Does anyone have a good example of this?

We have a developer here that has been unable to
figure out how to do this properly.  Numerous examples
from support.microsoft.com are apparently no help.

A particular problem seems to be declaring the args
properly, as he consistently gets and 'invalid type on parameter'
error from ODBC.

Thanks,

Jared

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

RE: Autoextend WAIT statistic?

[Fink, Dan]

I have heard from several sources that the v$ views are not as solid as they
should be. With all the emphasis on wait and event based tuning, they should
be more accurate. Has anyone done in-depth research on the collection
methods and accuracy of the x$ and v$ structures? Sounds like a project for
some of the gurus on the list... 

-Original Message-
Sent: Tuesday, November 26, 2002 8:25 PM
To: Multiple recipients of list ORACLE-L


As much as the v$"wait" views are touted they do have problems.  First, I
believe they are only updated every 3 seconds and can miss events.  Second,
examine enough samplings from the tables and you'll discover bizarre data.
Events which managed to wait say 50 seconds in a single sampling period when
the sampling rate was 5 Hz.  On the other hand, one may see events which are
continuous over many samplings, but their wait times are not incremented.

If you really want to know what's going on there's no substitute for a 10046
trace.

N.B., I am not stating the v$"wait" statistics tables are useless just that
they have their shortcomings.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

 
  

-Original Message-
Sent: Tuesday, November 26, 2002 3:26 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I did some quick & dirty testing by creating a very small(10M)
datafile with a large(2000m) autoextend clause. On the insert, the session
was waiting on 'file open' for most of the time. When I did a rollback and
reinserted the data, there were no waits (that I saw) on file open.

Interestingly, this wait event does not appear to be accurately
tracked in v$session_event. In v$session_wait the seconds in wait (last
trapped) was 132. In v$session_event, it shows 0. Okay, gurus, why? Am I
missing something in this?

select * from v$session_wait where sid = 14
  SID   SEQ# EVENT
-- --

P1TEXT   P1
P1RAW
 --

P2TEXT   P2
P2RAW
 --

P3TEXT   P3
P3RAW WAIT_TIME SECONDS_IN_WAIT
 --
 -- ---
STATE
---
14322 file open
fib  4327126592
000101EAB640
iov  4327069760
000101E9D840
0 0
00   -1 132
WAITED SHORT TIME

select * from v$session_event where sid = 14
   SID EVENT  TOTAL_WAITS TOTAL_TIMEOUTS
TIME_WAITED AVERAGE_WAIT   MAX_WAIT
-- -- --- --
---  --
14 rdbms ipc reply  4  1
210 52.5205
14 control file sequential read18  0
16   .9 15
14 local write wait 1  0
00  0
14 log buffer space72  0
124217.25 82
14 log file switch completion   6  0
250   41.667 72
14 log file sync4  0
6115.25 28
14 db file sequential read  7  0
1   .142857143  1
14 db file scattered read 164  0
152   .926829268  5
14 db file single write 2  0
1   .5  1
14 file identify4  0
00  0
14 file open6  0
00  0
14 SQL*Net message to client   41  0
00  0
14 SQL*Net message from client 40  0
67829 1695.725  19952


Dan Fink
-Original Message-
Sent: Tuesday, November 26, 2002 2:30 PM
To: Multiple recipients of list ORACLE-L


Oracle says that when a file autoextends, there is a slight delay. Does
anyone know which Oracle WAIT statistic that would appear under?
  We have been using autoextend on OLTP production tables for awhile now,
and the results have been satisfactory. This is an ERP system, so the
critical performance time is at month-end. Some of the developers are
concerned that table autoextending may slow batch programs, and sugge

Re: Oracle OS level security

[Stephane Faroult]

Very nicely put, Dan. I was thinking about words which have deserted
modern vocabulary, such as 'duty' or 'virtue' (in the Latin sense).
Somewhere along the line you have to trust people.


> 
> Dennis,
> I must respectfully disagree with 1. I would suggest that the 'can'
> be changed to a 'cannot'. It is this type of person that will stand up and
> say 'This is wrong.' Therein lies your security.
> 
> Dan Fink
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 7:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> Jared - I think Thomas has a good point. Here is the way I look at it:
> 
> 1. Make the server with critical information as secure as possible.
> 2. Restrict command line or console access to the minimum number of people.
> This narrows you down to a few sys admins and DBAs. For them your choices
> are:
> 1. Hire trustworthy professionals, people that can be intimidated by the
> threat of being fired.
> 2. Hire people too stupid to understand how to break into stuff.
> 3. Configure a really paranoid system to keep the people that must manage
> the system from being able to do their job. You could spend a lot of extra
> effort on this one. And it would have to be designed and audited by people
> outside the company.
>Years ago, a company I worked for tried option 3. It was a mainframe
> system with no interactive access. There were three groups of people that
> worked there, keypunch operators, programmers, and computer operators. The
> theory was that to defraud the system would require more than one person. A
> programmer could write a bogus program, but couldn't run it, would need an
> operator. And so on. They even had a separate building entrance for each
> group. Nobody outside of management seemed to think it was all that secure.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 7:14 AM
> To: Multiple recipients of list ORACLE-L
> 
> Jared,
> 
> Nice question.  I don't have an answer, but a comment.
> 
> It all comes down to Risk Management.  In my opinion, Risk Management
> entails identifying all known risks to losing or changing data in an
> authorized manner.  Once the risks are identified and explained to the
> organization, they decide what needs to be dealt with and what they are
> willing to "risk" based on the probability of the event actually happening.
> 
> In your example, you've identified the risk of allowing other people admin
> access on the database server machine.  If management is unwilling to revoke
> these privs, then they need to understand the risk that they have accepted.
> The risk they've accepted is that someone could, thru the use of stolen
> passwords, the BBED editor, or simply deleting a database file, cause a
> disruption, loss of service or loss of data to the organization.  And there
> is not much you (as the DBA) can do about it.
> 
> I'm sure I'm preaching to the choir here.  But a lot of what we (DBA's) do
> comes down to communication and education of management, and explaining
> things in terms that they can understand.
> 
> Hope this helps.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> -Original Message-
> Sent: Tuesday, November 26, 2002 6:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> Dear list,
> 
> Let me toss a hypothetical situation at you.
> 
> Say some auditors looked at some of your primary systems,
> and concluded that they had no assurance that someone with
> admin access to the server had not changed financial information
> to benefit themselves, or to falsify financial records for the
> gain of the company.
> 
> Not that they might have any proof that something like that
> had been done, but rather, just not proof that it had *not*
> been done.
> 
> I've been pondering this for a bit, and it seems to me that if
> someone had good knowledge of both the OS and the
> database (Oracle), as well as having admin rights on the
> server, there are few things you can do to prevent such a person
> from changing data in the database, and completely
> covering his or her tracks.
> 
> The platforms in question are Unix, Windows NT and
> Windows 2000.   I've limited it to those as most database
> systems use one of those, and besides, that's all I know.  :)
> 
> Consider what steps you might take to audit unauthorized
> transactions performed by an admin.
> 
> Oracle Auditing could be used, but someone with admin
> access to the server and database could easily alter the
> records created by system auditing.
> 
> You could create an audit table, using a trigger to audit
> sensitive tables.  A materialized view on a remote database
> could be created on sensitive tables to remotely log all
> actions.
> 
> In the case of the audit table, that could easily be disabled,
> and then re-enabled after the nefarious DML had completed.
> 
> The materialized views might be more difficult to circumvent.
> 
> If the remote en

RE: Open Source Security Comes Under Fire

[Boivin, Patrice J]

Ziff-Davis, did they own PC Magazine?

I am still annoyed at their coverage of OS/2...

Pat.

-Original Message-
Sent: Wednesday, November 27, 2002 3:27 PM
To: Multiple recipients of list ORACLE-L


Go figure.  This was published on a ZiffDavis news site.  ZD is either
majority or wholly owned by Microsoft.  Do you suppose there might be a
bit of a slant there?

Rodd Holman

On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote:
> Patrice - Amazing how these things happen. A few weeks ago a report listed
> Microsoft products as among the worst security risks. Microsoft
immediately
> attacked the report. Then by an amazing coincidence, an "impartial"
> organization releases a report stating that Microsoft's greatest
competitor,
> the "free" people, are actually the greatest security risk. 
> Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry
> hired the private eye to get some proof that they were just shills for
> Microsoft, and the guy was caught dumpster diving?
> 
> 
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 8:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> FYI.
>  
>  
> http://www.eweek.com/article2/0,3959,720533,00.asp
> 
> 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


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

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

[Rachel Carmichael]

they'll both be here in two weeks, I'm selling tickets to the fight now
:)


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> You best be careful, Jared. You KNOW how uptight and evil Tim can be!
> :)
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 9:56 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Oh boy, is my face red!
> 
> I remembered that of course, as soon  as I saw this.
> 
> I need to keep better track of who I'm plagierizing.  :)
> Jared
> 
> 
> 
> 
> 
> 
> "Cary Millsap" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  11/26/2002 03:05 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: LGWR using lots of CPU time, low CPU
> usage
> 
> 
> The ultimate sincerest form of flattery is for someone to attribute
> something smart to you that you wish you had done but, alas, did not
> actually do.
> 
> (It was Tim Gorman who posted the excellent analogy.)
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - Hotsos Clinic 101, Jan 7-9 Knoxville
> - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
> - 2003 Hotsos Symposium, Feb 9-12 Dallas
> 
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, November 26, 2002 4:07 PM
> To: Multiple recipients of list ORACLE-L
> 
> > >And "old school" is still right about not putting RedoLogs onto
> RAID5.
> 
> > From what I'm being told, this is not your father's RAID5.  This is
> what 
> 
> >they tell me:
> 
> > The CPU hands the IO to the disk controller and rather than do the
> > physical disk IO while the process waits, the disk controller
> caches
> > it to local memory and says done.  Therefore, effectively there is
> no
> > wait for IO and it doesn't matter if we are RAID 5 or RAID 0+1,
> > the system is NOT waiting for the IO. He said the only time there
> might
> > be a delay is during the cache's battery refresh times. I checked
> your
> > dates and it was not occurring during those times. Also, if you
> look
> > at the iostat statistics under the 'wait' and '%w' headers you will
> > see all zeros.
> 
> Debi, 
> 
> That is true, up to a point.
> 
> Think of the cache as a water tank.  You have a garden hose
> filling up the tank.  You can keep increasing the water
> pressure for a while.
> 
> But the outlet at the other end of the tank has a fixed
> capacity.  It flows 10 GPM, and no more.
> 
> What happens when you increase the flow at the intake to
> 20 GPM?
> 
> The tank fills up. 
> 
> When the tank fills up, your intake flow will need to decrease,
> because you can only flow 10 GPM at the outlet.
> 
> Now, think of the outlet as writing to disk, the RAID5 cache
> is the water tank, and your database is the inlet that wants
> to run at 20 GPM.
> 
> If your database activity will never be intensive enough to 
> stress the cache like this, no problem.  But 'never' is a
> very long time.
> 
> If any of this sound familiar, Cary Millsap posted a very similar
> explanation a few weeks ago.
> 
> Plagierism is the sincerest form of flattery.  :)
> 
> Jared
> 
> 
> -- 
> 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: Cary Millsap
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 EXAC

RE: IOUG 2003

[Jared . Still]

Dues were $75.00  last year.





"Weaver, Walt" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/27/2002 07:54 AM
 Please respond to ORACLE-L

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


Speaking of IOUG, did anyone else get a membership renewal email recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

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

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

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

[Stephen Lee]

-Original Message-
I am wondering how your sites handle patching production servers.


We make a copy of the existing product directory structure using tar
(everyone else) or cpio (me) before installing the patch.

For example:
cd /path/path/product/8.1.7
find . -print | cpio -pvmud /some/backup/directory
-- 
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: Open Source Security Comes Under Fire

[Rodd Holman]

Go figure.  This was published on a ZiffDavis news site.  ZD is either
majority or wholly owned by Microsoft.  Do you suppose there might be a
bit of a slant there?

Rodd Holman

On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote:
> Patrice - Amazing how these things happen. A few weeks ago a report listed
> Microsoft products as among the worst security risks. Microsoft immediately
> attacked the report. Then by an amazing coincidence, an "impartial"
> organization releases a report stating that Microsoft's greatest competitor,
> the "free" people, are actually the greatest security risk. 
> Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry
> hired the private eye to get some proof that they were just shills for
> Microsoft, and the guy was caught dumpster diving?
> 
> 
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 8:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> FYI.
>  
>  
> http://www.eweek.com/article2/0,3959,720533,00.asp
> 
> 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


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

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

RE: IOUG 2003

[Fink, Dan]

Lord, grant me patience...RIGHT NOW!

-Original Message-
Sent: Wednesday, November 27, 2002 11:55 AM
To: Multiple recipients of list ORACLE-L


yeah and I can't sign up for your session until I know how I'm signing
up.

Okay, I'll try to be patient a little while longer. I'm not good at
patience


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> I have heard about my university session, but not the regular
> sessions. They
> are scheduled to publish a schedule fairly soon, so we should be
> finding out
> shortly...I hope!
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 8:04 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
> 
> I go to the IOUG site and look at costs for the 2003 conference. I
> see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
> 
> Has anyone on this list, who submitted an abstract, actually RECEIVED
> a
> response? Either acceptance or rejection? I haven't.
> 
> How can you set something up to allow people to register if they
> don't
> know which way to register?
> 
> Sheesh. I can't even register for the University Session I want
> because
> I don't know what status I should use when registering.
> 
> Rachel
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.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).
> 


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

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

[DENNIS WILLIAMS]

Dave - Good to hear from a fellow-sufferer. It suddenly occurs to me that if
the war on terrorism continues, the feds may mandate something like 10CFR
for computer security. I recall that 10CFR was adapted from something
earlier. Whew boy, I can hardly wait.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 27, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


NRC audits, boy those sure are fun to be on the receiving end of.  Nothing
like getting comfy on the couch and reading 10CFR for pleasure.

-Original Message-
Sent: Wednesday, November 27, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L


Jared - I would be very careful about naming specific tools. Having been an
NRC auditor and been audited a lot of times, there is sometimes too much
specific information, which will leave the auditor with the impression there
is no security at all. They will then feel obligated to "flunk" your
system/process/site, or at least give you a ton or corrective action items.
If you feel heavily obligated, you might allude to the fact that an expert
could access the Oracle data at the O.S. level if they were very determined
and leave it at that. I'm sure there are some O.S. tools that can accomplish
what BBED can, if not as conveniently.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  

-Original Message-
Sent: Wednesday, November 27, 2002 8:09 AM
To: Multiple recipients of list ORACLE-L



Hadn't even considered BBED, and I have no idea
what their take is on it. 

Guess I'll have to ask.

Jared

On Tuesday 26 November 2002 16:09, K Gopalakrishnan wrote:
> Jared:
>
> Any one with a reasonable knowledge of Oracle Data Storage
> Internals can use the Data block Editor (BBED) to update
> anything in your database without the knowledge of the
> RDBMS kernel auditing mechanisms.
>
> Agreed,BBED is protected by a password in Windoze ports
> and one need to explicitly make the executable in Unix
> ports. But the point here is the hacker can do anything
> using the BBEd and this can be done even while your
> database is up and running !!
>
> What is their take on this kind of attack(!)s?>
>
>
> Best Regards,
> K Gopalakrishnan
>
>
>
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, November 26, 2002 3:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear list,
>
> Let me toss a hypothetical situation at you.
>
> Say some auditors looked at some of your primary systems,
> and concluded that they had no assurance that someone with
> admin access to the server had not changed financial information
> to benefit themselves, or to falsify financial records for the
> gain of the company.
>
> Not that they might have any proof that something like that
> had been done, but rather, just not proof that it had *not*
> been done.
>
> I've been pondering this for a bit, and it seems to me that if
> someone had good knowledge of both the OS and the
> database (Oracle), as well as having admin rights on the
> server, there are few things you can do to prevent such a person
> from changing data in the database, and completely
> covering his or her tracks.
>
> The platforms in question are Unix, Windows NT and
> Windows 2000.   I've limited it to those as most database
> systems use one of those, and besides, that's all I know.  :)
>
> Consider what steps you might take to audit unauthorized
> transactions performed by an admin.
>
> Oracle Auditing could be used, but someone with admin
> access to the server and database could easily alter the
> records created by system auditing.
>
> You could create an audit table, using a trigger to audit
> sensitive tables.  A materialized view on a remote database
> could be created on sensitive tables to remotely log all
> actions.
>
> In the case of the audit table, that could easily be disabled,
> and then re-enabled after the nefarious DML had completed.
>
> The materialized views might be more difficult to circumvent.
>
> If the remote end is using a dblink to the server employing a
> password that is *different* than that of it's own account at the
> remote server, it should be impossible for someone to completely
> cover the traces of transactions created to falsify data.
>
> The MV  Logs could be dropped, but without access to the MV's
> at the remote server, the MV's would have to be left in place.
>
> These could be used as a reference to look for unauthorized transactions
> in the primary server.  If this same admin has access to the remote
> server where the MV's are, then this can also be circumvented.
>
> There is also the logs created as when logging in as internal
> or sysdba. ( $ORACLE_HOME/rdms/audit/*.aud )
>
> These can simply be deleted.  Some system could be used to save
> these to a remote server, but it would have to run *very* frequently to
> be effective.
>
> Oracle password files could also be used. While this can prevent
> someone from logging in as SYS or SYSTEM 

Re: Oracle 8.1.6 Installation error

[Jared . Still]

Ahsoke,

8.0 and 8.1 are versions.

8.1.6 and 8.1.7 are releases of the same version.

Given that, I'm surprised the installer is complaining.

I installed both 8.1.6 and 8.1.7 on an NT server 2 weeks ago, no problems.

You should be able to put as many copies of any version you want
on a Solaris box. 

IIRC, full OFA compliance requires a separate ORACLE_HOME for
each app on a machine.

Maybe an installer problem?  Just guessing, I've never run into that.

Have you tried MetaLink?

Jared






"Mandal, Ashoke" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/27/2002 09:18 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle 8.1.6 Installation error


Greetings,

I was trying to install oracle 8.1.6 on a Sun Solaris(2.7) box.

But I get an error saying that you cannot install 8.1.6 when you have 
already installed 8.1.7 in this box.

I was under impression that you can install a lower version of Oracle in 
the same box.

Could you please confirm this.

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

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

[Jared . Still]

Chris,

Upgrading to 7.3.4.5, if possible, would be a good move.

We have 4 database here on NT with 7.3.4.5, no problems
in 18 months.

Jared





"Bowes, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/27/2002 08:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:NT Memory Leak 7.3.4


Hi, 
Does anyone know of a memory leak for Oracle 7.3.4.0 on Windows NT 
4.0?  A friend of mine is having to reboot monthly as the oracle73.exe 
grows to all of the memory on the machine when the SGA is pegged at 40M. 
As of today, the Oracle73.exe was at 210M and growing.  They will be 
rebooting today.  I know that the Oraclexx.exe starts less than the SGA 
and grows as it is used, but I haven't seen it go beyond the SGA settings. 
 I have told him he needs to upgrade to 7.3.4.4 or 7.3.4.5.  Is this good 
advice (they cannot go to 8)?  Thank you in advance.
--Chris 


-- 
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: is it possible ?

[Richard Ji]

It's possible on Unix I think.  But there are so many things you need to
consider.
o  You won't able to use your oratab file and therefore all the scripts
Oracle
supplied, dbhome, oraenv, dbshut, dbstart etc.
o  You might need to use two listeners.

But why would you want to do this?  Are you trying to produce a test
environment
on your prod or development server?  Or you merely want to try things?  Is
there
any reason you don't want to change the SID?

Seems to me, it not worth the trouble to do it, and it might cause you many
troubles if you do it.

Regards,

Richard Ji


-Original Message-
Sent: Wednesday, November 27, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L



Is it possible For 2 Databases to be Brought up on the SAME machine with the
SAME ORACLE_SID 
from Different ORACLE_HOMEs ?

If so , how ?

Thanks

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

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

RE: Oracle OS level security

[Fink, Dan]

Excellent point.

I always say, "I know enough NOT to be dangerous." Funny, two comments that
are syntactically opposite, really mean the same thing.

-Original Message-
Sent: Wednesday, November 27, 2002 11:45 AM
To: Multiple recipients of list ORACLE-L


You may just possibly be the only other DBA besides me who does NOT
want root access!

I know just enough to be dangerous. I have more than enough work to do
without taking over the SA's job as well. 

theoretical point 2:

yes, you should trust your DBAs and SAs. But if you, for whatever
reason, have to have a temporary person in, someone you don't know, who
leaves and is not reachable/accountable, then it behooves you to put
some sort of controls in place. perhaps just logging each session so
that what is done can be seen, without making it so onerous that people
try to circumvent the rules.

We have a hosting company here for our staging and production servers.
I have an account on both servers. They have not, as yet, changed the
database passwords (we're in the process of going live and they haven't
set up a read-only account for me). I *could* go in and fix the
problems. That would be the fast way, and the users certainly would
appreciate it.

I follow the rules. Submit change requests, with scripts attached. It's
safer all around.



--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> Jared,
>   I realize the following is not really an answer, but it may provide
> a little food for thought.
> 
>   Practical:
>   1. Log miner or other log reading tool could be used to track
> changes made through the transaction layer. Some operations can be
> done with
> nologging, but not all and the undo is logged regardless. Yes, it
> would be
> complicated and messy.
>   2. If you don't trust the SAs and DBAs for the systems, they need to
> be replaced. You are absolutely correct that if a person has the
> knowledge
> and motive, almost anything is possible. This is shown time and time
> again
> by corporate embezzlement.
>   3. As a DBA, I never want to know root's password. If I need SA
> type
> commands, either use sudo on unix (not sure if there is an equivalent
> on
> NT/2K) or provide exact information to the SA. I work on maintaining
> a good
> relationship with the SAs so we each respect each other's 'turf' and
> don't
> try to do things we are not qualified to do.
>   4. Changing passwords frequently, especially system generated ones,
> leads to people writing them down or otherwise storing them somewhere
> they
> can be accessed. I wonder how many of us have 1 password (with minor
> variations) for the overwhelming majority of our systems/logins.
>   5. Don't make security so onerous and inconvenient that people are
> constantly looking for ways around it just so that they can do their
> job.
> This encourages the creation of security holes and a general
> disregard for
> the processes and procedures.
>   6. If you create a server no admins have access to, how would it be
> set up and maintained?
> 
>   Theoretical
>   The only truly secure system is the one that is never turned on.
> Once power is applied and the system is started, it can be
> compromised. An
> SA can su - oracle and login as sysdba, a DBA can spoof a user, a
> developer
> could insert malicious code. 
>   I think that the issue is to create and abide by standards and
> processes, hire trustworthy personnel and treat them right.
>   As has been shown recently here in the US, there are significant
> business risks from unethical, greedy people. How are these
> prevented?
> 
> Dan Fink
> 
> -Original Message-
> Sent: Tuesday, November 26, 2002 4:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dear list,
> 
> Let me toss a hypothetical situation at you.
> 
> Say some auditors looked at some of your primary systems,
> and concluded that they had no assurance that someone with
> admin access to the server had not changed financial information
> to benefit themselves, or to falsify financial records for the
> gain of the company.
> 
> Not that they might have any proof that something like that 
> had been done, but rather, just not proof that it had *not*
> been done.
> 
> I've been pondering this for a bit, and it seems to me that if
> someone had good knowledge of both the OS and the 
> database (Oracle), as well as having admin rights on the
> server, there are few things you can do to prevent such a person
> from changing data in the database, and completely 
> covering his or her tracks.
> 
> The platforms in question are Unix, Windows NT and
> Windows 2000.   I've limited it to those as most database
> systems use one of those, and besides, that's all I know.  :)
> 
> Consider what steps you might take to audit unauthorized
> transactions performed by an admin.
> 
> Oracle Auditing could be used, but someone with admin 
> access to the server and database could easily alter the 
> records created by system auditing.
> 

patches

[Boivin, Patrice J]

Title: Pro*C for Oracle 817 on Win2000?



I am 
wondering how your sites handle patching production servers.
 
I just 
did a search in MetaLink, since 8174 was released there have been 48 patches (if 
I just select RDBMS).
 
If I 
select other items in my search, I get upwards of 70 additional bug 
fixes.
 
How do 
high reliability sites handle patching?  I assume they would rather fix 
potential problems (testing the patches on a testbed of course) rather than just 
apply bug fixes as problems are encountered on production 
servers.
 
regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA) 
 

RE: IOUG 2003

[Ari Kaplan]

Rachel and everyone,

As a follow-up, speaker notifications have not gone out yet for IOUG Live!
2003.  They are scheduled to email the week of December 9.  If you submitted
an abstract, IOUG suggests that you wait until mid-December to register for
the conference.  At that time, you'll know the status of your submission.
The early-bird rates will still apply at that time.  If you have further
questions, please call HQ at 312-245-1579 and they will be happy to assist
you.

Thanks and Happy Thanksgiving!

-Ari Kaplan
-Original Message-
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 10:03 AM


> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
>
> I go to the IOUG site and look at costs for the 2003 conference. I see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
>
> Has anyone on this list, who submitted an abstract, actually RECEIVED a
> response? Either acceptance or rejection? I haven't.
>
> How can you set something up to allow people to register if they don't
> know which way to register?
>
> Sheesh. I can't even register for the University Session I want because
> I don't know what status I should use when registering.
>
> Rachel
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

[Fink, Dan]

You best be careful, Jared. You KNOW how uptight and evil Tim can be! :)

-Original Message-
Sent: Wednesday, November 27, 2002 9:56 AM
To: Multiple recipients of list ORACLE-L


Oh boy, is my face red!

I remembered that of course, as soon  as I saw this.

I need to keep better track of who I'm plagierizing.  :)
Jared






"Cary Millsap" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/26/2002 03:05 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: LGWR using lots of CPU time, low CPU usage


The ultimate sincerest form of flattery is for someone to attribute
something smart to you that you wish you had done but, alas, did not
actually do.

(It was Tim Gorman who posted the excellent analogy.)


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- Hotsos Clinic 101, Jan 7-9 Knoxville
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 4:07 PM
To: Multiple recipients of list ORACLE-L

> >And "old school" is still right about not putting RedoLogs onto
RAID5.

> From what I'm being told, this is not your father's RAID5.  This is
what 

>they tell me:

> The CPU hands the IO to the disk controller and rather than do the
> physical disk IO while the process waits, the disk controller caches
> it to local memory and says done.  Therefore, effectively there is no
> wait for IO and it doesn't matter if we are RAID 5 or RAID 0+1,
> the system is NOT waiting for the IO. He said the only time there
might
> be a delay is during the cache's battery refresh times. I checked your
> dates and it was not occurring during those times. Also, if you look
> at the iostat statistics under the 'wait' and '%w' headers you will
> see all zeros.

Debi, 

That is true, up to a point.

Think of the cache as a water tank.  You have a garden hose
filling up the tank.  You can keep increasing the water
pressure for a while.

But the outlet at the other end of the tank has a fixed
capacity.  It flows 10 GPM, and no more.

What happens when you increase the flow at the intake to
20 GPM?

The tank fills up. 

When the tank fills up, your intake flow will need to decrease,
because you can only flow 10 GPM at the outlet.

Now, think of the outlet as writing to disk, the RAID5 cache
is the water tank, and your database is the inlet that wants
to run at 20 GPM.

If your database activity will never be intensive enough to 
stress the cache like this, no problem.  But 'never' is a
very long time.

If any of this sound familiar, Cary Millsap posted a very similar
explanation a few weeks ago.

Plagierism is the sincerest form of flattery.  :)

Jared


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

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

RE: is it possible ?

[Jeff Herrick]

On earlier (Unix) versions the SID was used to hash a value
for the shared memory segment identifier. If this still is
the case then what you are asking is _NOT_ possible. V7 even
had a length of SID restriction...but that is long gone. There
were even cases of 2 different SID's hashing to the same
ident and causing problemsbut I haven't heard of that one
in a long time.

HTH

Jeff Herrick

On Wed, 27 Nov 2002, Stephen Lee wrote:

> > -Original Message-
> > Is it possible For 2 Databases to be Brought up on the SAME
> > machine with the SAME ORACLE_SID
> > from Different ORACLE_HOMEs ?
> >
> > If so , how ?
>
> It would seem so.  Listener setup might be a bit dicey.  I might have to try
> this.  It seems that as long as you had separate environments, it should
> work ... we're talking Unix here right?
> --

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

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

calling Oracle stored procedures from ASP/ADO

[Jared . Still]

Does anyone have a good example of this?

We have a developer here that has been unable to
figure out how to do this properly.  Numerous examples
from support.microsoft.com are apparently no help.

A particular problem seems to be declaring the args
properly, as he consistently gets and 'invalid type on parameter'
error from ODBC.

Thanks,

Jared

-- 
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: IOUG 2003

[Weaver, Walt]

I remember it being $75 too.

--Walt

-Original Message-
Sent: Wednesday, November 27, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L


I did.  Wasn't the renewal $75 last year, or am I dating myself?  

If so, a 67% increase is pretty substantial to me.

Brian

-Original Message-
Walt
Sent: Wednesday, November 27, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L

Speaking of IOUG, did anyone else get a membership renewal email
recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

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

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

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

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

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

[Rachel Carmichael]

I script and test as well. But sometimes you can't think of every
possible problem.

My point wasn't to have a contest of who had worse problems or who had
a problem that the other didn't.

merely that sometimes hardware mirroring is not the be-all/end-all
solution. 

We all could swap war stories for hours. But I need a beer before I
start that, that's thirsty work :)


--- Stephen Lee <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > have you NEVER accidentally, at 3AM, after having been woken from a
> > sound sleep to a crisis that needs to be fixed RIGHT NOW,  
> > made a typo?
> > 
> 
> Actually no.  But we usually script our actions and test the scripts
> prior
> to doing anything in production.  As a sys admin, I've restored
> enough
> casualties of the "rm -rf *" command to be rather careful about it
> myself.
> 
> > Um, I have.
> 
> I was wondering if anyone had.  But I could turn this around too and
> give an
> example of when duplexing the redos failed to save me.  One so-called
> patch
> that Compaq released for Tru64 actually caused disk writes to be
> unreliable
> (OH MY GOD!!).  And we wound up with a G.D. mess in spite of the
> redos being
> duplexed all nice and official.
> -- 
> 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).
> 


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

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

RE: IOUG 2003

[Rachel Carmichael]

Queen? Is that a promotion or demotion? :)

One does not usually TEST something by releasing it to the public.
Unless one is MS

and in earlier versions, Oracle.

:)


--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> Ah.  The Queen is ranting again.
> 
> Confirmations have not been sent out by the IOUG as of yet.  Should
> be
> sometime within the next week or so.  The setup for the speakers is
> to have
> us test the registration and to have it ready when the confirmations
> go out.
> I would assume that registration will be comparable to last year.
> 
> Thank You
> 
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED]
> Web:  www.compuware.com
> 
>  -Original Message-
> Sent: Wednesday, November 27, 2002 10:04 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  IOUG 2003
> 
> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
> 
> I go to the IOUG site and look at costs for the 2003 conference. I
> see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
> 
> Has anyone on this list, who submitted an abstract, actually RECEIVED
> a
> response? Either acceptance or rejection? I haven't.
> 
> How can you set something up to allow people to register if they
> don't
> know which way to register?
> 
> Sheesh. I can't even register for the University Session I want
> because
> I don't know what status I should use when registering.
> 
> Rachel
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> The contents of this e-mail are intended for the named addressee
> only. It
> contains information that may be confidential. Unless you are the
> named
> addressee or an authorized designee, you may not copy or use it, or
> disclose
> it to anyone else. If you received it in error please notify us
> immediately
> and then destroy it. 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Karniotis, 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).
> 


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

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

Re:The future DBAs?

[Rachel Carmichael]

where were you when I needed you? You left NY is where.

We have been using data modelers here. Of course, we've gone through 3
completely different versions of the model, from a generic one to a
hybrid to a relational one.

I think we're done for the moment. :)

Rachel

--- Martin Bonner <[EMAIL PROTECTED]> wrote:
> I'm a data modeler at heart... that's about 90% of what the military
> used 
> me for. Unfortunately, it seems that, at least in this area, when the
> 
> economy turns sour, the designers are the first to go.
> 
> In my last interview, I was told that they didn't really have enough
> work 
> for a full time DBA yet, so the position would also likely be used as
> a 
> sysad, a network engineer, a junior programmer, etc...  I suppose
> data 
> modelers are dead for the moment. Please contradict me. Please
> 
> Marty
> 
> At 02:19 PM 11/26/2002 -0800, you wrote:
> >Personally, I like Data Architecture.
> >
> >And data modeling.  I never could get enough
> >of that.  The hard part is explaining to people that
> >don't quite understand the concept.
> >
> >Dave Hay rules!
> >http://www.amazon.com/exec/obidos/tg/detail/-/0932633293
> >
> >Being the sole DBA for the company, I don't get
> >nearly enough opportunities for this anymore, and
> >don't have the time for much of it anyway.
> >
> >Jared
> >
> >
> >
> >
> >
> >[EMAIL PROTECTED]
> >Sent by: [EMAIL PROTECTED]
> >  11/26/2002 10:04 AM
> >  Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:
> > Subject:Re:The future DBAs?
> >
> >
> >Well, I give MicroSlop pretty poor grades for predicting the future
> and
> >Monster.com is absolutely useless (naw make that less than) at job
> stuff
> >in
> >general.  I will agree with the person who wrote the article on one
> point.
> >  The
> >job of being a DBA is changing and we all need to remain flexible to
> >remain
> >useful in the marketplace.  That in some cases means spreading our
> wings
> >from
> >the historical role of DBA.  We may need to become part time (or
> full
> >time) data
> >architects, reporting tool experts, etc...  But in the end, I don't
> see us
> >degrading to the level of an order entry clerk nor order entry
> clerks
> >upgrading
> >to DBA's.  As usual the MicroSlop propaganda machine is at work
> again.
> >
> >Dick Goulet
> >
> >Reply Separator
> >Author: "Arup Nanda" <[EMAIL PROTECTED]>
> >Date:   11/25/2002 5:48 PM
> >
> >Fellow DBAs and other DBA wannabes,
> >
> >Ever wondered the best path into a DBA career? Microsoft offers a
> >brilliant
> >way. MSN Careers at
> http://editorial.careers.msn.com/articles/nofuture/
> >suggests some jobs are effectively dead, like farmers and sewing
> machine
> >operators and how the experts in that field can progress to the next
> >logical
> >career move. Guess which profession's logical career move is
> database
> >administrator? See the excerpt from the webpage here in the
> attachment as
> >a
> >picture.
> >
> >I just couldn't resist posting it here. May be they are referring to
> SQL
> >Server DBAs?
> >
> >Arup Nanda
> >
> >
> >
> >
> >
> >
> >
> >_
> >The new MSN 8: advanced junk mail protection and 2 months FREE*
> >http://join.msn.com/?page=features/junkmail
> >
> >
> >
> >
> >--
> >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).
> 
> Marty
> "All of life's big problems include the words 'indictment' or
> 'inoperable.'
>   Everything else is small stuff." -
>-Alton Brown, host, 'Good Eats'
> 


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

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

Is Oracle Text PATH_SECTION_GROUP incompatible with highlighting?

[Michael Garfield Sørensen]

 
 
The Oracle Text Reference for 9iR2 says that the INPATH 
operator (that is only available for PATH_SECTION_GROUPs) does not work 
with highlighting - and when you try it out, you get an error message - FAIR 
ENOUGH. The manual does however not say whether highlighting is compatible with 
PATH_SECTION_GROUP when using the WITHIN operator. When you try it out it does 
NOT give an error message. But it seems to give the wrong result (which is worse 
than giving an error message). Are highlighting and PATH_SECTION_GROUP 
incompatiable regardless of operator (or is it a bug)??
 
Example is given below. Any help is appreciated.
 
Regards,
Michael Garfield Sørensen, CeDeT
 
 
Example (Oracle9iR2 9.0.2.1 EE on  
Windows2000 Professional SP3 (DK)):
 
SQL> connect 
system/***Forbindelsen er oprettet.SQL> grant ctxapp to 
scott;
 
Adgang er givet (Grant).
 
SQL> connect scott/*Forbindelsen 
er oprettet.SQL> CREATE TABLE my_content(  2    
normid  VARCHAR2(255) NOT NULL,  3    content CLOB 
NOT NULL,  4    CONSTRAINT my_content_pk PRIMARY 
KEY(normid))  5  LOB(content) STORE AS (CACHE);
 
Tabel er oprettet.
 
SQL> SQL> BEGIN  
2    
ctx_ddl.create_section_group('my_content_sg','PATH_SECTION_GROUP');  
3    --   4  END;  5  /
 
PL/SQL-procedure er udført.
 
SQL> SQL> CREATE INDEX 
my_content_ix ON my_content(content)  2    INDEXTYPE IS 
ctxsys.context  3    PARAMETERS('SECTION GROUP 
my_content_sg');
 
Indeks er oprettet.
 
SQL> SQL> INSERT INTO 
my_content(normid,content)  2  VALUES('d1','  3  Born in England in the townStratford Upon 
Avon  4  It was the 
best of times.  5  ...  6  
');
 
1 række er oprettet.
 
SQL> SQL> BEGIN  
2    ctx_ddl.sync_index('scott.my_content_ix');  3  
END;  4  /
 
PL/SQL-procedure er udført.
 
SQL> SQL> ANALYZE TABLE 
my_content COMPUTE STATISTICS;
 
Tabel er analyseret.
 
SQL> SQL> COLUMN normid FORMAT 
a20SQL> PROMPT INPATH worksINPATH worksSQL> SELECT /*+ 
FIRST_ROWS */ normid,SCORE(1) FROM my_content  2  WHERE 
CONTAINS(content,'Stratford INPATH(BOOK)',1)>0  3   ORDER 
BY SCORE(1) DESC;
 
NORMID 
SCORE(1)    
--d1    
3    
    
 
SQL> PROMPT WITHIN worksWITHIN 
worksSQL> SELECT /*+ FIRST_ROWS */ normid,SCORE(1) FROM 
my_content  2   WHERE CONTAINS(content,'Stratford WITHIN 
BOOK',1)>0  3   ORDER BY SCORE(1) DESC;
 
NORMID 
SCORE(1) 
--    
d1    
3    
 
SQL> SQL> SET SERVEROUTPUT ON 
SIZE 100;SQL> PROMPT INPATH with highlighting does not 
work!INPATH with highlighting does not work!SQL> DECLARE  
2    h_tab ctx_doc.highlight_tab;  3  
BEGIN  4    
ctx_doc.highlight('MY_CONTENT_IX','d1','Stratford 
INPATH(BOOK)',h_tab,FALSE);  5    
DBMS_OUTPUT.PUT_LINE(h_tab.COUNT);  6    FOR i IN 
1..h_tab.COUNT LOOP  7  
DBMS_OUTPUT.PUT_LINE('Highlight('||i||'):Offset='||h_tab(i).offset||',Length='||h_tab(i).length);  
8    END LOOP;  9  END; 10  
/DECLARE*FEJL i linie 1:ORA-2: Oracle Text-fejl: 
ORA-06512: ved "CTXSYS.DRUE", linje 157 ORA-06512: ved "CTXSYS.CTX_DOC", 
linje 914 ORA-06512: ved linje 4 
 
SQL> SQL> PROMPT WITHIN with highlighting seems to be supposed 
to work - butdoes it?WITHIN with highlighting seems to be supposed to 
work - but does it?SQL> DECLARE  2    h_tab 
ctx_doc.highlight_tab;  3  BEGIN  4    
ctx_doc.highlight('MY_CONTENT_IX','d1','Stratford WITHIN 
BOOK',h_tab,FALSE);  5    DBMS_OUTPUT.PUT_LINE('This 
should be 1, but it is:');  6    
DBMS_OUTPUT.PUT_LINE('');  
7    DBMS_OUTPUT.PUT_LINE(h_tab.COUNT);  
8    
DBMS_OUTPUT.PUT_LINE('');  
9    FOR i IN 1..h_tab.COUNT 
LOOP 10  
DBMS_OUTPUT.PUT_LINE('Highlight('||i||'):Offset='||h_tab(i).offset||',Length='||h_tab(i).length); 11    
END LOOP; 12  END; 13  /This should be 1, but it 
is:    
    
0   
    

 
PL/SQL-procedure er udført.
 
 

RE: Oracle OS level security

[Richard Ji]

Just a thought.

How about also encrypt the sensitive data.  And the one who holds the
key to decrypt it doesn't have access to the system.  And the one does
have access doesn't know the key to decrypt.  The two will have to
work together to do un-authorized things, but at least it will make it
harder.  Don't introduce them, ever. :)

Richard Ji

-Original Message-
Sent: Wednesday, November 27, 2002 11:20 AM
To: Multiple recipients of list ORACLE-L


Let's face it.  The SA's have all the privs in the world.

Finally, with 9i, and connect internal going away, we can prevent
unauthorized connections to the database to prevent data snooping.  But we
all know that there are ways around everything in this world.  

It comes down to this simple point:  
The organization has to trust someone with the keys to the treasury.  It is
unavoidable.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, November 27, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


True, and the question suggests the DBA can be properly vetted while the
system administator cannot.   I suppose one could try somne type of two-man
control.  Jared  and his system administrator each know a different half of
the root and sysdba passwordJust how this could be setup is beyond my
ken.   Responses to database emergencies  would be interesting.

If one could implement a system which would fully protect the database from
system administrators, one would also need to weigh the costs of that
protection against the perceived gain.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


  



-Original Message-
Sent: Wednesday, November 27, 2002 5:14 AM
To: Multiple recipients of list ORACLE-L


Jared,

Nice question.  I don't have an answer, but a comment.

It all comes down to Risk Management.  In my opinion, Risk Management
entails identifying all known risks to losing or changing data in an
authorized manner.  Once the risks are identified and explained to the
organization, they decide what needs to be dealt with and what they are
willing to "risk" based on the probability of the event actually happening.

In your example, you've identified the risk of allowing other people admin
access on the database server machine.  If management is unwilling to revoke
these privs, then they need to understand the risk that they have accepted.
The risk they've accepted is that someone could, thru the use of stolen
passwords, the BBED editor, or simply deleting a database file, cause a
disruption, loss of service or loss of data to the organization.  And there
is not much you (as the DBA) can do about it.

I'm sure I'm preaching to the choir here.  But a lot of what we (DBA's) do
comes down to communication and education of management, and explaining
things in terms that they can understand.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 26, 2002 6:05 PM
To: Multiple recipients of list ORACLE-L


Dear list,

Let me toss a hypothetical situation at you.

Say some auditors looked at some of your primary systems,
and concluded that they had no assurance that someone with admin access to
the server had not changed financial information to benefit themselves, or
to falsify financial records for the gain of the company.

Not that they might have any proof that something like that 
had been done, but rather, just not proof that it had *not* been done.

I've been pondering this for a bit, and it seems to me that if someone had
good knowledge of both the OS and the 
database (Oracle), as well as having admin rights on the server, there are
few things you can do to prevent such a person from changing data in the
database, and completely 
covering his or her tracks.

The platforms in question are Unix, Windows NT and
Windows 2000.   I've limited it to those as most database
systems use one of those, and besides, that's all I know.  :)

Consider what steps you might take to audit unauthorized transactions
performed by an admin.

Oracle Auditing could be used, but someone with admin 
access to the server and database could easily alter the 
records created by system auditing.

You could create an audit table, using a trigger to audit sensitive tables.
A materialized view on a remote database could be created on sensitive
tables to remotely log all actions.

In the case of the audit table, that could easily be disabled, and then
re-enabled after the nefarious DML had completed.

The materialized views might be more difficult to circumvent.

If the remote end is using a dblink to the server employing a 
password that is *different* than that of it's own account at the 
remote server, it should be impossible for someone to completely cover the
traces of transactions created to falsify data.

The MV  Logs could be dropped, but without access to the MV's at the remote
server, the MV's would have to be left in place. 

These could be used

RE: Oracle OS level security

[Farnsworth, Dave]

NRC audits, boy those sure are fun to be on the receiving end of.  Nothing like 
getting comfy on the couch and reading 10CFR for pleasure.

-Original Message-
Sent: Wednesday, November 27, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L


Jared - I would be very careful about naming specific tools. Having been an
NRC auditor and been audited a lot of times, there is sometimes too much
specific information, which will leave the auditor with the impression there
is no security at all. They will then feel obligated to "flunk" your
system/process/site, or at least give you a ton or corrective action items.
If you feel heavily obligated, you might allude to the fact that an expert
could access the Oracle data at the O.S. level if they were very determined
and leave it at that. I'm sure there are some O.S. tools that can accomplish
what BBED can, if not as conveniently.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  

-Original Message-
Sent: Wednesday, November 27, 2002 8:09 AM
To: Multiple recipients of list ORACLE-L



Hadn't even considered BBED, and I have no idea
what their take is on it. 

Guess I'll have to ask.

Jared

On Tuesday 26 November 2002 16:09, K Gopalakrishnan wrote:
> Jared:
>
> Any one with a reasonable knowledge of Oracle Data Storage
> Internals can use the Data block Editor (BBED) to update
> anything in your database without the knowledge of the
> RDBMS kernel auditing mechanisms.
>
> Agreed,BBED is protected by a password in Windoze ports
> and one need to explicitly make the executable in Unix
> ports. But the point here is the hacker can do anything
> using the BBEd and this can be done even while your
> database is up and running !!
>
> What is their take on this kind of attack(!)s?>
>
>
> Best Regards,
> K Gopalakrishnan
>
>
>
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, November 26, 2002 3:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear list,
>
> Let me toss a hypothetical situation at you.
>
> Say some auditors looked at some of your primary systems,
> and concluded that they had no assurance that someone with
> admin access to the server had not changed financial information
> to benefit themselves, or to falsify financial records for the
> gain of the company.
>
> Not that they might have any proof that something like that
> had been done, but rather, just not proof that it had *not*
> been done.
>
> I've been pondering this for a bit, and it seems to me that if
> someone had good knowledge of both the OS and the
> database (Oracle), as well as having admin rights on the
> server, there are few things you can do to prevent such a person
> from changing data in the database, and completely
> covering his or her tracks.
>
> The platforms in question are Unix, Windows NT and
> Windows 2000.   I've limited it to those as most database
> systems use one of those, and besides, that's all I know.  :)
>
> Consider what steps you might take to audit unauthorized
> transactions performed by an admin.
>
> Oracle Auditing could be used, but someone with admin
> access to the server and database could easily alter the
> records created by system auditing.
>
> You could create an audit table, using a trigger to audit
> sensitive tables.  A materialized view on a remote database
> could be created on sensitive tables to remotely log all
> actions.
>
> In the case of the audit table, that could easily be disabled,
> and then re-enabled after the nefarious DML had completed.
>
> The materialized views might be more difficult to circumvent.
>
> If the remote end is using a dblink to the server employing a
> password that is *different* than that of it's own account at the
> remote server, it should be impossible for someone to completely
> cover the traces of transactions created to falsify data.
>
> The MV  Logs could be dropped, but without access to the MV's
> at the remote server, the MV's would have to be left in place.
>
> These could be used as a reference to look for unauthorized transactions
> in the primary server.  If this same admin has access to the remote
> server where the MV's are, then this can also be circumvented.
>
> There is also the logs created as when logging in as internal
> or sysdba. ( $ORACLE_HOME/rdms/audit/*.aud )
>
> These can simply be deleted.  Some system could be used to save
> these to a remote server, but it would have to run *very* frequently to
> be effective.
>
> Oracle password files could also be used. While this can prevent
> someone from logging in as SYS or SYSTEM while in place, all it
> takes is a change to init.ora, and a database bounce to fix that.
>
> Make your bogus data changes, change the init.ora back and
> bounce the database again.
>
> A somewhat clever person could set this up to automatically
> take place the next time the DB is bounced.
>
> The conclusion I have come to is that the only effective method
> that could be used to create an audit trail for such a scenario is

RE: IOUG 2003

[Rachel Carmichael]

yeah and I can't sign up for your session until I know how I'm signing
up.

Okay, I'll try to be patient a little while longer. I'm not good at
patience


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> I have heard about my university session, but not the regular
> sessions. They
> are scheduled to publish a schedule fairly soon, so we should be
> finding out
> shortly...I hope!
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 8:04 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
> 
> I go to the IOUG site and look at costs for the 2003 conference. I
> see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
> 
> Has anyone on this list, who submitted an abstract, actually RECEIVED
> a
> response? Either acceptance or rejection? I haven't.
> 
> How can you set something up to allow people to register if they
> don't
> know which way to register?
> 
> Sheesh. I can't even register for the University Session I want
> because
> I don't know what status I should use when registering.
> 
> Rachel
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.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).
> 


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

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

RE: IOUG 2003

[Brian McGraw]

I did.  Wasn't the renewal $75 last year, or am I dating myself?  

If so, a 67% increase is pretty substantial to me.

Brian

-Original Message-
Walt
Sent: Wednesday, November 27, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L

Speaking of IOUG, did anyone else get a membership renewal email
recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

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

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

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

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

Re: IOUG 2003

[Rachel Carmichael]

Arup,

thanks. I'm just trying to plan.. and give my boss info for budgets!

Rachel

--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> I inquired the same with IOUG Conference Committee and here is the
> response
> from Julie Ferry.
> 
>  START OF MESSAGE <<<
> - Original Message -
> To: '[EMAIL PROTECTED]'
> Sent: Tuesday, November 05, 2002 2:26 PM
> 
> Hi Arup,
> Speaker notifications will be send out the second week of December. 
> All
> speakers that submitted an abstract for Live! will receive a message
> regardless of whether or not they were accepted.
> 
> Thanks.
> 
> Julie
>  END OF MESSAGE 
> Hope this helps.
> Arup
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 27, 2002 10:03 AM
> 
> 
> > Okay, so I'm trying to get costs for conferences etc so my boss can
> > budget for them.
> >
> > I go to the IOUG site and look at costs for the 2003 conference. I
> see
> > "register online" so I click on it. They have it set up for speaker
> > registration already, and ask for the email confirmation code you
> > received.
> >
> > Has anyone on this list, who submitted an abstract, actually
> RECEIVED a
> > response? Either acceptance or rejection? I haven't.
> >
> > How can you set something up to allow people to register if they
> don't
> > know which way to register?
> >
> > Sheesh. I can't even register for the University Session I want
> because
> > I don't know what status I should use when registering.
> >
> > Rachel
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Arup Nanda
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


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

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

RE: Oracle OS level security

[Rachel Carmichael]

You may just possibly be the only other DBA besides me who does NOT
want root access!

I know just enough to be dangerous. I have more than enough work to do
without taking over the SA's job as well. 

theoretical point 2:

yes, you should trust your DBAs and SAs. But if you, for whatever
reason, have to have a temporary person in, someone you don't know, who
leaves and is not reachable/accountable, then it behooves you to put
some sort of controls in place. perhaps just logging each session so
that what is done can be seen, without making it so onerous that people
try to circumvent the rules.

We have a hosting company here for our staging and production servers.
I have an account on both servers. They have not, as yet, changed the
database passwords (we're in the process of going live and they haven't
set up a read-only account for me). I *could* go in and fix the
problems. That would be the fast way, and the users certainly would
appreciate it.

I follow the rules. Submit change requests, with scripts attached. It's
safer all around.



--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> Jared,
>   I realize the following is not really an answer, but it may provide
> a little food for thought.
> 
>   Practical:
>   1. Log miner or other log reading tool could be used to track
> changes made through the transaction layer. Some operations can be
> done with
> nologging, but not all and the undo is logged regardless. Yes, it
> would be
> complicated and messy.
>   2. If you don't trust the SAs and DBAs for the systems, they need to
> be replaced. You are absolutely correct that if a person has the
> knowledge
> and motive, almost anything is possible. This is shown time and time
> again
> by corporate embezzlement.
>   3. As a DBA, I never want to know root's password. If I need SA
> type
> commands, either use sudo on unix (not sure if there is an equivalent
> on
> NT/2K) or provide exact information to the SA. I work on maintaining
> a good
> relationship with the SAs so we each respect each other's 'turf' and
> don't
> try to do things we are not qualified to do.
>   4. Changing passwords frequently, especially system generated ones,
> leads to people writing them down or otherwise storing them somewhere
> they
> can be accessed. I wonder how many of us have 1 password (with minor
> variations) for the overwhelming majority of our systems/logins.
>   5. Don't make security so onerous and inconvenient that people are
> constantly looking for ways around it just so that they can do their
> job.
> This encourages the creation of security holes and a general
> disregard for
> the processes and procedures.
>   6. If you create a server no admins have access to, how would it be
> set up and maintained?
> 
>   Theoretical
>   The only truly secure system is the one that is never turned on.
> Once power is applied and the system is started, it can be
> compromised. An
> SA can su - oracle and login as sysdba, a DBA can spoof a user, a
> developer
> could insert malicious code. 
>   I think that the issue is to create and abide by standards and
> processes, hire trustworthy personnel and treat them right.
>   As has been shown recently here in the US, there are significant
> business risks from unethical, greedy people. How are these
> prevented?
> 
> Dan Fink
> 
> -Original Message-
> Sent: Tuesday, November 26, 2002 4:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dear list,
> 
> Let me toss a hypothetical situation at you.
> 
> Say some auditors looked at some of your primary systems,
> and concluded that they had no assurance that someone with
> admin access to the server had not changed financial information
> to benefit themselves, or to falsify financial records for the
> gain of the company.
> 
> Not that they might have any proof that something like that 
> had been done, but rather, just not proof that it had *not*
> been done.
> 
> I've been pondering this for a bit, and it seems to me that if
> someone had good knowledge of both the OS and the 
> database (Oracle), as well as having admin rights on the
> server, there are few things you can do to prevent such a person
> from changing data in the database, and completely 
> covering his or her tracks.
> 
> The platforms in question are Unix, Windows NT and
> Windows 2000.   I've limited it to those as most database
> systems use one of those, and besides, that's all I know.  :)
> 
> Consider what steps you might take to audit unauthorized
> transactions performed by an admin.
> 
> Oracle Auditing could be used, but someone with admin 
> access to the server and database could easily alter the 
> records created by system auditing.
> 
> You could create an audit table, using a trigger to audit
> sensitive tables.  A materialized view on a remote database
> could be created on sensitive tables to remotely log all
> actions.
> 
> In the case of the audit table, that could easily be disabled,
> an

RE: IOUG 2003

[Rachel Carmichael]

yeah I got one a few weeks ago. 

I don't remember the new pricing

--- "Weaver, Walt" <[EMAIL PROTECTED]> wrote:
> Speaking of IOUG, did anyone else get a membership renewal email
> recently?
> 
> Seems to me the annual dues have gone up significantly this year.
> 
> --Walt Weaver
>   Bozeman, Montana
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 8:04 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
> 
> I go to the IOUG site and look at costs for the 2003 conference. I
> see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
> 
> Has anyone on this list, who submitted an abstract, actually RECEIVED
> a
> response? Either acceptance or rejection? I haven't.
> 
> How can you set something up to allow people to register if they
> don't
> know which way to register?
> 
> Sheesh. I can't even register for the University Session I want
> because
> I don't know what status I should use when registering.
> 
> Rachel
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Weaver, Walt
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


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

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

RE: Oracle 8.1.6 Installation error

[Stephen Lee]

> -Original Message-
> I was under impression that you can install a lower version 
> of Oracle in the same box.

Did you use a different ORACLE_HOME?  I sounds like your oracle home is the
same.  If so, the install is probably finding the existing inventory file.
With completely a different installation location, the installer would not
find the other inventory file and, consequently, have no idea what was on
the box in the other location.
-- 
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: Data Warehousing books for Oracle 9i (once again)

[DENNIS WILLIAMS]

Rich -
   I don't claim to be a DW expert. My impression is that what you have to
do for a DW will vary widely from site to site. Also, much of the work may
be done by people besides yourself, and they may elect to use tools besides
Oracle.

I would consider a hierarchy of load/update tools to be as follows:
  1. ODBC tools
  2. Oracle - SQL, PL/SQL, etc.
  3. O.S. tools
The ODBC tools are the most convenient, and may give okay performance for
small amounts of data. You probably won't be using them, so this means
someone besides yourself may be doing much of the work. But for large data
sets, the performance may not be adequate.
   For really large amounts of data, you may find it necessary to process
data at the O.S. level before you load it into Oracle. For example, you
might sort the data before loading it into Oracle. SyncSort makes its money
by being faster than Oracle.
   Updating just adds more complexity and more variety to the tool set. You
must select a method based on your situation.
   Bottom line, use whatever works, and the more tools in your tool chest
the better.
   Next week I plan to make up a list of 9i new features that may be useful
for DW, to brief my DW developers. I'll send you the list.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 27, 2002 10:20 AM
To: Multiple recipients of list ORACLE-L


Yes, I know -- old topic, but a search thru the 440 DW posts on the fatcity
archives didn't reveal much.

Not having much of any knowledge on DW/DM, I picked up the Oracle Press'
"Oracle8 Data Warehousing" book for $1 on the clearance rack in hopes that
an overall view of the procedures necessary for DW/DM building and
maintenance to give me some idea of what I'm up against.

I can't help but be completely confused by this book because it doesn't seem
to cover DW/DM maintenance at all.  It has a chapter dedicated to various
ways to populate the DW/DM, but not how to keep the data up-to-date.  Do DWs
get completely regenerated on a daily/weekly/periodic basis?  This just
doesn't seem feasible to me, especially for large (1T+) DWs.

Am I missing something?  Are newer revs of this book better?  Are there any
better DW books geared specifically for Oracle9i?  Does Martha know that
John is really her long-lost brother?

>From past posts (Jared's?), I'm thinking that we'd be at least picking up
Kimball's DW Toolkit, 2nd Ed. and hopefully we'll get some training in for
this, too, but I would like something specific to DWs on Oracle 9i.


TIA!  :)
Rich


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


-- 
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.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: is it possible ?

[Stephen Lee]

> -Original Message-
> Is it possible For 2 Databases to be Brought up on the SAME 
> machine with the SAME ORACLE_SID 
> from Different ORACLE_HOMEs ?
> 
> If so , how ?

It would seem so.  Listener setup might be a bit dicey.  I might have to try
this.  It seems that as long as you had separate environments, it should
work ... we're talking Unix here right?
-- 
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: redo log file setup with mirrored drives

[Stephen Lee]

> -Original Message-
> Sorry if you took offense at some attempted humor.
--
No offense taken here.  I've always worked in large environments where there
were multiple DBA's, sys admins, developers, and testers.  One cannot be
easily offended and survive in these environments.  You have your debates;
break a few chairs in the ensuing fight; then go out for lunch.  It's all a
nice break from the daily routine.
-- 
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: LGWR using lots of CPU time, low CPU usage

[Jared . Still]

Oh boy, is my face red!

I remembered that of course, as soon  as I saw this.

I need to keep better track of who I'm plagierizing.  :)
Jared






"Cary Millsap" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/26/2002 03:05 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: LGWR using lots of CPU time, low CPU usage


The ultimate sincerest form of flattery is for someone to attribute
something smart to you that you wish you had done but, alas, did not
actually do.

(It was Tim Gorman who posted the excellent analogy.)


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- Hotsos Clinic 101, Jan 7-9 Knoxville
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 4:07 PM
To: Multiple recipients of list ORACLE-L

> >And "old school" is still right about not putting RedoLogs onto
RAID5.

> From what I'm being told, this is not your father's RAID5.  This is
what 

>they tell me:

> The CPU hands the IO to the disk controller and rather than do the
> physical disk IO while the process waits, the disk controller caches
> it to local memory and says done.  Therefore, effectively there is no
> wait for IO and it doesn't matter if we are RAID 5 or RAID 0+1,
> the system is NOT waiting for the IO. He said the only time there
might
> be a delay is during the cache's battery refresh times. I checked your
> dates and it was not occurring during those times. Also, if you look
> at the iostat statistics under the 'wait' and '%w' headers you will
> see all zeros.

Debi, 

That is true, up to a point.

Think of the cache as a water tank.  You have a garden hose
filling up the tank.  You can keep increasing the water
pressure for a while.

But the outlet at the other end of the tank has a fixed
capacity.  It flows 10 GPM, and no more.

What happens when you increase the flow at the intake to
20 GPM?

The tank fills up. 

When the tank fills up, your intake flow will need to decrease,
because you can only flow 10 GPM at the outlet.

Now, think of the outlet as writing to disk, the RAID5 cache
is the water tank, and your database is the inlet that wants
to run at 20 GPM.

If your database activity will never be intensive enough to 
stress the cache like this, no problem.  But 'never' is a
very long time.

If any of this sound familiar, Cary Millsap posted a very similar
explanation a few weeks ago.

Plagierism is the sincerest form of flattery.  :)

Jared


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

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

[Stephane Paquette]

Even 1$ is too much for "Oracle8 Data Warehousing" !

We're not yet on 9i so I've not checked about that
kind of book. 
For DW only, check Ralph Kimball's book and the IBM
red book site( http://www.redbooks.ibm.com/). There is
an excellent document (PDF) about datawarehousing in
general.
The data warehouse institute
(http://www.dw-institute.com) offers papers and
training. 

On 8i, I can recommend Tim Gorman's book.

DW are never reorganised but updated on the frequency
needed by the business needs.

HTH

 --- "Jesse, Rich" <[EMAIL PROTECTED]> a écrit :
> Yes, I know -- old topic, but a search thru the 440
> DW posts on the fatcity
> archives didn't reveal much.
> 
> Not having much of any knowledge on DW/DM, I picked
> up the Oracle Press'
> "Oracle8 Data Warehousing" book for $1 on the
> clearance rack in hopes that
> an overall view of the procedures necessary for
> DW/DM building and
> maintenance to give me some idea of what I'm up
> against.
> 
> I can't help but be completely confused by this book
> because it doesn't seem
> to cover DW/DM maintenance at all.  It has a chapter
> dedicated to various
> ways to populate the DW/DM, but not how to keep the
> data up-to-date.  Do DWs
> get completely regenerated on a
> daily/weekly/periodic basis?  This just
> doesn't seem feasible to me, especially for large
> (1T+) DWs.
> 
> Am I missing something?  Are newer revs of this book
> better?  Are there any
> better DW books geared specifically for Oracle9i? 
> Does Martha know that
> John is really her long-lost brother?
> 
> From past posts (Jared's?), I'm thinking that we'd
> be at least picking up
> Kimball's DW Toolkit, 2nd Ed. and hopefully we'll
> get some training in for
> this, too, but I would like something specific to
> DWs on Oracle 9i.
> 
> 
> TIA!  :)
> Rich
> 
> 
> Rich Jesse   System/Database
> Administrator
> [EMAIL PROTECTED]  Quad/Tech
> International, Sussex, WI USA
> 
> 
> -- 
> 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).
>  

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

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  INET: [EMAIL PROTECTED]

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

RE: IOUG 2003

[Fink, Dan]

I have heard about my university session, but not the regular sessions. They
are scheduled to publish a schedule fairly soon, so we should be finding out
shortly...I hope!

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

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

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

[Jesse, Rich]

Good point!  I'll take that one step further and suggest "select * from
v$instance" as that will also display the node that the DB is on.  Good to
know, especially if you have 3rd party apps that name the DBs the same.

Rich


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

> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 9:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: redo log file setup with mirrored drives
> 

[snip]

> it. I've learned to ALWAYS do a "pwd" at the OS level and a "select *
> from v$database" when I am connected to a database.

[snip]
-- 
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: Best way to store images in DB ?

[Stephane Paquette]

I've seen several answers to that post but none of
them have asked the question : what will you do with
the images ?

If the images are to be queried a lot then do not
store them in the database. Keep them on the OS. 
In a prevoius life, we've benchmarked our site
(www.houra.fr) with images in and out of Oracle. Out
wins in term fo performance. 

We have developed a small system so the managers can
entered text for each images. This time, the images
were in Oracle in a blob datatype.

Was 816/sun

HTH

 --- oraora  oraora <[EMAIL PROTECTED]> a écrit
: > Guys,
> 
> i have to store 20,000,000 images of 5k each in DB.
> which is the best possible way to do it ?
> can i store it as BLOB or use UTL_FILE_DIR ?
> is there any other means of achieving the same ?
> 
> it's 8.1.6 on Win2k.
> 
> Kindly let me know.
> 
> TIA.
> Jp.
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

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

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  INET: [EMAIL PROTECTED]

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

RE: Oracle OS level security

[DENNIS WILLIAMS]

Dan
   Point taken. I was thinking more of being careful with recently hired
employees and consultants that will only be around for a short time. 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 27, 2002 10:10 AM
To: Multiple recipients of list ORACLE-L


Dennis,
I must respectfully disagree with 1. I would suggest that the 'can'
be changed to a 'cannot'. It is this type of person that will stand up and
say 'This is wrong.' Therein lies your security.

Dan Fink

-Original Message-
Sent: Wednesday, November 27, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L


Jared - I think Thomas has a good point. Here is the way I look at it:

1. Make the server with critical information as secure as possible.
2. Restrict command line or console access to the minimum number of people.
This narrows you down to a few sys admins and DBAs. For them your choices
are:
1. Hire trustworthy professionals, people that can be intimidated by the
threat of being fired.
2. Hire people too stupid to understand how to break into stuff.
3. Configure a really paranoid system to keep the people that must manage
the system from being able to do their job. You could spend a lot of extra
effort on this one. And it would have to be designed and audited by people
outside the company.
   Years ago, a company I worked for tried option 3. It was a mainframe
system with no interactive access. There were three groups of people that
worked there, keypunch operators, programmers, and computer operators. The
theory was that to defraud the system would require more than one person. A
programmer could write a bogus program, but couldn't run it, would need an
operator. And so on. They even had a separate building entrance for each
group. Nobody outside of management seemed to think it was all that secure.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 27, 2002 7:14 AM
To: Multiple recipients of list ORACLE-L


Jared,

Nice question.  I don't have an answer, but a comment.

It all comes down to Risk Management.  In my opinion, Risk Management
entails identifying all known risks to losing or changing data in an
authorized manner.  Once the risks are identified and explained to the
organization, they decide what needs to be dealt with and what they are
willing to "risk" based on the probability of the event actually happening.

In your example, you've identified the risk of allowing other people admin
access on the database server machine.  If management is unwilling to revoke
these privs, then they need to understand the risk that they have accepted.
The risk they've accepted is that someone could, thru the use of stolen
passwords, the BBED editor, or simply deleting a database file, cause a
disruption, loss of service or loss of data to the organization.  And there
is not much you (as the DBA) can do about it.

I'm sure I'm preaching to the choir here.  But a lot of what we (DBA's) do
comes down to communication and education of management, and explaining
things in terms that they can understand.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 26, 2002 6:05 PM
To: Multiple recipients of list ORACLE-L


Dear list,

Let me toss a hypothetical situation at you.

Say some auditors looked at some of your primary systems,
and concluded that they had no assurance that someone with
admin access to the server had not changed financial information
to benefit themselves, or to falsify financial records for the
gain of the company.

Not that they might have any proof that something like that 
had been done, but rather, just not proof that it had *not*
been done.

I've been pondering this for a bit, and it seems to me that if
someone had good knowledge of both the OS and the 
database (Oracle), as well as having admin rights on the
server, there are few things you can do to prevent such a person
from changing data in the database, and completely 
covering his or her tracks.

The platforms in question are Unix, Windows NT and
Windows 2000.   I've limited it to those as most database
systems use one of those, and besides, that's all I know.  :)

Consider what steps you might take to audit unauthorized
transactions performed by an admin.

Oracle Auditing could be used, but someone with admin 
access to the server and database could easily alter the 
records created by system auditing.

You could create an audit table, using a trigger to audit
sensitive tables.  A materialized view on a remote database
could be created on sensitive tables to remotely log all
actions.

In the case of the audit table, that could easily be disabled,
and then re-enabled after the nefarious DML had completed.

The materialized views might be more difficult to circumvent.

If the remote end is using a dblink to the server employing a 
password that is *different* than that of it's o

RE: Oracle OS level security

[Mercadante, Thomas F]

Let's face it.  The SA's have all the privs in the world.

Finally, with 9i, and connect internal going away, we can prevent
unauthorized connections to the database to prevent data snooping.  But we
all know that there are ways around everything in this world.  

It comes down to this simple point:  
The organization has to trust someone with the keys to the treasury.  It is
unavoidable.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, November 27, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


True, and the question suggests the DBA can be properly vetted while the
system administator cannot.   I suppose one could try somne type of two-man
control.  Jared  and his system administrator each know a different half of
the root and sysdba passwordJust how this could be setup is beyond my
ken.   Responses to database emergencies  would be interesting.

If one could implement a system which would fully protect the database from
system administrators, one would also need to weigh the costs of that
protection against the perceived gain.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


  



-Original Message-
Sent: Wednesday, November 27, 2002 5:14 AM
To: Multiple recipients of list ORACLE-L


Jared,

Nice question.  I don't have an answer, but a comment.

It all comes down to Risk Management.  In my opinion, Risk Management
entails identifying all known risks to losing or changing data in an
authorized manner.  Once the risks are identified and explained to the
organization, they decide what needs to be dealt with and what they are
willing to "risk" based on the probability of the event actually happening.

In your example, you've identified the risk of allowing other people admin
access on the database server machine.  If management is unwilling to revoke
these privs, then they need to understand the risk that they have accepted.
The risk they've accepted is that someone could, thru the use of stolen
passwords, the BBED editor, or simply deleting a database file, cause a
disruption, loss of service or loss of data to the organization.  And there
is not much you (as the DBA) can do about it.

I'm sure I'm preaching to the choir here.  But a lot of what we (DBA's) do
comes down to communication and education of management, and explaining
things in terms that they can understand.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 26, 2002 6:05 PM
To: Multiple recipients of list ORACLE-L


Dear list,

Let me toss a hypothetical situation at you.

Say some auditors looked at some of your primary systems,
and concluded that they had no assurance that someone with admin access to
the server had not changed financial information to benefit themselves, or
to falsify financial records for the gain of the company.

Not that they might have any proof that something like that 
had been done, but rather, just not proof that it had *not* been done.

I've been pondering this for a bit, and it seems to me that if someone had
good knowledge of both the OS and the 
database (Oracle), as well as having admin rights on the server, there are
few things you can do to prevent such a person from changing data in the
database, and completely 
covering his or her tracks.

The platforms in question are Unix, Windows NT and
Windows 2000.   I've limited it to those as most database
systems use one of those, and besides, that's all I know.  :)

Consider what steps you might take to audit unauthorized transactions
performed by an admin.

Oracle Auditing could be used, but someone with admin 
access to the server and database could easily alter the 
records created by system auditing.

You could create an audit table, using a trigger to audit sensitive tables.
A materialized view on a remote database could be created on sensitive
tables to remotely log all actions.

In the case of the audit table, that could easily be disabled, and then
re-enabled after the nefarious DML had completed.

The materialized views might be more difficult to circumvent.

If the remote end is using a dblink to the server employing a 
password that is *different* than that of it's own account at the 
remote server, it should be impossible for someone to completely cover the
traces of transactions created to falsify data.

The MV  Logs could be dropped, but without access to the MV's at the remote
server, the MV's would have to be left in place. 

These could be used as a reference to look for unauthorized transactions in
the primary server.  If this same admin has access to the remote server
where the MV's are, then this can also be circumvented.

There is also the logs created as when logging in as internal 
or sysdba. ( $ORACLE_HOME/rdms/audit/*.aud )

These can simply be deleted.  Some system could be used to save these to a
remote server, but it would have to run *very* frequently to be effective.

Oracle password f

RE: Oracle OS level security

[Jesse, Rich]

H...just thinking.  How much of the sensitive info is encrypted to/from
the client?  If us SA/DBA folks can't get around system-level and DB-level
audits (made more difficult in 9i), network snooping and forging of
unencrypted data right from the DB server could be another hole to exploit
(one reason why my paranoia prevents me from viewing my paycheck online and
unencrypted here at work).

BTW, I can't find any hint of a BBDE program on 9iR2/Winders nor 8.1.7 on
HP.  I would like it to learn more about block level storage (on our TEST
DBs, obviously!).  Anyone with more info on this?

Rich


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

> -Original Message-
> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 10:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle OS level security
> 
> 
> Let's face it.  The SA's have all the privs in the world.
> 
> Finally, with 9i, and connect internal going away, we can prevent
> unauthorized connections to the database to prevent data 
> snooping.  But we
> all know that there are ways around everything in this world.  
> 
> It comes down to this simple point:  
> The organization has to trust someone with the keys to the 
> treasury.  It is
> unavoidable.
> 
> Tom Mercadante
> Oracle Certified Professional
-- 
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: IOUG 2003

[Robson, Peter]

Yeah, well I too had become somewhat puzzled at the length of time they seem
to be taking in informing would-be speakers, so emailed them.

The answer is that notifiations will be posted second week December.

Good luck!

peter
edinburgh

> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 15:04
> To: Multiple recipients of list ORACLE-L
> Subject: IOUG 2003
> 
> 
> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
> 
> I go to the IOUG site and look at costs for the 2003 conference. I see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
> 
> Has anyone on this list, who submitted an abstract, actually 
> RECEIVED a
> response? Either acceptance or rejection? I haven't.
> 
> How can you set something up to allow people to register if they don't
> know which way to register?
> 
> Sheesh. I can't even register for the University Session I 
> want because
> I don't know what status I should use when registering.
> 
> Rachel
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


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

is it possible ?

[VIVEK_SHARMA]

Is it possible For 2 Databases to be Brought up on the SAME machine with the SAME 
ORACLE_SID 
from Different ORACLE_HOMEs ?

If so , how ?

Thanks

-- 
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: Oracle OS level security

[Jared . Still]

After  pondering this for a few minutes, I came to the conclusion
that BED doesn't matter.

First, I need to clarify a proposed audit trail.  It consists of an audit
table on a sensitive table.  The audit table is populated via trigger
and records all updates/inserts/deletes. 

The audit table is replicated to a secure server via Materialized View.

It doesn't matter *how* fraudulent transactions are entered into the
table.  The audit trail is still in place, and data in the production 
system
would not correspond with the audit trail.

Jared






"K Gopalakrishnan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/26/2002 04:09 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle OS level security


Jared:

Any one with a reasonable knowledge of Oracle Data Storage
Internals can use the Data block Editor (BBED) to update
anything in your database without the knowledge of the
RDBMS kernel auditing mechanisms.

Agreed,BBED is protected by a password in Windoze ports
and one need to explicitly make the executable in Unix
ports. But the point here is the hacker can do anything 
using the BBEd and this can be done even while your 
database is up and running !!

What is their take on this kind of attack(!)s?>


Best Regards,
K Gopalakrishnan

 


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 3:05 PM
To: Multiple recipients of list ORACLE-L


Dear list,

Let me toss a hypothetical situation at you.

Say some auditors looked at some of your primary systems,
and concluded that they had no assurance that someone with
admin access to the server had not changed financial information
to benefit themselves, or to falsify financial records for the
gain of the company.

Not that they might have any proof that something like that 
had been done, but rather, just not proof that it had *not*
been done.

I've been pondering this for a bit, and it seems to me that if
someone had good knowledge of both the OS and the 
database (Oracle), as well as having admin rights on the
server, there are few things you can do to prevent such a person
from changing data in the database, and completely 
covering his or her tracks.

The platforms in question are Unix, Windows NT and
Windows 2000.   I've limited it to those as most database
systems use one of those, and besides, that's all I know.  :)

Consider what steps you might take to audit unauthorized
transactions performed by an admin.

Oracle Auditing could be used, but someone with admin 
access to the server and database could easily alter the 
records created by system auditing.

You could create an audit table, using a trigger to audit
sensitive tables.  A materialized view on a remote database
could be created on sensitive tables to remotely log all
actions.

In the case of the audit table, that could easily be disabled,
and then re-enabled after the nefarious DML had completed.

The materialized views might be more difficult to circumvent.

If the remote end is using a dblink to the server employing a 
password that is *different* than that of it's own account at the 
remote server, it should be impossible for someone to completely
cover the traces of transactions created to falsify data.

The MV  Logs could be dropped, but without access to the MV's
at the remote server, the MV's would have to be left in place. 

These could be used as a reference to look for unauthorized transactions
in the primary server.  If this same admin has access to the remote
server where the MV's are, then this can also be circumvented.

There is also the logs created as when logging in as internal 
or sysdba. ( $ORACLE_HOME/rdms/audit/*.aud )

These can simply be deleted.  Some system could be used to save
these to a remote server, but it would have to run *very* frequently to
be effective.

Oracle password files could also be used. While this can prevent
someone from logging in as SYS or SYSTEM while in place, all it
takes is a change to init.ora, and a database bounce to fix that.

Make your bogus data changes, change the init.ora back and 
bounce the database again.

A somewhat clever person could set this up to automatically
take place the next time the DB is bounced.

The conclusion I have come to is that the only effective method 
that could be used to create an audit trail for such a scenario is
to create Materialized Views on sensitive tables, and create them
on a server that admins are guaranteed to not have access to.

Of course, I may be missing something.  I'm not always one to 
catch all the details right off.  Input, comments, suggestions, far
out ideas are all welcome.

If you've read this far, thanks!

Jared





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

RE: RE: LGWR using lots of CPU time, low CPU usage

[VIVEK_SHARMA]

TOTAL Time Taken for a fixed Number of Application Transactions to Complete , (mostly 
OLTP in nature to Complete ) , Rose by about 3 TIMES the Normal Benchmarked Time .

We found that somehow the session_cached_cursor had been oversized to 200 .

Immediately thereafter , I reduced the session_cached_cursors to 50 , Bounced the 
Database 
& did a RE-Run

The performance (TOTAL Time Taken) returned to Normal

Benchmark was Done on Oracle 8.1.7 on Solaris 8

We unfortunately do NOT have any more Details of now

HTH


-Original Message-
Sent: Wednesday, November 27, 2002 7:39 AM
To: Multiple recipients of list ORACLE-L


VIVEK_SHARMA,
Can i know how did you get your result of oversizing the 
session_cached_cursors do harm to performance? My applications do a lot of softparse 
with pro*C and i used session_cached_cursors=200 in my db. I want to know How did you 
find it out and can you share your experience?
And another add on: lgwr using a lot of cpu time,low cpu usage, does it mean 
that it look like my profile? I think It is because lgwr is consistantly using cpu , 
and the database have been up for a long time.So, from ps/top, the total cpu is 
high,but cpu usage is low?
main-db1# /usr/ucb/ps -aux|grep ora_ |grep -v grep |sort +8nr

oracle1078  0.1 46.857277125697408 ?S   Oct 30 220:00 ora_lgwr_biddb
oracle1076  0.1 46.857317205701200 ?S   Oct 30 92:37 ora_dbw0_biddb
oracle1086  0.0 46.957328325709560 ?S   Oct 30 47:02 ora_snp0_biddb
oracle1088  0.0 46.957335925710896 ?S   Oct 30 25:04 ora_snp1_biddb
oracle1094  0.0 46.857275685696760 ?S   Oct 30 20:54 ora_arc0_biddb
oracle2662  0.0 46.857275685697472 ?S   Oct 30 20:20 ora_arc2_biddb
oracle1597  0.0 46.857275685697456 ?S   Oct 30 19:42 ora_arc1_biddb
oracle1092  0.0 46.957323765709312 ?S   Oct 30 17:19 ora_snp3_biddb
oracle1090  0.0 46.957344965709648 ?S   Oct 30 10:23 ora_snp2_biddb
oracle1096  0.0 47.257831605745720 ?S   Oct 30  8:22 ora_p000_biddb
oracle1101  0.0 47.257781605743520 ?S   Oct 30  7:36 ora_p002_biddb
oracle1098  0.0 47.257781765743904 ?S   Oct 30  6:34 ora_p001_biddb
oracle1103  0.0 47.257781525743576 ?S   Oct 30  6:42 ora_p003_biddb
oracle1080  0.0 46.857277125697440 ?S   Oct 30  4:21 ora_ckpt_biddb
oracle1107  0.0 47.157770005741416 ?S   Oct 30  4:18 ora_p005_biddb
oracle1105  0.0 47.057646325730624 ?S   Oct 30  3:20 ora_p004_biddb
oracle1109  0.0 47.157729045736024 ?S   Oct 30  2:25 ora_p006_biddb
oracle  0.0 47.157728485735952 ?S   Oct 30  2:28 ora_p007_biddb
oracle1074  0.0 46.857268085698184 ?S   Oct 30  0:00 ora_pmon_biddb
oracle1082  0.0 46.857259365700096 ?S   Oct 30  0:59 ora_smon_biddb
oracle1084  0.0 46.857258165699392 ?S   Oct 30  0:31 ora_reco_biddb





Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)

=== 2002-11-26 11:25:00 ,you wrote£º===

>In some of our benchmarks with our hybrid application on Oracle 8.1.7 , Oversizing 
>session_cached_cursors would HARM performance greatly . Our Optimal Value is 50
>
>
>-Original Message-
>Sent: Wednesday, November 27, 2002 12:20 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Deborah,
>
>First, don't remove Oracle's RedoLog duplexing, you may regret about it
>later (see recent thread on this issue).
>
>Second, if what you are telling ("logs are about 100 MB in 2 groups of 20
>members each") is accurate, then this is your main problem.  If you have
>your log switches on avg 2.5 per day, change your RedoLog configuration to
>be: 3 (or 4) groups, 3 members each (if you can put them on separate
>"physical" devices, if not - 2 members should suffice), and you can make
>them smaller, like 50Mb (or even smaller).  You will have more log switches
>per day, but it's perfectly fine as long, as don't have them every 5 min.
>
>And "old school" is still right about not putting RedoLogs onto RAID5.
>
>Igor Neyman, OCP DBA
>[EMAIL PROTECTED]
>
>
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Tuesday, November 26, 2002 1:00 PM
>
>
>> We are on 9.2.0.2, Solaris 8 on Sunfire 3800 with 16 GB memory and 128 MB
>> on a hardware-controlled, mirrored RAID5 StorEdge T-3 Array.
>>
>> Periodically throughout the day the LGWR background process clocks 20+
>> minutes of CPU time while actual CPU usage is quite low. I ran a statspack
>> report and for a 45-minute period that included the slow LGWR process.
>>
>> The top 5 timed events in my 45-minute report are:
>>
>> CPU time 1,295 60.41
>> db file sequential read 392,516 341 15.91
>> db file scattered read 70,245 168 7.85
>> log file sync 26,916 133 6.22
>> library cache pin 22 59 2.76
>>
>> (Now that the top 5 is "timed" events, 3

Re: Security Focus Link - SQL Injection White Paper

[Jared . Still]

Thanks Ethan,

You may also be interested in several papers on SQL Injection
available at:

   http://www.nextgenss.com/research/papers.html


These refer to SQL Server, but much of it is relevant 
for any database.

Jared






"Post, Ethan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/27/2002 07:54 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Security Focus Link - SQL Injection White Paper


SQL Injection and Oracle - By Pete Finnigan

This is the first article in a two-part series that will examine SQL
injection attacks against Oracle databases. The  bjective of this series 
is
to introduce Oracle users to some of the dangers of SQL injection and to
suggest some simple ways of protecting against these types of attack.

http://online.securityfocus.com/infocus/1644
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

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

[Jared . Still]

The first thing to do is quit using tnsnames.ora on the client PC's.

Use Oracle names or Oracle Internet Directory.

Jared





Hemant K Chitale <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/27/2002 07:28 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Recipe for application design to run on RAC



Hmm.  Oracle says that with the improved Cache Fusion in 9i,
any current application can be taken "as is" and run on 9iRAC.
But yes, you are right.  It really depends on the speed at which
the two instances can share the same block and this can never
be the same as two sessions accessing the same block in one
instance [one SGA].
We are currently running and 8.1.5 OPS [ouch !] environment
and testing 9iR2 RAC.  The 8.1.5 OPS runs such that the
Application Servers [Pro*C servers which get transactions
from remote devices through a "message bus"] all connect to
one node and direct PCs using VB/MSQuery connect to the other.
Time and again I've asked for the PCs also to connect to the same
node but no ... the effort to update the TNSNAMES.ORA and ODBC
setup on the PCs would be too much I am told.
In 9iRAC we are testing both BASIC and PRECONNECT Failover for
TAF and will most certainly be using both nodes of the cluster for
transactions.  Even the Application Servers will be connecting across
both nodes.
Cross-fingers, touch-wood and wish me luck !

Hemant

At 03:59 PM 26-11-02 -0800, you wrote:
>If two or more RAC instances will be trying to cache the same data
>blocks, then this causes the performance problems that you'll see show
>up as lots of time spent on the event called "global cache cr request".
>If you can partition your application so that RAC nodes don't have to
>share blocks very often through the cache fusion mechanism, then your
>system will scale a lot better.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>
>Upcoming events:
>- Hotsos Clinic, Dec 9-11 Honolulu
>- Hotsos Clinic 101, Jan 7-9 Knoxville
>- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
>- 2003 Hotsos Symposium, Feb 9-12 Dallas
>
>
>-Original Message-
>Sent: Tuesday, November 26, 2002 3:34 PM
>To: Multiple recipients of list ORACLE-L
>
>Dear List,
>
>Number of times I've seen that one of prerequsites for
>switching from single node DB to OPS/RAC is to have an
>application specifically designed / architectured to
>run on RAC.
>Can somebody elaborate? Is it something "visible" on
>ERD? That is by looking at the model can RAC guru tell
>that it wouldn't work well on RAC?
>Or put it another way can one conclude based on the
>ERD that app was modeled to run on RAC?
>
>What's the recepie for app design for RAC?
>
>TIA
>
>__
>Post your free ad now! http://personals.yahoo.ca
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Boris Dali
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Cary Millsap
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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).




-- 
Please see the official ORACLE-L FAQ: ht

NT Memory Leak 7.3.4

[Bowes, Chris]

Title: NT Memory Leak 7.3.4





Hi,


    Does anyone know of a memory leak for Oracle 7.3.4.0 on Windows NT 4.0?  A friend of mine is having to reboot monthly as the oracle73.exe grows to all of the memory on the machine when the SGA is pegged at 40M.  As of today, the Oracle73.exe was at 210M and growing.  They will be rebooting today.  I know that the Oraclexx.exe starts less than the SGA and grows as it is used, but I haven't seen it go beyond the SGA settings.  I have told him he needs to upgrade to 7.3.4.4 or 7.3.4.5.  Is this good advice (they cannot go to 8)?  Thank you in advance.

--Chris

Re: OT: Open Source Security Comes Under Fire

[Jared . Still]

The most interesting part of the article was the response by
the MS  VP of security.

Rather than bad mouth open source, he spoke of security
holes as an 'industry problem'

Amazing!

Jared






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

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:OT: Open Source Security Comes Under Fire


FYI.
 
http://www.eweek.com/article2/0,3959,720533,00.asp
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).

Oracle 8.1.6 Installation error

[Mandal, Ashoke]

Greetings,

I was trying to install oracle 8.1.6 on a Sun Solaris(2.7) box.

But I get an error saying that you cannot install 8.1.6 when you have already 
installed 8.1.7 in this box.

I was under impression that you can install a lower version of Oracle in the same box.

Could you please confirm this.

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

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

[Grant Allen]

Title: BackupExec & Oracle



You've got to 
love blinkered analyst reports - SQL Server alone has had nearly a dozen 
critical security issues this year (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316333&id=Q316333).  
But I guess that doesn't count :-)
 
Ciao
Fuzzy
(yes, I'm back - 
made it to the UK in mostly one piece)
 
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice JSent: 
  27 November 2002 14:24To: Multiple recipients of list 
  ORACLE-LSubject: OT: Open Source Security Comes Under 
  Fire
  FYI.
   
  http://www.eweek.com/article2/0,3959,720533,00.asp
  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: Autoextend WAIT statistic?

[DENNIS WILLIAMS]

K., Ian, Dan - Thanks so much for your replies. This is LMT. Dan -
appreciate your running a test, no wonder "you 'da man". Now I know the
statistic to keep an eye on, and which wait table. I'm not sure how much of
a problem this is, but when my sys admin gets an idea, he hangs on like a
bulldog, and damnit he's been right a few times!

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 26, 2002 5:26 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I did some quick & dirty testing by creating a very small(10M)
datafile with a large(2000m) autoextend clause. On the insert, the session
was waiting on 'file open' for most of the time. When I did a rollback and
reinserted the data, there were no waits (that I saw) on file open.

Interestingly, this wait event does not appear to be accurately
tracked in v$session_event. In v$session_wait the seconds in wait (last
trapped) was 132. In v$session_event, it shows 0. Okay, gurus, why? Am I
missing something in this?

select * from v$session_wait where sid = 14
  SID   SEQ# EVENT
-- --

P1TEXT   P1
P1RAW
 --

P2TEXT   P2
P2RAW
 --

P3TEXT   P3
P3RAW WAIT_TIME SECONDS_IN_WAIT
 --
 -- ---
STATE
---
14322 file open
fib  4327126592
000101EAB640
iov  4327069760
000101E9D840
0 0
00   -1 132
WAITED SHORT TIME

select * from v$session_event where sid = 14
   SID EVENT  TOTAL_WAITS TOTAL_TIMEOUTS
TIME_WAITED AVERAGE_WAIT   MAX_WAIT
-- -- --- --
---  --
14 rdbms ipc reply  4  1
210 52.5205
14 control file sequential read18  0
16   .9 15
14 local write wait 1  0
00  0
14 log buffer space72  0
124217.25 82
14 log file switch completion   6  0
250   41.667 72
14 log file sync4  0
6115.25 28
14 db file sequential read  7  0
1   .142857143  1
14 db file scattered read 164  0
152   .926829268  5
14 db file single write 2  0
1   .5  1
14 file identify4  0
00  0
14 file open6  0
00  0
14 SQL*Net message to client   41  0
00  0
14 SQL*Net message from client 40  0
67829 1695.725  19952


Dan Fink
-Original Message-
Sent: Tuesday, November 26, 2002 2:30 PM
To: Multiple recipients of list ORACLE-L


Oracle says that when a file autoextends, there is a slight delay. Does
anyone know which Oracle WAIT statistic that would appear under?
  We have been using autoextend on OLTP production tables for awhile now,
and the results have been satisfactory. This is an ERP system, so the
critical performance time is at month-end. Some of the developers are
concerned that table autoextending may slow batch programs, and suggesting
that I should determine which tables are likely to autoextend during
month-end and add storage beforehand. I would like to ensure that I am
fixing a real problem (short on time, like most of you), so I am wondering
if autoextend was causing a delay, what wait statistic would it show up
under. Any ideas?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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 P

RE: Oracle OS level security

[Stephen Lee]

My experience with NT security in an environment of any significant size is
that it is a hopeless situation.  In addition to dealing with admins on the
box with the database, it seems that there is always an application support
person or two that needs to administrator privs on that box too.  Then there
are the people that support multiple boxes, so they get domain admin privs.

I set the privs on Oracle files so that any administrator would at least
have to take ownership of the files  in order to delete them.  Following
strict file and directory naming conventions and teaching everyone to
recognize sacred file name patterns helps.  We even had certain drive
letters throughout the domain that were reserved for Oracle stuff so that
people would know which drive letters were danger zones.

With all this in place, the only problems we experienced were due to the
flakey disk clustering that the admins were using.  File systems (or the NT
equivalent thereof) had a habit of getting unmounted, and Oracle seems to
take offense at files suddenly disappearing.

I wasn't all that worried about people going in and deleting files.  My
biggest worry was that we automate a lot of jobs and a lot of monitoring
with scripts.  Some of these require information, (such as passwords) be put
into files; files that I can't protect on NT.  I never had a big problem
with admins being administrator (or root on Unix), but on NT it seems that
there are always people from development, or people from some department up
on 10th floor, that "need" administrator on the box too in order to support
some app.  So now you have developers and people you don't even know about
that, if they chose to do so, can go nosing around in your stuff.
-- 
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: Pro*C for Oracle 817 on Win2000?

[Jeff Herrick]

Hello

Pro*C can be found on the 8.1.7 NT/EE distribution which will
run on W2K. It's under application development. The Borland
compiled support was dropped a long time ago AFAIK. You can
try using the .LIB's for VisualC++ for linking with your
other compiler but I think you might be S.O.L. in that
department. I think the library formats vary between compilers.

Cheers

Jeff Herrick

On Wed, 27 Nov 2002, Denham Eva wrote:

> Hello,
>
> Apologies if this is the wrong list to write to, but some guidelines would
> be nice.
> We have a legacy software which requires changing. I would like to achieve
> this but as far as I can see there is no pro*c on otn.oracle.com for Win2k?
> Is it possible to load the libraries from somewhere? I have tried loading
> the Programmer option of the client, however from the errors received I
> don't have all the libraries. ie sqlca.h.
> I am trying to achieve this feat by using Bloodshed's DevC++. Am I being
> overly optimistic?
> I see there are libraries for VC++ and Borland, under the
> c:\oracle\ora81\oci directories. Unfortunately I don't have access to these
> programs?
>
> Any help will appreciated.
>
> 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
> _
>

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

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

RE: Recipe for application design to run on RAC

[Paula_Stankus]

Title: RE: Recipe for application design to run on RAC





Couldn't you partitioned your database to accomplish the same thing and thus still be application-independent? - costs $$ licensing but ...

-Original Message-
From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Recipe for application design to run on RAC




Hmm.  Oracle says that with the improved Cache Fusion in 9i,
any current application can be taken "as is" and run on 9iRAC.
But yes, you are right.  It really depends on the speed at which
the two instances can share the same block and this can never
be the same as two sessions accessing the same block in one
instance [one SGA].
We are currently running and 8.1.5 OPS [ouch !] environment
and testing 9iR2 RAC.  The 8.1.5 OPS runs such that the
Application Servers [Pro*C servers which get transactions
from remote devices through a "message bus"] all connect to
one node and direct PCs using VB/MSQuery connect to the other.
Time and again I've asked for the PCs also to connect to the same
node but no ... the effort to update the TNSNAMES.ORA and ODBC
setup on the PCs would be too much I am told.
In 9iRAC we are testing both BASIC and PRECONNECT Failover for
TAF and will most certainly be using both nodes of the cluster for
transactions.  Even the Application Servers will be connecting across
both nodes.
Cross-fingers, touch-wood and wish me luck !


Hemant


At 03:59 PM 26-11-02 -0800, you wrote:
>If two or more RAC instances will be trying to cache the same data
>blocks, then this causes the performance problems that you'll see show
>up as lots of time spent on the event called "global cache cr request".
>If you can partition your application so that RAC nodes don't have to
>share blocks very often through the cache fusion mechanism, then your
>system will scale a lot better.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>
>Upcoming events:
>- Hotsos Clinic, Dec 9-11 Honolulu
>- Hotsos Clinic 101, Jan 7-9 Knoxville
>- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
>- 2003 Hotsos Symposium, Feb 9-12 Dallas
>
>
>-Original Message-
>Sent: Tuesday, November 26, 2002 3:34 PM
>To: Multiple recipients of list ORACLE-L
>
>Dear List,
>
>Number of times I've seen that one of prerequsites for
>switching from single node DB to OPS/RAC is to have an
>application specifically designed / architectured to
>run on RAC.
>Can somebody elaborate? Is it something "visible" on
>ERD? That is by looking at the model can RAC guru tell
>that it wouldn't work well on RAC?
>Or put it another way can one conclude based on the
>ERD that app was modeled to run on RAC?
>
>What's the recepie for app design for RAC?
>
>TIA
>
>__
>Post your free ad now! http://personals.yahoo.ca
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Boris Dali
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>San Diego, California    -- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Cary Millsap
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>San Diego, California    -- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: redo log file setup with mirrored drives

[Rachel Carmichael]

> I was amazed at the non-security that seems to be rampant out there,
> with mischievous people running around deleting files.  I kept
reading
> about it and thinking you've got to be kidding.

Steven,

have you NEVER accidentally, at 3AM, after having been woken from a
sound sleep to a crisis that needs to be fixed RIGHT NOW,  made a typo?

if not, wow, I'm in awe. All you need to do is forget which directory
you are in... and not include the path when do you an "rm". I've done
it. I've learned to ALWAYS do a "pwd" at the OS level and a "select *
from v$database" when I am connected to a database.

In any case, in another post you asked if anyone had ever lost a
database due to hardware mirroring.

Um, I have. Okay, we recovered the database via Data Unloader, but
essentially it was lost, because we couldn't open the database. The
current redo log and its hardware mirror failed. To this day, I don't
know why, there was a lot of finger pointing going on, including "you
mirrored it onto itself" and "you had both disks on the same controller
and it failed".

Regardless of WHY it happened, it happened. We could not switch the
current log, we could not open the database, we couldn't access
anything.

Tech support finally mentioned that there was this product that field
support had...

and two DAYS later I had a database again.

In this case, Oracle mirroring (no, we were not using multiplexed redo
logs) would possibly have saved us time, money and I might have had a
few less gray hairs.

Rachel

--- Stephen Lee <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > We do redo log file multiplexing to protect against fat 
> > fingers and other odd-ball stuff that have caused problems 
> > for an entire file system.  Call it an unreliable OS, poor SA 
> > (ok, maybe even DBA) practices
> 
> I do it because it's a CYA thing of doing it by the book.  I've
> listened to
> a lot of debates about database things and been amazed at the
> reasoning
> behind why people do what they do.  I've lost count of how many
> debates I've
> heard about extent sizes and numbers of extents, the majority of it
> pure
> superstition.  In the end, no matter how scientific or superstitious
> the
> reasoning, CYA trumps all.  So that's why I do it.  But, in fact,
> this whole
> thing about corrupt blocks is flawed reasoning.  If an OS cannot do
> disk
> writes in an absolutely reliable way, then the OS is unusable.  The
> bad
> writes will occur throughout the system.  This includes when your
> logs get
> archived and writes to data files.  Put those two together and what
> do you
> get?
> 
> Actually, there is one advantage to hardware mirroring of archives. 
> On
> Oracle duplexed archives, my experience is that it is inevitable that
> you
> will have one destination fill up while the other one doesn't.  In
> which
> case Oracle quietly quits using the one destination even after the
> files are
> removed during a backup.  I wrote a script to monitor when Oracle has
> stopped duplexing archived logs for those where we don't have
> hardware
> mirroring.
> 
> I was amazed at the non-security that seems to be rampant out there,
> with
> mischievous people running around deleting files.  I kept reading
> about it
> and thinking you've got to be kidding.
> -- 
> 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).
> 


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

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

RE: Recipe for application design to run on RAC

[Boris Dali]

Thanks for taking time to reply, Cary. Much
appreciated.

Did I understand it correctly that in active/active
setup it would be beneficial to give each node "it's
own virtual empire" so to speak. 
Like one node to service say marketing and sales,
while the other to deal with say inventory and
automation and minimize interdependencies between the
two?
I was thinking more along the lines of equally
distributing/balancing the utilization across the
nodes (which presumably makes it easier to re-route db
calls to surviving node in case of instance/node
failure after remastering, since all nodes are
"peers")
I obviously need to do some serious RTFMing here.


So if the key is to have application partitioned (by
probably functional/business areas?), is it at the
logical design stage that this needs to be accounted
for?
Assuming enterprise framework in place, like Zachman's
(http://www.zifa.com/framework.html) would it be at
the system model/logical level (or using Oracle
Designer terminology I guess at the system analysis
stage) that "design for RAC" comes to the picture for
a first time?

Thanks again.

 --- Cary Millsap <[EMAIL PROTECTED]> wrote: >
If two or more RAC instances will be trying to cache
> the same data
> blocks, then this causes the performance problems
> that you'll see show
> up as lots of time spent on the event called "global
> cache cr request".
> If you can partition your application so that RAC
> nodes don't have to
> share blocks very often through the cache fusion
> mechanism, then your
> system will scale a lot better.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - Hotsos Clinic 101, Jan 7-9 Knoxville
> - Steve Adams's Miracle Master Class, Jan 13-15
> Copenhagen
> - 2003 Hotsos Symposium, Feb 9-12 Dallas
> 
> 
> -Original Message-
> Sent: Tuesday, November 26, 2002 3:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> Dear List,
> 
> Number of times I've seen that one of prerequsites
> for
> switching from single node DB to OPS/RAC is to have
> an
> application specifically designed / architectured to
> run on RAC.
> Can somebody elaborate? Is it something "visible" on
> 
> ERD? That is by looking at the model can RAC guru
> tell
> that it wouldn't work well on RAC?
> Or put it another way can one conclude based on the
> ERD that app was modeled to run on RAC?
> 
> What's the recepie for app design for RAC?
> 
> TIA
> 
>
__
> 
> Post your free ad now! http://personals.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Boris Dali
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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: Cary Millsap
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boris Dali
  INET: [EMAIL PROTECTED]

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

[Guang Mei]

Hi:

I am the original poster and thanks for all your inputs on this topic. Now I 
know more about what "might" happen if something goes wrong. The main 
purpose of we thinking doing this was to gain some performance. We have a 
weekly schema imp process which takes about a day to finish. We hope by 
eliminating redo log multiplex, but with OS mirroring we can speed up this 
loading process. We are going to do some tests to see how much we would 
gain.

BTW, our unix system admin is very good, I can trust him that we would never 
delete any redo log files or any oracle files.

So the only "practical danger" is that the redo file might get corrupted. 
This means we need to balance the "performance" vs "file curruption".

Thanks again.

Guang



_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus

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

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

RE: IOUG 2003

[Weaver, Walt]

Speaking of IOUG, did anyone else get a membership renewal email recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

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

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

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

RE: IOUG 2003

[Karniotis, Stephen]

Ah.  The Queen is ranting again.

Confirmations have not been sent out by the IOUG as of yet.  Should be
sometime within the next week or so.  The setup for the speakers is to have
us test the registration and to have it ready when the confirmations go out.
I would assume that registration will be comparable to last year.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, November 27, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
Subject:IOUG 2003

Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

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

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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, 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: Using RECYCLE pool?

[DENNIS WILLIAMS]

Thanks Denny, Connor, and Ferenc for your helpful suggestions.

Ferenc - I particularly appreciated your insights. This is also a packaged
app where I can't tune the SQL. It does no table scans (long story, but that
is the way this app works). My logic is that the biggest wait (85% of wait)
is "db file sequential read", and the BHR is fairly low, about 80%. So my
thought is to increase the buffer, and while I was at it, thought I would
try the KEEP and RECYCLE pools. 
   But I find your comment about logical tuning very interesting. Can you
explain more, in case I'm missing something basic? Thanks.

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


-Original Message-
Sent: Tuesday, November 26, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L


Hi Dennis

I try to not think of the pool names as being descriptive of what they 
should be allocated for. I regard them as pool 1 (default), of which I can 
configure two other pools, (pool 2 and pool 3).

For Siebel applications (probably works similar for PSOFT [Joe, you in on 
this thread ?] and SAP), knowing the application and what it does, the 
repository tables, like the tables that define position based access, 
views, responsibilities, position relationships (team-based visibility in 
Siebel), broadcast messages, workflow rules and rule items, I put them into 
a separate smaller but very frequently accessed pool, knowing they are 
going to get hit at least a few times every minute with a few hundred users 
logged on.

Then I try to identify those tables that DO get FTS, and if I cannot tune 
the query by placing relevant indices (sometimes it is better to have FTS 
than large index range scan to reduce logical IO, the big performance 
killer), put these into a separate pool, and leave the rest in default. 
Alternatively, the hot smaller tables go into one pool, the indices in 
another and the rest of the tables stay in default. There are various 
tricks for this. Oracle 9 makes things easier because you can identify 
which indexes are beig used, and then not waste your time with the others.

Just remember, you will get much further distance from reducing logical 
IO's than playing with various buffer pools, though there is a minimal 
argument for playing with buffer pools, once logical IO's have been 
decreased.

Real-life example : using Siebel EIM, by placing EIM tables into separate 
buffer pools, I saw a small advantage, say 5 - 10 % in buffer cache latch 
reduction and more efficient use of cached IO. But after tuning the 
structures so that I reduced logical IO's, I saw a 2000% throughput 
improvement of EIM, to the amazement of all skeptics on the project (also 
bumped up initrans and ran multiple parallel streams). So prioritize where 
you spend your tuning efforts. Reduction of logical IO = biggest bang for 
buck !

Getting off my soapbox now. Lots to do.
Ciao :

Ferenc Mantfeld

-Original Message-
From:   DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 27, 2002 8:30 AM
To: Multiple recipients of list ORACLE-L
Subject:Using RECYCLE pool?

Is anyone using the Oracle RECYCLE buffer pool? What was your criteria to
select tables? The application I am considering RECYCLE for doesn't perform
table scans, so that eliminates one common suggestion.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
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: mantfield
  INET: [EMAIL PROTECTED]

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

Re: IOUG 2003

[Arup Nanda]

Rachel,

I inquired the same with IOUG Conference Committee and here is the response
from Julie Ferry.

 START OF MESSAGE <<<
- Original Message -
To: '[EMAIL PROTECTED]'
Sent: Tuesday, November 05, 2002 2:26 PM

Hi Arup,
Speaker notifications will be send out the second week of December.  All
speakers that submitted an abstract for Live! will receive a message
regardless of whether or not they were accepted.

Thanks.

Julie
 END OF MESSAGE 
Hope this helps.
Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 10:03 AM


> Okay, so I'm trying to get costs for conferences etc so my boss can
> budget for them.
>
> I go to the IOUG site and look at costs for the 2003 conference. I see
> "register online" so I click on it. They have it set up for speaker
> registration already, and ask for the email confirmation code you
> received.
>
> Has anyone on this list, who submitted an abstract, actually RECEIVED a
> response? Either acceptance or rejection? I haven't.
>
> How can you set something up to allow people to register if they don't
> know which way to register?
>
> Sheesh. I can't even register for the University Session I want because
> I don't know what status I should use when registering.
>
> Rachel
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

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

RE: redo log file setup with mirrored drives

[Stephen Lee]

> -Original Message-
> have you NEVER accidentally, at 3AM, after having been woken from a
> sound sleep to a crisis that needs to be fixed RIGHT NOW,  
> made a typo?
> 

Actually no.  But we usually script our actions and test the scripts prior
to doing anything in production.  As a sys admin, I've restored enough
casualties of the "rm -rf *" command to be rather careful about it myself.

> Um, I have.

I was wondering if anyone had.  But I could turn this around too and give an
example of when duplexing the redos failed to save me.  One so-called patch
that Compaq released for Tru64 actually caused disk writes to be unreliable
(OH MY GOD!!).  And we wound up with a G.D. mess in spite of the redos being
duplexed all nice and official.
-- 
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).

Data Warehousing books for Oracle 9i (once again)

[Jesse, Rich]

Yes, I know -- old topic, but a search thru the 440 DW posts on the fatcity
archives didn't reveal much.

Not having much of any knowledge on DW/DM, I picked up the Oracle Press'
"Oracle8 Data Warehousing" book for $1 on the clearance rack in hopes that
an overall view of the procedures necessary for DW/DM building and
maintenance to give me some idea of what I'm up against.

I can't help but be completely confused by this book because it doesn't seem
to cover DW/DM maintenance at all.  It has a chapter dedicated to various
ways to populate the DW/DM, but not how to keep the data up-to-date.  Do DWs
get completely regenerated on a daily/weekly/periodic basis?  This just
doesn't seem feasible to me, especially for large (1T+) DWs.

Am I missing something?  Are newer revs of this book better?  Are there any
better DW books geared specifically for Oracle9i?  Does Martha know that
John is really her long-lost brother?

>From past posts (Jared's?), I'm thinking that we'd be at least picking up
Kimball's DW Toolkit, 2nd Ed. and hopefully we'll get some training in for
this, too, but I would like something specific to DWs on Oracle 9i.


TIA!  :)
Rich


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


-- 
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: Oracle OS level security

[DENNIS WILLIAMS]

Jared - I would be very careful about naming specific tools. Having been an
NRC auditor and been audited a lot of times, there is sometimes too much
specific information, which will leave the auditor with the impression there
is no security at all. They will then feel obligated to "flunk" your
system/process/site, or at least give you a ton or corrective action items.
If you feel heavily obligated, you might allude to the fact that an expert
could access the Oracle data at the O.S. level if they were very determined
and leave it at that. I'm sure there are some O.S. tools that can accomplish
what BBED can, if not as conveniently.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]  

-Original Message-
Sent: Wednesday, November 27, 2002 8:09 AM
To: Multiple recipients of list ORACLE-L



Hadn't even considered BBED, and I have no idea
what their take is on it. 

Guess I'll have to ask.

Jared

On Tuesday 26 November 2002 16:09, K Gopalakrishnan wrote:
> Jared:
>
> Any one with a reasonable knowledge of Oracle Data Storage
> Internals can use the Data block Editor (BBED) to update
> anything in your database without the knowledge of the
> RDBMS kernel auditing mechanisms.
>
> Agreed,BBED is protected by a password in Windoze ports
> and one need to explicitly make the executable in Unix
> ports. But the point here is the hacker can do anything
> using the BBEd and this can be done even while your
> database is up and running !!
>
> What is their take on this kind of attack(!)s?>
>
>
> Best Regards,
> K Gopalakrishnan
>
>
>
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, November 26, 2002 3:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear list,
>
> Let me toss a hypothetical situation at you.
>
> Say some auditors looked at some of your primary systems,
> and concluded that they had no assurance that someone with
> admin access to the server had not changed financial information
> to benefit themselves, or to falsify financial records for the
> gain of the company.
>
> Not that they might have any proof that something like that
> had been done, but rather, just not proof that it had *not*
> been done.
>
> I've been pondering this for a bit, and it seems to me that if
> someone had good knowledge of both the OS and the
> database (Oracle), as well as having admin rights on the
> server, there are few things you can do to prevent such a person
> from changing data in the database, and completely
> covering his or her tracks.
>
> The platforms in question are Unix, Windows NT and
> Windows 2000.   I've limited it to those as most database
> systems use one of those, and besides, that's all I know.  :)
>
> Consider what steps you might take to audit unauthorized
> transactions performed by an admin.
>
> Oracle Auditing could be used, but someone with admin
> access to the server and database could easily alter the
> records created by system auditing.
>
> You could create an audit table, using a trigger to audit
> sensitive tables.  A materialized view on a remote database
> could be created on sensitive tables to remotely log all
> actions.
>
> In the case of the audit table, that could easily be disabled,
> and then re-enabled after the nefarious DML had completed.
>
> The materialized views might be more difficult to circumvent.
>
> If the remote end is using a dblink to the server employing a
> password that is *different* than that of it's own account at the
> remote server, it should be impossible for someone to completely
> cover the traces of transactions created to falsify data.
>
> The MV  Logs could be dropped, but without access to the MV's
> at the remote server, the MV's would have to be left in place.
>
> These could be used as a reference to look for unauthorized transactions
> in the primary server.  If this same admin has access to the remote
> server where the MV's are, then this can also be circumvented.
>
> There is also the logs created as when logging in as internal
> or sysdba. ( $ORACLE_HOME/rdms/audit/*.aud )
>
> These can simply be deleted.  Some system could be used to save
> these to a remote server, but it would have to run *very* frequently to
> be effective.
>
> Oracle password files could also be used. While this can prevent
> someone from logging in as SYS or SYSTEM while in place, all it
> takes is a change to init.ora, and a database bounce to fix that.
>
> Make your bogus data changes, change the init.ora back and
> bounce the database again.
>
> A somewhat clever person could set this up to automatically
> take place the next time the DB is bounced.
>
> The conclusion I have come to is that the only effective method
> that could be used to create an audit trail for such a scenario is
> to create Materialized Views on sensitive tables, and create them
> on a server that admins are guaranteed to not have access to.
>
> Of course, I may be missing something.  I'm not always one to
> catch all the details right off.  Input, comments, sug

RE: Oracle OS level security

[Fink, Dan]

Jared,
I realize the following is not really an answer, but it may provide
a little food for thought.

Practical:
1. Log miner or other log reading tool could be used to track
changes made through the transaction layer. Some operations can be done with
nologging, but not all and the undo is logged regardless. Yes, it would be
complicated and messy.
2. If you don't trust the SAs and DBAs for the systems, they need to
be replaced. You are absolutely correct that if a person has the knowledge
and motive, almost anything is possible. This is shown time and time again
by corporate embezzlement.
  3. As a DBA, I never want to know root's password. If I need SA type
commands, either use sudo on unix (not sure if there is an equivalent on
NT/2K) or provide exact information to the SA. I work on maintaining a good
relationship with the SAs so we each respect each other's 'turf' and don't
try to do things we are not qualified to do.
4. Changing passwords frequently, especially system generated ones,
leads to people writing them down or otherwise storing them somewhere they
can be accessed. I wonder how many of us have 1 password (with minor
variations) for the overwhelming majority of our systems/logins.
5. Don't make security so onerous and inconvenient that people are
constantly looking for ways around it just so that they can do their job.
This encourages the creation of security holes and a general disregard for
the processes and procedures.
6. If you create a server no admins have access to, how would it be
set up and maintained?

Theoretical
The only truly secure system is the one that is never turned on.
Once power is applied and the system is started, it can be compromised. An
SA can su - oracle and login as sysdba, a DBA can spoof a user, a developer
could insert malicious code. 
I think that the issue is to create and abide by standards and
processes, hire trustworthy personnel and treat them right.
As has been shown recently here in the US, there are significant
business risks from unethical, greedy people. How are these prevented?

Dan Fink

-Original Message-
Sent: Tuesday, November 26, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L


Dear list,

Let me toss a hypothetical situation at you.

Say some auditors looked at some of your primary systems,
and concluded that they had no assurance that someone with
admin access to the server had not changed financial information
to benefit themselves, or to falsify financial records for the
gain of the company.

Not that they might have any proof that something like that 
had been done, but rather, just not proof that it had *not*
been done.

I've been pondering this for a bit, and it seems to me that if
someone had good knowledge of both the OS and the 
database (Oracle), as well as having admin rights on the
server, there are few things you can do to prevent such a person
from changing data in the database, and completely 
covering his or her tracks.

The platforms in question are Unix, Windows NT and
Windows 2000.   I've limited it to those as most database
systems use one of those, and besides, that's all I know.  :)

Consider what steps you might take to audit unauthorized
transactions performed by an admin.

Oracle Auditing could be used, but someone with admin 
access to the server and database could easily alter the 
records created by system auditing.

You could create an audit table, using a trigger to audit
sensitive tables.  A materialized view on a remote database
could be created on sensitive tables to remotely log all
actions.

In the case of the audit table, that could easily be disabled,
and then re-enabled after the nefarious DML had completed.

The materialized views might be more difficult to circumvent.

If the remote end is using a dblink to the server employing a 
password that is *different* than that of it's own account at the 
remote server, it should be impossible for someone to completely
cover the traces of transactions created to falsify data.

The MV  Logs could be dropped, but without access to the MV's
at the remote server, the MV's would have to be left in place. 

These could be used as a reference to look for unauthorized transactions
in the primary server.  If this same admin has access to the remote
server where the MV's are, then this can also be circumvented.

There is also the logs created as when logging in as internal 
or sysdba. ( $ORACLE_HOME/rdms/audit/*.aud )

These can simply be deleted.  Some system could be used to save
these to a remote server, but it would have to run *very* frequently to
be effective.

Oracle password files could also be used. While this can prevent
someone from logging in as SYS or SYSTEM while in place, all it
takes is a change to init.ora, and a database bounce to fix that.

Make your bogus data changes, change the init.ora back and 
bounce the database again.

A somewhat clever person

RE: Open Source Security Comes Under Fire

[DENNIS WILLIAMS]

Patrice - Amazing how these things happen. A few weeks ago a report listed
Microsoft products as among the worst security risks. Microsoft immediately
attacked the report. Then by an amazing coincidence, an "impartial"
organization releases a report stating that Microsoft's greatest competitor,
the "free" people, are actually the greatest security risk. 
Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry
hired the private eye to get some proof that they were just shills for
Microsoft, and the guy was caught dumpster diving?



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 27, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


FYI.
 
 
http://www.eweek.com/article2/0,3959,720533,00.asp

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: 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:The future DBAs?

[Martin Bonner]

I'm a data modeler at heart... that's about 90% of what the military used
me for. Unfortunately, it seems that, at least in this area, when the
economy turns sour, the designers are the first to go.
In my last interview, I was told that they didn't really have enough work
for a full time DBA yet, so the position would also likely be used as a
sysad, a network engineer, a junior programmer, etc...  I suppose
data modelers are dead for the moment. Please contradict me.
Please
Marty
At 02:19 PM 11/26/2002 -0800, you wrote:
Personally, I like Data
Architecture.
And data modeling.  I never could get enough
of that.  The hard part is explaining to people that
don't quite understand the concept.
Dave Hay rules!
http://www.amazon.com/exec/obidos/tg/detail/-/0932633293
Being the sole DBA for the company, I don't get
nearly enough opportunities for this anymore, and
don't have the time for much of it anyway.
Jared


[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/26/2002 10:04 AM
 Please respond to ORACLE-L
 
    To:
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
   
Subject:    Re:The future
DBAs?

Well, I give MicroSlop pretty poor grades for predicting the future
and
Monster.com is absolutely useless (naw make that less than) at job stuff

in
general.  I will agree with the person who wrote the article on one
point. 
 The
job of being a DBA is changing and we all need to remain flexible to

remain
useful in the marketplace.  That in some cases means spreading our
wings 
from
the historical role of DBA.  We may need to become part time (or
full 
time) data
architects, reporting tool experts, etc...  But in the end, I don't
see us
degrading to the level of an order entry clerk nor order entry clerks

upgrading
to DBA's.  As usual the MicroSlop propaganda machine is at work
again. 
Dick Goulet
Reply Separator
Author: "Arup Nanda" <[EMAIL PROTECTED]>
Date:   11/25/2002 5:48 PM
Fellow DBAs and other DBA wannabes,
Ever wondered the best path into a DBA career? Microsoft offers a 
brilliant 
way. MSN Careers at
http://editorial.careers.msn.com/articles/nofuture/

suggests some jobs are effectively dead, like farmers and sewing machine 
operators and how the experts in that field can progress to the next 
logical 
career move. Guess which profession's logical career move is database 
administrator? See the excerpt from the webpage here in the attachment as 
a 
picture.
I just couldn't resist posting it here. May be they are referring to SQL 
Server DBAs?
Arup Nanda



_
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail
 

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

Marty
"All of life's big problems include the words 'indictment' or 'inoperable.' 
 Everything else is small stuff." -
  -Alton Brown, host, 'Good Eats'

Re: Using RECYCLE pool?

[Brian_P_MacLean]

This might me it...

http://www.dbatoolbox.com/WP2001/tuning/multiple_buffer_pools.pdf




   

  Connor McDonald  

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

  Sent by: Subject:  Re: Using RECYCLE pool?   

  [EMAIL PROTECTED] 

   

   

  11/27/02 02:48 AM

  Please respond to

  ORACLE-L 

   

   





Assuming the stuff that you want in the recycle pool
is:

- consuming too much of your default pool
- isn't being used too much

you could so some sampling on x$bh using obj and tch
to make some conclusions.  John Beresniewicz wrote a
paper on this some time ago, but I don't have it handy
- maybe someone else can help.

hth
connor

 --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Is anyone using the Oracle RECYCLE buffer pool? What
> was your criteria to
> select tables? The application I am considering
> RECYCLE for doesn't perform
> table scans, so that eliminates one common
> suggestion.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> --
> 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).
>

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

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

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

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






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.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: Oracle OS level security

[Fink, Dan]

Dennis,
I must respectfully disagree with 1. I would suggest that the 'can'
be changed to a 'cannot'. It is this type of person that will stand up and
say 'This is wrong.' Therein lies your security.

Dan Fink

-Original Message-
Sent: Wednesday, November 27, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L


Jared - I think Thomas has a good point. Here is the way I look at it:

1. Make the server with critical information as secure as possible.
2. Restrict command line or console access to the minimum number of people.
This narrows you down to a few sys admins and DBAs. For them your choices
are:
1. Hire trustworthy professionals, people that can be intimidated by the
threat of being fired.
2. Hire people too stupid to understand how to break into stuff.
3. Configure a really paranoid system to keep the people that must manage
the system from being able to do their job. You could spend a lot of extra
effort on this one. And it would have to be designed and audited by people
outside the company.
   Years ago, a company I worked for tried option 3. It was a mainframe
system with no interactive access. There were three groups of people that
worked there, keypunch operators, programmers, and computer operators. The
theory was that to defraud the system would require more than one person. A
programmer could write a bogus program, but couldn't run it, would need an
operator. And so on. They even had a separate building entrance for each
group. Nobody outside of management seemed to think it was all that secure.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 27, 2002 7:14 AM
To: Multiple recipients of list ORACLE-L


Jared,

Nice question.  I don't have an answer, but a comment.

It all comes down to Risk Management.  In my opinion, Risk Management
entails identifying all known risks to losing or changing data in an
authorized manner.  Once the risks are identified and explained to the
organization, they decide what needs to be dealt with and what they are
willing to "risk" based on the probability of the event actually happening.

In your example, you've identified the risk of allowing other people admin
access on the database server machine.  If management is unwilling to revoke
these privs, then they need to understand the risk that they have accepted.
The risk they've accepted is that someone could, thru the use of stolen
passwords, the BBED editor, or simply deleting a database file, cause a
disruption, loss of service or loss of data to the organization.  And there
is not much you (as the DBA) can do about it.

I'm sure I'm preaching to the choir here.  But a lot of what we (DBA's) do
comes down to communication and education of management, and explaining
things in terms that they can understand.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 26, 2002 6:05 PM
To: Multiple recipients of list ORACLE-L


Dear list,

Let me toss a hypothetical situation at you.

Say some auditors looked at some of your primary systems,
and concluded that they had no assurance that someone with
admin access to the server had not changed financial information
to benefit themselves, or to falsify financial records for the
gain of the company.

Not that they might have any proof that something like that 
had been done, but rather, just not proof that it had *not*
been done.

I've been pondering this for a bit, and it seems to me that if
someone had good knowledge of both the OS and the 
database (Oracle), as well as having admin rights on the
server, there are few things you can do to prevent such a person
from changing data in the database, and completely 
covering his or her tracks.

The platforms in question are Unix, Windows NT and
Windows 2000.   I've limited it to those as most database
systems use one of those, and besides, that's all I know.  :)

Consider what steps you might take to audit unauthorized
transactions performed by an admin.

Oracle Auditing could be used, but someone with admin 
access to the server and database could easily alter the 
records created by system auditing.

You could create an audit table, using a trigger to audit
sensitive tables.  A materialized view on a remote database
could be created on sensitive tables to remotely log all
actions.

In the case of the audit table, that could easily be disabled,
and then re-enabled after the nefarious DML had completed.

The materialized views might be more difficult to circumvent.

If the remote end is using a dblink to the server employing a 
password that is *different* than that of it's own account at the 
remote server, it should be impossible for someone to completely
cover the traces of transactions created to falsify data.

The MV  Logs could be dropped, but without access to the MV's
at the remote server, the MV's would have to be left in place. 

These could be used as a reference to look for u

Re: Pro*C for Oracle 817 on Win2000?

[Igor Neyman]

Title: Pro*C for Oracle 817 on Win2000?



What do you mean, when you say:
"there are libraries for VC++ and Borland, under the 
c:\oracle\ora81\oci directories. Unfortunately I don't have access to these 
programs" ?
Did you set up your C++ project environment/settings properly, 
pointing to OCI dlls?
 
Igor Neyman, OCP DBA[EMAIL PROTECTED]  
 
 

  - Original Message - 
  From: 
  Denham Eva 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, November 27, 2002 10:39 
  AM
  Subject: Pro*C for Oracle 817 on 
  Win2000?
  
  Hello, 
  Apologies if this is the wrong list to write to, 
  but some guidelines would be nice. We have 
  a legacy software which requires changing. I would like to achieve this but as 
  far as I can see there is no pro*c on otn.oracle.com for Win2k?
  Is it possible to load the libraries from 
  somewhere? I have tried loading the Programmer option of the client, however 
  from the errors received I don't have all the libraries. ie 
sqlca.h.
  I am trying to achieve this feat by using 
  Bloodshed's DevC++. Am I being overly optimistic? I see there are libraries for VC++ and Borland, under the 
  c:\oracle\ora81\oci directories. Unfortunately I don't have access to these 
  programs?
  Any help will appreciated. 
  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