oracle 11g scripts for dba code example

Example: oracle 11g scripts for dba

SQL>  @gerador_awr   

====>Showingthe  AWR Settings Inverval/Retention

        Minute             Minute              Days  
    Snapshot Interval  Snapshot Retention Snapshot Retention 
    
    -----------------  ------------------ ------------------ 
    
    60               11520                  8 
 
 ====>Enteringthetypeof  AWR Report: [html/text]: text


 ====>Enteringthenumberofdaysof  snapshots listed: 1 
 
  DBID    SNAPID    BEGIN_TIME          END_TIME         
------------ ------ ----------------  -----------------
665418562      2626 15/12/2014 00:00   15/12/2014 01:00
               2627 15/12/2014 01:00   15/12/2014 02:00
               2628 15/12/2014 02:00   15/12/2014 03:00
               2629 15/12/2014 03:00   15/12/2014 04:00
               2630 15/12/2014 04:00   15/12/2014 05:00
               2631 15/12/2014 05:00   15/12/2014 06:00
               2632 15/12/2014 06:00   15/12/2014 07:00
               2633 15/12/2014 07:00   15/12/2014 08:00
               2634 15/12/2014 08:00   15/12/2014 09:00
               2635 15/12/2014 09:00   15/12/2014 10:00
               2636 15/12/2014 10:00   15/12/2014 11:00
               2637 15/12/2014 11:00   15/12/2014 12:00
               2638 15/12/2014 12:00   15/12/2014 13:00
               2639 15/12/2014 13:00   15/12/2014 14:00
               2640 15/12/2014 14:00   15/12/2014 15:00
               2641 15/12/2014 15:00   15/12/2014 16:00
               2642 15/12/2014 16:00   15/12/2014 17:00
               2643 15/12/2014 17:00   15/12/2014 18:00
               2644 15/12/2014 18:00   15/12/2014 19:00
               2645 15/12/2014 19:00   15/12/2014 20:00
               2646 15/12/2014 20:00   15/12/2014 21:00
               2647 15/12/2014 21:00   15/12/2014 22:00
               2648 15/12/2014 22:00   15/12/2014 23:00
               2649 15/12/2014 23:00   16/12/2014 00:00
         
         ====>Enteringthe  BEGIN SNAP ID : 2630 
      ====>Enteringthe  END SNAP ID : 2640
      
        Generation  AWR SNAPID ...2630 TO 2640
        WORKLOAD  REPOSITORY report for

        DB  Name    DB Id Instance Inst Num    Startup Time     Release      RAC
        ----------  -------------- ----------- ---------------- -----------  ----
        dbtst       665418562 dbtst1      1    11-Oct-14 19:57  11.2.0.4.0   YES

        Host  Name        Platform               CPUs Cores Sockets  Memory(GB)
        ----------------  ---------------------- ---------  -------- ----------
        dm01dbadm01.pass  Linux x86 64-bit            48        24     2 251.99

        Snap Id          Snap  Time          SessionsCurs/SessInstances
        ---------        --------------      --------------------------
        Begin Snap: 2630 15-Dec-14 05:00:00  2,3684.9        2
        EndSnap:    2631 15-Dec-14 06:00:03  2,3684.9        2
        Elapsed:         60.04 (mins)
        DB Time:         0.17 (mins)

        Load Profile      Per Second   Per Transaction  Per Exec  Per  Call
        ~~~~~~~~~~~~~~~   -----------  --------------- ---------  ---------
        DB Time(s):               0.0              0.4      0.00       0.00
        DB CPU(s):                0.0              0.4      0.00       0.00
        Redosize  (bytes):      634.1         95,187.8
        Logicalread  (blocks):   30.7          4,603.3
        Blockchanges:             1.6            240.5
        Physicalread  (blocks):   0.0              1.3
        Physicalwrite  (blocks):  0.2             33.8
        Read  IO requests:        0.0              1.3
        Write IO requests:        0.2             26.6
        Read IO (MB):             0.0              0.0
        Write IO (MB):            0.0              0.3
        RAC GC blocksreceived:    0.2             32.7
        RAC GC blocksserved:      0.1             21.8
        Usercalls:                1.6            233.1
        Parses (SQL):             1.0            151.2
        Hard parses (SQL):        0.0              5.3
        SQL WorkArea (MB):        0.1             16.5
        Logons:                   0.1             11.0
        Executes (SQL):           1.7            249.7
        Rollbacks:                0.0              0.0
        Transactions:             0.0

        InstanceEfficiencyPercentages  (Target 100%)
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Buffer Nowait %:  100.00 RedoNoWait %:      100.00
        Buffer   Hit   %:  99.97 In-memorySort  %:  100.00
         
        output  removido
        output  removido
        ...
        ...
        output  removido
        output  removido
         
            .00      0      0      0            0
        -----------------------------------------------------------------------
        DynamicRemasteringStats   DB/Inst: PREPROD/preprod1  Snaps:  2638-2639

        No data exists for thissectionofthe report.
        ------------------------------------------------------

        EndofReport

Tags:

Misc Example