RE: Should we stop analyzing?
exactly the same with steve trying to log a bug about x$ksmlru frits -Original Message- Sent: donderdag 8 januari 2004 20:59 To: Multiple recipients of list ORACLE-L Comment in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - Roughly, a bug would seem to be code that falls into one of two categories: * code that doesn't do what the developer intended * code that generates errors Several years ago I raised an issue with Oracle support where something was clearly going wrong - can't remember what, too long ago - and got told that I couldn't get the issue logged as a bug because the code was performing to specification. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Frits Hoogland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oaktable people
Onkel Mogens wrote: All to stay in my house (except Gaja - don't know what he's up to). Rock'n'roll. And none of them know what I meant when I asked them to bring some old clothes for some unusual teambuilding... You're not having them do construction work on your house again, are you? Gaja is probably the smart one, he knows what you're up to! My guess is that 'teambuilding' is Danish for 'dig me a 12 x 25 m swimming pool in my back yard and paint my house while you're at it.' Gummi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Book (was) oaktable people
Onkel Mogens wrote: there just MIGHT be a need for me to use a few, chosen, Danish bad words. I shall try, of course, to keep it in Danish. Shouldn't offend too many. Maybe not offend but it could bring back bad memories for some about blisters and aching backs, especially if one of the words is 'teambuilding'. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Index usage
sorry, the second query uses equality operator.. WHERE UPPER(col1) = 'xyz'; index hint is not helping. regards, B S Pradhan -- On Thu, 08 Jan 2004 zions swordfish wrote : hi, pradhan, I don't see any kind of differences with your two queries, but I suggest you to use hint in your query to activate index. Regards, Sony - Original Message - DATE: Thu, 08 Jan 2004 07:09:26 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Cc: Hi All, I have the query like: SELECT * FROM tab1 WHERE UPPER(col1) 'abc'; Obviously, the function based index i have is not hetting used because of the ineqality. When using SELECT * FROM tab1 WHERE UPPER(col1) 'abc'; index is getting used. How can I possibly use index in the 1st case. Thanks and Regards, B S Pradhan Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005
RE: seperate external procedure listeners for different SIDs
Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the ORA-28576 lost RPC connection to external procedure agent. However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -Original Message- Sent: 08 January 2004 15:59 To: Multiple recipients of list ORACLE-L John, I agree if you have multiple databases under the same home all is well, one extproc sid will do. But if you have several different Oracle homes, with different versions of Oracle then each needs it's own extproc sid. Tried using the latest listener and/or extproc combinations, didn't work. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 08, 2004 10:44 AM To: Multiple recipients of list ORACLE-L Thanks - I wasn't sure if each session got its own instance of extproc. The SID associated with an EXTPROC is not the same as a SID associated with a database. I have several databases running under the same Oracle Home, and they are sharing the same external procedure listener - which references that Oracle Home. If you are running databases under several versions of Oracle, you may be able to use the listener for the latest version of Oracle you have to listen for all of them, and use its extproc. But it is probably a better idea to run separate listeners for databases and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own Oracle Home. Just be careful about how the TNS administration directory is set. -Original Message- Sent: Thursday, January 08, 2004 9:54 AM To: Multiple recipients of list ORACLE-L John, On the contrary. You do need to associate an EXTPROC with a particular SID otherwise running different versions of Oracle on the same box blows the EXTPROC to hell. You'll notice that in listener.ora there needs to be a line SID_NAME= and in TNSNAMES.ora there is a Connect_data = (sid = as well. Now a particular database instance/version can only have one extproc_connect_data entry, but with multiple versions each has it's own, and sure enough each has to have a particular sid otherwise they mess each other up. BTW: Your description of the process is dead on, with one exception. An instance of extproc is connected to one and only one session in the calling database. If two sessions each need to call an external procedure then each gets it's own instance of extproc. Also if you need to update the dll or so file you have to get everyone to let go of extproc, namely by disconnecting from the database. Although it's like a database link, closing the links does not release extproc. Also using TCP to connect to extproc is not an Oracle recommended method, opens a door to hackers. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat
Re: ORACLE-L Digest -- Volume 2004, Number 009 (Out of Office
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Miller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: table reorganizations
Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: table reorganizations
Chris, I would argue that in your two examples, nothing needs to be done if you are using Locally Managed Tablespaces. All of the free space that your deletes generated would be reused by new inserts. When you say not good for FTS, I think you are wrong. Have you tried testing this statement? How much slower is it? Of course, I am talking about using Oracle 9i. Prior versions behaved much differently. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 09, 2004 6:09 AM To: Multiple recipients of list ORACLE-L Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: table reorganizations
Chris, Have you considered using dbms_redefinition for your second case? That would allow you to reorg and swap the tables without locking for any length of time. Rachel --- [EMAIL PROTECTED] wrote: Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Should we stop analyzing?
- Original Message - Wouldn't it be nice if dbms_stats could do an incremental refresh, tracking ONLY stats changes that might make a difference to execution plan: I'd settle for a flag I could turn on and off, saying: do/do not change stats for this object. I know which of them need to be analyzed and which don't. Better than Oracle will ever, deltas or no deltas, workload managers or not. a) Allow for dbms_stats to collect, store and compare changes to historical execution plans, using historical SQL from STATSPACK (or new 10g workload views) Sadly, this workload feature of 10g if I know anything about how Oracle works, will evolve into another monster elephant gun. Completely forgetting the problem out there is in most cases mosquito-size and can be addressed with a simple fly-swat. Yes, there is such a thing as over-engineering a solution. This will be one of them. And like anything that is over-engineered, it will be buggy - sorry Pete, feature-reluctant. Or perheaps document-challenged? And it will create a bad name for itself while the developers evolve it until Oracle 12r2... b) Allow the DBA control about whether to implement the new statistics That, sadly, is totally outside of Oracle's plans for the traditional production DBA role in future. It would cost these clients many thousands of dollars to have adjusted these plans, and management says If it ain't broke, why fix it. My problem too. Try and convince a damager that something that is working fine should have thousands of buckeroos spent on it to become compatible with new CBO! Like Heck it's gonna happen... Cripes, I know quite a few sites here that are STILL running Prime computers with Prime Information (for those who don't know, look-up Pick in google), 13 years after the company vanished! And no plans whatsoever to update. Why? Heck, it WORKS! Talk about TCO, eh? Oracle made a big-deal about going to the CBO in 11i, yet when we look at the SQL, a significant number of statement employ the rule hint! Connect-the-dots and you can guess why the RBO IS NOT being removed from Oracle10g. . . . Bingo!... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Should we stop analyzing?
Yahwoll, mein herr! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 6:09 AM Waddya mean, propaganda sheets? We never release propaganda - everything always works the way we say it does! :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: another OCP question -- help me guys
Pete Sharman scribbled on the wall in glitter crayon: Well, so here's the challenge for RMOUG training days - loosening Rachel's lips. Who's gonna join me in this endeavour? :) oh i have several methods i'd like to try.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] God is subtle but he is not malicious. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please
Hi all, I'd like to ask you about any steps that I should do additionally on installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os of windows 2000. I need to get this working by 2 days. So I really need help on this, thanks. Regards Wendry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please
Hi all, I'd like to ask you about any steps that I should do additionally on installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os of windows 2000. I need to get this working by 2 days. So I really need help on this, thanks. Regards Wendry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please
For one thing, please don't install 8.1.6. Install at least 8.1.7 and upgrade it to 8.1.7.4. You will be much better off. Actually, providing your system meets or exceeds the minimum requirements stated in the installation manual, this install goes fairly easily. DO read the installation manual and read me docs. Ask if you have more specific questions. -Original Message- Sent: Friday, January 09, 2004 8:29 AM To: Multiple recipients of list ORACLE-L 9i, urgent.. please Hi all, I'd like to ask you about any steps that I should do additionally on installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os of windows 2000. I need to get this working by 2 days. So I really need help on this, thanks. Regards Wendry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: table reorganizations
I thought that finish_redef_table does lock table for a few seconds? On 01/09/2004 07:54:26 AM, Rachel Carmichael wrote: Chris, Have you considered using dbms_redefinition for your second case? That would allow you to reorg and swap the tables without locking for any length of time. Rachel --- [EMAIL PROTECTED] wrote: Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala
Export bigger then 2G with Oracle7.3.4
Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Should we stop analyzing?
Note in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February 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] Sent: Friday, January 09, 2004 1:19 PM - Original Message - Wouldn't it be nice if dbms_stats could do an incremental refresh, tracking ONLY stats changes that might make a difference to execution plan: I'd settle for a flag I could turn on and off, saying: do/do not change stats for this object. I know which of them need to be analyzed and which don't. Better than Oracle will ever, deltas or no deltas, workload managers or not. Available in Oracle 10g - lock stats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Export / Import Question
I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Export bigger then 2G with Oracle7.3.4
Is any single table more than 2G ? If not, just break up the export into individual schemas and/or tables. For those tables that are more than 2G, you could compress via a pipe - for NT might mean running export over sqlnet from a unix box. hth connor --- [EMAIL PROTECTED] wrote: Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: table reorganizations
yes a few seconds. that's why I said without locking for any length of time and not doesn't lock at all :) The point being that you can do the redef and still allow access to the main table. Do a sync every once in a while while there is high volume traffic, then do the finish when there is low volume if you manually lock the table, then do the copy, it can take significantly more time --- Mladen Gogala [EMAIL PROTECTED] wrote: I thought that finish_redef_table does lock table for a few seconds? On 01/09/2004 07:54:26 AM, Rachel Carmichael wrote: Chris, Have you considered using dbms_redefinition for your second case? That would allow you to reorg and swap the tables without locking for any length of time. Rachel --- [EMAIL PROTECTED] wrote: Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel
RE: Export bigger then 2G with Oracle7.3.4
You could migrate the database to 8i, or you could use sql to split the table into 2GB and do the export in pieces, or you could just shut the database down and do a cold backup of the database, retaining any media you need to reinstall Oracle 7. Make sure if you are in archivelog mode that you backup all logfiles. Allan -Original Message- [EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:59 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Standby.
Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Should we stop analyzing?
Thanks. Sounds SUPER! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I'd settle for a flag I could turn on and off, saying: do/do not change stats for this object. snip Available in Oracle 10g - lock stats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman restore question
Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export bigger then 2G with Oracle7.3.4
I've uses the UNIX split command successfully with Oracle 7.3.4: # set maximum file size for each chunk of the export file # MAXFILESIZE=1500m export MAXFILESIZE # # create filenames for the parts of the backup # FILENAME1=$BACKUP_DIR/exporthrprd1.dmp FILENAME2=$BACKUP_DIR/exporthrprd2.dmp FILENAME3=$BACKUP_DIR/exporthrprd3.dmp LOGFILE=${BACKUP_DIR}/ora_export.log # # create the pipes # mkfifo exportpipeaa mkfifo exportpipeab mkfifo exportpipeac mkfifo wrkpipe umask 000 # # start the readers from the pipes to create the export files # dd if=exportpipeaa of=$FILENAME1 dd if=exportpipeab of=$FILENAME2 dd if=exportpipeac of=$FILENAME3 # # start the reader from the wrkpipe to compress and split the export # dd if=wrkpipe|split -b $MAXFILESIZE - exportpipe # # run the dd without the compress # #dd if=wrkpipe|split -b $MAXFILESIZE - exportpipe # # start the export for real # $ORACLE_HOME/bin/exp / FILE=wrkpipe OWNER=SYSADM DIRECT=Y BUFFER=512 LOG=$LOGFILE # # check return code from export # RetCode=$? if [ ${RetCode} -ne 0 ] then echo $(date +%Y%m%d-%H%M%S) ${script} --WARNING-- export for ${ORACLE_SID} failed ${BACKUP_DIR}/expsplit.log #echo $(date +%Y%m%d-%H%M%S) ${script} --ERROR-- export for ${ORACLE_SID} failed #exit 1 fi # # clean up after ourselves # rm exportpipeaa exportpipeab exportpipeac wrkpipe # # if you haven't used all the pipes, the dd may still linger on # make sure to REALLY clean up # ps -ef|grep exportpipe|grep -vi grep|awk '{printf (kill -9 %d; \n,$2)}'kill.lst chmod u+x kill.lst sh kill.lst rm kill.lst -Original Message- Sent: Friday, January 09, 2004 8:14 AM To: Multiple recipients of list ORACLE-L You could migrate the database to 8i, or you could use sql to split the table into 2GB and do the export in pieces, or you could just shut the database down and do a cold backup of the database, retaining any media you need to reinstall Oracle 7. Make sure if you are in archivelog mode that you backup all logfiles. Allan -Original Message- [EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:59 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Oracle Standby.
There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use blat to send an email of the last log applied so that I can be sure everything is OK. I don't run in managed mode, the servers come down occasionally and that messes up the standby if you're not careful. Jolene -Original Message- Sent: Friday, January 09, 2004 8:20 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export bigger then 2G with Oracle7.3.4
You don't mention OS, but if it's a flavor of unix, you could probably do: mknod my_pipe p exp file=my_pipe all other export options split -b 2047m my_pipe exp.dmp This will generate multiple files, 2.047 MB per file. They will be named exp.dmpaa, exp.dmpab, exp.dmpac, etc,etc. To import, you'd simply do: cat exp.dmp?? my_pipe imp file=my_pipe all other import options Hope that helps, -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions Needed: Latch free - library cache
During the Hotsos course I thought I remember hearing that the pool could be too large and that could have a negative impact on the library cache latch. Am I confusing this with something else (maybe the buffer busy event)? If true how do you go about determining the optimal size? From:Cary Millsap [EMAIL PROTECTED]@fatcity.com on 01/07/2004 07:44 PM PST Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Suggestions Needed: Latch free - library cache One way is by writing applications that use persistent connections. A mid-tier program ignites at 8amJan 1, connects to the Oracle instance, and then parses all the SQL it will use for the remainder of the year. The interface to this program from the user side is via "services," like "hire an employee," "fire an employee," "look up a salary," or whatever. Thousands of users throughout the year use the services, but the only parse calls the application makes all year occurred during the first few minutes of the morning on New Year's Day. Advantages are huge if you eliminate what would otherwise have been thousands of connections/disconnections and parse calls per day. All the db gets are binds, executes, and fetches except for the first few minutes after instance start-up. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis101: 1/27 Atlanta - SQL Optimization101: 2/16 Dallas - Hotsos Symposium 2004: March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: Wednesday, January 07, 2004 6:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Suggestions Needed: Latch free - library cache how do you limit excessive soft parsing? - Original Message - From:Bobak, Mark To:Multiple recipients of list ORACLE-L Sent:Wednesday, January 07, 2004 5:59 PM Subject:RE: Suggestions Needed: Latch free - library cache Tracy, What Oracle version? If you're not patched up to the latest patchset for your release, it's always a good idea to do so, as library cache bugs seem to invariably appear in every release. Has your code changed recently? Has your usage increased recently? Finally, library cache latch contention can be a sign of excessive soft parsing (hard parsing usually causes more shared pool latch contention). Do you have session_cached_cursors set? Just some thoughts -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- From: Tracy Rahmlow [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 5:40 PM To: Multiple recipients of list ORACLE-L Subject: Suggestions Needed: Latch free - library cache We have experienced intermittent problems (slow response time) with our oltp database today. There appears to be a large number of latch free events and the p2 parameter is indicating an issue with the library cache. Any thoughts on where to go next? American Express made the following annotations on 01/07/2004 03:36:25 PM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == American Express made the following annotations on 01/09/2004 07:39:30 AM -- ** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." ** ==
RE: Export bigger then 2G with Oracle7.3.4
The migration to an Oracle8i database is not possible, b'cause, the package using the database only support Oracle7. I will have problem if they decide to reuse this product. The coldbackup is the less demanding solution. Thanks -Original Message- Sent: January 9, 2004 9:39 AM To: Multiple recipients of list ORACLE-L You could migrate the database to 8i, or you could use sql to split the table into 2GB and do the export in pieces, or you could just shut the database down and do a cold backup of the database, retaining any media you need to reinstall Oracle 7. Make sure if you are in archivelog mode that you backup all logfiles. Allan -Original Message- [EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:59 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). application/ms-tnef
Hotsos Symposium Dinner
We considered this Mogens but you lost out to the Steve Adams 1-day seminar in a surprisingly close vote. As for an Oracle-L Tuesday group dinner during the Hotsos Symposium, I would suggest the Texas Bar Grill (http://www.theram.com/pages/restaurants/texas_bar_grill/texas/irving.as p). It is directly across from the hotel and a fun place equipped for larger groups. If someone can get us a headcount, I can have Stacy make the reservations. Gary (817)424-3443 Office (817)296-8000 Cell Hotsos Symposium 2004 - March 7-10. http://www.hotsos.com/appearances/sym2004.php -Original Message- Mogens Nørgaard Sent: Thursday, January 08, 2004 4:54 PM To: Multiple recipients of list ORACLE-L And since my topic at the Hotsos Symposium is /The DBA is Dead, the Database is Dying... But Our Future Looks Bright/ //there just MIGHT be a need for me to use a few, chosen, Danish bad words. I shall try, of course, to keep it in Danish. Shouldn't offend too many. Can I suggest, Gary, that we also do a Profanity Class 101 for the speakers during the event? I could teach some of it. Mogens Gary Goodman wrote: We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium speaker agreement. I will admit that profanity from Connor does not carry the same impact as profanity from Mogens! Gary -Original Message- Connor McDonald Sent: Wednesday, January 07, 2004 5:29 AM To: Multiple recipients of list ORACLE-L I'm saving that for the Hotsos symposium --- Daniel W. Fink [EMAIL PROTECTED] wrote: Who cares about the profanity Do you a) pound nails in a squirrel and b) force David Kurtz to consume massive amounts of gin whilst lobbing Fosters at the audience? Connor McDonald wrote: I have to admit I like this stuff about Connor's book especially since I'm only a co-author for the thing :-) (And unlike my presentations, I promise that there is no profanity in the book...) Cheers Connor --- Niall Litchfield [EMAIL PROTECTED] wrote: I haven't read it yet, but I'd be amazed if Connor's book wasn't excellent. He is a great communicator, despite being an aussie and all. Mogens and Tony from apress are probably pretty busy with the Miracle db forum right now (work gloves and stuff were mentioned euurgh), but there are plans that exist in more than Mogens' head for an OakTable press sequence of books, with apress as publishers. Someone has to write the buggers though. Some of us have work to do. Niall Not american, but not big and not clever either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 05 January 2004 22:34 To: Multiple recipients of list ORACLE-L Subject: oaktable people Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day ___ _ Yahoo! Messenger - Communicate instantly...Ping your friends today! Download
Who said Oracle ran better on Win03?
http://www.cxotoday.com/cxo/jsp/index.jsp?section=Newssubsection=Businesss ubsection_code=1file=template1.jspstoryid=505 Or, for the cut-and-paste impaired: http://tinyurl.com/23wcv Just adding gasoline to the bar-b-que... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Export bigger then 2G with Oracle7.3.4
--- [EMAIL PROTECTED] wrote: Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. are you certain that you want to use exp/imp for a 55 GB table? So a simple export on release 7 will crash when I will get 2G of dump file. It likely won't. I've seen a dump file on 7.3.4.4.5/NT4 sp6 of 8 GB. Max supported filesize with a 4KB block was 32 GB for datafiles. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? export FULL=Y ROWS=N. export all tables except for the 55 GB one via exp73.exe and unload the 55 GB table, load it via sqlldr.exe of the target database version. Thanks Luc hth. Pd __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export bigger then 2G with Oracle7.3.4
Mark, Jolane It's on WindowsNT, but I will install client7 on a Unix machine and I will use the pipe. Thank you Luc -Original Message- Sent: January 9, 2004 10:01 AM To: Multiple recipients of list ORACLE-L You don't mention OS, but if it's a flavor of unix, you could probably do: mknod my_pipe p exp file=my_pipe all other export options split -b 2047m my_pipe exp.dmp This will generate multiple files, 2.047 MB per file. They will be named exp.dmpaa, exp.dmpab, exp.dmpac, etc,etc. To import, you'd simply do: cat exp.dmp?? my_pipe imp file=my_pipe all other import options Hope that helps, -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). application/ms-tnef
RE: Oracle Standby.
Thanks, I've grabbed the whitepaper by Lawrence To (from http://otn.oracle.com/deploy/availability/pdf/stby8i_twp.pdf if anyone is interested). I'll take that home for bed time reading ;) If I have any more specific questions I'll give you all a shout again! ;) Many thanks Mark -Original Message- Shrake, Jolene Sent: 09 January 2004 14:39 To: Multiple recipients of list ORACLE-L There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use blat to send an email of the last log applied so that I can be sure everything is OK. I don't run in managed mode, the servers come down occasionally and that messes up the standby if you're not careful. Jolene -Original Message- Sent: Friday, January 09, 2004 8:20 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
timing data
I am trying to find a reference or document that explains how timing data is collected in 8i and 9i. I can remember reading an article that stated that 9i now collects in 1/1000th or 1/100th of a second. I know that through the v$system_event (one of the views in the wait interface) that it is 1/100th of a second. Does anybody now where a document is located that explains this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Standby.
Hi Mark... I have a good one... if you wanna copy email me off-list... Regards! JL --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Standby.
--- Shrake, Jolene [EMAIL PROTECTED] wrote: There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use blat to send an email of the last log applied so that I can be sure everything is OK. I don't run in managed mode, the servers come down occasionally and that messes up the standby if you're not careful. Jolene Mark, I have a few questions for you. Oracle version? (9i R2, I'd assume) Enterprise Edition or Standard? Database size? Volume of logs generated per day? standby server on local LAN or remote network? (do you want to use compression of logs) NetBIOS enabled over WAN/VPN? (what protocols are available to transfer logs) NOLOGGING operations permitted? (frequency of full refreshes, use of FORCE LOGGING) We run home-grown scripts for Standard Edition, but I have a project coming up where the Client is running Enterprise Edition, so when they are migrated to 9i R2, we're planning on using DataGuard to handle the physical standby. you're likely going to want to automate creation of initial backupset used for standby, and for automated refreshing of entire db. gotta run. Pd -Original Message- Sent: Friday, January 09, 2004 8:20 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hotsos Symposium Dinner
oh, just reserve the whole place :) From what I've been seeing, it's somewhere between 10-20 people so far... Jared? you started it, have you been keeping track? If not, anyone who is interested in a Tuesday night get-together at Hotsos, email me directly and I'll get a headcount to Gary -- to give those who are slow time to respond, I'll give Gary the list at the end of January (Gary, will that be enough time?). Rachel --- Gary Goodman [EMAIL PROTECTED] wrote: We considered this Mogens but you lost out to the Steve Adams 1-day seminar in a surprisingly close vote. As for an Oracle-L Tuesday group dinner during the Hotsos Symposium, I would suggest the Texas Bar Grill (http://www.theram.com/pages/restaurants/texas_bar_grill/texas/irving.as p). It is directly across from the hotel and a fun place equipped for larger groups. If someone can get us a headcount, I can have Stacy make the reservations. Gary (817)424-3443 Office (817)296-8000 Cell Hotsos Symposium 2004 - March 7-10. http://www.hotsos.com/appearances/sym2004.php -Original Message- Mogens Nørgaard Sent: Thursday, January 08, 2004 4:54 PM To: Multiple recipients of list ORACLE-L And since my topic at the Hotsos Symposium is /The DBA is Dead, the Database is Dying... But Our Future Looks Bright/ //there just MIGHT be a need for me to use a few, chosen, Danish bad words. I shall try, of course, to keep it in Danish. Shouldn't offend too many. Can I suggest, Gary, that we also do a Profanity Class 101 for the speakers during the event? I could teach some of it. Mogens Gary Goodman wrote: We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium speaker agreement. I will admit that profanity from Connor does not carry the same impact as profanity from Mogens! Gary -Original Message- Connor McDonald Sent: Wednesday, January 07, 2004 5:29 AM To: Multiple recipients of list ORACLE-L I'm saving that for the Hotsos symposium --- Daniel W. Fink [EMAIL PROTECTED] wrote: Who cares about the profanity Do you a) pound nails in a squirrel and b) force David Kurtz to consume massive amounts of gin whilst lobbing Fosters at the audience? Connor McDonald wrote: I have to admit I like this stuff about Connor's book especially since I'm only a co-author for the thing :-) (And unlike my presentations, I promise that there is no profanity in the book...) Cheers Connor --- Niall Litchfield [EMAIL PROTECTED] wrote: I haven't read it yet, but I'd be amazed if Connor's book wasn't excellent. He is a great communicator, despite being an aussie and all. Mogens and Tony from apress are probably pretty busy with the Miracle db forum right now (work gloves and stuff were mentioned euurgh), but there are plans that exist in more than Mogens' head for an OakTable press sequence of books, with apress as publishers. Someone has to write the buggers though. Some of us have work to do. Niall Not american, but not big and not clever either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 05 January 2004 22:34 To: Multiple recipients of list ORACLE-L Subject: oaktable people Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling === message truncated === __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for
Re: Export / Import Question
TRIGGERS=N On 01/09/2004 09:09:26 AM, Smith, Ron L. wrote: I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internet secure solutions
Guys, Any good doc. on securing data on database on internal network behind firewall with an application server accessing it in the DMZ. I am thinking Advanced security but would appreciate something on this subject. I have stored some documents on security from previous strings but cannot get to my folder do to a system issue. Thanks for any assistance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
Ron, I share your feeling. All stored objects are recreated with CREATE OR REPLACE - IGNORE=Y is inoperant for them. IMHO the best you can do is generate as many table-level exports as you have tables, with TRIGGERS=N. Of course, usual fun with constraints. On the bright side, you will be able to parallelize like crazy. At this stage, dumping to a flat file and using sqlldr might be an even better option than imp/exp. HTH S Faroult - --- Original Message --- - From: Smith, Ron L. [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 09 Jan 2004 06:09:26 I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Trigger Question - Thanks for all the help
Hi All, Thanks for all the tips and links to web sites. Really appreciated. I did have a mutating trigger - but I also had it calling a pre-existing procedure that had a commit in it (which from what I read today is not allowed) In the end I put the code in an existing procedure - it took only about 5 lines or so which was similar to implement than the mutating trigger solution. Regards, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-GovindanK :-Sent: 08 January 2004 21:20 :-To: Multiple recipients of list ORACLE-L :-Subject: Re: Trigger Question :- :- :-Ok. Here you go. :- :-http://osi.oracle.com/~tkyte/Mutate/index.html :- :-Let me know if you find this useful. :- :-HTH :- :-GovindanK :-OCP 8,8i :-Brainbench Certified Master DBA(8) :- :- :-On Thu, 08 Jan 2004 11:24:25 -0800, Nuala Cullen :-[EMAIL PROTECTED] :-said: :- :- Hi All, :- :- Firstly my apologies if this seems like a very *stupid* :-question but I'm :- a :- tad confused (and it's late in the evening) :- :- When an AFTER INSERT trigger is fired (row level) has the row been :- committed :- to the database at this stage? :- :- If so is it ok to call a package in the trigger that :-selects that row and :- changes some values in the row? :- :- Thanks, :- :- N. :- :- :--- :-http://www.fastmail.fm - Or how I learned to stop worrying and :- love email again :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: GovindanK :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in :-the message BODY, include a line containing: UNSUB ORACLE-L :-(or the name of mailing list you want to be removed from). You may :-also send the HELP command for other information (like subscribing). :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman restore question
Sorry, I tried set until time, it works. Now I think we can move rman to production since we tested all kinds of restore. Thanks and have nice day! Joan Joan Hsieh wrote: Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman restore question
Joan - Glad to hear your success. In the meanwhile I replied to your earlier message. Just to clarify, when you used a time-based recovery, setting a time earlier than the most recent backup, RMAN ignored the most recent backup and restored from an earlier backup? Wouldn't that have the disadvantage that you're stuck with a database that doesn't have all the recent transactions applied? Just asking, you're probably suffering from recovery fatigue now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Sorry, I tried set until time, it works. Now I think we can move rman to production since we tested all kinds of restore. Thanks and have nice day! Joan Joan Hsieh wrote: Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
RE: rman restore question
Joan - I have not used the redundancy policy, but my understanding is this just involves how many backup copies to retain. It does not relate to recovery as I read the manual. Do you have Robert Freeman's book Oracle9i RMAN Backup Recovery? Are you attempting an incomplete recovery or a complete recovery? Any recovery to a time prior to the current time is defined as an incomplete recovery. If I am recalling your goal, you are trying to recover but not use the latest backup sets. I always back up using an RMAN catalog, but have always tested recovery just using the control file. On Oracle8i I found it easier to separately issue a SQL command to back up the control file after an RMAN backup, then I ensure that control file ends up on the backup tape. This means that I can take the backup tape, restore the control file, then issue RMAN commands that will restore the database. That control file only knows about the RMAN backup that was last performed. So I could restore the data files from any backup. Now, as you know, recovery in RMAN is basically a shell over the Oracle recovery mechanism. You can restore using RMAN, then recover the database using Oracle server manager (now SQL*Plus) commands. So it should be possible to restore the database using RMAN as I described it (but not restore), then replace the old control file with a more recent control file, then recover the database (Oracle will apply archive log files) until the current time is reached. Obviously by starting with an older restore, more archive logs must be applied. Take a look at this idea and see if it would meet your requirements. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:24 AM To: Multiple recipients of list ORACLE-L Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services--
RE: timing data
David, See MetaLink Doc ID 39817.1, if you have access to MetaLink. Also, see Cary Millsap's new book: Optimizing Oracle Performance. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 10:19 AM To: Multiple recipients of list ORACLE-L I am trying to find a reference or document that explains how timing data is collected in 8i and 9i. I can remember reading an article that stated that 9i now collects in 1/1000th or 1/100th of a second. I know that through the v$system_event (one of the views in the wait interface) that it is 1/100th of a second. Does anybody now where a document is located that explains this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: timing data
search for tracing event 10046, or better, buy http://www.oreilly.com/catalog/optoraclep/index.html Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === I am trying to find a reference or document that explains how timing data is collected in 8i and 9i. I can remember reading an article that stated that 9i now collects in 1/1000th or 1/100th of a second. I know that through the v$system_event (one of the views in the wait interface) that it is 1/100th of a second. Does anybody now where a document is located that explains this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions Needed: Latch free - library cache
Title: Message Tracy, That's true, though it's less true in 8i and later than it was in 8.0 and earlier. This is due to the way that Oracle organizes free memory chunks. As to determining optimal size, well, if you run into ORA-4031 errors, then, short of a very poorly written application (that does lots of literal SQL), or a bug in your version of Oracle, the shared pool is probably too small. If you have lots of spare free memory after the system has been up and stable for a while, then your shared pool is probably too large. Steve Adams has the shared_pool_spare_free.sql script on his website, http://www.ixora.com.au/. Hope that helps, -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message-From: Tracy Rahmlow [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 9:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Suggestions Needed: Latch free - library cacheDuring the Hotsos course I thought I remember hearing that the pool could be too large and that could have a negative impact on the library cache latch. Am I confusing this with something else (maybe the buffer busy event)? If true how do you go about determining the optimal size? From: "Cary Millsap" [EMAIL PROTECTED]@fatcity.com on 01/07/2004 07:44 PM PST Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] cc: Subject: RE: Suggestions Needed: Latch free - library cache One way is by writing applications that use persistent connections. A mid-tier program ignites at 8amJan 1, connects to the Oracle instance, and then parses all the SQL it will use for the remainder of the year. The interface to this program from the user side is via "services," like "hire an employee," "fire an employee," "look up a salary," or whatever. Thousands of users throughout the year use the services, but the only parse calls the application makes all year occurred during the first few minutes of the morning on New Year's Day. Advantages are huge if you eliminate what would otherwise have been thousands of connections/disconnections and parse calls per day. All the db gets are binds, executes, and fetches except for the first few minutes after instance start-up. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis101: 1/27 Atlanta - SQL Optimization101: 2/16 Dallas - Hotsos Symposium 2004: March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: Wednesday, January 07, 2004 6:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Suggestions Needed: Latch free - library cache how do you limit excessive soft parsing? - Original Message - From:Bobak, Mark To:Multiple recipients of list ORACLE-L Sent:Wednesday, January 07, 2004 5:59 PM Subject:RE: Suggestions Needed: Latch free - library cache Tracy, What Oracle version? If you're not patched up to the latest patchset for your release, it's always a good idea to do so, as library cache bugs seem to invariably appear in every release. Has your code changed recently? Has your usage increased recently? Finally, library cache latch contention can be a sign of excessive soft parsing (hard parsing usually causes more shared pool latch contention). Do you have session_cached_cursors set? Just some thoughts -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message- From: Tracy Rahmlow [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 5:40 PM To: Multiple recipients of list ORACLE-L Subject: Suggestions Needed: Latch free - library cache We have experienced intermittent problems (slow response time) with our oltp database today. There appears to be a large number of latch free events and the p2 parameter is indicating an issue with the library cache. Any thoughts on where to go next? American Express made the following annotations on 01/07/2004 03:36:25 PM -- ** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this
RE: Hotsos Symposium Dinner
I'd like to go Allan -Original Message- Sent: Friday, January 09, 2004 9:35 AM To: Multiple recipients of list ORACLE-L oh, just reserve the whole place :) From what I've been seeing, it's somewhere between 10-20 people so far... Jared? you started it, have you been keeping track? If not, anyone who is interested in a Tuesday night get-together at Hotsos, email me directly and I'll get a headcount to Gary -- to give those who are slow time to respond, I'll give Gary the list at the end of January (Gary, will that be enough time?)). Rachel --- Gary Goodman [EMAIL PROTECTED] wrote: We considered this Mogens but you lost out to the Steve Adams 1-day seminar in a surprisingly close vote. As for an Oracle-L Tuesday group dinner during the Hotsos Symposium, I would suggest the Texas Bar Grill (http://www.theram.com/pages/restaurants/texas_bar_grill/texas/irving.as p). It is directly across from the hotel and a fun place equipped for larger groups. If someone can get us a headcount, I can have Stacy make the reservations. Gary (817)424-3443 Office (817)296-8000 Cell Hotsos Symposium 2004 - March 7-10. http://www.hotsos.com/appearances/sym2004.php -Original Message- Mogens Nørgaard Sent: Thursday, January 08, 2004 4:54 PM To: Multiple recipients of list ORACLE-L And since my topic at the Hotsos Symposium is /The DBA is Dead, the Database is Dying... But Our Future Looks Bright/ //there just MIGHT be a need for me to use a few, chosen, Danish bad words. I shall try, of course, to keep it in Danish. Shouldn't offend too many. Can I suggest, Gary, that we also do a Profanity Class 101 for the speakers during the event? I could teach some of it. Mogens Gary Goodman wrote: We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium speaker agreement. I will admit that profanity from Connor does not carry the same impact as profanity from Mogens! Gary -Original Message- Connor McDonald Sent: Wednesday, January 07, 2004 5:29 AM To: Multiple recipients of list ORACLE-L I'm saving that for the Hotsos symposium --- Daniel W. Fink [EMAIL PROTECTED] wrote: Who cares about the profanity Do you a) pound nails in a squirrel and b) force David Kurtz to consume massive amounts of gin whilst lobbing Fosters at the audience? Connor McDonald wrote: I have to admit I like this stuff about Connor's book especially since I'm only a co-author for the thing :-) (And unlike my presentations, I promise that there is no profanity in the book...) Cheers Connor --- Niall Litchfield [EMAIL PROTECTED] wrote: I haven't read it yet, but I'd be amazed if Connor's book wasn't excellent. He is a great communicator, despite being an aussie and all. Mogens and Tony from apress are probably pretty busy with the Miracle db forum right now (work gloves and stuff were mentioned euurgh), but there are plans that exist in more than Mogens' head for an OakTable press sequence of books, with apress as publishers. Someone has to write the buggers though. Some of us have work to do. Niall Not american, but not big and not clever either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 05 January 2004 22:34 To: Multiple recipients of list ORACLE-L Subject: oaktable people Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling === message truncated === __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
Oracle Warehouse Builder Tutorial
Greetings, Does anyone know of a good, readable tutorial on Oracle Warehouse Builder? I've been searching Google and even looking for books on Amazon.com and there seems to be a dearth of info on this product out there. I successfully installed it (9.2.0.3 Linux) and built the repository, run time repository, and target schema but I don't know where to go from here. Thanks, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stahlke, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OSUSER v 9.2.0.2 on linux
[ITS] [EMAIL PROTECTED] writes You should be aware that Oracle relies on the client providing this information, so it isn't always available. In particular, the JDBC thin driver tends to always use __jdbc__. Hi, certainly for the IP address you have to be using TCP. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: table reorganizations
Another way would be to do exchange partition between a single- or multipartition partitioned table and a regular table. Easier than dbms_redefinition and less locking issues than with manual lock swap. Tanel. --- Saatja: Rachel Carmichael [EMAIL PROTECTED] Kuupäev: 09.01.2004 16:14:33 --- yes a few seconds. that's why I said without locking for any length of time and not doesn't lock at all :) The point being that you can do the redef and still allow access to the main table. Do a sync every once in a while while there is high volume traffic, then do the finish when there is low volume if you manually lock the table, then do the copy, it can take significantly more time --- Mladen Gogala [EMAIL PROTECTED] wrote: I thought that finish_redef_table does lock table for a few seconds? On 01/09/2004 07:54:26 AM, Rachel Carmichael wrote: Chris, Have you considered using dbms_redefinition for your second case? That would allow you to reorg and swap the tables without locking for any length of time. Rachel --- [EMAIL PROTECTED] wrote: Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: seperate external procedure listeners for different SIDs
HUMM, I've taken a pretty tight stand against open ended external procedures and Java Stored Procedures. Thankfully the developers here agree. Basically I've told them that can't have an external or java procedure that executes a command send into it. That being the case rsh or sh command processors are verboten. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 5:29 AM To: Multiple recipients of list ORACLE-L Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the ORA-28576 lost RPC connection to external procedure agent. However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -Original Message- Sent: 08 January 2004 15:59 To: Multiple recipients of list ORACLE-L John, I agree if you have multiple databases under the same home all is well, one extproc sid will do. But if you have several different Oracle homes, with different versions of Oracle then each needs it's own extproc sid. Tried using the latest listener and/or extproc combinations, didn't work. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 08, 2004 10:44 AM To: Multiple recipients of list ORACLE-L Thanks - I wasn't sure if each session got its own instance of extproc. The SID associated with an EXTPROC is not the same as a SID associated with a database. I have several databases running under the same Oracle Home, and they are sharing the same external procedure listener - which references that Oracle Home. If you are running databases under several versions of Oracle, you may be able to use the listener for the latest version of Oracle you have to listen for all of them, and use its extproc. But it is probably a better idea to run separate listeners for databases and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own Oracle Home. Just be careful about how the TNS administration directory is set. -Original Message- Sent: Thursday, January 08, 2004 9:54 AM To: Multiple recipients of list ORACLE-L John, On the contrary. You do need to associate an EXTPROC with a particular SID otherwise running different versions of Oracle on the same box blows the EXTPROC to hell. You'll notice that in listener.ora there needs to be a line SID_NAME= and in TNSNAMES.ora there is a Connect_data = (sid = as well. Now a particular database instance/version can only have one extproc_connect_data entry, but with multiple versions each has it's own, and sure enough each has to have a particular sid otherwise they mess each other up. BTW: Your description of the process is dead on, with one exception. An instance of extproc is connected to one and only one session in the calling database. If two sessions each need to call an external procedure then each gets it's own instance of extproc. Also if you need to update the dll or so file you have to get everyone to let go of extproc, namely by disconnecting from the database. Although it's like a database link, closing the links does not release extproc. Also using TCP to connect to extproc is not an Oracle recommended method, opens a door to hackers. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Hotsos Symposium Dinner
I generally dislike large gatherings of people but for a Oracle-L get together I'll make the sacrifice. Count me in. At 07:54 AM 1/9/2004, you wrote: We considered this Mogens but you lost out to the Steve Adams 1-day seminar in a surprisingly close vote. As for an Oracle-L Tuesday group dinner during the Hotsos Symposium, I would suggest the Texas Bar Grill (http://www.theram.com/pages/restaurants/texas_bar_grill/texas/irving.as p). It is directly across from the hotel and a fun place equipped for larger groups. If someone can get us a headcount, I can have Stacy make the reservations. Gary (817)424-3443 Office (817)296-8000 Cell Hotsos Symposium 2004 - March 7-10. http://www.hotsos.com/appearances/sym2004.php Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Warehouse Builder Tutorial
Would love to know! -Original Message- Stahlke, Mark Sent: Friday, January 09, 2004 11:34 AM To: Multiple recipients of list ORACLE-L Greetings, Does anyone know of a good, readable tutorial on Oracle Warehouse Builder? I've been searching Google and even looking for books on Amazon.com and there seems to be a dearth of info on this product out there. I successfully installed it (9.2.0.3 Linux) and built the repository, run time repository, and target schema but I don't know where to go from here. Thanks, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stahlke, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hotsos Symposium Dinner
End of January is fine. Gary (817)424-3443 Office (817)296-8000 Cell -Original Message- Rachel Carmichael Sent: Friday, January 09, 2004 9:35 AM To: Multiple recipients of list ORACLE-L oh, just reserve the whole place :) From what I've been seeing, it's somewhere between 10-20 people so far... Jared? you started it, have you been keeping track? If not, anyone who is interested in a Tuesday night get-together at Hotsos, email me directly and I'll get a headcount to Gary -- to give those who are slow time to respond, I'll give Gary the list at the end of January (Gary, will that be enough time?). Rachel --- Gary Goodman [EMAIL PROTECTED] wrote: We considered this Mogens but you lost out to the Steve Adams 1-day seminar in a surprisingly close vote. As for an Oracle-L Tuesday group dinner during the Hotsos Symposium, I would suggest the Texas Bar Grill (http://www.theram.com/pages/restaurants/texas_bar_grill/texas/irving.as p). It is directly across from the hotel and a fun place equipped for larger groups. If someone can get us a headcount, I can have Stacy make the reservations. Gary (817)424-3443 Office (817)296-8000 Cell Hotsos Symposium 2004 - March 7-10. http://www.hotsos.com/appearances/sym2004.php -Original Message- Mogens Nørgaard Sent: Thursday, January 08, 2004 4:54 PM To: Multiple recipients of list ORACLE-L And since my topic at the Hotsos Symposium is /The DBA is Dead, the Database is Dying... But Our Future Looks Bright/ //there just MIGHT be a need for me to use a few, chosen, Danish bad words. I shall try, of course, to keep it in Danish. Shouldn't offend too many. Can I suggest, Gary, that we also do a Profanity Class 101 for the speakers during the event? I could teach some of it. Mogens Gary Goodman wrote: We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium speaker agreement. I will admit that profanity from Connor does not carry the same impact as profanity from Mogens! Gary -Original Message- Connor McDonald Sent: Wednesday, January 07, 2004 5:29 AM To: Multiple recipients of list ORACLE-L I'm saving that for the Hotsos symposium --- Daniel W. Fink [EMAIL PROTECTED] wrote: Who cares about the profanity Do you a) pound nails in a squirrel and b) force David Kurtz to consume massive amounts of gin whilst lobbing Fosters at the audience? Connor McDonald wrote: I have to admit I like this stuff about Connor's book especially since I'm only a co-author for the thing :-) (And unlike my presentations, I promise that there is no profanity in the book...) Cheers Connor --- Niall Litchfield [EMAIL PROTECTED] wrote: I haven't read it yet, but I'd be amazed if Connor's book wasn't excellent. He is a great communicator, despite being an aussie and all. Mogens and Tony from apress are probably pretty busy with the Miracle db forum right now (work gloves and stuff were mentioned euurgh), but there are plans that exist in more than Mogens' head for an OakTable press sequence of books, with apress as publishers. Someone has to write the buggers though. Some of us have work to do. Niall Not american, but not big and not clever either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 05 January 2004 22:34 To: Multiple recipients of list ORACLE-L Subject: oaktable people Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling === message truncated === __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
RE: timing data
David - I'll second Carel-Jan's suggestion. If you are this interested in this topic, you'll find Cary's book invaluable. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 10:15 AM To: Multiple recipients of list ORACLE-L search for tracing event 10046, or better, buy http://www.oreilly.com/catalog/optoraclep/index.html Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === I am trying to find a reference or document that explains how timing data is collected in 8i and 9i. I can remember reading an article that stated that 9i now collects in 1/1000th or 1/100th of a second. I know that through the v$system_event (one of the views in the wait interface) that it is 1/100th of a second. Does anybody now where a document is located that explains this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Suggestions Needed: Latch free - library cache
To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public synonyms causes contention for not only library cache latches but also row cache objects latches. What I had in mind is Steve Adams' test. Here's the URL http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right, the additional row cache objects latch gets are for synonym translations, particularly public synonym translations. Yong Huang __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: seperate external procedure listeners for different SIDs
This is the only reasonable policy, because all OS commands would necessarily execute on the server side. Developers, generally speaking, do not have access to the database server, so I don't see much use for that. If the idea is to spawn a command on the developer's workstation by using rsh or remsh (HP-UX), then it would require a great multitude of .rhosts files, which would render the whole network insecure. I did, however, see a reasonable application of external procedures. Database server was on the same machine as a scanner. External procedure made it possible for the operator to scan a form, OCR it, and store it as BFILE, all from Oracle*Forms on a client. Essentially, external procedure controlled the scanner and invoked OCR. Both scanner and PC were out of the computer room, so operator did not need access to the sensitive facilities. On 01/09/2004 11:44:26 AM, Goulet, Dick wrote: HUMM, I've taken a pretty tight stand against open ended external procedures and Java Stored Procedures. Thankfully the developers here agree. Basically I've told them that can't have an external or java procedure that executes a command send into it. That being the case rsh or sh command processors are verboten. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 5:29 AM To: Multiple recipients of list ORACLE-L Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the ORA-28576 lost RPC connection to external procedure agent. However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -Original Message- Sent: 08 January 2004 15:59 To: Multiple recipients of list ORACLE-L John, I agree if you have multiple databases under the same home all is well, one extproc sid will do. But if you have several different Oracle homes, with different versions of Oracle then each needs it's own extproc sid. Tried using the latest listener and/or extproc combinations, didn't work. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 08, 2004 10:44 AM To: Multiple recipients of list ORACLE-L Thanks - I wasn't sure if each session got its own instance of extproc. The SID associated with an EXTPROC is not the same as a SID associated with a database. I have several databases running under the same Oracle Home, and they are sharing the same external procedure listener - which references that Oracle Home. If you are running databases under several versions of Oracle, you may be able to use the listener for the latest version of Oracle you have to listen for all of them, and use its extproc. But it is probably a better idea to run separate listeners for databases and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own Oracle Home. Just be careful about how the TNS administration directory is set. -Original Message- Sent: Thursday, January 08, 2004 9:54 AM To: Multiple recipients of list ORACLE-L John, On the contrary. You do need to associate an EXTPROC with a particular SID otherwise running different versions of Oracle on the same box blows the EXTPROC to hell. You'll notice that in listener.ora there needs to be a line SID_NAME= and in TNSNAMES.ora there is a Connect_data = (sid = as well. Now a particular database instance/version can only have one extproc_connect_data entry, but with multiple versions each has it's own, and sure enough each has to have a particular sid otherwise they mess each other up. BTW: Your description of the process is dead on, with one exception. An instance of extproc is connected to one and only one session in the calling database. If two sessions each need to call an external procedure then each gets it's own instance of extproc. Also if you need to update the dll or so file you have to get everyone to let go of extproc, namely by disconnecting from the database. Although it's like a database link, closing the links does not release extproc. Also using TCP to connect to extproc is not an Oracle recommended method, opens a door
RE: Suggestions Needed: Latch free - library cache
During the Hotsos course I thought I remember hearing that the pool could be too large and that could have a negative impact on the library cache latch. Â Am I confusing this with something else (maybe the buffer busy event)? Â If true how do you go about determining the optimal size? Â Having too large shared pool may cause contention on shared pool latch, especially when shared pool's LRU lists get very long, causing searching for unpinned recreatable chunks to take long time (using CPU and preventing others from scanning the list). Before 9i there was only one shared pool latch protecting operations on whole shared pool. But starting from 9i, this issue can be relieved somewhat, but splitting the shared pool heap to several smaller heaps and assigning one shared pool child latch for each of them. This can be controlled using _kghdsidx_count parameter and the max in 9.2 seems to be 7, since there are 7 shared pool child latches (at least on W2K and Linux). However, when you split your shared pool to several parts, you might hit ORA-4031 error even when some shared pool heaps do have enough usable space, but the current one where allocation was tried, doesn't. Tanel. Tanel.
Re: Database Health Review
Hi Vidya, security! - There are a few checklists for security on my website at http;//www.petefinnigan.com/orasec.htm - but i guess you should have access to security and health check tools internally in Oracle? kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Suggestions Needed: Latch free - library cache
I remember readign that article and I thought the results that the contention was very minor? Steve, are you monitoring? It seemed like one of those things that its so minor its not really something to worry about? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:09 PM To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public synonyms causes contention for not only library cache latches but also row cache objects latches. What I had in mind is Steve Adams' test. Here's the URL http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right, the additional row cache objects latch gets are for synonym translations, particularly public synonym translations. Yong Huang __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
That would require effort and planning on their part. Ron -Original Message- Sent: Friday, January 09, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: seperate external procedure listeners for different SIDs
I'm not sure if I'd mentioned this before: We do use an external procedure to run external OS commands, but the procedure that is mapped to the C program is a private procedure in a package. The public interface to this procedure uses the PRODUCT_PROFILE (aka PRODUCT_USER_PROFILE) table to control who may execute what commands. The default is that no-one may execute any commands. We use the table to allow access much as SQL*Plus uses it to deny access to certain commands. -Original Message- Sent: Friday, January 09, 2004 11:44 AM To: Multiple recipients of list ORACLE-L HUMM, I've taken a pretty tight stand against open ended external procedures and Java Stored Procedures. Thankfully the developers here agree. Basically I've told them that can't have an external or java procedure that executes a command send into it. That being the case rsh or sh command processors are verboten. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 5:29 AM To: Multiple recipients of list ORACLE-L Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the ORA-28576 lost RPC connection to external procedure agent. However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Export / Import Question
On 01/09/2004 12:29:35 PM, Smith, Ron L. wrote: That would require effort and planning on their part. Ron Ron, are your developers little, bearded men that live in the swamps of Elbonia? Planning and effort are contrary to the elbonian customs, but Elbonians are cheap labor. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
Ron - You have my sympathy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 11:30 AM To: Multiple recipients of list ORACLE-L That would require effort and planning on their part. Ron -Original Message- Sent: Friday, January 09, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internet secure solutions
--- [EMAIL PROTECTED] wrote: Guys, Any good doc. on securing data on database on internal network behind firewall with an application server accessing it in the DMZ. I am thinking Advanced security but would appreciate something on this subject. I have stored some documents on security from previous strings but cannot get to my folder do to a system issue. Thanks for any assistance. Hi. how about some OS and database server version info? It wouldn't surprise me if SysAdmin Mag has an article on exactly this. Will more than just OracleNet traffic need to be encrypted? If so, then an ssh tunnel (or some other vpn solution) might make more sense. One method is entirely physical: private network (non-virtual) over additional NICs + crossover cable but that would require that you run a firewall on the server housing the database, as the application server is in an untrusted network. As it circumvents the existing firewall, it could get you fired for violating the site security policy, so it isn't necessarily a good solution. But its one worth considering. I really like using dedicated point to point connections between app server and database server where both servers have dual integrated gigabit cards, no one has coughed up the funds for switched gigabit ethernet ports and one of the integrated gigabit nics is unused (for a fat client/server app). but it does not scale for several hosts. Pd __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HP-UX Can not authenticate via OS
Any one see this one? I am working on getting more info about the configuration of this database, I don't have access to it. On AIX and Solaris, it is working fine. (9.2.0.4.0) on HP-UX. While I am trying to connect to the database using OS Authentication, the following error is raised $ sqlplus / SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 9 14:07:19 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-00600: internal error code, arguments: [15051], [], [], [], [], [], [], [] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: seperate external procedure listeners for different SIDs
That's a wrinkle I had not thought about. Here, being a PeopleSoft shop, they like to run SQR's and sure enough they want to run the same sqr's from web pages, forms applications, etc. Well I took the stand that the external procedure could only be passed data. No you can't pass an sqr filename, no you can't pass username and password (I get them from elswhere). It works and damanagement supports the idea. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 12:39 PM To: Multiple recipients of list ORACLE-L I'm not sure if I'd mentioned this before: We do use an external procedure to run external OS commands, but the procedure that is mapped to the C program is a private procedure in a package. The public interface to this procedure uses the PRODUCT_PROFILE (aka PRODUCT_USER_PROFILE) table to control who may execute what commands. The default is that no-one may execute any commands. We use the table to allow access much as SQL*Plus uses it to deny access to certain commands. -Original Message- Sent: Friday, January 09, 2004 11:44 AM To: Multiple recipients of list ORACLE-L HUMM, I've taken a pretty tight stand against open ended external procedures and Java Stored Procedures. Thankfully the developers here agree. Basically I've told them that can't have an external or java procedure that executes a command send into it. That being the case rsh or sh command processors are verboten. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 5:29 AM To: Multiple recipients of list ORACLE-L Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the ORA-28576 lost RPC connection to external procedure agent. However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Warehouse Builder Tutorial
Title: RE: Oracle Warehouse Builder Tutorial Mark, Take a look at OTN (http://otn.oracle.com/products/warehouse/index.html). There is a little information there. Unfortunately, there isn't much documentation on OWB. The online help docs with the product were all I found last year. There was no huge Oracle doc like with their other products. I took the OWB class in D.C. last year at Oracle in Reston. If you could get your hands on the class books it would provide a great tutorial for you, but I don't know how you'd do that without taking the class :-). It's very much like Informatica in the sense that you use a GUI interface to create ETL procedures. It generates a TON of code behind the scenes, and that code can have errors, which you'll have to go in and manually troubleshoot. The GUI interface complicates the code debugging. I haven't worked with the software in a few months, but I sure hope they've improved it in recent releases. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Stahlke, Mark [mailto:[EMAIL PROTECTED]] Sent: Friday, January 09, 2004 11:34 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Warehouse Builder Tutorial Greetings, Does anyone know of a good, readable tutorial on Oracle Warehouse Builder? I've been searching Google and even looking for books on Amazon.com and there seems to be a dearth of info on this product out there. I successfully installed it (9.2.0.3 Linux) and built the repository, run time repository, and target schema but I don't know where to go from here. Thanks, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stahlke, Mark INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internet secure solutions
Running Oracle 9i and Solaris 2.9. It appears to me that the solution can be hardware based or Oracle based then. Which brings up questions about cost versus administration versus reliability. Hmmm. -Original Message- Paul Drake Sent: Friday, January 09, 2004 12:49 PM To: Multiple recipients of list ORACLE-L --- [EMAIL PROTECTED] wrote: Guys, Any good doc. on securing data on database on internal network behind firewall with an application server accessing it in the DMZ. I am thinking Advanced security but would appreciate something on this subject. I have stored some documents on security from previous strings but cannot get to my folder do to a system issue. Thanks for any assistance. Hi. how about some OS and database server version info? It wouldn't surprise me if SysAdmin Mag has an article on exactly this. Will more than just OracleNet traffic need to be encrypted? If so, then an ssh tunnel (or some other vpn solution) might make more sense. One method is entirely physical: private network (non-virtual) over additional NICs + crossover cable but that would require that you run a firewall on the server housing the database, as the application server is in an untrusted network. As it circumvents the existing firewall, it could get you fired for violating the site security policy, so it isn't necessarily a good solution. But its one worth considering. I really like using dedicated point to point connections between app server and database server where both servers have dual integrated gigabit cards, no one has coughed up the funds for switched gigabit ethernet ports and one of the integrated gigabit nics is unused (for a fat client/server app). but it does not scale for several hosts. Pd __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Suggestions Needed: Latch free - library cache
Yong: I have not followed the thread completely. So I may be missing something obvious ;) BEGIN-NON TECHNICAL Many applications (for example Oracle Applications) use public synonyms heavily and running with better (or acceptable) performance. We should not really worry about the milli second performance improvements comparing with the coding/application development flexibilities offered by public synonymns. If you look at Steve's test carefully, the improvement or over head in the public synonym to private synonym is around 10% of the CPU time and latch gets. How much performance improvement you can expect in practical systems with the additiona 10% of latch gets/CPU times comparing with the overall system performance. I would expect less than (LESS THAN) 1-2% in total response time. END NON TECHNICAL The actual over head is coming from the negative dependency tracking or high version count in the Library cache. But this will be an issue only when too many users are connected and accssing the database with too many accounts (different parsing user_id). But this is rarely a situation in many of the packaged application as most of the application connects to the database using a single account (like 'APPS' user in Oracle eBusiness suite) and no negative dependency or multi version of SQLs are an issue here (at least in a single instance oracle). The over head can be little higher in RAC environment as the Library Cache and Row cache is globally co-ordinated. However I have not really seen major problem (may be I have not observed them too keen) with the public synonyms as most of the packaged applications I have worked are using a single oracle account to connect to the database. It is just my personal observation, and may be Jonathan can have a different opinion. Regards, KG PS : Aplogies if some one has already addressed this issue, I have been traveling and didn;t have enough free time to read all the posts. Seen lots of posts flooding on this topic and jumped in out of curiosity. --- Yong Huang [EMAIL PROTECTED] wrote: To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public synonyms causes contention for not only library cache latches but also row cache objects latches. What I had in mind is Steve Adams' test. Here's the URL http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right, the additional row cache objects latch gets are for synonym translations, particularly public synonym translations. Yong Huang = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DB_WRITER_PROCESSES vs DBWR_IO_SLAVES
Title: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES Running 9.2.0.2 on AIX 4.3.3. We recently experienced a situation where a datawarehouse database crashed due to a bug dealing with DBWR_IO_SLAVES 0. Oracle's recommended fix was to set the DBWR_IO_SLAVES to 0, which I did. Now, my understanding is that if AIO is enabled on the box, the rule of thumb appears to be to use DB_WRITER_PROCESSES and set DBWR_IO_SLAVES = 0. Now, the Sr DBA here is screaming about the performance since I made the change, in particular, he says he's seeing high redo latch contention and redo log buffer waits which he says validates his contention that we need to get back to using DBWR_IO_SLAVES. I admit I'm confused. I don't clearly see the relationship that he complaining about. My idea of 'monitoring' was to assess free buffer waits, and to monitor the batch schedules to see if any degradation in timing had occurred, and since the change, neither has been an issue. Am I missing something? What stats should I be assessing to contrast the use of DB_WRITER_PROCESSES vs DBWR_IO_SLAVES? And yes, I've googled and metalinked and and most information is mainly pertinent to 7.3.4 and 8i and of a more general nature. And yes, DISK_ASCYCH_IO is set to TRUE. Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba
RE: Oracle Warehouse Builder Tutorial
Good luck finding any relevant documentation outside of TFM. I looked for a while before I decided to go back and read what oracle provided. The docs are decent. ...once you get the hang of owb it's fairly intuitive. The thing is laden with bugs though. 9.2 is vastly better IMHO that previous releases. Chris -Original Message- Sent: Friday, January 09, 2004 10:55 AM To: Multiple recipients of list ORACLE-L Would love to know! -Original Message- Stahlke, Mark Sent: Friday, January 09, 2004 11:34 AM To: Multiple recipients of list ORACLE-L Greetings, Does anyone know of a good, readable tutorial on Oracle Warehouse Builder? I've been searching Google and even looking for books on Amazon.com and there seems to be a dearth of info on this product out there. I successfully installed it (9.2.0.3 Linux) and built the repository, run time repository, and target schema but I don't know where to go from here. Thanks, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stahlke, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES
Thomas: I think you are right on monitoring the db writer performance. You should look the write complete waits/ free buffer waits to understand the db writer contention. I am not sure what prompted your Sr.DBA to think on increasing the IO slaves or db writers. KG --- Thomas Jeff [EMAIL PROTECTED] wrote: Running 9.2.0.2 on AIX 4.3.3. We recently experienced a situation where a datawarehouse database crashed due to a bug dealing with DBWR_IO_SLAVES 0. Oracle's recommended fix was to set the DBWR_IO_SLAVES to 0, which I did. Now, my understanding is that if AIO is enabled on the box, the rule of thumb appears to be to use DB_WRITER_PROCESSES and set DBWR_IO_SLAVES = 0. Now, the Sr DBA here is screaming about the performance since I made the change, in particular, he says he's seeing high redo latch contention and redo log buffer waits which he says validates his contention that we need to get back to using DBWR_IO_SLAVES. I admit I'm confused. I don't clearly see the relationship that he complaining about. My idea of 'monitoring' was to assess free buffer waits, and to monitor the batch schedules to see if any degradation in timing had occurred, and since the change, neither has been an issue. Am I missing something?What stats should I be assessing to contrast the use of DB_WRITER_PROCESSES vs DBWR_IO_SLAVES? And yes, I've googled and metalinked and and most information is mainly pertinent to 7.3.4 and 8i and of a more general nature. And yes, DISK_ASCYCH_IO is set to TRUE. Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internet secure solutions
Is all SQL*Net traffic between the app server and the database server? In other words, is all traffic secure where packets cannot be sniffed? Or do you need to encrypt the SQL query result set data going from the server to an unknown client? I believe that's what Oracle Advanced Security gives you. If you just want to limit access to the database server and you're using tcp you can put the following entries into the $ORACLE_HOME/network/admin/sqlnet.ora file: TCP.VALIDNODE_CHECKING=yes TCP.INVITED_NODES=(myappserver.mycompany.com,mydbaworkstation.mycompay.c om) Regardless of Oracle implementation, isn't a firewall a mandatory part of the equasion? Steve Orr Bozeman, Montana -Original Message- [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:29 AM To: Multiple recipients of list ORACLE-L Running Oracle 9i and Solaris 2.9. It appears to me that the solution can be hardware based or Oracle based then. Which brings up questions about cost versus administration versus reliability. Hmmm. -Original Message- Paul Drake Sent: Friday, January 09, 2004 12:49 PM To: Multiple recipients of list ORACLE-L --- [EMAIL PROTECTED] wrote: Guys, Any good doc. on securing data on database on internal network behind firewall with an application server accessing it in the DMZ. I am thinking Advanced security but would appreciate something on this subject. I have stored some documents on security from previous strings but cannot get to my folder do to a system issue. Thanks for any assistance. Hi. how about some OS and database server version info? It wouldn't surprise me if SysAdmin Mag has an article on exactly this. Will more than just OracleNet traffic need to be encrypted? If so, then an ssh tunnel (or some other vpn solution) might make more sense. One method is entirely physical: private network (non-virtual) over additional NICs + crossover cable but that would require that you run a firewall on the server housing the database, as the application server is in an untrusted network. As it circumvents the existing firewall, it could get you fired for violating the site security policy, so it isn't necessarily a good solution. But its one worth considering. I really like using dedicated point to point connections between app server and database server where both servers have dual integrated gigabit cards, no one has coughed up the funds for switched gigabit ethernet ports and one of the integrated gigabit nics is unused (for a fat client/server app). but it does not scale for several hosts. Pd -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Suggestions Needed: Latch free - library cache
just to weigh in on the side of use of public synonyms. If you intend to use roles to simplify privilege management, you are almost forced to use public synonyms, as you cannot create a private synonym owned by a role. Your other alternative is to hard-code the schema owner name in every object access, which somewhat invalidates the idea of portability and security between dev/test/production environments, as you would have to maintain the same schema owner name in all environments. As a general practice, I create a schema owner, a schema user and a schema proc_owner account. I use public synonyms throughout and have never seen a performance hit because of them. My (practical) $0.02 Rachel --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Yong: I have not followed the thread completely. So I may be missing something obvious ;) BEGIN-NON TECHNICAL Many applications (for example Oracle Applications) use public synonyms heavily and running with better (or acceptable) performance. We should not really worry about the milli second performance improvements comparing with the coding/application development flexibilities offered by public synonymns. If you look at Steve's test carefully, the improvement or over head in the public synonym to private synonym is around 10% of the CPU time and latch gets. How much performance improvement you can expect in practical systems with the additiona 10% of latch gets/CPU times comparing with the overall system performance. I would expect less than (LESS THAN) 1-2% in total response time. END NON TECHNICAL The actual over head is coming from the negative dependency tracking or high version count in the Library cache. But this will be an issue only when too many users are connected and accssing the database with too many accounts (different parsing user_id). But this is rarely a situation in many of the packaged application as most of the application connects to the database using a single account (like 'APPS' user in Oracle eBusiness suite) and no negative dependency or multi version of SQLs are an issue here (at least in a single instance oracle). The over head can be little higher in RAC environment as the Library Cache and Row cache is globally co-ordinated. However I have not really seen major problem (may be I have not observed them too keen) with the public synonyms as most of the packaged applications I have worked are using a single oracle account to connect to the database. It is just my personal observation, and may be Jonathan can have a different opinion. Regards, KG PS : Aplogies if some one has already addressed this issue, I have been traveling and didn;t have enough free time to read all the posts. Seen lots of posts flooding on this topic and jumped in out of curiosity. --- Yong Huang [EMAIL PROTECTED] wrote: To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public synonyms causes contention for not only library cache latches but also row cache objects latches. What I had in mind is Steve Adams' test. Here's the URL http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right, the additional row cache objects latch gets are for synonym translations, particularly public synonym translations. Yong Huang = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
Any way to syncronize sequences between database?
When doing a partial data refresh, using export/import, is there any way to synchronize Sequences between the two databases? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RAC setup on linux
Ok spent 1K for hardware, got 2, 2.0Ghz cpu, 1 G of ram, couple of ethernet cards(one for private heartbeat, other to put on internal network) computers and external firewire drive, doing RH AS 2.1, OCFS, etc. gonna build a lab setup next week. any pointers as to what gotchas would be appreciated, otherwise i'll hack my way thru it like usual :) thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions Needed: Latch free - library cache
The other option is a user logon trigger that does execute immediate 'alter session set current_schema=appowner'; Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 2:44 PM To: Multiple recipients of list ORACLE-L just to weigh in on the side of use of public synonyms. If you intend to use roles to simplify privilege management, you are almost forced to use public synonyms, as you cannot create a private synonym owned by a role. Your other alternative is to hard-code the schema owner name in every object access, which somewhat invalidates the idea of portability and security between dev/test/production environments, as you would have to maintain the same schema owner name in all environments. As a general practice, I create a schema owner, a schema user and a schema proc_owner account. I use public synonyms throughout and have never seen a performance hit because of them. My (practical) $0.02 Rachel --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Yong: I have not followed the thread completely. So I may be missing something obvious ;) BEGIN-NON TECHNICAL Many applications (for example Oracle Applications) use public synonyms heavily and running with better (or acceptable) performance. We should not really worry about the milli second performance improvements comparing with the coding/application development flexibilities offered by public synonymns. If you look at Steve's test carefully, the improvement or over head in the public synonym to private synonym is around 10% of the CPU time and latch gets. How much performance improvement you can expect in practical systems with the additiona 10% of latch gets/CPU times comparing with the overall system performance. I would expect less than (LESS THAN) 1-2% in total response time. END NON TECHNICAL The actual over head is coming from the negative dependency tracking or high version count in the Library cache. But this will be an issue only when too many users are connected and accssing the database with too many accounts (different parsing user_id). But this is rarely a situation in many of the packaged application as most of the application connects to the database using a single account (like 'APPS' user in Oracle eBusiness suite) and no negative dependency or multi version of SQLs are an issue here (at least in a single instance oracle). The over head can be little higher in RAC environment as the Library Cache and Row cache is globally co-ordinated. However I have not really seen major problem (may be I have not observed them too keen) with the public synonyms as most of the packaged applications I have worked are using a single oracle account to connect to the database. It is just my personal observation, and may be Jonathan can have a different opinion. Regards, KG PS : Aplogies if some one has already addressed this issue, I have been traveling and didn;t have enough free time to read all the posts. Seen lots of posts flooding on this topic and jumped in out of curiosity. --- Yong Huang [EMAIL PROTECTED] wrote: To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public synonyms causes contention for not only library cache latches but also row cache objects latches. What I had in mind is Steve Adams' test. Here's the URL http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right, the additional row cache objects latch gets are for synonym translations, particularly public synonym translations. Yong Huang = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
Books on rac
any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions Needed: Latch free - library cache
Hi Rachel My understanding of the negative aspects of public synonyms is that they kick in as the number of distinct Oracle Users you have increases. My *experience* is much the same as yours - namely I almost couldn't care, however this is predicated on applications tracking users and not using a different Oracle account for each user. (typically we have 1-2 accounts per app). The archetype of application development on Oracle says that you have a different oracle account for each user (albeit probably OS authenticated). Mind you that same archetype says you can change the sql. I think that the drawbacks that steve has in mind don't apply to the majority of 3rd party apps. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Should we stop analyzing?
Nice. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Lewis Sent: 09 January 2004 14:04 To: Multiple recipients of list ORACLE-L Subject: Re: Should we stop analyzing? Note in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February 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] Sent: Friday, January 09, 2004 1:19 PM - Original Message - Wouldn't it be nice if dbms_stats could do an incremental refresh, tracking ONLY stats changes that might make a difference to execution plan: I'd settle for a flag I could turn on and off, saying: do/do not change stats for this object. I know which of them need to be analyzed and which don't. Better than Oracle will ever, deltas or no deltas, workload managers or not. Available in Oracle 10g - lock stats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 way to syncronize sequences between database?
Smith, Ron L. wrote: When doing a partial data refresh, using export/import, is there any way to synchronize Sequences between the two databases? Thanks! Ron Ron, We use a perl script that connects to procduction and select the current sequence value then updates the dev sequences to that value. -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Books on rac
AS OF NOW, I have not come across a book which talks about RAC at a detailed level (at least to the level we expect). There are couple of books in the market, but they cover very little on RAC (Concepts and Internals) But, the Oracle Documentation (At least for the RAC part) is very good and it is very readable and has all the information you need. --- Joe Testa [EMAIL PROTECTED] wrote: any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Books on rac
Joe, Last year at the midaltantic Oracle users group seminars there was a presentation by Mike Ault what was very informative on RAC with a budget. I believe that he has some decent information available. You might check www.rampant-books.com for his works. Ron [EMAIL PROTECTED] 01/09/2004 2:59:26 PM any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: table reorganizations
Hi Chris Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. What would be the rationale for this? If the rationale is performance how much faster does it make everything, and how many users are complaining to start with? If purely for space management purposes then I'd ask why the deleted space could not be reused? 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Pah. Once a day indeed. Once every 5 minutes... I'm interested in why you implemented table swap instead of 'alter table move' which is what we did. Cheers, Chris Dunscombe Cheers Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES
One interpretation of increased red latch contention and log buffer space waits is that more work is being done more quickly - so the log writer can't keep up. This could mean: a)the log writer has slowed down b)the database writer(s) have speeded up, so there is less time lost on write complete waits, free space waits, and (side effect) buffer busy waits. So the symptoms could be positive or negative, and we don't have enough relevant information to say which. Depending on the nature of the application, and the number and duration of sync waits, you could address the log buffer space waits by increasing the size of the log buffer. Are the redo latch waits allocation latch or copy latch ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - Now, the Sr DBA here is screaming about the performance since I made the change, in particular, he says he's seeing high redo latch contention and redo log buffer waits which he says validates his contention that we need to get back to using DBWR_IO_SLAVES. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions Needed: Latch free - library cache
How would you handle the case where there are many sets of privileges, depending on which user you log in as? The trigger would give everyone the right to do anything the owner could to a table. There are times when I want create a read-only account in addition to an app user. we do allow sqlplus access to production by developers -- in a read-only state so they can investigate end user complaints. --- Bobak, Mark [EMAIL PROTECTED] wrote: The other option is a user logon trigger that does execute immediate 'alter session set current_schema=appowner'; Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 2:44 PM To: Multiple recipients of list ORACLE-L just to weigh in on the side of use of public synonyms. If you intend to use roles to simplify privilege management, you are almost forced to use public synonyms, as you cannot create a private synonym owned by a role. Your other alternative is to hard-code the schema owner name in every object access, which somewhat invalidates the idea of portability and security between dev/test/production environments, as you would have to maintain the same schema owner name in all environments. As a general practice, I create a schema owner, a schema user and a schema proc_owner account. I use public synonyms throughout and have never seen a performance hit because of them. My (practical) $0.02 Rachel --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Yong: I have not followed the thread completely. So I may be missing something obvious ;) BEGIN-NON TECHNICAL Many applications (for example Oracle Applications) use public synonyms heavily and running with better (or acceptable) performance. We should not really worry about the milli second performance improvements comparing with the coding/application development flexibilities offered by public synonymns. If you look at Steve's test carefully, the improvement or over head in the public synonym to private synonym is around 10% of the CPU time and latch gets. How much performance improvement you can expect in practical systems with the additiona 10% of latch gets/CPU times comparing with the overall system performance. I would expect less than (LESS THAN) 1-2% in total response time. END NON TECHNICAL The actual over head is coming from the negative dependency tracking or high version count in the Library cache. But this will be an issue only when too many users are connected and accssing the database with too many accounts (different parsing user_id). But this is rarely a situation in many of the packaged application as most of the application connects to the database using a single account (like 'APPS' user in Oracle eBusiness suite) and no negative dependency or multi version of SQLs are an issue here (at least in a single instance oracle). The over head can be little higher in RAC environment as the Library Cache and Row cache is globally co-ordinated. However I have not really seen major problem (may be I have not observed them too keen) with the public synonyms as most of the packaged applications I have worked are using a single oracle account to connect to the database. It is just my personal observation, and may be Jonathan can have a different opinion. Regards, KG PS : Aplogies if some one has already addressed this issue, I have been traveling and didn;t have enough free time to read all the posts. Seen lots of posts flooding on this topic and jumped in out of curiosity. --- Yong Huang [EMAIL PROTECTED] wrote: To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public synonyms causes contention for not only library cache latches but also row cache objects latches. What I had in mind is Steve Adams' test. Here's the URL http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right, the additional row cache objects latch gets
RE: Books on rac
I've read a couple of the books available on RAC: - Oracle9i RAC by Madhu Tumma and Mike Ault is decent, I'd give it a 2.5 out of 5. Good multi-platform coverage and decent coverage of the internals. The book suffers from poor layout/editing. The graphics look like they're photocopied and the text material seems a bit unstructured and is poorly indexed. The tuning chapter is also weak. - Oracle Real Application Clusters by Murali Vallath has a lot of generic Oracle DBA material and can might appear as an Oracle overview with RAC chapters added. I sent my copy back to Amazon. For some reason a this title have gotten a lot of good reviews on Amazon. I've by far found Metalink the best source for RAC documentation. Sten -Original Message- Sent: Friday, January 09, 2004 11:59 AM To: Multiple recipients of list ORACLE-L any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rognes, Sten INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Books on rac
Joe/Ron, Hope I am not beating anyone down, but a colleague has this particular book and said that much of it was a 'cut-and-paste' from the manual... I haven't read it yet, but I can verify this (offline) if you so need. OTOH, I do know that Murali Vallath has a book out on RAC, and I know for sure that he has worked on many RAC installations so you *might* get something from there... As ever, this is my $0.02 (which is not worth much against the Euro!), and carries my standard disclaimer. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: Books on rac Joe, Last year at the midaltantic Oracle users group seminars there was a presentation by Mike Ault what was very informative on RAC with a budget. I believe that he has some decent information available. You might check www.rampant-books.com for his works. Ron [EMAIL PROTECTED] 01/09/2004 2:59:26 PM any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC setup on linux
Joe, In random order, here's some hints: Make sure you visit Werner's site, http://www.puschitz.com He has all sorts of non-RAC ideas on how to install Oracle on all sorts of RH flavors. Beware that RH AS 2.1 is bloody old. You may have problems with it recognizing your newer hardware. Since this was just a test for us on a pair of 2.4Ghz P-IVs, I said Screw it! and went with RH9, which config'd our Intel D845 MB, the built-in video, and the built-in 100baseT Ethernet (our older 3com 100baseT PCI card for the private network was recognized OK). Something I have not seen anywhere else (perhaps it's just my lack of understand of a proper network setup), but when you are creating the /etc/hosts file, do NOT alias ANY nodenames to localhost! The Cluster Manager will fail. For example, alias localhost to 127.0.0.1 and NOT to 192.168.1.1 (or whatever your public/domain IP address is). If you need to change kernel settings permanently, instead of echoing values to a pseudo-file in /proc on boot, make the change in /etc/sysctl.conf If you want to try OCFS, you *must* follow Wim's guide on OTN (can't remember the URL, but it was an OracleWorld presentation!). Without following that, 1.08 and 1.09 are deathly slow to the point of unusability. Also beware that OCFS won't work out-of-the box with RH9. I patched 1.08, following guidelines that IBM used to patch XFS for RH9. If you want the patched source, let me know. The rest of my notes seem to mostly relate to that MetaLink doc. If you have problems, post here! There's enough of us that have tried it, that I'm sure you'll get an answer faster than Oracle Support. :) HTH! GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, January 09, 2004 1:54 PM To: Multiple recipients of list ORACLE-L Ok spent 1K for hardware, got 2, 2.0Ghz cpu, 1 G of ram, couple of ethernet cards(one for private heartbeat, other to put on internal network) computers and external firewire drive, doing RH AS 2.1, OCFS, etc. gonna build a lab setup next week. any pointers as to what gotchas would be appreciated, otherwise i'll hack my way thru it like usual :) thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who said Oracle ran better on Win03?
My reading of that is that they chose RH over *Unix* rather than Windows for the DB Server. Detailing the problems encountered while using Windows Server 2003 on the communication and transaction server side, Sharma said, We have been facing this perennial problem of business logic malfunction, which is solved only when we reset the server. We have an active-passive server combination, and hence shifting loads is possible without compromising network availability. Since Forbes' DBA's were already conversant with Unix, shifting to the Linux platform on the database side was not a problem. I also find it interesting that they consider the familiarity of the admins with Unix a plus for the database, but apparently no such concern exists over a much larger switch for the other servers in the system. I'm also a bit surprised given that the problem was with business logic malfunction that they were able to port all their app code to a different platform without recoding (otherwise its comparing apples to oranges). Oh and it's a lottery of which I disapprove. Other than that interesting article :( Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesse, Rich Sent: 09 January 2004 15:00 To: Multiple recipients of list ORACLE-L Subject: Who said Oracle ran better on Win03? http://www.cxotoday.com/cxo/jsp/index.jsp?section=Newssubsect ion=Businesss ubsection_code=1file=template1.jspstoryid=505 Or, for the cut-and-paste impaired: http://tinyurl.com/23wcv Just adding gasoline to the bar-b-que... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Suggestions Needed: Latch free - library cache
that method is limiting. Lets say you publish data from various sources using transportable tablespaces... Its much easier to manage this publication by putting each transported tablespace in its own user. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:59 PM The other option is a user logon trigger that does execute immediate 'alter session set current_schema=appowner'; Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 2:44 PM To: Multiple recipients of list ORACLE-L just to weigh in on the side of use of public synonyms. If you intend to use roles to simplify privilege management, you are almost forced to use public synonyms, as you cannot create a private synonym owned by a role. Your other alternative is to hard-code the schema owner name in every object access, which somewhat invalidates the idea of portability and security between dev/test/production environments, as you would have to maintain the same schema owner name in all environments. As a general practice, I create a schema owner, a schema user and a schema proc_owner account. I use public synonyms throughout and have never seen a performance hit because of them. My (practical) $0.02 Rachel --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Yong: I have not followed the thread completely. So I may be missing something obvious ;) BEGIN-NON TECHNICAL Many applications (for example Oracle Applications) use public synonyms heavily and running with better (or acceptable) performance. We should not really worry about the milli second performance improvements comparing with the coding/application development flexibilities offered by public synonymns. If you look at Steve's test carefully, the improvement or over head in the public synonym to private synonym is around 10% of the CPU time and latch gets. How much performance improvement you can expect in practical systems with the additiona 10% of latch gets/CPU times comparing with the overall system performance. I would expect less than (LESS THAN) 1-2% in total response time. END NON TECHNICAL The actual over head is coming from the negative dependency tracking or high version count in the Library cache. But this will be an issue only when too many users are connected and accssing the database with too many accounts (different parsing user_id). But this is rarely a situation in many of the packaged application as most of the application connects to the database using a single account (like 'APPS' user in Oracle eBusiness suite) and no negative dependency or multi version of SQLs are an issue here (at least in a single instance oracle). The over head can be little higher in RAC environment as the Library Cache and Row cache is globally co-ordinated. However I have not really seen major problem (may be I have not observed them too keen) with the public synonyms as most of the packaged applications I have worked are using a single oracle account to connect to the database. It is just my personal observation, and may be Jonathan can have a different opinion. Regards, KG PS : Aplogies if some one has already addressed this issue, I have been traveling and didn;t have enough free time to read all the posts. Seen lots of posts flooding on this topic and jumped in out of curiosity. --- Yong Huang [EMAIL PROTECTED] wrote: To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public synonyms causes contention for not only library cache latches but also row cache objects latches. What I had in mind is Steve Adams' test. Here's the URL http://www.ixora.com.au/newsletter/2001_05.htm#synonyms. If I understand right, the additional row cache objects latch gets are for synonym translations, particularly public synonym translations. Yong Huang = Have a nice day !!
Re: Books on rac
beware the rampant press books. Most of them seem to be total garbage. All in large print with little detail. I didnt think much of the Ault Internals book from Rampant... its basically stuff you can copy and paste from metalink. Dont know about his RAC book. However, all the other non-Ault books from Rampant are total trash. There is another RAC book with some stuff on 10g by a guy who monitors this listserv(Murali Vallath). I have a copy of it, but have not read it yet. Anyone read either of those RAC books? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 3:19 PM Joe, Last year at the midaltantic Oracle users group seminars there was a presentation by Mike Ault what was very informative on RAC with a budget. I believe that he has some decent information available. You might check www.rampant-books.com for his works. Ron [EMAIL PROTECTED] 01/09/2004 2:59:26 PM any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Books on rac
Partly because of the complexity of the technology and uniqueness of each environment, no book in the field will be 100 per cent of what anyone of us needs; however, the following is on my database team's bookshelves: Oracle 9i RAC By Mike Ault Published August 2003 by Rampant Tech Press ISBN: 0972751300 Pages: 606 Regards, William Jones [EMAIL PROTECTED] wrote: any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: William R. Jones INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions Needed: Latch free - library cache
Um, roles, privileges, etc are administered however you'd like. The only suggestion I'm making is that rather than having public synonyms for all objects in your app_owner schema, each user which needs default access to the objects in the app_owner schema, gets access to that schema via the logon trigger that sets current_schema. This does (should) not have any effect on how you manage roles and permissions, just how Oracle does default object resolution. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 3:35 PM To: Multiple recipients of list ORACLE-L How would you handle the case where there are many sets of privileges, depending on which user you log in as? The trigger would give everyone the right to do anything the owner could to a table. There are times when I want create a read-only account in addition to an app user. we do allow sqlplus access to production by developers -- in a read-only state so they can investigate end user complaints. --- Bobak, Mark [EMAIL PROTECTED] wrote: The other option is a user logon trigger that does execute immediate 'alter session set current_schema=appowner'; Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 2:44 PM To: Multiple recipients of list ORACLE-L just to weigh in on the side of use of public synonyms. If you intend to use roles to simplify privilege management, you are almost forced to use public synonyms, as you cannot create a private synonym owned by a role. Your other alternative is to hard-code the schema owner name in every object access, which somewhat invalidates the idea of portability and security between dev/test/production environments, as you would have to maintain the same schema owner name in all environments. As a general practice, I create a schema owner, a schema user and a schema proc_owner account. I use public synonyms throughout and have never seen a performance hit because of them. My (practical) $0.02 Rachel --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Yong: I have not followed the thread completely. So I may be missing something obvious ;) BEGIN-NON TECHNICAL Many applications (for example Oracle Applications) use public synonyms heavily and running with better (or acceptable) performance. We should not really worry about the milli second performance improvements comparing with the coding/application development flexibilities offered by public synonymns. If you look at Steve's test carefully, the improvement or over head in the public synonym to private synonym is around 10% of the CPU time and latch gets. How much performance improvement you can expect in practical systems with the additiona 10% of latch gets/CPU times comparing with the overall system performance. I would expect less than (LESS THAN) 1-2% in total response time. END NON TECHNICAL The actual over head is coming from the negative dependency tracking or high version count in the Library cache. But this will be an issue only when too many users are connected and accssing the database with too many accounts (different parsing user_id). But this is rarely a situation in many of the packaged application as most of the application connects to the database using a single account (like 'APPS' user in Oracle eBusiness suite) and no negative dependency or multi version of SQLs are an issue here (at least in a single instance oracle). The over head can be little higher in RAC environment as the Library Cache and Row cache is globally co-ordinated. However I have not really seen major problem (may be I have not observed them too keen) with the public synonyms as most of the packaged applications I have worked are using a single oracle account to connect to the database. It is just my personal observation, and may be Jonathan can have a different opinion. Regards, KG PS : Aplogies if some one has already addressed this issue, I have been traveling and didn;t have enough free time to read all the posts. Seen lots of posts flooding on this topic and jumped in out of curiosity. --- Yong Huang [EMAIL PROTECTED] wrote: To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql
RE: Suggestions Needed: Latch free - library cache
Well, any solution will require consideration of the application design and implementation. I'm just offering a possible suggestion. ;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 4:00 PM To: Multiple recipients of list ORACLE-L that method is limiting. Lets say you publish data from various sources using transportable tablespaces... Its much easier to manage this publication by putting each transported tablespace in its own user. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:59 PM The other option is a user logon trigger that does execute immediate 'alter session set current_schema=appowner'; Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 2:44 PM To: Multiple recipients of list ORACLE-L just to weigh in on the side of use of public synonyms. If you intend to use roles to simplify privilege management, you are almost forced to use public synonyms, as you cannot create a private synonym owned by a role. Your other alternative is to hard-code the schema owner name in every object access, which somewhat invalidates the idea of portability and security between dev/test/production environments, as you would have to maintain the same schema owner name in all environments. As a general practice, I create a schema owner, a schema user and a schema proc_owner account. I use public synonyms throughout and have never seen a performance hit because of them. My (practical) $0.02 Rachel --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Yong: I have not followed the thread completely. So I may be missing something obvious ;) BEGIN-NON TECHNICAL Many applications (for example Oracle Applications) use public synonyms heavily and running with better (or acceptable) performance. We should not really worry about the milli second performance improvements comparing with the coding/application development flexibilities offered by public synonymns. If you look at Steve's test carefully, the improvement or over head in the public synonym to private synonym is around 10% of the CPU time and latch gets. How much performance improvement you can expect in practical systems with the additiona 10% of latch gets/CPU times comparing with the overall system performance. I would expect less than (LESS THAN) 1-2% in total response time. END NON TECHNICAL The actual over head is coming from the negative dependency tracking or high version count in the Library cache. But this will be an issue only when too many users are connected and accssing the database with too many accounts (different parsing user_id). But this is rarely a situation in many of the packaged application as most of the application connects to the database using a single account (like 'APPS' user in Oracle eBusiness suite) and no negative dependency or multi version of SQLs are an issue here (at least in a single instance oracle). The over head can be little higher in RAC environment as the Library Cache and Row cache is globally co-ordinated. However I have not really seen major problem (may be I have not observed them too keen) with the public synonyms as most of the packaged applications I have worked are using a single oracle account to connect to the database. It is just my personal observation, and may be Jonathan can have a different opinion. Regards, KG PS : Aplogies if some one has already addressed this issue, I have been traveling and didn;t have enough free time to read all the posts. Seen lots of posts flooding on this topic and jumped in out of curiosity. --- Yong Huang [EMAIL PROTECTED] wrote: To the OP: Other people point out common reasons for library cache latch contention. A less common reason is extensive use of public synonyms. If that's the reason, you also see row cache objects latch contention. I'm not sure that's right. If everyone uses a public synonym, then you get one sql text, and one cursor. I think the contention appears because everyone has to have a 'non-existent' reference in memory to say that they don't own an object with the same name as the public synonym - consequently if you have lots of users who have to check long chains of 'non-existent' then the latches get held for longer periods of time. Hi Jonathan, I don't see how your statement contradicts the claim that heavy use of public