performance Tuning

SGA TARGET ADVISORY IN ORACLE

The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for  SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET...

Shared Pool Advisory in oracle

Shared pool stores and caches the SQL and PL/SQL queries hitting the database , which avoids hard parsing the repetitive SQLs and It leads to increasing performance and memory usage. shared_pool_size ...

Migrate sql profiles from one database to another

 Follow below steps for migrating sql profiles from one database to another. 1. Create a staging table SQL> exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF(table_name=>'PBRPROFILE',schema_name=>'DBA...