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!

direct path read / write temp

don123Jan 12 2023

We are using Oracle 12.2 standard edition.

I used Oracle SQL Developer (Tools->Monitor sessions) to monitor the sessions which are waiting for several minutes. I see the following waits.
image.png
How to proceed further ?
The file is not available in database with no = 201
select file#, ts#, rfile#, status from v$datafile;
1 0 1 SYSTEM
2 1 2 ONLINE
3 2 3 ONLINE
4 4 4 ONLINE
5 4 5 ONLINE
6 4 6 ONLINE
7 4 7 ONLINE
8 4 8 ONLINE

This post has been answered by Jonathan Lewis on Jan 12 2023
Jump to Answer
Comments
Post Details
Added on Jan 12 2023
6 comments
342 views