Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC)

MOSC Banner

Need help calculating the individual NDB table index/data memory size.

edited May 13, 2014 12:00PM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 4 commentsAnswered

I have been looking online for a solid method for determining the individual table sizes in an NDB and I have not found a way to get this data for each table in the NDB.  I will list the methods I have already used to gather the data and what was determined to be the reason the method was not valid.

The first was to obtain the Avg_row_length using the SHOW TABLE STATUS <table_name> and use that value to multiply by the Rows to get a value in bytes.  The problem with this calculation is that it does not provide the index memory nor the data memory that is utilized in the NDB for this table.  This data was captured by using the following query that is being ran on the NDB SQL API node.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center