-
Can any one telle me as to what are Hot spots in Oracle?
Sabitabrata
-
I think hotspots refer to files with a lot of I/O activity going on. In tuning for performance, you don't want many 'hotspots' so to say, and instead would like the I/O to be distributed more evenly among the various datafiles, tablespaces and disks.
To detect the 'Hotspots', you can use the V$FILESTAT view and join it with V$DATAFILE.
Select n.filename, f.phyrds, f.phywrts, f.avgiotim
from v$datafile n, V$filestat f
where n.file# = f.file# ;
-
A particular block or datafile on the disk experincing very high amount of I/Os are called hot spots. It happens if the I/Os are not evenly distributed across the available disks.
Sanjay
-
-
there are hot spots in buffer cache as well but the concept is basically the same as datafiles, to check for hot spots in buffer cache you have to check for cache buffer chain latch from v$latch_children then join with x$bh (addr and laddr) and order by touch counts in x$bh
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
|