Zane Appel's Oracle Cookbook

Explain plan within Sqlplus

On:
set autotrace trace explain
Off:
set autotrace off

Posted by Zane Appel

Labels: DBA, Tuning

Newer Post Older Post Home

Popular Posts

Problem starting Cluster Services when installing 11gr2 on RHEL 7

Recently I installed Oracle RAC 11gr2 (11.2.0.4) on Red Hat Enterprise Linux 7 and ran into a problem running the root.sh script towards th...
Operating system configuration settings for Oracle 11g and Solaris 10

Oracle's Health Check utility recommends that you set certain parameters when installing on Solaris 10. Here is a summary of some common...
TEMP_UNDO_ENABLED: Increase performance and decrease undo segment usage

Oracle 12c has a new parameter called TEMP_UNDO_ENABLED. This parameter can be set at the SESSION or SYSTEM level. When it is set to TRU...
Enable trace in Oracle

1. Enable trace at instance level Put the following line in init.ora. It will enable trace for all sessions and the background processes sql...
Troubleshoot client connection problems

1. Check whether you can ping the server from the client machine. 2. If pinging then check whether service is started on server. 3. If servi...

Labels

ASM Configuration Data Guard DBA Grid Installation Indexing Installation Linux OEL 5 OEL 6 Oracle 11g Oracle 12c Oracle DB Installation PL/SQL RAC RHEL 5 RHEL 6 RHEL 7 Rman Solaris Solaris 10 Solaris 11 Streams System Administration Tuning

About This Blog

All of these scripts and tips are completely unsupported in any way and I cannot take any responsibility for any effects they may have upon your systems so TEST them before using.

The views expressed on this blog are my own and do not necessarily reflect the views of my employer.

Simple theme. Powered by Blogger.