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

Report message to a moderator

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: 10707
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

Report message to a moderator

Previous Topic: query taking lot of time
Next Topic: Performance issues
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 04:35:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.