How to monitor the Volatile table

Database
Enthusiast

How to monitor the Volatile table

Usually,I found some colleagues of mine defined the unreasonable Primary Index of Volatile,but we can't get the DDL of Volatile tables out the session due to The Volatile tables don't save the DDL in the dictionary tables.Are there any other way to get the information of the Volatile tables?

When I monitored the SQL explain,I just can get the information that the Primary Index is unreasonable,but I don't know the PI of the Volatile Tables.

How can I deal with it?
Thanks.
3 REPLIES
Enthusiast

Re: How to monitor the Volatile table

Try doing a:
Show query;

instead of explain query.

This normally gives an explain of the query and DDL of all tables/ views involved.
I have not tried it with a volatile table yet, but I see no reason why it will not work.

I will try it next week; let me know whether or not it works if you get there first!
Enthusiast

Re: How to monitor the Volatile table

All the queries those are executed in the database are stored in DBC.DBQLogTbl.
You can query the above table to get the details.
Enthusiast

Re: How to monitor the Volatile table

Yes,thanks.I forgot that we can get the table information from DBC.DBQLogTbl.

Hi.Supreme Being,we can get the DDL clause from the DBC.DBQLogTbl if it's a Volatile table.