Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Space Left in Oracle Tablespace used by Enterprise Analyzer Workspace

Space Left in Oracle Tablespace used by Enterprise Analyzer Workspace

Problem:

Within an Oracle database, the Enterprise Analyser tables are owned by a schema, but stored within tablespaces. How can you tell how much space is left in the tablespaces and can you continue to use your Workspace?

 

Resolution:

When the Oracle tablespaces are created various options can be specified including maximum size. It is worth doing a regular check on the tablespaces within the database to see if they are close to being full and if any more storage needs to be allocated to the tablepaces.

If the tablespace becomes full, you will not be able to add any programs to the workspace or verify programs without deleting your metrics.

It is advisable to regularly run queries against the database to check on the size of the tablespaces to see if they need to be extended or if more data files added to the tablespaces.

In a large organisation this task may well be performed by an Oracle DBA, but for test databases this may have to be performed by the master user of the Enterprise Analyser workspace.

The query that is attached to this Wiki is an example of a script that can be run to get information about the usage of the tablespaces within the Oracle database. The query will format the output to make it more useful.

3480.Check_Oracle_Tablespaces.sql

It is possible to have tablespaces configured to auto extend, in those situations your concern then becomes ensuring that you have enough disk space for the tablespace.

There are two other related articles:

1. Adding another Data File to Oracle Tablespace used by Enterprise Analyzer Workspace  - Has an attached script that can be used to add data files to a table space 

2. Moving Oracle Tablespace - Has an attached script that can be used to move a data file to another disk.

 

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-03-26 06:27
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.