mccmx's articles:

Items(72) /8 Next >> Last >|

Composite partitioned table purge causes need for index rebuild 3 50 (9/14/2009 2:10:27 AM) comp.databases.oracle.server Oracle 10.2.0.3 EE on RHEL 4 In a critical 24/7 database we have a very large transactional table which is partitioned by date (weekly) and then further subpartitioned by list (we have 3 subpartitions per week... Matt

Standby database Transport Lag 0 34 (11/28/2008 12:04:59 AM) comp.databases.oracle.server Oracle 10.2.0.3 EE with Data Guard Physical Standby configured with Asynchronous transport and real time apply. Platform RHEL 4 x86_64. How can I determine the exact lag between when a transaction is committe... mccmx

RAC or Large SMP...? 39 35 (10/7/2008 12:40:46 AM) comp.databases.oracle.server I support an OLTP application which handles 2 million transactions per day and is running on 10gR2 EE on RHEL 4 x86_64. I am investigating scaling options for the application and I'm trying to decide between 2... mccmx

How do you change log_archive_dest_X when using the DG Broker...? 4 28 (7/31/2008 9:24:09 AM) comp.databases.oracle.server 10.2.0.3 EE on Red Hat EL 4 How can you update the log_arc_dest parameters on a database which is managed by the Data Guard Broker... I've tried using the dgmgrl as follows: dgmgrl / DGMGRL> edit database... mccmx

Is 11g ready for Production....? 7 33 (7/11/2008 12:34:28 AM) comp.databases.oracle.server We are considering upgrading our Enterprise Edition database from 10gR2 to 11g. My instinct tells me that its a bad idea to upgrade to the first release of a major version. I've been burnt in the past by upgr... mccmx

Partitioning Best Practices 7 28 (7/8/2008 11:37:08 PM) comp.databases.oracle.server 10gR2 EE with Partitioning. I'm interested to hear peoples opinions on the following scenario. I have a 500 million row table which is partitioned by date (weekly). I'm trying to decide between specifying a ... mccmx

Compatible Parameter after Patching 10gR2 4 26 (6/24/2008 4:03:28 AM) comp.databases.oracle.server I've recently upgraded to 10.2.0.3 (from 10.2.0.1) on Linux x86_64. My compatible parameter is still set to 10.2.0.1. The patch set documentation doesn't refer to setting the compatible parameter to 10.2.0.3 ... mccmx

Validating Flashback Database 7 45 (6/17/2008 11:57:09 PM) comp.databases.oracle.server Oracle 10.2.0.3 EE on RHEL 4 I am considering using the following method for application upgrades in the future: (N.B. Flashback Logging is Disabled) 1. Shutdown DB 2. Create Guaranteed Restore Point 3. Upgr... mccmx

Restore and Rename a database from RMAN backupsets 5 38 (5/15/2008 5:01:18 AM) comp.databases.oracle.server 10.2.0.1 EE on RHEL 4 Anyone know a way of restoring a database to a different database name from RMAN backupsets.....? I could do a duplicate database by connecting to the target database but I want to avoid... mccmx

Which HOME to set for startinh 10g Grid Control Agent 4 50 (4/21/2008 1:09:34 AM) comp.databases.oracle.server We are running a 10.2.0.3 database and this is being monitored with a 10.2.0.3 Grid control agent in a separate home on the same server. When starting and stopping this agent the 10g docs say to: cd $AGENT_HO... mccmx

mccmx's replies:

Items(90) /9 Next >> Last >|

Unsupported Recovery Technique......? 9 32 (3/20/2008 3:01:07 AM) comp.databases.oracle.server 10g Release 2 I have cloned a 10.2.0.1 database onto a 10.2.0.3 home by using a cold backup and recreating the controlfile. During the 'alter database open resetlogs' the instance crashes because of the versi... mccmx (307)

Which HOME to set for startinh 10g Grid Control Agent 4 50 (4/21/2008 1:09:34 AM) comp.databases.oracle.server We are running a 10.2.0.3 database and this is being monitored with a 10.2.0.3 Grid control agent in a separate home on the same server. When starting and stopping this agent the 10g docs say to: cd $AGENT_HO... mccmx (307)

Restore and Rename a database from RMAN backupsets 5 38 (5/15/2008 5:01:18 AM) comp.databases.oracle.server 10.2.0.1 EE on RHEL 4 Anyone know a way of restoring a database to a different database name from RMAN backupsets.....? I could do a duplicate database by connecting to the target database but I want to avoid... mccmx (307)

Validating Flashback Database 7 45 (6/17/2008 11:57:09 PM) comp.databases.oracle.server Oracle 10.2.0.3 EE on RHEL 4 I am considering using the following method for application upgrades in the future: (N.B. Flashback Logging is Disabled) 1. Shutdown DB 2. Create Guaranteed Restore Point 3. Upgr... mccmx (307)

Compatible Parameter after Patching 10gR2 4 26 (6/24/2008 4:03:28 AM) comp.databases.oracle.server I've recently upgraded to 10.2.0.3 (from 10.2.0.1) on Linux x86_64. My compatible parameter is still set to 10.2.0.1. The patch set documentation doesn't refer to setting the compatible parameter to 10.2.0.3 ... mccmx (307)

Partitioning Best Practices 7 28 (7/8/2008 11:37:08 PM) comp.databases.oracle.server 10gR2 EE with Partitioning. I'm interested to hear peoples opinions on the following scenario. I have a 500 million row table which is partitioned by date (weekly). I'm trying to decide between specifying a ... mccmx (307)

Is 11g ready for Production....? 7 33 (7/11/2008 12:34:28 AM) comp.databases.oracle.server We are considering upgrading our Enterprise Edition database from 10gR2 to 11g. My instinct tells me that its a bad idea to upgrade to the first release of a major version. I've been burnt in the past by upgr... mccmx (307)

How do you change log_archive_dest_X when using the DG Broker...? 4 28 (7/31/2008 9:24:09 AM) comp.databases.oracle.server 10.2.0.3 EE on Red Hat EL 4 How can you update the log_arc_dest parameters on a database which is managed by the Data Guard Broker... I've tried using the dgmgrl as follows: dgmgrl / DGMGRL> edit database... mccmx (307)

RAC or Large SMP...? 39 35 (10/7/2008 12:40:46 AM) comp.databases.oracle.server I support an OLTP application which handles 2 million transactions per day and is running on 10gR2 EE on RHEL 4 x86_64. I am investigating scaling options for the application and I'm trying to decide between 2... mccmx (307)

Composite partitioned table purge causes need for index rebuild 3 50 (9/14/2009 2:10:27 AM) comp.databases.oracle.server Oracle 10.2.0.3 EE on RHEL 4 In a critical 24/7 database we have a very large transactional table which is partitioned by date (weekly) and then further subpartitioned by list (we have 3 subpartitions per week... mccmx (307)