Some times it is necessary to know which users are using the temporary tablespace. As some times the temporary tablespace might get filled up and if autoextend on, than it can make the file system fill, which can create a severe problem for a DBA.
We can check from SQL Plus which users are using the temporary tablespace.
Here is the query which can be used.............
SELECT b.tablespace, ROUND(((b.blocks*p.value)/1024/1024),2)'M' "SIZE", a.sid','a.serial# SID_SERIAL, a.username, a.program FROM sys.v_$session a, sys.v_$sort_usage b, sys.v_$parameter p WHERE p.name = 'db_block_size' AND a.saddr = b.session_addr ORDER BY b.tablespace, b.blocks
/
This blog contains different things for Oracle DBA and APPS DBA. All these things should be tested first on test environments. Also to make this blog more useful, please give your comments and share your experience. Thanks
Search This Blog
Subscribe to:
Posts (Atom)
Oracle Weblogic 12.2.1.3.0 60820: Select a domain which is a compatible with this environment. stopComponent.sh and start Component.sh give...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
-
Introduction: We use EMC BCV feature to clone our production database, and it was all working fine, but suddenly we started getting the erro...
-
Introduction: In this article we will see, the impact of "Parallel" clause of rebuilding a partition index. We would also enable t...