DBA Hub

📋Steps in this guide1/1

Temp tablespace details in Multitenant

select a.name,b.FILE_ID,b.tablespace_name,b.file_name from V$CONTAINERS a , CDB_TEMP_FILES b where a.con_id=b.con_id;

oracle configurationintermediate
by OracleDba
13 views
1

Temp tablespace details in Multitenant

Code/Command (click line numbers to comment):

1
select a.name,b.FILE_ID,b.tablespace_name,b.file_name from V$CONTAINERS a , CDB_TEMP_FILES b where a.con_id=b.con_id;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!