Oracle Lab - Overview of Database I/O

Welcome

Home

Forums

OCTC

Documents

News

Tips

Articles

Source Codes

Themes

SUPINFO Labs

IBM Lab

Sun Lab

About Us

Contacts

Overview of Database I/O

Database I/O spread

Votes: 9

Comments: 0

Visits: 2367

Administration 30-JUN-2004 03:28 PM, Arnaud Bontemps

This script gives an overall view of the database I/O spread.

column A heading name format a60
column B heading "Physical|Reads" format 99,999,990
column C heading "Physical|Writes" format 99,999,990
column D heading "Total" format 99,999,990
SELECT name A,
sum(Phyrds) B,
sum(Phywrts) C,
sum(phyrds) + sum(phywrts) D
FROM v$datafile df, v$filestat fs
WHERE df.file# = fs.file#
GROUP by name;

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