| Where I get the I/O Info? [message #182941] |
Tue, 18 July 2006 19:39  |
zahoorsunmicrosys4
Messages: 1
Registered: July 2006
Location: USA
|
Junior Member |
|
|
Please tell me whether V$filestat will provide me the I/O information if the below given scenario comes into the picture...
Scenario:
Suppose I am firing a query to get the table information
(eg. EMP table), but the table data is not present in the SGA(buffer cache) but it is founded in the RAM Memory of O/S part as a page.
what happen in this situation?
will V$filestat show the entry in the column of PHYRD for this I/O Operation as the actual I/O is not performed at the O/S level ?
Thanks & Rgds.
Zahoor Ahmad Bhat
[Updated on: Tue, 18 July 2006 19:54] Report message to a moderator |
|
|
|
| Re: Where I get the I/O Info? [message #182944 is a reply to message #182941] |
Tue, 18 July 2006 20:51  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Reported By: zahoorsunmicrosys4 On: Tue, 18 July 2006 19:58 In: RDBMS Server » Performance Tuning » Where I get the I/O Info?
Reason Please give me the tips regarding the question under the subject line " Where I get the I/O Info?".
Reporting your own posting to get attention, will not work.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
