Oracle SQL V$

• Created: October 28, 2019
• Last Modified: October 30, 2019

Here are some popular commands to use in Oracle Database.

If some of these don’t work, it is most likely permission issues.

Session Wait Events

• V$SESSION
• V$SESSION_WAIT
• V$SESSION_EVENT
• V$SESS_TIME_MODEL

Long Running Queries

• V$SQL
• V$SESSION_LONGOPS

Session Counters

• V$SESSTAT

↑ Back to topShare on Twitter