Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Category Archives: Tuning in General
Running an AWR Report.
Posted in Metalink, Oracle, Plan stability, Tuning in General
Tagged awr, AWR/ADDM, oracle
Comments Off
Optimal Redo Log Size
Posted in Tuning in General
Tagged LOG FILES, PHYSICAL, RECOVER, Recovery, REDO, standby, V$INSTANCE_RECOVERY
Comments Off
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by ‘inst 1, osid 70070′
ORA-00494, instance crashes. ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by ‘inst 1, osid 70070′ occured where a problem exists on getting a control file enqueue lock by the LGWR. However the instance shutsdown because CTKP … Continue reading
Posted in Tuning in General
Tagged ckpt, contention, controlfile, enqueue, enqueue blocker, fast_start_mttr_target, kill, lwgr, ORA-00494, redo log
Comments Off
Top Ten Performance Mistakes Found in Oracle Systems.
Posted in Tuning in General
Comments Off
Q: How to minimize log file sync?
Log file sync waits are associated with Redo data which has to be written to disk. There are a number of means with which you can combat this wait event.
Posted in Tuning in General
Comments Off
Capture DDL on a single table.
A user needed to capture DDL on a single table in 9.2.0.8. They’d done most of the work, but needed a little help to get to the end…….
About the Library Cache.
Where does the library cache live ? The library cache lives in the shared pool of the SGA in the instance. There are no parameters to control the size of the library cache within oracle.
Rebuild indexes to another tablespace.
I needed to rebuild the indexes from a tablespace to another, to allow me to clear the tablespace out and drop it. Here’s a script which performs this.
Posted in Oracle, Tuning in General
Comments Off
