---
title: "热表查询"
author: "hotjava"
date: "2008-07-03T10:56:57Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-07-03T10:56:57Z"
id: 210945
url: "https://hotjava.iteye.com/blog/210945"
---

SELECT Rownum AS Rank,  
       Seg\_Lio.*  
  FROM (SELECT St.Owner,  
               St.Obj#,  
               St.Object\_Type,  
               St.Object\_Name,  
               St.VALUE,  
               'LIO' AS Unit  
          FROM V$segment\_Statistics St  
         WHERE St.Statistic\_Name = 'logical reads'  
         ORDER BY St.VALUE DESC) Seg\_Lio  
WHERE Rownum &lt;= 10  
UNION ALL  
SELECT Rownum AS Rank,  
       Seq\_Pio\_r.*  
  FROM (SELECT St.Owner,  
               St.Obj#,  
               St.Object\_Type,  
               St.Object\_Name,  
               St.VALUE,  
               'PIO Reads' AS Unit  
          FROM V$segment\_Statistics St  
         WHERE St.Statistic\_Name = 'physical reads'  
         ORDER BY St.VALUE DESC) Seq\_Pio\_r  
WHERE Rownum &lt;= 10  
UNION ALL  
SELECT Rownum AS Rank,  
       Seq\_Pio\_w.*  
  FROM (SELECT St.Owner,  
               St.Obj#,  
               St.Object\_Type,  
               St.Object\_Name,  
               St.VALUE,  
               'PIO Writes' AS Unit  
          FROM V$segment\_Statistics St  
         WHERE St.Statistic\_Name = 'physical writes'  
         ORDER BY St.VALUE DESC) Seq\_Pio\_w  
WHERE Rownum &lt;= 10;