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

Wednesday, 15 August 2007

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.

About Me

I have more than 15 years of experience in IT. I am working being Senior Database Administrator / APPS DBA for an IT consultng company in New Zealand. I am Oracle Certified Professional DBA in Oracle 7.3, 8.0, 8i, 9i and 10g. I have worked on Oracle 10g RAC, Oracle Replication and Oracle Data Guard technologies.