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 [crayon-5beb1b20ca584476916925/] 1. Pack the profiles to the staging table  [crayon-5beb1b20ca...

Skip to toolbar