Define Cron Job at Solaris Machine

Open the Solaris command prompt and follow the below steps:

1. Run command
   export EDITOR=vi

2. Run command
    crontab -e

3. VI editor shall be opened. Press key 'i' and paste cron job
     Example:
     1 3 * * * /export/home/myfile.sh

4. Press key 'Esc' and write :wq

5. Check using below command whether job has been added successfully
    crontab -l

Oracle: Check SQL Query Execution Plan

Steps to verify SQL query execution plan:

1. Use below query to explain plan for SQL query
    
    explain plan for <select_query>

    Example:     explain plan for select 1 from dual;

2. Viewing plan using below query

     SELECT * FROM   TABLE(DBMS_XPLAN.DISPLAY);

For more detail : http://www.oracle-base.com/articles/9i/DBMS_XPLAN.php