{"id":5818,"date":"2013-10-25T12:27:04","date_gmt":"2013-10-25T12:27:04","guid":{"rendered":"https:\/\/gja.rfl.mybluehost.me\/website_fd74af1b\/total-number-of-documentscontent-in-your-webcenter-contentucm\/"},"modified":"2026-02-28T16:52:42","modified_gmt":"2026-02-28T16:52:42","slug":"total-number-of-documentscontent-in-your-webcenter-contentucm","status":"publish","type":"post","link":"https:\/\/onwardpath.com\/intelligence\/total-number-of-documentscontent-in-your-webcenter-contentucm\/","title":{"rendered":"Total number of documents\/content in your WebCenter Content\/UCM"},"content":{"rendered":"

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.<\/p>\n

Including revisions:<\/strong><\/p>\n

SELECT COUNT(*) FROM DOCMETA;\n<\/pre>\n
Only documents:<\/strong><\/p>\n
SELECT COUNT(*) FROM REVISIONS WHERE DREVRANK = 0;\n<\/pre>\n
–DREVRANK=0 indicates latest revision<\/p>\n
Both DOCMETA and REVISIONS are tables in the OCS database.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":10,"featured_media":4159,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[37,19],"tags":[61,62,55,63],"class_list":["post-5818","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-blog","category-webcenter","tag-docmeta","tag-revisions","tag-ucm","tag-webcenter-content"],"jetpack_featured_media_url":"https:\/\/onwardpath.com\/intelligence\/wp-content\/uploads\/2020\/09\/37-documents-contents.jpg","_links":{"self":[{"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/posts\/5818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/comments?post=5818"}],"version-history":[{"count":1,"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/posts\/5818\/revisions"}],"predecessor-version":[{"id":6653,"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/posts\/5818\/revisions\/6653"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/media\/4159"}],"wp:attachment":[{"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/media?parent=5818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/categories?post=5818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onwardpath.com\/intelligence\/wp-json\/wp\/v2\/tags?post=5818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}