What is an Oracle Service

Oracle services were a feature introduced in Oracle 10g. Their function is to simplify workload management by allowing you to group applications that share traits such as thresholds, priorities and attributes. The Oracle database is presented as a service and so you always have at least one service running. It is good practice to create …

Read more

How to modify Voting disks in ASM

The process for modifying a votedisk that is stored on ASM differs from the process when the votedisk is stored on some other medium. When your voting disks are stored on ASM you can move them off to non ASM storage with the replace command: $ crsctl replace votedisk [path_to_new_votedisk] (this can be done from …

Read more

SQL performance analyzer in Oracle 11g

SQL performance analyzer performs a similar job to the SQL Tuning Advisor with one major difference, SQL performance analyser allows you to compare the performance of SQL statements before and after a change, allowing you to predict the impact of changes to the system on SQL performance as well as pre tuning your database before …

Read more

Where to find Oracle clusterware log files.

To make administration and problem diagnosis easier in Oracle Clusterware, there is a single consolidated directory structure for the main clusterware log files.   This is found under $GRID_HOME/log/[hostname]/   The CRSD logfile – crsd.log is stored in the /crsd/ directory and is archived every 10mb.   The CSS logfiles – cssd.log is stored in …

Read more

How to enable Clusterware Resource Debugging in Oracle RAC

In order to enable clusterware resource debugging you need to set the resource attribute USR_ORA_DEBUG to 1 for the resource that you wish to debug. $ crsctl set log res “ora.host01.vip:1” When you are finished you issue almost the same command to disable the clusterware debugging (set USR_ORA_DEBUG to 0): $ crsctl set log res “ora.host01.vip:0” You can also use an initialization …

Read more