Thread: Purging and Archiving
View Single Post
  #6 (permalink)  
Old November 28th, 2007, 15:32
chad chad is offline
Junior Member
  
Join Date: Feb 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
chad is on a distinguished road
Re: Purging and Archiving
We analyze the db every weekend. We do have an open SR with Oracle though on report performance that seems to keep pointing back to the VPD. Our reports run in 10 seconds when logged in as dba.admin but take around 7-10 minutes when logged in as a normal user. Oracle has not found a resolution at this time. I have been getting some relief when using vpd.add_active_table in the reports.

Have you added indexes to the db or done any purging?

Thanks.
Reply With Quote