In this article we will see types of partitions available in Oracle. Range Partitioning : Range Partitioning works with range of column values. It sets lower boundaries and upper boundaries to the partition. It is widely used with DATE data types. Lets create one range partition to understand it better.It is generally used with DATE […]
Category: ORACLE DATABASE
Index Partitioning
In previous article we saw what is partitioning in oracle and the benefits it brings . http://oracle-help.com/oracle-database/oracle-partitioning/ In this article we will see Index partitioning. Indexes are the essential part of any SELECT and DML operations which we run on the database. So , when we tune the table we must consider […]
Oracle Partitioning
As a DBA we must have heard about Partitioned tables or Partitioned index in our tenure or may be we have used it at some extent.Here in this post we will see what is Partitioning and what benefits it brings. The first question that arises is What is Partitioning ? Partitioning means dividing your large […]
How Select Statement Works
When Oracle receives a sql query, it requires to run some pre-tasks before actually being able to really run the query. Combination of these tasks is called parsing. During parsing the below operations used to perform. Database validate the syntax of the statement whether the query is valid or not.For example, the following statement fails […]
Explore the Automatic Diagnostic Repository (ADR)
ADR – Automatic Diagnostic Repository is a file-based directory structure formed in a hierarchical way to store diagnostic information of the database. For each database instance, ADR directories are created and maintained. In 12c release two, it is not changed. Hence we are having one instance for root container only. ADR directories are managed for […]
Oracle Gateway Installation for MSSQL Server on RHEL 7
Recover From Redo Log File
This post explains about the steps are used by DBA for recovery From Redo Log File. Check the archive log status SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 2 Current log sequence 4 List the tablespaces SQL> select name from v$tablespace; NAME —————————— […]
Advantage Of RMAN in Oracle
This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits. RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]
Feature Enable In Oracle
Note: Just illustration for fun It in fact violates the license. This is only study purpose. All Features are enable in EE (Enterprise Edition). Actually some features not enabled, if you are using Oracle SE (Standard Edition). Follow the point to see the feature is enable or not in (SE) . In my case 1. […]
How to connect to ASM Instance Remotely
Today we have looked over ASM Instance Remotely. We can see that the normal instance of RDBMS is different from ASM. Connect to ASM Instance Remotely Being DBA we are aware that By Default Oracle ASM don’t allow remote sysdba connection since ASM instance is in NOMOUNT state. You Might get ORA-12528: TNS:listener: all appropriate […]