GET_DBSIZE_INFO procedure can be used to calculate database size.It takes 4 parameters in total.3 of them are output parameters and one is input parameter:
snapshot-timestamp:This indicates the time when the database size was actually calculated.This is an output parameter.
dbsize:This is the size of the database in bytes.This is an output parameter.
dbcapacity:This indicates the capacity of the database in bytes.This is an output parameter.
refresh-window:This is an input parameter.It indicates the number of minutes after which the database calculation values are refreshed.
Examples::
1)CALL GET_DBSIZE_INFO(?, ?, ?, -1) -1 which defaults to 30 minutes indicates that the cached values will be refreshed if 30 minute window is reached.
2)CALL GET_DBSIZE_INFO(?, ?, ?, 0) This indicates the cached values are refreshed immediately
3)CALL GET_DBSIZE_INFO(?, ?, ?, 100) indicates that the refresh happens every 100 minutes.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment