date:20020425


Point 3 sounds correct..

Make sure that you also *monitor the monitor*!! Even if you just set up AT
job or something that runs from a DBA desktop every 10-20 minutes, connects
to the instance and "select 'OK' from dual;" to test the connection.. If it
fails, flag an error through something like "net send" or email..

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


-Original Message-
[EMAIL PROTECTED]
Sent: 24 April 2002 23:04
To: Multiple recipients of list ORACLE-L
question



Thanks all who replied to my E-mail.
Right now I am still leaning toward having a centralized monitoring script
running in a admin database because -
1. Ease of administration
2. We don't need anything fancy, don't need application level monitorin, so
the requirements for different databases are similar.
3. If we use PL/SQL jobs and monitoring tables then all of our scripts can
be backed up as part of the database backup. So if anything happens to the
monitoring server/db all we have to do is recovering the database. We can
even restore the monitoring database to another server if we need to.
I am not certain if point 3 is correct so any thoughts on this?


Dennis Meng
Database Administrator
Focal Communications Corp.



Stephane
Faroult  To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
 Subject: Re: monitoring
multiple databases using PL/SQL
Sent by:
root@fatcity.
com


04/23/02
08:03 PM
Please
respond to
ORACLE-L






Ypu may find the following paper of interest:

   http://www.oriole.com/papers/monitor.html

A few years old, but sits somewhere in the middle as Chris suggests. And
you can use all of his scripts :-).

"Grabowy, Chris" wrote:
>
> Dennis,
>
> True, but you should also consider...
>
> "In a decentralized configuration, the monitoring software or scripts
reside
> with the database.  This complicates maintenance, but allows for higher
> monitoring availability."
>
> I believe that your better off somewhere in the middle.
>
> You can host a set of PL/SQL procs in a "monitoring" schema on each
database
> server to check the basics of the database, and report back to you.  In
this
> configuration, you can enhance and add features to the development
version,
> and make sure it works, before updating all the databases.  Du'oh!!
> Configuration Management!!!
>
> And then you can host specific "are you up/bogus login" scripts on a
central
> host.
>
> Generally, your Oracle database stays up...since it's not SQL
> Server...du'oh!!!  The majority of the database problems are in the
> database, ie. maxextents, no space, performance, blah, blah...there is a
> list in my paper.
>
> Don't forget to collect all this monitoring data in some table(s), as it
> will become useful.
>
> And be sure to CC your boss on all the benefits your monitoring services
> provide you.  Hopefully, some funding will eventually be thrown your way
to
> get a decent monitoring product.
>
> Also, recently I saw a demo of a monitoring product called AutoDBA.  It
is
> very slick, almost like having a junior DBA doing all the boring,
> monitoring, dirty work.  Except it doesn't get your coffee for you...or
wash
> your car...or...
>
> HTH.
>
> Chris Grabowy
>
> DISCLAIMER: I am not in any way associated with the makers of AutoDBA.
My
> paper also includes a list of other monitoring products.
>
> -Original Message-
> Sent: Tuesday, April 23, 2002 1:53 PM
> To: Multiple recipients of list ORACLE-L
>
> >From 'Oracle Database Monitoring for the Beginner' (pdf) - Chris Grabowy
>
> "In a centralized configuration, the monitoring software scripts reside
on
> one server. This obviously makes maintenance easier, but if the hosting
> server fails then there is no (more) monitoring of the databases"
>
> regards
> Madhu
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: monitoring multiple databases using PL/SQL
> >Date: Tue, 23 Apr 2002 08:00:33 -0800
> >
> >Greetings -
> >I am planning to centralize our Oracle monitoring process by using one
> >PL/SQL procedure to query database extents, invalid objects, alert logs
etc
> >through database links. I wonder if anybody has done it before and if
there
> >is any cons with it.  The pros would be ease of administration, ease of
> >standardization etc.
> >
> >TIA
> >
> >Dennis
> >

--
Regards,

Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.

RE: good pl/sql coding/debugging tool?


Other options would also be PL/SQL Developer from
www.allroundautomations.com (though I had heard that they have also been
taken over by Quest), and Lecco SQLExpert from www.leccotech.com (also
available from yours truly ;P)

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance

-Original Message-
[EMAIL PROTECTED]
Sent: 25 April 2002 10:09
To: Multiple recipients of list ORACLE-L



I would suggest you to use TOAD because the DBA Module of this product is
quiet good. Database Monitor and Unix Monitor could also be used. Another
option is SQL Station from CA.


Regards

M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]



"Magaliff, Bill" <[EMAIL PROTECTED]>
lendware.com
Sent by: [EMAIL PROTECTED]
24.04.02 23:18
Please respond to ORACLE-L

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







I'm trying to evaluate tools for pl/sql coding/debugging - main options seem
to be toad, sql navigator (both from quest) and rapid sql (from
embarcadero).

One nice thing I noticed about the embarcadero product is the ability to
debug anonymous blocks . . .but haven't looked seriously into other pl/sql
constructs (i.e., records, types, etc.)

any comments/feedback/suggestions from the group would be greatly
appreciated . . .

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

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

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

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

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

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

Cronjob

2002-04-25 Thread Roland . Skoldblom


Hallo,

I would like to have this cronjob run only in saturday mornings at 6 am. How  could I 
easy change this script?

0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log
 2>&1

Thanks in advance

Roland

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

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

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

Which Server Machine?

2002-04-25 Thread Abdul Aleem


Hi,

What should be the basis of selecting a type of server machine? Single
processor, two processor, four processor
How many years down the road should one plan for?

In web deployment, the web server will have connection(s) with data server
and can be configured for connection sharing. What role the number of
connections between data and web server plays in server selection?

Please do give some solid guidelines.

TIA!

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

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

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

RE: Any scripts to check the health of the database

2002-04-25 Thread Farnsworth, Dave


This is something that I am looking for a way to check on an 8.1.7 database running on 
NT without me physically having to login myself.  Is there some automated way to do 
this, that maybe can send an email to a computer operator??

Thanks,

Dave

-Original Message-
Sent: Wednesday, April 24, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


Personally, I think that many folks go a bit overboard when
it comes to checking the health of a database.

These are the things I like to check for:

* is the database up?  this is the most important tech check
* status of jobs in DBA_JOBS
* space issues.  Will a table be able to extend N times
   without error?
* are the users happy?  This is actually more important
  than any of the technical issues.

There's a lot of other things you can check, but personnaly, I
quit checking them long ago. 

I do log a few things from the database, and periodically store 
the explain plans for SQLin the cache for troubleshooting later 
the things go awry.   This is really not part of a periodic 
health check though, this is a whole different matter.

One thing to keep in mind: Rolling your own helps you to
understand what's being monitored.  :)

Jared







Praveen Sahni <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 12:24 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Any scripts to check the health of the database


Hi All,
I need to write a report on the health of a database.
Please send if any of us have a scripts and any report format for the 
health
of the database.
Thanks in advance
Praveen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praveen Sahni
  INET: [EMAIL PROTECTED]

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

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



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

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

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

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

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

Re: good pl/sql coding/debugging tool?

2002-04-25 Thread Joe Testa


give up windoze, go to linux and use TORA.

joe


[EMAIL PROTECTED] wrote:

>
> I would suggest you to use TOAD because the DBA Module of this product 
> is quiet good. Database Monitor and Unix Monitor could also be used. 
> Another option is SQL Station from CA.
>
>
> Regards
>
> M.Emre HANCIOGLU
> Masterfoods Services GmbH
> ISI Application Support
> Tel : +49 2162 500-576
> Fax: +49 2162 41497
> E-Mail: [EMAIL PROTECTED]
>
>
>
>
>
> *"Magaliff, Bill" <[EMAIL PROTECTED]>*
> lendware.com
> Sent by: [EMAIL PROTECTED]
>
> 24.04.02 23:18
> Please respond to ORACLE-L
>
>
>
> *To:* Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> *cc:*
>
>
>
> *Subject:* good pl/sql coding/debugging tool?
>
>
>
>  
>
> I'm trying to evaluate tools for pl/sql coding/debugging - main 
> options seem
> to be toad, sql navigator (both from quest) and rapid sql (from
> embarcadero).
>
> One nice thing I noticed about the embarcadero product is the ability to
> debug anonymous blocks . . .but haven't looked seriously into other pl/sql
> constructs (i.e., records, types, etc.)
>
> any comments/feedback/suggestions from the group would be greatly
> appreciated . . .
>
> thanks
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Magaliff, Bill
>  INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

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

How to Install oracle 9i on windows cluster.

2002-04-25 Thread ayyappan . subramaniyan


Hi all

I have to install oracle9i on windows 2000 cluster environment. whether i
have to install it in cluster or not. and what are all the steps to follow.

Rgds
Ayyappan.S


This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.

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

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

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

RE: Cronjob

2002-04-25 Thread SARKAR, Samir


0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log 2>&1

Samir

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


-Original Message-
Sent: 25 April 2002 12:43
To: Multiple recipients of list ORACLE-L


Hallo,

I would like to have this cronjob run only in saturday mornings at 6 am. How
could I easy change this script?

0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log
 2>&1

Thanks in advance

Roland

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

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

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


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

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

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

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

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

RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n

2002-04-25 Thread Connor McDonald


hi Mike,

Go to my site (www.oracledba.co.uk), then Tuning =>
Custom Hit Ratio

Enjoy!

Cheers
Connor

 --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]>
wrote: > Ok...ok...ok...enough talk... can somebody
PLEASE
> publish a
> reference location of this script?
> 
> Thanks,
> Mike
> 
> 
> -Original Message-
> Sent: Wednesday, April 24, 2002 8:39 AM
> To: Multiple recipients of list ORACLE-L
> please
> n
> 
> 
> it was also mentioned at the Oracle of Oracles
> closing session, in the
> "top 10 things I learned in San Diego" :)  
> 
> 
> --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > Might have been Dave too, but I mentioned it in my
> "Misunderstandings
> > About Oracle Internals" talk at IOUG on Tuesday...
> > 
> >  
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > [EMAIL PROTECTED]
> > http://www.hotsos.com
> > 
> > 
> > -Original Message-
> > Sent: Monday, April 22, 2002 10:58 PM
> > To: Multiple recipients of list ORACLE-L
> > n
> > 
> > I think it was Dave Ensor...
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> > Sent: Monday, April 22, 2002 6:30 PM
> > 
> > 
> > > Hi Connor,
> > >
> > > Somebody (I think it was Cary) mentioned your
> little PL/SQL
> > procedure
> > that
> > > will provide any required CHR. So you are
> famous, even if you were
> > not
> > > present :)
> > >
> > > And yes, without seeming to migrate to the CHR
> camp, there is some
> > merit
> > in
> > > what you are saying. However, I would suggest
> that tracking
> > 'normal'
> > delta
> > > values of 'cache buffer chain' gets, misses,
> spins and sleeps from
> > > V$SYSTEM_EVENT/V$LATCH, as well as deltas of
> 'table scan rows
> > gotten'
> > vs
> > > 'table fetch by rowid' would be a better 'ratio'
> than the CHR which
> > will
> > > only serve to feed a myth. The former would give
> you some
> > indication
> > of
> > LIO
> > > (and the stress it causes on the system) and the
> latter will
> > indicate
> > raw
> > > requirements that were met but were the ones
> that drove PIO As
> > for
> > me,
> > I
> > > detect changes in the following SQL and page out
> to an on-call DBA
> > when
> > some
> > > set limits are exceeded:
> > >
> > > select event, count(*) from v$session_wait
> > > group by event;
> > >
> > > This does show the 'current' bottleneck and I
> still remain true to
> > the
> > > calling of OWI!!
> > >
> > > John Kanagaraj
> > > Oracle Applications DBA
> > > DBSoft Inc
> > > (W): 408-970-7002
> > >
> > > Grace - Getting something we don't deserve
> > > Mercy - NOT getting something we deserve
> > >
> > > Click on 'http://www.needhim.org' for Grace and
> Mercy that is
> > freely
> > > available!
> > >
> > > ** The opinions and statements above are
> entirely my own and not
> > those
> > of
> > my
> > > employer or clients **
> > >
> > >
> > > > -Original Message-
> > > > From: Connor McDonald
> [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, April 22, 2002 4:44 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RE: Anything new from IOUG? + "OWI"
> Born!!
> > > > (Anjo/Mogens, please
> > > > n
> > > >
> > > >
> > > > I still like to recommend the buffer cache hit
> ratio
> > > > because its so easy to please customers with
> an
> > > > improvement - A plsql routine to generate any
> desired
> > > > hit ratio on a running system is freely
> available for
> > > > download from my site... a consultants dream!
> :-)
> > > >
> > > > But, serious hat on temporarily, there IS
> still a use
> > > > for the buffer hit ratio as a "delta"
> measurement.
> > > > What I mean by this is that you measure it
> every 'n'
> > > > mins/hrs/whatever and store it.  When it
> displays a
> > > > massive dip or a massive increase (ie
> something out of
> > > > the ordinary for *your* system), then whilst
> it
> > > > doesn't necessarily mean anything is wrong -
> it DOES
> > > > mean that something has changed in your
> system, which
> > > > is a good prompt to do some investigation..
> > > >
> > > > hth
> > > > connor
> > > >
> > > >  --- John Kanagaraj <[EMAIL PROTECTED]>
> wrote: >
> > > > Mark,
> > > > >
> > > > > This is from a first-timer at IOUG, so I may
> be way
> > > > > off here.
> > > > >
> > > > > A lot of marketing blurb was thrown out at
> IOUG
> > > > > (probably a lot less than
> > > > > usual, and *much* less than Oracle OpenWorld
> in any
> > > > > case!). As for tools,
> > > > > many vendors were flogging the same ones,
> improved
> > > > > versions maybe. One which
> > > > > did make us say 'wow' was StorageXpert from
> Quest.
> > > > > IMHO, this is an
> > > > > excellent tool, engineered by our very own
> Gaja. I
> > > > > believe details are at
> > > > > the Quest site at www.quest.com. If you have
> EMC
> > > > > disks and are facing
> > > > > performance problems, I believe there is the
> best
> > > > > there is. (Or even if you
> > > > > have other storage devices, it would still
> give you
> > > > > the hots

Re: Cronjob

2002-04-25 Thread Jan Pruner

0 6 * * 6 /d31/app .

Look at man for crontab (on my linux it's man 5 crontab);

 The time and date fields are:

  field  allowed values
  -  --
  minute 0-59
  hour   0-23
  day of month   0-31
  month  0-12 (or names, see below)
  day of week0-7 (0 or 7 is Sun, or use names)

   A field may be an asterisk (*), which always stands for ``first-last''.
***

JP

On Thu 25. April 2002 13:43, you wrote:
> Hallo,
>
> I would like to have this cronjob run only in saturday mornings at 6 am.
> How  could I easy change this script?
>
> 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log 2>&1
>
> Thanks in advance
>
> Roland
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

Re: Cronjob


man cron
man crontab

you really need to do some research on your questions before posting


--- [EMAIL PROTECTED] wrote:
> Hallo,
> 
> I would like to have this cronjob run only in saturday mornings at 6
> am. How  could I easy change this script?
> 
> 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log
>  2>&1
> 
> Thanks in advance
> 
> Roland
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Cronjob

2002-04-25 Thread Thomas, Kevin


Use vi.

-Original Message-
Sent: 25 April 2002 12:43
To: Multiple recipients of list ORACLE-L


Hallo,

I would like to have this cronjob run only in saturday mornings at 6 am. How
could I easy change this script?

0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log
 2>&1

Thanks in advance

Roland

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

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

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

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

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

Re: Cronjob

2002-04-25 Thread cichomitiko


 0 6 * * 6 /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log
 2>&1


__ www.cichomitiko.cjb.net __
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 1:43 PM


> Hallo,
>
> I would like to have this cronjob run only in saturday mornings at 6 am.
How  could I easy change this script?
>
> 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log
>  2>&1
>
> Thanks in advance
>
> Roland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

"Can't Break In" and Securing iAS on NT

2002-04-25 Thread Boivin, Patrice J


I am reading through O'Reilly's Apache: The Definitive Guide, 1999.  

On page 42 it says:
"In plain English, this means, once again, that Win32 is not an adequate
platform for running a Web server that has any need for security."

Has anyone been able to get info out of MetaLink on how to secure iAS on NT?


Do you have any info on how to secure iAS on NT?  I was told last year to
install iAS on NT and this year I have been told to "secure the Oracle
servers".

If you have any info, SANS would probably like to see it too, they are
putting together an Oracle security guide.

I like Oracle, in my opinion it's better than anything else out there right
now.  But I have been told to secure the Oracle servers and so far I appear
to have hit a brick wall with the MetaLink helpdesk people, they keep asking
me if I have specific concerns.

I asked them to tell me if the local administrator account is the right one
to use for installing Oracle software on NT, one technical analyst quoted
installation notes saying that a new account should be created and placed in
the local administrators group; another told me that the local administrator
account is fine; the third one hard closed my TAR without answering my
question.  He figured that since I had asked the same question for iAS, OEM
and the rdbms, he didn't need to answer my question.

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: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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

RE: Curious question about flushing the Pool

2002-04-25 Thread Connor McDonald


True - but then you're up for a definition of what
constitutes filthy?

A query like

"select to_char(x,'...'), substr(y,1,3),instr(..)"

(ie insert any appropriate Oracle function that could
have static numeric/character arguments)

and suddenly its "filthy"...Still, I'd like something
more dramatic like 

(First run)
"ORA-12345: Your SQL contains literals - could be a
bad idea"

(On cache reload)

"ORA-12346: Look I've told you already - fix that SQL"

:-)

Connor

 --- Cary Millsap <[EMAIL PROTECTED]> wrote: > I
think an excellent Oracle kernel enhancement would
> be to bias in the
> LRU scheme against SQL that uses literals, just like
> the buffer cache
> algorithm biases against blocks that are read via
> full-table scan. Think
> about it... What's the likelihood that a SQL
> statement that's filthy
> with literal values will ever be reused again in the
> future? Then why
> store it as if it will ever be shared (i.e., reused)
> in the future?
> 
>  
> Cary Millsap
> Hotsos Enterprises, Ltd.
> [EMAIL PROTECTED]
> http://www.hotsos.com
> 
> 
> -Original Message-
> Sent: Wednesday, April 24, 2002 8:58 PM
> To: Multiple recipients of list ORACLE-L
> 
>  begin rant -
> It's *ALWAYS* a good idea to try to understand the
> underlying causes,
> for
> any and every situation.  Too often people attempt
> to attack new
> problems
> with the same approach that they used before (or
> heard some "guru"
> advise),
> in a different context, in a different environment,
> on a different stack
> of
> technology, across a different mix of versions, with
> differing
> requirements
> for business rules, performance, availability, and
> end-user
> expectations.
> This might imply that all prior knowledge and
> experience is worthless,
> but
> rather it should simply imply that everything is
> changing constantly and
> you
> have to understand *why* something works instead of
> simply remembering
> *what* works in order to act appropriately...
> 
> Sometimes, we'll try to save time by skipping the
> "understand why"
> steps,
> and sometimes you get away with it, and other times
> you get bit.  After
> all,
> we're only human.  I like the quote by the British
> author and
> large-animal
> country veterinarian James Herriott -- "Veterinary
> practice (substitute
> "database administration") gives one ample
> opportunity to make a
> complete
> ass of oneself".  I've proven this many times
> over...  ;-)
>  end rant -
> 
> In the case of flushing the shared pool, it is a
> valid response to the
> problem of OLTP applications not utilizing
> "bind-variables" and
> bollixing up
> the Shared SQL Area.  In this case, using ALTER
> SYSTEM FLUSH SHARED_POOL
> is
> very much analogous to using chemo-therapy to treat
> cancer.  The cure is
> very nearly as debilitating as the disease, but it
> works.
> 
> I've always seen the use of FLUSH SHARED_POOL as the
> last resort when
> the
> problem is entirely in the hands of the application,
> provided the Oracle
> version is 8.1.6 or less.  CURSOR_SHARING was
> introduced in 8.1.6, but
> it
> didn't work until 8.1.7.3, I understand.  To this
> day, I've not yet
> encountered that type of malicious application in a
> database of version
> 8.1.7 or above (yet!), so I've not used
> CURSOR_SHARING yet...
> 
> Without the availability of the CURSOR_SHARING=FORCE
> functionality, the
> Shared SQL Area is simply at the mercy of the
> application.  As I
> visualize
> it (and I could be very wrong!), there is little
> contention as long as
> the
> Shared SQL Area is *filling up*.  Once it is *full*,
> however, is when
> contention starts.  Once the Shared SQL Area has
> filled, it becomes
> necessary for the RDBMS must find an entry to
> age-out of the cache
> instead
> of just simply locating the next empty slot.  So,
> frequent usage of the
> FLUSH SHARED_POOL command continually keeps the
> Shared SQL Area on a
> less-contentious "always filling" basis, rather than
> the
> very-contentious
> "gotta-pitch-one-to-make-room-for-another" basis. 
> SQL is not being
> re-used,
> but it's not being re-used anyway -- using FLUSH
> SHARED_POOL has no
> impact
> on that.  At least, that's my simple-minded way of
> looking at it...
> 
> Anyway, if this is the problem they are facing, then
> a script to
> periodically (i.e. 5 mins?  30 mins?  60 mins?)
> FLUSH SHARED_POOL may be
> the
> only way to survive.  However, if there is another
> alternative, then it
> might be worthwhile to attempt to talk them off the
> precipice...
> 
> Comments?  Corrections?  Rants?
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, April 24, 2002 5:53 PM
> 
> 
> > I see a couple of folks who want to
> > know how to flush the pool or are looking
> > for a script to do it automatically.
> >
> > Shouldn't we be asking what is causing
> > the behavior that got us to this quandry
> > in the first place ?
> >
> > Just a stupid question .. I

Re: Curious question about flushing the Pool


Minor correction, cursor_sharing did work in versions under 8.1.7.3 (I
used it in 8.1.6) but there was a bug relating to very specific usage.
I never encountered it, I know you can look up the details of the bug
on Metalink.

Having said that, I used cursor_sharing=force instead of flushing the
shared pool because it does almost entirely eliminate the "out of
memory" error, while flushing, if you misset the timing, doesn't.

We had programmers who did not want to use bind variables (Java
prepared statements) and so, for an OLTP system where they were looking
up registration information, we ended up with each SQL statement,
differing only by the constant value being looked up, in the shared
pool.   

I lost the fight to have the code fixed, and so turned on
cursor_sharing. Worked like a charm

Rachel
--- Tim Gorman <[EMAIL PROTECTED]> wrote:
>  begin rant -
> It's *ALWAYS* a good idea to try to understand the underlying causes,
> for
> any and every situation.  Too often people attempt to attack new
> problems
> with the same approach that they used before (or heard some "guru"
> advise),
> in a different context, in a different environment, on a different
> stack of
> technology, across a different mix of versions, with differing
> requirements
> for business rules, performance, availability, and end-user
> expectations.
> This might imply that all prior knowledge and experience is
> worthless, but
> rather it should simply imply that everything is changing constantly
> and you
> have to understand *why* something works instead of simply
> remembering
> *what* works in order to act appropriately...
> 
> Sometimes, we'll try to save time by skipping the "understand why"
> steps,
> and sometimes you get away with it, and other times you get bit. 
> After all,
> we're only human.  I like the quote by the British author and
> large-animal
> country veterinarian James Herriott -- "Veterinary practice
> (substitute
> "database administration") gives one ample opportunity to make a
> complete
> ass of oneself".  I've proven this many times over...  ;-)
>  end rant -
> 
> In the case of flushing the shared pool, it is a valid response to
> the
> problem of OLTP applications not utilizing "bind-variables" and
> bollixing up
> the Shared SQL Area.  In this case, using ALTER SYSTEM FLUSH
> SHARED_POOL is
> very much analogous to using chemo-therapy to treat cancer.  The cure
> is
> very nearly as debilitating as the disease, but it works.
> 
> I've always seen the use of FLUSH SHARED_POOL as the last resort when
> the
> problem is entirely in the hands of the application, provided the
> Oracle
> version is 8.1.6 or less.  CURSOR_SHARING was introduced in 8.1.6,
> but it
> didn't work until 8.1.7.3, I understand.  To this day, I've not yet
> encountered that type of malicious application in a database of
> version
> 8.1.7 or above (yet!), so I've not used CURSOR_SHARING yet...
> 
> Without the availability of the CURSOR_SHARING=FORCE functionality,
> the
> Shared SQL Area is simply at the mercy of the application.  As I
> visualize
> it (and I could be very wrong!), there is little contention as long
> as the
> Shared SQL Area is *filling up*.  Once it is *full*, however, is when
> contention starts.  Once the Shared SQL Area has filled, it becomes
> necessary for the RDBMS must find an entry to age-out of the cache
> instead
> of just simply locating the next empty slot.  So, frequent usage of
> the
> FLUSH SHARED_POOL command continually keeps the Shared SQL Area on a
> less-contentious "always filling" basis, rather than the
> very-contentious
> "gotta-pitch-one-to-make-room-for-another" basis.  SQL is not being
> re-used,
> but it's not being re-used anyway -- using FLUSH SHARED_POOL has no
> impact
> on that.  At least, that's my simple-minded way of looking at it...
> 
> Anyway, if this is the problem they are facing, then a script to
> periodically (i.e. 5 mins?  30 mins?  60 mins?) FLUSH SHARED_POOL may
> be the
> only way to survive.  However, if there is another alternative, then
> it
> might be worthwhile to attempt to talk them off the precipice...
> 
> Comments?  Corrections?  Rants?
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 24, 2002 5:53 PM
> 
> 
> > I see a couple of folks who want to
> > know how to flush the pool or are looking
> > for a script to do it automatically.
> >
> > Shouldn't we be asking what is causing
> > the behavior that got us to this quandry
> > in the first place ?
> >
> > Just a stupid question .. I know !
> >
> > Peace !
> >
> > Mike
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Johnson, Michael
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> -

RE: 9i new features, the saga continues?

2002-04-25 Thread Jamadagni, Rajendra




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

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 9:14 
  AMTo: Multiple recipients of list ORACLE-LSubject: 9i 
  new features, the saga continues?
  Ok life has slowed down some and i've got some free time to potentially 
  pickup the 9i new features saga i did about 6 months ago.
   
  Anyone still interested?
   
  The next on the list was 9i data guard.
   
  joe
   

***1

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

***1

RE: Any scripts to check the health of the database

2002-04-25 Thread Boivin, Patrice J


You can send e-mails using UTL_TCP and UTL_SMTP, see MetaLink for example.

Alternatively you can run crontab for Windows or AT jobs regularly and use
something like blat to send alerts when certain conditions occur.

You have to maintain the scripts though.  Scripting on NT / Win2K is (er...)
disingenuous.

For example you can use freeware utilities like grade to compare the length
of files.

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]


 -Original Message-
Sent:   Thursday, April 25, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Any scripts to check the health of the database

This is something that I am looking for a way to check on an 8.1.7 database
running on NT without me physically having to login myself.  Is there some
automated way to do this, that maybe can send an email to a computer
operator??

Thanks,

Dave

-Original Message-
Sent: Wednesday, April 24, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


Personally, I think that many folks go a bit overboard when
it comes to checking the health of a database.

These are the things I like to check for:

* is the database up?  this is the most important tech check
* status of jobs in DBA_JOBS
* space issues.  Will a table be able to extend N times
   without error?
* are the users happy?  This is actually more important
  than any of the technical issues.

There's a lot of other things you can check, but personnaly, I
quit checking them long ago. 

I do log a few things from the database, and periodically store 
the explain plans for SQLin the cache for troubleshooting later 
the things go awry.   This is really not part of a periodic 
health check though, this is a whole different matter.

One thing to keep in mind: Rolling your own helps you to
understand what's being monitored.  :)

Jared







Praveen Sahni <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 12:24 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Any scripts to check the health of the database


Hi All,
I need to write a report on the health of a database.
Please send if any of us have a scripts and any report format for the 
health
of the database.
Thanks in advance
Praveen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praveen Sahni
  INET: [EMAIL PROTECTED]

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

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



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

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY,

9i new features, the saga continues?

2002-04-25 Thread JOE TESTA




Ok life has slowed down some and i've got some free time to potentially 
pickup the 9i new features saga i did about 6 months ago.
 
Anyone still interested?
 
The next on the list was 9i data guard.
 
joe

Re: Cronjob



Roland,

Use the following command from the unix prompt:

man crontab

It'll tell you everything you need to know about changing the times of jobs
scheduled via cron.   If you look it up and figure it out yourself, you'll
never need to ask about it again.   However, if you just cut and paste
someone's response with the answer in it, you'll have to keep coming back
here to ask every time you want to reschedule a job.

Cherie Machler
Oracle DBA
Gelco Information Network


   

Roland.Skoldbl 

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

[EMAIL PROTECTED]   Subject: Cronjob  

om 

   

   

04/25/02 06:43 

AM 

Please respond 

to ORACLE-L

   

   





Hallo,

I would like to have this cronjob run only in saturday mornings at 6 am.
How  could I easy change this script?

0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log
 2>&1

Thanks in advance

Roland

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

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

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




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

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

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

RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n

2002-04-25 Thread Karniotis, Stephen


Good morning everyone:

  Since everyone was wondering what the Top 10 things were from IOUG Live!,
I went to the source:  Ian Abramson, Director of Educational Programming for
the IOUG and the person that provided this jocularity.  Here they are:

Here is the top 10 list:
Top 10 Lessons Learned at IOUG Live 2002
>From the home office in Chicago, IL
11. (added during speech) If you go to Tijuana don't drink the water 10.
Scott Tiger is real!
9.  Finding ways to bring humor into your workday does not mean laughing
after doing a shutdown abort on your production database  by mistake.
8.  Kellogg's may have a Mini-Wheat, but the IOUG has a Mini-Dean 7.  It is
possible to print an onsite agenda on the head of a pin or grain of rice.
6.  SQL*Net = The dollar amount derived by subtracting the money generated
by owning Oracle from the cost of the license.
5.  You will find your way around the Convention Center not later than
Thursday afternoon
4.  San Diego is colder than Canada
3.  Hashing is not illegal
2.  In the brain of the DBA. "Session 504 has been moved to room 30A" means
"alter session 504 move tablespace 30A"
And the #1 thing I learned at IOUG Live
1.  IOUG Live Sandwiches are made by Oracle  you can't break in!

Ian Abramson


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, April 24, 2002 7:08 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens,
please n

no, the Tijuana trip we were very careful not to drink the water (hm,
that left only alcohol!)

I just didn't write them down, was having too much fun just listening
to them


--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> >> I don't remember the rest
> 
> Was that because of the water in Tijuana?? :-))
> Sorry I missed out on that, but I got otherwise 
> involved in something.
> 
> RF
> 
> -Original Message-
> Sent: Wednesday, April 24, 2002 3:28 PM
> To: Multiple recipients of list ORACLE-L
> please
> n
> 
> 
> One I know was "bring a coat to San Diego"
> 
> for those of you not at IOUG, San Diego, a city that is supposedly
> warm
> was COLD and everyone was freezing there
> 
> they added a "zero" -- when you go to Tijuana, don't drink the water"
> 
> I don't remember the rest
> 
> 
> --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> > So, do you remember the other top 10 items??
> > 
> > Robert
> > 
> > -Original Message-
> > Sent: Wednesday, April 24, 2002 11:39 AM
> > To: Multiple recipients of list ORACLE-L
> > please
> > n
> > 
> > 
> > it was also mentioned at the Oracle of Oracles closing session, in
> > the
> > "top 10 things I learned in San Diego" :)  
> > 
> > 
> > --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > > Might have been Dave too, but I mentioned it in my
> > "Misunderstandings
> > > About Oracle Internals" talk at IOUG on Tuesday...
> > > 
> > >  
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > [EMAIL PROTECTED]
> > > http://www.hotsos.com
> > > 
> > > 
> > > -Original Message-
> > > Sent: Monday, April 22, 2002 10:58 PM
> > > To: Multiple recipients of list ORACLE-L
> > > n
> > > 
> > > I think it was Dave Ensor...
> > > 
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Monday, April 22, 2002 6:30 PM
> > > 
> > > 
> > > > Hi Connor,
> > > >
> > > > Somebody (I think it was Cary) mentioned your little PL/SQL
> > > procedure
> > > that
> > > > will provide any required CHR. So you are famous, even if you
> > were
> > > not
> > > > present :)
> > > >
> > > > And yes, without seeming to migrate to the CHR camp, there is
> > some
> > > merit
> > > in
> > > > what you are saying. However, I would suggest that tracking
> > > 'normal'
> > > delta
> > > > values of 'cache buffer chain' gets, misses, spins and sleeps
> > from
> > > > V$SYSTEM_EVENT/V$LATCH, as well as deltas of 'table scan rows
> > > gotten'
> > > vs
> > > > 'table fetch by rowid' would be a better 'ratio' than the CHR
> > which
> > > will
> > > > only serve to feed a myth. The former would give you some
> > > indication
> > > of
> > > LIO
> > > > (and the stress it causes on the system) and the latter will
> > > indicate
> > > raw
> > > > requirements that were met but were the ones that drove PIO
> > As
> > > for
> > > me,
> > > I
> > > > detect changes in the following SQL and page out to an on-call
> > DBA
> > > when
> > > some
> > > > set limits are exceeded:
> > > >
> > > > select event, count(*) from v$session_wait
> > > > group by event;
> > > >
> > > > This does show the 'current' bottleneck and I still remain true
> > to
> > > the
> > > > calling of OWI!!
> > > >
> > > > John Kanagaraj
> > > > Oracle Applications DBA
> > > > DBSoft Inc
> > > > (W): 408-970-7002
> > > >
> > > > Grace - Getting something we d

Re: Cronjob

2002-04-25 Thread Ron Rogers


Roland,
 The crontab fields are defined as:
1 2 3 4 5 "program to execite"

1 = minutes after the hour 0-59
2 = hours of the day 0-23
3 = days of the month 1-31
4 = months of the year 1-12
5 = days of the week 0-6 0=Sunday
   * = all possible values
0 6 * * 6  job to be run is placed here.
States that the job will run at 0 minutes after the hour of 6 on day 6
,all days of the month, all months of the year.
If you want to run the job only once use the "at" command.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 04/25/02 07:43AM >>>
Hallo,

I would like to have this cronjob run only in saturday mornings at 6
am. How  could I easy change this script?

0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log
 2>&1

Thanks in advance

Roland

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

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

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

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

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

OLAP Financial Function Calculators for Oracle 9i.

2002-04-25 Thread SRAJENDRAN


Hi


I would like to know if the Oracle Express feature of Financial Function
Calculators 
are available with Oracle enterprise Edition 9.0.1.0.0. 
If my memory serves me correctly , I think Oracle has incorporated OLAP
services as part of
the 9i database enterprise edition.  But I am not certain if Financial
Functions such as IRR, NPV are part
of the embedded OLAP services in Oracle 9i enterprise Edition .

I am specifically looking for functions such as IRR, NPV, etc.
Here are some of the functions:
DEPRDECL Calculates declining?balance depreciation
DEPRDECLSW Calculates depreciation using a combination of the
decliningbalance
and straight-line methods
DEPRSL Calculates straight?line depreciation
DEPRSOYD Calculates sum?of?year?s?digits depreciation
FINTSCHED Calculates the interest on a series of fixed?rate installment
loans
FPMTSCHED Calculates payments for a series of fixed?rate installment loans
GROWRATE Calculates the growth rate of a time-series expression
IRR Calculates the internal rate of return for a stream of cash flows
NPV Calculates the net present value of a stream of cash flows
VINTSCHED Calculates the interest portion of the payments on a series of
variable-rate installment loans
VPMTSCHED Calculates a payment schedule for a series of variable-rate
installment loans


Please let me know what needs to be installed, if this 
functionality is not part of OLAP services of Oracle enterprise edition 
9.0.1.0.0.


Thanks

Srini Rajendran.

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

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

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

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

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

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

RE: Which Server Machine?

2002-04-25 Thread Seefelt, Beth



IMHO, I would never opt for only 1 cpu.  There should be at least 2, if
you are going to be using parallel query, then 4 cpus.  After 4, on many
platforms, there is diminshing return on investment.  That's my rule of
thumb, and I have nothing to base it on but gut feeling.

HTH,

Beth

-Original Message-
Sent: Thursday, April 25, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L


Hi,

What should be the basis of selecting a type of server machine? Single
processor, two processor, four processor
How many years down the road should one plan for?

In web deployment, the web server will have connection(s) with data
server
and can be configured for connection sharing. What role the number of
connections between data and web server plays in server selection?

Please do give some solid guidelines.

TIA!

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

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

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

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

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

Buffer in Import

2002-04-25 Thread Ramon E. Estevez




Does the parameter 
buffer in the import refers to bytes or number of rows ? 
 
Kind of confuse. I 
think it refers to the number of rows.
 
buffer=5  
---> is that 5 bytes,  or 5 rows 
 
TIA
 
Ramon

Re: good value for optimizer_index_cost_adj

2002-04-25 Thread Bill Pass


My 1/2 cents on this...

Another way of thinking of scattered -vs- sequential
reads is that a scattered read is used when you know
up front that you want to read several blocks and know
which blocks they are. You can then use a vectored
read to do this or farm them all out in parallel using
asynchronous read. Sequential reads implies that you
need the result of each block before you can determine
the next block to read. Therefore you do single block
I/O.

Bill

--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote:
> 
> Well, Tim did say he was making a long story short.
> 
> scattered reads = multiblock reads which are
> typically
> associated with tablescans, but can be index
> fast full
> scans.
> 
> sequential reads = single block reads which are
> typically
> associated with index block reads, table blocks
> accessed
> as a consequence of index block reads, but can
> be
> one-off blocks in table scans and index fast
> full scans
> due to the existence of previously buffered
> blocks or
> tail-end blocks on extents.
> 
> And then there are cached LOB reads and 
> 
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
> Author of:
> Practical Oracle 8i: Building Efficient Databases
> 
> Next Seminar - Australia - July/August
> http://www.jlcomp.demon.co.uk/seminar.html
> 
> Host to 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: 25 April 2002 00:21
> 
> 
> |> "db file scattered read" (associated with FULL
> |>  table scans) and "db file sequential
> |>  read" (associated with indexed scans)
> |
> |But see, Tuning 101, p. 35, where a "db file
> sequential read" is
> |investigated and the waits are found to be reads
> from a *table*.
> |
> |And other examples elsewhere, where "db file
> scattered read" is found
> to be
> |associated with reads from an index.
> |
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jonathan Lewis
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]

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

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

Re: Anyone using Enterprise Manager?

2002-04-25 Thread rchalton



Check out note 114682.1 on Metalink.
   
 
   
 
   
 






Abdul Aleem <[EMAIL PROTECTED]>@fatcity.com on 25-04-2002 10:43:23

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



Hi,

I have this problem with starting 9i EM as connected to Management Server

After installation and configuration I started with default sysman. And
changed the password after first login. It worked fine for that session but
after closing and then restarting, EM Console does not seem to be
recognizing the console username and password. It displays VTK-1000 error.

As suggested by someone, I looked for sysman listed in Win2K users, it
wasn't so I created it and assigned ORA_DBA group. Still it doesn't work.

Any ideas? Changing password?

TIA!

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

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

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





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

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

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

RE: Is sqlplus too slow to unload data?

2002-04-25 Thread Kimberly Smith

Hey Jared,
I got quite a few folks waiting for your book now.  I am really pushing
Perl at the office:-)  When is the scheduled release again?

-Original Message-
Sent: Thursday, April 25, 2002 12:03 AM
To: Multiple recipients of list ORACLE-L

On Tuesday 23 April 2002 21:53, Bin Wang wrote:
> Hi,
> Our application uses sqlplus + sqlloader to transfer data between
>  databases. It takes nearly four hours to unload to data to flat
>  files(1G), which is far too slow. In the application, the query looks
>  like the following. All those &3,&4,&5 are for sqlldr format.

How about using Perl?

Below is a script I just used to unload a table.  Not very big, but this
is just from one of my test databases at home on a Linux box.

It unloaded about 12,000 rows in less than 2 seconds.  This include
writing them to a file.  This script creates a file of .dmp.

$> time ul.pl -database ts01 -username orades -password orades \
-table 'I$RM_PROPERTY_MAPS'

1.22s real 1.07s user 0.04s system

Doing the same thing with SQL*plus took 4.46 seconds.

You must have DBI and DBD::Oracle installed to use this.

Jared

#!/usr/bin/perl

# ul.pl - unload a table

use warnings;
use FileHandle;
use DBI;
use strict;

use Getopt::Long;

my %optctl = ();

Getopt::Long::GetOptions(
\%optctl,
"database=s",
"username=s",
"password=s",
"table=s",
"sysdba!",
"sysoper!",
"z","h","help");

#setup environment - homegrown package

my($db, $username, $password, $connectionMode);

$connectionMode = 0;
if ( $optctl{sysoper} ) { $connectionMode = 4 }
if ( $optctl{sysdba} ) { $connectionMode = 2 }

if ( ! defined($optctl{database}) ) {
Usage();
die "database required\n";
}
$db=$optctl{database};

if ( ! defined($optctl{username}) ) {
Usage();
die "username required\n";
}

if ( ! defined($optctl{table}) ) {
Usage();
die "table required\n";
}

$username=$optctl{username};
$password = $optctl{password};

my $dbh = DBI->connect(
'dbi:Oracle:' . $db,
$username, $password,
{
RaiseError => 1,
AutoCommit => 0,
ora_session_mode => $connectionMode
}
);

die "Connect to  $db failed \n" unless $dbh;

# time and adjust row cache size
$dbh->{RowCacheSize} = 5000;

my $MySql="select * from $optctl{table}";

my $sth = $dbh->prepare($MySql);

$sth->execute;

open(OUT,">$optctl{table}.dmp") || die "cannot create $optctl{table}.dmp -
$!\n";

my $delimiter = '~';

no warnings;  # don't raise warnings on null columns
while( my $ary = $sth->fetchrow_arrayref ) {
print OUT join($delimiter,@{$ary}), "\n";
}
use warnings;

$sth->finish;
$dbh->disconnect;

sub Usage {
print "\n";
print "usage:  ul.pl\n";
print "ul.pl -database dv07 -username scott -password tiger -table emp
[-sysdba || -sysoper]\n";
print "\n";
}

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

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

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

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

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

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

RE: Number of File systems to use.

2002-04-25 Thread Johnson Poovathummoottil


Thank you very much Robert Freeman for your opinion. I
am half way through your book of 9i new features. It
is very good.

Could some one else give some opinion on the need to
spread IO even when using EMC storage please. 




--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> I'd stick to the idea of fewer file systems. Here is
> why:
> 
> 1. Shorter system reboot time (fsck doesn't take as
> long with 
> fewer file systems).
> 
> 2. Fewer file systems reduce the risk of Inode
> corruption.
> 
> 3. Fewer file system easier to manage.
> 
> As for EMC and IO and performance, I'm not sure I'm
> the 
> best person to address that question. 
> 
> RF
> 
> Robert G. Freeman
> Author Oracle9i New Features by Oracle Press
> Mastering Oracle8i By Sybex
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 8:58 AM
> To: LazyDBA.com Discussion
> Subject: Number of File systems to use.
> 
> 
> All,
> 
> Although this has been discussed many times. My boss
> wants other opinions on this.
> 
> We EMC storage whcih uses 9 gig disks.
> We also use veritas volume manager.
> 
> We plan to upgrade our SUN ultra e6500 to sun fire
> 15K
> machine. During to move we want to do a little
> reorg.
> This machine will have 6 partitions, 3 for the OLTP
> databases and 3 for the warehouse.
> 
> The warehouse currently uses 20 file systems 25 GB
> each(3 disks raid S) for data and index. We have
> agreed on making the file systems to use 4 disks and
> stripe it with 256 KB stripe size. There are two
> opinions regarding the number of file systems.
> 
> 1: 50 file systems of 15 GB each. In this case the 4
> disks are not fully used. What is ramainig after the
> 15 GB can be alloted to other file systems other
> than
> the ones used by the database. Advantage IO spread
> over disks.
> 
> 2: 20 file systems of 34 GB each. All four disks are
> fully used. IO over 80 disks.
> 
> Question.: 
> 1:Since we are using EMC do we need to pay so much
> attention to spreading  IO.
> 2: Any problems/advantages in having too many file
> systems.
> 
> Please give all your opinions.
>  
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> 
> 
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> [EMAIL PROTECTED]
> To subscribe:   send a blank email to
> [EMAIL PROTECTED]
> Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

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

No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2



We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2.

While testing our nightly load job that runs in two simultaneous
streams (ascending and descending), we have been getting deadlock
errors.   The trace file shows the the rows waited on are no rows.

In response to a TAR I opened with Oracle, Oracle responded that
the application needs to be rewritten so that there is only a single
stream.   However our developers aren't inclined to do so because
our nightly window isn't long enough for a single job and because
this application worked fine as is on 8.0.4.

Our developers have discovered an old article (perhaps from 7.3.4 times)
by Roger Snowdent "The Deadly Embrace (Oracle Locking Strategies)"
www.dbdomain.com/120197.htm
that indicates this deadlock error with no rows is an indication of an
"insidious table".

The article states that the the INITRANS and PCTFREE parameters
may be set too low for the table in use.

Has anyone encountered this deadlock with norows indicated error
before?  If yes, how did you resolve it?

In our current 8.0.4 datawarehouse database, this partitioned table
has PCTFREE of 10 and INI_TRANS of 1.   The block size is
8k, we are using Sun Solaris 2.6 and Veritas Volume Manager.
As I said, we are preparing to upgrade this to 8.1.7.

What would be an appropriate setting for PCTFREE and INI_TRANS
for this large warehouse partitioned table in these circumstances?

What are our options if we want to change the PCTFREE and INI_TRANS
for new data that gets loaded?   Can we change PCTFREE and INI_TRANS
and then just keep loading more data into an existing partition?   Can
we change these values in new partitions and leave them the same in
existing partitions?   What would be the drawbacks of having some
partitions
with one value for these storage parameters and other partitions with
different
values?

Also, the developers want to know if there is any utility that could be run
to
determine whether other tables might be susceptible to this deadlock
condition.
Something like dbverify or analyze with some validation option?

Thanks in advance for your feedback.

Cherie Machler
Oracle DBA
Gelco Information Network



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

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

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

Re: 9i new features, the saga continues?

2002-04-25 Thread Donita Hilfinger


Joe,

You give interesting points and topics. Yes, I am interested in your 9i new 
features.

Thanks for the time you give to help others.

Have a great weekend,
donita

:Date: Thu, 25 Apr 2002 05:13:37 -0800
:To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
:X-Comment: Oracle RDBMS Community Forum
:X-Sender: "JOE TESTA" <[EMAIL PROTECTED]>
:From: "JOE TESTA" <[EMAIL PROTECTED]>
:Subject: 9i new features, the saga continues?
:X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman
:
:Ok life has slowed down some and i've got some free time to potentially pickup 
the 9i new features saga i did about 6 months ago.
:
:Anyone still interested?
:
:The next on the list was 9i data guard.
:
:joe


  |\  _,,,---,,_ 
ZZZzz /,`.-'`'-.  ;-;;,_ 
_|,4-  ) )-,_. ,\ (-'___
'---''(_/--'  `-'\_)

Donita Hilfinger  [EMAIL PROTECTED]
ISIS Oracle Database AdministratorPh:(303)737-4179
Great-West Life Assurance Co.Fax:(303)737-4850
8515 E. Orchard Rd, m/s 5T2
Englewood, CO 80111

"The promise is remembered long after the conditions attached to it are 
forgotten"
-- author unknown

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

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

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

RE: Curious question about flushing the Pool


okay, who do you still know inside Oracle who can push this
enhancement? sounds eminently reasonable to me!

Rachel
--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> I think an excellent Oracle kernel enhancement would be to bias in
> the
> LRU scheme against SQL that uses literals, just like the buffer cache
> algorithm biases against blocks that are read via full-table scan.
> Think
> about it... What's the likelihood that a SQL statement that's filthy
> with literal values will ever be reused again in the future? Then why
> store it as if it will ever be shared (i.e., reused) in the future?
> 
>  
> Cary Millsap
> Hotsos Enterprises, Ltd.
> [EMAIL PROTECTED]
> http://www.hotsos.com
> 
> 
> -Original Message-
> Sent: Wednesday, April 24, 2002 8:58 PM
> To: Multiple recipients of list ORACLE-L
> 
>  begin rant -
> It's *ALWAYS* a good idea to try to understand the underlying causes,
> for
> any and every situation.  Too often people attempt to attack new
> problems
> with the same approach that they used before (or heard some "guru"
> advise),
> in a different context, in a different environment, on a different
> stack
> of
> technology, across a different mix of versions, with differing
> requirements
> for business rules, performance, availability, and end-user
> expectations.
> This might imply that all prior knowledge and experience is
> worthless,
> but
> rather it should simply imply that everything is changing constantly
> and
> you
> have to understand *why* something works instead of simply
> remembering
> *what* works in order to act appropriately...
> 
> Sometimes, we'll try to save time by skipping the "understand why"
> steps,
> and sometimes you get away with it, and other times you get bit. 
> After
> all,
> we're only human.  I like the quote by the British author and
> large-animal
> country veterinarian James Herriott -- "Veterinary practice
> (substitute
> "database administration") gives one ample opportunity to make a
> complete
> ass of oneself".  I've proven this many times over...  ;-)
>  end rant -
> 
> In the case of flushing the shared pool, it is a valid response to
> the
> problem of OLTP applications not utilizing "bind-variables" and
> bollixing up
> the Shared SQL Area.  In this case, using ALTER SYSTEM FLUSH
> SHARED_POOL
> is
> very much analogous to using chemo-therapy to treat cancer.  The cure
> is
> very nearly as debilitating as the disease, but it works.
> 
> I've always seen the use of FLUSH SHARED_POOL as the last resort when
> the
> problem is entirely in the hands of the application, provided the
> Oracle
> version is 8.1.6 or less.  CURSOR_SHARING was introduced in 8.1.6,
> but
> it
> didn't work until 8.1.7.3, I understand.  To this day, I've not yet
> encountered that type of malicious application in a database of
> version
> 8.1.7 or above (yet!), so I've not used CURSOR_SHARING yet...
> 
> Without the availability of the CURSOR_SHARING=FORCE functionality,
> the
> Shared SQL Area is simply at the mercy of the application.  As I
> visualize
> it (and I could be very wrong!), there is little contention as long
> as
> the
> Shared SQL Area is *filling up*.  Once it is *full*, however, is when
> contention starts.  Once the Shared SQL Area has filled, it becomes
> necessary for the RDBMS must find an entry to age-out of the cache
> instead
> of just simply locating the next empty slot.  So, frequent usage of
> the
> FLUSH SHARED_POOL command continually keeps the Shared SQL Area on a
> less-contentious "always filling" basis, rather than the
> very-contentious
> "gotta-pitch-one-to-make-room-for-another" basis.  SQL is not being
> re-used,
> but it's not being re-used anyway -- using FLUSH SHARED_POOL has no
> impact
> on that.  At least, that's my simple-minded way of looking at it...
> 
> Anyway, if this is the problem they are facing, then a script to
> periodically (i.e. 5 mins?  30 mins?  60 mins?) FLUSH SHARED_POOL may
> be
> the
> only way to survive.  However, if there is another alternative, then
> it
> might be worthwhile to attempt to talk them off the precipice...
> 
> Comments?  Corrections?  Rants?
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 24, 2002 5:53 PM
> 
> 
> > I see a couple of folks who want to
> > know how to flush the pool or are looking
> > for a script to do it automatically.
> >
> > Shouldn't we be asking what is causing
> > the behavior that got us to this quandry
> > in the first place ?
> >
> > Just a stupid question .. I know !
> >
> > Peace !
> >
> > Mike
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Johnson, Michael
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > To REMOVE yo

Oracle ODBC On Windows95 (Don't ask) :)

2002-04-25 Thread Stefan Jakobsson


I need to setup a ODBC connection to an Oracle 8.1.7 database
over TCP/IP where the Client PC's are running Windows 95 (Old
clunkers)

Anyone know what I need to do for this? Can I use the 7.3 ODBC
drivers written for Windows95 for connection to a 8.1.7?

I've never done this before and can't find any clear answers
about it on Oracles website.

Would be immensly gratefull for an answer of any kind, even
if it is a "no-can do", then I would know that I dont have
to put any more effort into this :)

Thanks!

Stefan Jakobsson
Arel-Data
[EMAIL PROTECTED]
Tele: 08 - 470 24 00
Fax:  08 - 470 24 24 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jakobsson
  INET: [EMAIL PROTECTED]

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

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

RE: 9i new features, the saga continues?

2002-04-25 Thread Ron Rogers


Joe,
 It took me a while to remember what you were refferring to and a
search of my archived mail but I too  appreciate the information about
9i that you were sending to us.
Thanks for finding the time to spread the knowledge.
Ron
ROR mª¿ªm

-Original Message-
Sent: Thursday, April 25, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L


Ok life has slowed down some and i've got some free time to
potentially
pickup the 9i new features saga i did about 6 months ago.
 
Anyone still interested?
 
The next on the list was 9i data guard.
 
joe
 

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

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

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

RE: 9i new features, the saga continues?

2002-04-25 Thread Hately Mike


So those features aren't new any more; they're 6 months old. =)

Paging Robert Freeman; Joe is cutting into the sales of your book here!!

Grins to all on this sunny afternoon,

Mike Hately




-Original Message-
Sent: Thursday, April 25, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L


Ok life has slowed down some and i've got some free time to potentially
pickup the 9i new features saga i did about 6 months ago.

Anyone still interested?

The next on the list was 9i data guard.

joe


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


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

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

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

UNIX Courses

2002-04-25 Thread Simon Waibale


Hi all,
What Unix courses/modules would you recommend for a budding Oracle DBA
Thanx,
---
CSW
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
  INET: [EMAIL PROTECTED]

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

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

RE: 9i new features, the saga continues?

2002-04-25 Thread Jack C. Applewhite




Yes!
Jack C. ApplewhiteDatabase 
Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 
  Thursday, April 25, 2002 8:14 AMTo: Multiple recipients of list 
  ORACLE-LSubject: 9i new features, the saga 
  continues?
  Ok life has slowed down some and i've got some free time to potentially 
  pickup the 9i new features saga i did about 6 months ago.
   
  Anyone still interested?
   
  The next on the list was 9i data guard.
   
  joe

sql monitor

2002-04-25 Thread Daniel Wisser


hi!

i am looking for tools to monitor the SQL of an application that
connects to oracle to analyse it.

whichs tools are available? who has experience with them???

tia & bye

daniel

-- 
Daniel Wisser, Mag.

ISIS Information Systems
Alter Wienerweg 12
A-2344 Ma. Enzersdorf, Austria

Phone: +43-2236-27551-149
Fax: +43-2236-21081
E-mail: [EMAIL PROTECTED]

Hotline: +43-2236-27551-111

Visit the ISIS Website: http://www.isis-papyrus.com

---
This e-mail is only intended for the recipient and not legally 
binding. Unauthorised use, publication, reproduction or 
disclosure of the content of this e-mail is not permitted.
---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

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

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

RE: Curious question about flushing the Pool

2002-04-25 Thread Seefelt, Beth



Wow, I think that's a brilliant idea.  It would be a huge benefit to me, where all of 
our code is VB, and the developers refuse to use bind variables.  My sql area is .5 GB 
and is 95% garbage.


-Original Message-
Sent: Thursday, April 25, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L


okay, who do you still know inside Oracle who can push this
enhancement? sounds eminently reasonable to me!

Rachel
--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> I think an excellent Oracle kernel enhancement would be to bias in
> the
> LRU scheme against SQL that uses literals, just like the buffer cache
> algorithm biases against blocks that are read via full-table scan.
> Think
> about it... What's the likelihood that a SQL statement that's filthy
> with literal values will ever be reused again in the future? Then why
> store it as if it will ever be shared (i.e., reused) in the future?
> 
>  
> Cary Millsap
> Hotsos Enterprises, Ltd.
> [EMAIL PROTECTED]
> http://www.hotsos.com
> 
> 
> -Original Message-
> Sent: Wednesday, April 24, 2002 8:58 PM
> To: Multiple recipients of list ORACLE-L
> 
>  begin rant -
> It's *ALWAYS* a good idea to try to understand the underlying causes,
> for
> any and every situation.  Too often people attempt to attack new
> problems
> with the same approach that they used before (or heard some "guru"
> advise),
> in a different context, in a different environment, on a different
> stack
> of
> technology, across a different mix of versions, with differing
> requirements
> for business rules, performance, availability, and end-user
> expectations.
> This might imply that all prior knowledge and experience is
> worthless,
> but
> rather it should simply imply that everything is changing constantly
> and
> you
> have to understand *why* something works instead of simply
> remembering
> *what* works in order to act appropriately...
> 
> Sometimes, we'll try to save time by skipping the "understand why"
> steps,
> and sometimes you get away with it, and other times you get bit. 
> After
> all,
> we're only human.  I like the quote by the British author and
> large-animal
> country veterinarian James Herriott -- "Veterinary practice
> (substitute
> "database administration") gives one ample opportunity to make a
> complete
> ass of oneself".  I've proven this many times over...  ;-)
>  end rant -
> 
> In the case of flushing the shared pool, it is a valid response to
> the
> problem of OLTP applications not utilizing "bind-variables" and
> bollixing up
> the Shared SQL Area.  In this case, using ALTER SYSTEM FLUSH
> SHARED_POOL
> is
> very much analogous to using chemo-therapy to treat cancer.  The cure
> is
> very nearly as debilitating as the disease, but it works.
> 
> I've always seen the use of FLUSH SHARED_POOL as the last resort when
> the
> problem is entirely in the hands of the application, provided the
> Oracle
> version is 8.1.6 or less.  CURSOR_SHARING was introduced in 8.1.6,
> but
> it
> didn't work until 8.1.7.3, I understand.  To this day, I've not yet
> encountered that type of malicious application in a database of
> version
> 8.1.7 or above (yet!), so I've not used CURSOR_SHARING yet...
> 
> Without the availability of the CURSOR_SHARING=FORCE functionality,
> the
> Shared SQL Area is simply at the mercy of the application.  As I
> visualize
> it (and I could be very wrong!), there is little contention as long
> as
> the
> Shared SQL Area is *filling up*.  Once it is *full*, however, is when
> contention starts.  Once the Shared SQL Area has filled, it becomes
> necessary for the RDBMS must find an entry to age-out of the cache
> instead
> of just simply locating the next empty slot.  So, frequent usage of
> the
> FLUSH SHARED_POOL command continually keeps the Shared SQL Area on a
> less-contentious "always filling" basis, rather than the
> very-contentious
> "gotta-pitch-one-to-make-room-for-another" basis.  SQL is not being
> re-used,
> but it's not being re-used anyway -- using FLUSH SHARED_POOL has no
> impact
> on that.  At least, that's my simple-minded way of looking at it...
> 
> Anyway, if this is the problem they are facing, then a script to
> periodically (i.e. 5 mins?  30 mins?  60 mins?) FLUSH SHARED_POOL may
> be
> the
> only way to survive.  However, if there is another alternative, then
> it
> might be worthwhile to attempt to talk them off the precipice...
> 
> Comments?  Corrections?  Rants?
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 24, 2002 5:53 PM
> 
> 
> > I see a couple of folks who want to
> > know how to flush the pool or are looking
> > for a script to do it automatically.
> >
> > Shouldn't we be asking what is causing
> > the behavior that got us to this quandry
> > in the first place ?
> >
> > Just a stupid question .. I know !
> >
> > Peace !
> >
> > Mike
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >

Re: "Can't Break In" and Securing iAS on NT

2002-04-25 Thread Rodd Holman

Sounds like the only way to secure iAS on NT is not to put it on NT. You might try LINUX. It would at least let you use your existing hardware. And, it's free or relatively cheap depending on distro.

Rodd

On Thu, 2002-04-25 at 07:53, Boivin, Patrice J wrote:

I am reading through O'Reilly's Apache: The Definitive Guide, 1999.

On page 42 it says:
"In plain English, this means, once again, that Win32 is not an adequate
platform for running a Web server that has any need for security."

Has anyone been able to get info out of MetaLink on how to secure iAS on NT?

Do you have any info on how to secure iAS on NT? I was told last year to
install iAS on NT and this year I have been told to "secure the Oracle
servers".

If you have any info, SANS would probably like to see it too, they are
putting together an Oracle security guide.

I like Oracle, in my opinion it's better than anything else out there right
now. But I have been told to secure the Oracle servers and so far I appear
to have hit a brick wall with the MetaLink helpdesk people, they keep asking
me if I have specific concerns.

I asked them to tell me if the local administrator account is the right one
to use for installing Oracle software on NT, one technical analyst quoted
installation notes saying that a new account should be created and placed in
the local administrators group; another told me that the local administrator
account is fine; the third one hard closed my TAR without answering my
question. He figured that since I had asked the same question for iAS, OEM
and the rdbms, he didn't need to answer my question.

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: Boivin, Patrice J
INET: [EMAIL PROTECTED]

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

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

Re: Oracle ODBC On Windows95 (Don't ask) :)

2002-04-25 Thread Rodd Holman





Why not use 8i ODBC.  I know that 8.1.5 installed on Win95.  My guess is that 8.1.7 should too.

If it won't use the 8.1.5 drivers.



Rodd



On Thu, 2002-04-25 at 09:28, Stefan Jakobsson wrote:

I need to setup a ODBC connection to an Oracle 8.1.7 database
over TCP/IP where the Client PC's are running Windows 95 (Old
clunkers)

Anyone know what I need to do for this? Can I use the 7.3 ODBC
drivers written for Windows95 for connection to a 8.1.7?

I've never done this before and can't find any clear answers
about it on Oracles website.

Would be immensly gratefull for an answer of any kind, even
if it is a "no-can do", then I would know that I dont have
to put any more effort into this :)

Thanks!

Stefan Jakobsson
Arel-Data
[EMAIL PROTECTED]
Tele: 08 - 470 24 00
Fax:  08 - 470 24 24 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jakobsson
  INET: [EMAIL PROTECTED]

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

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

DBMS_STATS.gather_database_stats

2002-04-25 Thread Walter K


If you're not supposed to analyze SYS and SYSTEM then 
can anyone explain why the 
DBMS_STATS.GATHER_DATABASE_STATS procedure does?

We have run into scenarios where the data dictionary 
becomes almost unusable until SYS gets analyzed again 
via this procedure. I.e. can't describe v$ views, 
selects against v$ views take forever to return 
results, etc.

The obvious solution is to not use this particular 
procedure but it still begs the question WHY doesn't 
it exclude SYS and SYSTEM? Are there any reasons why 
you would want to analyze these schemas?

Thanks.
-w

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

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

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

RE: 9i new features, the saga continues?




Keep 'em coming Joe!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 25 
  April 2002 14:14To: Multiple recipients of list 
  ORACLE-LSubject: 9i new features, the saga 
  continues?
  Ok life has slowed down some and i've got some free time to potentially 
  pickup the 9i new features saga i did about 6 months ago.
   
  Anyone still interested?
   
  The next on the list was 9i data guard.
   
  joe

Re: Buffer in Import

2002-04-25 Thread Paul Baumgartel

I believe that it refers to bytes.

--- "Ramon E. Estevez" <[EMAIL PROTECTED]> wrote:
> Does the parameter buffer in the import refers to bytes or number of
> rows ? 
>  
> Kind of confuse. I think it refers to the number of rows.
>  
> buffer=5  ---> is that 5 bytes,  or 5 rows 
>  
> TIA
>  
> Ramon
>  
>  
>  
> 

=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

Re: Cronjob

2002-04-25 Thread lynxidajax


I have the same problem but with our vax/vms machine..
could I submit a job queue on every week or maybe every month...

$Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log -
_$/After = "tomorrow+06:00" -
_$sys$geology:[diga.digu]dige.com

I usually submit que every day.. but I want to submit every week and month
or every saturday.
Could I do it on our vax machine?

regards,

Ahmadsyah Alghozi Nugroho
Certified Oracle DBA

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 7:38 PM


> 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log 2>&1
>
> Samir
>
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
>
>
> -Original Message-
> Sent: 25 April 2002 12:43
> To: Multiple recipients of list ORACLE-L
>
>
> Hallo,
>
> I would like to have this cronjob run only in saturday mornings at 6 am.
How
> could I easy change this script?
>
> 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log
>  2>&1
>
> Thanks in advance
>
> Roland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
___
> This email is confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions presented are
> solely those of the author and do not necessarily represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised that you have received
this
> email in error and that any use, dissemination, forwarding, printing, or
> copying of this email is strictly prohibited.
>
> If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

Re: Oracle ODBC On Windows95 (Don't ask) :)

2002-04-25 Thread Gene Sais


Install the 8.1.7 client on 95.

>>> [EMAIL PROTECTED] 04/25/02 10:28AM >>>
I need to setup a ODBC connection to an Oracle 8.1.7 database
over TCP/IP where the Client PC's are running Windows 95 (Old
clunkers)

Anyone know what I need to do for this? Can I use the 7.3 ODBC
drivers written for Windows95 for connection to a 8.1.7?

I've never done this before and can't find any clear answers
about it on Oracles website.

Would be immensly gratefull for an answer of any kind, even
if it is a "no-can do", then I would know that I dont have
to put any more effort into this :)

Thanks!

Stefan Jakobsson
Arel-Data
[EMAIL PROTECTED] 
Tele: 08 - 470 24 00
Fax:  08 - 470 24 24 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Stefan Jakobsson
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

AUDIT_ACTIONS

2002-04-25 Thread Charlie Mengler


103 SESSION REC

I see entries in one of my AUD$ tables with a ACTION = 103
I'd like to know exactly what this action references.
I've searched my 8i online doc set but got no hits.

I'm willing to RTFM is somebody will point me at which FM
I should use in this case.

TIA & HAND!

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct.
858-831-2229  San Diego, CA 92131
Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n

2002-04-25 Thread Brian McGraw


>>1.IOUG Live Sandwiches are made by Oracle  you can't break in!

UnBreakable, InEdible.

Brian

-Original Message-
Stephen
Sent: Thursday, April 25, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L
n

Good morning everyone:

  Since everyone was wondering what the Top 10 things were from IOUG
Live!,
I went to the source:  Ian Abramson, Director of Educational Programming
for
the IOUG and the person that provided this jocularity.  Here they are:

Here is the top 10 list:
Top 10 Lessons Learned at IOUG Live 2002
>From the home office in Chicago, IL
11. (added during speech) If you go to Tijuana don't drink the water 10.
Scott Tiger is real!
9.  Finding ways to bring humor into your workday does not mean laughing
after doing a shutdown abort on your production database  by
mistake.
8.  Kellogg's may have a Mini-Wheat, but the IOUG has a Mini-Dean 7.  It
is
possible to print an onsite agenda on the head of a pin or grain of
rice.
6.  SQL*Net = The dollar amount derived by subtracting the money
generated
by owning Oracle from the cost of the license.
5.  You will find your way around the Convention Center not later than
Thursday afternoon
4.  San Diego is colder than Canada
3.  Hashing is not illegal
2.  In the brain of the DBA. "Session 504 has been moved to room 30A"
means
"alter session 504 move tablespace 30A"
And the #1 thing I learned at IOUG Live
1.  IOUG Live Sandwiches are made by Oracle  you can't break in!

Ian Abramson


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, April 24, 2002 7:08 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens,
please n

no, the Tijuana trip we were very careful not to drink the water (hm,
that left only alcohol!)

I just didn't write them down, was having too much fun just listening
to them


--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> >> I don't remember the rest
> 
> Was that because of the water in Tijuana?? :-))
> Sorry I missed out on that, but I got otherwise 
> involved in something.
> 
> RF
> 
> -Original Message-
> Sent: Wednesday, April 24, 2002 3:28 PM
> To: Multiple recipients of list ORACLE-L
> please
> n
> 
> 
> One I know was "bring a coat to San Diego"
> 
> for those of you not at IOUG, San Diego, a city that is supposedly
> warm
> was COLD and everyone was freezing there
> 
> they added a "zero" -- when you go to Tijuana, don't drink the water"
> 
> I don't remember the rest
> 
> 
> --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> > So, do you remember the other top 10 items??
> > 
> > Robert
> > 
> > -Original Message-
> > Sent: Wednesday, April 24, 2002 11:39 AM
> > To: Multiple recipients of list ORACLE-L
> > please
> > n
> > 
> > 
> > it was also mentioned at the Oracle of Oracles closing session, in
> > the
> > "top 10 things I learned in San Diego" :)  
> > 
> > 
> > --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > > Might have been Dave too, but I mentioned it in my
> > "Misunderstandings
> > > About Oracle Internals" talk at IOUG on Tuesday...
> > > 
> > >  
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > [EMAIL PROTECTED]
> > > http://www.hotsos.com
> > > 
> > > 
> > > -Original Message-
> > > Sent: Monday, April 22, 2002 10:58 PM
> > > To: Multiple recipients of list ORACLE-L
> > > n
> > > 
> > > I think it was Dave Ensor...
> > > 
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Monday, April 22, 2002 6:30 PM
> > > 
> > > 
> > > > Hi Connor,
> > > >
> > > > Somebody (I think it was Cary) mentioned your little PL/SQL
> > > procedure
> > > that
> > > > will provide any required CHR. So you are famous, even if you
> > were
> > > not
> > > > present :)
> > > >
> > > > And yes, without seeming to migrate to the CHR camp, there is
> > some
> > > merit
> > > in
> > > > what you are saying. However, I would suggest that tracking
> > > 'normal'
> > > delta
> > > > values of 'cache buffer chain' gets, misses, spins and sleeps
> > from
> > > > V$SYSTEM_EVENT/V$LATCH, as well as deltas of 'table scan rows
> > > gotten'
> > > vs
> > > > 'table fetch by rowid' would be a better 'ratio' than the CHR
> > which
> > > will
> > > > only serve to feed a myth. The former would give you some
> > > indication
> > > of
> > > LIO
> > > > (and the stress it causes on the system) and the latter will
> > > indicate
> > > raw
> > > > requirements that were met but were the ones that drove PIO
> > As
> > > for
> > > me,
> > > I
> > > > detect changes in the following SQL and page out to an on-call
> > DBA
> > > when
> > > some
> > > > set limits are exceeded:
> > > >
> > > > select event, count(*) from v$session_wait
> > > > group by event;
> > > >
> > > > This does show the 'current' bottlene

RE: Oracle ODBC On Windows95 (Don't ask) :)

2002-04-25 Thread johanna . doran

Title: RE: Oracle ODBC On Windows95 (Don't ask) :)






Are you just trying to setup an ODBC conenction?


In Control Panel, you should see an icon for an ODBC manager where you can add dns entries .  You STILL will need to install Oracle client.  Use the db alias name for the Service name in the ODBC setup.

On 95, I believe that there are 2 sets of Oracle ODBC drivers,  one put out by Oracle and the other by Microsoft. funny but I remember we had to use the Microsoft drivers because we had problems with the Oracle ones.

That's all I really remember, but feel free to get me off list for more specifics if you need them.


Hannah



 -Original Message-

From:   [EMAIL PROTECTED]@SUNGARD   On Behalf Of Stefan Jakobsson <[EMAIL PROTECTED]>

Sent:   Thursday, April 25, 2002 10:28 AM

To: Multiple recipients of list ORACLE-L

Subject:    Oracle ODBC On Windows95 (Don't ask) :)


I need to setup a ODBC connection to an Oracle 8.1.7 database

over TCP/IP where the Client PC's are running Windows 95 (Old

clunkers)


Anyone know what I need to do for this? Can I use the 7.3 ODBC

drivers written for Windows95 for connection to a 8.1.7?


I've never done this before and can't find any clear answers

about it on Oracles website.


Would be immensly gratefull for an answer of any kind, even

if it is a "no-can do", then I would know that I dont have

to put any more effort into this :)


Thanks!


Stefan Jakobsson

Arel-Data

[EMAIL PROTECTED]

Tele: 08 - 470 24 00

Fax:  08 - 470 24 24

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com

--

Author: Stefan Jakobsson

  INET: [EMAIL PROTECTED]


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

San Diego, California    -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).




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

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

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

RE: 9i new features, the saga continues?

2002-04-25 Thread John Hallas










Joe,

That feature was really useful and interesting. I
would be pleased to see you continue it

 

John

 

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jack
C. Applewhite
Sent: 25 April 2002 16:33
To: Multiple recipients of list
ORACLE-L
Subject: RE: 9i new features, the
saga continues?

 

Yes!


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

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of JOE
TESTA
Sent: Thursday, April 25, 2002
8:14 AM
To: Multiple recipients of list
ORACLE-L
Subject: 9i new features, the saga
continues?

Ok life has slowed down some and i've got
some free time to potentially pickup the 9i new features saga i did about 6
months ago.

 

Anyone still interested?

 

The next on the list was 9i data guard.

 

joe

RE: UNIX Courses

2002-04-25 Thread Hately Mike


Simon,

Get hold of a cruddy Intel box.
Install Suse 7.0 Linux and Oracle 8.1.7.
Configure your environment so that your default shell is sh, bsh, or ksh.
Play with it until it breaks.

OReilly's "Learning Unix", "Unix in a Nutshell" and "Learning the Korn
Shell" can help with everything you need to know.
Don Burleson's Unix for Oracle DBAs may help too, I've really only glanced
through it but it looks useful for starters.

As far as classroom courses go, I've never attended one that I thought was
better than teaching myself.

Having said that, if someone else is paying follow Oracle recommended course
path (but build the test box too).

Regards,
Mike Hately


-Original Message-
Sent: 25 April 2002 14:09
To: Multiple recipients of list ORACLE-L


Hi all,
What Unix courses/modules would you recommend for a budding Oracle DBA
Thanx,
---
CSW
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Simon Waibale
  INET: [EMAIL PROTECTED]

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

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


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


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

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

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

What block size are you using for your new 9i data warehouse?



We are building a new version 9.0.1 data warehouse on Sun Solaris 2.6
migrating to Solaris 2.8.  We will be using striped disk that is striped
using Veritas Volume Manager on EMC disk.

The datawarehouse will be about 200 Gig.   It will be written to throughout
the day.

To this point, almost all of our databases have been created with an 8k
block size.   i'm not sure if that blocksize is optimal anymore.   With 9i,
what block sizes are people using in the field nowadays for data
warehouses?

Also, if you use striped disk, what stripe size are you using and why?

Thanks for weighing in on this topic.

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

RE: Curious question about flushing the Pool

2002-04-25 Thread Orr, Steve


> I lost the fight to have the code fixed, and so turned on
> cursor_sharing. Worked like a charm

Been there, done that... but now I feel better knowing that a tenacious
goddess of the DBA battlefields also lost this fight. :-)

It's a tough fight when embedded SQL is scattered all over the place and
development is more concerned with coding the next feature set on "Internet
time." Apart from the tons of embedded SQL, we have a "dynamic SQL
generator" function in our code which creates SQL with literals based on
states or values in webpage check boxes, radio buttons, dropdownlists, text
boxes, etc. Since this is a central, oft-used part of the app I'm hoping to
get duhvelopment to use bind variables in it but it's going to be an uphill
battle. Just the normal frustration in the on-going DBA/Duhveloper battle.
Sigh...


Steve Orr
Bozeman, MONTANA!


-Original Message-
Sent: Thursday, April 25, 2002 6:58 AM
To: Multiple recipients of list ORACLE-L
Importance: High


Minor correction, cursor_sharing did work in versions under 8.1.7.3 (I
used it in 8.1.6) but there was a bug relating to very specific usage.
I never encountered it, I know you can look up the details of the bug
on Metalink.

Having said that, I used cursor_sharing=force instead of flushing the
shared pool because it does almost entirely eliminate the "out of
memory" error, while flushing, if you misset the timing, doesn't.

We had programmers who did not want to use bind variables (Java
prepared statements) and so, for an OLTP system where they were looking
up registration information, we ended up with each SQL statement,
differing only by the constant value being looked up, in the shared
pool.   

I lost the fight to have the code fixed, and so turned on
cursor_sharing. Worked like a charm

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

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

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

RE: 9i new features, the saga continues?

2002-04-25 Thread johanna . doran

Title: RE: 9i new features, the saga continues?






Please refresh me, wasn't this Oracle's answer to Quest's market share?



 -Original Message-

From:   [EMAIL PROTECTED]@SUNGARD   On Behalf Of "JOE TESTA" <[EMAIL PROTECTED]>

Sent:   Thursday, April 25, 2002 9:14 AM

To: Multiple recipients of list ORACLE-L

Subject:    9i new features, the saga continues?



Ok life has slowed down some and i've got some free time to potentially  pickup the 9i new features saga i did about 6 months ago.

 

Anyone still interested?

 

The next on the list was 9i data guard.

 

joe

 




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

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

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

RE: 9i new features, the saga continues?

2002-04-25 Thread Rodd Holman





Go for it Joe!!

I've collected them all so far, and am looking foreward to more.



Rodd



On Thu, 2002-04-25 at 08:33, Jamadagni, Rajendra wrote:

Yes, I am *still* interested Joe.

 

Raj

__



Rajendra Jamadagni      MIS, ESPN Inc.



Rajendra dot Jamadagni at ESPN dot com



Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 



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

-Original Message-

From: JOE TESTA [mailto:[EMAIL PROTECTED]]

Sent: Thursday, April 25, 2002 9:14 AM

To: Multiple recipients of list ORACLE-L

Subject: 9i new features, the saga continues?





Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago.

 

Anyone still interested?

 

The next on the list was 9i data guard.

 

joe

RE: 9i new features, the saga continues?

2002-04-25 Thread Robertson Lee - lerobe




I am still interested. Bring it 
on
 
Cheers
 
Lee

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: 25 April 2002 
  14:14To: Multiple recipients of list ORACLE-LSubject: 9i 
  new features, the saga continues?
  Ok life has slowed down some and i've got some free time to potentially 
  pickup the 9i new features saga i did about 6 months ago.
   
  Anyone still interested?
   
  The next on the list was 9i data guard.
   
  joe
   

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

RE: Buffer in Import

2002-04-25 Thread Ramon E. Estevez




Thanks 
for clarify me.
 
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Hately MikeSent: 
  Thursday, 25 April, 2002 11:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Buffer in Import
  It's 
  bytes.
   
  Regards,
  Mike 
  Hately
  
-Original Message-From: Ramon E. Estevez 
[mailto:[EMAIL PROTECTED]]Sent: 25 April 2002 
15:39To: Multiple recipients of list ORACLE-LSubject: 
Buffer in Import
Does the 
parameter buffer in the import refers to bytes or number of rows ? 

 
Kind of confuse. 
I think it refers to the number of rows.
 
buffer=5  ---> is that 5 bytes, 
 or 5 rows 
 
TIA
 
Ramon
 
 
 
   
  
  This email and any attached to it are confidential 
  and intended only for the individual or 
  entity to which it is addressed. If you are not the 
  intended recipient, please let us know 
  by telephoning or emailing the sender. You should 
  also delete the email and any attachment 
  from your systems and should not copy the email or 
  any attachment or disclose their content 
  to any other person or entity. The views expressed 
  here are not necessarily those of 
  Churchill Insurance Group plc or its affiliates or 
  subsidiaries. Thank you. 
  Churchill Insurance Group plc. Company Registration 
  Number - 2280426. England. 
  Registered Office: Churchill Court, Westmoreland 
  Road, Bromley, Kent BR1 1DP.

ora-470

2002-04-25 Thread O'Neill, Sean


Oracle 8.1.7, W2K SP1.  This AM instance terminated by PMON due to error 470
detected in background process.  List archive showing no matches and
MetaLink articles don't seem to match either.  "Slim" entries for problem in
PMON and CKPT trace files.  Nothing in SMON, LGWR or DBW0.  Anyone got any
experience of this problem, what causes it and most importantly how to
prevent re-occurence =:-0

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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

Re: Cronjob

2002-04-25 Thread Gene Sais


I wrote a DCL script called crontab that re-submits itself every day.  In the script, 
it checks what day it is and submits those jobs.  A lot easier than running multiple 
submit jobs.  I need to change something, I goto the crontab, just like Unix.

Gene

PS. Each OS has its advantages, still looking on Wintel.

>>> [EMAIL PROTECTED] 04/25/02 10:33AM >>>
I have the same problem but with our vax/vms machine..
could I submit a job queue on every week or maybe every month...

$Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log -
_$/After = "tomorrow+06:00" -
_$sys$geology:[diga.digu]dige.com

I usually submit que every day.. but I want to submit every week and month
or every saturday.
Could I do it on our vax machine?

regards,

Ahmadsyah Alghozi Nugroho
Certified Oracle DBA

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 7:38 PM


> 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log 2>&1
>
> Samir
>
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email :  [EMAIL PROTECTED] 
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
>
>
> -Original Message-
> Sent: 25 April 2002 12:43
> To: Multiple recipients of list ORACLE-L
>
>
> Hallo,
>
> I would like to have this cronjob run only in saturday mornings at 6 am.
How
> could I easy change this script?
>
> 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log
>  2>&1
>
> Thanks in advance
>
> Roland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author:
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
___
> This email is confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions presented are
> solely those of the author and do not necessarily represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised that you have received
this
> email in error and that any use, dissemination, forwarding, printing, or
> copying of this email is strictly prohibited.
>
> If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

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

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

RE: Cronjob

2002-04-25 Thread Marc Cure

If I recall correctly, the reason I was editing the crontab in the first
place was to unschedule whatever it was that was filling up /var. Oops.

And this happened back when I was doubling as the sysadmin, so I didn't
really have anyone else to blame. :-) On the other hand, I didn't have to
wait for someone else to restore the crontab from the previous night's
backup; I just went and restored it myself. Ups and downs to everything, I
suppose.

Marc Cure
Oracle DBA, OCP 8i

-Original Message-
Smith
Sent: Thursday, April 25, 2002 12:13 AM
To: Multiple recipients of list ORACLE-L

That's what the SA's are for.  Restore please.  They should have never
let /var get full:-)

-Original Message-
Sent: Wednesday, April 24, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L

You'll lose your entire crontab if you do a crontab -e when /var is full?

(I've had this happen to me on HP-UX...)

Marc Cure
Oracle DBA, OCP 8i

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L

crontab -e is bad!

1000 points if you can figure out why.
( guess I'm watching too much 'Whose Line Is It Anyway?" )

Jared

Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 10:07 AM
Please respond to ORACLE-L

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

crontab -e

On Wed, 24 Apr 2002, bill thater wrote:

> [EMAIL PROTECTED] wrote:
>
> > Anyone whom can tell me how to delete a job that  is  created by
crontab.
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
>
> man crontab
>
>
> --
> --
> Bill "Shrek" Thater  ORACLE DBA
>  [EMAIL PROTECTED]
> 
> You gotta program like you don't need the money,
> You gotta compile like you'll never get hurt,
> You gotta run like there's nobody watching,
> It's gotta come from the heart if you want it to work.
> 
> Your e-mail has been returned due to insufficient voltage.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: bill thater
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

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

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

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

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

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

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

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

RE: 9i new features, the saga continues?

2002-04-25 Thread johanna . doran


All sarcasism aside, I'm interested too :>

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

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

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

Re: 9i new features, the saga continues?

2002-04-25 Thread Suzy Vordos

Yes please, with a cocktail :)

"JOE TESTA" wrote:
> Ok life has slowed down some and i've got some free time to potentially 
> pickup the 9i new features saga i did about
> 6 months ago.
>
> Anyone still interested?
> 
> The next on the list was 9i data guard.
> 
> joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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

RE: AUDIT_ACTIONS

2002-04-25 Thread Taylor, Shirley


Charlie,
I believe this may refer to the ORA- error generated by the attempt. 
Shirley
Systems Admin & Operations | Admin. et Exploit. des systèms
Technology Services | Services technologiques
Informatics Branch  | Direction de l'informatique 
Maritimes Region, DFO   | Région des Maritimes, MPO
(506) 529 5911
[EMAIL PROTECTED]


 -Original Message-
Sent:   Thursday, April 25, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
Subject:AUDIT_ACTIONS

103 SESSION REC

I see entries in one of my AUD$ tables with a ACTION = 103
I'd like to know exactly what this action references.
I've searched my 8i online doc set but got no hits.

I'm willing to RTFM is somebody will point me at which FM
I should use in this case.

TIA & HAND!

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct.
858-831-2229  San Diego, CA 92131
Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

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

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

{9i New Features: DataGuard}

2002-04-25 Thread JOE TESTA




Next installment of 9i new features, like always send hate mail to 
/dev/null.  Also if I've lied in something feel free to correct/flame me 
for it.
 
The Saga continues:
 
Oracle 9i New Features:  9i Data Guard 
So you have Oracle 8i standby database, what is new with 9i standby 
also known as Data Guard.
 
Well in theory it can be totally automated.  In 8i you had to put the 
database in managed recovery mode(or you manually did recovery) on the standby 
db.  I hope no one was doing manual recovery every time a archive log was 
shipped across. :)
 
Now with 9i dataguard, the standby database can be built either:
 
1.  manually just like you did in 8i or2.  automagically with 
OEM Dataguard Wizard(crazy wizards for everything anymore).
 
I personally couldnt get the wizard to work with 9.0.1.0.  Does it 
work now?, I'm not sure as I've not tested it as of recent.  The manual 
method works just fine.
 
Ok so you need to create a standby database, we're not going to cover that 
here, why?, Mostly cause we're only going to cover the new aspects, you all can 
read the docs as well as I can to build the db.
 
On to the new stuff:
 
Your standby database in 8i was only in what we call "delayed" protection 
mode, which means there is a delay from the time the logs are completed on the 
primary database before they are appliedto the standby database.  Now with 
9i, you have 3 other modes:
 
Guaranteed protection: indicates that primary database modifications are 
available to the standby database, up to the last committed transaction.  
The standby database cannot diverge from the primary database at all, and no 
data can be lost. If a standby database is unavailable, processing automatically 
halts on the primary database as well.
 
Instant Protection: With instant protection, the standby database may 
temporarily diverge from the primary database, but upon failover to the standby 
database, the databases can be synchronized, and no data will be lost.
 
Rapid Protection: With rapid protection, the log writer process transmits 
redo logs to the standby sites. Use this mode when availability and performance 
on the primary database are more important than the risk of losing a small 
amount of data.
 
 
 
An important note is that in Guaranteed and Instant protection mode that 
the logs are written in SYNCHRONOUS mode to the standby site. Rapid and Delayed 
mode are ASYNC writes.
 
So this begs to ask what is the difference between Guaranteed and 
Instant?  Well in Guaranteed mode the logs are applied and there is no data 
divergence from the primary and standby db.  Whereas Instant mode there can 
be data divergence but upon failover there will beNO data loss.
 
So since we wont have data loss, there is a new way to "failover" to a 
standby database, called switchover.  
 
You can literally be able to switch to a standby database and switchback to 
the original primary WITHOUT having to reinstantiate(ie: rebuild) the 
primary.  
 
A very nice feature, this gives you the capability to do rolling upgrade of 
OS <-NOTICE, NOT ORACLE BINARIES YET, ONLY THE OS.
 
In 8i you could only do a failover(which required rebuilding the primary), 
you can still do a failover in 9i if you've lost the primary db in some disaster 
like the computer room caught on fire.
 
Now for the automated part:
 
There is the dataguard manager/broker, it can be run from command 
line($ORACLE_HOME/bin/dgmgrl) as well as from OEM.  This gives you the 
luxury of oracle doing all the work to maintain consistency between the primary 
and standby database.  Way too much to cover here but it handles 
automatically applying logs, notification of down standby, etc.
 
Feel free to ask anything about Dataguard to me directly at [EMAIL PROTECTED]
 
Joe

RE: sql monitor


I have *lots* of experience with them ;P

Take a look at SQLExpert:

http://www.cool-tools.co.uk/Products/sqlexpert.html

It can either monitor the SGA for poorly performing SQL, or can read
source/binary/forms type files for "bad" SQL also.. As well as a wealth of
other things - including the best SQL tuning module available in the market
(IMHO).

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


-Original Message-
Wisser
Sent: 25 April 2002 16:03
To: Multiple recipients of list ORACLE-L


hi!

i am looking for tools to monitor the SQL of an application that
connects to oracle to analyse it.

whichs tools are available? who has experience with them???

tia & bye

daniel

--
Daniel Wisser, Mag.

ISIS Information Systems
Alter Wienerweg 12
A-2344 Ma. Enzersdorf, Austria

Phone: +43-2236-27551-149
Fax: +43-2236-21081
E-mail: [EMAIL PROTECTED]

Hotline: +43-2236-27551-111

Visit the ISIS Website: http://www.isis-papyrus.com

---
This e-mail is only intended for the recipient and not legally
binding. Unauthorised use, publication, reproduction or
disclosure of the content of this e-mail is not permitted.
---
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Clob, toad, and a trigger not working

2002-04-25 Thread Shaw John-P55297


I've encountered a weird error (no it's not my boss). It's on W2K and
happens on 8.1.6 an 9i.

I've got two tables with clobs
CREATE TABLE CLOB_TEST ( 
  EIDNUMBER, 
  CLOB_TEST  CLOB ) ; 
--
CREATE TABLE CLOB_TEST_AFTER (
  EIDNUMBER, 
  CLOB_TEST  CLOB ) ; 
and created the following trigger:

CREATE OR REPLACE TRIGGER CLOB_TEST_AI AFTER INSERT ON CLOB_TEST
FOR EACH ROW
DECLARE

   buffer   long;
   len  number(10);
   eid  number;
   clobber  clob;
   sql_stmt varchar2(100);

BEGIN
 eid := :NEW.EID;
 clobber := :NEW.CLOB_TEST;
 len :=  dbms_lob.getlength(clobber);
 DBMS_LOB.READ(clobber,len,1,buffer);
 insert into clob_test_after (eid, clob_test) values (eid, buffer);
END;

This trigger works fine when I do an insert into the first table from
sqlplus 
but when I do an insert from TOAD or another third party application I get
the following error messages:
ora-21560 argument 2 is null, invalid, or out of range
ora-06512 at sys.dbms_lob line 648
ora-06512 at clob_test_ai line 17
ora-04088 error during execution of trigger
clob_test_ai

Anyone know why this error occurs from third party stuff and not from
sqlplus - or better yet a work around?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw John-P55297
  INET: [EMAIL PROTECTED]

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

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

RE: DBMS_STATS.gather_database_stats

2002-04-25 Thread Hately Mike


Walter,
this is actually a bug. It's supposedly fixed in 9i though I haven't tried
it. Anybody?
Do you still see a performance hit when you delete the statistics from the
SYS objects?

Regards,
Mike Hately

-Original Message-
Sent: 25 April 2002 15:33
To: Multiple recipients of list ORACLE-L


If you're not supposed to analyze SYS and SYSTEM then 
can anyone explain why the 
DBMS_STATS.GATHER_DATABASE_STATS procedure does?

We have run into scenarios where the data dictionary 
becomes almost unusable until SYS gets analyzed again 
via this procedure. I.e. can't describe v$ views, 
selects against v$ views take forever to return 
results, etc.

The obvious solution is to not use this particular 
procedure but it still begs the question WHY doesn't 
it exclude SYS and SYSTEM? Are there any reasons why 
you would want to analyze these schemas?

Thanks.
-w



 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


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

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

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

Re: 9i new features, the saga continues?

yes please -- of course, you COULD just post your paper from IOUG :)

--- JOE TESTA <[EMAIL PROTECTED]> wrote:
> Ok life has slowed down some and i've got some free time to
> potentially pickup the 9i new features saga i did about 6 months ago.
> 
> Anyone still interested?
> 
> The next on the list was 9i data guard.
> 
> joe
> 

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

2002-04-25 Thread Stephane Faroult


You mention a partitioned table. Not an IOT I hope? Because SELECTs can cause 
deadlocks on an IOT if you partition it in the process (deadlock on DDL, as opposed to 
DML, locks). I used to have a trigger of death to check it, but I wouldn't recommend 
it, since you have to delete SYS tables to get rid of it :-). Bug encountered in 8.1.6 
and 8.1.7, don't know about 9i, my interest for bugs decreases strongly when I have 
switched to something else, and my professional life is a succession of switches. BTW 
if the deadlock occurs on DDL locks, INITRANS and PCTFREE are totally irrelevant.

>- Original Message -
>From: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Thu, 25 Apr 2002 07:18:30
>
>
>We are testing an upgrade of our warehouse from
>8.0.4 to 8.1.7.2.
>
>While testing our nightly load job that runs in two
>simultaneous
>streams (ascending and descending), we have been
>getting deadlock
>errors.   The trace file shows the the rows waited
>on are no rows.
>
>In response to a TAR I opened with Oracle, Oracle
>responded that
>the application needs to be rewritten so that there
>is only a single
>stream.   However our developers aren't inclined to
>do so because
>our nightly window isn't long enough for a single
>job and because
>this application worked fine as is on 8.0.4.
>
>Our developers have discovered an old article
>(perhaps from 7.3.4 times)
>by Roger Snowdent "The Deadly Embrace (Oracle
>Locking Strategies)"
>www.dbdomain.com/120197.htm
>that indicates this deadlock error with no rows is
>an indication of an
>"insidious table".
>
>The article states that the the INITRANS and
>PCTFREE parameters
>may be set too low for the table in use.
>
>Has anyone encountered this deadlock with norows
>indicated error
>before?  If yes, how did you resolve it?
>
>In our current 8.0.4 datawarehouse database, this
>partitioned table
>has PCTFREE of 10 and INI_TRANS of 1.   The block
>size is
>8k, we are using Sun Solaris 2.6 and Veritas Volume
>Manager.
>As I said, we are preparing to upgrade this to
>8.1.7.
>
>What would be an appropriate setting for PCTFREE
>and INI_TRANS
>for this large warehouse partitioned table in these
>circumstances?
>
>What are our options if we want to change the
>PCTFREE and INI_TRANS
>for new data that gets loaded?   Can we change
>PCTFREE and INI_TRANS
>and then just keep loading more data into an
>existing partition?   Can
>we change these values in new partitions and leave
>them the same in
>existing partitions?   What would be the drawbacks
>of having some
>partitions
>with one value for these storage parameters and
>other partitions with
>different
>values?
>
>Also, the developers want to know if there is any
>utility that could be run
>to
>determine whether other tables might be susceptible
>to this deadlock
>condition.
>Something like dbverify or analyze with some
>validation option?
>
>Thanks in advance for your feedback.
>
>Cherie Machler
>Oracle DBA
>Gelco Information Network
>
>
>
>-- 
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.com
>-- 
>Author: 
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 
>FAX: (858) 538-5051
>San Diego, California-- Public Internet
>access / Mailing Lists
>To REMOVE yourself from this mailing list, send an
>E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of
>'ListGuru') and in
>the message BODY, include a line containing: UNSUB
>ORACLE-L
>(or the name of mailing list you want to be removed
>from).  You may
>also send the HELP command for other information
>(like subscribing).
>---
>-

Stephane Faroult
Oriole Corporation
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--

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

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

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

9i new features, the saga continues?

2002-04-25 Thread Kulev, Milen




There were very interesting collection of 
articles. It would be nice if you continue writing them.

  -Ursprüngliche Nachricht-Von: Mark Leith 
  [mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 25. April 2002 
  16:34An: Multiple recipients of list ORACLE-LBetreff: 
  RE: 9i new features, the saga continues?
  Keep 'em coming Joe!
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 25 
April 2002 14:14To: Multiple recipients of list 
ORACLE-LSubject: 9i new features, the saga 
continues?
Ok life has slowed down some and i've got some free time to potentially 
pickup the 9i new features saga i did about 6 months ago.
 
Anyone still interested?
 
The next on the list was 9i data guard.
 
joe

RE: {9i New Features: DataGuard}

2002-04-25 Thread Arun Chakrapani




I have been working on this dataguard on 8I 
in this u can switch over the production to standby as production and switch 
back to orignal production 
by making the switch over production to 
standby again.
 
The 9i OEM dataguard does not support 8I it 
only supports 9i
so the only option is to run from command 
line.
It is working fine as such i have not faced 
any probs from that.
 

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 1:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: {9i 
  New Features: DataGuard}
  Next installment of 9i new features, like always send hate mail to 
  /dev/null.  Also if I've lied in something feel free to correct/flame me 
  for it.
   
  The Saga continues:
   
  Oracle 9i New Features:  9i Data Guard 
  So you have Oracle 8i standby database, what is new with 9i standby 
  also known as Data Guard.
   
  Well in theory it can be totally automated.  In 8i you had to put 
  the database in managed recovery mode(or you manually did recovery) on the 
  standby db.  I hope no one was doing manual recovery every time a archive 
  log was shipped across. :)
   
  Now with 9i dataguard, the standby database can be built either:
   
  1.  manually just like you did in 8i or2.  automagically 
  with OEM Dataguard Wizard(crazy wizards for everything anymore).
   
  I personally couldnt get the wizard to work with 9.0.1.0.  Does it 
  work now?, I'm not sure as I've not tested it as of recent.  The manual 
  method works just fine.
   
  Ok so you need to create a standby database, we're not going to cover 
  that here, why?, Mostly cause we're only going to cover the new aspects, you 
  all can read the docs as well as I can to build the db.
   
  On to the new stuff:
   
  Your standby database in 8i was only in what we call "delayed" protection 
  mode, which means there is a delay from the time the logs are completed on the 
  primary database before they are appliedto the standby database.  Now 
  with 9i, you have 3 other modes:
   
  Guaranteed protection: indicates that primary database modifications are 
  available to the standby database, up to the last committed transaction.  
  The standby database cannot diverge from the primary database at all, and no 
  data can be lost. If a standby database is unavailable, processing 
  automatically halts on the primary database as well.
   
  Instant Protection: With instant protection, the standby database may 
  temporarily diverge from the primary database, but upon failover to the 
  standby database, the databases can be synchronized, and no data will be 
  lost.
   
  Rapid Protection: With rapid protection, the log writer process transmits 
  redo logs to the standby sites. Use this mode when availability and 
  performance on the primary database are more important than the risk of losing 
  a small amount of data.
   
   
   
  An important note is that in Guaranteed and Instant protection mode that 
  the logs are written in SYNCHRONOUS mode to the standby site. Rapid and 
  Delayed mode are ASYNC writes.
   
  So this begs to ask what is the difference between Guaranteed and 
  Instant?  Well in Guaranteed mode the logs are applied and there is no 
  data divergence from the primary and standby db.  Whereas Instant mode 
  there can be data divergence but upon failover there will beNO data 
  loss.
   
  So since we wont have data loss, there is a new way to "failover" to a 
  standby database, called switchover.  
   
  You can literally be able to switch to a standby database and switchback 
  to the original primary WITHOUT having to reinstantiate(ie: rebuild) the 
  primary.  
   
  A very nice feature, this gives you the capability to do rolling upgrade 
  of OS <-NOTICE, NOT ORACLE BINARIES YET, ONLY THE OS.
   
  In 8i you could only do a failover(which required rebuilding the 
  primary), you can still do a failover in 9i if you've lost the primary db in 
  some disaster like the computer room caught on fire.
   
  Now for the automated part:
   
  There is the dataguard manager/broker, it can be run from command 
  line($ORACLE_HOME/bin/dgmgrl) as well as from OEM.  This gives you the 
  luxury of oracle doing all the work to maintain consistency between the 
  primary and standby database.  Way too much to cover here but it handles 
  automatically applying logs, notification of down standby, etc.
   
  Feel free to ask anything about Dataguard to me directly at [EMAIL PROTECTED]
   
  Joe

Re: AUDIT_ACTIONS

2002-04-25 Thread Suzy Vordos



select * from audit_actions where action=103; shows SESSION REC but not
sure what that means

Charlie Mengler wrote:
> 
> 103 SESSION REC
> 
> I see entries in one of my AUD$ tables with a ACTION = 103
> I'd like to know exactly what this action references.
> I've searched my 8i online doc set but got no hits.
> 
> I'm willing to RTFM is somebody will point me at which FM
> I should use in this case.
> 
> TIA & HAND!
> 
> --
> Charlie Mengler   Maintenance Warehouse
> [EMAIL PROTECTED]  10641 Scripps Summit Ct.
> 858-831-2229  San Diego, CA 92131
> Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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

Re: Curious question about flushing the Pool

2002-04-25 Thread Jonathan Lewis



It sounds a cute idea at first sight (pardon the mixed
metaphor) - but then what do you do about the situation
where you deliberately have a handful of versions of
the 'same' SQL which are identified by the presence of
a literal string;  or the SQL that you build with one
literal and many binds because that one literal is
required to make sure that Oracle uses a histogram
on one column ?

Then there's the problem of literals which are
textually constant but variable valued such as:
sys_context('hr_hierarchy','manager');


Marginal proliferation of 'semi-literate'   SQL
can be a good thing.   Maybe yet another undocumented
hint /*+ bypass_cache_flush */ would be sufficient.

One (trivial ?) thing I'd like to see is SQL normalised
before it goes into the shared pool.  Oracle 9i does it
with stored_outlines - why not with all SQL ?



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

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to 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: 25 April 2002 05:00


I think an excellent Oracle kernel enhancement would be to bias in the
LRU scheme against SQL that uses literals, just like the buffer cache
algorithm biases against blocks that are read via full-table scan.
Think
about it... What's the likelihood that a SQL statement that's filthy
with literal values will ever be reused again in the future? Then why
store it as if it will ever be shared (i.e., reused) in the future?


Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL PROTECTED]
http://www.hotsos.com



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

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

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

Begin backup fails sporadically

2002-04-25 Thread Kip . Bryant


Version is 8.0.6.3.0

I have several databases using the exact same set of generic backup scripts. 
The script that puts all tablespaces into backup mode is generated
automatically and done correctly.  Same is true for the script which takes all
the tablespaces out of backup mode.  The problem I am facing is that when this
script is invoked, one (and only one) of these databases occasionally has
problems.  Some tablespaces are successfully put into backup mode and some say

ORA-01146: cannot start online backup - file 15 is already in backup
ORA-01110: data file 15: '< datafile name >'

The only things that would make sense to me is if two of these scripts were
running in parallel or if the prior day had some weird problem.  Neither of
these seem to be the case.  The only thing that seems to straighten things out 
is to runs these scripts manually.

Ideas?

Regards,
Kip Bryant

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

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

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

Re: DBMS_STATS.gather_database_stats

2002-04-25 Thread Connor McDonald


My guess would be that they took the code straight
from dbms_utility.analyze_database (which does the
same awful thing...)

hth
connor

 --- Walter K <[EMAIL PROTECTED]> wrote: > If
you're not supposed to analyze SYS and SYSTEM
> then 
> can anyone explain why the 
> DBMS_STATS.GATHER_DATABASE_STATS procedure does?
> 
> We have run into scenarios where the data dictionary
> 
> becomes almost unusable until SYS gets analyzed
> again 
> via this procedure. I.e. can't describe v$ views, 
> selects against v$ views take forever to return 
> results, etc.
> 
> The obvious solution is to not use this particular 
> procedure but it still begs the question WHY doesn't
> 
> it exclude SYS and SYSTEM? Are there any reasons why
> 
> you would want to analyze these schemas?
> 
> Thanks.
> -w
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Walter K
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

"Some days you're the pigeon, some days you're the statue"

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

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

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

2002-04-25 Thread Khedr, Waleed


Can you please give more details on: While testing our nightly load job that
runs in two simultaneous
streams (ascending and descending).

What do you mean by descending and ascending (simultaneous)?

Thanks

Waleed

-Original Message-
Sent: Thursday, April 25, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L



We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2.

While testing our nightly load job that runs in two simultaneous
streams (ascending and descending), we have been getting deadlock
errors.   The trace file shows the the rows waited on are no rows.

In response to a TAR I opened with Oracle, Oracle responded that
the application needs to be rewritten so that there is only a single
stream.   However our developers aren't inclined to do so because
our nightly window isn't long enough for a single job and because
this application worked fine as is on 8.0.4.

Our developers have discovered an old article (perhaps from 7.3.4 times)
by Roger Snowdent "The Deadly Embrace (Oracle Locking Strategies)"
www.dbdomain.com/120197.htm
that indicates this deadlock error with no rows is an indication of an
"insidious table".

The article states that the the INITRANS and PCTFREE parameters
may be set too low for the table in use.

Has anyone encountered this deadlock with norows indicated error
before?  If yes, how did you resolve it?

In our current 8.0.4 datawarehouse database, this partitioned table
has PCTFREE of 10 and INI_TRANS of 1.   The block size is
8k, we are using Sun Solaris 2.6 and Veritas Volume Manager.
As I said, we are preparing to upgrade this to 8.1.7.

What would be an appropriate setting for PCTFREE and INI_TRANS
for this large warehouse partitioned table in these circumstances?

What are our options if we want to change the PCTFREE and INI_TRANS
for new data that gets loaded?   Can we change PCTFREE and INI_TRANS
and then just keep loading more data into an existing partition?   Can
we change these values in new partitions and leave them the same in
existing partitions?   What would be the drawbacks of having some
partitions
with one value for these storage parameters and other partitions with
different
values?

Also, the developers want to know if there is any utility that could be run
to
determine whether other tables might be susceptible to this deadlock
condition.
Something like dbverify or analyze with some validation option?

Thanks in advance for your feedback.

Cherie Machler
Oracle DBA
Gelco Information Network



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

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

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

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

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

Re: Oracle ODBC On Windows95 (Don't ask) :)

2002-04-25 Thread Suzy Vordos



If the 8.1.7 database is UTF8 character set, that version of ODBC won't
work.  Install the 8.1.7 client & odbc drivers.

Stefan Jakobsson wrote:
> 
> I need to setup a ODBC connection to an Oracle 8.1.7 database
> over TCP/IP where the Client PC's are running Windows 95 (Old
> clunkers)
> 
> Anyone know what I need to do for this? Can I use the 7.3 ODBC
> drivers written for Windows95 for connection to a 8.1.7?
> 
> I've never done this before and can't find any clear answers
> about it on Oracles website.
> 
> Would be immensly gratefull for an answer of any kind, even
> if it is a "no-can do", then I would know that I dont have
> to put any more effort into this :)
> 
> Thanks!
> 
> Stefan Jakobsson
> Arel-Data
> [EMAIL PROTECTED]
> Tele: 08 - 470 24 00
> Fax:  08 - 470 24 24
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stefan Jakobsson
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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

RE: DBMS_STATS.gather_database_stats

2002-04-25 Thread Walter K


I can't answer the question about the performance 
after deleting the statistics because we have a 
contract DBA here that insists it's okay to analyze 
the internal schemas even though he's the one that 
acknowledges the performance problem if the stats get 
a little stale! Unfortunately, he always gets his way, 
right or wrong..

--- Original Message ---
To: Multiple recipients of list ORACLE-L 

>Walter,
>this is actually a bug. It's supposedly fixed in 9i 
though I haven't tried
>it. Anybody?
>Do you still see a performance hit when you delete 
the statistics from the
>SYS objects?
>
>Regards,
>Mike Hately
>
>-Original Message-
>Sent: 25 April 2002 15:33
>To: Multiple recipients of list ORACLE-L
>
>
>If you're not supposed to analyze SYS and SYSTEM then 
>can anyone explain why the 
>DBMS_STATS.GATHER_DATABASE_STATS procedure does?
>
>We have run into scenarios where the data dictionary 
>becomes almost unusable until SYS gets analyzed again 
>via this procedure. I.e. can't describe v$ views, 
>selects against v$ views take forever to return 
>results, etc.
>
>The obvious solution is to not use this particular 
>procedure but it still begs the question WHY doesn't 
>it exclude SYS and SYSTEM? Are there any reasons why 
>you would want to analyze these schemas?
>
>Thanks.
>-w
>
>
>
> 
>__
__
> 
>
>This email and any attached to it are confidential 
and intended only for the
>individual or 
>entity to which it is addressed.  If you are not the 
intended recipient,
>please let us know 
>by telephoning or emailing the sender.  You should 
also delete the email and
>any attachment 
>from your systems and should not copy the email or 
any attachment or
>disclose their content 
>to any other person or entity.  The views expressed 
here are not necessarily
>those of 
>Churchill Insurance Group plc or its affiliates or 
subsidiaries. Thank you. 
>Churchill Insurance Group plc.  Company Registration 
Number - 2280426.
>England. 
>Registered Office: Churchill Court, Westmoreland 
Road, Bromley, Kent BR1
>1DP. 
>
>
>-- 
>Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
>-- 
>Author: Hately Mike
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: 
(858) 538-5051
>San Diego, California-- Public Internet 
access / Mailing Lists
>--
--
>To REMOVE yourself from this mailing list, send an E-
Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling 
of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB 
ORACLE-L
>(or the name of mailing list you want to be removed 
from).  You may
>also send the HELP command for other information 
(like subscribing).


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

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

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

RE: What block size are you using for your new 9i data warehouse?

2002-04-25 Thread Toepke, Kevin M


Cherie:

If you are using Oracle 9i, you can use mutliple block sizes! You still
create your database with a default block size, but each tablespace (except
system) can have a block size different from the default.

Valid blocksizes are limited by OS, but they range from 2K to 32k. 

Check out the 9i docs for CREATE TABLESPACE for more info.

Caver

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



We are building a new version 9.0.1 data warehouse on Sun Solaris 2.6
migrating to Solaris 2.8.  We will be using striped disk that is striped
using Veritas Volume Manager on EMC disk.

The datawarehouse will be about 200 Gig.   It will be written to throughout
the day.

To this point, almost all of our databases have been created with an 8k
block size.   i'm not sure if that blocksize is optimal anymore.   With 9i,
what block sizes are people using in the field nowadays for data
warehouses?

Also, if you use striped disk, what stripe size are you using and why?

Thanks for weighing in on this topic.

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

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

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

RE: Oracle ODBC On Windows95 (Don't ask) :)

2002-04-25 Thread Thomas Day



There are free drivers from Oracle and Microsoft.  They have different
behaviors.  One will fail, under certain conditions, where the other will
not.  Use the one that works for you.  There is a third party driver that
works under all conditions but you have to pay for it.  I don't remember
the name of the vendor but our client was unwilling to pay for it since
Oracle provided a free driver.



   

johanna.doran  

@sungard.com To: Multiple recipients of list ORACLE-L  

Sent by: root<[EMAIL PROTECTED]>

 cc:   

 Subject: RE: Oracle ODBC On Windows95 
(Don't  
04/25/2002   ask) :)   

12:18 PM   

Please 

respond to 

ORACLE-L   

   

   







Are you just trying to setup an ODBC conenction?

In Control Panel, you should see an icon for an ODBC manager where you can
add dns entries .  You STILL will need to install Oracle client.  Use the
db alias name for the Service name in the ODBC setup.

On 95, I believe that there are 2 sets of Oracle ODBC drivers,  one put out
by Oracle and the other by Microsoft. funny but I remember we had to
use the Microsoft drivers because we had problems with the Oracle ones.

That's all I really remember, but feel free to get me off list for more
specifics if you need them.

Hannah

 -Original Message-
<[EMAIL PROTECTED]>
Sent:   Thursday, April 25, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject:    Oracle ODBC On Windows95 (Don't ask) :)

I need to setup a ODBC connection to an Oracle 8.1.7 database
over TCP/IP where the Client PC's are running Windows 95 (Old
clunkers)

Anyone know what I need to do for this? Can I use the 7.3 ODBC
drivers written for Windows95 for connection to a 8.1.7?

I've never done this before and can't find any clear answers
about it on Oracles website.

Would be immensly gratefull for an answer of any kind, even
if it is a "no-can do", then I would know that I dont have
to put any more effort into this :)

Thanks!

Stefan Jakobsson
Arel-Data
[EMAIL PROTECTED]
Tele: 08 - 470 24 00
Fax:  08 - 470 24 24
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jakobsson
  INET: [EMAIL PROTECTED]

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

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




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

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

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

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2



Stephane,

No, this is not an IOT table.

This is a TX type of lock on insert.

Thanks for your reply.

Cherie


   
 
"Stephane  
 
Faroult"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Subject: RE: No Rows Deadlock and 
PCTFREE, INITRANS on 8.1.7.2
Sent by:   
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
04/25/02 11:28 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




You mention a partitioned table. Not an IOT I hope? Because SELECTs can
cause deadlocks on an IOT if you partition it in the process (deadlock on
DDL, as opposed to DML, locks). I used to have a trigger of death to check
it, but I wouldn't recommend it, since you have to delete SYS tables to get
rid of it :-). Bug encountered in 8.1.6 and 8.1.7, don't know about 9i, my
interest for bugs decreases strongly when I have switched to something
else, and my professional life is a succession of switches. BTW if the
deadlock occurs on DDL locks, INITRANS and PCTFREE are totally irrelevant.

>- Original Message -
>From: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Thu, 25 Apr 2002 07:18:30
>
>
>We are testing an upgrade of our warehouse from
>8.0.4 to 8.1.7.2.
>
>While testing our nightly load job that runs in two
>simultaneous
>streams (ascending and descending), we have been
>getting deadlock
>errors.   The trace file shows the the rows waited
>on are no rows.
>
>In response to a TAR I opened with Oracle, Oracle
>responded that
>the application needs to be rewritten so that there
>is only a single
>stream.   However our developers aren't inclined to
>do so because
>our nightly window isn't long enough for a single
>job and because
>this application worked fine as is on 8.0.4.
>
>Our developers have discovered an old article
>(perhaps from 7.3.4 times)
>by Roger Snowdent "The Deadly Embrace (Oracle
>Locking Strategies)"
>www.dbdomain.com/120197.htm
>that indicates this deadlock error with no rows is
>an indication of an
>"insidious table".
>
>The article states that the the INITRANS and
>PCTFREE parameters
>may be set too low for the table in use.
>
>Has anyone encountered this deadlock with norows
>indicated error
>before?  If yes, how did you resolve it?
>
>In our current 8.0.4 datawarehouse database, this
>partitioned table
>has PCTFREE of 10 and INI_TRANS of 1.  The block
>size is
>8k, we are using Sun Solaris 2.6 and Veritas Volume
>Manager.
>As I said, we are preparing to upgrade this to
>8.1.7.
>
>What would be an appropriate setting for PCTFREE
>and INI_TRANS
>for this large warehouse partitioned table in these
>circumstances?
>
>What are our options if we want to change the
>PCTFREE and INI_TRANS
>for new data that gets loaded?   Can we change
>PCTFREE and INI_TRANS
>and then just keep loading more data into an
>existing partition?   Can
>we change these values in new partitions and leave
>them the same in
>existing partitions?  What would be the drawbacks
>of having some
>partitions
>with one value for these storage parameters and
>other partitions with
>different
>values?
>
>Also, the developers want to know if there is any
>utility that could be run
>to
>determine whether other tables might be susceptible
>to this deadlock
>condition.
>Something like dbverify or analyze with some
>validation option?
>
>Thanks in advance for your feedback.
>
>Cherie Machler
>Oracle DBA
>Gelco Information Network
>
>
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.com
>--
>Author:
>  INET: [EMAIL P

Re: UNIX Courses

2002-04-25 Thread Alex

I suggest you download linux or bsd and play around. 

On Thu, 25 Apr 2002, Simon Waibale wrote:

> Hi all,
> What Unix courses/modules would you recommend for a budding Oracle DBA
> Thanx,
> ---
> CSW
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Simon Waibale
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

Re: Curious question about flushing the Pool

2002-04-25 Thread Jonathan Lewis



So have you tried dropping your SGA to 275MB
so that the stuff that is useful can be found quicker
and latches are held for a shorter time ?

Also consider looking at cursor_sharing - it's
a band-aid but it can work well in extremis.

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

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to 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: 25 April 2002 16:47



Wow, I think that's a brilliant idea.  It would be a huge benefit to
me, where all of our code is VB, and the developers refuse to use bind
variables.  My sql area is .5 GB and is 95% garbage.




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

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

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

RE: AUDIT_ACTIONS

2002-04-25 Thread Scott . Shafer


read ?/rdbms/admin/cataudit.sql 

insert into audit_actions values (102, 'LOGOFF BY CLEANUP');
insert into audit_actions values (103, 'SESSION REC');
insert into audit_actions values (104, 'SYSTEM AUDIT');

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Charlie Mengler [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 25, 2002 9:43 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  AUDIT_ACTIONS
> 
> 103 SESSION REC
> 
> I see entries in one of my AUD$ tables with a ACTION = 103
> I'd like to know exactly what this action references.
> I've searched my 8i online doc set but got no hits.
> 
> I'm willing to RTFM is somebody will point me at which FM
> I should use in this case.
> 
> TIA & HAND!
> 
> -- 
> Charlie Mengler   Maintenance Warehouse  
> [EMAIL PROTECTED]  10641 Scripps Summit Ct.
> 858-831-2229  San Diego, CA 92131
> Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Charlie Mengler
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n


that too I found that after I finished eating lunch, there was
almost as much in "garbage" (inedible food) left in the lunch box as
there was in "food" when I opened the box.

The potato chips were usually good though :)


--- Brian McGraw <[EMAIL PROTECTED]> wrote:
> >>1.  IOUG Live Sandwiches are made by Oracle  you can't break in!
> 
> UnBreakable, InEdible.
> 
> Brian
> 
> -Original Message-
> Stephen
> Sent: Thursday, April 25, 2002 9:03 AM
> To: Multiple recipients of list ORACLE-L
> n
> 
> Good morning everyone:
> 
>   Since everyone was wondering what the Top 10 things were from IOUG
> Live!,
> I went to the source:  Ian Abramson, Director of Educational
> Programming
> for
> the IOUG and the person that provided this jocularity.  Here they
> are:
> 
> Here is the top 10 list:
> Top 10 Lessons Learned at IOUG Live 2002
> From the home office in Chicago, IL
> 11. (added during speech) If you go to Tijuana don't drink the water
> 10.
> Scott Tiger is real!
> 9.  Finding ways to bring humor into your workday does not mean
> laughing
> after doing a shutdown abort on your production database  by
> mistake.
> 8.  Kellogg's may have a Mini-Wheat, but the IOUG has a Mini-Dean 7. 
> It
> is
> possible to print an onsite agenda on the head of a pin or grain of
> rice.
> 6.  SQL*Net = The dollar amount derived by subtracting the money
> generated
> by owning Oracle from the cost of the license.
> 5.  You will find your way around the Convention Center not later
> than
> Thursday afternoon
> 4.  San Diego is colder than Canada
> 3.  Hashing is not illegal
> 2.  In the brain of the DBA. "Session 504 has been moved to room 30A"
> means
> "alter session 504 move tablespace 30A"
> And the #1 thing I learned at IOUG Live
> 1.IOUG Live Sandwiches are made by Oracle  you can't break in!
> 
> Ian Abramson
> 
> 
> 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, April 24, 2002 7:08 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens,
> please n
> 
> no, the Tijuana trip we were very careful not to drink the water (hm,
> that left only alcohol!)
> 
> I just didn't write them down, was having too much fun just listening
> to them
> 
> 
> --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> > >> I don't remember the rest
> > 
> > Was that because of the water in Tijuana?? :-))
> > Sorry I missed out on that, but I got otherwise 
> > involved in something.
> > 
> > RF
> > 
> > -Original Message-
> > Sent: Wednesday, April 24, 2002 3:28 PM
> > To: Multiple recipients of list ORACLE-L
> > please
> > n
> > 
> > 
> > One I know was "bring a coat to San Diego"
> > 
> > for those of you not at IOUG, San Diego, a city that is supposedly
> > warm
> > was COLD and everyone was freezing there
> > 
> > they added a "zero" -- when you go to Tijuana, don't drink the
> water"
> > 
> > I don't remember the rest
> > 
> > 
> > --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> > > So, do you remember the other top 10 items??
> > > 
> > > Robert
> > > 
> > > -Original Message-
> > > Sent: Wednesday, April 24, 2002 11:39 AM
> > > To: Multiple recipients of list ORACLE-L
> > > please
> > > n
> > > 
> > > 
> > > it was also mentioned at the Oracle of Oracles closing session,
> in
> > > the
> > > "top 10 things I learned in San Diego" :)  
> > > 
> > > 
> > > --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > > > Might have been Dave too, but I mentioned it in my
> > > "Misunderstandings
> > > > About Oracle Internals" talk at IOUG on Tuesday...
> > > > 
> > > >  
> > > > Cary Millsap
> > > > Hotsos Enterprises, Ltd.
> > > > [EMAIL PROTECTED]
> > > > http://www.hotsos.com
> > > > 
> > > > 
> > > > -Original Message-
> > > > Sent: Monday, April 22, 2002 10:58 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > n
> > > > 
> > > > I think it was Dave Ensor...
> > > > 
> > > > - Original Message -
> > > > To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> > > > Sent: Monday, April 22, 2002 6:30 PM
> > > > 
> > > > 
> > > > > Hi Connor,
> > > > >
> > > > > Somebody (I think it was Cary) mentioned your little PL/SQL
> > > > procedure
> > > > that
> > > > > will provide any required CHR. So you are famous, even if you
> > > were
> > > > not
> > > > > present :)
> > > > >
> > > > > And yes, without seeming to migrate to the CHR camp, there is
> > > some
> > > > merit
> > > > in
> > > > > what you are saying. However, I would suggest that tracking
> > > > 'normal'
> > > > delta
> > > > > values of 'cache buffer chain' gets, misses, spins and sleeps
> > > from
> > > > > V$SYSTEM_EVENT/V$LATCH, as well as deltas of 'table scan rows
> > > > gotten'
> > > > vs
> > > > > 'table fetch by rowid' would be a bett

RE: {9i New Features: DataGuard}

2002-04-25 Thread Arun Chakrapani




It even adds the datafile on the standby 
database for u, only u have set it in the parameter file of the 
dataguard.
 

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 1:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: {9i 
  New Features: DataGuard}
  Next installment of 9i new features, like always send hate mail to 
  /dev/null.  Also if I've lied in something feel free to correct/flame me 
  for it.
   
  The Saga continues:
   
  Oracle 9i New Features:  9i Data Guard 
  So you have Oracle 8i standby database, what is new with 9i standby 
  also known as Data Guard.
   
  Well in theory it can be totally automated.  In 8i you had to put 
  the database in managed recovery mode(or you manually did recovery) on the 
  standby db.  I hope no one was doing manual recovery every time a archive 
  log was shipped across. :)
   
  Now with 9i dataguard, the standby database can be built either:
   
  1.  manually just like you did in 8i or2.  automagically 
  with OEM Dataguard Wizard(crazy wizards for everything anymore).
   
  I personally couldnt get the wizard to work with 9.0.1.0.  Does it 
  work now?, I'm not sure as I've not tested it as of recent.  The manual 
  method works just fine.
   
  Ok so you need to create a standby database, we're not going to cover 
  that here, why?, Mostly cause we're only going to cover the new aspects, you 
  all can read the docs as well as I can to build the db.
   
  On to the new stuff:
   
  Your standby database in 8i was only in what we call "delayed" protection 
  mode, which means there is a delay from the time the logs are completed on the 
  primary database before they are appliedto the standby database.  Now 
  with 9i, you have 3 other modes:
   
  Guaranteed protection: indicates that primary database modifications are 
  available to the standby database, up to the last committed transaction.  
  The standby database cannot diverge from the primary database at all, and no 
  data can be lost. If a standby database is unavailable, processing 
  automatically halts on the primary database as well.
   
  Instant Protection: With instant protection, the standby database may 
  temporarily diverge from the primary database, but upon failover to the 
  standby database, the databases can be synchronized, and no data will be 
  lost.
   
  Rapid Protection: With rapid protection, the log writer process transmits 
  redo logs to the standby sites. Use this mode when availability and 
  performance on the primary database are more important than the risk of losing 
  a small amount of data.
   
   
   
  An important note is that in Guaranteed and Instant protection mode that 
  the logs are written in SYNCHRONOUS mode to the standby site. Rapid and 
  Delayed mode are ASYNC writes.
   
  So this begs to ask what is the difference between Guaranteed and 
  Instant?  Well in Guaranteed mode the logs are applied and there is no 
  data divergence from the primary and standby db.  Whereas Instant mode 
  there can be data divergence but upon failover there will beNO data 
  loss.
   
  So since we wont have data loss, there is a new way to "failover" to a 
  standby database, called switchover.  
   
  You can literally be able to switch to a standby database and switchback 
  to the original primary WITHOUT having to reinstantiate(ie: rebuild) the 
  primary.  
   
  A very nice feature, this gives you the capability to do rolling upgrade 
  of OS <-NOTICE, NOT ORACLE BINARIES YET, ONLY THE OS.
   
  In 8i you could only do a failover(which required rebuilding the 
  primary), you can still do a failover in 9i if you've lost the primary db in 
  some disaster like the computer room caught on fire.
   
  Now for the automated part:
   
  There is the dataguard manager/broker, it can be run from command 
  line($ORACLE_HOME/bin/dgmgrl) as well as from OEM.  This gives you the 
  luxury of oracle doing all the work to maintain consistency between the 
  primary and standby database.  Way too much to cover here but it handles 
  automatically applying logs, notification of down standby, etc.
   
  Feel free to ask anything about Dataguard to me directly at [EMAIL PROTECTED]
   
  Joe

RE: Curious question about flushing the Pool


Some truisms I've found after losing the fight at several different
locations:

1) If the programming staff was there before you got there, you will
lose every fight

2) If the programming staff was hired after you got there, but has a
prior working history with management, you will lose every fight

3) If what you ask for means going back and recoding existing "working"
code, you will lose every fight

4) If you haven't convinced the development staff that it really is
essential that you are part of the design process, you will lose every
fight

5) if the code has been provided by a 3rd party vendor, you will lose
every fight

6) "No" is a complete sentence. But it should be backed up with the
reasons why doing whatever it is that they want you to will adversely
impact the application. They don't care what it does to the database,
but if it hurts the visible app, they will listen

7) DOCUMENT EVERYTHING. Every time you lose a fight, send a note to
your home email address and to your manager explaining why you feel
this is a bad idea. Do not send it to your office email address, it's
too easy for those files to get lost (anyone old enough to remember the
"missing 18 minutes of tape"?)

--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> > I lost the fight to have the code fixed, and so turned on
> > cursor_sharing. Worked like a charm
> 
> Been there, done that... but now I feel better knowing that a
> tenacious
> goddess of the DBA battlefields also lost this fight. :-)
> 
> It's a tough fight when embedded SQL is scattered all over the place
> and
> development is more concerned with coding the next feature set on
> "Internet
> time." Apart from the tons of embedded SQL, we have a "dynamic SQL
> generator" function in our code which creates SQL with literals based
> on
> states or values in webpage check boxes, radio buttons,
> dropdownlists, text
> boxes, etc. Since this is a central, oft-used part of the app I'm
> hoping to
> get duhvelopment to use bind variables in it but it's going to be an
> uphill
> battle. Just the normal frustration in the on-going DBA/Duhveloper
> battle.
> Sigh...
> 
> 
> Steve Orr
> Bozeman, MONTANA!
> 
> 
> -Original Message-
> Sent: Thursday, April 25, 2002 6:58 AM
> To: Multiple recipients of list ORACLE-L
> Importance: High
> 
> 
> Minor correction, cursor_sharing did work in versions under 8.1.7.3
> (I
> used it in 8.1.6) but there was a bug relating to very specific
> usage.
> I never encountered it, I know you can look up the details of the bug
> on Metalink.
> 
> Having said that, I used cursor_sharing=force instead of flushing the
> shared pool because it does almost entirely eliminate the "out of
> memory" error, while flushing, if you misset the timing, doesn't.
> 
> We had programmers who did not want to use bind variables (Java
> prepared statements) and so, for an OLTP system where they were
> looking
> up registration information, we ended up with each SQL statement,
> differing only by the constant value being looked up, in the shared
> pool.   
> 
> I lost the fight to have the code fixed, and so turned on
> cursor_sharing. Worked like a charm
> 
> Rachel
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Buffer in Import

2002-04-25 Thread Karniotis, Stephen

The buffer size refers to the number of bytes placed into Imports internal
buffer.  Generally, you should make this value large, like 5 or 10m to
accommodate large data imports.  Small values increase import time and
induce risk for large tables.

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:   Thursday, April 25, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Buffer in Import

I 2nd that, bytes.

>>> [EMAIL PROTECTED] 04/25/02 12:03PM >>>
I believe that it refers to bytes.

--- "Ramon E. Estevez" <[EMAIL PROTECTED]> wrote:
> Does the parameter buffer in the import refers to bytes or number of
> rows ? 
>  
> Kind of confuse. I think it refers to the number of rows.
>  
> buffer=5  ---> is that 5 bytes,  or 5 rows 
>  
> TIA
>  
> Ramon
>  
>  
>  
> 

=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED] 

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

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

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

Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

2002-04-25 Thread Anjo Kolk


Basically the concurrency level = initrans (so if 2 jobs run -> set it to 2),
however for indexes set it to conccurency + 1.

Anjo.


[EMAIL PROTECTED] wrote:

> We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2.
>
> While testing our nightly load job that runs in two simultaneous
> streams (ascending and descending), we have been getting deadlock
> errors.   The trace file shows the the rows waited on are no rows.
>
> In response to a TAR I opened with Oracle, Oracle responded that
> the application needs to be rewritten so that there is only a single
> stream.   However our developers aren't inclined to do so because
> our nightly window isn't long enough for a single job and because
> this application worked fine as is on 8.0.4.
>
> Our developers have discovered an old article (perhaps from 7.3.4 times)
> by Roger Snowdent "The Deadly Embrace (Oracle Locking Strategies)"
> www.dbdomain.com/120197.htm
> that indicates this deadlock error with no rows is an indication of an
> "insidious table".
>
> The article states that the the INITRANS and PCTFREE parameters
> may be set too low for the table in use.
>
> Has anyone encountered this deadlock with norows indicated error
> before?  If yes, how did you resolve it?
>
> In our current 8.0.4 datawarehouse database, this partitioned table
> has PCTFREE of 10 and INI_TRANS of 1.   The block size is
> 8k, we are using Sun Solaris 2.6 and Veritas Volume Manager.
> As I said, we are preparing to upgrade this to 8.1.7.
>
> What would be an appropriate setting for PCTFREE and INI_TRANS
> for this large warehouse partitioned table in these circumstances?
>
> What are our options if we want to change the PCTFREE and INI_TRANS
> for new data that gets loaded?   Can we change PCTFREE and INI_TRANS
> and then just keep loading more data into an existing partition?   Can
> we change these values in new partitions and leave them the same in
> existing partitions?   What would be the drawbacks of having some
> partitions
> with one value for these storage parameters and other partitions with
> different
> values?
>
> Also, the developers want to know if there is any utility that could be run
> to
> determine whether other tables might be susceptible to this deadlock
> condition.
> Something like dbverify or analyze with some validation option?
>
> Thanks in advance for your feedback.
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


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

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

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

RE: Buffer in Import

2002-04-25 Thread Whittle Jerome Contr NCI

Title: RE: Buffer in Import






Ramon,


Bytes.  IMHO, 5 is way to low if you have a lot of data to import. Try doubling it at least.


Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   Ramon E. Estevez [SMTP:[EMAIL PROTECTED]]


Does the parameter buffer in the import refers to bytes or number of rows ? 

 

Kind of confuse. I think it refers to the number of rows.

 

buffer=5  ---> is that 5 bytes,  or 5 rows 

 

TIA

 

Ramon

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

2002-04-25 Thread Khedr, Waleed


My guess there is no triggers or referential constraints since it's a Data
Warehouse.

More details will help,

Regards

Waleed

-Original Message-
Sent: Thursday, April 25, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L



Is it a TX mode 4 (Share) deadlock ?

Can you post a section of the deadlock graph
from the trace file.

If you really have only two streams running,
then you need only set initrans to 2 at a cost
of (typically) 24 bytes per block to guarantee
that the problem goes away.

There are several other reasons for deadlocks -
in particular issues relating to parent/child
conflicts.  e.g.
session 1 deletes child for parent A
session 2 inserts child for parent A
session 1 tries to delete parent A

At this point session 1 waits for session 2
to commit - showing TX/4 and no rows

If your batches are sufficiently tangled that
the same sequence could have happened
in the opposite order (possibly through triggers)
on other parent/child rows, then you'll get
a TX/4 deadlock showing no rows.


An alternative thought - did you upgrade by
doing an export/import ? Going from 8.0 to 8.1
you may find that some of the 8.0 indexes
were deemed redundant by the 8.1 import,
so you may have invisibly dropped an index
supporting a foreign key.



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

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to 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: 25 April 2002 16:11


|
|We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2.
|
|While testing our nightly load job that runs in two simultaneous
|streams (ascending and descending), we have been getting deadlock
|errors.   The trace file shows the the rows waited on are no rows.
|
|In response to a TAR I opened with Oracle, Oracle responded that
|the application needs to be rewritten so that there is only a single

|stream.   However our developers aren't inclined to do so because
|our nightly window isn't long enough for a single job and because
|this application worked fine as is on 8.0.4.
|
|Our developers have discovered an old article (perhaps from 7.3.4
times)
|by Roger Snowdent "The Deadly Embrace (Oracle Locking Strategies)"
|www.dbdomain.com/120197.htm
|that indicates this deadlock error with no rows is an indication of
an
|"insidious table".
|
|The article states that the the INITRANS and PCTFREE parameters
|may be set too low for the table in use.
|
|Has anyone encountered this deadlock with norows indicated error
|before?  If yes, how did you resolve it?
|
|In our current 8.0.4 datawarehouse database, this partitioned table
|has PCTFREE of 10 and INI_TRANS of 1.   The block size is
|8k, we are using Sun Solaris 2.6 and Veritas Volume Manager.
|As I said, we are preparing to upgrade this to 8.1.7.
|
|What would be an appropriate setting for PCTFREE and INI_TRANS
|for this large warehouse partitioned table in these circumstances?
|
|What are our options if we want to change the PCTFREE and INI_TRANS
|for new data that gets loaded?   Can we change PCTFREE and INI_TRANS
|and then just keep loading more data into an existing partition?
Can
|we change these values in new partitions and leave them the same in
|existing partitions?   What would be the drawbacks of having some
|partitions
|with one value for these storage parameters and other partitions with
|different
|values?
|
|Also, the developers want to know if there is any utility that could
be run
|to
|determine whether other tables might be susceptible to this deadlock
|condition.
|Something like dbverify or analyze with some validation option?
|
|Thanks in advance for your feedback.
|
|Cherie Machler
|Oracle DBA
|Gelco Information Network


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXA

Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

2002-04-25 Thread Jonathan Lewis



Is it a TX mode 4 (Share) deadlock ?

Can you post a section of the deadlock graph
from the trace file.

If you really have only two streams running,
then you need only set initrans to 2 at a cost
of (typically) 24 bytes per block to guarantee
that the problem goes away.

There are several other reasons for deadlocks -
in particular issues relating to parent/child
conflicts.  e.g.
session 1 deletes child for parent A
session 2 inserts child for parent A
session 1 tries to delete parent A

At this point session 1 waits for session 2
to commit - showing TX/4 and no rows

If your batches are sufficiently tangled that
the same sequence could have happened
in the opposite order (possibly through triggers)
on other parent/child rows, then you'll get
a TX/4 deadlock showing no rows.


An alternative thought - did you upgrade by
doing an export/import ? Going from 8.0 to 8.1
you may find that some of the 8.0 indexes
were deemed redundant by the 8.1 import,
so you may have invisibly dropped an index
supporting a foreign key.



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

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to 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: 25 April 2002 16:11


|
|We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2.
|
|While testing our nightly load job that runs in two simultaneous
|streams (ascending and descending), we have been getting deadlock
|errors.   The trace file shows the the rows waited on are no rows.
|
|In response to a TAR I opened with Oracle, Oracle responded that
|the application needs to be rewritten so that there is only a single

|stream.   However our developers aren't inclined to do so because
|our nightly window isn't long enough for a single job and because
|this application worked fine as is on 8.0.4.
|
|Our developers have discovered an old article (perhaps from 7.3.4
times)
|by Roger Snowdent "The Deadly Embrace (Oracle Locking Strategies)"
|www.dbdomain.com/120197.htm
|that indicates this deadlock error with no rows is an indication of
an
|"insidious table".
|
|The article states that the the INITRANS and PCTFREE parameters
|may be set too low for the table in use.
|
|Has anyone encountered this deadlock with norows indicated error
|before?  If yes, how did you resolve it?
|
|In our current 8.0.4 datawarehouse database, this partitioned table
|has PCTFREE of 10 and INI_TRANS of 1.   The block size is
|8k, we are using Sun Solaris 2.6 and Veritas Volume Manager.
|As I said, we are preparing to upgrade this to 8.1.7.
|
|What would be an appropriate setting for PCTFREE and INI_TRANS
|for this large warehouse partitioned table in these circumstances?
|
|What are our options if we want to change the PCTFREE and INI_TRANS
|for new data that gets loaded?   Can we change PCTFREE and INI_TRANS
|and then just keep loading more data into an existing partition?
Can
|we change these values in new partitions and leave them the same in
|existing partitions?   What would be the drawbacks of having some
|partitions
|with one value for these storage parameters and other partitions with
|different
|values?
|
|Also, the developers want to know if there is any utility that could
be run
|to
|determine whether other tables might be susceptible to this deadlock
|condition.
|Something like dbverify or analyze with some validation option?
|
|Thanks in advance for your feedback.
|
|Cherie Machler
|Oracle DBA
|Gelco Information Network


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

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

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

RE: Cronjob

2002-04-25 Thread Mercadante, Thomas F


Ahmadsyah,

If I remember correctly (my Vax is a couple of years old), we set up two
jobs to accomplish this.  One job ran every day.  All this job did was to
start the real job schedule job.  the job schedule job interrogated what day
of the week it was and ran other jobs.  For example, if today is Thursday,
it would start all jobs that were supposed to run on a thursday.

the final thing that this job did was to re-schedule the first job for
tommorrow at the same time.  Kind of a circular job scheduling process.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, April 25, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L


I have the same problem but with our vax/vms machine..
could I submit a job queue on every week or maybe every month...

$Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log -
_$/After = "tomorrow+06:00" -
_$sys$geology:[diga.digu]dige.com

I usually submit que every day.. but I want to submit every week and month
or every saturday.
Could I do it on our vax machine?

regards,

Ahmadsyah Alghozi Nugroho
Certified Oracle DBA

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 7:38 PM


> 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log 2>&1
>
> Samir
>
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
>
>
> -Original Message-
> Sent: 25 April 2002 12:43
> To: Multiple recipients of list ORACLE-L
>
>
> Hallo,
>
> I would like to have this cronjob run only in saturday mornings at 6 am.
How
> could I easy change this script?
>
> 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
> >/d31/appl/konto/log/laddabilbo.log
>  2>&1
>
> Thanks in advance
>
> Roland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
___
> This email is confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions presented are
> solely those of the author and do not necessarily represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised that you have received
this
> email in error and that any use, dissemination, forwarding, printing, or
> copying of this email is strictly prohibited.
>
> If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

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

To REMOVE yo

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2



Waleed,

There used to be a single process that loaded the data.   It ran too long
and the application owners split the job out into two process.   One
started at one end and loaded data in ascending order and the other started
at the other end and loaded in descending order.

Both jobs run at the same time in the same database.  They've run like this
for a couple of years in the current 8.0.4 database without any obvious
locking errors.

Cherie Machler


   

"Khedr,

Waleed"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: RE: No Rows Deadlock and 
PCTFREE, INITRANS on 8.1.7.2
Sent by:   

[EMAIL PROTECTED] 

om 

   

   

04/25/02 01:33 

PM 

Please respond 

to ORACLE-L

   

   





Can you please give more details on: While testing our nightly load job
that
runs in two simultaneous
streams (ascending and descending).

What do you mean by descending and ascending (simultaneous)?

Thanks

Waleed

-Original Message-
Sent: Thursday, April 25, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L



We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2.

While testing our nightly load job that runs in two simultaneous
streams (ascending and descending), we have been getting deadlock
errors.   The trace file shows the the rows waited on are no rows.

In response to a TAR I opened with Oracle, Oracle responded that
the application needs to be rewritten so that there is only a single
stream.   However our developers aren't inclined to do so because
our nightly window isn't long enough for a single job and because
this application worked fine as is on 8.0.4.

Our developers have discovered an old article (perhaps from 7.3.4 times)
by Roger Snowdent "The Deadly Embrace (Oracle Locking Strategies)"
www.dbdomain.com/120197.htm
that indicates this deadlock error with no rows is an indication of an
"insidious table".

The article states that the the INITRANS and PCTFREE parameters
may be set too low for the table in use.

Has anyone encountered this deadlock with norows indicated error
before?  If yes, how did you resolve it?

In our current 8.0.4 datawarehouse database, this partitioned table
has PCTFREE of 10 and INI_TRANS of 1.   The block size is
8k, we are using Sun Solaris 2.6 and Veritas Volume Manager.
As I said, we are preparing to upgrade this to 8.1.7.

What would be an appropriate setting for PCTFREE and INI_TRANS
for this large warehouse partitioned table in these circumstances?

What are our options if we want to change the PCTFREE and INI_TRANS
for new data that gets loaded?   Can we change PCTFREE and INI_TRANS
and then just keep loading more data into an existing partition?   Can
we change these values in new partitions and leave them the same in
existing partitions?   What would be the drawbacks of having some
partitions
with one value for these storage parameters and other partitions with
different
values?

Also, the developers want to know if there is any utility that could be run
to
determine whether other tables might be susceptible to this deadlock
condition.
Something like dbverify or analyze with some validation option?

Thanks in advance for your feedback.

Cherie Machler
Oracle DBA
Gelco Information Network



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

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

Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2