Re: Change Manager
On 2003.12.08 01:49, George Leonard wrote: Hi there There was a article on asktom.oracle.com a while back of a stored procedure/trigger extension you can add to Oracle with a logging table that record when a table was added or modified or basically any object was altered. It's called a database trigger on ddl event. If I'm not mistaken, the syntax is something like create or relace trigger mytrig on scott.schema after create|drop|alter. What is so important about that article? That stuff is covered in 9i SQL reference manual. -- 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: Change Manager
Nothing is so important. It is just the gentle man below wanted to know how he can keep track of changes on his objects, this is an option open to him. George __ George Leonard Oracle Database Administrator Professional Services (Oracle Business Unit) Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- Mladen Gogala Sent: 08 December 2003 09:14 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 01:49, George Leonard wrote: Hi there There was a article on asktom.oracle.com a while back of a stored procedure/trigger extension you can add to Oracle with a logging table that record when a table was added or modified or basically any object was altered. It's called a database trigger on ddl event. If I'm not mistaken, the syntax is something like create or relace trigger mytrig on scott.schema after create|drop|alter. What is so important about that article? That stuff is covered in 9i SQL reference manual. -- 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). This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-02045 on 8.1.7.0.0
You may check the distributed_transaction parameter on your databases. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 1:54 PM Hello @all, maybe this is a newbie question (at least I am) I've got an Oracle 8.1.7 installation on Sun Solaris 8 (sparc). We use some database management software which gegerates several select-statements going over ten database users. After some seconds (everytime in another db-user and another table), the system prints out the following error: ORA-02045: too many local sessions participating in global transaction ORA-02063: preceding line from STGTSU What's up here? greetz Elmar -- +++ GMX - die erste Adresse für Mail, Message, More +++ Neu: Preissenkung für MMS und FreeMMS! http://www.gmx.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Elmar Hartung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
SET ORACLE-L MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Change Manager
MG, the article does something more than manual ... can you spell 'cut-and-paste' ??? It gives readymade code. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, December 08, 2003 2:14 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 01:49, George Leonard wrote: Hi there There was a article on asktom.oracle.com a while back of a stored procedure/trigger extension you can add to Oracle with a logging table that record when a table was added or modified or basically any object was altered. It's called a database trigger on ddl event. If I'm not mistaken, the syntax is something like create or relace trigger mytrig on scott.schema after create|drop|alter. What is so important about that article? That stuff is covered in 9i SQL reference manual. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
Oh ... and one more thing ... you can write code in Perl and not have many people understand it, greatly helps in job security if you are the only one at your work to know Perl. Okay, it is great, nice and better than many other languages, but now can you learn this language to obfuscation? http://compsoc.dur.ac.uk/whitespace/ We just took a class in Perl programming, so go ahead, you'll be glad you learned something and then you get addicted to YAPH. It surely does a lot more than sql*plus and ksh. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PERL?
Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
RE: PERL?
Hi I tend to use PHP (and present the results in a browser or via email) for scripts that fall outside the scope of (PL/)SQL. I have never had a serious look at Perl, is there any website(s) that can give a clear explanation of the pro's con's of both? The reason I choose PHP was the ease of learning and availability of resources/examples. Jack -Original Message- Sent: Monday, December 08, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: PERL?
what do you mean by sophisticated I/O? From: Cary Millsap [EMAIL PROTECTED] Date: 2003/12/07 Sun PM 11:59:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: PERL? You'll get much more comprehensive answers than mine, but a few huge motives for me are. - You can't do I/O-especially sophisticated interactive I/O-conveniently in SQL*Plus or PL/SQL. - More generally, SQL restricts your viewpoint to what's inside the database. As a performance analyst, I need a language in which I can do text processing, mathematical processing, and especially experiments with the same OS calls that Oracle uses. You can even attach directly to the Oracle SGA with Perl, where you can get x$ information without using SQL. (I don't do it, but it can be done.) - Perl regular expression processing is spectacular compared to anything else out there; this is critical for text processing (lexical analysis and parsing). - Perl is more portable, more easily extensible, and better supported with lots of interesting open source libraries than Unix shells. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- KENNETH JANUSZ Sent: Sunday, December 07, 2003 9:34 PM To: Multiple recipients of list ORACLE-L I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM Youll get much more comprehensive answers than mine, but a few huge motives for me are - You cant do I/Oespecially sophisticated interactive I/Oconveniently in SQL*Plus or PL/SQL. - More generally, SQL restricts your viewpoint to whats inside the database. As a performance analyst, I need a language in which I can do text processing, mathematical processing, and especially experiments with the same OS calls that Oracle uses. You can even attach directly to the Oracle SGA with Perl, where you can get x$ information without using SQL. (I dont do it, but it can be done.) - Perl regular _expression_ processing is spectacular compared to anything else out there; this is critical for text processing (lexical analysis and parsing). - Perl is more portable, more easily extensible, and better supported with lots of interesting open source libraries than Unix shells. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization101: 12/8 Dallas, 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 KENNETH JANUSZ Sent: Sunday, December 07, 2003 9:34 PM To: Multiple recipients of list ORACLE-L Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
Re: RE: PERL?
Say, handling screen forms, sockets and pipes would be considered rather sophisticated IO, don't you think? Generally speaking, PL/SQL can only do simpleton I/O (a.k.a doofus I/O) while perl is much more sophisticated On 12/08/2003 08:09:25 AM, [EMAIL PROTECTED] wrote: what do you mean by sophisticated I/O? From: Cary Millsap [EMAIL PROTECTED] Date: 2003/12/07 Sun PM 11:59:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: PERL? You'll get much more comprehensive answers than mine, but a few huge motives for me are. - You can't do I/O-especially sophisticated interactive I/O-conveniently in SQL*Plus or PL/SQL. - More generally, SQL restricts your viewpoint to what's inside the database. As a performance analyst, I need a language in which I can do text processing, mathematical processing, and especially experiments with the same OS calls that Oracle uses. You can even attach directly to the Oracle SGA with Perl, where you can get x$ information without using SQL. (I don't do it, but it can be done.) - Perl regular expression processing is spectacular compared to anything else out there; this is critical for text processing (lexical analysis and parsing). - Perl is more portable, more easily extensible, and better supported with lots of interesting open source libraries than Unix shells. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- KENNETH JANUSZ Sent: Sunday, December 07, 2003 9:34 PM To: Multiple recipients of list ORACLE-L I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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).
Oracle and Novell eDirectory LDAP
Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 on another server
I have ftp'd the backup pieces into the identical backup location as the orignal server so I have all the stuff available... Im just wondering if I have to do something to tell it that I am on a different server... I've restored the controlfile mannually before but on the same server. I backup the controlfile and wrap in the backup piece with the normal backup. Brian -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Janardhana - That's a good point. Brian - were you expecting RMAN to extract your controlfile from the RMAN backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in 8i. I couldn't get that to work myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 6:49 PM To: Multiple recipients of list ORACLE-L May be you try the following: If you get errors restoring controlfile, You may ftp the controlfiles manually to the new server and startup mount the database first. Then, Try your restore database. -- Janardhana -Original Message- Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92
Oracle Data Guard
Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? 2) If yes then, is there any performance impact on Target/Source server database. 3) any drawbacks using Data Guard. with many thanks, Vijay. BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 on another server
DENNIS...Thanks for your feedback. Here it is.. (NSF problem??) 1. I am not using Tape only disk backups.. 2. I ftp'd the backup pieces to new machine 3. I created a link to duplicate the backup location on the original machine and other locations as pfiles...edited the init file for new control locations etc. 4. The controlfile was wrapping in the backup piece same backup command 5. It is an NSF mount point. (Netapp) Is there a solution with the NFS issue? Brian Spears Database Services [EMAIL PROTECTED] Limitedbrands TECHNOLOGY SERVICES -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62
RE: Oracle and Novell eDirectory LDAP
Stephane - Last week the following message was posted. While it relates to MS AD, rather than Novell, the principles are the same and after all LDAP is a standard -- right? ;-) So you may want to scan the archives for this thread. Several people have expressed interest in this topic, and it seems doable, but nobody has posted a success story. From my meager understanding of LDAP, I think you will have to install and run Oracle Internet Directory, at least to get started, then export an LDIF from OID and import it into eDirectory. Depending on how you intend to use LDAP, you may have to continue to synchronize the two. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 03, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Embarrassed by Google/OTN, after stating I had not had time to verify what version integrates with AD, I spent 10 mins on Google and OTN (Oracle Technology Network) and hey presto :- With Oracle9i Application Server 9.0.4, Oracle will offer prepackaged connectivity solutions for NT Domains and ADS. These solutions will allow Oracle customers to perform two-way synchronization of directory data between the Windows and Oracle environments. Therefore the answer is any version prior to Oracle 9i Application Server 9.0.4 does not have out-of-the-box integration with Active Directory. -Original Message- Sent: Monday, December 08, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN restore on another server
Brian - I think that is the problem -- you can't tell RMAN you are on a different server. The part I'm not getting a clear picture on is your control file. For this specific recovery, how is it getting a control file? Did you move one over from production, or are you waiting for RMAN to cough it up from the backup pieces? On 8i this tends to be a problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 08, 2003 8:39 AM To: Multiple recipients of list ORACLE-L I have ftp'd the backup pieces into the identical backup location as the orignal server so I have all the stuff available... Im just wondering if I have to do something to tell it that I am on a different server... I've restored the controlfile mannually before but on the same server. I backup the controlfile and wrap in the backup piece with the normal backup. Brian -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Janardhana - That's a good point. Brian - were you expecting RMAN to extract your controlfile from the RMAN backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in 8i. I couldn't get that to work myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 6:49 PM To: Multiple recipients of list ORACLE-L May be you try the following: If you get errors restoring controlfile, You may ftp the controlfiles manually to the new server and startup mount the database first. Then, Try your restore database. -- Janardhana -Original Message- Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71
Re: rebuilding indexes - sure to cause a ruckus
Hi! Yes Yong I agree with you, that rebuilding may be beneficial in some cases, especially some tables/indexes become either logically or physically read only (btw, I was not speaking about coalescing in my post, it's a different story anyway). But the point I wanted to make is that single query's speed (LIO amount) right after rebuilding index doesn't usually give us enough information to determine whether overall system speed will go better in long term. When you have rebuilt an index, it becomes more compact, causing more recursive operations for block splits and perhaps index height changes in the future. Also, in heavily loaded 24x7 environments with no real low-peak time, the additional CPU, IO and brief exclusive lock usage may cause more harm than it gives benefit. And often this benefit is only short term in regular OLTP systems. But in some cases, as when you've deleted a number of rows from your table or done a lot of updates and you never expect these keys to be back in the index, a rebuild can be justified. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 10:29 PM Tanel, I think you're saying a query almost always runs faster right after the index rebuild and there's no point in finding the criterion whether to rebuild an index. (What is 42?) Some time ago I posted a message somewhere else showing a case where rebuilding or coalescing an index may be benefitial. A data warehouse is found to have some data errors. Deletes and updates are done. Then the database goes to mostly read-only again, and will last for a month or quarter. Then shrinking frequently used B*Tree indexes is a good idea. Now I'd like to add one more criterion as a result of reading Jonathan Lewis' dbazine article and email with him (errors are mine): the index is full scanned, or if range scanned or unique scanned, the index selectivity has to be fairly low (but not too low for the index to be ignored by CBO). In a typical working environment, a data warehouse does have plenty of relatively quiet period. I worked on a monthly data load project at an insurance company. I remember we rebuilt a partitioned IOT (one partition at a time) and fast full index scan (certain partitions) did run faster. There're some errors in Don Burleson's dbazine article (e.g. pct_used in dba_indexes) and Mike Hordila's Oramag article (structurally unbalanced index). But one thing alluded to in there is important: study Oracle performance problems as scientific research. You said setting _wait_for_sync to false improves performance. That's a fact. We can only explain and analyze it but not deny it. Similarly, when Mike says queries run 10 to 50% faster after index rebuild, we can't deny unless we find his measurement is wrong. Wouldn't it be nice if Oracle researchers write articles with sections like Abstract - Experimental - Results - Discussion in that order? Yong Huang Tanel Poder wrote: There's no point of arguing about whether a query ran faster right after you rebuilt your index. Nor there is no point in finding some ultimate algorithm for finding the point of index rebuilding, we all know the answer - it's 42. Instead, a long stress test has to be done, e.g. running 10 millions of continous transactions and queries (simulating real life). Do one 10M without rebuilding indexes in the meantime, measure total execution time, IO amount, CPU usage, segment sizes etc. Then restore your database back to starting point and do the same test again with regular index rebuilds during the operations (online or taking users offline, depending on environment type). And then measure the same statistics, especially total execution time. Note, that statistics and time also for rebuilding indexes should be accounted in totals, because in real life they don't just disappear somewhere as in some simple-minded tests. Tanel. __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- 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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
Alert Log
Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- 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: RE: Change Manager
Raj, Thanks for your response. Could you or someone in this list give me the url. I did search asktom site but not able to locate the actual code. - Original Message - Date: Monday, December 8, 2003 7:14 am MG, the article does something more than manual ... can you spell 'cut-and-paste' ??? It gives readymade code. Raj --- - Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, December 08, 2003 2:14 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 01:49, George Leonard wrote: Hi there There was a article on asktom.oracle.com a while back of a stored procedure/trigger extension you can add to Oracle with a logging table that record when a table was added or modified or basically any object was altered. It's called a database trigger on ddl event. If I'm not mistaken, the syntax is something like create or relace trigger mytrig on scott.schema after create|drop|alter. What is so important about that article? That stuff is covered in 9i SQL reference manual. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Alert Log
Maybe in %ORACLE_HOME%\dbs ? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 9:05 AM To: Multiple recipients of list ORACLE-L Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- 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: RE: Change Manager
There is a nice search feature on asktom page, I usually use that. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, December 08, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Raj, Thanks for your response. Could you or someone in this list give me the url. I did search asktom site but not able to locate the actual code. - Original Message - Date: Monday, December 8, 2003 7:14 am MG, the article does something more than manual ... can you spell 'cut-and-paste' ??? It gives readymade code. Raj --- - Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, December 08, 2003 2:14 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 01:49, George Leonard wrote: Hi there There was a article on asktom.oracle.com a while back of a stored procedure/trigger extension you can add to Oracle with a logging table that record when a table was added or modified or basically any object was altered. It's called a database trigger on ddl event. If I'm not mistaken, the syntax is something like create or relace trigger mytrig on scott.schema after create|drop|alter. What is so important about that article? That stuff is covered in 9i SQL reference manual. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Data Guard
Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Copying stats between/amongst schemas
Hi! I checked the Cassandra last time I was in Finland. It's a quite decent graphical tool for transferring/managing and testing statistics. It's based on dbms_stats, so it's just a frontend. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 1:39 AM Although I'm sure that someone (ChangeGroup in Denmark, Abase in Finland) would like to tell you about Cassandra: http://www.abase.fi/products_cassandra.php?lang=e (a GUI interface (+ more) to dbms_stats (sort of)). :o) Michael Garfield Sørensen, CeDeT - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 12:24 AM dbms_stats is the only sanctioned way to do it. Orr, Steve wrote: 1 database instance, 2 nearly identical schemas. What's the best sanctioned way to copy stats, (including histograms), from one schema to another? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-1?Q?Michael_Garfield_S=F8rensen?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
I/O error offlines a datafile
Hi I got the following error in an alert.log file. Aparently it was a result of some UNIX issues on a hdisk, which have been resolved some time later .. Fri Dec 5 18:28:10 2003 KCF: write/open error block=0x3571 online=1 file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 16384' Automatic datafile offline due to write error on file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf The file in question had status = 'RECOVER in the v$datafile and status = 'AVAIALBLE' in dba_Data_files. I attempted to restore the file after taking it offline, but couldn't due to a lock. I ended up bouncing the database an recovering this file. I'm wondering whether I should have tired to recover this file first without bouncing the database. If anyone has any experience with that issue, could you let me know whether what I did was wrong or not (and why). Is there a document that I can read on this? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CPU Capacity Planning
Thanks a lot, Cary. Yes, this sentence on p.248: As long the execution of each business function can be expressed in terms of an LIO count, you can translate the queueing model's output in terms of business function response time and throughput was the one I marked as something to go back to, as I didn't really understand it. Thanks, Boris Dali. --- Cary Millsap [EMAIL PROTECTED] wrote: Boris, I think I covered this in my response to Ryan. It was the two stages part. Note that you can avoid even using queueing theory at all if you just make sure that utilization stays to the left of the knee in the performance curve for each resource on the system. You can learn the location of the knee for a given number of parallel service channels (for example, CPUs in your case) on Table 9-3 on p260 of Optimizing Oracle Performance. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Boris Dali Sent: Sunday, December 07, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Thanks for the clarifications, Cary. With regards to a hardware sizing - how do LIOs fit into queueing theory? Let's say I can come up with something like: #CPUs required = Sum( LIOs(Bus.Tx i)) / (10,000*clock rate/100) where i={Bus.Tx 1..n} [on a projected box that haven't been bought yet, it might be a little difficult to estimate the denominator, ... and on the existing one I guess I have to get hold of Jonathan's paper to learn how this can be done] ..but in any event for forecasting purposes, how queueing effect might be taken into account here? Let's say I measured Sum( LIOs(...)) for a 50 users in a unit testing environment and I am told that production would be 10 times more than that, what do I do? Thanks, Boris Dali. --- Cary Millsap [EMAIL PROTECTED] wrote: My answers are in-line, preceded with [Cary Millsap]... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Boris Dali Sent: Sunday, December 07, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Thanks a lot for the reply, Cary. Yes, your explanation makes all the sense in the world even though it is precisely the weighted average approach that I've seen on some capacity planning spreadsheets. Two additional questions if I may, Cary. Would it be correct to say that when I throw additional users on a system it is only queueing component of a response time that climbs up, while service time stays the same? [Cary Millsap] Sort of, but not exactly. There are lots of scalability threats that begin to manifest in reality when you crank up the load. For example, you'll see latch free waiting on applications that parse too much, but only at higher user volumes (never in unit test). You can consider the new appearance of latch free events to be a type of queueing if you want, but it's really not queueing in the sense of a simple CPU queueing model. If that's true, than does it matter how I measure service time of my Bus.Tx1 - on a loaded system where hundreds of users run this operation or when nobody executes it all? Also is it important to have the other two operations - Bus.Tx2 and Bus.Tx3 - running concurrently (as they would in a real life) for the c measurements? [Cary Millsap] You'll put yourself at risk if you simply try to use a queueing model to extrapolate big-system performance from data collected in a unit testing environment. It's because of the potentially out-of-model scalability threats. In other words assuming I have an identical replica of a production environment where I am the only user - would service time/rate measured there be applicable for a loaded system with heterogeneous workload? [Cary Millsap] ...Only if you your production environment doesn't trigger any new serialization issues that weren't visible on your unit test env. And another stupid question. Knowing individual business tx. characteristics (response time, number of CPUs required to comply with SLA requirements, average utilization per CPU, etc), how does one go about sizing the box in terms of the overall system required CPU capacity? Or put it another way - what do I tell a hardware vendor? That is, if what comes out of a queueuing exercise is: m pho --- Bus.Tx1
RE: RMAN restore on another server
Brian - My sys admin pleads amnesia on the NFS problem. My recollection was that it was misconfigured or had a default configuration that expected only a couple of connections and RMAN actually opens MANY file connections. My specific symptoms is that RMAN would create the first few data files and then just stop. Oracle Support made me take NFS out of the mix and then everything worked. In your case, I am also concerned about the control file. I was unable to get 8i to create the control file from the backup although others on this list reported success with that. I would feel better if you said that you separately backed up the control file at the end of the RMAN backup, and manually moved that control file into place on the test system. At least you would eliminate that as the problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 08, 2003 8:49 AM To: Multiple recipients of list ORACLE-L DENNIS...Thanks for your feedback. Here it is.. (NSF problem??) 1. I am not using Tape only disk backups.. 2. I ftp'd the backup pieces to new machine 3. I created a link to duplicate the backup location on the original machine and other locations as pfiles...edited the init file for new control locations etc. 4. The controlfile was wrapping in the backup piece same backup command 5. It is an NSF mount point. (Netapp) Is there a solution with the NFS issue? Brian Spears Database Services [EMAIL PROTECTED] Limitedbrands TECHNOLOGY SERVICES -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23
RE: RE: PERL?
By more sophisticated I/O, I mean things like: read and write files anywhere from a byte at a time to a whole file at a time, do buffered C-like stuff (getc, ungetc), read and write directly with compressed output, get and set tty attributes, do graphics, and so on. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization101: 12/8 Dallas, 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 [EMAIL PROTECTED] Sent: Monday, December 08, 2003 7:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: PERL? Youll get much more comprehensive answers than mine, but a few huge motives for me are - You cant do I/Oespecially sophisticated interactive I/Oconveniently in SQL*Plus or PL/SQL. - More generally, SQL restricts your viewpoint to whats inside the database. As a performance analyst, I need a language in which I can do text processing, mathematical processing, and especially experiments with the same OS calls that Oracle uses. You can even attach directly to the Oracle SGA with Perl, where you can get x$ information without using SQL. (I dont do it, but it can be done.) - Perl regular _expression_ processing is spectacular compared to anything else out there; this is critical for text processing (lexical analysis and parsing). - Perl is more portable, more easily extensible, and better supported with lots of interesting open source libraries than Unix shells. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization101: 12/8 Dallas, 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 KENNETH JANUSZ Sent: Sunday, December 07, 2003 9:34 PM To: Multiple recipients of list ORACLE-L Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
Re: Alert Log
Shed some light on your dump parameters? They'd look much better if they had slashes instead of backslashes, but you probably can't help it. Now that you've told us where are your log and trace files, please tell us what's in them. My ESP capabilities are damaged by the snow and I need to actually see the messages to even be able to speculate. Things are bound to improve in the summer. In the meantime, try checking whether PRE_PAGE_SGA parameter is set to TRUE. That sometimes may increase the instance startup time. Also, was your instance shut down regularly or aborted? The instance may have been engaged in instance recovery. If my initial advice was followed (/ instead of \), I could advise you how to change /etc/init.d/oracle, but because of \, I can't help you. On 12/08/2003 10:04:33 AM, [EMAIL PROTECTED] wrote: Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: Alert Log
This is from the Oracle 8i Administrators Guide for Windows: Oracle8i for Windows NT background threads use trace files to record occurrences and exceptions of database operations, as well as errors. Background thread trace files are created regardless of whether the BACKGROUND_DUMP_DEST parameter is set in the INIT.ORA initialization parameter file. If BACKGROUND_DUMP_DEST is set, the trace files are stored in the directory specified. If the parameter is not set, the trace files are stored in the ORACLE_BASE\ADMIN\DB_NAME\BDUMP directory. This is the same information from the Oracle 9i Administrators Guide for Windows: The alert file is named SIDALRT.LOG and is found in the directory specified by parameter BACKGROUND_DUMP_DEST in the initialization parameter file. If parameter BACKGROUND_DUMP_DEST is not set, then file SIDALRT.LOG is generated in ORACLE_BASE\admin\db_name\bdump. Alert files should be deleted or archived periodically. HTH -Original Message- [EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:05 AM To: Multiple recipients of list ORACLE-L Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- 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: Gary W. Parker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Alert Log
If nothing else helps, download procexp or filemon from www.sysinternals.com and see which files are open by oracle.exe Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 5:04 PM Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- - - background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- 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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
The only thing I think I disagree with is the word almost. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization101: 12/8 Dallas, 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 Eric King Sent: Monday, December 08, 2003 6:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: PERL? Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
RE: PERL?
The difference that has affected me the most in writing utility scripts is that PERL can talk to the database like using a telephone. Ksh must talk like using a walkie-talkie; that is, each side of the conversation must talk then release the push-to-talk (PTT) button before the other side can talk. Using a small amount of cleverness (which is good, because that's about how much I have) in ksh, you can program around most of the communication limitations. For example, to deal with sqlplus getting stuck for one reason or the other, you can run the subsection of the script in the background (as a ksh job). Then you check on the job later in the script. If the job is still there longer than it should be, the script can kill the job. THEN, for good measure, look for sqlplus (and possible another ksh that got forked by the script) with parent process ID (PPID) of me and kill them. This is similar to the other side failing to release the PTT button. Unlike PERL, which can maybe yell into to telephone to wake the other side up, ksh must launch an artillery shell onto the other guy which, in a rather violent manner, will cause him to release the PTT button (well ... actually .. the PTT switch kind of got blown up too). Then, depending on the situation, retry the sqlplus or conclude that something is wrong. That being said, ksh is so easy to use and so handy, that I still use it for automating database management and monitoring. I'm sure a big part of that is because I learned shell, sed, awk, etc. programming before perl was standard equipment on Unix boxes. I suppose if you are starting from the beginning, then the way to go would be perl. But you can still do a heck of a lot with ksh (the REAL ksh; not the POS public domain ksh that tends to show up with linux). For an excellent book on getting started with this, go to Amazon and search on Mark G. Sobell (or just Sobell). Here's a tinyurl link to what I think is still must-have book. Even though a lot of it is outdated, the sections on getting around in Unix and shell scripting are still entirely relevant. http://tinyurl.com/y8x6 (Note that the used book sellers are just about giving away the book) There is also a BSD version of the above book. And you want to get O'Reilly's book on Sed and Awk. Those should get you going down the wonderful world of shell scripting ... which is the ORIGINAL, and still great, Rapid Application Development. -Original Message- I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. -- 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: PERL?
Hey Mladen, Weren't you going to be taking a look at Python too? (Around Thanksgiving as I recall.) I'd be interested in your feedback on it as well. My take is that Python is powerful yet easy to learn, it's much more productive than Java and is still quite scalable. Like Perl it's a great multi-platform scripting/glue language and shares many of its advantages but unlike Perl, it's been object oriented from the start. There is some looseness to its OO but the Python community touts that as an advantage. ;-) We have a Python story here where we host our software for the majority of our customers. While we perform most of the administration for our customers we also allow them to admin some stuff via a web app developed in Python. This app was developed under an accelerated schedule with a 3 man team headed by a brilliant computer science PhD dweeb who really doesn't have to work for a living but chose to work with us just for the fun of it. One of the things our customers can do is perform upgrades of their app and this entails things like creating complete database schemas, Oracle backups and creating/dropping tablespaces among other things. (Kind of scary from a DBA control freak perspective.) Shortly after this web app went production, one of the developers was tragically killed, another developer who was an intern went back to school, and the PhD dude went on to be a university professor so the app was kind of dumped on my department consisting of a dozen admin type dweebs. We had to learn Python to maintain this mission critical app in short order. Not only were we able to quickly come up to speed to support the app, we have since greatly enhanced it to where it's become central to much of our SysAdmin/DBA duties. One reason for this successful transitions was the virtue of Python. Several in the department (myself included) were Perl literate beforehand and there is now unanimous consensus that we could not have had as good transition if the app had been written in Perl and we are glad Python was forced on us because the readability of Python code makes it MUCH more maintainable. Besides being DBA I've now done enough in Python that I am part DUHveloper. With socket programming and XML I've been able to transact between databases. (Which is definitely more sophisticated I/O than PL/SQL is capable of.) I've also used Python to develop a web server and I'm even thinking about replacing some Apache usage with my own web server code. Well that's our story and there's more to Python than I can cover here so as soon as hunting season is over I'm going to resume preparation for my upcoming IOUW presentation titled, Python, Oracle and the Meaning of Life. Hope to see some of you there. Steve Orr Bozeman, Montana -Original Message- Mladen Gogala Sent: Sunday, December 07, 2003 10:04 PM To: Multiple recipients of list ORACLE-L Perl is a general purpose interpreted programming language, written specifically with reporting purpose in mind. In fact, perl stands for Practical Extraction/Reporting Language. That means that perl is excellent for producing all kinds of reports. In fact, it has a part called formats which is, in fact, a small report writer and can be used to produce beautiful reports very quickly and with minimal effort. The next very useful feature is an extremely versatile regular expression engine which can do whatever awk sed can do and more. That, of course, is ideal for parsing all kinds of regular expressions, like, for instance, parsing alert.log. Perl , as I've said before, is a general purpose programming language with pointers (all right, all right, the name is references, but those are really pointers) , which makes for an exceptionally powerful combination. Last, but not least, there is a huge treasure chest called CPAN (http://cpan.perl.org) which contains vast number of modules. In case of emergency, it's really easy to find something useful. One other thing worth mentioning is that perl has bindings and modules which make it possible to work with many databases, Tk, Gtk, HTML and almost anything conceivable (OLE, ODBC, ADO and other MS perversions included). There are two problems with perl. One is that perl is a huge language with so many intrinsic and important elements that it is really hard to learn the whole language. A title of a perl master should be an equivalent of a PhD. Another problem is a serious inadequacy of perl syntax for OO. Perl doesn't have classes, abstract classes, private/protected/public interface, templates, exception throw/catch mechanisms or some other things that we know and love. Perl's OO model is based on something called module, essentially a program unit and a very weird function named bless. This function plays a vital role in object construction and, it is done from up down to the ground instead of doing it from the ground up. Bless takes a pointer (reference) and blesses it to the pointer to a member of a given
RE: RMAN restore on another server
Dennis and all, I have no problem getting the controlfile... I just comment out the SET commands to change the directories of the dbfs...and I replicate the control according to the init file specifications.. So This operation actually extract the controlfile out of the backup piece so I know the location and connections are working fine. But since the controlfile is backup and I am restoring it with the same RMan command I think I should have no problem.. I know other DBAs.. run this same script and restore the database on another server with no problem if the controlfile is restored before the database is restored and recovered. Here is the restore controlfile script and resulting log file == Controlfile restore Script == connect catalog rman81740/[EMAIL PROTECTED] connect target / run { allocate channel d1 type disk ; sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; set until time = '2003-12-02 05:50:00'; #restore controlfile to '/u02/vssppln/restored_cf.ctl'; replicate controlfile from '/u02/vssppln/restored_cf.ctl'; release channel d1; } == Successful Controlfile restore log == Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 run 7 8 { 9 10 allocate channel d1 type disk ; 11 12 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 13 set until time = '2003-12-02 05:50:00'; 14 15 16 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 17 18 replicate controlfile from '/u02/vssppln/restored_cf.ctl'; 19 20 release channel d1; 21 } 22 23 RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target database: vssppln (not mounted) RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS RMAN-03023: executing command: sql RMAN-03022: compiling command: set RMAN-03022: compiling command: replicate RMAN-03023: executing command: replicate RMAN-08058: replicating controlfile RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1 Recovery Manager complete. = Here is the orignal entire script to restore controlfile and database but it just hangs on the set commands.. = == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname
Re: I/O error offlines a datafile
It's review time, so everything you do is wrong, as a cost saving measure. Any half way competent member of damagement can tell you that.In this particular case though, you could have recovered the datafile online. You should have offlined the tablespace, restored the datafile and recovered the datafile. Restarting the database was not not necessary. Also, one of my religious rituals is to perform a checkpoint after the tablespace has been successfully brought online. The reason is to record the new timestamp to the control file and make sure that all files have the same timestamp (checkpoint process updates file headers during checkpoint). On 12/08/2003 10:39:32 AM, Gene Gurevich wrote: Hi I got the following error in an alert.log file. Aparently it was a result of some UNIX issues on a hdisk, which have been resolved some time later .. Fri Dec 5 18:28:10 2003 KCF: write/open error block=0x3571 online=1 file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 16384' Automatic datafile offline due to write error on file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf The file in question had status = 'RECOVER in the v$datafile and status = 'AVAIALBLE' in dba_Data_files. I attempted to restore the file after taking it offline, but couldn't due to a lock. I ended up bouncing the database an recovering this file. I'm wondering whether I should have tired to recover this file first without bouncing the database. If anyone has any experience with that issue, could you let me know whether what I did was wrong or not (and why). Is there a document that I can read on this? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: PERL?
Title: Message Well I might have disputedyour "almost" dispute until I learned that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) OT: Anyone on the list ever run PlayStation on Linux? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary MillsapSent: Monday, December 08, 2003 9:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: PERL? The only thing I think I disagree with is the word almost. Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta- SQL Optimization101: 12/8 Dallas, 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 Eric KingSent: Monday, December 08, 2003 6:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: PERL? Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
Re: PERL?
Title: Message Then PERL should also run on a TIVO box - it usesLinux. Ken Janusz, CPIM - Original Message - From: Orr, Steve To: Multiple recipients of list ORACLE-L Sent: Monday, December 08, 2003 10:24 AM Subject: RE: PERL? Well I might have disputedyour "almost" dispute until I learned that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) OT: Anyone on the list ever run PlayStation on Linux? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary MillsapSent: Monday, December 08, 2003 9:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: PERL? The only thing I think I disagree with is the word almost. Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta- SQL Optimization101: 12/8 Dallas, 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 Eric KingSent: Monday, December 08, 2003 6:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: PERL? Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
Re: PERL?
I was. Unfortunately, I'm struggling with something called OpenLDAP, which was determined to be of even higher priority then Python. On 12/08/2003 11:14:33 AM, Orr, Steve wrote: Hey Mladen, Weren't you going to be taking a look at Python too? (Around Thanksgiving as I recall.) I'd be interested in your feedback on it as well. My take is that Python is powerful yet easy to learn, it's much more productive than Java and is still quite scalable. Like Perl it's a great multi-platform scripting/glue language and shares many of its advantages but unlike Perl, it's been object oriented from the start. There is some looseness to its OO but the Python community touts that as an advantage. ;-) We have a Python story here where we host our software for the majority of our customers. While we perform most of the administration for our customers we also allow them to admin some stuff via a web app developed in Python. This app was developed under an accelerated schedule with a 3 man team headed by a brilliant computer science PhD dweeb who really doesn't have to work for a living but chose to work with us just for the fun of it. One of the things our customers can do is perform upgrades of their app and this entails things like creating complete database schemas, Oracle backups and creating/dropping tablespaces among other things. (Kind of scary from a DBA control freak perspective.) Shortly after this web app went production, one of the developers was tragically killed, another developer who was an intern went back to school, and the PhD dude went on to be a university professor so the app was kind of dumped on my department consisting of a dozen admin type dweebs. We had to learn Python to maintain this mission critical app in short order. Not only were we able to quickly come up to speed to support the app, we have since greatly enhanced it to where it's become central to much of our SysAdmin/DBA duties. One reason for this successful transitions was the virtue of Python. Several in the department (myself included) were Perl literate beforehand and there is now unanimous consensus that we could not have had as good transition if the app had been written in Perl and we are glad Python was forced on us because the readability of Python code makes it MUCH more maintainable. Besides being DBA I've now done enough in Python that I am part DUHveloper. With socket programming and XML I've been able to transact between databases. (Which is definitely more sophisticated I/O than PL/SQL is capable of.) I've also used Python to develop a web server and I'm even thinking about replacing some Apache usage with my own web server code. Well that's our story and there's more to Python than I can cover here so as soon as hunting season is over I'm going to resume preparation for my upcoming IOUW presentation titled, Python, Oracle and the Meaning of Life. Hope to see some of you there. Steve Orr Bozeman, Montana -Original Message- Mladen Gogala Sent: Sunday, December 07, 2003 10:04 PM To: Multiple recipients of list ORACLE-L Perl is a general purpose interpreted programming language, written specifically with reporting purpose in mind. In fact, perl stands for Practical Extraction/Reporting Language. That means that perl is excellent for producing all kinds of reports. In fact, it has a part called formats which is, in fact, a small report writer and can be used to produce beautiful reports very quickly and with minimal effort. The next very useful feature is an extremely versatile regular expression engine which can do whatever awk sed can do and more. That, of course, is ideal for parsing all kinds of regular expressions, like, for instance, parsing alert.log. Perl , as I've said before, is a general purpose programming language with pointers (all right, all right, the name is references, but those are really pointers) , which makes for an exceptionally powerful combination. Last, but not least, there is a huge treasure chest called CPAN (http://cpan.perl.org) which contains vast number of modules. In case of emergency, it's really easy to find something useful. One other thing worth mentioning is that perl has bindings and modules which make it possible to work with many databases, Tk, Gtk, HTML and almost anything conceivable (OLE, ODBC, ADO and other MS perversions included). There are two problems with perl. One is that perl is a huge language with so many intrinsic and important elements that it is really hard to learn the whole language. A title of a perl master should be an equivalent of a PhD. Another problem is a serious inadequacy of perl syntax for OO. Perl doesn't have classes, abstract classes, private/protected/public interface, templates, exception throw/catch mechanisms or some other things that we know and love. Perl's OO model is based on something called module, essentially a program unit and
RE: PERL?
echo s='Perl is portable';print s.replace('Perl','Python')+' too!'|python -Original Message- KENNETH JANUSZ Sent: Monday, December 08, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Then PERL should also run on a TIVO box - it uses Linux. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, December 08, 2003 10:24 AM Well I might have disputed your almost dispute until I learned that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) OT: Anyone on the list ever run PlayStation on Linux? -Original Message- Cary Millsap Sent: Monday, December 08, 2003 9:00 AM To: Multiple recipients of list ORACLE-L The only thing I think I disagree with is the word almost. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Eric King Sent: Monday, December 08, 2003 6:39 AM To: Multiple recipients of list ORACLE-L Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- 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: PERL?
Title: Message It does. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 11:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: PERL? Then PERL should also run on a TIVO box - it usesLinux. Ken Janusz, CPIM - Original Message - From: Orr, Steve To: Multiple recipients of list ORACLE-L Sent: Monday, December 08, 2003 10:24 AM Subject: RE: PERL? Well I might have disputedyour "almost" dispute until I learned that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) OT: Anyone on the list ever run PlayStation on Linux? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary MillsapSent: Monday, December 08, 2003 9:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: PERL? The only thing I think I disagree with is the word "almost." Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta- SQL Optimization101: 12/8 Dallas, 2/16 Dallas- Hotsos Symposium 2004: March 7-10 Dallas- Visit www.hotsos.com for schedule details... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric KingSent: Monday, December 08, 2003 6:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: PERL? Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
Re: I/O error offlines a datafile
Mladen, Thank you very much for your suggestion. I tried exactly that - offline the tablespace and restore the datafile and - guess what? - it failed because of the lock being held against the datafile. That is what lead me (and the Oracle support guy) to bounce the database. Now I may be less than half way competent member of damanagement (whatever it means), but based on your advice you may be not much better. In the future if you can't refrain from isults, please do not reply to my posts. I'm asking for help and advice, not an insult. Gene --- Mladen Gogala [EMAIL PROTECTED] wrote: It's review time, so everything you do is wrong, as a cost saving measure. Any half way competent member of damagement can tell you that.In this particular case though, you could have recovered the datafile online. You should have offlined the tablespace, restored the datafile and recovered the datafile. Restarting the database was not not necessary. Also, one of my religious rituals is to perform a checkpoint after the tablespace has been successfully brought online. The reason is to record the new timestamp to the control file and make sure that all files have the same timestamp (checkpoint process updates file headers during checkpoint). On 12/08/2003 10:39:32 AM, Gene Gurevich wrote: Hi I got the following error in an alert.log file. Aparently it was a result of some UNIX issues on a hdisk, which have been resolved some time later .. Fri Dec 5 18:28:10 2003 KCF: write/open error block=0x3571 online=1 file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 16384' Automatic datafile offline due to write error on file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf The file in question had status = 'RECOVER in the v$datafile and status = 'AVAIALBLE' in dba_Data_files. I attempted to restore the file after taking it offline, but couldn't due to a lock. I ended up bouncing the database an recovering this file. I'm wondering whether I should have tired to recover this file first without bouncing the database. If anyone has any experience with that issue, could you let me know whether what I did was wrong or not (and why). Is there a document that I can read on this? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL
Re: PERL?
echo Python is portable|perl -e '$X=;chomp($X); print $X but it is much harder to write obfuscated code in Python\n;' On 12/08/2003 11:59:35 AM, Orr, Steve wrote: echo s='Perl is portable';print s.replace('Perl','Python')+' too!'|python -Original Message- KENNETH JANUSZ Sent: Monday, December 08, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Then PERL should also run on a TIVO box - it uses Linux. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, December 08, 2003 10:24 AM Well I might have disputed your almost dispute until I learned that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) OT: Anyone on the list ever run PlayStation on Linux? -Original Message- Cary Millsap Sent: Monday, December 08, 2003 9:00 AM To: Multiple recipients of list ORACLE-L The only thing I think I disagree with is the word almost. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Eric King Sent: Monday, December 08, 2003 6:39 AM To: Multiple recipients of list ORACLE-L Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: I/O error offlines a datafile
Gene, i thought you'd been around a while and know how Mladen works, geez. joe Gene Gurevich wrote: Mladen, Thank you very much for your suggestion. I tried exactly that - offline the tablespace and restore the datafile and - guess what? - it failed because of the lock being held against the datafile. That is what lead me (and the Oracle support guy) to bounce the database. Now I may be less than half way competent member of damanagement (whatever it means), but based on your advice you may be not much better. In the future if you can't refrain from isults, please do not reply to my posts. I'm asking for help and advice, not an insult. Gene --- Mladen Gogala [EMAIL PROTECTED] wrote: It's review time, so everything you do is wrong, as a cost saving measure. Any half way competent member of damagement can tell you that.In this particular case though, you could have recovered the datafile online. You should have offlined the tablespace, restored the datafile and recovered the datafile. Restarting the database was not not necessary. Also, one of my religious rituals is to perform a checkpoint after the tablespace has been successfully brought online. The reason is to record the new timestamp to the control file and make sure that all files have the same timestamp (checkpoint process updates file headers during checkpoint). On 12/08/2003 10:39:32 AM, Gene Gurevich wrote: Hi I got the following error in an alert.log file. Aparently it was a result of some UNIX issues on a hdisk, which have been resolved some time later .. Fri Dec 5 18:28:10 2003 KCF: write/open error block=0x3571 online=1 file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 16384' Automatic datafile offline due to write error on file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf The file in question had status = 'RECOVER in the v$datafile and status = 'AVAIALBLE' in dba_Data_files. I attempted to restore the file after taking it offline, but couldn't due to a lock. I ended up bouncing the database an recovering this file. I'm wondering whether I should have tired to recover this file first without bouncing the database. If anyone has any experience with that issue, could you let me know whether what I did was wrong or not (and why). Is there a document that I can read on this? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). __ Do you Yahoo!? Free Pop-Up Blocker - Get it now
RE: Alert Log
Regardless of whether or not it works, download it and the other tools like ntregmon, prcvire, and the almighty FileMonitor. No installs, no DLLs, no uninstall crap. Just extract and run the .exe. Excellent debugging tools. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 9:55 AM To: Multiple recipients of list ORACLE-L If nothing else helps, download procexp or filemon from www.sysinternals.com and see which files are open by oracle.exe Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 5:04 PM Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- - - background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- 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: I/O error offlines a datafile
There weren't any insults in Mladens post. Me thinks you're taking things a bit too seriously. Jared Gene Gurevich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 09:14 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: I/O error offlines a datafile Mladen, Thank you very much for your suggestion. I tried exactly that - offline the tablespace and restore the datafile and - guess what? - it failed because of the lock being held against the datafile. That is what lead me (and the Oracle support guy) to bounce the database. Now I may be less than half way competent member of damanagement (whatever it means), but based on your advice you may be not much better. In the future if you can't refrain from isults, please do not reply to my posts. I'm asking for help and advice, not an insult. Gene --- Mladen Gogala [EMAIL PROTECTED] wrote: It's review time, so everything you do is wrong, as a cost saving measure. Any half way competent member of damagement can tell you that.In this particular case though, you could have recovered the datafile online. You should have offlined the tablespace, restored the datafile and recovered the datafile. Restarting the database was not not necessary. Also, one of my religious rituals is to perform a checkpoint after the tablespace has been successfully brought online. The reason is to record the new timestamp to the control file and make sure that all files have the same timestamp (checkpoint process updates file headers during checkpoint). On 12/08/2003 10:39:32 AM, Gene Gurevich wrote: Hi I got the following error in an alert.log file. Aparently it was a result of some UNIX issues on a hdisk, which have been resolved some time later .. Fri Dec 5 18:28:10 2003 KCF: write/open error block=0x3571 > file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 16384' Automatic datafile offline due to write error on file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf The file in question had status = 'RECOVER in the v$datafile and status = 'AVAIALBLE' in dba_Data_files. I attempted to restore the file after taking it offline, but couldn't due to a lock. I ended up bouncing the database an recovering this file. I'm wondering whether I should have tired to recover this file first without bouncing the database. If anyone has any experience with that issue, could you let me know whether what I did was wrong or not (and why). Is there a document that I can read on this? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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
dc_used_extents ,dc_free_extents and dc_histogram_defs
Hi: I am reading some statspack reports from our 8173 DB (on Sun Solaris) and found some of Dictionary Cache Stats are pretty high (much higher than 2%). I notice that Pct Get Miss for dc_used_extents ,dc_free_extents and dc_histogram_defs are high (the second column data below). Is this something I need to pay attention in terms of doing performance optimization? If yes, what are the things (regarding Dictionary Cache) that I should look in order to improve the performance? TIA. Guang ps, here are some dc_ stats from my reports and a copy of actual report (partial): -- bash-2.03$ grep dc_used_extents sp_* sp_681_682.lst:dc_used_extents 136 83.10 136 3,840 100 sp_682_683.lst:dc_used_extents 124 81.50 124 3,918 99 sp_683_684.lst:dc_used_extents 34 58.80 34 3,924 100 sp_684_685.lst:dc_used_extents 0 0 0 3,924 100 sp_685_686.lst:dc_used_extents 37 64.90 37 3,935 99 sp_686_687.lst:dc_used_extents 12 100.00 12 3,947 100 sp_687_688.lst:dc_used_extents 18 100.00 18 3,965 100 sp_688_689.lst:dc_used_extents 26 100.00 26 3,991 100 sp_689_690.lst:dc_used_extents 14 100.00 14 4,005 100 sp_690_691.lst:dc_used_extents 16 100.00 16 4,021 100 sp_691_692.lst:dc_used_extents 29 100.00 29 4,050 100 sp_692_693.lst:dc_used_extents 1 100.00 1 4,051 99 sp_693_694.lst:dc_used_extents 1,118 51.20 1,118 4,077 100 sp_694_695.lst:dc_used_extents 1,294 99.80 1,294 5,365 100 sp_695_696.lst:dc_used_extents 2,031 13.20 2,031 3,870 72 sp_696_697.lst:dc_used_extents 1,195 98.50 1,195 5,029 94 sp_697_698.lst:dc_used_extents 44 100.00 44 5,073 94 sp_698_699.lst:dc_used_extents 0 0 0 5,073 94 sp_699_700.lst:dc_used_extents 1,3598.50 1,359568 33 bash-2.03$ grep dc_free_extents sp_* sp_681_682.lst:dc_free_extents 395 34.4 166 0.0 362 4,071 82 sp_682_683.lst:dc_free_extents 507 27.2 160 0.0 342 4,100 82 sp_683_684.lst:dc_free_extents 75 32.0 20 0.0 64 4,104 82 sp_684_685.lst:dc_free_extents 120.00 0 4,104 82 sp_685_686.lst:dc_free_extents 95 35.8 24 0.0 83 4,114 83 sp_686_687.lst:dc_free_extents 47 25.5 12 0.0 36 4,114 83 sp_687_688.lst:dc_free_extents 64 23.4 18 0.0 52 4,111 82 sp_688_689.lst:dc_free_extents 93 24.7 32 0.0 78 4,108 82 sp_689_690.lst:dc_free_extents 54 25.9 14 0.0 42 4,108 82 sp_690_691.lst:dc_free_extents 63 23.8 21 0.0 48 4,107 82 sp_691_692.lst:dc_free_extents 109 25.7 42 0.0 85 4,106 82 sp_692_693.lst:dc_free_extents 156.71 0.0 3 4,106 82 sp_693_694.lst:dc_free_extents 1,624 24.0 596 0.0 1,574 3,924 79 sp_694_695.lst:dc_free_extents 3,398 31.31,307 0.0 3,288 3,696 74 sp_695_696.lst:dc_free_extents 2,043 86.3 268 0.0 2,031 5,191 99 sp_696_697.lst:dc_free_extents 1,2091.71,177 0.0 1,197 4,034 77 sp_697_698.lst:dc_free_extents 550.0 44 0.0 44 3,990 76 sp_698_699.lst:dc_free_extents 120.00 0 3,990 79 sp_699_700.lst:dc_free_extents 1,384 90.4 115 0.0 1,371 1,564 94 bash-2.03$ grep dc_histogram_defs sp_* sp_681_682.lst:dc_histogram_defs49 79.60 25128 21 sp_682_683.lst:dc_histogram_defs47 29.80 0142 23 sp_683_684.lst:dc_histogram_defs 186 51.60 119238 39 sp_684_685.lst:dc_histogram_defs 1,756 91.30 1,699 1,841 100 sp_685_686.lst:dc_histogram_defs 2,1911.10 59 1,865 100 sp_686_687.lst:dc_histogram_defs 1440.00 0 1,865 100 sp_687_688.lst:dc_histogram_defs 8,3220.00 18 1,865 100 sp_688_689.lst:dc_histogram_defs 50.00 0 1,865 100 sp_689_690.lst:dc_histogram_defs130.00 0 1,865 100 sp_690_691.lst:dc_histogram_defs360.00 0 1,865 100 sp_691_692.lst:dc_histogram_defs 2121.40 70 1,868 100 sp_692_693.lst:dc_histogram_defs 5590.00 76 1,868 100 sp_693_694.lst:dc_histogram_defs 127,6820.3
Re: I/O error offlines a datafile
Actually, I haven't read too much of his posts. Based on the one he sent to me, I didn't miss much. Gene --- Joe Testa [EMAIL PROTECTED] wrote: Gene, i thought you'd been around a while and know how Mladen works, geez. joe Gene Gurevich wrote: Mladen, Thank you very much for your suggestion. I tried exactly that - offline the tablespace and restore the datafile and - guess what? - it failed because of the lock being held against the datafile. That is what lead me (and the Oracle support guy) to bounce the database. Now I may be less than half way competent member of damanagement (whatever it means), but based on your advice you may be not much better. In the future if you can't refrain from isults, please do not reply to my posts. I'm asking for help and advice, not an insult. Gene --- Mladen Gogala [EMAIL PROTECTED] wrote: It's review time, so everything you do is wrong, as a cost saving measure. Any half way competent member of damagement can tell you that.In this particular case though, you could have recovered the datafile online. You should have offlined the tablespace, restored the datafile and recovered the datafile. Restarting the database was not not necessary. Also, one of my religious rituals is to perform a checkpoint after the tablespace has been successfully brought online. The reason is to record the new timestamp to the control file and make sure that all files have the same timestamp (checkpoint process updates file headers during checkpoint). On 12/08/2003 10:39:32 AM, Gene Gurevich wrote: Hi I got the following error in an alert.log file. Aparently it was a result of some UNIX issues on a hdisk, which have been resolved some time later .. Fri Dec 5 18:28:10 2003 KCF: write/open error block=0x3571 online=1 file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 16384' Automatic datafile offline due to write error on file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf The file in question had status = 'RECOVER in the v$datafile and status = 'AVAIALBLE' in dba_Data_files. I attempted to restore the file after taking it offline, but couldn't due to a lock. I ended up bouncing the database an recovering this file. I'm wondering whether I should have tired to recover this file first without bouncing the database. If anyone has any experience with that issue, could you let me know whether what I did was wrong or not (and why). Is there a document that I can read on this? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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
Re: I/O error offlines a datafile
Stop complaining. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 7:59 PM Actually, I haven't read too much of his posts. Based on the one he sent to me, I didn't miss much. Gene --- Joe Testa [EMAIL PROTECTED] wrote: Gene, i thought you'd been around a while and know how Mladen works, geez. joe Gene Gurevich wrote: Mladen, Thank you very much for your suggestion. I tried exactly that - offline the tablespace and restore the datafile and - guess what? - it failed because of the lock being held against the datafile. That is what lead me (and the Oracle support guy) to bounce the database. Now I may be less than half way competent member of damanagement (whatever it means), but based on your advice you may be not much better. In the future if you can't refrain from isults, please do not reply to my posts. I'm asking for help and advice, not an insult. Gene --- Mladen Gogala [EMAIL PROTECTED] wrote: It's review time, so everything you do is wrong, as a cost saving measure. Any half way competent member of damagement can tell you that.In this particular case though, you could have recovered the datafile online. You should have offlined the tablespace, restored the datafile and recovered the datafile. Restarting the database was not not necessary. Also, one of my religious rituals is to perform a checkpoint after the tablespace has been successfully brought online. The reason is to record the new timestamp to the control file and make sure that all files have the same timestamp (checkpoint process updates file headers during checkpoint). On 12/08/2003 10:39:32 AM, Gene Gurevich wrote: Hi I got the following error in an alert.log file. Aparently it was a result of some UNIX issues on a hdisk, which have been resolved some time later .. Fri Dec 5 18:28:10 2003 KCF: write/open error block=0x3571 online=1 file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 16384' Automatic datafile offline due to write error on file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf The file in question had status = 'RECOVER in the v$datafile and status = 'AVAIALBLE' in dba_Data_files. I attempted to restore the file after taking it offline, but couldn't due to a lock. I ended up bouncing the database an recovering this file. I'm wondering whether I should have tired to recover this file first without bouncing the database. If anyone has any experience with that issue, could you let me know whether what I did was wrong or not (and why). Is there a document that I can read on this? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
Well, once upon a time, in a land far, far away, there was Oracle V6 with something called TPO, which was essentially row locking + PL/SQL V1 (no stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve Feuerstein and Howard Rogers know a thing or two about the Jurassic period in the database development. BTW, that was also when buffer hit ratio was invented. The entries that you see are remnants from oracle v6, together with the table called V$ROWCACHE and are both religiously maintained for the compatibility reasons, because Oracle Corp. doesn't want to disappoint all those who are still running V6. Even compatibility with V5 is still maintained. In Oracle 5.1.22, dictionary views weren't called user_tables and user_objects, they were called tab (user_tables) and cat (from CATALOG, replaced with USER_OBJECTS). The term CATALOG was directory command on Apple IIe (6502, later Z80) with 100k floppies, computer immensly popular at the time, and I believe that is why the first implementation of user_objects was called catalog. Now, let's fast forward to the present time and Oracle 9.2.0.4. Do Select * from tab and select * from cat. You'll be surprised. For all those still running V5.1.22 with forms 2.0 and 2.3, the world is not over yet. On 12/08/2003 12:39:30 PM, Guang Mei wrote: Hi: I am reading some statspack reports from our 8173 DB (on Sun Solaris) and found some of Dictionary Cache Stats are pretty high (much higher than 2%). I notice that Pct Get Miss for dc_used_extents ,dc_free_extents and dc_histogram_defs are high (the second column data below). Is this something I need to pay attention in terms of doing performance optimization? If yes, what are the things (regarding Dictionary Cache) that I should look in order to improve the performance? TIA. Guang ps, here are some dc_ stats from my reports and a copy of actual report (partial): -- bash-2.03$ grep dc_used_extents sp_* sp_681_682.lst:dc_used_extents 136 83.10 136 3,840 100 sp_682_683.lst:dc_used_extents 124 81.50 124 3,918 99 sp_683_684.lst:dc_used_extents 34 58.80 34 3,924 100 sp_684_685.lst:dc_used_extents 0 0 0 3,924 100 sp_685_686.lst:dc_used_extents 37 64.90 37 3,935 99 sp_686_687.lst:dc_used_extents 12 100.00 12 3,947 100 sp_687_688.lst:dc_used_extents 18 100.00 18 3,965 100 sp_688_689.lst:dc_used_extents 26 100.00 26 3,991 100 sp_689_690.lst:dc_used_extents 14 100.00 14 4,005 100 sp_690_691.lst:dc_used_extents 16 100.00 16 4,021 100 sp_691_692.lst:dc_used_extents 29 100.00 29 4,050 100 sp_692_693.lst:dc_used_extents 1 100.00 1 4,051 99 sp_693_694.lst:dc_used_extents 1,118 51.20 1,118 4,077 100 sp_694_695.lst:dc_used_extents 1,294 99.80 1,294 5,365 100 sp_695_696.lst:dc_used_extents 2,031 13.20 2,031 3,870 72 sp_696_697.lst:dc_used_extents 1,195 98.50 1,195 5,029 94 sp_697_698.lst:dc_used_extents 44 100.00 44 5,073 94 sp_698_699.lst:dc_used_extents 0 0 0 5,073 94 sp_699_700.lst:dc_used_extents 1,3598.50 1,359568 33 bash-2.03$ grep dc_free_extents sp_* sp_681_682.lst:dc_free_extents 395 34.4 166 0.0 362 4,071 82 sp_682_683.lst:dc_free_extents 507 27.2 160 0.0 342 4,100 82 sp_683_684.lst:dc_free_extents 75 32.0 20 0.0 64 4,104 82 sp_684_685.lst:dc_free_extents 120.00 0 4,104 82 sp_685_686.lst:dc_free_extents 95 35.8 24 0.0 83 4,114 83 sp_686_687.lst:dc_free_extents 47 25.5 12 0.0 36 4,114 83 sp_687_688.lst:dc_free_extents 64 23.4 18 0.0 52 4,111 82 sp_688_689.lst:dc_free_extents 93 24.7 32 0.0 78 4,108 82 sp_689_690.lst:dc_free_extents 54 25.9 14 0.0 42 4,108 82 sp_690_691.lst:dc_free_extents 63 23.8 21 0.0 48 4,107 82 sp_691_692.lst:dc_free_extents 109 25.7 42 0.0 85 4,106 82 sp_692_693.lst:dc_free_extents 156.71 0.0 3 4,106 82 sp_693_694.lst:dc_free_extents 1,624 24.0 596 0.0 1,574 3,924 79 sp_694_695.lst:dc_free_extents 3,398 31.31,307 0.0 3,288 3,696 74 sp_695_696.lst:dc_free_extents 2,043 86.3 268 0.0 2,031 5,191 99
Exclusive Password file, multiple databases
Title: Exclusive Password file, multiple databases Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of me figure out how to clue in my database. 9.2.0.2 on AIX 5l I am running multiple databases and am trying to get all of the instances running with remote_login_passwordfile=exclusive. Most of the databases are running fine, but one insists on looking for the default file name, despite my having provided filename=filename parameter to orapwd. I can't find anything that is supposed to clue it in in this circumstance, and recreating the password file doesn't really so any good either. Every time I try to start the database using the pfile, it complains about wanting the orapwd file... All of the other databases are happy enough with what I did. What am I doing wrong with this one... where do I start looking? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Re: PERL?
Can you install Oracle 9.2 on a playstation 2? On 12/08/2003 12:04:26 PM, Bobak, Mark wrote: It does. -Original Message- Sent: Monday, December 08, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Then PERL should also run on a TIVO box - it uses Linux. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:24 AM Well I might have disputed your almost dispute until I learned that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) OT: Anyone on the list ever run PlayStation on Linux? -Original Message- Cary Millsap Sent: Monday, December 08, 2003 9:00 AM To: Multiple recipients of list ORACLE-L The only thing I think I disagree with is the word almost. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium http://www.hotsos.com/events/symposium/2004 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Eric King Sent: Monday, December 08, 2003 6:39 AM To: Multiple recipients of list ORACLE-L Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: Exclusive Password file, multiple databases
Title: Exclusive Password file, multiple databases April, I just went thru this. Look in the sqlnet.ora file. If : Tom Mercadante Oracle Certified Professional -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Exclusive Password file, multiple databases Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of me figure out how to clue in my database. 9.2.0.2 on AIX 5l I am running multiple databases and am trying to get all of the instances running with remote_login_passwordfile=exclusive. Most of the databases are running fine, but one insists on looking for the default file name, despite my having provided filename=filename parameter to orapwd. I can't find anything that is supposed to clue it in in this circumstance, and recreating the password file doesn't really so any good either. Every time I try to start the database using the pfile, it complains about wanting the orapwd file... All of the other databases are happy enough with what I did. What am I doing wrong with this one... where do I start looking? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Exclusive Password file, multiple databases
Title: Exclusive Password file, multiple databases April, I just went thru this. Look in the sqlnet.ora file. If :SQLNET.AUTHENTICATION_SERVICES= (NTS)is set, comment it out. It was the cause of the problems on my machine. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Exclusive Password file, multiple databases Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of me figure out how to clue in my database. 9.2.0.2 on AIX 5l I am running multiple databases and am trying to get all of the instances running with remote_login_passwordfile=exclusive. Most of the databases are running fine, but one insists on looking for the default file name, despite my having provided filename=filename parameter to orapwd. I can't find anything that is supposed to clue it in in this circumstance, and recreating the password file doesn't really so any good either. Every time I try to start the database using the pfile, it complains about wanting the orapwd file... All of the other databases are happy enough with what I did. What am I doing wrong with this one... where do I start looking? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Exclusive Password file, multiple databases
Title: Exclusive Password file, multiple databases Our only sqlnet.ora file is the one in samples, and it is all comments... I don't think that's it... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 12:44 PMTo: '[EMAIL PROTECTED]'Cc: April WellsSubject: RE: Exclusive Password file, multiple databases April, I just went thru this. Look in the sqlnet.ora file. If :SQLNET.AUTHENTICATION_SERVICES= (NTS)is set, comment it out. It was the cause of the problems on my machine. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Exclusive Password file, multiple databases Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of me figure out how to clue in my database. 9.2.0.2 on AIX 5l I am running multiple databases and am trying to get all of the instances running with remote_login_passwordfile=exclusive. Most of the databases are running fine, but one insists on looking for the default file name, despite my having provided filename=filename parameter to orapwd. I can't find anything that is supposed to clue it in in this circumstance, and recreating the password file doesn't really so any good either. Every time I try to start the database using the pfile, it complains about wanting the orapwd file... All of the other databases are happy enough with what I did. What am I doing wrong with this one... where do I start looking? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
.. And there used to be all these dc_ parameters that one could set, giving the dba control over the dictionary cache, which was not a part of the shared pool. And then came Oracle V7, with the shared_pool_size, wresting that control. Regards Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ading.com cc: Sent by: Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs [EMAIL PROTECTED] ity.com 12/08/2003 01:29 PM Please respond to ORACLE-L Well, once upon a time, in a land far, far away, there was Oracle V6 with something called TPO, which was essentially row locking + PL/SQL V1 (no stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve Feuerstein and Howard Rogers know a thing or two about the Jurassic period in the database development. BTW, that was also when buffer hit ratio was invented. The entries that you see are remnants from oracle v6, together with the table called V$ROWCACHE and are both religiously maintained for the compatibility reasons, because Oracle Corp. doesn't want to disappoint all those who are still running V6. Even compatibility with V5 is still maintained. In Oracle 5.1.22, dictionary views weren't called user_tables and user_objects, they were called tab (user_tables) and cat (from CATALOG, replaced with USER_OBJECTS). The term CATALOG was directory command on Apple IIe (6502, later Z80) with 100k floppies, computer immensly popular at the time, and I believe that is why the first implementation of user_objects was called catalog. Now, let's fast forward to the present time and Oracle 9.2.0.4. Do Select * from tab and select * from cat. You'll be surprised. For all those still running V5.1.22 with forms 2.0 and 2.3, the world is not over yet. On 12/08/2003 12:39:30 PM, Guang Mei wrote: Hi: I am reading some statspack reports from our 8173 DB (on Sun Solaris) and found some of Dictionary Cache Stats are pretty high (much higher than 2%). I notice that Pct Get Miss for dc_used_extents ,dc_free_extents and dc_histogram_defs are high (the second column data below). Is this something I need to pay attention in terms of doing performance optimization? If yes, what are the things (regarding Dictionary Cache) that I should look in order to improve the performance? TIA. Guang ps, here are some dc_ stats from my reports and a copy of actual report (partial): -- bash-2.03$ grep dc_used_extents sp_* sp_681_682.lst:dc_used_extents 136 83.10 136 3,840 100 sp_682_683.lst:dc_used_extents 124 81.50 124 3,918 99 sp_683_684.lst:dc_used_extents 34 58.80 34 3,924 100 sp_684_685.lst:dc_used_extents 0 0 0 3,924 100 sp_685_686.lst:dc_used_extents 37 64.90 37 3,935 99 sp_686_687.lst:dc_used_extents 12 100.00 12 3,947 100 sp_687_688.lst:dc_used_extents 18 100.00 18 3,965 100 sp_688_689.lst:dc_used_extents 26 100.00 26 3,991 100 sp_689_690.lst:dc_used_extents 14 100.00 14 4,005 100 sp_690_691.lst:dc_used_extents 16 100.00 16 4,021 100 sp_691_692.lst:dc_used_extents 29 100.00 29 4,050 100 sp_692_693.lst:dc_used_extents 1 100.00 1 4,051 99
RE: RMAN restore on another server
why not use the RMAN duplicate database process. that sounds like what you are trying to do. Have you ever let the script run to completion? Maybe its slow for another reason. I have used duplicate database on Solaris many times with great success. Josh -Original Message- Sent: Monday, December 08, 2003 8:20 AM To: Multiple recipients of list ORACLE-L Dennis and all, I have no problem getting the controlfile... I just comment out the SET commands to change the directories of the dbfs...and I replicate the control according to the init file specifications.. So This operation actually extract the controlfile out of the backup piece so I know the location and connections are working fine. But since the controlfile is backup and I am restoring it with the same RMan command I think I should have no problem.. I know other DBAs.. run this same script and restore the database on another server with no problem if the controlfile is restored before the database is restored and recovered. Here is the restore controlfile script and resulting log file == Controlfile restore Script == connect catalog rman81740/[EMAIL PROTECTED] connect target / run { allocate channel d1 type disk ; sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; set until time = '2003-12-02 05:50:00'; #restore controlfile to '/u02/vssppln/restored_cf.ctl'; replicate controlfile from '/u02/vssppln/restored_cf.ctl'; release channel d1; } == Successful Controlfile restore log == Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 run 7 8 { 9 10 allocate channel d1 type disk ; 11 12 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 13 set until time = '2003-12-02 05:50:00'; 14 15 16 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 17 18 replicate controlfile from '/u02/vssppln/restored_cf.ctl'; 19 20 release channel d1; 21 } 22 23 RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target database: vssppln (not mounted) RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS RMAN-03023: executing command: sql RMAN-03022: compiling command: set RMAN-03022: compiling command: replicate RMAN-03023: executing command: replicate RMAN-08058: replicating controlfile RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1 Recovery Manager complete. = Here is the orignal entire script to restore controlfile and database but it just hangs on the set commands.. = == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't plan on migrating to 10g until I learn it well and if some oracle sales guy tries to exert pressure on me to migrate, he will get a very stable sign used by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill of white papers and articles and now I want to see the software. On 12/08/2003 02:24:33 PM, [EMAIL PROTECTED] wrote: .. And there used to be all these dc_ parameters that one could set, giving the dba control over the dictionary cache, which was not a part of the shared pool. And then came Oracle V7, with the shared_pool_size, wresting that control. Regards Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ading.com cc: Sent by: Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs [EMAIL PROTECTED] ity.com 12/08/2003 01:29 PM Please respond to ORACLE-L Well, once upon a time, in a land far, far away, there was Oracle V6 with something called TPO, which was essentially row locking + PL/SQL V1 (no stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve Feuerstein and Howard Rogers know a thing or two about the Jurassic period in the database development. BTW, that was also when buffer hit ratio was invented. The entries that you see are remnants from oracle v6, together with the table called V$ROWCACHE and are both religiously maintained for the compatibility reasons, because Oracle Corp. doesn't want to disappoint all those who are still running V6. Even compatibility with V5 is still maintained. In Oracle 5.1.22, dictionary views weren't called user_tables and user_objects, they were called tab (user_tables) and cat (from CATALOG, replaced with USER_OBJECTS). The term CATALOG was directory command on Apple IIe (6502, later Z80) with 100k floppies, computer immensly popular at the time, and I believe that is why the first implementation of user_objects was called catalog. Now, let's fast forward to the present time and Oracle 9.2.0.4. Do Select * from tab and select * from cat. You'll be surprised. For all those still running V5.1.22 with forms 2.0 and 2.3, the world is not over yet. On 12/08/2003 12:39:30 PM, Guang Mei wrote: Hi: I am reading some statspack reports from our 8173 DB (on Sun Solaris) and found some of Dictionary Cache Stats are pretty high (much higher than 2%). I notice that Pct Get Miss for dc_used_extents ,dc_free_extents and dc_histogram_defs are high (the second column data below). Is this something I need to pay attention in terms of doing performance optimization? If yes, what are the things (regarding Dictionary Cache) that I should look in order to improve the performance? TIA. Guang ps, here are some dc_ stats from my reports and a copy of actual report (partial): -- bash-2.03$ grep dc_used_extents sp_* sp_681_682.lst:dc_used_extents 136 83.10 136 3,840 100 sp_682_683.lst:dc_used_extents 124 81.50 124 3,918 99 sp_683_684.lst:dc_used_extents
RE: PERL?
One BIG advantage of Perl is DBI. Via shell you can't use bind variables which sometimes come in handy. An admin dweeb here developed a monitoring shell script that executed 5500 queries an hour each using literals instead of bind variables resulting in shared pool fragmentation and server errors. When the same monitoring was rewritten in Python the load on the server was dramatically reduced. (It could have been done in Perl with the same result.) The usage of literals could have been avoided with PL/SQL but there was also a need for significant file reads, file writes and email so using shell and PL/SQL was cumbersome at best. (Besides, the admin dweeb didn't know PL/SQL.) Another plus is that your oft used routines can be portable between Windoze and *nix. I guess the point is this: Many times you need greater programming power than afforded by shell scripting. If you can easily and productively perform everything that you can do in shell scripting with a complete programming language like Perl or Python then you're one step ahead of the game. Otherwise you may be lamenting limitations. So the remaining challenge is merely learning a programming language that works for you. Steve Orr Bozeman, Montana -Original Message- [EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:14 AM To: Multiple recipients of list ORACLE-L The difference that has affected me the most in writing utility scripts is that PERL can talk to the database like using a telephone. Ksh must talk like using a walkie-talkie; that is, each side of the conversation must talk then release the push-to-talk (PTT) button before the other side can talk. Using a small amount of cleverness (which is good, because that's about how much I have) in ksh, you can program around most of the communication limitations. For example, to deal with sqlplus getting stuck for one reason or the other, you can run the subsection of the script in the background (as a ksh job). Then you check on the job later in the script. If the job is still there longer than it should be, the script can kill the job. THEN, for good measure, look for sqlplus (and possible another ksh that got forked by the script) with parent process ID (PPID) of me and kill them. This is similar to the other side failing to release the PTT button. Unlike PERL, which can maybe yell into to telephone to wake the other side up, ksh must launch an artillery shell onto the other guy which, in a rather violent manner, will cause him to release the PTT button (well ... actually .. the PTT switch kind of got blown up too). Then, depending on the situation, retry the sqlplus or conclude that something is wrong. That being said, ksh is so easy to use and so handy, that I still use it for automating database management and monitoring. I'm sure a big part of that is because I learned shell, sed, awk, etc. programming before perl was standard equipment on Unix boxes. I suppose if you are starting from the beginning, then the way to go would be perl. But you can still do a heck of a lot with ksh (the REAL ksh; not the POS public domain ksh that tends to show up with linux). For an excellent book on getting started with this, go to Amazon and search on Mark G. Sobell (or just Sobell). Here's a tinyurl link to what I think is still must-have book. Even though a lot of it is outdated, the sections on getting around in Unix and shell scripting are still entirely relevant. http://tinyurl.com/y8x6 (Note that the used book sellers are just about giving away the book) There is also a BSD version of the above book. And you want to get O'Reilly's book on Sed and Awk. Those should get you going down the wonderful world of shell scripting .. which is the ORIGINAL, and still great, Rapid Application Development. -Original Message- I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. -- 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: 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
RE: PERL?
Don't know why not. Using the here document anything you can type in on the sqlplus command line can be entered with ksh ... including the defining of bind variables. -Original Message- Via shell you can't use bind variables which sometimes come in handy. -- 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: PERL?
#!/usr/bin/ksh sqlplus -s -XXX joecool/jomama var xyz char(50) var abc char(50) begin :xyz := 'HELLO WORLD'; select :xyz into :abc from dual; end; / print abc XXX -- 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).
Oracle, GPG, PGP, Java...
Hi folks, I'm looking for some kind of library or such that would allow me to decrypt PGP/GnuPG encrypted content from SQL. Something allowing me to do something like this: SELECT decrypt([private key passed in from application code], field) from ... The current solution we have (in Perl) is something like this: - Select out the encrypted value - Exec() the gpg command-line utility, supplying the private key - Do something with the decrypoted data. We use the GnuPG.pm module, which is really just a wrapper around an exec() (yuk). I'd like to be able to eliminate all the exec madness, and use something a little closer to the database. I was glancing at Chapter 22 in Feuerstein's Oracle PL/SQL Programming (3rd. ed.), and thought it might not be too hard to find an existing Java library that can manage the decryption, and call the Java library from PL/SQL, as discussed in that chapter. Has anybody else done anything like this? Any Java libraries that can manage PGP decryption? I found one here: http://www.cryptix.org/products/openpgp/index.html#download but wanted to ask the list's opinion to see if there was anything else out there. I would assume I could also call native C libraries from PL/SQL via some voodoo which I haven't explored yet, and if needed would be open to something like that as well, but though Java might be a gentler path to start with. Thanks for any help, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
Though there has been an average increase in the total number of init parameter of 83% from versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38% in 7.3.4, to 31%/69% in 9.2.0.4. version undoc tunable total %undoc %tunable - 7.3.4 97 158 255 3862 8.1.7.4300 204 504 6040 9.2.0.4587 258 845 6931 To achieve the stated goal of 100 tunable parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number of parameters, 10g should look somthing like this: version undoc tunable total %undoc %tunable - 10.0.0 999 100 1099 91 9 ;) Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 11:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: dc_used_extents ,dc_free_extents and dc_histogram_defs Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't plan on migrating to 10g until I learn it well and if some oracle sales guy tries to exert pressure on me to migrate, he will get a very stable sign used by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill of white papers and articles and now I want to see the software.
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
somebody has free time on his hands. Jared, what's your bosses email addy? Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 3:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defsThough there has been an average increase in the total number of init parameter of 83% from versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38% in 7.3.4, to 31%/69% in 9.2.0.4. version undoc tunable total %undoc %tunable - 7.3.4 97 158 255 38 62 8.1.7.4 300 204 504 6040 9.2.0.4587 258 845 6931 To achieve the stated goal of 100 tunable parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number of parameters, 10g should look somthing like this: version undoc tunable total %undoc %tunable - 10.0.0 999 100 1099 91 9 ;) Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: dc_used_extents ,dc_free_extents and dc_histogram_defsLarry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g.As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't planon migrating to 10g until I learn it well and if some oracle sales guytries to exert pressure on me to migrate, he will get a very stable signused by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill ofwhite papers and articles and now I want to see the software.
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
Title: Message So I believe your unstated point is that the only thing that needs to be reduced is Mr. E's marketing hype. ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defsThough there has been an average increase in the total number of init parameter of 83% from versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38% in 7.3.4, to 31%/69% in 9.2.0.4. version undoc tunable total %undoc %tunable - 7.3.4 97 158 255 38 62 8.1.7.4 300 204 504 6040 9.2.0.4587 258 845 6931 To achieve the stated goal of 100 tunable parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number of parameters, 10g should look somthing like this: version undoc tunable total %undoc %tunable - 10.0.0 999 100 1099 91 9 ;) Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: dc_used_extents ,dc_free_extents and dc_histogram_defsLarry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g.As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't planon migrating to 10g until I learn it well and if some oracle sales guytries to exert pressure on me to migrate, he will get a very stable signused by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill ofwhite papers and articles and now I want to see the software.
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
10g has about 30 "basic" parameters such are db_name andsga_target, a real bunch of "advanced" parameters and the rest are undocumented parameters. So, the marketing people can already say you got less than 100 tunable params.. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, December 08, 2003 10:59 PM Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs Though there has been an average increase in the total number of init parameter of 83% from versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38% in 7.3.4, to 31%/69% in 9.2.0.4. version undoc tunable total %undoc %tunable - 7.3.4 97 158 255 38 62 8.1.7.4 300 204 504 6040 9.2.0.4587 258 845 6931 To achieve the stated goal of 100 tunable parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number of parameters, 10g should look somthing like this: version undoc tunable total %undoc %tunable - 10.0.0 999 100 1099 91 9 ;) Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: dc_used_extents ,dc_free_extents and dc_histogram_defsLarry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g.As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't planon migrating to 10g until I learn it well and if some oracle sales guytries to exert pressure on me to migrate, he will get a very stable signused by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill ofwhite papers and articles and now I want to see the software.
A brief detour....;-)
So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has over 100 different implementations of the Towers of Hanoi solution, each in a different language. Since he didn't have one in PL/SQL, I decided to write one. Here it is: create or replace package hanoi is from_peg constant number := 1; to_pegconstant number := 3; using_peg constant number := 2; procedure play(n number); end hanoi; / create or replace package body hanoi is procedure do_hanoi(n number, from_peg number, to_peg number, using_peg number) is begin if(n 0) then do_hanoi(n-1,from_peg, using_peg, to_peg); dbms_output.put_line('move '||from_peg||' -- '||to_peg); do_hanoi(n-1, using_peg, to_peg, from_peg); end if; end; procedure play(n number) is begin do_hanoi(n, from_peg, to_peg, using_peg); end; end; / This concludes this public service announcement. We now return you to our regularly scheduled programming. -Mark PS Yes, it's a slow day;-) -- 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: Oracle Data Guard
Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database management techniques and frameworks
No Bambi, No, no, no... This is not what damagement wants. They don't want you to develop your own tools and scripts so they are dependent on you. They want to spent lots of money on a GUI tool they can see and they want a sales drone to show them how easy it is and tell them that anybody can be a DBA if they just had this GUI tool. That way, if they don't like you they can get rid of you and just pluggin another warm body. Sort of like handing a hammer to an unskilled laborer and saying, Here, you are now a master carpenter. By all means stop using that geek stuff like Perl. Stop being subversive to the system by developing your own stuff and use the GUI wizbang tool that damagement likes. -Original Message- Bellow, Bambi Sent: Friday, December 05, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make sure it runs ok, then shuts itself down. (note to the Oracle-L historians who might be curious, this change in my utilization is largely why my posts from 10 years ago were a lot more DBMS/internals heavy and my posts nowadays are more OS/script heavy.) Regardless, I hope this answers your question and shows some of the complexity of what you're asking for... Bambi. -Original Message- Sent: Friday, December 05, 2003 1:44 PM To: Multiple recipients of list ORACLE-L So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or do you install these scripts on each database server? Do you leverage dbms_jobs? And relying on email seems kind of iffy -- what happens if you're not around to check your email? Page system? Escalation matrix in place? Not trying to ruffle any feathers here, and certainly, I appreciate the time requirements in fully answering a question as broad as the one I submitted, but I would like to probe further into various strategies. The whole run scripts to check, install statspack, etc. approach seems both highly unscalable and leaves much to the whim of the individual DBA. So what, you've installed statspack? Do you use it regularly? Is this a manual review, or is some system in
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
a) not really, in fact, far less than usual. going to be *loonnngg* day. Just needed a diversion. b) I'm not telling Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 01:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dc_used_extents ,dc_free_extents and dc_histogram_defs somebody has free time on his hands. Jared, what's your bosses email addy? Tom Mercadante Oracle Certified Professional -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs Though there has been an average increase in the total number of init parameter of 83% from versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38% in 7.3.4, to 31%/69% in 9.2.0.4. version undoc tunable total %undoc %tunable - 7.3.4 97 158 255 3862 8.1.7.4300 204 504 6040 9.2.0.4587 258 845 6931 To achieve the stated goal of 100 tunable parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number of parameters, 10g should look somthing like this: version undoc tunable total %undoc %tunable - 10.0.0 999 100 1099 91 9 ;) Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 11:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: dc_used_extents ,dc_free_extents and dc_histogram_defs Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't plan on migrating to 10g until I learn it well and if some oracle sales guy tries to exert pressure on me to migrate, he will get a very stable sign used by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill of white papers and articles and now I want to see the software.
RE: Oracle Data Guard
Hi, Tanel, enabling jumbo frames and SDU size if using Gbit ethernet, can you elaborate on this? -Original Message- Sent: Monday, December 08, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rebuilding indexes - sure to cause a ruckus
Ouch, I gotta take a day off to read this one ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:29 PM Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): a.. There are no such things as star indexes. Star joins, yes, star transformations yes, but not star indexes ? b.. I still disagree with your description of b-tree indexes being complex and difficult to understand, but then again this could just be my personal perception (check out http://groups.google.com/groups?q=g:thl3498916429ddq=hl=enlr=ie=UTF-8se lm=ant%259.39604%24jM5.100537%40newsfeeds.bigpond.comrnum=47 where I have a sample demo on how to investigate the workings of b-tree indexes.) However, by understanding them and a how they function, the question of whether or not they need rebuilding no longer needs to be debated. It becomes easily apparent under what conditions indexes could benefit from a rebuild. I'll expand on this later but I would suggest those that debate, those that really don't know when a rebuild is justified and just rebuild in the hope it might do some good are those that really don't understand how indexes function. Knowledge is the key that unlocks the door of doubt and those without the key fumble aimlessly and prod around in hope... c.. Your subsequent quote There is enough anecdotal evidence that index rebuilding has helped some systems perform better, and I also have no doubt that there is no scientific basis for the claim is a nonsense. Of course one explain in scientific terms such performance improvements, I can only suggest that you unfortunately can't. Oracle is not some magic piece of software and it doesn't run on some magical pieces of hardware. Any suggestions to the contrary are not helpful to anyone. d.. I still disagree with the double the block size, halving the logical reads must be a good thing argument. It's a path that could lead to a very disappointing conclusion (read cliff edge). Indexes prefer large block sizes true but if the underlining storage file-system is not tuned to read (or write) these larger block sizes efficiently, then the whole thing is counter productive. You've been warned ... e.. Your description of PCTUSED is still wrong. There is no PCTUSED for indexes so it really shouldn't be misleading to confuse a non-existing index attribute with the amount of used space as documented in INDEX_STATS... f.. Including in your criteria for rebuilding an index btree_space being greater than a block is redundant when listed with the other criteria. It is fundamentally impossible for an index with 4 levels or more to consist of a single block, so why mention it. It just adds confusion and is silly. The DBA who swears by this criteria (which I noticed has changed in this draft ;), how do they make such a claim? It's one thing to swear, it's quite another to prove. Your table that lists average rows and blocks per different index levels shows that those indexes with a leaf row length of 500,000,000 and with 100,000 blocks require 4 levels. How does rebuilding such indexes with no subsequent change in index level improve performance ? I mean, large indexes need more levels right, so rebuilding them all the time and keeping the levels unchanged only to rebuild them again because they're still 4 or more levels seems like a pointless, never-ending exercise in futility. To rebuild an index that actually results in a reduction in it's level generally requires a drastic reduction in it's data volume due to the orders of sizing magnitude that a new level represents. More on this and the other so-called rebuild criteria later but the current level of an index is not a criteria for a rebuild. A level 3 index could conceivably be rebuilt to just a level 1 (if there were heaps and heaps of deletions) and a level 5 index could be rebuilt to stay at level 5. Which index has benefited . g.. Criteria for a rebuild: or the total length of deleted is 1 block makes no sense whatsoever. Nearly all indexes would have a total length of deleted than 1 block meaning nearly all indexes need rebuilding. I don't think so ... h.. Your discussion on the clustering factor affecting the likelihood of requiring an index rebuild is still flawed, however interestingly, you've now given an example on why this is the case. However, you've still come to the wrong conclusion !! Firstly, you're incorrect in your example to say that a 1,000,000 row table with a clustering factor of 1,000,000 has it's rows in the same order as it's index although I guess this could be a typo. Regardless, if you delete all last_name beginning with a K, you are going to delete consecutive leaf nodes
Who is querying database info using dblink
How do I check who is querying database information via database link? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database management techniques and frameworks
Here, of course, you're assuming that such a magical GUI, sort of DBA in an ancient oil lamp, tools exist. Well, they do not. Even if you have some useful gooey tools, they do require extensive configuration and customization to become useful and they do require extensive knowledge from the person doing configuration and customization. Other then that, I find it quite questionable how useful it is to fire your own customers and replace them with cheap Elbonian labor. Anyone who has called Oracle support recently knows exactly what I'm talking about. On 12/08/2003 04:44:31 PM, Orr, Steve wrote: No Bambi, No, no, no... This is not what damagement wants. They don't want you to develop your own tools and scripts so they are dependent on you. They want to spent lots of money on a GUI tool they can see and they want a sales drone to show them how easy it is and tell them that anybody can be a DBA if they just had this GUI tool. That way, if they don't like you they can get rid of you and just pluggin another warm body. Sort of like handing a hammer to an unskilled laborer and saying, Here, you are now a master carpenter. By all means stop using that geek stuff like Perl. Stop being subversive to the system by developing your own stuff and use the GUI wizbang tool that damagement likes. -Original Message- Bellow, Bambi Sent: Friday, December 05, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make sure it runs ok, then shuts itself down. (note to the Oracle-L historians who might be curious, this change in my utilization is largely why my posts from 10 years ago were a lot more DBMS/internals heavy and my posts nowadays are more OS/script heavy.) Regardless, I hope this answers your question and shows some of the complexity of what you're asking for... Bambi. -Original Message- Sent: Friday, December 05, 2003 1:44 PM To: Multiple recipients of list ORACLE-L So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or
RE: Database management techniques and frameworks
Ah, Steve, thanks for clarifying. It all becomes clear. Here... 42! HTH, Bambi. -Original Message- Sent: Monday, December 08, 2003 3:45 PM To: Multiple recipients of list ORACLE-L No Bambi, No, no, no... This is not what damagement wants. They don't want you to develop your own tools and scripts so they are dependent on you. They want to spent lots of money on a GUI tool they can see and they want a sales drone to show them how easy it is and tell them that anybody can be a DBA if they just had this GUI tool. That way, if they don't like you they can get rid of you and just pluggin another warm body. Sort of like handing a hammer to an unskilled laborer and saying, Here, you are now a master carpenter. By all means stop using that geek stuff like Perl. Stop being subversive to the system by developing your own stuff and use the GUI wizbang tool that damagement likes. -Original Message- Bellow, Bambi Sent: Friday, December 05, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make sure it runs ok, then shuts itself down. (note to the Oracle-L historians who might be curious, this change in my utilization is largely why my posts from 10 years ago were a lot more DBMS/internals heavy and my posts nowadays are more OS/script heavy.) Regardless, I hope this answers your question and shows some of the complexity of what you're asking for... Bambi. -Original Message- Sent: Friday, December 05, 2003 1:44 PM To: Multiple recipients of list ORACLE-L So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or do you install these scripts on each database server? Do you leverage dbms_jobs? And relying on email seems kind of iffy -- what happens if you're not around to check your email? Page system? Escalation matrix in place? Not trying to ruffle any feathers here, and certainly, I appreciate the time requirements in fully answering a question as broad as the one I submitted, but I would like to probe further into various strategies. The whole run scripts to check, install statspack, etc.
Re: rebuilding indexes - sure to cause a ruckus
Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): a.. There are no such things as star indexes. Star joins, yes, star transformations yes, but not star indexes ? b.. I still disagree with your description of b-tree indexes being complex and difficult to understand, but then again this could just be my personal perception (check out http://groups.google.com/groups?q=g:thl3498916429ddq=hl=enlr=ie=UTF-8se lm=ant%259.39604%24jM5.100537%40newsfeeds.bigpond.comrnum=47 where I have a sample demo on how to investigate the workings of b-tree indexes.) However, by understanding them and a how they function, the question of whether or not they need rebuilding no longer needs to be debated. It becomes easily apparent under what conditions indexes could benefit from a rebuild. I'll expand on this later but I would suggest those that debate, those that really don't know when a rebuild is justified and just rebuild in the hope it might do some good are those that really don't understand how indexes function. Knowledge is the key that unlocks the door of doubt and those without the key fumble aimlessly and prod around in hope... c.. Your subsequent quote There is enough anecdotal evidence that index rebuilding has helped some systems perform better, and I also have no doubt that there is no scientific basis for the claim is a nonsense. Of course one explain in scientific terms such performance improvements, I can only suggest that you unfortunately can't. Oracle is not some magic piece of software and it doesn't run on some magical pieces of hardware. Any suggestions to the contrary are not helpful to anyone. d.. I still disagree with the double the block size, halving the logical reads must be a good thing argument. It's a path that could lead to a very disappointing conclusion (read cliff edge). Indexes prefer large block sizes true but if the underlining storage file-system is not tuned to read (or write) these larger block sizes efficiently, then the whole thing is counter productive. You've been warned ... e.. Your description of PCTUSED is still wrong. There is no PCTUSED for indexes so it really shouldn't be misleading to confuse a non-existing index attribute with the amount of used space as documented in INDEX_STATS... f.. Including in your criteria for rebuilding an index btree_space being greater than a block is redundant when listed with the other criteria. It is fundamentally impossible for an index with 4 levels or more to consist of a single block, so why mention it. It just adds confusion and is silly. The DBA who swears by this criteria (which I noticed has changed in this draft ;), how do they make such a claim? It's one thing to swear, it's quite another to prove. Your table that lists average rows and blocks per different index levels shows that those indexes with a leaf row length of 500,000,000 and with 100,000 blocks require 4 levels. How does rebuilding such indexes with no subsequent change in index level improve performance ? I mean, large indexes need more levels right, so rebuilding them all the time and keeping the levels unchanged only to rebuild them again because they're still 4 or more levels seems like a pointless, never-ending exercise in futility. To rebuild an index that actually results in a reduction in it's level generally requires a drastic reduction in it's data volume due to the orders of sizing magnitude that a new level represents. More on this and the other so-called rebuild criteria later but the current level of an index is not a criteria for a rebuild. A level 3 index could conceivably be rebuilt to just a level 1 (if there were heaps and heaps of deletions) and a level 5 index could be rebuilt to stay at level 5. Which index has benefited . g.. Criteria for a rebuild: or the total length of deleted is 1 block makes no sense whatsoever. Nearly all indexes would have a total length of deleted than 1 block meaning nearly all indexes need rebuilding. I don't think so ... h.. Your discussion on the clustering factor affecting the likelihood of requiring an index rebuild is still flawed, however interestingly, you've now given an example on why this is the case. However, you've still come to the wrong conclusion !! Firstly, you're incorrect in your example to say that a 1,000,000 row table with a clustering factor of 1,000,000 has it's rows in the same order as it's index although I guess this could be a typo. Regardless, if you delete all last_name beginning with a K, you are going to delete consecutive leaf nodes regardless of the clustering factor. So what difference does it make to the index. None. To the table, yes, you either delete rows from all differing blocks or rows from a small number of blocks but to the index, it makes no difference, hence your claim makes no
Re: Oracle Data Guard
Hi Vijay, I've done around 20 DG installations at different sites, using Linux, Solaris, AIX and W2K. High speed network isn't always what you need, low latency might be more important. I've set up a DG environment between Kuala Lumpur and Rotterdam, using a 128KB line. This wasn't for standby reasins, but was about database consolidation. As long as the daily Archive Log could be done, everything was OK. For maximum availability/protection mode you get synchronous writes. Latency counts very much. See also DocId 233650.1 on Metalink, Titled 9i Data Guard Complete Reference. It actually contains a list of interesting Data Guard publications on metalink. Force logging mode is required for Logical Standby. I agree with Tanel, LSB isn't for production yet. However, in some situations it might be usefull for a reporting database, as long as you do not rely on the standby part. Create a PSB for that purpose. On one site, with a long distance PSB ( 100 km between datacenters), with requirements about Zero Data Loss, I advised to setup a PSB/maximum availabilty mode locally, and a remote PSB in max. performance mode. This minimizes the chance of data loss, and affects performance as little as possible. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- At 07:19 8-12-03 -0800, you wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
Well, you could have joined the beta program if you were THAT interested, Mladen! Ducks and runs. :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 6:59 AM To: Multiple recipients of list ORACLE-L Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't plan on migrating to 10g until I learn it well and if some oracle sales guy tries to exert pressure on me to migrate, he will get a very stable sign used by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill of white papers and articles and now I want to see the software. On 12/08/2003 02:24:33 PM, [EMAIL PROTECTED] wrote: .. And there used to be all these dc_ parameters that one could set, giving the dba control over the dictionary cache, which was not a part of the shared pool. And then came Oracle V7, with the shared_pool_size, wresting that control. Regards Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ading.com cc: Sent by: Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs [EMAIL PROTECTED] ity.com 12/08/2003 01:29 PM Please respond to ORACLE-L Well, once upon a time, in a land far, far away, there was Oracle V6 with something called TPO, which was essentially row locking + PL/SQL V1 (no stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve Feuerstein and Howard Rogers know a thing or two about the Jurassic period in the database development. BTW, that was also when buffer hit ratio was invented. The entries that you see are remnants from oracle v6, together with the table called V$ROWCACHE and are both religiously maintained for the compatibility reasons, because Oracle Corp. doesn't want to disappoint all those who are still running V6. Even compatibility with V5 is still maintained. In Oracle 5.1.22, dictionary views weren't called user_tables and user_objects, they were called tab (user_tables) and cat (from CATALOG, replaced with USER_OBJECTS). The term CATALOG was directory command on Apple IIe (6502, later Z80) with 100k floppies, computer immensly popular at the time, and I believe that is why the first implementation of user_objects was called catalog. Now, let's fast forward to the present time and Oracle 9.2.0.4. Do Select * from tab and select * from cat. You'll be surprised. For all those still running V5.1.22 with forms 2.0 and 2.3, the world is not over yet. On 12/08/2003 12:39:30 PM, Guang Mei wrote: Hi: I am reading some statspack reports from our 8173 DB (on Sun Solaris) and found some of Dictionary Cache Stats are pretty high (much higher than 2%). I notice that Pct Get Miss for dc_used_extents ,dc_free_extents and dc_histogram_defs are high (the second column data below). Is this something I need to pay attention in terms of doing performance optimization? If yes, what are the things (regarding Dictionary Cache) that I should look in order to improve the performance? TIA. Guang ps, here are some dc_ stats from my reports and a copy of actual report (partial): -- bash-2.03$ grep dc_used_extents sp_* sp_681_682.lst:dc_used_extents 136 83.10 136 3,840 100 sp_682_683.lst:dc_used_extents 124 81.50 124 3,918 99 sp_683_684.lst:dc_used_extents 34 58.80 34 3,924 100 sp_684_685.lst:dc_used_extents 0 0 0 3,924 100 sp_685_686.lst:dc_used_extents 37 64.90 37 3,935 99 sp_686_687.lst:dc_used_extents 12 100.00 12 3,947 100 sp_687_688.lst:dc_used_extents 18 100.00 18 3,965 100 sp_688_689.lst:dc_used_extents 26 100.00 26 3,991 100 sp_689_690.lst:dc_used_extents 14 100.00 14 4,005 100 sp_690_691.lst:dc_used_extents 16 100.00 16 4,021 100 sp_691_692.lst:dc_used_extents 29 100.00 29 4,050 100 sp_692_693.lst:dc_used_extents 1 100.00 1 4,051 99 sp_693_694.lst:dc_used_extents
RE: Who is querying database info using dblink
Try this: Select /*+ ORDERED */ substr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10) ORIGIN, substr(g.K2GTITID_ORA,1,35) GTXID, substr(s.indx,1,4)||'.'|| substr(s.ksuseser,1,5) LSESSION , substr(decode(bitand(ksuseidl,11),1,'ACTIVE',0, decode(bitand(ksuseflg,4096),0,'INACTIVE','CACHED'), 2,'SNIPED',3,'SNIPED', 'KILLED'),1,1) S, substr(event,1,10) WAITING from x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w where g.K2GTDXCB =t.ktcxbxba and g.K2GTDSES=t.ktcxbses and s.addr=g.K2GTDSES and w.sid=s.indx ; -Original Message- Sent: Monday, December 08, 2003 5:04 PM To: Multiple recipients of list ORACLE-L How do I check who is querying database information via database link? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: PERL?
If the rest works, the JDBC thin client oughtta work, too. I wonder if anyone's bothered for some unholy reason to try Oracle server in WineX... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Can you install Oracle 9.2 on a playstation 2? -- 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: rebuilding indexes - sure to cause a ruckus
Tanel Poder wrote: Ouch, I gotta take a day off to read this one ;) http://www.netmeister.org/news/learn2quote.html It's all about optimization... -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Data Guard
Comments inline At 13:34 8-12-03 -0800, you wrote: Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. It all depends on the amount of redolog you generate. When that's pretty much, you waste some resources by transporting online/archived redologs you actually don't need. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). So, they don't like nologging operations like truncate, not even on the standby database? The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. LSB might work, but do not consider the option of failing over to it. Be aware that, altough in maximum protection mode your redolog arrives at the SB system within the transaction, it doesn't get applied there instantly. SQL Application takes place _after_ the log-switch on the Primary. When you take 10 minutes of redolog, and perform a logswitch, the SQL Apply process might even take longer than 10 minutes to complete processing of the redologfile. There is a risk that not every transaction arrives within 20 minutes at the LSB. So, your log-switching frequency and the amount of redo you generate per unit of time both play a major role in the refresh rate of the LSB. I'll send you the PDF of a DG Special I did in Kista a few months ago. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: migrate 8.1.7 to 9.2.0
Guys, I am working through a manual migration from 8i to 9i on Solaris 2.8. I am using the guide in Note: 159657.1. I shutdown the 8.1.7 database, copied network and init files - then run sqlplus / as sysdba or sqlplus /nolog connect sys/jfjfj as sysdba I get ORA-12545: Connect failed because target host or object does not exist. What target host - what object I had to change domain name and set ORA_NLS33 if that matters?? I can't find anything on Metastink that seems relevant although a great deal of stuff on this error code. Help. -- 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: rebuilding indexes - sure to cause a ruckus
somewhat on the longish side??? I'd hate to see a long article! ;-) --- Richard Foote [EMAIL PROTECTED] wrote: Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
can't see a SQL generated by Crystal Report
Hi all: I'm trying to catch a DDL generated by Crystal report. I'm using the following query to do that: select sql_text from v$sqltext where ( address, hash_value ) in (select sql_address, sql_hash_value from v$session where username = UPPER('username')) order by piece I am catching a SQL, but that SQL returns different amount of rows than the report when executed through a Crystal. Is there something wrong with my query (it is running under Oracle 817) that makes it miss some data? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Data Guard
With TCP over standard ethernet the maximum transfer unit (MTU) is about 1500 bytes, this means if you want to send 2000 bytes over network, you have to fragment it in 2 packets and send them separately. This means double packet headers, double latency etc. Jumbo frames is a capability of some Gbit ethernet cards which allow them to transfer about 9000 bytes in a single packet. SDU is session level transfer unit (session data unit). When you enable jumbo frames and set MTU/SDU to 8192 for example, you'll fit much more in single packet, thus increasing performance for larger transactions. Also make sure that TCP.NODELAY is unset in your sqlnet.ora or is set to true. More info can be found from: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/troubleshooting.htm#635905 Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 11:49 PM Hi, Tanel, enabling jumbo frames and SDU size if using Gbit ethernet, can you elaborate on this? -Original Message- Sent: Monday, December 08, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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: Oracle Data Guard
Hi Carel, That is good help, can you please send me the pdf that you implemented there then. Tell me one thing I agree that we some times (rather most of the time ) generate less redo so we should be smooth. Can you tell me is there any releation between LSB and Primary keys, I read like LCR(logical Change Request) is based on Primary keys as It does not depends on Transaction at that time. Have you implemnented LSB successfully? with many thanks, Vi. --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 13:34 8-12-03 -0800, you wrote: Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. It all depends on the amount of redolog you generate. When that's pretty much, you waste some resources by transporting online/archived redologs you actually don't need. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). So, they don't like nologging operations like truncate, not even on the standby database? The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. LSB might work, but do not consider the option of failing over to it. Be aware that, altough in maximum protection mode your redolog arrives at the SB system within the transaction, it doesn't get applied there instantly. SQL Application takes place _after_ the log-switch on the Primary. When you take 10 minutes of redolog, and perform a logswitch, the SQL Apply process might even take longer than 10 minutes to complete processing of the redologfile. There is a risk that not every transaction arrives within 20 minutes at the LSB. So, your log-switching frequency and the amount of redo you generate per unit of time both play a major role in the refresh rate of the LSB. I'll send you the PDF of a DG Special I did in Kista a few months ago. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be.
RE: migrate 8.1.7 to 9.2.0
Make sure your ORACLE_SID and ORACLE_HOME are set. -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Guys, I am working through a manual migration from 8i to 9i on Solaris 2.8. I am using the guide in Note: 159657.1. I shutdown the 8.1.7 database, copied network and init files - then run sqlplus / as sysdba or sqlplus /nolog connect sys/jfjfj as sysdba I get ORA-12545: Connect failed because target host or object does not exist. What target host - what object I had to change domain name and set ORA_NLS33 if that matters?? I can't find anything on Metastink that seems relevant although a great deal of stuff on this error code. Help. -- 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: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
At 11:59 8-12-03 -0800, you wrote: Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. Aaargh, that's why LOG_ARCHIVE_DEST_n gets so many options that documentation of one parameter takes 56 pages! The more options, the lesser parameters! or is it the other way around? Carel-Jan -- 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: Oracle Data Guard
Comments inline At 14:54 8-12-03 -0800, you wrote: Hi Carel, That is good help, can you please send me the pdf that you implemented there then. Was on its way already Tell me one thing I agree that we some times (rather most of the time ) generate less redo so we should be smooth. Can you tell me is there any releation between LSB and Primary keys, I read like LCR(logical Change Request) is based on Primary keys as It does not depends on Transaction at that time. Because LSB 'reverse engineers' SQL from the redolog info, it needs to get hold of the right rows. The rows get inserted/updated/deleted, and _a_ unique identification, not being the rowid, is required. So, every row needs to be uniquely identified. Have you implemnented LSB successfully? Yes, using a PSB / LSB combination for standby and reporting purposes respectively. with many thanks, Vi. --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 13:34 8-12-03 -0800, you wrote: Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. It all depends on the amount of redolog you generate. When that's pretty much, you waste some resources by transporting online/archived redologs you actually don't need. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). So, they don't like nologging operations like truncate, not even on the standby database? The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. LSB might work, but do not consider the option of failing over to it. Be aware that, altough in maximum protection mode your redolog arrives at the SB system within the transaction, it doesn't get applied there instantly. SQL Application takes place _after_ the log-switch on the Primary. When you take 10 minutes of redolog, and perform a logswitch, the SQL Apply process might even take longer than 10 minutes to complete processing of the redologfile. There is a risk that not every transaction arrives within 20 minutes at the LSB. So, your log-switching frequency and the amount of redo you generate per unit of time both play a major role in the refresh rate of the LSB. I'll send you the PDF of a DG Special I did in Kista a few months ago. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't recommend you to use logical stby yet, it's more like a prototype currently, not exactly a working product. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: rebuilding indexes - sure to cause a ruckus
I think it needs an index. ;-) -Original Message- Paul Baumgartel Sent: Monday, December 08, 2003 3:44 PM To: Multiple recipients of list ORACLE-L somewhat on the longish side??? I'd hate to see a long article! ;-) --- Richard Foote [EMAIL PROTECTED] wrote: Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): -- 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: Oracle Data Guard
Hi Carel, What if 50% of tables doesn't have Primary/Unique keys, how it is going be with LSB then? Can you please explain more. with thanks, Vi --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 14:54 8-12-03 -0800, you wrote: Hi Carel, That is good help, can you please send me the pdf that you implemented there then. Was on its way already Tell me one thing I agree that we some times (rather most of the time ) generate less redo so we should be smooth. Can you tell me is there any releation between LSB and Primary keys, I read like LCR(logical Change Request) is based on Primary keys as It does not depends on Transaction at that time. Because LSB 'reverse engineers' SQL from the redolog info, it needs to get hold of the right rows. The rows get inserted/updated/deleted, and _a_ unique identification, not being the rowid, is required. So, every row needs to be uniquely identified. Have you implemnented LSB successfully? Yes, using a PSB / LSB combination for standby and reporting purposes respectively. with many thanks, Vi. --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 13:34 8-12-03 -0800, you wrote: Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. It all depends on the amount of redolog you generate. When that's pretty much, you waste some resources by transporting online/archived redologs you actually don't need. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). So, they don't like nologging operations like truncate, not even on the standby database? The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. LSB might work, but do not consider the option of failing over to it. Be aware that, altough in maximum protection mode your redolog arrives at the SB system within the transaction, it doesn't get applied there instantly. SQL Application takes place _after_ the log-switch on the Primary. When you take 10 minutes of redolog, and perform a logswitch, the SQL Apply process might even take longer than 10 minutes to complete processing of the redologfile. There is a risk that not every transaction arrives within 20 minutes at the LSB. So, your log-switching frequency and the amount of redo you generate per unit of time both play a major role in the refresh rate of the LSB. I'll send you the PDF of a DG Special I did in Kista a few months ago. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging etc), will not run that fast anymore. In logical standby, I think there's no such requirement, but I don't === message truncated === BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December
Re: A brief detour....;-)
Monday, December 8, 2003, 4:19:27 PM, Bobak, Mark ([EMAIL PROTECTED]) wrote: BM So, I saw on SlashDot (http://www.slashdot.org/) a story BM about a guy who has over 100 different implementations BM of the Towers of Hanoi solution, each in a different BM language. Since he didn't have one in PL/SQL, Aw, PL/SQL never gets no respect. BM I decided to write one. Cool! I hope you posted the PL/SQL solution on Slashdot too. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
CLONE db
Hi, I have hotbackup for x date.I want to create clone to another box on Linux(Oracle9i). is it possible to clone with same instance name on diffrent box with diffrent file location?I think yes. Can someone send me correct steps how to clone on linux box? Thx -Seema _ Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database management techniques and frameworks
I'm not assuming such a tool exists... It indeed does exist because the salesman who happened to be selling it said so and it must be true. ;-) A former boss saw it, got it (on eval) then tried to get me to use it. Lucky for me I was able to deflect such silliness until the boss was fired. I was also fortunate in that, while some of the Unix dweebs thought the tool was cool, they eventually tired of the scene and I was able to continue with my proven script/monitoring routines. As a happy Bambi below the heavens I did frolic. :-) -Original Message- Mladen Gogala Sent: Monday, December 08, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Here, of course, you're assuming that such a magical GUI, sort of DBA in an ancient oil lamp, tools exist. Well, they do not. Even if you have some useful gooey tools, they do require extensive configuration and customization to become useful and they do require extensive knowledge from the person doing configuration and customization. Other then that, I find it quite questionable how useful it is to fire your own customers and replace them with cheap Elbonian labor. Anyone who has called Oracle support recently knows exactly what I'm talking about. On 12/08/2003 04:44:31 PM, Orr, Steve wrote: No Bambi, No, no, no... This is not what damagement wants. They don't want you to develop your own tools and scripts so they are dependent on you. They want to spent lots of money on a GUI tool they can see and they want a sales drone to show them how easy it is and tell them that anybody can be a DBA if they just had this GUI tool. That way, if they don't like you they can get rid of you and just pluggin another warm body. Sort of like handing a hammer to an unskilled laborer and saying, Here, you are now a master carpenter. By all means stop using that geek stuff like Perl. Stop being subversive to the system by developing your own stuff and use the GUI wizbang tool that damagement likes. -Original Message- Bellow, Bambi Sent: Friday, December 05, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
On 2003.12.08 17:24, Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! I missed the opportunity because I was amid changing jobs. I tried to lay my hands on the software several times since then, to no avail. Ducks and runs. :) No need, Pete. I've always appreciated your advice and expertize. Your posts have been very useful to me on more then one occasion. I am the one to apologize for blowing off some steam, but I must confess, that I don't understand such secrecy, especially not after it has already been announced. -- 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: dc_used_extents ,dc_free_extents and dc_histogram_defs
Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) And no apologies needed. Particularly from someone that's bigger than me! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 11:29 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 17:24, Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! I missed the opportunity because I was amid changing jobs. I tried to lay my hands on the software several times since then, to no avail. Ducks and runs. :) No need, Pete. I've always appreciated your advice and expertize. Your posts have been very useful to me on more then one occasion. I am the one to apologize for blowing off some steam, but I must confess, that I don't understand such secrecy, especially not after it has already been announced. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: CLONE db
I assume both OS are same (Linux). What you can do is rename the filenames using alter tablespace or alter database rename file. So 1) Copy database files, archive logs etc.to new machine 2) Startup mount 3)Rename files 4) Start recovery You could also take a backup controlfile to trace then change the file u get in udump to change the file names.Then use it to create a controlfile on the new machine. However using controlfile and creating a new controlfile means you can only do 'resetlogs'. 1) Copy database files to new machine 2) Startup nomount 3) Create controlfile 4) Start recovery Seema Singh [EMAIL PROTECTED] wrote: Hi,I have hotbackup for x date.I want to create clone to another box on Linux(Oracle9i).is it possible to clone with same instance name on diffrent box with diffrent file location?I think yes.Can someone send me correct steps how to clone on linux box?Thx-Seema_Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Seema SinghINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] tcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: A brief detour....;-)
Bobak, Mark wrote: Here it is: [...] This concludes this public service announcement. We now return you to our regularly scheduled programming. Interesting. PL/SQL recursive solutions are expensive, though. :) Did not check it, maybe something alike was posted already... SET VERIFY OFF PAGES 200 DEFINE disks=7 REM Please do not use all_objects :) DEFINE big_table=all_objects COLUMN Implementation Plan FORMAT A20 SPOOL hanoi_solution.txt SELECT 'Move it from ' || TO_CHAR(MOD(BITAND(ROWNUM, ROWNUM - 1), 3) + 1) || ' to ' || TO_CHAR(MOD(-BITAND(-ROWNUM - 1, -ROWNUM), 3) + 1) AS Implementation Plan FROM big_table WHERE ROWNUM POWER(2, disks) AND disks 8 / SPOOL OFF Should work correctly. Regards, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
And how do you join one ? Denny Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! Ducks and runs. :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 6:59 AM To: Multiple recipients of list ORACLE-L Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't plan on migrating to 10g until I learn it well and if some oracle sales guy tries to exert pressure on me to migrate, he will get a very stable sign used by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill of white papers and articles and now I want to see the software. On 12/08/2003 02:24:33 PM, [EMAIL PROTECTED] wrote: .. And there used to be all these dc_ parameters that one could set, giving the dba control over the dictionary cache, which was not a part of the shared pool. And then came Oracle V7, with the shared_pool_size, wresting that control. Regards Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ading.com cc: Sent by: Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs [EMAIL PROTECTED] ity.com 12/08/2003 01:29 PM Please respond to ORACLE-L Well, once upon a time, in a land far, far away, there was Oracle V6 with something called "TPO", which was essentially row locking + PL/SQL V1 (no stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve Feuerstein and Howard Rogers know a thing or two about the Jurassic period in the database development. BTW, that was also when buffer hit ratio was invented. The entries that you see are remnants from oracle v6, together with the table called "V$ROWCACHE" and are both religiously maintained for the compatibility reasons, because Oracle Corp. doesn't want to disappoint all those who are still running V6. Even compatibility with V5 is still maintained. In Oracle 5.1.22, dictionary views weren't called "user_tables" and "user_objects", they were called "tab" (user_tables) and cat (from "CATALOG", replaced with "USER_OBJECTS"). The term "CATALOG" was directory command on Apple IIe (6502, later Z80) with 100k floppies, computer immensly popular at the time, and I believe that is why the first implementation of "user_objects" was called "catalog". Now, let's fast forward to the present time and Oracle 9.2.0.4. Do "Select * from tab" and "select * from cat". You'll be surprised. For all those still running V5.1.22 with forms 2.0 and 2.3, the world is not over yet. On 12/08/2003 12:39:30 PM, Guang Mei wrote: Hi: I am reading some statspack reports from our 8173 DB (on Sun Solaris) and found some of "Dictionary Cache Stats" are pretty high (much higher than 2%). I notice that "Pct Get Miss" for dc_used_extents ,dc_free_extents and dc_histogram_defs are high (the second column data below). Is this something I need to pay attention in terms of doing performance optimization? If yes, what are the things (regarding "Dictionary Cache") that I should look in order to improve the performance? TIA. Guang ps, here are some "dc_" stats from my reports and a copy of actual report (partial):
Re: Add/Drop partition and CBO statistics
Hi list: I did another add partition last monday evening, and that time everything is ok. Maybe statistics did not change much(like high value in tables/indexes). I will do more research and give feedback to you . And I think there must be other DBAs also using partitions, why not share your pains and gains? Regards. Zhu Chao. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:49 AM I've got a perfect application for partitioning by date. Each month is a new batch of data and everything is set for the last date of the month. But they asked me today, if we drop a partition of old data, and then add a new partition for the next month, load it, what needs analyzed? Is it enough to simply analyze the new partition? -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 Reply in lines. Zhu Chao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 7:29 PM Agreed that scanning one big index is faster than many partitions. Then raises the questions - I thought partitioning is for: 1) ease of archiving/dropping off old partitions - drop old and create new partitions in a sliding window. A single large global index negates a lot of this ease - even though it is true that deletes on non-partitioned tables would be even more inconvenient. Yes, that is why we use local index.not Global indexes. 2) efficiencies in partition pruning for queries. If you are querying whole table - why bother with partitioning? The point then becomes you don't need to partition in the first place, or your partitioning scheme is not appropriate? Sometimes it is constrained by complex real applications. A table has tens of columns and you can only partition by one key(or several columns), and to use partition elimination, the SQL must contains the partition key. So only these limited SQL can use partition pruning. While in complex real life application, there will always SQL with different where clause that do not use the partition key at all. The other constraint is business logic.We should partition according to product online time, but we have ten tables to archive and only one table(products) has that key, all other tables do not have that column. Adding such a column to other tables need considrable application rewrite and is denied. So we use product_id(the primary key of most tables) as the partition key. When partitioning key is not a part of the index and you are querying whole table, then it is faster to scan one big index than many smaller ones. The difference is something like log rows to partcount*log (rows/partcount). BTW, local indexes are the only way to go -- I've never understood the point of global indexes on partitioned tables -- maybe someone else can? Global indexes are faster than local index, so if you have schedule down time and need better performance, go to global index. OLTP is more suitable for GLobal index, tomas kyte said in his expert one on one. Regards Zhu Chao. Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list,