alter database link .. 

Instead of DB link recreation after password change of remote schema from 11gr2 we can use “alter database link”

alter database link SCOTT_DBLINK connect to scott identified by abc;

Check the below link for detailed info.

http://aprakash.wordpress.com/2012/05/11/change-in-database-link-11gr2/

To know last utlrp run,

we can find an entry from alert log as below

Tue May  8 19:27:43 2012
SERVER COMPONENT id=UTLRP_BGN: timestamp=2012-05-08 19:27:43
Tue May  8 19:27:55 2012
SERVER COMPONENT id=UTLRP_END: timestamp=2012-05-08 19:27:55

Top 15 sqls from cursor and Workload repository

from Oracle 10g release there is a script named SQLTRPT.SQL at ORACLE_HOME/rdbms/admin
which lists top 15 sqls from cache cursor and workload repository and its Tuning recommendations.

SQL>  col SQL_TEXT_FRAGMENT for a67
SQL> set pages 999
SQL> @sqltrpt

--DUE TO CLUMSY FORMAT here removed from display--
 
Specify the Sql id
~~~~~~~~~~~~~~~~~~
Enter value for sqlid: b6usrg82hwsa3

Sql Id specified: b6usrg82hwsa3

Tune the sql
~~~~~~~~~~~~

GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name                  : TASK_331359
Tuning Task Owner                 : SYS
Scope                             : COMPREHENSIVE
Time Limit(seconds)               : 1800
Completion Status                 : COMPLETED
Started at                        : 05/08/2012 17:54:55
Completed at                      : 05/08/2012 17:54:55

-------------------------------------------------------------------------------
Schema Name: SYS
SQL ID     : b6usrg82hwsa3
SQL Text   : call dbms_stats.gather_database_stats_job_proc (  )

-------------------------------------------------------------------------------
ADDITIONAL INFORMATION SECTION
-------------------------------------------------------------------------------
- Type of SQL statement not supported.

-------------------------------------------------------------------------------