aster table usage


aster table usage


I'm looking for a way to find information about a set of Aster tables- specifically who(userid) queries them.

What would be  the best way to get this info?


Re: aster table usage

You can have a look at the same using AMC or if you wanna check it with a sql Query you can us the NC_tables.

The data dictionary view nc_all_statements contains information about recently executed statements in Aster Database. By default, the table retains three days worth of statements, but your representative can change the retention policy for you.

you can frame a query where you wanna see tablename like in <statement> and pull out the sessionid and then can relate the sessionids and Userids.

hopefully this helps.

Re: aster table usage

Thank you!