Database Administration (MOSC)

MOSC Banner

How to read the LSQLBIND column from SYS.fga_log$

edited Dec 8, 2015 10:04AM in Database Administration (MOSC) 1 commentAnswered

Hello

We have a need to turn on the audit on specific tables/views at the database level. I do have an export from our DBA - select * from SYS.fga_log$

The data is pretty much exactly what I am looking for. However I would like you to help me read the data from LSQLBIND column

All my searches done from the application has been recorded - Which is good, as this is what I need.

Example:

#1(0):  #2(7):1000091

#1(2):81 #2(6):148145 #3(5):30164 #4(6):165945

What does the Hash tag numbers mean?

What does the numbers in the parenthesis mean?

Please help me to read the data from this column

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