Getting below error while installing oracle 11g/12c database using DBCA. UnsatisfiedLinkError exception loading native library: njni11java.lang.UnsatisfiedLinkError: /home/u01/app/oracle/product/11.2.0/db_1/lib/libnjni11.so: libclntsh.so.11.1: cannot open…
Oracle has inbuilt features using which you can convert scn to timestamp and timestamp to scn. SCN_TO_TIMESTAMP takes as an…
A materialized view is a table segment or database object that contains the results of a query. A materialized view…
Sometimes it is required to flush the single sql plan from the shared pool and it a good idea rather…
Being a DBA, you often asked to check the status of RMAN backup job details. You can monitor progress and…
Being a DBA, there are many occasions where you need to move all database objects from one tablespace to another…
Recently i came across a situation where i was not able to see the SQL text for my sql_id. Developer…
SQL INSERT INTO statement is used to insert new records into a table. How insert statement in Oracle executes internally…
UPDATE command in sql is used to modify existing records in a table. How SQL UPDATE statement works inside the Oracle…
In one of the sites, I came across a performance issue where data loading task was taking more than usual.…