---
title: "查看临时表空间占用情况"
author: "hotjava"
date: "2008-06-18T16:14:44Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-06-18T16:14:44Z"
id: 205204
url: "https://hotjava.iteye.com/blog/205204"
---

select (sum (blocks))\*8/1000 "MB" from v$sort\_usage --当前有多少临时表空间被使用

select * from v$sort\_usage