Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

• Buffer Cache Hit Ratio - Calculate buffer cache hit ratio in the database. Make sure it is more than 80 for an oltp environment and 99 is the best value. pop (Added: 21-Oct-1999 Hits: 13571 Rating: 5.27 Votes: 22) Rate It

• Calculate Dictionary Cache Ratio - Increase Shared pool size to reach a 90% hit ratio on Dictionary Cache. Entries for dc_table_grants, d_user_grants, and dc_users should be under 5% each in the MISS RATE % column pop (Added: 24-Aug-1999 Hits: 9424 Rating: 8.00 Votes: 4) Rate It

• Calculate Individual Cache Hit Ratios - Reduce the Reloads and try to increase the hit ratios to above 85% (Added: 24-Aug-1999 Hits: 7914 Rating: 10.00 Votes: 2) Rate It

• Calculate the Library Cache Ratio for the Whole system - This should be near 0.If the Ratio is larger than 1% then increase the SHARED_POOL_SIZE. (Added: 14-Sep-1999 Hits: 8015 Rating: 7.00 Votes: 1) Rate It

• CALCULATING THE HIT RATIO FOR MULTIPLES POOLS - To run this script you must get connect
  as user sys (Added: 12-Sep-2003 Hits: 3690 Rating: 1.50 Votes: 2) Rate It

• CHECK FREE SHARED POOL AND FLUSH - THIS SCRIPT CHECK THE FREE SPACE IN THE SHARED POOL AND WHEN THE SIZE ITS VERY SMALL EXECUTE AN ALTER SYSTEM FLUSH SHARED POOL (Added: 23-Feb-2008 Hits: 2856 Rating: 0 Votes: 0) Rate It

• Check Session Level Hit Ratio - The Hit Ratio should be higher than 90% (Added: 6-Nov-2000 Hits: 6273 Rating: 7.00 Votes: 3) Rate It

• copying the data from one database to another - If you want to copy the data from one database to another having many tables and constraints,all you need is this script which will first disable all the constraints then delete the prior data and then finaly copy the data from any remote database and finaly it enables all the constraints on the table of that database.......all you need is to have a table having names of all the tables and the corresponding constraints (Added: 6-Dec-2006 Hits: 3641 Rating: 0 Votes: 0) Rate It

• List Session Specific Memory - List the UGA and PGA used by each session on the server (Added: 13-Aug-1999 Hits: 7919 Rating: 8.00 Votes: 3) Rate It

• List the size of Stored Procedures and use it to tune Shared Pool - This script lists the size of stored objects (Added: 21-Oct-1999 Hits: 6867 Rating: 5.00 Votes: 1) Rate It

Next 10