Views related to Oracle database and session wait events

Several views related to the Oracle database and session wait events, v $ session: the connection will generate a session, and the information of the current session will be saved in v $ session, and the connection will disappear after disconnection; 2. v $ session_wait: copy the waiting session Status in the current session to the view, disconnect and disappear (wait for the last wait of the session lifecycle); 3. v $ sessi

Views related to Oracle database and session wait events 1. v $ session: the connection will generate a session, and the information of the current session will be saved in v $ session, which disappears after the connection is disconnected; 2. v $ session_wait: copy the waiting session Status in the current session to the view, disconnect and disappear (wait for the last wait of the session lifecycle); 3. v $ sessi

Views related to Oracle database and session wait events

1. v $ session: the connection will generate a session. The information of the current session is saved in v $ session and disappears after the connection is disconnected. 2. v $ session_wait: copy the waiting session Status in the current session to the view, and then disappear (waiting for the last wait of the session lifecycle); 3. v $ session_wait_history: save each active session in v $ sess

1. v $ session: the connection will generate a session. The information of the current session is saved in v $ session, and the session disappears after the connection is disconnected;

2. v $ session_wait: copy the pending session Status in the current session to the view, disconnect and disappear (wait for the last wait time of the session lifecycle );

3. v $ session_wait_history: stores the last 10 waiting events of each active session in v $ session_wait (waiting for the last 10 waiting events of the session lifecycle );

4. ASH (v $ active_session_history): it is saved in the memory and sampled from v $ session_wait every second (waiting for the snapshot of the session per second)

5. AWR: The ASH data is sampled and written to the disk every hour. AWR (dba_hist...) is retained for 7 days by default.