RE: OFA and RAC on raw devices

/ 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

RE: OFA and RAC on raw devices

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

RE: Re: Logical StandBy question

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

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

RE: Re[2]: Sequences in OPS/RAC

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

RE: Clone db 9.2 on AIX 5L

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

RE: Execution Plan is good but HIGH CPU

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

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

RE: Clone db 9.2 on AIX 5L

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

Foreign Key and Unique key on same columns

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

Execution Plan is good but HIGH CPU

(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

RE: _DB_FILE_DIRECT_IO_COUNT

-- _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

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

RE: How To Pull Second Row from 100 ROWS

...) 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

COBOL TO 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

RE: ROW CACHE HIGH - Priority 1

. 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

RE: ROW CACHE HIGH - Priority 1

-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

ROW CACHE HIGH - Priority 1

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

RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SP

; 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

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

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

RE: SYSTEM TABLESPACE IS SO HUGE ?

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

Total Memory Usage in AIX System

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

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

FW: Beginners questions for RMAN and Legato on WIN2000

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

FW: Beginners questions for RMAN and Legato on WIN2000

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

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

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

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

RE: Archiving in OPS

. 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

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

How do I parse information from a Column

,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