Home » RDBMS Server » Performance Tuning » Tempfile readtime and Writetime (DB version 9.2.0.7 AIX)
Tempfile readtime and Writetime [message #380848] Tue, 13 January 2009 10:30 Go to next message
dbcop
Messages: 37
Registered: September 2006
Location: india
Member
I need to find the readtim and write time on temporary datafiles

Apart from statspack is there any data dictionary to find out for the same.

I guess v$filestat gives the readtime and writetime for all the datafiles except the tempfiles.

Thanks
Re: Tempfile readtime and Writetime [message #380859 is a reply to message #380848] Tue, 13 January 2009 10:45 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
v$tempstat
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2165.htm
Previous Topic: query taking lot of time
Next Topic: Performance issues
Goto Forum:
  


Current Time: Sun Dec 04 12:42:23 CST 2016

Total time taken to generate the page: 0.09522 seconds