Total number of documents/content in your WebCenter Content/UCM

Often business would like to know the total number of documents in Oracle WebCenter Content (UCM). The following SQL queries against the OCS database can be used to determine this.

Including revisions:

SELECT COUNT(*) FROM DOCMETA;

Only documents:

SELECT COUNT(*) FROM REVISIONS WHERE DREVRANK = 0;

–DREVRANK=0 indicates latest revision

Both DOCMETA and REVISIONS are tables in the OCS database.