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
Monthly Archives: December 2009
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
What software is necessary for Oracle RAC? Does it have a separate installation CD to order?
Oracle Real Application Clusters is an option of Oracle Database andtherefore part of the Oracle Database CD.
Giving Access to run AWR/ADDM
You may want to allow non-dba users to run AWR reports (I wouldn’t, but my client may). Here’s how to do it.
Converting from RAC to single instance.
Oracle does not support conversion of a RAC database to a single instance, or at least does not supply any tool to perform this change as of oracle 10g.
How to Manually Convert Single Instance to RAC on Unix.
There is now the rconfig utility in 10g which allows you to convert a single instance to a RAC. However, you can still do this manually.
What (and what not) to monitor.
There’s monitoring and there’s monitoring. When you’ve deployed an oracle database system, you will either have a DBA in to run it or have outsourced to a reputable company, to perform the tasks required. If you’ve a DBA, you’ve vetted … Continue reading
Splitting multiple column range partitioned tables.
There was some confusion in splitting multiple column partitioned tables sometimes, and you need to grasp the concept of how oracle manages partitions to understand this.
Create a complex partitioned table.
Creating partitioned tables can be very time consuming, which is where the tools like Toad and EM come in handy. However, if you don’t have either, what’s the simpliest way to create a partitioned table ?
