Category Archive: Oracle Database

How to solve ORA-04021: timeout occurred while waiting to lock object
  • 11
    Mar

How to solve ORA-04021: timeout occurred while waiting to lock object

Compile an object can give the following error Quire the process to find the session that still running select a.object, a.type, b.sid,b.serial#,s.inst_id, b.username, b.osuser, b.program, s.status, s.sql_exec_start from v$access  a, v$session b, gv$session s where a.sid    = b.sid and a.owner ...

Read More
Ora-19025
  • 17
    Lug

Ora-19025

When you work with xml file you should be solve the scenery that have an node with its properly sub node. In our case the following nodes () ; () . It is quite delicate find exactly approach that gives...

Read More
Oracle Database 18c: My preferred new features for DBAs
  • 18
    Apr

Oracle Database 18c: My preferred new features for DBAs

Oracle Databse 18c comes with some cool new features for DBAs. In this article I'll list my preferred ones. Just one note: I think the name "Autonomous Database" is quite misleading, as it means that some of the new features...

Read More
Create Sequence-Oracle Database 12c
  • 1
    Mar

Create Sequence-Oracle Database 12c

Database version : from Oracle Database 12cR1 Create sequence with session or global option When a sequence number is generated, the sequence is incremented, independent of the transaction committing or rolling back. SESSION option makes opportunity to create sequence that...

Read More