Skip to main content
Question

Raw Data Size x License Size

  • July 7, 2022
  • 1 reply
  • 3 views
joliveira
Forum|alt.badge.img

Hi all,

I will perform a cleaning in my database, where old data will be deleted in
several tables and different schemas, I searched the documentation and I didn't find a way to calculate the volume (GB) that this action will free up space in the database.

I emphasize that I do not want the volumetry view by table or schema, but at the line level.

Thanks in advance for the support.

C/c.: @Jim_Knicely

    1 reply

    mosheg
    Forum|alt.badge.img+2
    • mosheg
    • Participating Frequently
    • July 7, 2022

    The AUDIT function returns the raw data size (in bytes) of a database, schema, or table as it is counted in an audit of the database size.
    Unless you specify zero error tolerance and 100 percent confidence level, AUDIT returns only approximate results that can vary over multiple iterations.
    For example: SELECT AUDIT('');

    If you want to estimate the raw data size of a given query or a table to clean data,
    The following will measure the size of 10% raw data export (with no need to create a file):

    vsql -F ',' -P null="''" -AXtnq -c "select * from YourTableName_or_Query TABLESAMPLE(10) ;" | pv | dd of=/dev/null

    In the above example we use pv to monitor the size and progress of data through a pipe
    To install pv on RHEL/CentOS consider this..
    sudo yum makecache
    sudo yum -y install pv

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement