Oracle8i

Plan Table and methods for obtaining a formatted Explain Plan

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 »

Managing Oracle database services

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 …

Managing Oracle database services Read More »