Oracle Lab - I/O statistics

Welcome

Home

Forums

OCTC

Documents

News

Tips

Articles

Source Codes

Themes

SUPINFO Labs

IBM Lab

Sun Lab

About Us

Contacts

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

Comments

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.

	show_item show_previous_next show_item_comments
SUSE Linux Enterprise Server for Oracle Servers Administration 14-JUN-2008 06:29 PM, Fabien Loudet	show_item show_previous_next show_item_comments
Oracle Application Server Portal 10g Installation Portal 05-NOV-2007 11:50 PM, Maxime Gontcharov	show_item show_previous_next show_item_comments

	show_item show_previous_next show_item_comments
	show_item show_previous_next show_item_comments
	show_item show_previous_next show_item_comments
Oracle Content Services 10g - Semantic API General 04-NOV-2007 10:14 PM, Frederic Humbert-Droz	show_item show_previous_next show_item_comments
1Z0-007 On Line Certifications 23-SEP-2007 10:46 PM, Jerome Alef	show_item show_previous_next show_item_comments

Tips

Windows PowerShell : Connecting to an Oracle Database Administration 16-SEP-2008 04:50 PM, Fabien Loudet	show_item show_previous_next show_item_comments
Kill Oracle session Administration 10-SEP-2008 07:27 PM, Julien Ragueneau	show_item show_previous_next show_item_comments
Installing Oracle on a Unix server without any GUI Administration 10-SEP-2008 07:05 PM, Jérémie Hodnik	show_item show_previous_next show_item_comments
Distributed requests SQL 10-SEP-2008 10:47 AM, Thibaut Maxant	show_item show_previous_next show_item_comments
Use of "readonly" on a table SQL 10-SEP-2008 10:36 AM, Rémi Olivier	show_item show_previous_next show_item_comments

More Tips

Source Codes

Add Multi-language support Portal 25-NOV-2004 10:30 AM, Pierre-Henry Tupin	show_item show_previous_next show_item_comments
Instant Messenger Communication 24-NOV-2004 10:31 AM, Arnaud Bontemps	show_item show_previous_next show_item_comments
Who is online Portal 24-NOV-2004 10:26 AM, Arnaud Bontemps	show_item show_previous_next show_item_comments
Change the Portal CSS Portal 15-JUN-2004 04:15 PM, Arnaud Bontemps, Yoan Sultan	show_item show_previous_next show_item_comments

More Source Codes

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.	show_item show_previous_next show_item_comments
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.	show_item show_previous_next show_item_comments
Oracle's Industry Strategy 01-SEP-2008 12:01 PM, Thibaut Maxant	show_item show_previous_next show_item_comments
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.	show_item show_previous_next show_item_comments
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.	show_item show_previous_next show_item_comments

More News