FROM all_objects
--1G=1024*11048576Bytes=11313741824Bytes
FROM dba_data_files
FROM dba_free_space
AND a.tablespace_name = c.tablespace_name;
(next_extent / 1024) nextextent,
FROM dba_free_space
free "表空间剩余大小",
SELECT a.tablespace_name "表空间名",
--8、查看数据库的版本　
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
WHERE a.tablespace_name = b.tablespace_name
(b.bytes * 100) / a.bytes "% USED ",
r.status,
SELECT segment_name,
SELECT a.tablespace_name,
FROM (SELECT tablespace_name, SUM(bytes) free
SELECT owner, object_type, status, COUNT(*) count#
--1M=11048576Bytes
--2、查看表空间物理文件的名称及大小
(SELECT tablespace_name, SUM(bytes) total
GROUP BY owner, object_type, status;

round(bytes / (1024 * 1024), 0) total_space
total / (1024 * 1024 * 1024) "表空间大小(G)",
total "表空间大小",
c.bytes free,
GROUP BY t.tablespace_name;
FROM product_component_version
WHERE r.segment_id = v.usn(+)
SELECT created, log_mode, log_mode FROM v$database;
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name
--5、查看日志文件
WHERE substr(product, 1, 6) = 'Oracle';

复制代码 代码如下:

SELECT NAME FROM v$controlfile;
max_extents,
--7、查看数据库库对象
SELECT version
free / (1024 * 1024 * 1024) "表空间剩余大小(G)",
SELECT tablespace_name,
--1、查看表空间的名称及大小
GROUP BY tablespace_name;
SQL2:
(c.bytes * 100) / a.bytes "% FREE "
GROUP BY tablespace_name) a,
b.bytes used,
--4、查看控制文件
a.bytes total,
--9、查看数据库的创建日期和归档方式
--1M=1024KB
--1G=1024MB

复制代码 代码如下:

--6、查看表空间的使用情况
--3、查看回滚段名称及大小
SELECT SUM(bytes) / (1024 * 1024) AS free_space, tablespace_name
file_id,
(total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)",
--1K=1024Bytes
WHERE t.tablespace_name = d.tablespace_name
(total - free) "表空间使用大小",
file_name,

FROM dba_tablespaces t, dba_data_files d
FROM dba_data_files
round((total - free) / total, 4) * 100 "使用率 %"
v.curext curextent
FROM sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free c

tablespace_name,
ORDER BY tablespace_name;
(initial_extent / 1024) initialextent,
SELECT MEMBER FROM v$logfile;
FROM dba_rollback_segs r, v$rollstat v
ORDER BY segment_name;