Home » RDBMS Server » Performance Tuning » scripts on tablespaces,Indexes and DBJobs (linux 4.0 with oracle 10g)
scripts on tablespaces,Indexes and DBJobs [message #539976] Thu, 19 January 2012 10:22 Go to next message
faiz123
Messages: 4
Registered: January 2012
Location: Hyderabad,India
Junior Member

Hi all,

I am new to orafaq forum.

I am working in a small org with the db size of 75GB.
I would appreciate if someone can answer the following questions for me...

I am looking for scripts that can send alerts for the following

We have Autoextend on enabled on all the datafiles.

1)Tablespace- monitoring script to see all the datafiles in the tablespaces are below 10GB

2)Indexes Verify if any indexes are broken and corrupted

3)DB Jobs Verify to see if any DB Jobs are running longer than 30 min

Thanks in Advance.

Faiz.
Re: scripts on tablespaces,Indexes and DBJobs [message #539985 is a reply to message #539976] Thu, 19 January 2012 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.
We will help you but we will NOT do your job.
Post what you tried and where you are stuck and we will help you to go further.

Oracle dictionary views are described in Database Reference.
You can quickly find the purpose of view or search for some dictionary views using the DICT view itself.
For instance, to know where free space is recorded you can use:
SQL> col comments format a50 word_wrap
SQL> select * from dict where lower(comments) like '%free%space%';
TABLE_NAME                     COMMENTS
------------------------------ --------------------------------------------------
USER_FREE_SPACE                Free extents in tablespaces accessible to the user
DBA_FREE_SPACE                 Free extents in all tablespaces
DBA_LMT_FREE_SPACE             Free extents in all locally managed tablespaces
DBA_DMT_FREE_SPACE             Free extents in all dictionary managed tablespaces


Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: scripts on tablespaces,Indexes and DBJobs [message #539986 is a reply to message #539976] Thu, 19 January 2012 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I am sorry to see that you are unwilling or incapable of using SEARCH or GOOGLE

http://www.orafaq.com/wiki/Scripts

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: scripts on tablespaces,Indexes and DBJobs [message #541165 is a reply to message #539986] Sun, 29 January 2012 00:39 Go to previous messageGo to next message
faiz123
Messages: 4
Registered: January 2012
Location: Hyderabad,India
Junior Member

Thanks Micheal..Got it...
Re: scripts on tablespaces,Indexes and DBJobs [message #541175 is a reply to message #539976] Sun, 29 January 2012 02:53 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I am looking for scripts that can send alerts for the following
Have you looked at the alert system? There are pre-configured alerts for many conditions, listed in the v$alert_types view. Enable them by setting thresholds with the dbms_server_alert package.If you have Enterprise Edition licences, you can automate notifications by email with OEM, on Standard Edition you have to write your own alert handler (not so difficult.)
Previous Topic: Subquery Transformation
Next Topic: Performance tuning in View
Goto Forum:
  


Current Time: Thu Mar 28 14:21:42 CDT 2024