Skip to Main Content

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!

Very long parallel operations not showing up in v$session_longops...

3826378Feb 14 2019 — edited Feb 15 2019

Hi,

We're on 12.2 on IBM AIX platform.

Have you already seen this ?: you have plenty of sessions in v$px_session, sometimes

for hours, but session IDs (whether it be the coordinator or the slaves) cannot be found

in v$session_longops.

If you already experienced this - found out the cause ? What was it due to ? Could you

solve this ?

Thanks.

Regards,

Seb

Comments
Post Details
Added on Feb 14 2019
9 comments
761 views