Home » RDBMS Server » Performance Tuning » Tempfile readtime and Writetime (DB version AIX)
Tempfile readtime and Writetime [message #380848] Tue, 13 January 2009 10:30 Go to next message
Messages: 37
Registered: September 2006
Location: india
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.

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
Previous Topic: query taking lot of time
Next Topic: Performance issues
Goto Forum:

Current Time: Sun Oct 23 03:40:37 CDT 2016

Total time taken to generate the page: 0.10649 seconds