Home » RDBMS Server » Server Administration » Monitoring Full tablescans
Monitoring Full tablescans [message #193535] Mon, 18 September 2006 02:42 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
SQL> select name,value
2 from v$sysstat
3 where name like 'table scans%'
4 ;

table scans (short tables) 6599797
table scans (long tables) 14003
table scans (rowid ranges) 0
table scans (cache partitions) 0
table scans (direct read) 0

SQL> show parameter db_file_multiblock_read_count

------------------------------------ ------- --------------
db_file_multiblock_read_count integer 32

should i increase db_file_multiblock_read_count and how much it is needed to be increased?
Re: Monitoring Full tablescans [message #193558 is a reply to message #193535] Mon, 18 September 2006 04:47 Go to previous messageGo to next message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
No you shouldn't increase or decrease db_file_multiblock_read_count.
The value of that parameter should mirror the actual physical multiblock read count of the disks that your database is on.

You can gether System Statistics to measure what this value is if you don't know it.

On a related note, Tuning your system by changing the init-ora parameters and seeing what happens is probably the worst way of going about it.
Re: Monitoring Full tablescans [message #193897 is a reply to message #193558] Tue, 19 September 2006 17:54 Go to previous message
Messages: 9
Registered: March 2004
Junior Member
What Oracle Version are you using ?

Tables Statistics are present on your tables and indexes ?

optimizer_mode = ?

Previous Topic: Rebuild index Script and Move tables to a different tablespace
Next Topic: How to allocate space for next extent whne no space hard disk.....
Goto Forum:

Current Time: Mon Oct 24 15:56:05 CDT 2016

Total time taken to generate the page: 0.08407 seconds