How much database space is my project or repository using?

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

We would like to clean up our Harvest database and possibly archive some projects to reclaim space.  Is there a query that will show how much space in the Harvest database a particular project or repository is using?

Environment

Release : 13.0.3

Component : CA Harvest Software Change Manager

Resolution

Attached are 2 txt files containing SQL queries for this.  One of the files has a SQL Server version of the queries and the other has the Oracle version of the queries.