-
Monitoring Full tablescans
SQL> select name,value
2 from v$sysstat
3 where name like 'table scans%'
4 ;
NAME VALUE
----------------------------------------------------------------
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
NAME TYPE VALUE
------------------------------------ ------- --------------
db_file_multiblock_read_count integer 32
should i increase db_file_multiblock_read_count and how much it is needed to be increased?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|