Author Archives: anargodjaev

What are Critical Patch Updates (CPUs)?


Critical Patch Updates are sets of patches containing fixes for security flaws in Oracle products. The Critical Patch Update program (CPU) was introduced in January 2005 to provide security fixes on a fixed, publicly available schedule to help customers lower their security management costs. Advertisements

Query to Check Last CPU Applied on a Database


col VERSION for a15; col COMMENTS for a50; col ACTION for a10; set lines 500; select ACTION,VERSION,COMMENTS,BUNDLE_SERIES from registry$history;

How to backup archivelog for specific sequence RMAN


When you issue archive backup commands via RAMN, it will backup all the archive logs. Sometimes, you might need to backup only a particular archive log sequence. Below command will help you backup archive logs between specific sequence RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 355 UNTIL SEQUENCE 479 DELETE INPUT; The above command will backup archive […]

How to check execution plan of a query


First get the sql ID and then you can use below command to generate execution plan of a query in oracle SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR(‘2t3nwk8h97vph’,0)); In case you have more IDs, use below command to supply sql id every time you run the query SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR(‘&sql_id’,0));

How to check high resource intensive SQL in Oracle


Database performance is a major concern for a DBA. SQLs are the ones which needs proper DB management in order to execute well. At times the application team might tell you that the database is running slow. You can run below query to get the top 5 resource intensive SQL with SQL ID and then […]

How to check users, roles and privileges in Oracle


Query to check the granted roles to a user SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = ‘&USER’; Query to check privileges granted to a user SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = ‘USER’; Privileges granted to a role which is granted to a user SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE IN (SELECT granted_role FROM DBA_ROLE_PRIVS […]

RMAN RECOVER TABLE Feature New to Oracle Database 12c (Point in Time TABLE RECOVERY Example)


% rman target sys/oracle@t12ccdb log recover_table5.log RMAN> RECOVER TABLE SMEDS.”RECTEST” OF PLUGGABLE DATABASE T12CPDB1 UNTIL SEQUENCE 64 thread 1 AUXILIARY DESTINATION ‘/testcases/rectbl’ REMAP TABLE ‘SMEDS’.’RECTEST’:’TEST4_RECTEST’; Starting recover at 21-JAN-13 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=16 device type=DISK RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time List of tablespaces expected to have UNDO […]

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr] on 11.2.0.4


Today when I started the DB , It refused to start with error ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]. Below is the workaround … [oracle@TEST ~]$ export ORACLE_SID=ANARDB [oracle@TEST ~]$ sqlplus Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System […]

Exadata cells memory checks


Oracle(R) Integrated Lights Out Manager Version 3.2.10.22.a r121452 Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved. Warning: HTTPS certificate is set to factory default. Hostname: exa1celadm01-ilom -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( exa1celadm01.kfsaz.local login: root Password: [root@exa1celadm01 ~]# […]

Exadata cell current temperature


Oracle(R) Integrated Lights Out Manager Version 3.2.10.22.a r121452 Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved. Warning: HTTPS certificate is set to factory default. Hostname: exa1celadm01-ilom -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( exa1celadm01.kfsaz.local login: root Password: [root@exa1celadm01 ~]# […]

Exadata cell CPU utilization


Oracle(R) Integrated Lights Out Manager Version 3.2.10.22.a r121452 Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved. Warning: HTTPS certificate is set to factory default. Hostname: exa1celadm01-ilom -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( exa1celadm01.kfsaz.local login: root Password: [root@exa1celadm01 ~]# […]

Exadata X4 change from X3


Exadata X4 change from X3

Exadata Storage Expansion Rack X4


Exadata Storage Expansion Rack X4

Exadata Storage Sever X4-2


Exadata Storage Sever X4-2

Exadata Database Machine X4-2


Exadata Database Machine X4-2

Exadata Storage Expansion Rack X3


Exadata Storage Expansion Rack X3

Exadata Storage Sever X3-2


Exadata Storage Sever X3-2

Exadata Storage Expansion Rack X2


Exadata Storage Expansion Rack X2

Exadata Storage Sever X2-2


Exadata Storage Sever X2-2

Exadata Database Machine X2-8


Exadata Database Machine X2-8