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.
SELECT COUNT(*) FROM DOCMETA;
SELECT COUNT(*) FROM REVISIONS WHERE DREVRANK = 0;
–DREVRANK=0 indicates latest revision
Both DOCMETA and REVISIONS are tables in the OCS database.