---
title: "查询库中全表扫描的表"
author: "hotjava"
date: "2008-05-15T15:14:11Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-05-15T15:14:11Z"
id: 193300
url: "https://hotjava.iteye.com/blog/193300"
---

Select sid,  
       serial#,  
       opname,  
       target,  
       to\_char(start\_time, 'HH24:MI:SS'),  
       (sofar / totalwork) * 100  
  from v$session\_longops;

 

目前还查不到是哪个SQL进行的全表查询。