{"id":12290,"date":"2024-03-14T15:32:19","date_gmt":"2024-03-14T15:32:19","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/"},"modified":"2025-08-04T23:44:18","modified_gmt":"2025-08-04T23:44:18","slug":"how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/","title":{"rendered":"Check Oracle Tablespace Usage with SQL"},"content":{"rendered":"<p>You can use the following SQL query to view the usage of Oracle user tablespaces:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> tablespace_name,\r\n       <span class=\"hljs-built_in\">sum<\/span>(bytes) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> \"Total Size (MB)\",\r\n       <span class=\"hljs-built_in\">sum<\/span>(bytes <span class=\"hljs-operator\">-<\/span> blocks <span class=\"hljs-operator\">*<\/span> block_size) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> \"Used Size (MB)\",\r\n       <span class=\"hljs-built_in\">sum<\/span>(blocks <span class=\"hljs-operator\">*<\/span> block_size) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> \"Free Size (MB)\",\r\n       round((<span class=\"hljs-number\">1<\/span> <span class=\"hljs-operator\">-<\/span> <span class=\"hljs-built_in\">sum<\/span>(bytes <span class=\"hljs-operator\">-<\/span> blocks <span class=\"hljs-operator\">*<\/span> block_size) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-built_in\">sum<\/span>(bytes)) <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-number\">100<\/span>, <span class=\"hljs-number\">2<\/span>) \"Used Percentage\"\r\n<span class=\"hljs-keyword\">FROM<\/span> dba_data_files\r\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> tablespace_name;\r\n<\/code><\/pre>\n<p>This query will return the name, total size, used size, available size, and usage percentage of the user table space.<\/p>\n<p>Please note that you need to have the correct permissions to access the DBA_DATA_FILES view. If you do not have access to the DBA_DATA_FILES view, you can try using the USER_TABLESPACES view to query the usage of user tablespaces.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> tablespace_name,\r\n       round(<span class=\"hljs-built_in\">sum<\/span>(bytes) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span>) \"Total Size (MB)\",\r\n       round(<span class=\"hljs-built_in\">sum<\/span>(bytes <span class=\"hljs-operator\">-<\/span> blocks <span class=\"hljs-operator\">*<\/span> block_size) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span>) \"Used Size (MB)\",\r\n       round(<span class=\"hljs-built_in\">sum<\/span>(blocks <span class=\"hljs-operator\">*<\/span> block_size) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span>) \"Free Size (MB)\",\r\n       round((<span class=\"hljs-number\">1<\/span> <span class=\"hljs-operator\">-<\/span> <span class=\"hljs-built_in\">sum<\/span>(bytes <span class=\"hljs-operator\">-<\/span> blocks <span class=\"hljs-operator\">*<\/span> block_size) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-built_in\">sum<\/span>(bytes)) <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-number\">100<\/span>, <span class=\"hljs-number\">2<\/span>) \"Used Percentage\"\r\n<span class=\"hljs-keyword\">FROM<\/span> user_segments\r\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> tablespace_name;\r\n<\/code><\/pre>\n<p>This query will return the name, total size, used size, available size, and usage percentage of the user tablespace.<\/p>\n<p>Please note that the above query statement is only applicable for checking the usage of the user tablespace. If you want to check the usage of other tablespaces (such as system tablespace or temporary tablespace), you will need to modify the view name in the query accordingly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can use the following SQL query to view the usage of Oracle user tablespaces: SELECT tablespace_name, sum(bytes) \/ 1024 \/ 1024 &#8220;Total Size (MB)&#8221;, sum(bytes &#8211; blocks * block_size) \/ 1024 \/ 1024 &#8220;Used Size (MB)&#8221;, sum(blocks * block_size) \/ 1024 \/ 1024 &#8220;Free Size (MB)&#8221;, round((1 &#8211; sum(bytes &#8211; blocks * block_size) \/ [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[390,282,1079,1034,10663],"class_list":["post-12290","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-administration","tag-oracle","tag-oracle-dba","tag-sql-query","tag-tablespace-usage"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Check Oracle Tablespace Usage with SQL - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to check Oracle tablespace usage with a simple SQL query. Get insights into used space, free space, and usage percentages.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Check Oracle Tablespace Usage with SQL\" \/>\n<meta property=\"og:description\" content=\"Learn how to check Oracle tablespace usage with a simple SQL query. Get insights into used space, free space, and usage percentages.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T15:32:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T23:44:18+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"Check Oracle Tablespace Usage with SQL\",\"datePublished\":\"2024-03-14T15:32:19+00:00\",\"dateModified\":\"2025-08-04T23:44:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/\"},\"wordCount\":151,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database administration\",\"Oracle\",\"Oracle DBA\",\"SQL query\",\"tablespace usage\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/\",\"name\":\"Check Oracle Tablespace Usage with SQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T15:32:19+00:00\",\"dateModified\":\"2025-08-04T23:44:18+00:00\",\"description\":\"Learn how to check Oracle tablespace usage with a simple SQL query. Get insights into used space, free space, and usage percentages.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Check Oracle Tablespace Usage with SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Check Oracle Tablespace Usage with SQL - Blog - Silicon Cloud","description":"Learn how to check Oracle tablespace usage with a simple SQL query. Get insights into used space, free space, and usage percentages.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Check Oracle Tablespace Usage with SQL","og_description":"Learn how to check Oracle tablespace usage with a simple SQL query. Get insights into used space, free space, and usage percentages.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T15:32:19+00:00","article_modified_time":"2025-08-04T23:44:18+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"Check Oracle Tablespace Usage with SQL","datePublished":"2024-03-14T15:32:19+00:00","dateModified":"2025-08-04T23:44:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/"},"wordCount":151,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database administration","Oracle","Oracle DBA","SQL query","tablespace usage"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/","name":"Check Oracle Tablespace Usage with SQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T15:32:19+00:00","dateModified":"2025-08-04T23:44:18+00:00","description":"Learn how to check Oracle tablespace usage with a simple SQL query. Get insights into used space, free space, and usage percentages.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-check-the-space-usage-of-a-users-table-space-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Check Oracle Tablespace Usage with SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12290"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12290\/revisions"}],"predecessor-version":[{"id":156080,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12290\/revisions\/156080"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}