Question

What SYSTEM VARIABLE is used to refer DATABASE TIME ?

(a) $$dbtime$$

(b) $$time$$

(c) $$datetime$$

(d) None of the Mentioned

This question was posed to me in an interview.

The origin of the question is Installing Oracle Database 11g and Creating a Database in chapter Oracle Database 11g Architecture Options of Oracle

Answer 1

Right choice is (a) $$dbtime$$

The explanation is: The DB time Oracle metric is the amount of elapsed time (in microseconds) spent performing Database user-level calls.