DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Performance with ORACLE policy

Hybrid View

  1. 10-05-2005, 09:21 AM #1
    aghosha
    aghosha is offline Junior Member
    Join Date
    Mar 2001
    Posts
    15

    Performance with ORACLE policy

    Can somebody give me some hint about the performance issue on oracle policy. After implementing on some table the execution time
    of the processes using those tables had gone up 5 times.

    Any suggestion please?

    Thanks
    Reply With Quote Reply With Quote
  2. 10-05-2005, 09:48 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    That is expected behaviour. Make sure your policy functions arent too complex, bear in mind they are executed twice per SQL execution.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width