How to Check Temp file Size in Oracle Database

Question

338 views19/04/2023Oracle Database

0

Ezana886 18/04/2023 0 Comments

How to Check Temp file Size in Oracle Database? DBA scripts to check Temp file Size in Oracle Database?

Amen Answered question 19/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-19T06:29:50+00:00

DBA scripts to check Temp file Size in Oracle Database:

SQL >   SELECT TABLESPACE_NAME,FILE_NAME,bytes/1024/1024 "SIZE MB",AUTOEXTENSIBLE,MAXBYTES/1024/1024 "MAX SIZE MB" FROM DBA_TEMP_FILES ;