Home » RDBMS Server » Enterprise Manager » Oracle Enterprise Manager
Oracle Enterprise Manager [message #273686] Thu, 11 October 2007 06:29 Go to next message
Messages: 19
Registered: October 2006
Junior Member

A few users have been complaining of system slowness, so I checked for space issues in the enterprise manager console, the thing is i'm pretty new to oracle admin, and i'm a bit confused as to what im seeing, for instance, if i look at the tablespaces the temp tablespace shows ar 99.97% used, but if i look at the actual datafile it shows as 0% used, which one is correct? apart from that there is free space in all tablespaces/datafiles.

Can someone explain to me what i'm seeing and why both views are different and also where i might check to find the cause of the system slowness ( if it is an oracle issue )

we are using oracle version 10G and running IFS as our ERP system.


Re: Oracle Enterprise Manager [message #273694 is a reply to message #273686] Thu, 11 October 2007 06:36 Go to previous message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't worry about temp file usage, it is always full this is how Oracle works.
Figures are meaningless.


[Updated on: Thu, 11 October 2007 06:37]

Report message to a moderator

Previous Topic: SYS able to login using sqlplus but not at EM dbconsole
Next Topic: Enterprise problem on PC
Goto Forum:

Current Time: Mon Oct 24 01:02:20 CDT 2016

Total time taken to generate the page: 0.20577 seconds