Below section I have tried to present all the important features in Oracle Database management
Oracle Advanced Queuing provides message queuing as an integrated part of the Oracle Server, thereby creating a message-enabled database. Oracle uses the following components to deliver AQ fuctionality: Message A message is the smallest unit of information inserted into and retrieved from a queue. It contains user data (payload) in the form of an object …
Oracle Advanced Queuing Read More »
In this post, I will explain How to create ADDM task and check its report We are using start snapshot as 900 And end snapshots as 950 BEGIN — Create an ADDM task. DBMS_ADVISOR.create_task ( advisor_name => ‘ADDM’, task_name => ‘900_950_AWR_SNAPSHOT’, task_desc => ‘Advisor for snapshots 900 to 950.’); — Set the start and end …
You can restored a database from the backup and applied lots of archive to make it consistent. Now you would like to make sure open resets logs goes fine.Here is how to check Database is consistent after incomplete recovery The below statement set the date format to extended form as we would be requiring this …
how to check Database is consistent after incomplete recovery Read More »
Oracle database 12c is the latest release of Oracle database. As per Oracle ,this is first database designed for Cloud enablement. It also comes with lot of new features to enable consolidation, Security. Here i am presenting the top 10 oracle 12c new features Pluggable Databases Through Database Consolidation: Oracle is doing every thing to …
There are certain keywords in oracle which can be used restrictively only. These values are defined in v$reserved_words table SQL> desc v$reserved_words; Name Null? Type —————————————– ——– —————————- KEYWORD VARCHAR2(30) LENGTH NUMBER RESERVED VARCHAR2(1) RES_TYPE VARCHAR2(1) RES_ATTR VARCHAR2(1) RES_SEMI VARCHAR2(1) DUPLICATE VARCHAR2(1) -A value of column reserved Y means that the keyword cannot be used …
Many times RMAN session hangs or gave different types of errors. The investigation cannot be done with log files generated. We need to debug rman session in order the performance issues or the errors. With debugging a detailed trace file is generated where we can easily find the performance issue and errors The RMAN Debug …
How to debug Oracle RMAN session Read More »
