Examples

Examples

Oracle

SQL Tuning (optimizer errors)

* select with outliers

* People Soft query

* People Soft query simplified

DBMS Platform	Create Schema	SQL Load Files	SQL Profile Session Files	SQL Tuning Job Files
Oracle	PeopleSoftData.zip	PeopleSoftDemo.osl	PeopleSoftDemo.oar	PeopleSoftDemo.tun
		PeopleSoftDemohints.osl

Load Editor & Profiler

* Parsing : Library Cache Latch

* Nest Loops : cache buffers chains latch

* Commits : log file sync

Cross Platform

DBMS Platform	Create Schema	SQL Load Files	SQL Profile Session Files	SQL Tuning Job Files
Oracle	gimdata_oracle.zip	Oracle Demo.osl	Oracle Demo.oar	Oracle Demo.tun
		Oracle Demo hints.osl
SQL Server	gimdata_mssql.zip	Sql Server Demo.osl	Sql Server Demo.oar	Sql Server Demo.tun
		Sql Server Demo hints.osl
Sybase	gimdata_sybase.zip	Sybase Demo.osl	Sybase Demo.oar	Sybase Demo.tun
		Sybase Demo hints.osl
DB2	gimdata_db2.zip	DB2 Demo.osl	DB2 Demo.oar	DB2 Demo.tun
		DB2 Demo hints.osl