About Me

My photo
Pune, Maharashtra, India
Working on Oracle technology for more than 14+ years.Oracle Certified professional. Expertise in Oracle advance technologies like Oracle Real Application Cluster (RAC) , Oracle DataGuard, Oracle ASM, Oracle Golden gate. Experience in Area of migration/Replication of Oracle Database. Expertise in Storage/OS administration,Vertulization, Cloud technology. Activly involed in forum discussion of RAC sig and DBA village.

Friday, November 23, 2012

oracle technology lovers blog: View Free space from temporary tablespace

oracle technology lovers blog: View Free space from temporary tablespace: select substr(a.tablespace_name,1,20) "TS_name", substr(a.file_name,1,35) "File_Name", round(sum(a.bytes)/1024/1024,2) "Size_MB",sum(NVL(b.b...

4 comments: