RE: OFA and RAC on raw devices
Gilles, What about the OFA admin subtree (create, pfile, udump,bdump..) ? Did you duplicate it on each node ? Each node will have its own ADMIN subtree (/u01/app/oracle/admin/prod/). Make sure the following parameters are configured in INIT.ORA file: # First instance specific parameters db1.local_listener=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) db1.thread=1 db1.instance_name=db1 db1.instance_number=1 db1.remote_listener = listener_db2 db1.undo_tablespace = UNDOTBS1 db1.log_archive_dest_1 = 'location=/archdb1/prod mandatory' # Second instance specific parameters db2.local_listener=(ADDRESS=(PROTOCOL=TCP)(HOST=x)(PORT=1521)) db2.thread=2 db2.instance_name = db2 db2.instance_number = 2 db2.remote_listener = listener_db1 db2.undo_tablespace = UNDOTBS2 db2.log_archive_dest_1 = 'location=/archdb2/prod mandatory' What are the steps in Service Guard to configure failover File system ? System Administrator created the Failover File system at OS level. Do you use RMAN for backups? if yes with autolocate 9i feature ? Yes I am using RMAN..it is a complicated setup. If you used soft links for datafiles, it means you have some sort of /oradata/db_name/ structure on each node. Right? Yes. For example if I am using /u01/oradata/prod/ then make sure you have exactly same file system on both nodes so that database will recognize the datafiles on each node otherwise it will fail. Does this prove helpful? Yes. Muqthar Ahmed DBA -Original Message- Sent: Wednesday, November 19, 2003 5:20 PM To: Multiple recipients of list ORACLE-L Hi Muqthar , thanks for you reply. Some more precisions : What about the OFA admin subtree (create, pfile, udump,bdump..) ? Did you duplicate it on each node ? What are the steps in Service Guard to configure failover File system ? Do you use RMAN for backups ? if yes with autolocate 9i feature ? If you used soft links for datafiles, it means you have some sort of /oradata/db_name/ structure on each node. Right ? Does this prove helpful ? Regards At 06:05 19/11/2003 -0800, you wrote: Gilles, RAC Configuration: 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File System) I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM. 3. UNDO (RAW FILES) - Each node will have its own UNDO. We have STRIPED RAID1+0 to have good performance. Database is not pointing to RAW FILES directly. I have created SOFT LINKS to point to RAW FILES. I have created TABLESPACE using SOFT LINKS. Muqthar Ahmed -Original Message- Sent: Wednesday, November 19, 2003 1:55 AM To: Multiple recipients of list ORACLE-L Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
RE: OFA and RAC on raw devices
Gilles, RAC Configuration: 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File System) I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM. 3. UNDO (RAW FILES) - Each node will have its own UNDO. We have STRIPED RAID1+0 to have good performance. Database is not pointing to RAW FILES directly. I have created SOFT LINKS to point to RAW FILES. I have created TABLESPACE using SOFT LINKS. Muqthar Ahmed -Original Message- Sent: Wednesday, November 19, 2003 1:55 AM To: Multiple recipients of list ORACLE-L Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: Logical StandBy question
Juan, I am using Physical Standby Database for Disaster Recovery situation andalso forREPORTS. I apply logs everyday in the morning and bring it up in READ ONLY mode. Developers can SELECT latest data from STANDBY database. I have created a DATABASE LINK for STANDBY database from X database. Now you can create REPORTSin X database by SELECTING data from STANDBY database. Less maintenance, reliable and good performance. The only disadvantage is STANDBY database is one day behind. Muqthar Ahmed DBA -Original Message-From: Juan Miranda [mailto:[EMAIL PROTECTED]Sent: Thursday, November 13, 2003 3:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Re: Logical StandBy question I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.) I didn´t kwon that LSB are so bad. So do you think It is so bad that you don´t put it into production ??? Do you try 9.2.0.4 ?? I need to take a decision I thankyour previous answers. (I read doc, of course, but It is not explicity say that) -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]En nombre de Carel-Jan EngelEnviado el: miércoles, 12 de noviembre de 2003 19:59Para: Multiple recipients of list ORACLE-LAsunto: RE: Re: Logical StandBy questionWalt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm.I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening.regards, Carel-JanAt 09:19 12-11-03 -0800, you wrote: Stephane,What sort of problems can one expect from logical standby?I'm toying with the idea of using it as a replication database -- noadditional schema objects will be created, but users will have read-onlyaccess to it. It's one of the options I'm looking at.Seems to me like there was a thread on this a few months ago, but I'mnot sure...--WaltOn Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. --Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Walt Weaver INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C2743 BX WaddinxveenThe Netherlandstel. +31 (0) 182 640 428fax +31 (0) 182 640 429mobile+31 (0) 653 911 950e-mail [EMAIL PROTECTED]
RE: Logical StandBy question
Juan, How can you create Schema in STANDBY database that does not exist in Primiary database?? Can you give me an example? Muqthar Ahmed -Original Message- Sent: Wednesday, November 12, 2003 8:24 AM To: Multiple recipients of list ORACLE-L yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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[2]: Sequences in OPS/RAC
Hi, I have RAC and I always use ORDER when I create SEQUENCE. The following information is from Oracle Manual: ORDER is necessary only to guarantee ordered generation if you are using Oracle with Real Application Clusters. If you are using exclusive mode, sequence numbers are always generated in order. Muqthar Ahmed -Original Message- Sent: Monday, November 03, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Hello Hemant, Monday, November 3, 2003, 11:29:26 AM, you wrote: HKC However, the Builder.Com article quite explicity asserts HKC Sequence generator numbers are guaranteed to be unique only for a single HKC instance, which is unsuitable for use as a primary key in parallel or HKC remote environments, where a sequence in each environment might generate HKC the same number and result in conflicts Can you point us to the article? My guess is that the author is not familiar with Oracle, and is basing the above statement on his experience with some other database (DB2 perhaps?). There is no problem with using sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clone db 9.2 on AIX 5L
Veronica, There are two different types of installation CDs for Oracle 8.1.7: 1. Oracle 8.1.7 64-bit and 2. Oracle 8.1.7 Oracle cerfitied 8.1.7(32-bit) for 5L not for Oracle 8.1.6 64-bit. If you have Oracle 8.1.7(32-bit), then you can upgrade AIX 4.3.3 to AIX 5L: 1. Upgrade OS from AIX 4.3.3 to AIX 5L 2. Install the following AIX 5L OS patches as required by the Installation Guide, refer to Note: 169706.1: IY26778(5100-01) IY28766(5100-01) IY28949(5100-01) IY29965(5100-02) IY30150(5100-02) Maint Level 1 and IY22854 Required OS packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat 3. Install Oracle 8.1.7 for AIX 5L from CDs into new ORACLE_HOME 4. Copy init.ora to new ORACLE_HOME and modify the init.ora to change dump directories, 5. Setup your environment to point to new ORACLE_HOME and start the databases. I would recommend you to open a TAR with Oracle Support. Muqthar Ahmed -Original Message- Sent: Friday, October 31, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Hi Muqthar , I am planning to upgrade from AIX 4.3.3 to AIX 5L (5.2), but I am not planning to upgrade Oracle. I am at 8.1.7.2 and can't upgrade to 9i yet due to applications compatibility Do I have to upgrade Oracle to 9i if I upgrade AIX to 5L I understand Oracle 8.1.7.2 can run on AIX 5L at 32 bits without problems. Saludos, Verónica Levin Enríquez GTI Compañía Cervecera de Nicaragua -Mensaje original- De: Muqthar Ahmed [mailto:[EMAIL PROTECTED] Enviado el: Tuesday, October 28, 2003 12:00 PM Para: Multiple recipients of list ORACLE-L Asunto: RE: Clone db 9.2 on AIX 5L Hi, You DO NOT have to CLONE the databases if you are upgrading the OS from 4.3.3 to 5L. You mentioned that the instances are already running. IBM has break the technology at AIX 5.1.0.0, meaning the AIX 4.3.3 and AIX 5.1.0.0 have different architecture. So if you are upgrading IBM AIX 4.3.3 to AIX 5.1.0.0, you also have to upgrade Oracle at the same time. Oracle 9.2 CDs are separate for IBM AIX 4.3.3 and IBM AIX 5.1.0.0. If you are in this situation, all you have to is shutdown all databases, install Oracle 9.2 with 5L CDs in new ORACEL HOME and setup your environment with new ORACLE HOME to start your existing databases. Muqthar Ahmed -Original Message- Sent: Tuesday, October 28, 2003 11:49 AM To: Multiple recipients of list ORACLE-L SQL @cr_spap SQL STARTUP NOMOUNT pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora ORA-03113: end-of-file on communication channel SQL CREATE CONTROLFILE REUSE DATABASE SPAP RESETLOGS NOARCHIVELOG 2 MAXLOGFILES 50 3 MAXLOGMEMBERS 5 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 226 7 LOGFILE 8 GROUP 1 '/iu33/u02/oradata/spap/redo01.log' SIZE 100M, 9 GROUP 2 '/iu33/u02/oradata/spap/redo02.log' SIZE 100M, 10 GROUP 3 '/iu33/u02/oradata/spap/redo03.log' SIZE 100M 11 DATAFILE 12 '/iu33/u02/oradata/spap/system01.dbf', 13 '/iu33/u02/oradata/spap/undotbs01.dbf', 14 '/iu33/u02/oradata/spap/drsys01.dbf', 15 '/iu33/u02/oradata/spap/example01.dbf', 16 '/iu33/u02/oradata/spap/odm01.dbf', 17 '/iu33/u02/oradata/spap/tools01.dbf', 18 '/iu33/u02/oradata/spap/users01.dbf', 19 '/iu33/u02/oradata/spap/xdb01.dbf', 20 '/iu33/u02/oradata/spap/users02.dbf', 21 '/iu33/u02/oradata/spap/users03.dbf', 22 '/iu33/u02/oradata/spap/users04.dbf', 23 '/iu33/u02/oradata/spap/users05.dbf', 24 '/iu33/u02/oradata/spap/indexes01.dbf', 25 '/iu33/u02/oradata/spap/indexes02.dbf', 26 '/iu33/u02/oradata/spap/indexes03.dbf' 27 CHARACTER SET WE8ISO8859P1 28 ; CREATE CONTROLFILE REUSE DATABASE SPAP RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-03114: not connected to ORACLE SQL -- RECOVER DATABASE SQL -- ALTER DATABASE OPEN; SQL -- ALTER TABLESPACE TEMP ADD TEMPFILE '/iu33/u02/oradata/spap/temp01.dbf' SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ; SQL The confusing thing is that I have instances already running on the machine. So I know the install is ok. I can start/shutdown the existing instances no problem. But when I try to clone and startup --- I get the results from above. -Original Message- Sent: Monday, October 27, 2003 5:24 PM To: [EMAIL PROTECTED] When are you getting the error? During startup? Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup controlfile to trace -- edited for the new file locations keeping the SID the same created init.ora from spfile startup nomount pfile=init.ora getting ora-3113 I have a TAR opened and figured I would check out here as well. -Original Message- [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:44 PM To: Multiple recipients of list ORACLE-L How about some more
RE: Execution Plan is good but HIGH CPU
Jared, The output is from TKPROF. Muqthar -Original Message- Sent: Tuesday, October 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Have you run SQLTRACE on this query? The detail in the trace file will show where the cpu is being consumed. There is insufficient data in the summary to reach any conclusion. Jared On Mon, 2003-10-27 at 21:24, Muqthar Ahmed wrote: Hi, Execution plan looks good but the query is consuming 800 seconds CPU timewhy? SELECT sampleavail, sample_cost_amount, sample_sale_amount, discount_room, discount_case, discount_half_case, allow_cut, retail_cut_amount, cost_cut_amount, gp_room from tbljnwpbookvendortype t1, tbljnwpbookvendor t2 where t1.jnwpbvid = t2.jnwpbvid and t2.prsuid = :b3 and t2.wpbkid = :b2 and t1.wpptid = :b1 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 5618 0.63 0.58 0 0 0 0 Fetch 5617800.05 782.07 01409683 04187 --- -- -- -- -- -- -- total11236800.68 782.66 01409683 04187 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 109 (DDTBL) (recursive depth: 1) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 NESTED LOOPS 0TABLE ACCESS (BY INDEX ROWID) OF 'TBLJNWPBOOKVENDOR' 0 INDEX (UNIQUE SCAN) OF 'TBLJNWPBOOKVENDOR_UQ1' (UNIQUE) 0TABLE ACCESS (BY INDEX ROWID) OF 'TBLJNWPBOOKVENDORTYPE' 0 INDEX (RANGE SCAN) OF 'TBLJNWPBOOKVENDORTYPE_IDX1' (NON-UNIQUE) Muqthar Ahmed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Execution Plan is good but HIGH CPU
Hi, The developer was executing the SQL statement in the loop in procedure. After re-writing the code, now the performance is good. Thanks Muqthar Ahmed -Original Message- Sent: Tuesday, October 28, 2003 8:09 AM To: Multiple recipients of list ORACLE-L It's 800 sec for 5617 exec/fetch calls. It looks like it's a sql inside a cursor loop or stored proc that gets called from some app. If you are unhappy, try to get rid of the cursor logic and get everything done in one sql call. Waleed -Original Message- Sent: Tuesday, October 28, 2003 12:24 AM To: Multiple recipients of list ORACLE-L Hi, Execution plan looks good but the query is consuming 800 seconds CPU timewhy? SELECT sampleavail, sample_cost_amount, sample_sale_amount, discount_room, discount_case, discount_half_case, allow_cut, retail_cut_amount, cost_cut_amount, gp_room from tbljnwpbookvendortype t1, tbljnwpbookvendor t2 where t1.jnwpbvid = t2.jnwpbvid and t2.prsuid = :b3 and t2.wpbkid = :b2 and t1.wpptid = :b1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 5618 0.63 0.58 0 0 0 0 Fetch 5617800.05 782.07 01409683 0 4187 --- -- -- -- -- -- -- total11236800.68 782.66 01409683 0 4187 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 109 (DDTBL) (recursive depth: 1) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 NESTED LOOPS 0TABLE ACCESS (BY INDEX ROWID) OF 'TBLJNWPBOOKVENDOR' 0 INDEX (UNIQUE SCAN) OF 'TBLJNWPBOOKVENDOR_UQ1' (UNIQUE) 0TABLE ACCESS (BY INDEX ROWID) OF 'TBLJNWPBOOKVENDORTYPE' 0 INDEX (RANGE SCAN) OF 'TBLJNWPBOOKVENDORTYPE_IDX1' (NON-UNIQUE) Muqthar Ahmed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clone db 9.2 on AIX 5L
Hi, You DO NOT have to CLONE the databases if you are upgrading the OS from 4.3.3 to 5L. You mentioned that the instances are already running. IBM has break the technology at AIX 5.1.0.0, meaning the AIX 4.3.3 and AIX 5.1.0.0 have different architecture. So if you are upgrading IBM AIX 4.3.3 to AIX 5.1.0.0, you also have to upgrade Oracle at the same time. Oracle 9.2 CDs are separate for IBM AIX 4.3.3 and IBM AIX 5.1.0.0. If you are in this situation, all you have to is shutdown all databases, install Oracle 9.2 with 5L CDs in new ORACEL HOME and setup your environment with new ORACLE HOME to start your existing databases. Muqthar Ahmed -Original Message- Sent: Tuesday, October 28, 2003 11:49 AM To: Multiple recipients of list ORACLE-L SQL @cr_spap SQL STARTUP NOMOUNT pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora ORA-03113: end-of-file on communication channel SQL CREATE CONTROLFILE REUSE DATABASE SPAP RESETLOGS NOARCHIVELOG 2 MAXLOGFILES 50 3 MAXLOGMEMBERS 5 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 226 7 LOGFILE 8 GROUP 1 '/iu33/u02/oradata/spap/redo01.log' SIZE 100M, 9 GROUP 2 '/iu33/u02/oradata/spap/redo02.log' SIZE 100M, 10 GROUP 3 '/iu33/u02/oradata/spap/redo03.log' SIZE 100M 11 DATAFILE 12 '/iu33/u02/oradata/spap/system01.dbf', 13 '/iu33/u02/oradata/spap/undotbs01.dbf', 14 '/iu33/u02/oradata/spap/drsys01.dbf', 15 '/iu33/u02/oradata/spap/example01.dbf', 16 '/iu33/u02/oradata/spap/odm01.dbf', 17 '/iu33/u02/oradata/spap/tools01.dbf', 18 '/iu33/u02/oradata/spap/users01.dbf', 19 '/iu33/u02/oradata/spap/xdb01.dbf', 20 '/iu33/u02/oradata/spap/users02.dbf', 21 '/iu33/u02/oradata/spap/users03.dbf', 22 '/iu33/u02/oradata/spap/users04.dbf', 23 '/iu33/u02/oradata/spap/users05.dbf', 24 '/iu33/u02/oradata/spap/indexes01.dbf', 25 '/iu33/u02/oradata/spap/indexes02.dbf', 26 '/iu33/u02/oradata/spap/indexes03.dbf' 27 CHARACTER SET WE8ISO8859P1 28 ; CREATE CONTROLFILE REUSE DATABASE SPAP RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-03114: not connected to ORACLE SQL -- RECOVER DATABASE SQL -- ALTER DATABASE OPEN; SQL -- ALTER TABLESPACE TEMP ADD TEMPFILE '/iu33/u02/oradata/spap/temp01.dbf' SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ; SQL The confusing thing is that I have instances already running on the machine. So I know the install is ok. I can start/shutdown the existing instances no problem. But when I try to clone and startup --- I get the results from above. -Original Message- Sent: Monday, October 27, 2003 5:24 PM To: [EMAIL PROTECTED] When are you getting the error? During startup? Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup controlfile to trace -- edited for the new file locations keeping the SID the same created init.ora from spfile startup nomount pfile=init.ora getting ora-3113 I have a TAR opened and figured I would check out here as well. -Original Message- [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:44 PM To: Multiple recipients of list ORACLE-L How about some more details? Are you cloning to a similar platform? Are you using a cold backup with controlfile recreation? RMAN backup or restore? RMAN duplicate? ... Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 02:24 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Clone db 9.2 on AIX 5L Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Foreign Key and Unique key on same columns
Hi, Is there any performance problem if two columns have FOREIGN KEY from different tables and both columns also have UNIQUE CONSTRAINT? CREATE TABLE table1 ( COL1NUMBER constraint table1_fk1 references table2(col1), COL2NUMBER constraint table1_fk2 references table3(col1)); CREATE UNIQUE INDEX table1_uq1 ON table1(COL1, COL2); Thanks Muqthar Ahmed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Execution Plan is good but HIGH CPU
Hi, Execution plan looks good but the query is consuming 800 seconds CPU timewhy? SELECT sampleavail, sample_cost_amount, sample_sale_amount, discount_room, discount_case, discount_half_case, allow_cut, retail_cut_amount, cost_cut_amount, gp_room from tbljnwpbookvendortype t1, tbljnwpbookvendor t2 where t1.jnwpbvid = t2.jnwpbvid and t2.prsuid = :b3 and t2.wpbkid = :b2 and t1.wpptid = :b1 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 5618 0.63 0.58 0 0 0 0 Fetch 5617800.05 782.07 01409683 04187 --- -- -- -- -- -- -- total11236800.68 782.66 01409683 04187 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 109 (DDTBL) (recursive depth: 1) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 NESTED LOOPS 0TABLE ACCESS (BY INDEX ROWID) OF 'TBLJNWPBOOKVENDOR' 0 INDEX (UNIQUE SCAN) OF 'TBLJNWPBOOKVENDOR_UQ1' (UNIQUE) 0TABLE ACCESS (BY INDEX ROWID) OF 'TBLJNWPBOOKVENDORTYPE' 0 INDEX (RANGE SCAN) OF 'TBLJNWPBOOKVENDORTYPE_IDX1' (NON-UNIQUE) Muqthar Ahmed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: _DB_FILE_DIRECT_IO_COUNT
Lee, If you would like to see the default value for _DB_FILE_DIRECT_IO_COUNT, run the following query with SYSDBA privileges: col Parameter for a50 col Session Value for a20 col Instance Value for a20 select a.ksppinm Parameter, b.ksppstvl Session Value, c.ksppstvl Instance Value from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '_db_file%' order by ksppinm / Parameter Session ValueInstance Value -- _db_file_direct_io_count 1048576 1048576 _db_file_noncontig_mblock_read_count 11 11 SQL Muqthar Ahmed DBA -Original Message- Sent: Tuesday, October 21, 2003 8:16 AM To: Multiple recipients of list ORACLE-L Hi, 9.2.0.3 AIX 5L Anyone used this in 9i ?? Can you set this as you would a normal parameter (ie. as I did in 8i with undocumented parameters). Sorry if this is a stupid question but I am still getting my head around this 9i stuff. Plus don't worry, this is not Production I am playing but a test instance. I thought I would ask first as I would rather not recreate this. Cheers Lee ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How To Pull Second Row from 100 ROWS
Hi, Is there a way to pull ONLY 2nd row from the selected rows. Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Pull Second Row from 100 ROWS
Thank you.it works. Muqthar DBA -Original Message- Sent: Tuesday, October 21, 2003 5:05 PM To: Multiple recipients of list ORACLE-L SELECT blah, blah, blah... FROM (SELECT blah, blah, blah..., ROWNUM r FROM table_name WHERE ...) WHERE r = 2; No guarantees, that you will be always getting the same row (depending on in-line query). Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Muqthar Ahmed Sent: Tuesday, October 21, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Hi, Is there a way to pull ONLY 2nd row from the selected rows. Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
COBOL TO ORACLE
Hi, Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ROW CACHE HIGH - Priority 1
Hi, Thanks for your suggestions. Usually Friday we have low traffic on our website. I will run the database with one node to check the row cache problem. Muqthar -Original Message- Sent: Friday, September 26, 2003 7:15 AM To: Multiple recipients of list ORACLE-L sql parsing would be reflected in Library cache not rowcache Basic stuff Not that basic. Rowcache will get hit during any hard parse, since you need to get information about objects from DD. And if objects information isn't cached yet, it has to be loaded into row cache. Btw, row cache locks might come from LMT extent (de)allocation. Now, if both RAC instances start allocating or deallocating extents in a datafile, they need to access the same bitmap blocks, which results in GC traffic or pings, maybe that's the problem? Tanel. Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:14 PM General answer: upgrade to 9.2.0.4 and hope that the bug has been fixed. Row cache locks are data dictionary locks. You can see the contents of row cache by inspecting v$rowcache. You may need to increase shared pool. Last but not least, how fast is your private network connection between the two nodes? 100mbit/sec is not nearly fast enough. You need at least a gigabit switch. Also check your SQL for hard parsing (see the executions and invalidations in v$sqlarea), ad-hoc DDL and that kind of stuff. And no, it's not my priority 1. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Muqthar Ahmed Sent: Wednesday, September 24, 2003 3:50 PM To: Multiple recipients of list ORACLE-L Subject: ROW CACHE HIGH - Priority 1 Hi, I have Oracle 9.2.0.2.0 RAC (two nodes) on IBM AIX. Currently I am seeing very high number for ROW CACHE LOCK in statspack. Top 5 Timed Events ~~ % Total Event Waits Time (s) Ela Time --- row cache lock11,310 5,441 86.97 CPU time 522 8.34 global cache cr request32,513 71 1.14 global cache null to x 21,507 57 91 log file sync22,689 49 .78 - Get Spin Latch Name Requests Misses SleepsSleeps 1-4 -- -- --- --- library cache 7,094,208 31,499 1,480 30031/1456/12/0/0 shared pool 2,385,408 6,739 5276212/527/0/0/0 ges enqueue table freelist 1,492,275 1,903 1241780/122/1/0 /0 library cache pin 3,201,008 1,437 1301307/130/0/0/0 row cache objects1,400,498 1,020 56 964/56/0/0/0 row cache enqueue latch 1,292,843 715 19 696/19/0/0/0 It is holding row cache lock (v$session_wait), other sessions are in the queuedue to this, number of concurrent sessions will increase from 100 to 350 sessions on each node. In less than one minute everything will be cleared ( OLTP database) I have already opened a TAR with Priority 1. Do you have any suggestions. Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute
RE: ROW CACHE HIGH - Priority 1
Hi, There are two BUGS 2605240 and 2683906 which got fixed in 9.2.0.4.0. I will be applying the patch to fix the problem. Thanks for your input. Muqthar -Original Message- Sent: Friday, September 26, 2003 9:55 AM To: Multiple recipients of list ORACLE-L SQL parsing would also be reflected in rowcache because, to parse successfully, you need dictionary and parse locks. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sam Roberts Sent: Friday, September 26, 2003 2:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: ROW CACHE HIGH - Priority 1 sql parsing would be reflected in Library cache not rowcache Basic stuff Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:14 PM General answer: upgrade to 9.2.0.4 and hope that the bug has been fixed. Row cache locks are data dictionary locks. You can see the contents of row cache by inspecting v$rowcache. You may need to increase shared pool. Last but not least, how fast is your private network connection between the two nodes? 100mbit/sec is not nearly fast enough. You need at least a gigabit switch. Also check your SQL for hard parsing (see the executions and invalidations in v$sqlarea), ad-hoc DDL and that kind of stuff. And no, it's not my priority 1. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Muqthar Ahmed Sent: Wednesday, September 24, 2003 3:50 PM To: Multiple recipients of list ORACLE-L Subject: ROW CACHE HIGH - Priority 1 Hi, I have Oracle 9.2.0.2.0 RAC (two nodes) on IBM AIX. Currently I am seeing very high number for ROW CACHE LOCK in statspack. Top 5 Timed Events ~~ % Total Event Waits Time (s) Ela Time --- row cache lock11,310 5,441 86.97 CPU time 522 8.34 global cache cr request32,513 71 1.14 global cache null to x 21,507 57 91 log file sync22,689 49 .78 - Get Spin Latch Name Requests Misses SleepsSleeps 1-4 -- -- --- --- library cache 7,094,208 31,499 1,480 30031/1456/12/0/0 shared pool 2,385,408 6,739 5276212/527/0/0/0 ges enqueue table freelist 1,492,275 1,903 1241780/122/1/0 /0 library cache pin 3,201,008 1,437 1301307/130/0/0/0 row cache objects1,400,498 1,020 56 964/56/0/0/0 row cache enqueue latch 1,292,843 715 19 696/19/0/0/0 It is holding row cache lock (v$session_wait), other sessions are in the queuedue to this, number of concurrent sessions will increase from 100 to 350 sessions on each node. In less than one minute everything will be cleared ( OLTP database) I have already opened a TAR with Priority 1. Do you have any suggestions. Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you
ROW CACHE HIGH - Priority 1
Hi, I have Oracle 9.2.0.2.0 RAC (two nodes) on IBM AIX. Currently I am seeing very high number for ROW CACHE LOCK in statspack. Top 5 Timed Events ~~ % Total Event WaitsTime (s) Ela Time --- row cache lock11,310 5,44186.97 CPU time 522 8.34 global cache cr request32,513 711.14 global cache null to x 21,507 5791 log file sync22,689 49.78 - Get Spin Latch Name Requests Misses SleepsSleeps 1-4 -- -- --- --- library cache 7,094,208 31,499 1,480 30031/1456/12/0/0 shared pool 2,385,408 6,739 527 6212/527/0/0/0 ges enqueue table freelist 1,492,275 1,903 1241780/122/1/0 /0 library cache pin 3,201,008 1,437 130 1307/130/0/0/0 row cache objects1,400,498 1,020 56 964/56/0/0/0 row cache enqueue latch 1,292,843 715 19 696/19/0/0/0 It is holding row cache lock (v$session_wait), other sessions are in the queuedue to this, number of concurrent sessions will increase from 100 to 350 sessions on each node. In less than one minute everything will be cleared ( OLTP database) I have already opened a TAR with Priority 1. Do you have any suggestions. Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SP
Hi, I have used 12 channels to backup 700GB database and writing to FOUR TAPES at the same time. I used to backed up in 4 1/2 hours. On EMC disk, restore was done in 8 hours. allocate channel c1 type 'SBT_TAPE'; allocate channel c2 type 'SBT_TAPE'; allocate channel c3 type 'SBT_TAPE'; allocate channel c4 type 'SBT_TAPE'; allocate channel c5 type 'SBT_TAPE'; allocate channel c6 type 'SBT_TAPE'; allocate channel c7 type 'SBT_TAPE'; allocate channel c8 type 'SBT_TAPE'; allocate channel c9 type 'SBT_TAPE'; allocate channel c10 type 'SBT_TAPE'; allocate channel c11 type 'SBT_TAPE'; allocate channel c12 type 'SBT_TAPE'; setlimit channel c1 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c2 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c3 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c4 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c5 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c6 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c7 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c8 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c9 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c10 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c11 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c12 kbytes 2097150 maxopenfiles 16 readrate 500; Thanks Muqthar Ahmed DBA -Original Message- Sent: Thursday, January 30, 2003 11:21 AM To: Multiple recipients of list ORACLE-L SPEED? Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database. The machine probably will have 10+ cpus HP machine and EMC disk although the backups will probably sit on a fast SAN. There will be 12Gig of fast memory... 200,000 users...max 10,000 concurrent, 100MB io card. IF anyone has done it...what speeds could you obtain with RMAN from Disk? What were the best SPEED enhancing factors?? ( I know cpus, mult-channels, and memory, disk ban widths anymore?) Thanks, Brian Spears -Original Message- Sent: Thursday, January 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L OK, that's it. My mountain bike is coming out TODAY. I don't care if it's 10F out. There's no snow, so it won't be as fun, but that's alright. And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a week. I admit that I spent some time in Rehab afterwards for rough cartilage (I was BORN geeky, too!), but it was a blast nonetheless. Hm...maybe I'd better set my arse on the stationary bike for a few weeks first before taking on the trails. Now I'm depressed. Thank God it's Beer Day! http://society.servebeer.com :) Now back to your regularly schedule database problems... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND! Koivu, Lisa Lisa.Koivu@efairTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by: Subject: RE: Take Care of your DBAs [EMAIL PROTECTED] 01/29/2003 01:54 PM Please respond to ORACLE-L I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
URGENT! URGENT!
Hi, Does anyone has information for ORA-327000 error occurred in DIAG Group Service. I am using Oracle9i RAC on AIX servers. When I try to bring up the database I get that error. Thank you in advance. Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Shutdown Immediate Hanging
Title: Message Steve, Recently I got same problem and I have resolved it. This will happen if you setup INITIAL and NEXT extent size very small for TEMPORARY tablespace. Look at the following information: http://metalink.oracle.com and look for the following DOC ID: DOC ID: 61997.1 DOC ID: 1076161.6 I created new LOCALLY MANAGEDTEMPORARY tablespace which handles better than DICTIONARY tablespace: CREATE TEMPORARY TABLESPACE temp TEMPFILE '/d05/oradata/prod/temp01.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp; Muthar Ahmed DBA -Original Message-From: Steve Perry [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:13 PMTo: Multiple recipients of list ORACLE-LSubject: Shutdown Immediate Hanging I hope somebody can help me with this shutdown problem. There's 2 questions unless: how to troubleshoota stalledshutdown and the best way to deal with it. #1 - Database hangs during shutdown We have several instances running 8.1.7.3 on Win2k and continue to have intermittent shutdown problems. The shutdown never completes. Here's are the steps used to stop the database 1.) Stop the application servers 1.) run a kill session script to kill all remaining sessions except the one running the script 2.) issue shutdown immediate and hope it shuts down. At this point, the database closes but it never dismounts. We never receive the "Completed: ALTER DATABASE DISMOUNT" Is there anything I can do to diagnose the problem at this point? After 15 minutes, Arcservebacks upthe files to tape (delay fieldin arcserve job). After the backup is complete, the database startup script is run. The alert log says the startup is normal, but no connections are allowed into the database. I either have to do a shutdown abort or stop the service and then I can start the database. I wrote a script to detectthe shutdownhangsthat will page me, do a shutdown abort, startup and thenshutdown immediate (before the backup job starts) There's not much I can do when it stalls and I don't mind running the script if it won't corrupt my database. Is there a better way to handle this? I checked metalink and opened a tar. Oracle said it was a security dll issue with MS and that I should change the scripts to shutdown the service instead of using svrmgrl or sqlplus. That was fine until I realized that stopping the service will do a shutdown immediate. If thedatabase doesn't complete before the ora_SID_shutdown_timeout value, it does a shutdown abort (or equivalent). Thanks, Steve
RE: SYSTEM TABLESPACE IS SO HUGE ?
Madhu, Try these two queries to find out allocated space in SYSTEM tablespace: select owner, tablespace_name, sum(bytes)/(1024*1024) Allocated MBytes from dba_segments where tablespace_name = 'SYSTEM' group by owner, tablespace_name; select tablespace_name, sum(bytes)/(1024*1024) Total MBytes from dba_data_files where tablespace_name = 'SYSTEM' group by tablespace_name; Muqthar Ahmed DBA -Original Message- Sent: Thursday, August 15, 2002 4:23 PM To: Multiple recipients of list ORACLE-L Rogers , If you mean to say Writing is Creating the segments , I did not see any other user except SYS and SYSTEM users in the SYSTEM tablespace. But some user IDs which were created for replication purpose have the Default_tablespace as SYSTEM , but they do not have any segments in SYSTEM tablespace . And there wont be any chance of creating a new object/segment under those users. I believe the SYSTEM tablespace was fragmented and now I would like to resize it , would like to know best and fastest way Thanks Madhu -Original Message- Sent: Thursday, August 15, 2002 1:51 PM To: Multiple recipients of list ORACLE-L Madhu some one or something is writing into your system tablespace. I would check to see if anyone has the system tablespace as their default tablespace. SELECT username from dba_users where default_tablespace ='SYSTEM'; or SELECT username from dba_users where temporary_tablespace ='SYSTEM'; Ron ROR mô¿ôm [EMAIL PROTECTED] 08/15/02 02:06PM Hello Listers, We have a database for which the SYSTEM tablespace size is nearly 10 gig , Now I have a plan to reduce the size of it . And database is running on 8.1.7.2. What would be the best and faster way to do it. Your ideas will be very much appreciated !! Thank in advance, Madhu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Total Memory Usage in AIX System
Hi, I have a few Oracle scripts to calculate Total Physical Memory usage by Oracle at any give time. But I would like to find out Total Memory Usage by ORACLE and NON-ORACLE processes. I used dmesg in HP system but I do not know for IBM AIX system. Please let me know if you happen to know the method to calculate the total memory usage on the system. Thank you! Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Weird Windoze 'AT' Behavior
Dave, Did you stop and start SCHEDULER.if not do it, it will fix the problem. Muqthar Ahmed DBA -Original Message- Sent: Wednesday, July 17, 2002 9:43 AM To: Multiple recipients of list ORACLE-L I have Oracle 8.1.7 running on NT. I do cold backups nightly and have a batch file that is called by the NT 'AT' scheduler. I recently changed some lines of commands in the batch file and since then when the batch file is executed by 'AT' only the lines that I did not edit are executed. If I execute the batch file from the command prompt it works fine. I deleted the job from 'AT' and then entered it back in but still getting this odd behavior of only executing the commands that I did not edit. Our SA's know nothing about 'AT' so they are of no help. Has anyone else seen this odd behavior in the 'AT' function in Windoze? I know you find it hard to believe that something can be weird in Windoze. ;o) And yes, I am soon planning on learning RMAN and do hot backups. I have the 8i Backup and Recovery Handbook for my reading pleasure. I see the app that is being used going to a 24X7 schedule. Now it is only used during the day. 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Beginners questions for RMAN and Legato on WIN2000
Hi, Follow the following configuration steps before you use the Legato Software for backup: 1. Install Legato NetWorker Software 2. Install BusinessSuite Module for Oracle (Integration between Oracle and Legato) 3. Configure Legato Neworker to use Tape Devices 4. Use RMAN to backup only controlfile to Tape device to check whether RMAN is recognizing Tape Devices or not. you can use the following script to test your backup (Change the server host name LAWPROD before you use the script): rman catalog [EMAIL PROTECTED] connect target run { allocate channel c1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; allocate channel c2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; allocate channel c3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; backup current controlfile format 'cf_%d_t%t_s%s_p%p'; backup incremental level 0 tag backup_level_0 filesperset 4 format 'ts_%d_t%t_s%s_p%p' (database); release channel c1; release channel c2; release channel c3; resync catalog; } All the best! Muqthar Ahmed DBA http://www.decoratetoday.com -Original Message- Sent: Wednesday, July 03, 2002 4:08 AM To: Multiple recipients of list ORACLE-L Hi all, I have some problems with rman and Legato Networker on Win2000. I am using a catalog and my oracle version is 8.1.7. How rman/Legato knows which nsrnmo -script it will use, I mean I have created script for each instance with filename nsrnmo_DBNAME.bat. Also how do I specify which Legato server and Legato group is used. I tried to test as it was mentioned in Legato Networker Module for Oracle (rel.3.5) documentation page 52, but rman was complaining about the parameter NSR_ENV ... I tried to check these things from the manual but still I am at the same point :-) ... Thank you in advance! br Keijo -- __ Ota itsellesi luotettava kotimainen email http://www.jippii.fi/ Tutustu samalla netin parhaaseen pelipaikkaan JIPPIIGAMESIIN. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Beginners questions for RMAN and Legato on WIN2000
Hi, Follow the following configuration steps before you use the Legato Software for backup: 1. Install Legato NetWorker Software 2. Install BusinessSuite Module for Oracle (Integration between Oracle and Legato NetWorker) 3. Configure Legato Neworker to use Tape Devices 4. Test RMAN and Tape Device interface by backing up only controlfile. you can use the following script for the full backup (Change the server host name LAWPROD before you use the script): rman catalog [EMAIL PROTECTED] connect target run { allocate channel c1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; allocate channel c2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; allocate channel c3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; backup current controlfile format 'cf_%d_t%t_s%s_p%p'; backup incremental level 0 tag backup_level_0 filesperset 4 format 'ts_%d_t%t_s%s_p%p' (database); release channel c1; release channel c2; release channel c3; resync catalog; } All the best! Muqthar Ahmed DBA -Original Message- Sent: Wednesday, July 03, 2002 9:09 AM To: '[EMAIL PROTECTED]' Hi, Follow the following configuration steps before you use the Legato Software for backup: 1. Install Legato NetWorker Software 2. Install BusinessSuite Module for Oracle (Integration between Oracle and Legato) 3. Configure Legato Neworker to use Tape Devices 4. Use RMAN to backup only controlfile to Tape device to check whether RMAN is recognizing Tape Devices or not. you can use the following script to test your backup (Change the server host name LAWPROD before you use the script): rman catalog [EMAIL PROTECTED] connect target run { allocate channel c1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; allocate channel c2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; allocate channel c3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=lawprod)'; backup current controlfile format 'cf_%d_t%t_s%s_p%p'; backup incremental level 0 tag backup_level_0 filesperset 4 format 'ts_%d_t%t_s%s_p%p' (database); release channel c1; release channel c2; release channel c3; resync catalog; } All the best! Muqthar Ahmed DBA http://www.decoratetoday.com -Original Message- Sent: Wednesday, July 03, 2002 4:08 AM To: Multiple recipients of list ORACLE-L Hi all, I have some problems with rman and Legato Networker on Win2000. I am using a catalog and my oracle version is 8.1.7. How rman/Legato knows which nsrnmo -script it will use, I mean I have created script for each instance with filename nsrnmo_DBNAME.bat. Also how do I specify which Legato server and Legato group is used. I tried to test as it was mentioned in Legato Networker Module for Oracle (rel.3.5) documentation page 52, but rman was complaining about the parameter NSR_ENV ... I tried to check these things from the manual but still I am at the same point :-) ... Thank you in advance! br Keijo -- __ Ota itsellesi luotettava kotimainen email http://www.jippii.fi/ Tutustu samalla netin parhaaseen pelipaikkaan JIPPIIGAMESIIN. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Restore with RMAN
Luc, RMAN catalog will always restore the latest CONTROLFILE. If you can restore OLDER version of CONTROLFILE then you can restore the previous one. Muqthar Ahmed DBA -Original Message- Sent: Tuesday, June 25, 2002 4:50 PM To: Multiple recipients of list ORACLE-L Luc - I wondered about this issue, but since it wasn't going to be on the OCP BR exam, it obviously wasn't worth knowing (just a little dark OCP humor). My initial guess would be either: 1) RMAN would just know to go to the earlier backup if the first failed (I doubt that). 2) Manually go into the RMAN catalog and delete the reference to the bad backup so RMAN no longer knows it exists. I also believe there may be an RMAN command to accomplish this. 3) Hope someone else on this list knows the answer. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Hi gurus, I'm in a process of testing our backup and recovery strategies. Question: For a restore of a noarchivelog database : Is't possible to restore other backups than the last one? What's happen if the last one is not good? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Any Good Tool for Entity Relationship Diagram
Hi, One of our databases is custom based application. Is there any good tool I can use for ER Diagram. Thank your! Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to you stop an export?
Hi, If you are running from a UNIX server, kill the job by PID number. Muqthar Ahmed DBA -Original Message- Sent: Monday, June 10, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Hi, by my experience, press CTL-C is enougth. :-) Ciao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 10, 2002 7:08 PM how do you stop an command-line export? press CTL-C countless times and ususally just stops the current table . . . usually end up killing the entire session. was hoping there's a different way? thx bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: claudio cutelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Archiving in OPS
Hi, You can not setup your archive logs in EMC storage (RAW). Currently I am working on this project. Oracle recommends that the following setup: SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / REDOLOGS - RAW (EMC storage) ARCHIVE LOGS / ROLLBACK (UNDO) - LOCAL (on each instance) You can use FAILOVER to move archive location. For example: Instance1 Instance2 PROD1PROD2 /d01/arch1 /d02/arch2 If Instance1 goes down, using FAILOVER method, /d01/arch1 will be automatically mounted on Instance2. Check with your UNIX Administrator about FAILOVER mechanism. Muqthar Ahmed DBA -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 12:59 PMTo: Multiple recipients of list ORACLE-LSubject: Archiving in OPS Hi list, Scenario OPS, 2 nodes, 8.1.7, AIX using raw devices, EMC box. I am new in OPS and have to implement archiving in an OPS environment and configure RMAN to use with LEGATO. My question is how to organize the archives. What will happen if one of the nodes goes down ? I think that the2 nodes have to see each other and write archive files to the same place, for instance I assume that the archive files have to be in the EMC box . I have been gathering very helpful information from the list in the past week about RMAN, but if you have some scripts, some documentation, links about it will be very appreciated. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
RE: Archiving in OPS
Hi, Yes you are correct.I am using Oracle9i RAC (Real Application Cluster). Muqthar Ahmed DBA -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 4:44 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Archiving in OPS If I understand you correctly, you are referring to "RAW" EMC storage as the shared storage array accessible from all nodes in the cluster, while "local" is local storage that is only accessible from the node to which it is directly attached? If so, then putting the tablespaces on that "local" storage will never work. Likewise, if the rollback tablespaces were also not in "raw" devices; it would never work (unless you are using a clustered file-system such as available on Tru64). In both cases, OPS/RAC would fail to startup... - Original Message - From: Muqthar Ahmed To: Multiple recipients of list ORACLE-L Sent: Thursday, June 06, 2002 1:48 PM Subject: RE: Archiving in OPS Hi, You can not setup your archive logs in EMC storage (RAW). Currently I am working on this project. Oracle recommends that the following setup: SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / REDOLOGS - RAW (EMC storage) ARCHIVE LOGS / ROLLBACK (UNDO) - LOCAL (on each instance) You can use FAILOVER to move archive location. For example: Instance1 Instance2 PROD1PROD2 /d01/arch1 /d02/arch2 If Instance1 goes down, using FAILOVER method, /d01/arch1 will be automatically mounted on Instance2. Check with your UNIX Administrator about FAILOVER mechanism. Muqthar Ahmed DBA -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 12:59 PMTo: Multiple recipients of list ORACLE-LSubject: Archiving in OPS Hi list, Scenario OPS, 2 nodes, 8.1.7, AIX using raw devices, EMC box. I am new in OPS and have to implement archiving in an OPS environment and configure RMAN to use with LEGATO. My question is how to organize the archives. What will happen if one of the nodes goes down ? I think that the2 nodes have to see each other and write archive files to the same place, for instance I assume that the archive files have to be in the EMC box . I have been gathering very helpful information from the list in the past week about RMAN, but if you have some scripts, some documentation, links about it will be very appreciated. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
How do I parse information from a Column
Hi, I am capturing data from v$sqlarea to a table to find out all the query activities on a database. Now I would like to parse sql_text column from a table to get only DML commands(SELECT, INSERT, UPDATE and DELETE) and also FROM clause to get table names. The example is: SELECT cuid,usid,cufirstname,culastname,cushipfirstname,cushiplastname,cushipaddress1,cushipaddress2,cushiphomephone,cuemail,cushipcareof,cushipcity,cushipstate,cushippostalcode,cuadcode,cubilltiid,cuaddress1,cuaddress2,cucity,custate,cupostalcode FROM tblCustinfo WHERE UsID=234563245 Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).