Database Security Products (MOSC)

MOSC Banner

OLS sa_session.set_access_profile taking way too long

edited Jan 2, 2013 5:52AM in Database Security Products (MOSC) 4 commentsAnswered ✓
We are using Oracle 10.2.0.4.  We have implementing a connection pool, and as each application user is assigned a connection, the application calls a very short stored procedure which executes "sa_session.set_access_profile (policy_name, user_name)."  This ONE LINE is taking 4.5 seconds to execute on our production database.  This does not seem reasonable at all.  However, we have recently had to change a number of OLS groups into OLS compartments by creating the compartments of the same names, giving each user of the group the ability to see the compartment, relabeling all the data, dropping the group from the users, and finally dropping the groups themselves.  Could the LBACSYS tables be badly fragmented?  If so, how do we fix them?  We do run dbms_stats.gather_dictionary_stats on a daily basis, so the stats on the LBACSYS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center