Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

V$SQL having multiple records for single SQL_ID

TomNov 8 2016 — edited Nov 8 2016

Oracle Version: 11.2.0.4

OS : Oracle Linux 6.5

Clustering : 2-Node RAC

In my database, the following SQL_ID returned 32 records ; all of them showing the same SQL_TEXT .

What does this mean ? Does this mean

1. Multiple sessions are currently running the same SQL ( sql_id = '3z8xfnmqnbm6f' )

or

2. One session is doing several executions of this SQL ?

or

something else ?

select * from v$sql where sql_id = '3z8xfnmqnbm6f'

I retrieved the above SQL_ID from GV$SESSION
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2016
Added on Nov 8 2016
#general-database-discussions
4 comments
3,421 views