Home » RDBMS Server » Server Administration » USERS tablespace is filling fast (oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM)
USERS tablespace is filling fast [message #679415] Fri, 28 February 2020 03:51 Go to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
hi There

my USers tablespace is filling very fast and last day it has consumed 30G of data.i havn't created this database and my EM is also not working now at SQL prompt how can i check that what is going on in this tablespace ? so how can i check what is filling my data


Regards
Re: USERS tablespace is filling fast [message #679417 is a reply to message #679415] Fri, 28 February 2020 04:01 Go to previous messageGo to next message
John Watson
Messages: 8402
Registered: January 2010
Location: Global Village
Senior Member
You had better begin by querying a few views. These would be a good start:
dba_free_space
dba_tablespace_usage_metrics
dba_segments
Re: USERS tablespace is filling fast [message #679421 is a reply to message #679417] Fri, 28 February 2020 04:39 Go to previous messageGo to next message
janakors
Messages: 227
Registered: September 2009
Senior Member
Thank u John but when i try to run query i get error "
ORA-01000: Maximum open curosr exceeded
Re: USERS tablespace is filling fast [message #679430 is a reply to message #679421] Fri, 28 February 2020 05:33 Go to previous message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
Something is running in the background and chewing up all the resources.
Try restarting the DB.
If that doesn't work try starting in restricted mode: startup restrict;
Previous Topic: Oracle Server 11g times out after only a few min online
Next Topic: Calculating the size of the depending on the AUTOEXTENSIBALE
Goto Forum:
  


Current Time: Sat Oct 31 19:45:49 CDT 2020