Still it works for single OU responsibility when org security profile is not set. MO: Operating Unit is Original operating unit profile. Assign MO: Operating Unit(Mandatory for only Single Org or if MO: Security Profile is not defined).Also the bind variable for each test are of course the same. Assign MO: Default Operating Unit (Optional) The statement runs fast in TOAD (but not in our program) We run the statement in sqlplus.exe, where it is slow (same behaviour as in our program) Adaptive Features are off, so every session should use the same explain plan.Run the Security List Maintenance Program. Define Global Security Profile (HR Responsibility->Security->Profile).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |