| 本月文章推荐 |
在Oracle中获取磁盘空间的使用情况，吐血推荐发表日期：2008-2-9
|
|
Select Distinct SysDate, s.user# As UserID, u.name As UserName, s.ts# As TableSpaceID, d.tablespace_name As TableSpaceName, s.FILE# As DataFileID, d.file_name As DataFileName, d.bytes As Bytes, d.maxbytes As MaxBytes, d.user_bytes As UserBytes, d.autoextensible As AutoExtensible, d.increment_by As InCrementBy, d.status As Status From sys.seg$ s, sys.user$ u, dba_data_files d Where s.user# = u.user# And s.file# = d.file_id; |
| 上一篇：在Oracle中查看各个表、表空间占用空间的大小
人气:2179 下一篇：Oracle中Decode()函数使用技巧 人气:863 |
| 浏览全部Oracle教程的内容
Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐 |
