Re: Curious question about flushing the Pool
I'll second that suggestion! To extend the analogy, how about a "recycle pool" for them? (So they don't fragment or otherwise clutter up the "keep pool".) How about adaptive "auto-pin" in the "keep pool" based on execution frequency? (Never mind... Probably not really necessary. I'd settle for the LRU bias.) Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 11:03 PM 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: Don Granaman 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: LOG_BUFFER Parameter Question
Thanks to all of you on this issue... -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 24, 2002 8:12 PMTo: Multiple recipients of list ORACLE-LSubject: RE: LOG_BUFFER Parameter Question Alternatively, you size it until redo_log_space_wait goes away from v$system_events. -Original Message-From: Anjo Kolk [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 24, 2002 4:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: LOG_BUFFER Parameter QuestionYep, wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 * Anjo. Denham Eva wrote: Hello, I have been wondering about how to work out what the optimal LOG_BUFFER parameter, compared to the physical size of the REDOLOG file, for the best optimization and writes from buffer to log. Or am I barking up the wrong tree? Is there some other way of doing this. i.e. redolog file size is 10M and LOG_BUFFER is 512000. Can this be optimized better? Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Re: Curious question about flushing the Pool
> Comments? Corrections? Rants? I'll go for rant... I've had long and painful experience with a few pathological applications. One in particular contained hundreds of sets of common SQL statements - varying only in the literal values. Many were executed hundreds of thousands or even millions of times every day. (e.g. What could have been a few hundred distinct statements with bind variables was instead tens or hundreds of millions of distinct statements in the course of a day.) None of these applications ran on anything later than Oracle 8.1.7.1 - some on 7.3.x. On the vast majority of the 8i systems, there was some bug/quirk that prevented CURSOR_SHARING=FORCE. (For example, one such bug/quirk was that if the value for the first variable in a bind list was a null, the application process puked and either hung or died. I don't now remember the specific color, chunksize, ORA-x, or bug number though.) The typical symptom was a gradual degradation of overall performance as the shared pool filled up. When it slowed to a crawl, the only remedy was to flush the shared pool - which resulted temporarily in a much more dramatic performance hit. ("Would you like that adhesive tape pulled off your hairy chest a little at a time or in one quick heart-rending yank?") Then everything ran fine until we came full-circle again on the roller-coaster ride. We created a scheduled job to flush the shared pool and "tuned" the frequency with which it ran! This continued for at least 2 1/2 years (until I left). I hear that it is still the main performance issue with this particular ultra-critical multi-million dollar system (loaded E10K, large EMC Sym, ...). I showed the outsourcing "consultants" that designed and wrote this atrocity the wait analysis - which they adamantly insisted was NOT caused by their code. ("Tuning is the DBA's responsibility" - and our management bought it). My most convincing argument was routinely dumping a join of v$SQLAREA and v$SQLTEXT sorted by SQL_TEXT into a file. Actually seeing 60,000+ copies of the same statement differing only in literal values, followed by 23,000 of another, etc. eventually convinced management that it might actually be a problem. (This isn't an argument against using the wait interface, but in this case it was unnecessary - the problem was quite obvious). Just as I fled the company, one of the people who took over this system came up with a simple "solution" (encouraged by Oracle support and several very popular tuning books) - he raised the shared pool size to almost a gigabyte - in spite of my admonitions. Oddly enough, that made it MUCH worse! ;-) In this case, the flushing "solution" was just barely survival. And, obviously, it did nothing to avoid the wildly excessive parsing. In other words, "I agree" - flushing the shared pool is curing symptoms, not the disease. Don Granaman [cranky old OraSaurus with enough war stories to publish a multi-volume set] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 8:58 PM [... snipped for brevity ...] > 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
Anyone using Enterprise Manager?
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).
Re: good pl/sql coding/debugging tool?
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).
RE: monitoring multiple databases using PL/SQL -- follow-up question
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
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?
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
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?
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.
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
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
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
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
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
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
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
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?
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
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?
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
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
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.
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?
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
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
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?
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?
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.
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?
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) :)
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?
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?
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
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?
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
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
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
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) :)
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
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
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
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) :)
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
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
>>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) :)
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?
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
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
> 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?
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?
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?
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
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
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
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
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?
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?
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
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}
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
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
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
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?
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}
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
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
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
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
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
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) :)
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
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?
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) :)
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
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
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
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}
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
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
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
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
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
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
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
Jonathan, Following is section of the trace file generated. It is a TX lock. I'm not sure whether it is mode 4. How can I tell? We upgraded using the migration script, not export/import. During the nightly loads we have always dropped the indexes on the foreign keys on this large fact table and never had any problems at 8.0.4. Those foreign key indexes were dropped before this load. I got another recommendation from Anjo Kolk to increase INITRANS to 2. The problem is that this very large partitioned table cannot be exported/imported in it's entirety during our regular maintenance window. Is that a requirement for changing INITRANS? Could we just do this on new partitions? It is not a problem with existing rows but rather with new rows being inserted (according to our developers). Thanks for your helpful reply. Cherie Machler *** SESSION ID:(9.24642) 2002-01-07 09:49:54.992 DEADLOCK DETECTED Current SQL statement for this session: INSERT INTO EXP_LINE_ITEM_FACT ( CONFIRMATION_NUMBER,EXPENSE_REPORT_LINE_NUMBER, STATUS_KEY,BATCH_WINDOW_DATE_KEY,ACCOUNT_KEY,EXPENSE_DATE_KEY,REP_KEY,EXPENSE_CO ST_CENTER_KEY,SUBMIT_DATE_KEY,ARRIVAL_DATE_KEY,PAYMENT_INITIATED_DATE_KEY,TRANSA CTION_INITIATED_DATE_KEY,EXPENSE_CATEGORY_KEY,PROJECT_KEY,PRODUCT_KEY,PAYMENT_ME THOD_KEY,EXPENSE_VENDOR_KEY,EXPENSE_LOCATION_KEY,EXPENSE_REPORT_NUMBER,PERIOD_EN D_DATE,EXPENSED_AMOUNT,PAID_AMOUNT,OVERRIDE_IND,RECEIPT_IND,OUT_OF_POLICY_IND,LI NE_ITEM_REMARKS_IND,DATA_SOURCE_MOD_DATETIME,DATA_WAREHOUSE_MOD_DATETIME,DATA_MA RT_MOD_DATETIME,LOAD_DATE_KEY ) VALUES ( :b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b 10,:b11,:b12,:b13,:b14,:b15,:b16,:b17,:b18,:b19,:b20,:b21,:b22,:b23,:b24,:b25,:b 26,:b27,:b28,:b29,:b30 ) - PL/SQL Call Stack - object line object handlenumber name a2ddf49c 258 package body EDM_DBO.EXP_LINE_ITEM_FACT_COMMON_PKG a2ddf49c 1173 package body EDM_DBO.EXP_LINE_ITEM_FACT_COMMON_PKG a2cffa58 1107 package body EDM_DBO.ELIF_EXP_RPT_AMT_TYPE_PKG_ASC a2cffa58 677 package body EDM_DBO.ELIF_EXP_RPT_AMT_TYPE_PKG_ASC a2cffa58 393 package body EDM_DBO.ELIF_EXP_RPT_AMT_TYPE_PKG_ASC a2125ddc 4 anonymous block The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock: Deadlock graph: -Blocker(s) -Waiter(s) - Resource Name process session holds waits process session holds waits TX-0007004b-d4e915 9 X 12 37 S TX-0006001f-d1ac12 37 X 15 9 S session 9: DID 0001-000F-0002 session 37: DID 0001-000C-0002 session 37: DID 0001-000C-0002 session 9: DID 0001-000F-0002 Rows waited on: Session 37: no row Session 9: no row === PROCESS STATE - "Jonathan Lewis" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> mon.co.uk>cc: Sent by: Subject: Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2 [EMAIL PROTECTED] 04/25/02 11:53 AM Please respond to 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 del