This content has been marked as final. Show 5 replies
This is your load profile.
86 percent of your snapshot interval is devoted to the system using CPU on behalf of the end-users.
This is quite good!
db file sequential read: the database is waiting for a block from disk
db file scattered read: the database is waiting for db_file_multiblock_read_count blocks.
log file sync: the database is waiting for a commit to complete.
Senior Oracle DBA
Hm, to me that profile looks more like an app putting load on the database server... but either way, you can't really tell just by looking at a few context-less numbers.
Sorry am a bit confused by the replies. Someone says it is good, others say bad.
There is an application running against the DB.
I will review the metalink note
Sorry am a bit confused by the replies. Someone saysThat was sort of my point. Maybe, for example, the log write is a problem, but unless you have a real, specific performance issue then it's just chasing numbers and a waste of time.
it is good, others say bad.