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
