Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In this article I will continue to explain Oracle Automatic Storage Management. Before reading this article, I suggest you read the previous article. “Oracle Automatic …
Read More »ORACLE
Oracle Automatic Storage Management -1
In this article, I will explain the Automatic Storage Management (ASM) and ASM disk operations that come with the 10g version to the Oracle Database. …
Read More »Run commands from a single server on all cell nodes or compute nodes on Exadata(dcli utility)
You can run commands on all the compute nodes or cell nodes from a single server on Exadata. We can use the dcli utility …
Read More »How To Keep Same Password For Oracle User When Its EXPIRED(GRACE) State
Users’ passwords are valid for the duration of PASSWORD_LIFE_TIME in their profile. At the end of this period the password expires and must be …
Read More »How To Move OCR and Vote Disks to Different ASM Disk Groups
Generally, for the Oracle Cluster Registry and Vote Disks, the disk group where the database files are stored is used in RAC Systems. The …
Read More »ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
When the BSLN_MAINTAIN_STATS_JOB job ends with ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” and “ORA-06502: PL/SQL: numeric or value error” errors, the baseline …
Read More »How To Check if Oracle instance was started with pfile or spfile
We can learn the parameter file in which the database is opened by querying the spfile and pfile parameter value. If both the spfile and …
Read More »ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
When you try to import the export from a database on Exadata to a database that is not on Exadata storage, Pillar Axiom storage …
Read More »ORA-08104 error received during index rebuild process
During the process of an online index rebuild operation, when the related session is unexpectedly interrupted, even though there is no rebuild process, it …
Read More »Hybrid Columnar Compression
Hybrid Columnar Compression (HCC) introduced with Oracle Database 11g Release 2. HCC is a feature that can be used with Exadata storage, Pillar Axiom …
Read More »