AWS Elastic Block Storage (EBS) GP3 Vs GP2

AWS announced a new type of volume called gp3 in re:Invent 2020 by Andy Jassy, which is latest offering of general purpose Elastic Block Storage (EBS).  The new EBS volume gp3 is 20% cheaper than gp2. As you might be aware, 1GB of gp2 volume provides 3 IOPS and someone can add more storage to achieve a higher number of IOPS. Applications which require more IOPS, you would need to grow the volumes size which will increase TCO for gp2. 

The new EBS Volume gp3 provides 3000 IOPS by default without any extra cost with 125 MB/s throughput and allows increasing Max Throughput/Volume to 1,000 MB/s. 

gp3 can also be considered to replace io1 and io2 EBS volumes to save costs for organizations. Another thing to note about io1 and io2 that these provide higher durability compared to gp3 and gp2. One has to do their own performance testing for their workload as each workload may be very different. 

GP3 and GP2 Comparison:

Finally, gp3 offers SSD-performance at a 20% lower cost per GB than gp2. Organizations should consider moving to gp3 for better performance and lower cost.

Caution:

• Your AWS account may have a soft limit on size of gp3 available. You would need to work with your account manager or AWS support to address any soft limits.   

More Info:

Introducing new Amazon EBS general purpose volumes, gp3

ADRCI Oracle 11g command line utility

ADRCI (Automatic Diagnostic Repository Command line interpreter)  is new utility introduced in Oracle 11g. ADRCI is part of fault diagnostic infrastructure and used for :

• View diagnostic data in ADR
• View Health Monitor Report
• Package information for Oracle support

ADRCI can be used in interactive mode or in scripts. It is file based repository for database diagnostic data for example traces, alert log. health monitor reports and much more. It provides diagnostic infrastructure for single instance database and Oracle Real Application Cluster.

In order to use ADRCI, you need to setup following parameters (tested on Oracle on AIX):

export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LIBPATH=$ORACLE_HOME/lib

$ adrci
ADRCI: Release 11.2.0.2.0 - Production on Sat May 14 12:49:41 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
ADR base = "/oracle"
adrci> help  
 HELP [topic]
   Available Topics:
        CREATE REPORT
        ECHO
        EXIT
        HELP
        HOST
        IPS
        PURGE
        RUN
        SET BASE
        SET BROWSER
        SET CONTROL
        SET ECHO
        SET EDITOR
        SET HOMES | HOME | HOMEPATH
        SET TERMOUT
        SHOW ALERT
        SHOW BASE
        SHOW CONTROL
        SHOW HM_RUN
        SHOW HOMES | HOME | HOMEPATH
        SHOW INCDIR
        SHOW INCIDENT
        SHOW PROBLEM
        SHOW REPORT
        SHOW TRACEFILE
        SPOOL
 There are other commands intended to be used directly by Oracle, type
 "HELP EXTENDED" to see the list
adrci>

If you have multiple homes, you would need to set to one :
adrci> show homes
ADR Homes:
diag/rdbms/etltst/etltst
diag/rdbms/gprptst/gprptst

adrci> set home diag/rdbms/etltst/etltst
adrci> set home diag/rdbms/etltst/etltst
adrci> show alert -tail -f      2011-05-14 12:53:41.878000 -04:00
  Tns error struct:
    ns main err code: 12535
   
TNS-12535: TNS:operation timed out
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.200.171)(PORT=34814))
WARNING: inbound connection timed out (ORA-3136)
2011-05-14 12:54:12.044000 -04:00

Purge all traces which are older than 60 minutes:
adrci> purge -age 60 -type trace

Following outputs the alert log, without XML tags:

adrci> SHOW ALERT -P "MESSAGE_TEXT LIKE '%ORA-600%'"This displays only alert log messages that contain the string 'ORA-600'. The output looks something like this:

ADR Home = /oracle/product/11r2/db_1/log/diag/rdbms/orclbi/orclbi:
******************************************************************************
01-SEP-06 09.17.44.849000000 PM -07:00
AlertMsg1: ORA-600 dbgris01, addr=0xa9876541

You can also use Oracel Enterprise Manager to review diagnostic by going to Software and Support and then to support workbench:

There is much more...................keep exploring...............