Very much could be because of the VPD. You can turn on SQL logging to
see the resultant SQL statement.
Dan
-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailto
wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Brian Steemson
Sent: Monday, February 04, 2008 4:58 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Direct SQL Updates (DSU's) Slow with VPD
Has anyone had problems with direct sql updates run through an
automation agent?
We have examples which run fine in SQL developer but when the same SQL
is run through automation it runs very slowly, these seems to be related
to VPD security?
Brian Steemson
CSC/GTS (Wollongong)
ph. 0405 537 675
Please consider the environment before printing this e-mail.
CSC Australia Pty Limited; Registered Office: 5B/26 Talavera Road,
Macquarie Park NSW 2113 Australia; Incorporated in Australia. ACN: 008
476
944
This is a private message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. Note: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose.
You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution of issues and topics related to Oracle Transportation
Management. If you do not want to receive future mail from the list,
send email to majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe
otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!
You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!