Today one of my guys called me that log seq is not in sync with main db server.
When I checked [...]

[Read more →]

Today I faced following problem while starting the database.
SQL> connect /  as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance [...]

[Read more →]

Today I had a situation at my client’s place which I need to tackle as soon as possible and I [...]

[Read more →]

Yesterday suddenly I received a call from my guys that one of the database server at my client’s place  has [...]

[Read more →]

Recently after I configured database on testing machine and configure the forms to run on middle tier on testing machine [...]

[Read more →]

Recently while doing R&D, I came across the ADR Command Interpreter (ADRCI).
Introduced in Oracle Database Release 11g, it is a [...]

[Read more →]

Yesterday I was doing some r&d and tried to find trace file for my session.
After lot of trouble I was [...]

[Read more →]

As per my experience when working with PL/SQL code, DBMS_OUTPUT is one of the most frequently used package to display [...]

[Read more →]

Check out following:
SQL> select * from test;
COL1
———-
[...]

[Read more →]

When working with virtual columns recently I came across the following error:
ORA-30553: The function is not deterministic
Cause: The function on [...]

[Read more →]