Database Tuning (MOSC)

MOSC Banner

Improve less Access Disk and memory my ratio bad

edited Nov 20, 2015 10:05AM in Database Tuning (MOSC) 15 commentsAnswered

hello,


    I try to improve the disk's access number :

i notice that i have plenty of number access disk comparing my access memory then :


1 - i would like understand how may i improve it and by which method i could improve it.

2 - i would like less my %bad ?

3 - have i my tablespace of data or indexe unorganized ?

4 - have i to increase the number of read per block ? by  db_file_multiblock_read_count = 12 ?


what do you think ?

thank you for your help.

regards

JP

I executed this query then :

select
   buffer_gets,disk_reads,executions,b.piece,((disk_reads*1000)+buffer_gets)/tot.sumed*100  "% Bad" ,b.sql_text

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center