You can automatically get a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is generated after successful SQL DML (that is, SELECT, DELETE, UPDATE and INSERT) statements. It is useful for monitoring and tuning the performance of these statements. To use this feature, you must create …
Tuning SQL statements with AUTOTRACE in SQL*Plus Read More »
Methods required to obtain a formatted explain plan differ depending on which version of Oracle you are using. The initial steps to create a plan table and make the optimizer populate the plan table with the execution plan are common to all versions of Oracle. Note that there are limitations with explain plan when the …
Plan Table and methods for obtaining a formatted Explain Plan Read More »
Preparing a Linux server to install oracle has been made easy with the help of oracle-validated rpm package. Install of oracle-validated automates the download and install of all required RPMs including dependencies, setup of Linux kernel parameters, creation of oracle user (Linux user) and dba, oinstall groups I have been thinking of trying out oracle-validated …
Prepare your Linux Server to install Oracle database using oracle-validated RPM Read More »
This post summarizes on how to start, stop and to check the status of Oracle database services. Oracle 10g Oracle Listener: To Start, execute the following command: $ su – oracle $ lsnrctl start To Stop, execute the following command: $ su – oracle $ lsnrctl stop Grid Control for Database Management: To Start, execute …
This article briefs about the steps that are required to remove Oracle 10g software from Linux server using Oracle Universal Installer and manually. Removing Oracle 10g Software Using Oracle Universal Installer Identify all instances associated with the Oracle home: To identify all instances associated with the Oracle home that you want to remove, issue the …