oracle10g系统管理之动态性能视图

<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span style="">动态性能视图用于记录当前例程的活动信息，启动例程时，</span><span lang="EN-US"><span style="font-family: Times New Roman;">ORACLE</span></span><span style="">会自动创建动态性能视图，停止例程时，</span><span lang="EN-US"><span style="font-family: Times New Roman;">ORACLE</span></span><span style="">会自动删除动态性能视图。需要注意的是：数据字典信息是从数据文件中取得，而动态性能视图则是从</span><span lang="EN-US"><span style="font-family: Times New Roman;">SGA</span></span><span style="">和控制文件中取得。通过查询动态性能视图一方面可以获得性能数据，另一方面还可以取得与磁盘和内存结构相关的其他信息。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span style="">多数动态性能视图只能由特权用户和</span><span lang="EN-US"><span style="font-family: Times New Roman;">DBA</span></span><span style="">用户查询。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">V$FIXEDTABLE</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style=""><span style="font-size: small;">动态性能视图用于列出所有可用的动态性能视图和动态性能表。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">SELECT name FROM V$TABLE where name LIKE ‘vs%’;</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">V$_INSTANCE</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style=""><span style="font-size: small;">获得当前例程的详细信息。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">SELECT instance_name,host_name,status FROM V$INSTANCE;</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">V$SGA</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span style="">该动态性能视图用于显示</span><span lang="EN-US"><span style="font-family: Times New Roman;">SGA</span></span><span style="">主要组成部分。</span><span lang="EN-US"><span style="font-family: Times New Roman;">(</span></span><span style="">共享池，数据高速缓存和重做日志缓冲区</span><span lang="EN-US"><span style="font-family: Times New Roman;">)</span></span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">V$SGAINFO</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span style="">获取</span><span lang="EN-US"><span style="font-family: Times New Roman;">SGA</span></span><span style="">的详细信息。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">V$SESSION</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style=""><span style="font-size: small;">该动态性能视图用于显示会话的详细信息。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span lang="EN-US"><span style="font-family: Times New Roman;">SELECT sid</span></span><span style="">，</span><span lang="EN-US"><span style="font-family: Times New Roman;">serial#</span></span><span style="">，</span><span lang="EN-US"><span style="font-family: Times New Roman;">username FROM V$SESSION WHERE username IS NOT NULL</span></span><span style="">；</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span style="">如果用户名是</span><span lang="EN-US"><span style="font-family: Times New Roman;">null</span></span><span style="">，则表示后台进程。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">V$PROCESS</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span style="">用于显示</span><span lang="EN-US"><span style="font-family: Times New Roman;">ORACLE</span></span><span style="">的所有进程信息。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">SELECT a.terminal,a.pid,a.pga_alloc_mem FROM v$ process a,v$session b WHERE a.addr=b.paddr AND b.username=’SCOTT’;</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span lang="EN-US"><span style="font-size: small; font-family: Times New Roman;">V$TABLESPACE</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style=""><span style="font-size: small;">该动态性能视图用于显示表空间信息。</span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: small;"><span lang="EN-US"><span style="font-family: Times New Roman;">SELECT * FROM V$TABLESPACE</span></span><span style="">；</span></span></p>