Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
what is v$timer view?
- Thread starter mohkamal
- Start date
From the Server Reference Manual:
The v$timer shows elapsed time in hundredths of a second. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes (roughly 497 days).
If you wanted to time events, you could query/save the value from v$timer, execute the event, and then query/save the value from v$timer again. The difference between the second and first values will be the elapsed time.
The v$timer shows elapsed time in hundredths of a second. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes (roughly 497 days).
If you wanted to time events, you could query/save the value from v$timer, execute the event, and then query/save the value from v$timer again. The difference between the second and first values will be the elapsed time.
- Status
Similar threads
- Locked
- Question