tablespace question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: tablespace question

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    Is there a way to find if tablespace is currently being used?

  2. #2
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    The tablespace will be in use when the database is up and all the datafiles will be stamped during a checkpoint.

    What is your question? Do you want to find out if any users are using it by creating data in some of the tables which are in that tablespace? Then you can analyze the tables in that tablespace and check the avg space used. If that is changing or the table size is changing then the tablespace is in use.

    Baliga

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    As Baliga told, all the tablespaces which are online are in use.
    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Sep 2000
    Posts
    96
    If you are wanting to see the status (online or offline) of the tablespace, use the following query:

    select tablespace_name, status from dba_tablespaces;


    If the tablespace is offline is not available for data access.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width