orcle linux怎么登陆？全局表空间统计信息怎么查看？表空间内表的统计信息怎么看？数据表的字段怎么查？...

• TBS_STAT表空间统计信息

https://blog.csdn.net/u013991521/article/details/79293706

SELECT a.tablespace_name ,
total / (1024 * 1024 * 1024) total,
free / (1024 * 1024 * 1024) free,
(total - free) / (1024 * 1024 * 1024) used,
round((total - free) / total, 4) * 100 usage_rate
FROM (SELECT tablespace_name, SUM(bytes) free
FROM dba_free_space
GROUP BY tablespace_name) a,
(SELECT tablespace_name, SUM(bytes) total
FROM dba_data_files
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name;

 

 

https://blog.csdn.net/wwlhz/article/details/73296430

• 登录

• su - oracle
  
  sqlplus / as sysdba
  

  　　

 

• 查表的字段

SELECT column_name, data_type
FROM all_tab_cols
WHERE table_name = 'DBA_DATA_FILES' ;

 

• 增加表空间

https://blog.csdn.net/naruto0025/article/details/78622374

 

• 表空间内表统计信息

https://blog.csdn.net/sayyy/article/details/80006939?utm_source=blogxgwz6

SELECT SEGMENT_NAME,
SUM(BYTES) / 1024 / 1024 / 1024,
OWNER,
TABLESPACE_NAME
FROM DBA_SEGMENTS
WHERE TABLESPACE_NAME = 'TBS_GL_RES'
GROUP BY SEGMENT_NAME;

 

 

https://www.cnblogs.com/BobXie85/p/9814686.html

转载于:https://www.cnblogs.com/NigelLay/p/10605228.html