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