Home » RDBMS Server » Server Administration » Monitoring alerts and logs. (Oracle 11.2.0.3 AIX)
Monitoring alerts and logs. [message #572986] Wed, 19 December 2012 04:13 Go to next message
skyeland
Messages: 4
Registered: December 2012
Junior Member
Hi.

I'm a begginer in Oracle's administration.
I have version 11.2.0.3 installed in a server AIX and i'd like to know where are alerts and logs like "max extents reached in table....". I don't see them in alert.log.
Where is the best way to monitoring this class of alerts and logs?
How can i see how many actuals extents go consumed in tables and indexes?

Could you help me?

Sorry for my English.

Thanks very much.
Re: Monitoring alerts and logs. [message #572987 is a reply to message #572986] Wed, 19 December 2012 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are nowhere.

Quote:
How can i see how many actuals extents go consumed in tables and indexes?


dba_segments
dba_extents

Regards
Michel
Re: Monitoring alerts and logs. [message #572989 is a reply to message #572987] Wed, 19 December 2012 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 59283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here are some scripts for you.

How to get all objects that can't allocate next extend
How to get all objects that can't extend

Regards
Michel
Re: Monitoring alerts and logs. [message #573006 is a reply to message #572989] Wed, 19 December 2012 12:08 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

Your provided links are required username and password. Kindly provide the same or provide the link which we can see directly.

Regards,
Ishika
Re: Monitoring alerts and logs. [message #573007 is a reply to message #573006] Wed, 19 December 2012 12:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just register to the site.

Regards
Michel
Re: Monitoring alerts and logs. [message #573010 is a reply to message #573007] Wed, 19 December 2012 13:19 Go to previous messageGo to next message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
I have been running the following script for the past 12 years to identify tablespaces that need more space and have only had space issues 3 times in the past 12 years. In the last 5 years we have only had 1 space issue where I missed an index tablespace that had grown too fast (since it was a new application).
ECSCDAP1P > select tablespace_name, 'Tablespace needs more space.'
  2  from dba_tablespaces a
  3  where tablespace_name not like '%TEMP%'
  4  and not exists
  5  (select 1 from dba_data_files b   -- if five gig of extendable space, tablespace OK
  6  where b.tablespace_name=a.tablespace_name
  7  and autoextensible='YES'
  8  and maxbytes/1024/1024-bytes/1024/1024 >=4999
  9  and maxbytes > 0)
 10  and not exists
 11  (select 1 from dba_free_space c  -- if five gig free within any datafile, tablespace OK
 12  where c.tablespace_name=a.tablespace_name
 13  and bytes/1024/1024 >= 4999);

TABLESPACE_NAME                'TABLESPACENEEDSMORESPACE.'
------------------------------ ----------------------------
SYSAUX                         Tablespace needs more space.
SYSTEM                         Tablespace needs more space.

Re: Monitoring alerts and logs. [message #573119 is a reply to message #572986] Fri, 21 December 2012 02:19 Go to previous messageGo to next message
skyeland
Messages: 4
Registered: December 2012
Junior Member
Thanks you very much.

Any answer about where is logged error ora-01631 max extents reached in table....?

[Updated on: Fri, 21 December 2012 02:20]

Report message to a moderator

Re: Monitoring alerts and logs. [message #573124 is a reply to message #573119] Fri, 21 December 2012 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not logged.

Regards
Michel
Re: Monitoring alerts and logs. [message #573125 is a reply to message #573124] Fri, 21 December 2012 03:04 Go to previous messageGo to next message
skyeland
Messages: 4
Registered: December 2012
Junior Member
Ok. I didn't know that.

Thanks.
Re: Monitoring alerts and logs. [message #573126 is a reply to message #573125] Fri, 21 December 2012 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you get the scripts?

Regards
Michel
Re: Monitoring alerts and logs. [message #573127 is a reply to message #573126] Fri, 21 December 2012 03:11 Go to previous message
skyeland
Messages: 4
Registered: December 2012
Junior Member
Yes, I registered to the site and i get them.

Thanks.
Previous Topic: ORA-600 [4454]
Next Topic: long data type illegal?
Goto Forum:
  


Current Time: Wed Oct 01 04:45:19 CDT 2014

Total time taken to generate the page: 0.21902 seconds