📄 oracle基本操作-9.htm

📁 微软数据库开发梦工场多媒体教学-oracle篇.rar,是多媒体教学的

💻 HTM

字号:

<body bgcolor="#000000">
<font color="#009900"> 查看数据库的SQL</font> 
<p><font color="#FFFFFF"> </font><font color="#FFFFFF">1、查看表空间的名称及大小</font></p>
<p><font color="#FFFFFF"> select t.tablespace_name, round(sum(bytes/(1024*1024)),0) 
  ts_size<br>
  from dba_tablespaces t, dba_data_files d<br>
  where t.tablespace_name = d.tablespace_name<br>
  group by t.tablespace_name;</font></p>
<p><font color="#FFFFFF">2、查看表空间物理文件的名称及大小</font></p>
<p><font color="#FFFFFF"> select tablespace_name, file_id, file_name,<br>
  round(bytes/(1024*1024),0) total_space<br>
  from dba_data_files<br>
  order by tablespace_name;</font></p>
<p><font color="#FFFFFF">3、查看回滚段名称及大小</font></p>
<p><font color="#FFFFFF"> select segment_name, tablespace_name, r.status, <br>
  (initial_extent/1024) InitialExtent,(next_extent/1024) NextExtent, <br>
  max_extents, v.curext CurExtent<br>
  From dba_rollback_segs r, v$rollstat v<br>
  Where r.segment_id = v.usn(+)<br>
  order by segment_name ;</font></p>
<p><font color="#FFFFFF">4、查看控制文件</font></p>
<p><font color="#FFFFFF"> select name from v$controlfile;</font></p>
<p><font color="#FFFFFF">5、查看日志文件</font></p>
<p><font color="#FFFFFF"> select member from v$logfile;</font></p>
<p><font color="#FFFFFF">6、查看表空间的使用情况</font></p>
<p><font color="#FFFFFF"> select sum(bytes)/(1024*1024) as free_space,tablespace_name 
  <br>
  from dba_free_space<br>
  group by tablespace_name;</font></p>
<p><font color="#FFFFFF"> SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, 
  C.BYTES FREE,<br>
  (B.BYTES*100)/A.BYTES &quot;% USED&quot;,(C.BYTES*100)/A.BYTES &quot;% FREE&quot;<br>
  FROM SYS.SM$TS_AVAIL A,SYS.SM$TS_USED B,SYS.SM$TS_FREE C<br>
  WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME=C.TABLESPACE_NAME; 
  </font></p>
<p><font color="#FFFFFF">7、查看数据库库对象</font></p>
<p><font color="#FFFFFF"> select owner, object_type, status, count(*) count# from 
  all_objects group by owner, object_type, status;</font></p>
<p><font color="#FFFFFF">8、查看数据库的版本　</font></p>
<p><font color="#FFFFFF"> Select version FROM Product_component_version <br>
  Where SUBSTR(PRODUCT,1,6)='Oracle';</font></p>
<p><font color="#FFFFFF">9、查看数据库的创建日期和归档方式</font></p>
<p><font color="#FFFFFF"> Select Created, Log_Mode, Log_Mode From V$Database;<br>
  </font></p>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -