SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to know if a certain "TABLESPACE" is being used currently?

459628Jan 3 2007 — edited Jan 4 2007

Hi,

I am wondering how could I know if a certain "TABLESPACE" is being used/accessed currently?

The thing that, I want to drop a "TABLESPACE" and re-create it with "AUTOEXTEND" feature and I want to be sure that this "TABLESPACE" is not being used/accessed at that time so I will avoid any crashing.

I am using Oracle 9i under HP-UNIX platform and there are too many UNIX automated CRON jobs that are doing SQL stuff; that's why I want to be sure that this "TABLESPACE" which I want to re-create in not being used by any job/user at the time of re-creating.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2007

Added on Jan 3 2007

16 comments

1,422 views