DX Application Performance Management

 View Only

Estimate the size of the table space needed by the iscope_orcl user

  • 1.  Estimate the size of the table space needed by the iscope_orcl user

    Posted Jul 01, 2014 04:30 PM

    Using release 9.5.3 of the APM Oracle Database extension ( AKA power pack).

    Need to estimate the size of the table space needed by the iscope_orcl user.

     

    The client DBA refuses to execute the SQL script provided with the product until we provide an estimate of disk space needed for the table space.

    It appears that the script is

    1. Creating 12 tables using select statement against oracle system "V$" tables.

    2. Creating a stored procedure to truncate the tables and re-issue the select statement (once each polling interval?).

    Assuming this is correct, the estimate will depend on the result of the select queries from step 1.

     

    Does anyone here know of a reliable sizing estimate for the iscope_orcl user default table space?