Oracle Online Demos and Tutorials

I am sure most of you are already familiar with these resources but sometime we all  forget where to look for quick help when is really needed. I find these demos and tutorials very valuable .You can quickly find out what needs to be done to successfully implement particular feature without spending too much time … Read more

Patch utility interface

This is also undocumented feature.As name suggest this utility is used to install patches or to be more precise online patches without shooting down instance ( as you know Oracle  now offers online patching ). This patch utility can be invoked by running oradebug command: oradebug patch Here is list of all available options which … Read more

DBMS_DUMA_INTERNAL

Accidentally found this  package  in Oracle version 11.2.0.1 .No documentation available but that’s the case with internals so be careful with this ( use in test database ). cd $ORACLE_HOME/rdbms/admin SQL> @prvtdumi.plb Library created. Package created. No errors. Package body created. No errors. 1* select object_name,object_type from dba_objects where object_name like ‘%DUMA%’ SQL> / OBJECT_NAME                                   … Read more