Session is INACTIVE when it is making a SQL call to Oracle Database - Managing Oracle Database Processes

Q.  A session is INACTIVE when it is making a SQL call to Oracle Database. A session is ACTIVE if it is not making a SQL call to the database.
- Published on 19 Oct 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 23 Sep 15
    - To identify which session to terminate, specify the session index number and serial number.

    - To identify the system identifier (SID) and serial number of a session, query the V$SESSION dynamic performance view.

    - A session is ACTIVE when it is making a SQL call to Oracle Database.

    - A session is INACTIVE if it is not making a SQL call to the database.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)