/* ************************************************ */
/*                                                  */
/* Script: Determine if the database data files are */
/*         experienceing I/O contention             */
/*                                                  */
/* name:    @c:\oracle\sql\v$circit.sql             */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select rawtohex(c.circuit),
	d.name,
	s1.name,
	s.sid,
	s.serial#,
	c.status,
	c.queue,
	c.messages,
	c.bytes
from v$circuit c,
     v$dispatcher d,
     v$shared_server s1,
     v$session s
where c.dispatcher = d.paddr(+)  and
      c.server     = s1.paddr(+) and
      c.saddr      = s.addr(+)
order by 1, 2, 3;
from v$database;

commit;

