{"id":26567,"date":"2024-03-16T06:54:22","date_gmt":"2024-03-16T06:54:22","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/"},"modified":"2024-03-22T08:53:56","modified_gmt":"2024-03-22T08:53:56","slug":"how-to-view-the-usage-of-temporary-tablespace-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/","title":{"rendered":"How to view the usage of temporary tablespace in Oracle?"},"content":{"rendered":"<p>To check the usage of the Oracle temporary tablespace, you can use the following query statement:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> tablespace_name, bytes_used<span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span><span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span> <span class=\"hljs-keyword\">AS<\/span> used_mb, bytes_free<span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span><span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span> <span class=\"hljs-keyword\">AS<\/span> free_mb, bytes_used<span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span><span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">+<\/span> bytes_free<span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span><span class=\"hljs-operator\">\/<\/span><span class=\"hljs-number\">1024<\/span> <span class=\"hljs-keyword\">AS<\/span> total_mb \r\n<span class=\"hljs-keyword\">FROM<\/span> v$temp_space_header;\r\n<\/code><\/pre>\n<p>This query will retrieve the name of the temporary tablespace, the space used (in MB), the remaining space (in MB), and the total space (sum of used and remaining space, in MB).<\/p>\n<p>Note: This query statement is to be run under a user with administrative rights in the Oracle database in order to execute it successfully.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To check the usage of the Oracle temporary tablespace, you can use the following query statement: SELECT tablespace_name, bytes_used\/1024\/1024 AS used_mb, bytes_free\/1024\/1024 AS free_mb, bytes_used\/1024\/1024 + bytes_free\/1024\/1024 AS total_mb FROM v$temp_space_header; This query will retrieve the name of the temporary tablespace, the space used (in MB), the remaining space (in MB), and the total space [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-26567","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"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>How to view the usage of temporary tablespace in Oracle? - Blog - Silicon Cloud<\/title>\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-to-view-the-usage-of-temporary-tablespace-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to view the usage of temporary tablespace in Oracle?\" \/>\n<meta property=\"og:description\" content=\"To check the usage of the Oracle temporary tablespace, you can use the following query statement: SELECT tablespace_name, bytes_used\/1024\/1024 AS used_mb, bytes_free\/1024\/1024 AS free_mb, bytes_used\/1024\/1024 + bytes_free\/1024\/1024 AS total_mb FROM v$temp_space_header; This query will retrieve the name of the temporary tablespace, the space used (in MB), the remaining space (in MB), and the total space [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-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-16T06:54:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T08:53:56+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\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=\"Liam\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"How to view the usage of temporary tablespace in Oracle?\",\"datePublished\":\"2024-03-16T06:54:22+00:00\",\"dateModified\":\"2024-03-22T08:53:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/\"},\"wordCount\":82,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/\",\"name\":\"How to view the usage of temporary tablespace in Oracle? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T06:54:22+00:00\",\"dateModified\":\"2024-03-22T08:53:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to view the usage of temporary tablespace in Oracle?\"}]},{\"@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\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to view the usage of temporary tablespace in Oracle? - Blog - Silicon Cloud","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-to-view-the-usage-of-temporary-tablespace-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How to view the usage of temporary tablespace in Oracle?","og_description":"To check the usage of the Oracle temporary tablespace, you can use the following query statement: SELECT tablespace_name, bytes_used\/1024\/1024 AS used_mb, bytes_free\/1024\/1024 AS free_mb, bytes_used\/1024\/1024 + bytes_free\/1024\/1024 AS total_mb FROM v$temp_space_header; This query will retrieve the name of the temporary tablespace, the space used (in MB), the remaining space (in MB), and the total space [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T06:54:22+00:00","article_modified_time":"2024-03-22T08:53:56+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"How to view the usage of temporary tablespace in Oracle?","datePublished":"2024-03-16T06:54:22+00:00","dateModified":"2024-03-22T08:53:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/"},"wordCount":82,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/","name":"How to view the usage of temporary tablespace in Oracle? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T06:54:22+00:00","dateModified":"2024-03-22T08:53:56+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-usage-of-temporary-tablespace-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to view the usage of temporary tablespace in Oracle?"}]},{"@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\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26567","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=26567"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26567\/revisions"}],"predecessor-version":[{"id":60739,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26567\/revisions\/60739"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=26567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=26567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=26567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}