Virtual on Virtual – VPD on virtual column

Quick test to prove that  Virtual Private Database ( VPD ) works on virtual column. Here is demo.First create test table and load it ( so lazy that I found this on google too ) /** Create table and insert some rows **/ DROP TABLE employees; CREATE TABLE employees (   id          NUMBER,   first_name  VARCHAR2(10), … Read more

Script to list modified parameters

All started with dba-willage post when someone asked how to list static and dynamic parameter.. Answer was to select  v$parameter table.I made a comment that also oradebug ( love it ) can be used to list dynamically modified parameter ( one of the previous post )  and got the answer that oradebug is useless when … Read more

Run away from GUI DBA.. Script to report waiting sessions for RAC

Found this one in my old DBA folder.. It’s time to use more sqlplus command line than Toad and OEM ( GUI DBA )..   set serverout on size 999999      declare      begin      dbms_output.put_line(‘ ‘);      dbms_output.put_line(‘************* Start report for WAITING sessions with current SQL ***************’);      for x in (select vs.inst_id, vs.sid … Read more

Poor man Audit Vault

Everyone knows how to enable database auditing .That’s for sure.But to make auditors happy is another story.One of the requirements is that all these data  from the source should be  stored somewhere else.. but not on source .. If you have plenty of money you can get  Oracle audit wault.But if you don’t   than you make your … Read more

Apex in 11g database.

  My pain developer http://www.oraclenerd.com/  keep buging me for some time to install APEX…   We had it installed and it worked fine and sudenly APEX images did not work… In the past I have installed APEX  using Oracle Application server and configuring dads.conf file etc.. Well with 11g database installing APEX is much easier.In Oracle … Read more