ORA-1652: unable to extend temp segment by %s in tablespace TEMP
This error occur when user running the queries doesn't get the enough free...
Queries to Monitor Expdp Datapump Jobs Status
Being a DBA, you often asked to perform and monitor expdp/impdp - datapump jobs on regular basis. In this post you will get varieties of queries...
How to Find Users having DBA Role in Oracle
The default DBA role is automatically created during Oracle Database installation. This role contains most database system privileges. Therefore,...
dbca UnsatisfiedLinkError exception loading native library java.lang.UnsatisfiedLinkError
Getting below error while installing oracle 11g/12c database using DBCA.
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: /home/u01/app/oracle/product/11.2.0/db_1/lib/libnjni11.so: libclntsh.so.11.1: cannot open shared object file: No such file or directory
Exception...
How to convert scn to a timestamp in Oracle
Oracle has inbuilt features using which you can convert scn to timestamp and timestamp to scn. SCN_TO_TIMESTAMP takes as an argument a number...
How to stop Materialized view Auto Refresh in Oracle
A materialized view is a table segment or database object that contains the results of a query. A materialized view created with the automatic...
How to Flush a Single SQL Statement from the Shared Pool
Sometimes it is required to flush the single sql plan from the shared pool and it a good idea rather than flushing all the sql plan from the...
Best ways to Describe Table in Vertica
There are various ways to describe table in vertica, among some of them are listed below.
List table definition using \d:
=> ...
Script to Monitor RMAN Backup Status and Timings
Being a DBA, you often asked to check the status of RMAN backup job details. There are many ways to monitor the progress of the backup...
Best Way to move all objects from one Tablespace to another in Oracle
Being a DBA, there are many occasions where you need to move all database objects from one tablespace to another to make them reorganized....
How to Fix AHM not Advancing to Last Good Epoch in Vertica
Vertica advances the AHM at an interval of 5 minutes to be equal with Last Good Epoch - LGE. Because of unrefreshed projections due to some...
How to Check the Size of Tables in Vertica
Vertica store table data in compressed format. To get the size of a table in vertica, you can use the below query. By using column_storage and projection_storage system tables you will get the size of table compressed format. You can check the all the column definition from the official vertica sites using below...
How to Change MySQL Data Directory to a New Location on Linux
In this article we will explain how to change the default MySQL data directory to a different mount point or location on a CentOS/RHEL...
Hidden SQL- Why v$sql is not displaying sql_fulltext in Oracle
Recently i came across a situation where i was not able to see the SQL text for my sql_id. Developer and application guys were struggling to fix the backlog piling into the system during data loading. They had configured a piece of code called dbwritter - not a database dbwritter. This process will pick the...
How insert statement works internally in oracle
In this post, we will see the flow and sequence of steps which oracle follow internally for the execution of insert statement. So below are...
How update statement works internally in oracle
In this post, we will see the flow and sequence of steps which oracle follow internally for the execution of update statement.
How...
Network Wait: SQL*Net more data from client in awr report
In one of the sites, I came across a performance issue where data loading task was taking more than usual. After analysing the AWR report,...
How select statement works internally in oracle
In this post we will discuss about the order or flow of execution of select statement in oracle.
To write a select query against an oracle...
How to Enable/Disable ARCHIVELOG Mode in Oracle 11g/12c
When you run the database in NOARCHIVELOG mode, you disable the archiving of the redo log. If you want to take the backup of the database using RMAN then your database must be in ARCHIVELOG mode.
A database backup, together with online and archived redo log files, guarantees that you can recover all committed...
Subscribe to:
Posts (Atom)