HomeSearchE-MailPrint
French English Chinese

I/O statistics

This statement gives informations about the user's Input/Output operations.

Votes: 24

Comments: 0

Visits: 2269

Administration 30-JUN-2004 04:14 PM, Reda Benkirane

To obtain this informations, it is enough for you to login as SYSDBA and execute the following statement:

select nvl(ses.USERNAME,'ORACLE PROC') username,
OSUSER os_user,
PROCESS pid,
ses.SID sid,
SERIAL#,
PHYSICAL_READS,
BLOCK_GETS,
CONSISTENT_GETS,
BLOCK_CHANGES,
CONSISTENT_CHANGES
from v$session ses,
v$sess_io sio
where ses.SID = sio.SID
order by PHYSICAL_READS, ses.USERNAME
Next Previous

Comments

Login to leave a comment.

Articles

Oracle Installation on SUSE Linux Enterprise Server

Administration 14-JUN-2008 07:03 PM, Fabien Loudet

We will follow step-by-step the installation of Oracle Database 10g on SUSE Linux Enterprise Server. We choose here to install Oracle Enterprise Edition and create a database.


Articles RSS
Source Codes

Add Multi-language support

Portal 25-NOV-2004 10:30 AM, Pierre-Henry Tupin

Instant Messenger

Communication 24-NOV-2004 10:31 AM, Arnaud Bontemps

Who is online

Portal 24-NOV-2004 10:26 AM, Arnaud Bontemps

Change the Portal CSS

Portal 15-JUN-2004 04:15 PM, Arnaud Bontemps, Yoan Sultan


Source Codes RSS
News

Oracle VM Templates

02-SEP-2008 12:15 PM, Jérémie Hodnik

Further enabling customers to benefit from server consolidation, energy and space cost savings by using enterprise-class server virtualization, Oracle today announced Oracle® VM Templates.

Oracle Unbreakable Linux

02-SEP-2008 12:08 PM, Thibaut Maxant

Oracle's Linux commitment began in 1998 with the first commercial database on Linux.

Oracle's Industry Strategy

01-SEP-2008 12:01 PM, Thibaut Maxant

Oracle is the #1 in Relational Database

20-AUG-2008 07:26 PM, Thibaut Maxant

Gartner 2007 Worldwide RDBMS Market Share Reports 48.6% Share for Oracle.

Oracle Buys Skywire Software

02-AUG-2008 11:18 AM, Zhen Dong

June 23, 2008, Oracle announced that it has reached an agreement with Skywire Software and buys of its business application software.


News RSS