What is Large Pages and How it benefits Oracle database on IBM AIX AIX support two virtual page sizes: 4 kilobytes (standard page) and 16 megabytes (large page). When using large pages to map virtual memory, there are fewer page boundaries, which improve the performance of prefetching. Both online transaction processing (OLTP) and data […]
Useful Cluster command in Oracle clusterware 10g , 11g and 12c
Oracle clusterware is the clusterware technology from oracle to Manage Oracle RAC database on various platform. Oracle has provide cluster utilities to manage it. Here are some of the useful oracle Cluster command in 10g ,11g and 12c CRSCTL command Cluster Control utility performs various administrative operation of oracle clusterware. It is located in $ORA_CRS_HOME/bin […]
Oracle 12c pluggable database commands
Here are very useful Oracle 12c pluggable database commands which will very helpful in day to day DBA administration for Container and Pluggable database Query to check if the database is CDB or non-CDB SELECT NAME, CDB, CON_ID FROM V$DATABASE; NAME CDB CON_ID ————————— ——— ———- CDB01 YES 0 how to check container database in […]
JSON in Oracle database
Lets first start with what is JSON What is JSON JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition – December 1999. […]
ORA-00001 unique constraint violated
ORA-00001 unique constraint violated is one of the common message we often get while loading data. This ORA-00001 unique constraint violated error occurs when You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. Check list to run to resolve ORA-00001 We can […]
How to find table where statistics are locked
Statistics played in key role for Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the oracle table involved in the SQL queries. You may want to lock statistics in a oracle table in some cases, for example you don’t want a table to be analyzed by schedule statistics job […]
