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....
Subscribe to:
Posts (Atom)