Database Tuning (MOSC)

MOSC Banner

High User I/O in 11g vs 10g, bug?

edited Dec 16, 2014 12:37PM in Database Tuning (MOSC) 5 commentsAnswered ✓

Do you think I am experiencing a bug in 11g? When I run a simple query to view the free space on my tablespaces there is high user I/O against the database. The query takes 2 minutes to run in 11g however in my 10g database it only takes 1 second. This same issue can be reproduced/compared in my testing 11g/10g environments.


This slowness also occurs if I use a tool (DBartisan) to view the tablespaces in the 11g database)


Test query:

SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024/1024 "FREE SPACE(GB)"
FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME


Database: Enterprise Edition Release 11.2.0.3.6 single-instance using ASM

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center