aster table usage

Aster

aster table usage

Hello,

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?

2 REPLIES

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 asterdata.com/support 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!