The size of Prepared Statement object

Database
Enthusiast

The size of Prepared Statement object

Hello,

I need in a little bit specific information - I need to know how much memory is consumed by statements prepared by Teradata database (in case of using Prepared Statements).
I'm using application server's cache, and in that cache each prepared statement object consumes some amount of memory and the actual amount is variable, based on the database vendor in use (as well as the number and size of parameter data).
So, how to determine actual amount of memory needed for statement prepared by Teradata database?

Thanks,
Sergey.
Tags (2)
2 REPLIES
Teradata Employee

Re: The size of Prepared Statement object

Are you asking about a PreparedStatement object created by the Teradata JDBC Driver?
Enthusiast

Re: The size of Prepared Statement object

I think, yes (cause app server returns cached PreparedStatement objects).

I need it to measure how much memory will be consumed by caches of different capacities.