Is it possible to copy one db to another if the SID is different
Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA 604 followed by ORA 4031 error
hello guys, i found this error in my trace file. environment is 8.1.6/win2k. system RAM = 4G shared_pool_size = 238M shared_pool_reserved_size = 119M java_pool_size = 64K large_pool_size = 95M - ERROR IN EXECUTING TIGGERS IN DB. ON STARTUP ksedmp INTERNAL FATAL ERROR ORA 604 : ERROR OCCURED AT RECURSIVE SQL LEVEL STRING ORA 4031 : UNABLE TO ALLOCATE 4032 BYTES OF SHRED MEMORY (shared pool,java/io/inputstreamsys,joxled:in ehe,ioc_allocate_pool) ORA 6512 : sys.dbms_java , ? 0 ORA 6512 : ? 2 -- then i changed, java_pool_size = 20M large_pool_size = 150M but even then i get the same error in my trace files. what is the reason for this error ? will increasing shared_pool_size get rid of it ? is it a fatal error ? kindly let me know your views. thanx in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is differ
Hi Yen-wee, I tried but still get the following error message : CREATE CONTROLFILE SET DATABASE TEST RESETLOGS NOARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST ORA-01110: data file 6: '/dg8/oracle/testdata/ctxd01.dbf' Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:18 PM To: CHAN Chor Ling Catherine (CSC) Subject:RE: Is it possible to copy one db to another if the SID is differ ent Hi Can u try SET instead of REUSE? CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Subject: Is it possible to copy one db to another if the SID is different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is differ
Hi, You have to recreate the controlfile as CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG. The new database name will be TEST . Pl ensure that the old control files are deleted before recereating the controlfile . Regards Rajendra -Original Message- Sent: Wednesday, October 09, 2002 12:43 PM To: Multiple recipients of list ORACLE-L different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Choudhary Rajendra (TTL_LKO) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is it possible to copy one db to another if the SID is different
Hi, Please use SET in create controlfile statement if you are going to change the DB Name. CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS ARCHIVELOG thnx Venkat ORACLE-L@fatcity. com To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Is it possible to copy one db to another if the SID is different 10/09/02 12:43 PM Please respond to ORACLE-L Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is differ
hi you have to do a alter database backup controlfile to trace on the source database change all occurrences PROD in TEST in the created backup controlfile the create controlfile reuse has to be create controlfile SET database test oracle note 61590.1 on metalink g.g. kor rdw the netherlands -Oorspronkelijk bericht- Van: CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 9 oktober 2002 9:13 Aan: Multiple recipients of list ORACLE-L Onderwerp:Is it possible to copy one db to another if the SID is different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is differ
Thanks to those (Venkat, Rajendra and Yen-Wee) who replied. Problem has been resolved. Solution : * Has to use CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG * I forgot to delete old control files. Thank you so much. Regds, New Bee -Original Message- From: Choudhary Rajendra (TTL_LKO) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Subject:RE: Is it possible to copy one db to another if the SID is differ Hi, You have to recreate the controlfile as CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG. The new database name will be TEST . Pl ensure that the old control files are deleted before recereating the controlfile . Regards Rajendra -Original Message- Sent: Wednesday, October 09, 2002 12:43 PM To: Multiple recipients of list ORACLE-L different Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Choudhary Rajendra (TTL_LKO) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
bug2062512
Hello all. I tried get file bug2062512.tar.gz from oracle ftp site ftp://oracle-ftp.oracle.com/server/patchsets/unix/LINUX/bug2062512/ This file is 8411 bytes of length. At ftp site I see same size for that file. After I had got that and started decompress gzip messaged me that unexpected end of file. I had some attempts to get this file, but result was same. Does somebody have correct version of this file ? -- Best regards Mikhail Ivanov W±ëzØ^¡÷âr¥9,BÅm¶ÿÃ(§Ú©Êëa¢³¢ÚÈ4Dæö§¢û]z¶«¸V +r5ëp¢¹z»âqëçÎwó9Öm§ÿðÃÚµÈÉÊI©Ãè( +©b~ç£X§X¬µ©ÝÁæá¢Ëb®øzÄèDCTL¨º»÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\ ²¥)à¡òâ²Ñ®®æ§v)í é²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þ騽ç_®¢éÉ©l¢Ç§vØ^BÏr¦jw_¢º- êâú+«b¢ybë.nÇ+¸§
ORA-472 DBWR terminated
Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: ORA-472 DBWR terminated
Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround. If you've already done this what was the outcome? BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 10:39 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle pricing...
Title: Oracle pricing... Hi, found the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. Product Named users Licence Processor Licence Oracle db(enterprise) 800 4 Oracle db(standard) 300 15000 Oracle db(personal) 400 -- rgds amar http://amzone.netfirms.com
RE: ORA-472 DBWR terminated
creating a file solved the problem(actually renamed the alertlog back to original name) and it wasn't such a big deal. I am just wondering why two databases with similar setup and exact same versions on the same machine do not have the same problems. Creating a workaround for this database is not my first choice as this is a script that runs of a remote server and is standard for all UNIX databases. But if all else fails Thx Jack -Original Message- Sent: Wednesday, October 09, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround. If you've already done this what was the outcome? BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 10:39 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: ORA-472 DBWR terminated
Would you please send the dbwr trace file . Regards Rajendra -Original Message- Sent: Wednesday, October 09, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Choudhary Rajendra (TTL_LKO) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 9i desupport dates
The first releases of each version tend to be de-supported more quickly than the final releases, I think. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 5:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle 9i desupport dates Wait a min... Apps isn't even certified on 9.2 yet! April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: oracle 9i desupport dates 9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003. -- yes in like 8 months 9.2, aka9ir2, ECS ends sep 30, 2005. joe
RE: ORA-472 DBWR terminated
Apart from ensuring that the unix file permissions are fine have you considered that the alert log file may be being created but in a different location? Have a look and do a search. I seem to recall seeing an unexplainable event like this on Windows before Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 11:43 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- creating a file solved the problem(actually renamed the alertlog back to original name) and it wasn't such a big deal. I am just wondering why two databases with similar setup and exact same versions on the same machine do not have the same problems. Creating a workaround for this database is not my first choice as this is a script that runs of a remote server and is standard for all UNIX databases. But if all else fails Thx Jack -Original Message- Sent: Wednesday, October 09, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround. If you've already done this what was the outcome? BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 10:39 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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
how to change listener port ?
guys, i have a db CLONEDB , cloned from another DB. i have did it successfully and things work fine. the listener listens on default port 1521. now i would like to change this to some other port number , say 2521. the environment is oracle 8.1.6/win2k. how do i do it ? can someone explain me the steps involved ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-472 DBWR terminated
Listers: I've been a subscriber of this Oracle list for three days now. Am I correct in concluding that most of the participants / questions are at the DBA level? If I'm correct, is there an Oracle list more suited to a developer ( been in the business for 20 years, but 2 weeks with Oracle )? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 list more suited to a developer?
Listers: Sorry for the duplicate posting, the first was with an incorrect subject line. I've been a subscriber of this Oracle list for three days now. Am I correct in concluding that most of the participants / questions are at the DBA level? If I'm correct, is there an Oracle list more suited to a developer ( been in the business for 20 years, but 2 weeks with Oracle )? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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-472 DBWR terminated
Harry, Welcome. There are DBA's and developers on this list. You may even see a reference or two to perl. ;o) Here is a link that lists many Oracle related sites and may have exactly what you are looking for. http://web.singnet.com.sg/~petermag/oracle.html Dave -Original Message- Sent: Wednesday, October 09, 2002 7:19 AM To: Multiple recipients of list ORACLE-L Listers: I've been a subscriber of this Oracle list for three days now. Am I correct in concluding that most of the participants / questions are at the DBA level? If I'm correct, is there an Oracle list more suited to a developer ( been in the business for 20 years, but 2 weeks with Oracle )? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL and case structure
Thanks to everyone who answered this question. The paper noted below is excellent! -Original Message- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject:RE: SQL and case structure Doug Burns wrote a very informative paper on Decode, presented at an earlier UK-OUG meeting. Its available from his web site: http://doug.burns.tripod.com/decode.html And the answer to the question posed below is 'yes'. peter edinburgh -Original Message- From: Droogendyk, Harry [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 23:59 To: Multiple recipients of list ORACLE-L Subject: RE: SQL and case structure Jesse: Can I also use the value of another column rather than a literal like my example coded? e.g. select acct_no, decode(substr(acct_no,16,1),'1',field1 '2',field2 field3 ) as descr from star.kills ; TIA -Original Message- Sent: Monday, October 07, 2002 5:28 PM To: Multiple recipients of list ORACLE-L CASE in PL/SQL serves a slightly different function, but DECODE should do the trick. Try: select acct_no, DECODE(substr(acct_no,16,1), '1','one', '2','two', 'other') as DESCR from star.kills; I also changed desc to descr, since desc is a reserved word. HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Droogendyk, Harry [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Subject: SQL and case structure Listers: I've used SAS's version of SQL and it allows the coding of conditional logic in the SELECT statement: proc sql; select acct_no, case substr(acct_no,16,1) when '1' then 'one' when '2' then 'two' else 'other' end as desc from star.kills; quit; The same syntax does not work in SQL*Plus for Oracle 8. Can someone point me to the correct syntax? Secondly, any URLs for this kind of information would be most appreciated. Regards, Harry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED]
Re: Oracle pricing...
Amar, All human users and non-human operated devices that are accessing the program Check out the software investment guide : http://www.oracle.com/corporate/pricing/index.html?sig.html In particular, I like the 400-employees-on-30-forklifts example (pg. 15 of the guide). I would love to see an Oracle sales rep. explain that one to our CFO! Jay [EMAIL PROTECTED] 10/09/02 06:08AM Hi, found the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. Product Named users Licence Processor Licence Oracle db(enterprise) 800 4 Oracle db(standard) 300 15000 Oracle db(personal) 400 -- rgds amar http://amzone.netfirms.com **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reports
Maybe he got the wrong name. Can you connect via SQLPLUS from his machine? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 7:33 PM I don't work with Oracle Reports but one of my co-workers does. His problem --- TNS can't find the database. He has three Oracle homes. I've copied the good tnsnames.ora to all of his homes (I know about the NETWORK and NET80 directories). It's Report 6i on a Win2K machine trying to connect to an 8.1.6 Oracle. He has Reports 6i installed on two of his Oracle homes and Reports 6.0 on the other. Don't ask me why --- I don't know. I used the Oracle home changer and cycled through all 3 homes. The error is ORA-12154: TNS could not resolve service name. Is there anything special about having multiple copies of Reports on Win2K? Thanks (IA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Write caching controllers
Good morning all! I have a question regarding use of write-caching RAID controllers. As an NT systems/network admin of some years, and an Oracle 8i DBA-in-training, I had done some homework and gather that both Oracle and industry best-practices suggest avoiding write-caching controllers if possible (to preclude any chance of data loss). As a result, I had recommended we purchase dual non-caching controllers on the new Compaq ML530s we are about to buy. Compaq has discontinued the model controller we requested, and now all their controllers include write caching (battery-backed, of course). We are running a couple of ~10GB instances, not terabyte OLTP - so should I just go with it and not be so anal about the caching?? Thanks and Regards, Brian NT 4.0 SP6a Oracle 8.1.7.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richards, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: trace an SQL session
Thank you for the correction. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 6:18 PM Igor Neyman wrote: select v$sql.sql_text from v$sql, v$session where v$sql.address = v$session.sql_address and v$sql.hash_value = v$session.sql_hash_value and v$session.sid = sid; Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to change listener port ?
Modify listener.ora in network/admin directory. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 8:18 AM guys, i have a db CLONEDB , cloned from another DB. i have did it successfully and things work fine. the listener listens on default port 1521. now i would like to change this to some other port number , say 2521. the environment is oracle 8.1.6/win2k. how do i do it ? can someone explain me the steps involved ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Write caching controllers
As long, as battery backup on the controller is working, you should be fine. On the other hand, all those controllers should have an option to turn of write-caching, if you wish. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 9:23 AM Good morning all! I have a question regarding use of write-caching RAID controllers. As an NT systems/network admin of some years, and an Oracle 8i DBA-in-training, I had done some homework and gather that both Oracle and industry best-practices suggest avoiding write-caching controllers if possible (to preclude any chance of data loss). As a result, I had recommended we purchase dual non-caching controllers on the new Compaq ML530s we are about to buy. Compaq has discontinued the model controller we requested, and now all their controllers include write caching (battery-backed, of course). We are running a couple of ~10GB instances, not terabyte OLTP - so should I just go with it and not be so anal about the caching?? Thanks and Regards, Brian NT 4.0 SP6a Oracle 8.1.7.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richards, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Is it possible to copy one db to another if the SID is di
New Bee, It's CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS NOARCHIVELOG. ^ Dick Goulet Reply Separator Author: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Date: 10/8/2002 11:13 PM Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA 604 followed by ORA 4031 error
Increase your java_pool_size. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 4:08 AM hello guys, i found this error in my trace file. environment is 8.1.6/win2k. system RAM = 4G shared_pool_size = 238M shared_pool_reserved_size = 119M java_pool_size = 64K large_pool_size = 95M - ERROR IN EXECUTING TIGGERS IN DB. ON STARTUP ksedmp INTERNAL FATAL ERROR ORA 604 : ERROR OCCURED AT RECURSIVE SQL LEVEL STRING ORA 4031 : UNABLE TO ALLOCATE 4032 BYTES OF SHRED MEMORY (shared pool,java/io/inputstreamsys,joxled:in ehe,ioc_allocate_pool) ORA 6512 : sys.dbms_java , ? 0 ORA 6512 : ? 2 -- then i changed, java_pool_size = 20M large_pool_size = 150M but even then i get the same error in my trace files. what is the reason for this error ? will increasing shared_pool_size get rid of it ? is it a fatal error ? kindly let me know your views. thanx in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LMT's and DMT's in same database?
I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Warehouse design: snowflake vs star schemas
Dennis, Thanks for the link. It's a great DW resource. There are not only fundamentals, but some valuable real-life stuff, which is what I need. Live and learn, learn,learn... Regards, Alex -Original Message- WILLIAMS Sent: Tuesday, October 08, 2002 7:39 PM To: Multiple recipients of list ORACLE-L Alexandre Stephane gave you an excellent reply. If you want to learn more about these DW design issues, I would start by visiting http://www.ralphkimball.com. He is one of the leading figures in the DW field, and has copies of all his articles posted on his site. I would start with the oldest articles because those are where he discusses the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 08, 2002 3:29 AM To: Multiple recipients of list ORACLE-L Stéphane, Thanks for response. I have always discplined myself to use star schema and never snowflake. Would you mind asking why? The Which one is easier to implement and easier ETL ? is not a good question as your data model should not be design for the ETL procecess but only for the querying. I mean ETL to load data _INTO_ data warehouse. Of course, complexity is mostly determined by sources, but still I'd like to know if there is any general influence by DW's data model. Another question. Is it feasible to make date dimension or just use date column? For example, Oracle Discoverer can work with date columns using hierarchies Y-M-D and similar. What is faster: separate table for date dimension or date column? If I go with date dimension table should I use date column as a foreign key in fact table or use some artificial key? TIA, Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 pricing...
Named User pricing is for individuals you can name. The Oracle installed users SYS, SYSTEM, DBSNMP, OUTLN, etc do not count. BTW: That does not mean that if one person at your company is on the day shift that they can pass their account on to someone on the night shift. In this case you have 2 named users and have to pay accordingly. Also don't ever, under any circumstances attach any type of WEB or transaction server to this database. You'll need CPU licensing for that. Oracle interprets Named Users very tightly. BTDT, OUCH!! Dick Goulet Reply Separator Author: Amar Kumar Padhi [EMAIL PROTECTED] Date: 10/9/2002 2:08 AM Hi, found the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. Product Named users Licence Processor Licence Oracle db(enterprise) 800 4 Oracle db(standard) 300 15000 Oracle db(personal) 400 -- rgds amar http://amzone.netfirms.com !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=x-user-defined META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEOracle pricing.../TITLE /HEAD BODY PFONT SIZE=2 FACE=Courier NewHi, /FONT BRFONT SIZE=2 FACE=Courier Newfound the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. /FONT/P PBFONT SIZE=2 FACE=Courier NewProductnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n bsp;nbsp;nbsp;nbsp;nbsp;nbsp; Named users Licencenbsp;nbsp; Processor Licence/FONT/B BRFONT SIZE=2 FACE=Courier NewOracle db(enterprise)nbsp;nbsp;nbsp;nbsp; 800nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp ;nbsp;nbsp;nbsp;nbsp; 4nbsp;nbsp; /FONT BRFONT SIZE=2 FACE=Courier NewOracle db(standard)nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 300nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp ;nbsp;nbsp;nbsp;nbsp; 15000/FONT BRFONT SIZE=2 FACE=Courier NewOracle db(personal)nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 400nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp ;nbsp;nbsp;nbsp;nbsp; -- /FONT /P PFONT COLOR=#00 SIZE=2 FACE=Courierrgds/FONT BRFONT COLOR=#00 SIZE=2 FACE=Courieramar/FONT BRFONT COLOR=#00 FACE=ScriptA HREF=http://amzone.netfirms.com; TARGET=_blankhttp://amzone.netfirms.com/A/FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LMT's and DMT's in same database?
Yes you can. M. -Original Message- Dave Sent: 09 October 2002 14:54 To: Multiple recipients of list ORACLE-L I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.394 / Virus Database: 224 - Release Date: 03/10/2002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Warehouse design: snowflake vs star schemas
Stéphane, Thanks for good points! Alex -Original Message- stephane Sent: Tuesday, October 08, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Snowflake is often used because people still want to normalize (and save some disk space !) which is not the way to go to ease query. If you do an hybrid data model, your loading will be easier as you will have less problems to solve. I agrre with you, the complexity comes from the number of sources and their quality. But, from experience, at my last job, the DW has designed an hybrid data model to ease the ETL processes. Let me tell you that the querying and reporting was painful and slow. We have redesign it in a more formal star schema and we had some real challenges to load the DW. On the current project, we have 15 sources (excel, cobol, Oracle, Clipper, DB2/MVS, Nomad,... ) we are doing a prototype with an ETL, we will have fun ! It is feasible just to have a date column in the fact table. That's what they had done at the previous job. I do not recommend that. If you carefully do the analysis, you'll see that the users want to manage all kind of special events like season, national day, F1 racing (in Montreal, a beer company is checking if beer is more sold during the week-end Grand Prix). Also, often the fiscal year do not match the calendar year. So there is plenty stuff you may want to track with the time dimension. Using a generated key or the date value as the key is a good question. On the theoritical side you should use a generated key. I've used a date field without problem. --- Alexandre Gorbatchev [EMAIL PROTECTED] a écrit : Stéphane, Thanks for response. I have always discplined myself to use star schema and never snowflake. Would you mind asking why? The Which one is easier to implement and easier ETL ? is not a good question as your data model should not be design for the ETL procecess but only for the querying. I mean ETL to load data _INTO_ data warehouse. Of course, complexity is mostly determined by sources, but still I'd like to know if there is any general influence by DW's data model. Another question. Is it feasible to make date dimension or just use date column? For example, Oracle Discoverer can work with date columns using hierarchies Y-M-D and similar. What is faster: separate table for date dimension or date column? If I go with date dimension table should I use date column as a foreign key in fact table or use some artificial key? TIA, Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LMT's and DMT's in same database?
Why not? 8i didn't have the option of having the system tablespace as locally managed(not sure about 9i), but they always had the option of locally managed ones for the other tablespaces. u can have both of them in the same db without any problem Regards Naveen -Original Message- Sent: Wednesday, October 09, 2002 7:24 PM To: Multiple recipients of list ORACLE-L I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: LMT's and DMT's in same database?
Yes Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 9. Oktober 2002 15:54 An: Multiple recipients of list ORACLE-L Betreff: LMT's and DMT's in same database? I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LMT's and DMT's in same database?
Yes, you can. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 9:54 AM I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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:Is it possible to copy one db to another if the SID is di
Did you modify db_name parameter in initSID.ora to be TEST? Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 9:48 AM New Bee, It's CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS NOARCHIVELOG. ^ Dick Goulet Reply Separator Author: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Date: 10/8/2002 11:13 PM Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LMT's and DMT's in same database?
Yes (at least that's what the study guide answer is...) Brian OCP-2-B -Original Message- Sent: Wednesday, October 09, 2002 9:54 AM To: Multiple recipients of list ORACLE-L I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richards, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LMT's and DMT's in same database?
Dave - This shouldn't be a problem. I am gradually converting my tablespaces to LMT, but for relatively static tablespaces, I haven't had a reason to go in and rebuild yet. Yes, I know there is a procedure to convert a dictionary-managed to LMT, but I don't trust it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 8:54 AM To: Multiple recipients of list ORACLE-L I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reports
Yes. Thanks for all who answered. It's still a mystery but it had a worthwhile consequence. They (the powers that be) have decided to can reports and go with Java. We'll see where this leads. Yechiel Adar adar76To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @inter.net.ilcc: Subject: Re: Reports Sent by: root 10/09/2002 09:08 AM Please respond to ORACLE-L Maybe he got the wrong name. Can you connect via SQLPLUS from his machine? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 7:33 PM I don't work with Oracle Reports but one of my co-workers does. His problem --- TNS can't find the database. He has three Oracle homes. I've copied the good tnsnames.ora to all of his homes (I know about the NETWORK and NET80 directories). It's Report 6i on a Win2K machine trying to connect to an 8.1.6 Oracle. He has Reports 6i installed on two of his Oracle homes and Reports 6.0 on the other. Don't ask me why --- I don't know. I used the Oracle home changer and cycled through all 3 homes. The error is ORA-12154: TNS could not resolve service name. Is there anything special about having multiple copies of Reports on Win2K? Thanks (IA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9.2 on Red Hat 8.0
That's interesting since Oracle Corp is now offering to be front-line and back-line support for the Linux OS itself, in addition to the DB. Our local sales guy (in another country!) didn't mention what distros or versions, though... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 8:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: 9.2 on Red Hat 8.0 Oracle only supports RH 7.1, SLES-7, RH Advanced Server 2.1. Right? I understand Oracle is having problems supporting RH 7.1 but they won't admit it to the general public. So even official RH 7.1 support could be risky. ;-) Any rumors? On another note, I've heard that RH Advanced Server 2.1 does not support direct I/O but SLES-7 does. Can anyone corroborate this? Any rumors? I guess SLES-8/United Linix (UL) will be available in November and the assumption is that it will have Oracle's blessing. Any rumors? Feeling like the Katt... Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Write caching controllers
Brian, I would not worry about it. To preclude any chance of data loss requires not having any data to loose in the first place. I lost files using EMC Symmetrix, yet I have bought more. inka -Original Message- Sent: Wednesday, October 09, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Good morning all! I have a question regarding use of write-caching RAID controllers. As an NT systems/network admin of some years, and an Oracle 8i DBA-in-training, I had done some homework and gather that both Oracle and industry best-practices suggest avoiding write-caching controllers if possible (to preclude any chance of data loss). As a result, I had recommended we purchase dual non-caching controllers on the new Compaq ML530s we are about to buy. Compaq has discontinued the model controller we requested, and now all their controllers include write caching (battery-backed, of course). We are running a couple of ~10GB instances, not terabyte OLTP - so should I just go with it and not be so anal about the caching?? Thanks and Regards, Brian NT 4.0 SP6a Oracle 8.1.7.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richards, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sequence numbers
I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performancehit if I take out the cache 20? April Wells Oracle DBAThere is neither good nor bad, but thinking makes it so. -Shakespeare CSUA 2002: Imagine the Possibilities! Corporate Systems Annual Users Association Conference When: October 2-4, 2002 Where: Caribe Royale Resort Orlando, FL USA For more information go to www.csedge.com The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment.
Oracle Portal -- DB Performance Tuning -- any tips ?
Has anyone experiences to share on DB Performance Tuning for Oracle Portal [DB 8.1.7.2 for Oracle Portal 3.0.9.8.0 as part of iAS 1.0.2.2, not yet having upgraded the Portal to 3.0.9.8.3 or 3.0.9.8.4] ? Our portal implementation seems to have the following characteristics : 1. Each page has 4 to 6 portlets [some are HTML, others StoredProcedures] 2. Every time a user visits a page, each of the portlets makes a seperate connection to the database, executes the procedure and disconnects. [ie, 4 to 6 connect-execute-disconnect calls for each page for each visitor]. I tried setting the connection-pooling or connection-reuse feature in the modplsql gateway settings but this suddenly caused the number of database sessions to go up from 40-60 to 200 in a matter of minutes. Apparently, there's a few bugs logged and a couple of notes advising not to use this feature, particularly if you have Intermedia Indexing enabled -- which we have. So I had to set the connection-reuse back to No. 3. StatsPack indicates high waits on log-file-sync. OK, the LGWR may be slow writing to redo logs --- but this is a Portal, why are we having a large number of writes/transactions/commits in the first place ? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is differ
One thing to keep in mind (If I recall correctly): If you are using rman repository, the database ID (DBID) of the copied database will be the same as the old database. You will have to create a second schema in the repository if you plan on backing up both the new and the old databases using the same catalog database. -Original Message- Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to change listener port ?
oraora Yes, in the listener.ora file, in the section: LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 999.999.999.999) (Port = 2521) You don't want to accidentally select a port that something else on your network is using. The usual alternate port to use for Oracle is 1526. On Unix, there is a file that designates what application or function uses what port. I understand from my networking buddy that this is more of a honor system, so theoretically you should add an entry there. I haven't the faintest idea how this applies to W2K, but somebody on this list probably does. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 7:19 AM To: Multiple recipients of list ORACLE-L guys, i have a db CLONEDB , cloned from another DB. i have did it successfully and things work fine. the listener listens on default port 1521. now i would like to change this to some other port number , say 2521. the environment is oracle 8.1.6/win2k. how do i do it ? can someone explain me the steps involved ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Consistent gets
Has anybody any idea why a query against tables on which very few if any update are applied would display a high number of consistent gets ? Details : Big query involving 4/5 tables, most of them partitioned. This is a test database, db block buffers about 100M, 5,000,000 of logical reads with 8K blocks which means that the SGA is flushed a number of times. The execution plan starts with a partition scan, then a series of nested loops (hash join disappointing). The number of db block gets corresponds to the number of blocks read during the partition scan; everything else appears as consistent gets. You can rule out delayed cleanout, since the same behaviour is displayed when the same query is run over and over and not update at all takes place. Another curious symptom is that the number of rows returned per second decreases by a factor 3 or 4 between the beginning and the end of the query. Believe me, no hideous hidden scan of table of partition. TIA, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9.2 on Red Hat 8.0
Oracle seems to change their official mind from time to time, but the reality is that RedHat 7.1 and 7.3 are the best versions to run with Oracle. I've had absolutely no problems with either version of the OS, and the installation and setup are well documented (both by Oracle and third-party sites). AS2 appears to have been targetted to Oracle, and installs super clean (the least amount of effort yet required). Good deal if you're looking for the top of the line configuration. I've tried installing 8.1.7 (my usual testbed) on RedHat 8.0 this past weekend and encountered some problems. It doesn't like Apache 2.0 in the mix, even though it doesn't use it. It has some problems getting the IP address, but I can fix that afterwards. The tough issues are which JDK (seems like 1.1.8 is the answer) and which compat- libs. I'm plowing through the compat- libs issue right now. Hopefully it will be fully installed and I can give some feedback as to how it runs in a week or so. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is differ
Title: RE: Is it possible to copy one db to another if the SID is differ or consider note: 174625.1 -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Is it possible to copy one db to another if the SID is differ One thing to keep in mind (If I recall correctly): If you are using rman repository, the database ID (DBID) of the copied database will be the same as the old database. You will have to create a second schema in the repository if you plan on backing up both the new and the old databases using the same catalog database. -Original Message- Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sequence numbers
If the sequence is not cached then Oracle has to generate a new sequence number for every record inserted (CPU cycles). NOORDER is the default so that won't slow you up. If you're doing bulk loads why not cache the sequence numbers? Is it important that there be no gaps? Even with NOCACHE you can get gaps. If a sequence number is generated but the row (insert or create) is not COMMITed the sequence number is not rolled back. Unless there are fewer than 100 rows to be inserted I'd go with some caching. April Wells awells To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @csedge.com cc: Sent by: rootSubject: sequence numbers 10/09/2002 10:54 AM Please respond to ORACLE-L I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Consistent gets
No problem as long as the stat no work - consistent read gets (v$sysstat) is also close to that number. Anjo. Stephane Faroult wrote: Has anybody any idea why a query against tables on which very few if any update are applied would display a high number of consistent gets ? Details : Big query involving 4/5 tables, most of them partitioned. This is a test database, db block buffers about 100M, 5,000,000 of logical reads with 8K blocks which means that the SGA is flushed a number of times. The execution plan starts with a partition scan, then a series of nested loops (hash join disappointing). The number of db block gets corresponds to the number of blocks read during the partition scan; everything else appears as consistent gets. You can rule out delayed cleanout, since the same behaviour is displayed when the same query is run over and over and not update at all takes place. Another curious symptom is that the number of rows returned per second decreases by a factor 3 or 4 between the beginning and the end of the query. Believe me, no hideous hidden scan of table of partition. TIA, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Have input displayed in sql worksheet output window
Hi All, Sql Worksheet 9.0.1 Win NT Is there a way in sql worksheet to have the commands issued in the input pane to show also in the output pane along with sql output. i.e., similar to sqlplus. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is differ
Fascinating. (attrib. Spock) Didn't know about that one. While we're on the subject, I don't recall if anyone mentioned this, but don't forget about updating the global_name table. -Original Message- Sent: Wednesday, October 09, 2002 10:40 AM To: Multiple recipients of list ORACLE-L or consider note: 174625.1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Table Scans
I am looking for a query that will allow me to find the SQL statements that are responsible for Full Table Scans. I understand that sometimes a full table scan is the best way to return data but I would like to evaluate this on a case by case basis. I use the following query to identify the Tables were recently accessed by a full table scan, however, that still leaves me with over 100 statements to trace. set serverout on size 100 set verify off col object_name form a30 SELECT distinct(o.object_name),o.object_type,o.owner FROM dba_objects o,x$bh x WHERE x.obj=o.object_id AND o.object_type='TABLE' AND standard.bitand(x.flag,524288)0 AND o.owner'SYS'; Thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sequence numbers
This was more of a defense question than anything I read the docs, but without knowing what volume we will be expecting, I don't want stuff being aged out either. I don't guess making the sequence_cache_entries double what I figure we will need will cause anything horrible... but It was put to me to try (without really TRYING) to determine what the ramifications were. I'm really not so worried about gaps... more loosing the lost numbers. This will be a warehouse, and with the way things are being defined, I think we could run out if we load the way we anticipate with the way these are being built. Some tables may not have any records loaded, or less than 100... but that may be client specific, too... Do you get the feeling that business rules should have come somewhat earlier in the project??? =) Thank you Thomas... April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Wednesday, October 09, 2002 10:54 AM To: Multiple recipients of list ORACLE-L If the sequence is not cached then Oracle has to generate a new sequence number for every record inserted (CPU cycles). NOORDER is the default so that won't slow you up. If you're doing bulk loads why not cache the sequence numbers? Is it important that there be no gaps? Even with NOCACHE you can get gaps. If a sequence number is generated but the row (insert or create) is not COMMITed the sequence number is not rolled back. Unless there are fewer than 100 rows to be inserted I'd go with some caching. April Wells awells To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @csedge.com cc: Sent by: rootSubject: sequence numbers 10/09/2002 10:54 AM Please respond to ORACLE-L I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE +;G0N#0H-@T*#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LMT's and DMT's in same database?
Dennis, I also am working towards converting my databases to LMT's. Do you have a doc/link on how you are doing this? Thanks, Dave -Original Message- Sent: Wednesday, October 09, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Dave - This shouldn't be a problem. I am gradually converting my tablespaces to LMT, but for relatively static tablespaces, I haven't had a reason to go in and rebuild yet. Yes, I know there is a procedure to convert a dictionary-managed to LMT, but I don't trust it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 8:54 AM To: Multiple recipients of list ORACLE-L I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9.2 on Red Hat 8.0
I'm going to try mandrake 9.0, which came out this week, with some 8i and 9i this week. I'll post a followup. Mandrake is basically rh with a better installer, actually one of the best installers I've seen ever! No ora support, just for fun. On Wed, Oct 09, 2002 at 07:43:40AM -0800, Bruce wrote: Oracle seems to change their official mind from time to time, but the reality is that RedHat 7.1 and 7.3 are the best versions to run with Oracle. I've had absolutely no problems with either version of the OS, and the installation and setup are well documented (both by Oracle and third-party sites). AS2 appears to have been targetted to Oracle, and installs super clean (the least amount of effort yet required). Good deal if you're looking for the top of the line configuration. I've tried installing 8.1.7 (my usual testbed) on RedHat 8.0 this past weekend and encountered some problems. It doesn't like Apache 2.0 in the mix, even though it doesn't use it. It has some problems getting the IP address, but I can fix that afterwards. The tough issues are which JDK (seems like 1.1.8 is the answer) and which compat- libs. I'm plowing through the compat- libs issue right now. Hopefully it will be fully installed and I can give some feedback as to how it runs in a week or so. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9.2 on Red Hat 8.0
the reality is that RedHat 7.1 and 7.3 are the best Is that a qualified opinion? ...based on your extensive experience and thorough testing with SuSE? :-) Others would debate with you... there's been a bit of discussion on this on the suse-oracle list: http://lists.suse.com/archive/suse-oracle/2002-Oct/ The SuSE 8/United Linux release coming out in November sounds very good. But who has time for exhaustive research? My gut feel is that both SuSE SLES-8 and RH Adv Server 2.1 will be very good. Competition AND open-source... wow, life is wonderful. And since Oracle is saving us so much money with its Linux support they can charge us more for licenses. ;-) -Original Message- Sent: Wednesday, October 09, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Oracle seems to change their official mind from time to time, but the reality is that RedHat 7.1 and 7.3 are the best versions to run with Oracle. I've had absolutely no problems with either version of the OS, and the installation and setup are well documented (both by Oracle and third-party sites). AS2 appears to have been targetted to Oracle, and installs super clean (the least amount of effort yet required). Good deal if you're looking for the top of the line configuration. I've tried installing 8.1.7 (my usual testbed) on RedHat 8.0 this past weekend and encountered some problems. It doesn't like Apache 2.0 in the mix, even though it doesn't use it. It has some problems getting the IP address, but I can fix that afterwards. The tough issues are which JDK (seems like 1.1.8 is the answer) and which compat- libs. I'm plowing through the compat- libs issue right now. Hopefully it will be fully installed and I can give some feedback as to how it runs in a week or so. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
cpu on AIX
I'm working on an AIX (4.3) box which seems to be CPU bound. vmstat and iostat -t both show idle cpu and iowait at 0%. User and system cpu are about 40/60. While trying to track down the source of this load, I looked at the %cpu (-o pcpu) of the processes. One process, spawned from an import, was using about 30% of the cpu. The sum of all pcpu obtained from ps doesn't break 35-40%. I am assuming that this is user cpu, and that the import process is using 3/4 of the user cpu. Since the import is io intensive, I am guessing it is also using a healthy chunk of the system cpu. Is there any way to track this down? Multiple applications (manned by different teams) run on the same server, and so the more I can irrefutably nail down, the better. Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sequence numbers
Order and noorder options are relevant only for the OPS/RAC configurations because that is the only way that the sequence numbers may be returned out of order. If the sequence is not cached, then you'll suffer a logical read and a physical write each time you query the sequence. What will be a performance impact? It depends primarily on you disk configuration, whether your database is a file system one or is it on raw devices and how much cache are you having on your disk controllers. -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Subject: Re: sequence numbers If the sequence is not cached then Oracle has to generate a new sequence number for every record inserted (CPU cycles). NOORDER is the default so that won't slow you up. If you're doing bulk loads why not cache the sequence numbers? Is it important that there be no gaps? Even with NOCACHE you can get gaps. If a sequence number is generated but the row (insert or create) is not COMMITed the sequence number is not rolled back. Unless there are fewer than 100 rows to be inserted I'd go with some caching. April Wells awells To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @csedge.com cc: Sent by: rootSubject: sequence numbers 10/09/2002 10:54 AM Please respond to ORACLE-L I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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-472 DBWR terminated
Are privileges of the oracle user and the directory where the alert log goes the same for all three databases? Henry -Original Message- Zanen Sent: Wednesday, October 09, 2002 6:43 AM To: Multiple recipients of list ORACLE-L creating a file solved the problem(actually renamed the alertlog back to original name) and it wasn't such a big deal. I am just wondering why two databases with similar setup and exact same versions on the same machine do not have the same problems. Creating a workaround for this database is not my first choice as this is a script that runs of a remote server and is standard for all UNIX databases. But if all else fails Thx Jack -Original Message- Sent: Wednesday, October 09, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround. If you've already done this what was the outcome? BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 09 October 2002 10:39 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel.:0251 268268 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an
RE: sequence numbers
Increasing sequence_cache_entries will minimize the demand for SQ enqueue that Oracle uses to internally bump the seq numbers. - Kirti -Original Message- Sent: Wednesday, October 09, 2002 11:29 AM To: Multiple recipients of list ORACLE-L This was more of a defense question than anything I read the docs, but without knowing what volume we will be expecting, I don't want stuff being aged out either. I don't guess making the sequence_cache_entries double what I figure we will need will cause anything horrible... but It was put to me to try (without really TRYING) to determine what the ramifications were. I'm really not so worried about gaps... more loosing the lost numbers. This will be a warehouse, and with the way things are being defined, I think we could run out if we load the way we anticipate with the way these are being built. Some tables may not have any records loaded, or less than 100... but that may be client specific, too... Do you get the feeling that business rules should have come somewhat earlier in the project??? =) Thank you Thomas... April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Wednesday, October 09, 2002 10:54 AM To: Multiple recipients of list ORACLE-L If the sequence is not cached then Oracle has to generate a new sequence number for every record inserted (CPU cycles). NOORDER is the default so that won't slow you up. If you're doing bulk loads why not cache the sequence numbers? Is it important that there be no gaps? Even with NOCACHE you can get gaps. If a sequence number is generated but the row (insert or create) is not COMMITed the sequence number is not rolled back. Unless there are fewer than 100 rows to be inserted I'd go with some caching. April Wells awells To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @csedge.com cc: Sent by: rootSubject: sequence numbers 10/09/2002 10:54 AM Please respond to ORACLE-L I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE +;G0N#0H-@T*#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City
RE: sequence numbers
LOL --- Actually, I can't laugh too much because this is, sadly, too true! April Wells awells To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @csedge.com cc: Sent by: rootSubject: RE: sequence numbers 10/09/2002 12:28 PM Please respond to ORACLE-L snip Do you get the feeling that business rules should have come somewhat earlier in the project??? =) Thank you Thomas... April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Wednesday, October 09, 2002 10:54 AM To: Multiple recipients of list ORACLE-L If the sequence is not cached then Oracle has to generate a new sequence number for every record inserted (CPU cycles). NOORDER is the default so that won't slow you up. If you're doing bulk loads why not cache the sequence numbers? Is it important that there be no gaps? Even with NOCACHE you can get gaps. If a sequence number is generated but the row (insert or create) is not COMMITed the sequence number is not rolled back. Unless there are fewer than 100 rows to be inserted I'd go with some caching. April Wells awells To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @csedge.com cc: Sent by: rootSubject: sequence numbers 10/09/2002 10:54 AM Please respond to ORACLE-L I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE +;G0N#0H-@T*#0H end -- Please see the official ORACLE-L FAQ:
RE: sequence numbers
I'm really not so worried about gaps... more loosing the lost numbers. This will be a warehouse, and with the way things are being defined, I think we could run out if we load the way we anticipate with the way these are being built. April, Do the math. :) I did this exercise once to allay developers and mgrs fears that using a sequence would cause problems down the road when the sequence 'ran out'. We standardized on a 12 digit integer for primary keys. 12 digits allows a maximum key value of (10 * 10^11)-1, or . If you were inserting 1000 rows per second, you sequence would run out of values in 9.999 seconds. ( ( 10 * 10^11 ) -1 ) / 1000 = 9.999 If your database did this 24*7 for 31.7 years, the sequence would indeed run out of values: 9.999 / ( 365 * 24 * 60 * 60 ) = 31.7 If that's not enough time, use more digits. The following ( very short ) perl script can help you determine how big is big enough. = #!/usrbin/perl my $secondsPerYear = 365 * 24 * 60 * 60; my $insertsPerSecond = 1000; foreach my $digits ( 12 .. 38 ) { my $yearsToExhaustion = ( ( ( 10 * 10**($digits-1) ) -1 ) / $insertsPerSecond ) / $secondsPerYear; printf(Digits: %3i Years: %36.4f\n, $digits, $yearsToExhaustion); } = Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 09:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: sequence numbers This was more of a defense question than anything I read the docs, but without knowing what volume we will be expecting, I don't want stuff being aged out either. I don't guess making the sequence_cache_entries double what I figure we will need will cause anything horrible... but It was put to me to try (without really TRYING) to determine what the ramifications were. I'm really not so worried about gaps... more loosing the lost numbers. This will be a warehouse, and with the way things are being defined, I think we could run out if we load the way we anticipate with the way these are being built. Some tables may not have any records loaded, or less than 100... but that may be client specific, too... Do you get the feeling that business rules should have come somewhat earlier in the project??? =) Thank you Thomas... April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Wednesday, October 09, 2002 10:54 AM To: Multiple recipients of list ORACLE-L If the sequence is not cached then Oracle has to generate a new sequence number for every record inserted (CPU cycles). NOORDER is the default so that won't slow you up. If you're doing bulk loads why not cache the sequence numbers? Is it important that there be no gaps? Even with NOCACHE you can get gaps. If a sequence number is generated but the row (insert or create) is not COMMITed the sequence number is not rolled back. Unless there are fewer than 100 rows to be inserted I'd go with some caching. April Wells awells To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @csedge.com cc: Sent by: rootSubject: sequence numbers 10/09/2002 10:54 AM Please respond to ORACLE-L I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: cpu on AIX
Henry - The issue isn't whether all the CPU is being used, but whether it is being used well. If the O.S. is handling priorities well, servicing your online users crisply, and just giving the excess CPU to a batch-type program, then that is okay. Do you think the O.S. should throw away 10% of the CPU for the heck of it? If users are experiencing sluggish response, then you have a tuning problem to diagnose. If you use STATSPACK, take a couple of snapshots and see what the waits are. If not, look at V$SESSION_EVENT. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I'm working on an AIX (4.3) box which seems to be CPU bound. vmstat and iostat -t both show idle cpu and iowait at 0%. User and system cpu are about 40/60. While trying to track down the source of this load, I looked at the %cpu (-o pcpu) of the processes. One process, spawned from an import, was using about 30% of the cpu. The sum of all pcpu obtained from ps doesn't break 35-40%. I am assuming that this is user cpu, and that the import process is using 3/4 of the user cpu. Since the import is io intensive, I am guessing it is also using a healthy chunk of the system cpu. Is there any way to track this down? Multiple applications (manned by different teams) run on the same server, and so the more I can irrefutably nail down, the better. Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LMT's and DMT's in same database?
Dave No particular strategy, other than using uniform extents. Using the Oracle guidelines, I created a tablespace with 128-k extents for small tables and one with 4-m extents for medium tables, with matching index tablespaces. Then I started moving tables to these tablespaces and rebuilding indexes to the index tablespaces. The large tables I've put in their own tablespaces, again following guidelines. My largest database is about 150-gig. total. As I've created or moved tables, I've stuck with this. I haven't yet moved some of the more static tables yet. I subscribe to the Lazy DBA theory that the more energy you put into certain activities, the more likely you will cause your own problems. Otherwise known as if it ain't broke, don't fix it. And when I've created 9iR2 databases, I've let Oracle create everything as LMT and used automatic undo. But not too much usage there yet, so I can't guarantee no problems there yet. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Dennis, I also am working towards converting my databases to LMT's. Do you have a doc/link on how you are doing this? Thanks, Dave -Original Message- Sent: Wednesday, October 09, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Dave - This shouldn't be a problem. I am gradually converting my tablespaces to LMT, but for relatively static tablespaces, I haven't had a reason to go in and rebuild yet. Yes, I know there is a procedure to convert a dictionary-managed to LMT, but I don't trust it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 8:54 AM To: Multiple recipients of list ORACLE-L I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: cpu on AIX
Dennis, Thanks for the response, and I agree that CPU is there to be used. If you have got it, you might as well use it (0% idle isn't necessarily a bad thing). However, 0% idle could also mean you need more than you've got, and the bottleneck is CPU. (IBM's doc says typically, the CPU is pacing (the system is CPU bound) if the sum of user and system time exceeds 90% of CPU resource on a single-user system or 80% on a multi-user system. This condition means that the CPU is the limiting factor in system performance). In this case, multiple applications are running on a single server. Application A is running slowly (wait states don't show any abnormal Oracle contention). The CPU seems to be the bottleneck slowing down the machine. One process running on Application B is using a large chunk of the CPU (~30%). I think it is using a lot more than this if you take the system io calls into account. The stronger the evidence, the easier it will be to get Application B to tune/reschedule their process. That is why I am trying to find the system CPU usage initiated by this user process. Henry -Original Message- WILLIAMS Sent: Wednesday, October 09, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Henry - The issue isn't whether all the CPU is being used, but whether it is being used well. If the O.S. is handling priorities well, servicing your online users crisply, and just giving the excess CPU to a batch-type program, then that is okay. Do you think the O.S. should throw away 10% of the CPU for the heck of it? If users are experiencing sluggish response, then you have a tuning problem to diagnose. If you use STATSPACK, take a couple of snapshots and see what the waits are. If not, look at V$SESSION_EVENT. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I'm working on an AIX (4.3) box which seems to be CPU bound. vmstat and iostat -t both show idle cpu and iowait at 0%. User and system cpu are about 40/60. While trying to track down the source of this load, I looked at the %cpu (-o pcpu) of the processes. One process, spawned from an import, was using about 30% of the cpu. The sum of all pcpu obtained from ps doesn't break 35-40%. I am assuming that this is user cpu, and that the import process is using 3/4 of the user cpu. Since the import is io intensive, I am guessing it is also using a healthy chunk of the system cpu. Is there any way to track this down? Multiple applications (manned by different teams) run on the same server, and so the more I can irrefutably nail down, the better. Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener Problem
Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta -an command: Following line is from dragon - the server that has the TNSLISTENER on only one interface 161.208.1.138.1521 *.*0 0 0 0 LISTEN Following line is from beowulf - the server that has the TNSLISTENER on all interfaces *.1521 *.*0 0 0 0 LISTEN He is focusing the ip address binding to the oracle port on one server but using a wild card for the other. We have a tar open for this but so far, they have not been too helpful. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9.2 on Red Hat 8.0
May I subscribe to the results of your undertaking? My home email is mailto:[EMAIL PROTECTED] May the force be with you. -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9.2 on Red Hat 8.0 I'm going to try mandrake 9.0, which came out this week, with some 8i and 9i this week. I'll post a followup. Mandrake is basically rh with a better installer, actually one of the best installers I've seen ever! No ora support, just for fun. On Wed, Oct 09, 2002 at 07:43:40AM -0800, Bruce wrote: Oracle seems to change their official mind from time to time, but the reality is that RedHat 7.1 and 7.3 are the best versions to run with Oracle. I've had absolutely no problems with either version of the OS, and the installation and setup are well documented (both by Oracle and third-party sites). AS2 appears to have been targetted to Oracle, and installs super clean (the least amount of effort yet required). Good deal if you're looking for the top of the line configuration. I've tried installing 8.1.7 (my usual testbed) on RedHat 8.0 this past weekend and encountered some problems. It doesn't like Apache 2.0 in the mix, even though it doesn't use it. It has some problems getting the IP address, but I can fix that afterwards. The tough issues are which JDK (seems like 1.1.8 is the answer) and which compat- libs. I'm plowing through the compat- libs issue right now. Hopefully it will be fully installed and I can give some feedback as to how it runs in a week or so. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Scans
I am curious about something in your query. SELECT distinct(o.object_name),o.object_type,o.owner FROM dba_objects o,x$bh x WHERE x.obj=o.object_id AND o.object_type='TABLE' AND standard.bitand(x.flag,524288)0 AND o.owner'SYS'; Where did you learn of the correct pattern for the AND standard.bitand(x.flag,524288)0 clause? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 pricing...
Not only applies for web based applications, but also for TP monitoring applications like CICS, Tuxedo, etc. Some clients actually priced the number of concurrent connections via these TP monitors versus the 10,000 or so users that use them. Ouch! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 09, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Subject:Re:Oracle pricing... Named User pricing is for individuals you can name. The Oracle installed users SYS, SYSTEM, DBSNMP, OUTLN, etc do not count. BTW: That does not mean that if one person at your company is on the day shift that they can pass their account on to someone on the night shift. In this case you have 2 named users and have to pay accordingly. Also don't ever, under any circumstances attach any type of WEB or transaction server to this database. You'll need CPU licensing for that. Oracle interprets Named Users very tightly. BTDT, OUCH!! Dick Goulet Reply Separator Author: Amar Kumar Padhi [EMAIL PROTECTED] Date: 10/9/2002 2:08 AM Hi, found the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. Product Named users Licence Processor Licence Oracle db(enterprise) 800 4 Oracle db(standard) 300 15000 Oracle db(personal) 400 -- rgds amar http://amzone.netfirms.com !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=x-user-defined META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEOracle pricing.../TITLE /HEAD BODY PFONT SIZE=2 FACE=Courier NewHi, /FONT BRFONT SIZE=2 FACE=Courier Newfound the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. /FONT/P PBFONT SIZE=2 FACE=Courier NewProductnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs p;n bsp;nbsp;nbsp;nbsp;nbsp;nbsp; Named users Licencenbsp;nbsp; Processor Licence/FONT/B BRFONT SIZE=2 FACE=Courier NewOracle db(enterprise)nbsp;nbsp;nbsp;nbsp; 800nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp; 4nbsp;nbsp; /FONT BRFONT SIZE=2 FACE=Courier NewOracle db(standard)nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 300nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp; 15000/FONT BRFONT SIZE=2 FACE=Courier NewOracle db(personal)nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 400nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp; -- /FONT /P PFONT COLOR=#00 SIZE=2 FACE=Courierrgds/FONT BRFONT COLOR=#00 SIZE=2 FACE=Courieramar/FONT BRFONT COLOR=#00 FACE=ScriptA HREF=http://amzone.netfirms.com; TARGET=_blankhttp://amzone.netfirms.com/A/FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
Jay - I share your concerns. Can you elaborate more on how heavily loaded the system is? Is it somewhat I/O bound? Basically you're saying that it would have a single RAID0 set? If you divided the disks differently to create 2 or 4 RAID sets, would there be enough room for your application? I've run Oracle systems with a single RAID set, but not with a significant load. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Consistent gets
Anjo, Why do they appear in the first place? Jared Anjo Kolk [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 09:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Consistent gets No problem as long as the stat no work - consistent read gets (v$sysstat) is also close to that number. Anjo. Stephane Faroult wrote: Has anybody any idea why a query against tables on which very few if any update are applied would display a high number of consistent gets ? Details : Big query involving 4/5 tables, most of them partitioned. This is a test database, db block buffers about 100M, 5,000,000 of logical reads with 8K blocks which means that the SGA is flushed a number of times. The execution plan starts with a partition scan, then a series of nested loops (hash join disappointing). The number of db block gets corresponds to the number of blocks read during the partition scan; everything else appears as consistent gets. You can rule out delayed cleanout, since the same behaviour is displayed when the same query is run over and over and not update at all takes place. Another curious symptom is that the number of rows returned per second decreases by a factor 3 or 4 between the beginning and the end of the query. Believe me, no hideous hidden scan of table of partition. TIA, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
This one is so easy that even a high school student could answer it. Use the theory of constraints (book called The Goal) to this one. When you reduce the number of resources to process a job, sequentially or concurrently, you induce bottlenecks within the process. Thus, by reducing the number of available spindles, you reduce the overall capabilities of the system. Not hard to accomplish. All of the vendors sell their caching technology as a way to avoid bottlenecks. First, shoot the sales rep from Sun and make him explain all of the performance bottlenecks to the CEO. Next, buy more disk. I truly wish disk vendors would stop increasing the minimum storage amount for disks, selling that to CIO's as a way to perform server consolidation, and then not taking the blame for the performance mess. Cache does not work, never worked and will never continue to work until the pipeline is the same size. Use basic theories and you will see the light. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 09, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Scans
Jay: The other option is to look for 'db file scattered read' waits and join with dba_extents/segments to get the segments which are accessed via full table scan. This would be better alternate since you don't need to scan the entire buffer cache to get the names of the segments whose blocks are read to the buffer cache via sequential scan. Best Regards, K Gopalakrishnan http://www.oradebug.com -Original Message- (DBA) Sent: Wednesday, October 09, 2002 9:34 AM To: Multiple recipients of list ORACLE-L I am looking for a query that will allow me to find the SQL statements that are responsible for Full Table Scans. I understand that sometimes a full table scan is the best way to return data but I would like to evaluate this on a case by case basis. I use the following query to identify the Tables were recently accessed by a full table scan, however, that still leaves me with over 100 statements to trace. set serverout on size 100 set verify off col object_name form a30 SELECT distinct(o.object_name),o.object_type,o.owner FROM dba_objects o,x$bh x WHERE x.obj=o.object_id AND o.object_type='TABLE' AND standard.bitand(x.flag,524288)0 AND o.owner'SYS'; Thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Scans
http://www.think-forward.com/sql/bufferts.htm -Original Message- Sent: Wednesday, October 09, 2002 4:00 PM To: Multiple recipients of list ORACLE-L I am curious about something in your query. SELECT distinct(o.object_name),o.object_type,o.owner FROM dba_objects o,x$bh x WHERE x.obj=o.object_id AND o.object_type='TABLE' AND standard.bitand(x.flag,524288)0 AND o.owner'SYS'; Where did you learn of the correct pattern for the AND standard.bitand(x.flag,524288)0 clause? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 on AIX
Henry - Here are my reactions, and hopefully someone that knows how to track system CPU usage back to an application will reply. One thought I have is to run each application on a test server and observe the system I/O there. I haven't tried this. Other thoughts: 1) Are interactive users complaining? If they are, then you have a definite problem. 2) In terms of maxing out the CPU, does this situation continue for long periods of time? For example, I have a financial system that is overloaded at the first of the month, but underutilized the rest of the month. But another system simply couldn't process everything they needed each day, so we had to do something. In that case the users ceased running some reports. 3) I looked in Oracle Performance Tuning 101 to see what Gaja has to say. He points out that the Solaris sar -q command has a %wio column, a measure of processes that are currently using the CPU, but are waiting for I/O requests to be serviced and hence are not making prudent use of the CPU. He further says that %sys and %wio should be less than 10-15% and if it is consistently higher you need to get to the bottom of it, and usually it is a application causing the problem. No details on how to get to the bottom. 4) Maybe you can get some type of O.S. audit that can report what system calls are being made, and that will give you a clue. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Dennis, Thanks for the response, and I agree that CPU is there to be used. If you have got it, you might as well use it (0% idle isn't necessarily a bad thing). However, 0% idle could also mean you need more than you've got, and the bottleneck is CPU. (IBM's doc says typically, the CPU is pacing (the system is CPU bound) if the sum of user and system time exceeds 90% of CPU resource on a single-user system or 80% on a multi-user system. This condition means that the CPU is the limiting factor in system performance). In this case, multiple applications are running on a single server. Application A is running slowly (wait states don't show any abnormal Oracle contention). The CPU seems to be the bottleneck slowing down the machine. One process running on Application B is using a large chunk of the CPU (~30%). I think it is using a lot more than this if you take the system io calls into account. The stronger the evidence, the easier it will be to get Application B to tune/reschedule their process. That is why I am trying to find the system CPU usage initiated by this user process. Henry -Original Message- WILLIAMS Sent: Wednesday, October 09, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Henry - The issue isn't whether all the CPU is being used, but whether it is being used well. If the O.S. is handling priorities well, servicing your online users crisply, and just giving the excess CPU to a batch-type program, then that is okay. Do you think the O.S. should throw away 10% of the CPU for the heck of it? If users are experiencing sluggish response, then you have a tuning problem to diagnose. If you use STATSPACK, take a couple of snapshots and see what the waits are. If not, look at V$SESSION_EVENT. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I'm working on an AIX (4.3) box which seems to be CPU bound. vmstat and iostat -t both show idle cpu and iowait at 0%. User and system cpu are about 40/60. While trying to track down the source of this load, I looked at the %cpu (-o pcpu) of the processes. One process, spawned from an import, was using about 30% of the cpu. The sum of all pcpu obtained from ps doesn't break 35-40%. I am assuming that this is user cpu, and that the import process is using 3/4 of the user cpu. Since the import is io intensive, I am guessing it is also using a healthy chunk of the system cpu. Is there any way to track this down? Multiple applications (manned by different teams) run on the same server, and so the more I can irrefutably nail down, the better. Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL
Re: Advice needed on move to Sun 15K (losing spindles)
Jay, You will hit performance problems because of not having I/O bandwidth. Databases don't need storage, they need IO operations. Two important pieces of info that are missing from your post: - How many databases in total are going to run on this Sun 15K ? - How many concurrent users on all databases at the same time ? Anjo. Miller, Jay wrote: Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Packed decimal
Hi, Is there any way to identify values in a field, defined in Oracle as number(11,2), with a packed decimal format? Or to update the field with packed decimal values? Thanks, Russ
update statistics
What is the equivalent in Oracle of the Informix UPDATE STATISTICS? Thanks much. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Scans
That is correct, but I do think that everybody wants to know how did you get that number (512k) and where can we find more info about that. -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Table Scans Jay: The other option is to look for 'db file scattered read' waits and join with dba_extents/segments to get the segments which are accessed via full table scan. This would be better alternate since you don't need to scan the entire buffer cache to get the names of the segments whose blocks are read to the buffer cache via sequential scan. Best Regards, K Gopalakrishnan http://www.oradebug.com -Original Message- (DBA) Sent: Wednesday, October 09, 2002 9:34 AM To: Multiple recipients of list ORACLE-L I am looking for a query that will allow me to find the SQL statements that are responsible for Full Table Scans. I understand that sometimes a full table scan is the best way to return data but I would like to evaluate this on a case by case basis. I use the following query to identify the Tables were recently accessed by a full table scan, however, that still leaves me with over 100 statements to trace. set serverout on size 100 set verify off col object_name form a30 SELECT distinct(o.object_name),o.object_type,o.owner FROM dba_objects o,x$bh x WHERE x.obj=o.object_id AND o.object_type='TABLE' AND standard.bitand(x.flag,524288)0 AND o.owner'SYS'; Thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Packed decimal
Oracle uses a proprietary field format for numbers. I dont think it is packed decimal, however, I believe most of the Cobol or PL/I programs I wrote against Oracle RDBMS on the mainframe used Packed Decimal to represent number fields. You can use the SIGN function to determine the sign of the value, if thats what you are looking for. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Brooks, Russ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Subject: Packed decimal Hi, Is there any way to identify values in a field, defined in Oracle as number(11,2), with a packed decimal format? Or to update the field with packed decimal values? Thanks, Russ The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
Re: Is it possible to copy one db to another if the SID is different
CHAN Chor Ling Catherine (CSC) wrote: Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I followed the instructions on Metalink doc 135792.1 Cloning Oracle Applications Release 11I. Everything works fine until I re-create the controlfile in the target instance. In svrmgrl = STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 ( '/dg3/oracle/testredo/log01a.dbf', '/dg4/oracle/testredo/log01b.dbf' ) SIZE 10M DATAFILE '/dg7/oracle/testdata/system01.dbf', '/dg7/oracle/testdata/system02.dbf', ... '/dg8/oracle/testdata/ctxd01.dbf', . CHARACTER SET US7ASCII CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST Any advice ? Thanks. (Please reply to [EMAIL PROTECTED]) Regds, New Bee -- Catherine, It IS possible, I have done it a number of times, although long ago. Out the top of my head I think that the problem is with the REUSE after the CREATE CONTROL FILE. It doesn't pertain to the files, creating a control file will not do anything to the data files (you probably feared overwriting them). And afterwards you need an ALTER DATABASE to change the global name. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener Problem
Magically, it's fixed. No one has 'fessed up' but it is definietly not an Oracle problem. --- Peter Barnett [EMAIL PROTECTED] wrote: Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta -an command: Following line is from dragon - the server that has the TNSLISTENER on only one interface 161.208.1.138.1521 *.*0 0 0 0 LISTEN Following line is from beowulf - the server that has the TNSLISTENER on all interfaces *.1521 *.*0 0 0 0 LISTEN He is focusing the ip address binding to the oracle port on one server but using a wild card for the other. We have a tar open for this but so far, they have not been too helpful. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Making a tablespace read-only - identifying blocking tx
I am creating a stored proc that will export a tablespace. One task it needs to perform is to place the tablespace(s) in read only mode to make a copy. Based upon the application and proc logic, there should not be any transactions against objects in the ts. However, if there are, the ALTER TABLESPACE command will wait until the transaction is completed. I would rather have the ALTER TABLESPACE command fail immediately. If I cannot do that, I would like to be able to test for locks on objects in the tablespace (figured that one out, but it is rather kludgy). Is there a method to force an immediate failure of ALTER TABLESPACE tsname READ ONLY if it cannot be immediatly completed? Is there a clean method/proc to determine if the ALTER TABLESPACE command will work? Dan Fink
Re: Advice needed on move to Sun 15K (losing spindles)
Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cache hit ratio?
Hi One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I have noticed after week again cache hit ratio became low. Can u please suggest what other things I can do to fix this problem? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
SOLARIS to linux
Hi Can any one share data migration from sun solaris to linux ? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Listener Problem
As luck would have it, we just went through a similar problem. Does the listener actually startup? Can you stop and restart it manually using lsnrctl? Ours wouldn't. We tracked it down to two problems, both security related. The one that was hampering our listener was a change in /etc/nsswitch.conf that caused a change in the way that the listener tried to listen on the port. Specifically, look for differences in the protocols line and the services line. Also, potentially, the ipnodes line. We were installing LDAP and had changed these lines to ldap [NOTFOUND=return] files, but the listener just didn't like it, so we changed them back to just files. Also, the only time we'd see a problem is in the start and stop of the listener. If we changed the files back to ldap... while the listener was up, connections worked fine. We just couldn't start it back up if it was shutdown. Barring this, check for security differences in your bin and network dir trees under $ORACLE_HOME. Check for owner, group and protection bits. HTH! GL! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Peter Barnett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: Listener Problem Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta -an command: Following line is from dragon - the server that has the TNSLISTENER on only one interface 161.208.1.138.1521 *.*0 0 0 0 LISTEN Following line is from beowulf - the server that has the TNSLISTENER on all interfaces *.1521 *.*0 0 0 0 LISTEN He is focusing the ip address binding to the oracle port on one server but using a wild card for the other. We have a tar open for this but so far, they have not been too helpful. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cache hit ratio?
Seema Singh wrote: Hi One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I have noticed after week again cache hit ratio became low. Can u please suggest what other things I can do to fix this problem? Thx -Seema Use Connor's script. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cache hit ratio?
If u r not kidding then attend hotsos clinic. r u sure u r not kidding can u catch the session which is not performing as it should from the end users perspective? get the top 5 wait events for that session. -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: Cache hit ratio? Hi One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I have noticed after week again cache hit ratio became low. Can u please suggest what other things I can do to fix this problem? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Making a tablespace read-only - identifying blocking tx
Here's an even more kludgy guess. Maybe you can execute the alter tablespace in the pl/sql job queue. If it runs too long (how long is too long?), then you know that it's waiting (i.e., failing), and you could do something appropriate action? Fink, Dan [EMAIL PROTECTED]@fatcity.com on 10/09/2002 04:48:54 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I am creating a stored proc that will export a tablespace. One task it needs to perform is to place the tablespace(s) in read only mode to make a copy. Based upon the application and proc logic, there should not be any transactions against objects in the ts. However, if there are, the ALTER TABLESPACE command will wait until the transaction is completed. I would rather have the ALTER TABLESPACE command fail immediately. If I cannot do that, I would like to be able to test for locks on objects in the tablespace (figured that one out, but it is rather kludgy). Is there a method to force an immediate failure of ALTER TABLESPACE tsname READ ONLY if it cannot be immediatly completed? Is there a clean method/proc to determine if the ALTER TABLESPACE command will work? Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cache hit ratio?
There is a script available (search the archives) that will set the ratio to anything you want... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 10/09/02 02:13 PMcc: Please respond toSubject: Cache hit ratio? ORACLE-L Hi One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I have noticed after week again cache hit ratio became low. Can u please suggest what other things I can do to fix this problem? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN and TSM
I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Problem
Hmmm...check the dates on your /etc/*.conf files! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Peter Barnett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject: Re: Listener Problem Magically, it's fixed. No one has 'fessed up' but it is definietly not an Oracle problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Making a tablespace read-only - identifying blocking tx
Title: Message Just a slight correction it will wait until any transaction against the entire database, not just the tablespaceis completed. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: Making a tablespace read-only - identifying blocking tx I am creating a stored proc that will export a tablespace. One task it needs to perform is to place the tablespace(s) in read only mode to make a copy. Based upon the application and proc logic, there should not be any transactions against objects in the ts. However, if there are, the ALTER TABLESPACE command will wait until the transaction is completed. I would rather have the ALTER TABLESPACE command fail immediately. If I cannot do that, I would like to be able to test for locks on objects in the tablespace (figured that one out, but it is rather kludgy). Is there a method to force an immediate failure of ALTER TABLESPACE tsname READ ONLY if it cannot be immediatly completed? Is there a clean method/proc to determine if the ALTER TABLESPACE command will work? Dan Fink
DROP DEVELOPER not working
We have a developer here, installing a third party application, who claims one of his delete campaign process is hanging. I looked at the wait events, saw nothing, and asked him to politely to go look at the code. After much analysys, the developer now complains, that Oracle is not executing a drop table command at the end of the process, and hanging there. He claims he can drop the table from SQLPLUS. I asked him to rerun the process. I noticed no wait events for that session in v$session_wait when he claims the process is hanging. I see no DROP statements in the v$sqlarea. I did a 10046 trace, and the last statement in the trace file is a select statement. I looked at the sql addresses from v$session, linked it to v$sqlarea and the sql_text shows the same select statement as is seen in the trace file. I see no exclusive locks on the said table. I conclude that the application is not sending a DROP statement to Oracle for execution. He claims that cannot be the case. They have done the same installation in a test environment and it worked fine. The jury seems to be taking sides. I scream SOS. What more should I be doing? And Does an Oracle 10046 trace write into the trace file after the statement has executed? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is it possible to copy one db to another if the SID is different
Dear New Bee: We do this all the time, and the problem you're having is the one that I tripped over my first time, too. There is an important word missing from your command. It's not... CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG ...it is ... CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS ARCHIVELOG ^^^ And when you ALTER DATABASE OPEN you'll also need to say RESETLOGS. HTH, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: update statistics
Saira I'm assuming that Informix UPDATE STATISTICS analyzes the data in a table or multiple tables and makes fresh data available for the cost-based analyzer. If that is true, the answer depends somewhat on the version of Oracle you are using. The simple answer is to enter the statement: ANALYZE TABLE table_name ESTIMATE STATISTICS; That works on all Oracle versions, but is a little difficult to automate. Do not ever analyze Oracle tables owned by SYS. On newer Oracle versions, you can take a look at the DBMS_STATS package. It can analyze all tables in a schema with a single command. It also uses fewer resources than ANALYZE. This has had a few bugs in certain Oracle versions, like analyzing SYS tables, so check out the comments that people have made about it. But if your intention is to analyze all your tables regularly, this is probably what you will want to use. For Lawson, I don't think analyzing the tables is critical. Lawson adds a hint to each query, and Oracle takes the hint. But if you are using a report generator outside Lawson, you may want to make this a practice. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 2:50 PM To: Multiple recipients of list ORACLE-L What is the equivalent in Oracle of the Informix UPDATE STATISTICS? Thanks much. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).