empty pages

For determinate current patch version you should use following:
a) select * from v$version; (Oracle9i Database Reference Release 2 (9.2) Part Number A96536-02)
b) select * from dba_registry; (Oracle9i Database Reference Release 2 (9.2) Part Number A96536-02)
c) readme.html from patches (can be extract from patch bundle or downloaded from metalink)

(далее…)

As we know, we can use dbms_lock package to manage our application locks. For example we can create «lock» for synchronize logic in application or you can «lock» your external resources (file handler, network sockets etc).

(далее…)