Forgot your password?    
+ Reply to Thread
Results 1 to 5 of 5

Thread: mountpoint gets full

  1. #1
    Oracle Administrator
    Join Date
    Apr 2012

    mountpoint gets full

    If mountpoint gets full then how will we know..everytime we dont go to the server and we wont issue df -h.Then how can we know that its getting full?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    You can see it in your alert log. The database may or may not can get hanged. If you are using DBA THRESHOLD you will get the alert when it reaches your given THRESHOLD.


  3. #3
    Oracle Administrator
    Join Date
    Apr 2012
    Like in OEM we will set it for tablespaces and datafiles....not for mount points rite? then how can we know before it gets full?

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    New Delhi, India
    We can set file system alerts in OEM as well.

  5. #5
    Easy Customization of OEM Alerts

    The Oracle10g Enterprise Manager recognizes that no DBA has the time to constantly monitor all of the metrics in real-time and provides an easy to use exception reporting mechanism. Figure 1 shows the MANAGE METRICS screen in which the DBA can easily define a customized alert mechanism for a database.


    Figure :1 The OEM Manage Metrics screen.

    When a drill down into the metric list occurs, OEM displays hundreds of individual tuning metrics and provides the ability to set personalized alert thresholds as shown in Figure 2. OEM allows the DBA to specify any scalar thresholds, such as greater than or less than, and has full pattern matching capabilities for text-based alerts such as alert log messages.

    Figure 2: Setting alert thresholds within OEM.

    For example, DBAs can set an OEM threshold to send them a pager alert or use OEM2GO whenever their critical metrics change. There are several critical instance-wide performance metrics displayed in Figure 2:

    SQL Response Time (%)

    System Response Time (centi-seconds)

    Shared Pool Free (%)

    Because of the time-series nature of AWR, it is easy to trigger an exception alert when the marginal values of any metrics change. All metrics denoted with the (%) are delta-based, meaning that OEM triggers an alert whenever any metric moves by more than a specified percentage, regardless of its current value. This delta-based mechanism is used to allow time to repair a pending performance issue before it cripples the end-users.

    For automated notification, a SNMP interface can be easily configured to have OEM send the DBA a notification e-mail whenever the threshold value has been exceeded. This alert can be an e-mail, a telephone message or an alert on the OEM2GO PDA device.


    Responding to OEM Alerts

    Whenever an alert is received, many DBA’s run ADDM or another advisor to get a more detailed diagnostics of system or object behavior. The DBA can also opt to enable a corrective script to run on receiving an alert as mentioned in Managing Metric Thresholds section.

    If a Tablespace Space Usage alert is received, remedial actions can be taken by running the Oracle10g Segment Advisor on the tablespace to identify objects for shrinking. Those objects can then be coalesced or extended.

    All of the job details, including the schedule, job definition and the broken flag, can be edited within Enterprise Manager by double clicking on the job of interest. Figure 4 shows the edit job dialog.


    Figure 4: OEM: Edit job.

    The run procedure on this screen allows the DBA to run a specified job immediately, with the next_date recalculated from that point. The force parameter indicates that the job queue affinity can be ignored allowing any instance to run the job.

    Job information is also available from Oracle Enterprise Manager (OEM) (Network > Databases > Your-Instance > Distributed > Advanced Replication > Administration > DBMS Job Tab).

    Exception Tuning Inside Enterprise Manager

    The Automatic Diagnostic component of the Oracle Performance OEM screen contains an alert area in which ADDM warns the DBA about historical performance exceptions. This exception-based reporting is very important to Oracle tuning because Oracle databases change rapidly, and transient performance issues are very difficult to detect without an exception-based mechanism.

    Exception reports allow the Oracle professional to view specific times and conditions when Oracle processing demands have exceeded the server capacity. More important, these transient server exceptions give insight regarding repeating server trends.

    Figure 5 is a representation of the OEM alert screen.

    Figure 5: The OEM exception reporting screen

    In Figure 5, the Oracle alerts are located on the top-half of the screen and the external server alerts are located on the bottom half. The server-related alerts are critical to Oracle performance because Oracle10g allows the DBA to relieve server stress by adding additional servers. Common server-related alerts might include:

    CPU utilization: Whenever the CPU run queue exceeds the number of processors on the server, the database is CPU-bound. Actions might include tuning SQL to reduce logical I/O or adding more CPU resources

    Filesystem Shortage: When using Oracle with autoextend datafiles, the only constraint to file growth is the limitation of the OS filesystem. Should a filesystem become unable to accommodate an automatic datafile expansion, Oracle halts the process until additional space is allocated. This monitoring task is critical to ensuring the continuous availability of the database.

    Swap Shortage: The swap disk is used on a virtual processor to store infrequently used RAM frames. When the swap disk becomes full, more disks should be added.

    This ability to perform server-side alerts is extremely valuable to the Oracle professional who must monitor both internal and external Oracle environments.

    The next section shows techniques for extending the OEM functionality for trend-based reporting, and explores the Automated Database Diagnostic Monitor (ADDM) as well as the SQL Tuning Advisor within OEM. A real world Oracle10g migration for an Oracle8i application using the obsolete rule-based SQL optimizer (RBO) is also shown.

    A good understanding of the basic functionality of OEM performance monitoring and how OEM accesses the new AWR database is needed before exploring how Enterprise Manager interprets AWR and ASH information. This information is used to diagnose performance issues with the Automatic Database Diagnostic Monitor (pronounced “Adam”).

    The bottom of the following screen shows the Related Links, including the OEM Advisor Central link as shown in Figure 6

    Figure 6.: The OEM alerts screen with link to Advisor Central.

    This link between the database and server exceptions provides a preview of the exceptional conditions and validates the recommendations from the Advisor Central area of OEM.

    I hope this will help!! Cheers

+ Reply to Thread

Similar Threads

  1. Issues regarding FULL GCs in JVMs and JVM crashing in 11.5.10 EBS environment
    By Chitiz in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 02-29-2012, 03:45 PM
  2. Replies: 0
    Last Post: 11-02-2011, 03:23 PM
  3. Search for installation status of a product based on full name
    By Hemant in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-01-2011, 03:45 PM
  4. Archivelog gets full
    By ajaysingh in forum Core Database Administration and Monitoring
    Replies: 7
    Last Post: 11-01-2011, 11:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training

Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics