Statistics

[former_member572313]

Hi Team,

I have a list of customized tables and views created under a particular schema. I would like to know the below information at the minimum for a usage  statistics.

- created at

- created by

- changed at

- changed by

I tried all the SYS schema tables, but I couldn't able to find any information. Appreciate any input on this!

Thanks for your help in Advance!

BR,

Sathish

[lbreddemann · Accepted solution]

CREATE and MODIFY timestamps can be found in M_CS_TABLES.

There is no automatic record of the database or application user who performed the actions though.

You can however setup auditing for this and store these information in the audit log.

- Lars

[former_member572313 · Accepted solution]

Thanks Lars, enabling the auditing log will help us for the future usecase. We would like to view the created/changed information for the existing created tables/views under the schema. Is there any other alternatives or suggestions?

[lbreddemann · Accepted solution]

Nope. That kind of data is not captured w/o auditing.