My Oracle Support Banner

Accessing the Tablespace Page in the Enterprise Manager Database Control Web Site Times Out with Browser Errors or is Extremely Slow (Doc ID 1906088.1)

Last updated on MAY 27, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.4 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Timeout errors are given in the Database Control web site when accessing tablespace details.  For example, firefox shows:

The connection has timed out

 

Sometimes the tablespace details will display, but the page will be extremely slow to display them.

When the following query, which Database Control uses to display the tablespace information is run manually at sqlplus, the query also takes a large amount of time to run:

WITH df AS (SELECT tablespace_name, SUM(bytes) bytes, COUNT(*) cnt, DECODE(SUM(DECODE(autoextensible,'NO',0,1)), 0, 'NO', 'YES') autoext FROM dba_data_files GROUP BY tablespace_name), tf AS ( SELECT tablespace_name, SUM(bytes) bytes, COUNT(*) cnt, DECODE(SUM(DECODE(autoextensible,'NO',0,1)), 0, 'NO', 'YES') autoext FROM dba_temp_files GROUP BY tablespace_name) SELECT d.tablespace_name, NVL(a.bytes / 1024 / 1024, 0), NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024, NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), a.autoext, NVL(f.bytes, 0) / 1024 / 1024, d.status, a.cnt, d.contents, d.extent_management, d.segment_space_management FROM dba_tablespaces d, df a, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_free_space GROUP BY tablespace_name ) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT d.contents = 'UNDO' AND NOT ( d.extent_management = 'LOCAL' AND d.contents = 'TEMPORARY' ) AND d.tablespace_name LIKE '%%' UNION ALL SELECT d.tablespace_name, NVL(a.bytes / 1024 / 1024, 0), NVL(t.ub*d.block_size, 0)/1024/1024, NVL((t.ub*d.block_size) / a.bytes * 100, 0), a.autoext, (NVL(a.bytes ,0)/1024/1024 - NVL((t.ub*d.block_size), 0)/1024/1024), d.status, a.cnt, d.contents, d.extent_management, d.segment_space_management FROM dba_tablespaces d, tf a, (SELECT ss.tablespace_name , sum(ss.used_blocks) ub FROM gv$sort_segment ss GROUP BY ss.tablespace_name ) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management = 'LOCAL' AND d.contents = 'TEMPORARY' and d.tablespace_name LIKE '%%' UNION ALL SELECT d.tablespace_name, NVL(a.bytes / 1024 / 1024, 0), NVL(u.bytes, 0) / 1024 / 1024, NVL(u.bytes / a.bytes * 100, 0), a.autoext, NVL(a.bytes - NVL(u.bytes, 0), 0)/1024/1024, d.status, a.cnt, d.contents, d.extent_management, d.segment_space_management FROM dba_tablespaces d, df a, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_undo_extents where status in ('ACTIVE','UNEXPIRED') GROUP BY tablespace_name ) u WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = u.tablespace_name(+) AND d.contents = 'UNDO' AND d.tablespace_name LIKE '%%' ORDER BY 1

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.