Gaussdb T WSR 报告示例

原创倪哥 2019-12-27

729

Workload Statistics Report

Database Information

DB Name	DB Id	DB Role	Log Mode	Sharding	Version
GAUSS	1728658755	PRIMARY	ARCHIVELOG	NO	GaussDB_100_1.0.0.B019 Release 0b7bb43

Instance Information

Instance Name	Instance Id	Copy Status	Instance Startup
zenith	0	NORMAL	2019-12-25 11:12:17

Host Information

Host Name	Operating System	CPUs	CPU Cores	CPU Sockets	Memory (MB)
		2	2	1	2000

Snap Information

Elapsed Time	DB Time
22.63 (mins)	60.58 (mins)

Snap Id	Snap Time
322	2019-12-26 11:12:18
323	2019-12-26 11:34:56

Database Load
Instance Efficiency
Top 10 Events by Total Wait Time
Host CPU
Host Memory
Instance Snap
Session Statistics
SQL Statistics
Complete List of SQL Text
Segment Statistics
Instance Parameters

Database Load

Attribute	Total	Per Second	Per Transaction	Per Exec
DB Time(s):	3635	2.68	0.06	0.00
DB CPU(s):	2941	2.17	0.05	0.00
Redo size (bytes):	2300683036	1694170.12	35254.65	331.18
Redo write time:	259	0.19	0.00	0.00
Redo writes:	0	0.00	0.00	0.00
Logical read:	49967590	36794.99	765.68	7.19
CR gets:	430	0.32	0.01	0.00
Page changes:	18909521	13924.54	289.76	2.72
Physical read:	2799854	2061.75	42.90	0.40
DBWR disk writes:	557354	410.42	8.54	0.08
DBWR disk write time:	385	0.28	0.01	0.00
User calls:	7866649	5792.82	120.55	1.13
SQL parse time:	0	0.00	0.00	0.00
Parses (SQL):	1149	0.85	0.02	0.00
Hard parses (SQL):	48	0.04	0.00	0.00
Logons:	76	0.06	0.00	0.00
Executes (SQL):	6947016	5115.62	106.45	1.00
Rollbacks:	288	0.21	0.00	0.00
Transactions:	65259	48.06	1.00	0.01
Select executions:	234485	172.67	3.59	0.03
Select execution time:	311	0.23	0.00	0.00
Insert executions:	132483	97.56	2.03	0.02
Insert execution time:	1148	0.85	0.02	0.00
Update executions:	0	0.00	0.00	0.00
Update execution time:	0	0.00	0.00	0.00
Delete executions:	27684	20.39	0.42	0.00
Delete execution time:	26	0.02	0.00	0.00
Fetched counts:	918408	676.29	14.07	0.13
Fetched rows:	3709284	2731.43	56.84	0.53
Processed rows:	9988478	7355.29	153.06	1.44
Sorts:	12	0.01	0.00	0.00
Sort on disk:	1	0.00	0.00	0.00
Temp allocates:	10806	7.96	0.17	0.00

Instance Efficiency

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	94.40	In-memory Sort %:	91.67
Library Hit %:	100.00	Soft Parse %:	95.82
Execute to Parse %:	99.98	Latch Hit %:	99.93

Top 10 Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
CPU		2942		80.92
buffer busy waits	160534	528	3.291	14.53	Concurrency
db file scattered read	132226	424	3.207	11.66	User/IO
db file sequential read	2650861	262	0.099	7.2	User/IO
latch: data buffer pool	26314	222	8.473	6.13	Concurrency
heap extend segment	40796	102	2.516	2.82	Concurrency
enq: TX row lock contention	2015	26	13.325	.74	Application
read by other session	2457	8	3.270	.22	Concurrency
log file sync	233	1	6.261	.04	Commit
heap find map	31	0	2.055	0	Concurrency

Host CPU

CPUs	Cores	Sockets	%User	%System	%WIO	%Idle
2	2	1	24.663	5.278	6.690	63.369

Host Memory

VM_PAGE_IN_BYTES	VM_PAGE_OUT_BYTES
19447808	286019584

Instance Snap

Snap Time	Sessions	Active Sessions	Locks	Transactions	Temp Pool Free Pages	Data Buffer Pins	System Tablespace Left (Bytes)	User Tablespace Left (Bytes)	Txn Pages	Undo Pages
2019-12-26 11:12:28	51	6	9	1	794	2544	955539456	5368635392	2048	51711
2019-12-26 11:12:58	51	6	9	1	794	2544	955539456	5368635392	2048	51711
2019-12-26 11:13:28	51	6	9	1	794	2544	955539456	5368635392	2048	51711
2019-12-26 11:13:58	51	6	9	1	794	2544	955539456	5368635392	2048	51711
2019-12-26 11:14:28	51	6	9	1	794	2544	955539456	5368635392	2048	51711
2019-12-26 11:14:58	62	6	11217	11	794	2549	955539456	5288681472	2048	50244
2019-12-26 11:15:29	62	6	41226	11	794	2549	955539456	5079556096	2048	47578
2019-12-26 11:15:58	62	16	64511	11	794	2554	955473920	4926070784	2048	44689
2019-12-26 11:16:30	62	11	82100	11	794	2555	955473920	4812890112	2048	39701
2019-12-26 11:16:59	62	6	98266	11	794	2555	955473920	4706131968	2048	35967
2019-12-26 11:17:29	62	6	114765	11	794	2555	955473920	4582727680	2048	35595
2019-12-26 11:17:59	55	9	37876	4	794	2555	955473920	4459257856	2048	55235
2019-12-26 11:18:30	53	7	23	2	764	2558	955473920	4444708864	2048	60617
2019-12-26 11:19:00	53	7	23	2	404	2563	955473920	4395556864	2048	60140
2019-12-26 11:19:30	53	7	23	2	0	2563	955473920	4395556864	2048	60140
2019-12-26 11:20:02	53	7	23	2	688	2564	955473920	4297646080	2048	59730
2019-12-26 11:20:30	53	7	12	2	794	2565	955473920	4271693824	2048	59731
2019-12-26 11:21:00	51	6	9	1	794	2566	955408384	4265730048	2048	59731
2019-12-26 11:21:30	51	6	9	1	794	2566	955408384	4265730048	2048	59731
2019-12-26 11:22:00	51	6	9	1	794	2566	955408384	4265730048	2048	59731
2019-12-26 11:22:32	63	15	184	8	794	2566	955408384	4261142528	2048	59725
2019-12-26 11:23:03	63	16	98	5	794	2566	955408384	4254720000	2048	59724
2019-12-26 11:23:33	63	16	251	2	794	2566	955408384	4249280512	2048	59724
2019-12-26 11:24:03	63	14	109	10	794	2566	955408384	4243906560	2048	59726
2019-12-26 11:24:33	63	16	253	11	794	2566	955408384	4238598144	2048	59720
2019-12-26 11:25:03	63	15	233	1	794	2566	955342848	4232175616	2048	59731
2019-12-26 11:25:34	63	16	43	6	789	2566	955277312	4225884160	2048	59727
2019-12-26 11:26:04	63	14	185	6	794	2566	955211776	4219330560	2048	59730
2019-12-26 11:26:35	63	15	113	5	794	2566	955211776	4214087680	2048	59724
2019-12-26 11:27:04	51	6	9	1	794	2566	955211776	4209106944	2048	59731
2019-12-26 11:27:34	51	6	9	1	794	2566	955211776	4209106944	2048	59731
2019-12-26 11:28:04	51	6	9	1	794	2566	955211776	4209106944	2048	59731
2019-12-26 11:28:34	51	6	9	1	794	2566	955211776	4209106944	2048	59731
2019-12-26 11:29:04	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:29:34	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:30:04	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:30:34	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:31:04	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:31:34	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:32:04	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:32:34	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:33:04	51	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:33:35	52	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:34:04	52	6	9	1	794	2566	955146240	4209106944	2048	59731
2019-12-26 11:34:34	52	6	9	1	794	2566	955146240	4209106944	2048	59731

Session Statistics

Session ordered by Wait Time
Session ordered by Long SQL
Session ordered by Long Transaction
Back to Top

Session ordered by Wait Time

SID	Wait Time (s)	Total Waits	Top 1 Event	Top 1 Wait Time (s)	Top 1 Waits	Top 1 Avg Wait Time (ms)	Top 2 Event	Top 2 Wait Time (s)	Top 2 Waits	Top 2 Avg Wait Time (ms)
3	28.206	5155	db file sequential read	18.517	4059	4.562	latch: data buffer pool	8.996	1064	8.455
21	2.053	483	latch: data buffer pool	2.047	66	31.019	db file sequential read	0.005	417	0.013
19	0.381	52	db file scattered read	0.380	46	8.257	log file sync	0.001	1	1.002
67	0.039	711	db file sequential read	0.033	691	0.048	db file scattered read	0.005	20	0.264
18	0.023	165	db file scattered read	0.016	75	0.218	db file sequential read	0.006	90	0.072

Session ordered by Long SQL

SID	SQL ID	Schema	Client IP	Program	Auto Commit	Logon time	SQL Exec Start	Snap Time	Module	Event	SQL Text
53	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:30:04	2019-12-26 11:30:04	2019-12-26 11:30:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
53	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	buffer busy waits	SELECT d_tax, d_next_o_id ...
53	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:34	2019-12-26 11:25:34	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
53	2305559646	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	db file sequential read	UPDATE bmsql_customer SET ...
53	2923084465	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:26:04	2019-12-26 11:26:04	JDBC	db file sequential read	UPDATE bmsql_order_line SE...
53	405006318	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:44	2019-12-26 11:15:28	2019-12-26 11:15:28	JDBC	buffer busy waits	INSERT INTO bmsql_stock ( s_i...
53	405006318	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:44	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_stock ( s_i...
53	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:44	2019-12-26 11:16:59	2019-12-26 11:16:59	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
53	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:44	2019-12-26 11:17:59	2019-12-26 11:17:59	JDBC	idle wait	INSERT INTO bmsql_order_line (...
53	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	latch: data buffer pool	SELECT s_quantity, s_data, ...
53	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	SELECT s_quantity, s_data, ...
54	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:21:00	2019-12-26 11:21:00	2019-12-26 11:21:00	JDBC	idle wait	select * from DV_SESSIONS WHER...
54	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:23:33	2019-12-26 11:23:33	2019-12-26 11:23:33	JDBC	idle wait	select * from DV_SESSIONS WHER...
54	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:28:34	2019-12-26 11:28:34	2019-12-26 11:28:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
54	203728423	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:59	2019-12-26 11:16:59	JDBC	db file scattered read	INSERT INTO bmsql_customer ( ...
54	3583228784	SYS	127.0.0.1		FALSE	2019-12-26 11:26:04	2019-12-26 11:26:04	2019-12-26 11:26:04	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
54	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
55	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:22:00	2019-12-26 11:22:00	2019-12-26 11:22:00	JDBC	idle wait	select * from DV_SESSIONS WHER...
55	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:27:04	2019-12-26 11:27:04	2019-12-26 11:27:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
55	3583228784	SYS	127.0.0.1		FALSE	2019-12-26 11:24:33	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
55	405006318	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:28	2019-12-26 11:15:28	JDBC	latch: data buffer pool	INSERT INTO bmsql_stock ( s_i...
55	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
56	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:28:04	2019-12-26 11:28:04	2019-12-26 11:28:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
56	3583228784	SYS	127.0.0.1		FALSE	2019-12-26 11:23:01	2019-12-26 11:23:03	2019-12-26 11:23:03	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
56	3583228784	SYS	127.0.0.1		FALSE	2019-12-26 11:25:33	2019-12-26 11:25:34	2019-12-26 11:25:34	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
56	405006318	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:28	2019-12-26 11:15:28	JDBC	heap extend segment	INSERT INTO bmsql_stock ( s_i...
56	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
56	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:29	2019-12-26 11:16:29	JDBC	latch: data buffer pool	INSERT INTO bmsql_order_line (...
57	1198270733	SYS	192.168.56.1		FALSE	2019-12-26 11:13:28	2019-12-26 11:13:28	2019-12-26 11:13:28	JDBC	idle wait	select * from DV_SESSIONS WHER...
57	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:29:34	2019-12-26 11:29:34	2019-12-26 11:29:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
57	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	buffer busy waits	SELECT d_tax, d_next_o_id ...
57	3583228784	SYS	192.168.56.1		FALSE	2019-12-26 11:15:58	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
57	368405445	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	SELECT count(*) AS low_stock F...
57	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:34	2019-12-26 11:25:34	JDBC	db file sequential read	SELECT s_quantity, s_data, ...
57	729190854	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	db file sequential read	SELECT c_discount, c_last, c_c...
58	1198270733	SYS	192.168.56.1		FALSE	2019-12-26 11:13:58	2019-12-26 11:13:58	2019-12-26 11:13:58	JDBC	idle wait	select * from DV_SESSIONS WHER...
58	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:33:34	2019-12-26 11:33:34	2019-12-26 11:33:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
58	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	buffer busy waits	SELECT d_tax, d_next_o_id ...
58	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:23:03	2019-12-26 11:23:03	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
58	2690334720	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	SELECT i_price, i_name, i_data...
58	3583228784	SYS	192.168.56.1		FALSE	2019-12-26 11:16:28	2019-12-26 11:16:29	2019-12-26 11:16:29	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
58	3583228784	SYS	192.168.56.1		FALSE	2019-12-26 11:18:29	2019-12-26 11:18:29	2019-12-26 11:18:29	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
59	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:31:34	2019-12-26 11:31:34	2019-12-26 11:31:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
59	209361974	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	latch: data buffer pool	UPDATE bmsql_oorder SET o_...
59	2305559646	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	UPDATE bmsql_customer SET ...
59	2305559646	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:34	2019-12-26 11:25:34	JDBC	db file sequential read	UPDATE bmsql_customer SET ...
59	289374106	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:23:03	2019-12-26 11:23:03	JDBC	db file scattered read	UPDATE bmsql_district SET ...
59	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	db file sequential read	SELECT s_quantity, s_data, ...
61	1198270733	SYS	127.0.0.1		TRUE	2019-12-26 11:34:04	2019-12-26 11:34:04	2019-12-26 11:34:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
61	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
61	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:29	2019-12-26 11:16:29	JDBC	buffer busy waits	INSERT INTO bmsql_order_line (...
62	1198270733	SYS	127.0.0.1		TRUE	2019-12-26 11:27:34	2019-12-26 11:27:34	2019-12-26 11:27:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
62	3583228784	SYS	127.0.0.1		TRUE	2019-12-26 11:22:30	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
62	3583228784	SYS	127.0.0.1		TRUE	2019-12-26 11:25:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
62	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
62	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:29	2019-12-26 11:16:29	JDBC	buffer busy waits	INSERT INTO bmsql_order_line (...
63	1198270733	SYS	127.0.0.1		TRUE	2019-12-26 11:34:34	2019-12-26 11:34:34	2019-12-26 11:34:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
63	203728423	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:59	2019-12-26 11:16:59	JDBC	db file scattered read	INSERT INTO bmsql_customer ( ...
63	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
63	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:29	2019-12-26 11:16:29	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
64	1198270733	SYS	192.168.56.1		FALSE	2019-12-26 11:12:58	2019-12-26 11:12:58	2019-12-26 11:12:58	JDBC	idle wait	select * from DV_SESSIONS WHER...
64	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:32:04	2019-12-26 11:32:04	2019-12-26 11:32:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
64	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	buffer busy waits	SELECT d_tax, d_next_o_id ...
64	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
64	2305559646	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:26:04	2019-12-26 11:26:04	JDBC	db file sequential read	UPDATE bmsql_customer SET ...
64	3583228784	SYS	192.168.56.1		FALSE	2019-12-26 11:15:28	2019-12-26 11:15:28	2019-12-26 11:15:28	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
64	4128069989	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	latch: data buffer pool	INSERT INTO bmsql_order_line (...
64	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	SELECT s_quantity, s_data, ...
65	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:30:34	2019-12-26 11:30:34	2019-12-26 11:30:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
65	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
65	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
65	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:26:34	2019-12-26 11:26:34	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
65	3583228784	SYS	127.0.0.1		FALSE	2019-12-26 11:20:00	2019-12-26 11:20:00	2019-12-26 11:20:00	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
65	405006318	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:28	2019-12-26 11:15:28	JDBC	heap extend segment	INSERT INTO bmsql_stock ( s_i...
65	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
65	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:29	2019-12-26 11:16:29	JDBC	buffer busy waits	INSERT INTO bmsql_order_line (...
65	4128069989	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	latch: data buffer pool	INSERT INTO bmsql_order_line (...
66	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:20:30	2019-12-26 11:20:30	2019-12-26 11:20:30	JDBC	idle wait	select * from DV_SESSIONS WHER...
66	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:31:04	2019-12-26 11:31:04	2019-12-26 11:31:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
66	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:34	2019-12-26 11:25:34	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
66	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:26:34	2019-12-26 11:26:34	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
66	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
66	447837152	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	db file sequential read	SELECT c_id FROM bmsql_cus...
66	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	db file sequential read	SELECT s_quantity, s_data, ...
66	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	SELECT s_quantity, s_data, ...
67	1198270733	SYS	192.168.56.1		FALSE	2019-12-26 11:14:28	2019-12-26 11:14:28	2019-12-26 11:14:28	JDBC	idle wait	select * from DV_SESSIONS WHER...
67	3583228784	SYS	192.168.56.1		FALSE	2019-12-26 11:16:59	2019-12-26 11:16:59	2019-12-26 11:16:59	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
67	3583228784	SYS	192.168.56.1		FALSE	2019-12-26 11:18:59	2019-12-26 11:18:59	2019-12-26 11:18:59	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
67	567372848	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	db file scattered read	DELETE FROM bmsql_new_order ...
68	1198270733	SYS	192.168.56.1		TRUE	2019-12-26 11:12:28	2019-12-26 11:12:28	2019-12-26 11:12:28	JDBC	idle wait	select * from DV_SESSIONS WHER...
68	1198270733	SYS	192.168.56.1		TRUE	2019-12-26 11:14:58	2019-12-26 11:14:58	2019-12-26 11:14:58	JDBC	idle wait	select * from DV_SESSIONS WHER...
68	1198270733	SYS	192.168.56.1		TRUE	2019-12-26 11:21:30	2019-12-26 11:21:30	2019-12-26 11:21:30	JDBC	idle wait	select * from DV_SESSIONS WHER...
68	1198270733	SYS	192.168.56.1		TRUE	2019-12-26 11:29:04	2019-12-26 11:29:04	2019-12-26 11:29:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
68	3583228784	SYS	192.168.56.1		TRUE	2019-12-26 11:17:59	2019-12-26 11:17:59	2019-12-26 11:17:59	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
68	3583228784	SYS	192.168.56.1		TRUE	2019-12-26 11:24:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
68	3583228784	SYS	192.168.56.1		TRUE	2019-12-26 11:26:34	2019-12-26 11:26:34	2019-12-26 11:26:34	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
70	1198270733	SYS	127.0.0.1		TRUE	2019-12-26 11:17:29	2019-12-26 11:17:29	2019-12-26 11:17:29	JDBC	idle wait	select * from DV_SESSIONS WHER...
70	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:33:04	2019-12-26 11:33:04	2019-12-26 11:33:04	JDBC	idle wait	select * from DV_SESSIONS WHER...
70	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:23:03	2019-12-26 11:23:03	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
70	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:03	2019-12-26 11:25:03	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
70	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:26:04	2019-12-26 11:26:04	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
70	3583228784	SYS	127.0.0.1		TRUE	2019-12-26 11:19:29	2019-12-26 11:19:29	2019-12-26 11:19:29	JDBC	idle wait	BEGIN WSR$CREATE_SESSION_SNAPS...
70	447837152	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	SELECT c_id FROM bmsql_cus...
70	617601049	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	idle wait	SELECT s_quantity, s_data, ...
71	1198270733	SYS	127.0.0.1		FALSE	2019-12-26 11:32:34	2019-12-26 11:32:34	2019-12-26 11:32:34	JDBC	idle wait	select * from DV_SESSIONS WHER...
71	1326412389	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:26:04	2019-12-26 11:26:04	JDBC	db file scattered read	SELECT d_tax, d_next_o_id ...
71	1775218545	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:25:34	2019-12-26 11:25:34	JDBC	db file sequential read	UPDATE bmsql_stock SET s_q...
71	19533674	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:16:29	2019-12-26 11:16:29	JDBC	db file scattered read	INSERT INTO bmsql_new_order ( ...
71	2305559646	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:03	2019-12-26 11:24:03	JDBC	latch: data buffer pool	UPDATE bmsql_customer SET ...
71	4071217845	STEVEN	127.0.0.1	[12319]gsql-jdbc	FALSE	2019-12-26 11:14:45	2019-12-26 11:15:58	2019-12-26 11:15:58	JDBC	db file scattered read	INSERT INTO bmsql_order_line (...
71	4128069989	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:24:33	2019-12-26 11:24:33	JDBC	db file sequential read	INSERT INTO bmsql_order_line (...
71	567372848	STEVEN	127.0.0.1	[12835]gsql-jdbc	FALSE	2019-12-26 11:22:03	2019-12-26 11:22:31	2019-12-26 11:22:31	JDBC	buffer busy waits	DELETE FROM bmsql_new_order ...

Session ordered by Long Transaction

Elapsed Time (s)	SID	Undo Count	Begin Time	Snap Time	SQL ID	SQL Text	Locked Table
194.000	55	2646	2019-12-26 11:14:45	2019-12-26 11:17:59		...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
194.000	63	2623	2019-12-26 11:14:45	2019-12-26 11:17:59		...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
178.000	53	2482	2019-12-26 11:15:01	2019-12-26 11:17:59		...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
164.000	54	2186	2019-12-26 11:14:45	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
164.000	61	2321	2019-12-26 11:14:45	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
164.000	65	2357	2019-12-26 11:14:45	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
164.000	62	2191	2019-12-26 11:14:45	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
164.000	71	2398	2019-12-26 11:14:45	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_ORDER_LINE
164.000	56	2185	2019-12-26 11:14:45	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_ORDER_LINE
163.000	66	2396	2019-12-26 11:14:46	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	BMSQL_WAREHOUSE ,BMSQL_STOCK ,BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_HISTORY ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_NEW_ORDER
42.000	64	1	2019-12-26 11:18:47	2019-12-26 11:19:29		...	SYS_CONSTRAINT_DEFS ,SYS_COLUMNS ,SYS_INDEXES ,SYS_TABLES ,BMSQL_ORDER_LINE
24.000	64	1	2019-12-26 11:18:05	2019-12-26 11:18:29		...	SYS_CONSTRAINT_DEFS ,SYS_COLUMNS ,SYS_INDEXES ,SYS_TABLES ,BMSQL_CUSTOMER
13.000	53	425	2019-12-26 11:14:45	2019-12-26 11:14:58	1198270733	select * from DV_SESSIONS WHER...	BMSQL_CONFIG ,BMSQL_ITEM
13.000	64	1	2019-12-26 11:19:47	2019-12-26 11:20:00		...	SYS_CONSTRAINT_DEFS ,SYS_COLUMNS ,SYS_INDEXES ,SYS_TABLES ,BMSQL_STOCK
1.000	71	0	2019-12-26 11:20:29	2019-12-26 11:20:30	1198270733	select * from DV_SESSIONS WHER...	BMSQL_ORDER_LINE ,BMSQL_OORDER ,BMSQL_STOCK
0.000	53	0	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT
0.000	53	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	53	1	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_OORDER
0.000	53	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_WAREHOUSE ,BMSQL_CUSTOMER ,BMSQL_HISTORY
0.000	53	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT ,BMSQL_OORDER
0.000	53	1	2019-12-26 11:26:04	2019-12-26 11:26:04	2923084465	UPDATE bmsql_order_line SE...	BMSQL_NEW_ORDER ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_CUSTOMER
0.000	53	1	2019-12-26 11:30:04	2019-12-26 11:30:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	54	1	2019-12-26 11:21:00	2019-12-26 11:21:00	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	54	1	2019-12-26 11:23:33	2019-12-26 11:23:33	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	54	1	2019-12-26 11:26:04	2019-12-26 11:26:04	2923084465	UPDATE bmsql_order_line SE...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	54	1	2019-12-26 11:28:34	2019-12-26 11:28:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	55	1	2019-12-26 11:22:00	2019-12-26 11:22:00	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	55	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	55	1	2019-12-26 11:27:04	2019-12-26 11:27:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	56	1	2019-12-26 11:23:03	2019-12-26 11:23:03		...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	56	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	56	1	2019-12-26 11:28:04	2019-12-26 11:28:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	57	1	2019-12-26 11:13:28	2019-12-26 11:13:28	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_LOCK_OBJECT ,WSR_TRANSACTION
0.000	57	1	2019-12-26 11:15:58	2019-12-26 11:15:58	405006318	INSERT INTO bmsql_stock ( s_i...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_SQLTEXT ,WSR_LOCK_OBJECT
0.000	57	0	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT
0.000	57	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	57	0	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_WAREHOUSE
0.000	57	1	2019-12-26 11:25:03	2019-12-26 11:25:03	2305559646	UPDATE bmsql_customer SET ...	BMSQL_NEW_ORDER ,BMSQL_ORDER_LINE ,BMSQL_OORDER ,BMSQL_CUSTOMER
0.000	65	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	65	1	2019-12-26 11:25:03	2019-12-26 11:25:03	2305559646	UPDATE bmsql_customer SET ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	66	1	2019-12-26 11:20:30	2019-12-26 11:20:30	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	66	1	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	66	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	66	1	2019-12-26 11:26:34	2019-12-26 11:26:34	3583228784	BEGIN WSR$CREATE_SESSION_SNAPS...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	67	1	2019-12-26 11:14:28	2019-12-26 11:14:28	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	67	1	2019-12-26 11:18:59	2019-12-26 11:18:59		...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	67	1	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT
0.000	67	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK
0.000	68	1	2019-12-26 11:14:58	2019-12-26 11:14:58	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	68	1	2019-12-26 11:21:30	2019-12-26 11:21:30	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	68	1	2019-12-26 11:26:34	2019-12-26 11:26:34	3583228784	BEGIN WSR$CREATE_SESSION_SNAPS...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	70	1	2019-12-26 11:17:29	2019-12-26 11:17:29	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	70	1	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT
0.000	70	1	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK
0.000	70	1	2019-12-26 11:26:04	2019-12-26 11:26:04	2923084465	UPDATE bmsql_order_line SE...	BMSQL_DISTRICT ,BMSQL_WAREHOUSE ,BMSQL_CUSTOMER ,BMSQL_HISTORY
0.000	71	2	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_NEW_ORDER ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_CUSTOMER
0.000	71	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	71	1	2019-12-26 11:32:34	2019-12-26 11:32:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	71	1	2019-12-26 11:26:34	2019-12-26 11:26:34	3583228784	BEGIN WSR$CREATE_SESSION_SNAPS...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	71	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT
0.000	71	0	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_NEW_ORDER
0.000	70	1	2019-12-26 11:33:04	2019-12-26 11:33:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	70	1	2019-12-26 11:26:34	2019-12-26 11:26:34	3583228784	BEGIN WSR$CREATE_SESSION_SNAPS...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	70	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	70	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	70	1	2019-12-26 11:19:29	2019-12-26 11:19:29		...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	68	1	2019-12-26 11:29:04	2019-12-26 11:29:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	68	1	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	68	1	2019-12-26 11:17:59	2019-12-26 11:17:59		...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	68	1	2019-12-26 11:12:28	2019-12-26 11:12:28	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	67	2	2019-12-26 11:25:03	2019-12-26 11:25:03	2305559646	UPDATE bmsql_customer SET ...	BMSQL_DISTRICT ,BMSQL_WAREHOUSE ,BMSQL_CUSTOMER ,BMSQL_HISTORY
0.000	67	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	67	1	2019-12-26 11:16:59	2019-12-26 11:16:59	4071217845	INSERT INTO bmsql_order_line (...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	66	1	2019-12-26 11:31:04	2019-12-26 11:31:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	66	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER
0.000	66	1	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_WAREHOUSE
0.000	66	1	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT ,BMSQL_WAREHOUSE
0.000	65	1	2019-12-26 11:30:34	2019-12-26 11:30:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	65	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER
0.000	65	0	2019-12-26 11:23:33	2019-12-26 11:23:33	1198270733	select * from DV_SESSIONS WHER...	BMSQL_NEW_ORDER ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_CUSTOMER
0.000	65	0	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT
0.000	57	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT ,BMSQL_NEW_ORDER ,BMSQL_OORDER ,BMSQL_STOCK
0.000	57	1	2019-12-26 11:26:34	2019-12-26 11:26:34	3583228784	BEGIN WSR$CREATE_SESSION_SNAPS...	BMSQL_DISTRICT ,BMSQL_CUSTOMER ,BMSQL_WAREHOUSE ,BMSQL_HISTORY
0.000	57	1	2019-12-26 11:29:34	2019-12-26 11:29:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_LOCK_OBJECT ,WSR_TRANSACTION
0.000	58	1	2019-12-26 11:13:58	2019-12-26 11:13:58	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	58	1	2019-12-26 11:16:29	2019-12-26 11:16:29	4071217845	INSERT INTO bmsql_order_line (...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	58	1	2019-12-26 11:18:29	2019-12-26 11:18:29		...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	58	0	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT
0.000	58	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	58	1	2019-12-26 11:23:33	2019-12-26 11:23:33	1198270733	select * from DV_SESSIONS WHER...	BMSQL_NEW_ORDER ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_CUSTOMER
0.000	58	1	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	58	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	58	1	2019-12-26 11:26:04	2019-12-26 11:26:04	2923084465	UPDATE bmsql_order_line SE...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	58	1	2019-12-26 11:33:34	2019-12-26 11:33:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	59	0	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT
0.000	59	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	59	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	BMSQL_NEW_ORDER ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_CUSTOMER
0.000	59	1	2019-12-26 11:25:03	2019-12-26 11:25:03	2305559646	UPDATE bmsql_customer SET ...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK
0.000	59	1	2019-12-26 11:25:34	2019-12-26 11:25:34	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_NEW_ORDER ,BMSQL_OORDER ,BMSQL_ORDER_LINE ,BMSQL_CUSTOMER
0.000	59	1	2019-12-26 11:26:34	2019-12-26 11:26:34	3583228784	BEGIN WSR$CREATE_SESSION_SNAPS...	BMSQL_DISTRICT ,BMSQL_OORDER ,BMSQL_NEW_ORDER ,BMSQL_STOCK ,BMSQL_ORDER_LINE
0.000	59	1	2019-12-26 11:31:34	2019-12-26 11:31:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	61	1	2019-12-26 11:34:04	2019-12-26 11:34:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	62	1	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	62	1	2019-12-26 11:25:03	2019-12-26 11:25:03	2305559646	UPDATE bmsql_customer SET ...	WSR_SESSION_SQL ,WSR_SQLTEXT ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	62	1	2019-12-26 11:27:34	2019-12-26 11:27:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	63	1	2019-12-26 11:34:34	2019-12-26 11:34:34	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	64	1	2019-12-26 11:12:58	2019-12-26 11:12:58	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
0.000	64	1	2019-12-26 11:15:28	2019-12-26 11:15:28	405006318	INSERT INTO bmsql_stock ( s_i...	WSR_TRANSACTION ,WSR_LOCK_OBJECT ,WSR_SESSION_SQL ,WSR_SQLTEXT
0.000	64	0	2019-12-26 11:22:31	2019-12-26 11:22:31	1326412389	SELECT d_tax, d_next_o_id ...	BMSQL_DISTRICT
0.000	64	0	2019-12-26 11:23:03	2019-12-26 11:23:03		...	BMSQL_DISTRICT
0.000	64	1	2019-12-26 11:24:03	2019-12-26 11:24:03	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT ,BMSQL_OORDER
0.000	64	1	2019-12-26 11:24:33	2019-12-26 11:24:33	617601049	SELECT s_quantity, s_data, ...	BMSQL_DISTRICT
0.000	64	2	2019-12-26 11:26:04	2019-12-26 11:26:04	2923084465	UPDATE bmsql_order_line SE...	BMSQL_DISTRICT ,BMSQL_WAREHOUSE ,BMSQL_CUSTOMER ,BMSQL_HISTORY
0.000	64	1	2019-12-26 11:32:04	2019-12-26 11:32:04	1198270733	select * from DV_SESSIONS WHER...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT
-1.000	65	1	2019-12-26 11:20:01	2019-12-26 11:20:00		...	WSR_SESSION_SQL ,WSR_TRANSACTION ,WSR_LOCK_OBJECT

SQL Statistics

SQL ordered by Elapsed Time
Long SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by first 6 letters
SQL ordered by first 10 letters
SQL ordered by first 15 letters
SQL ordered by first 20 letters
SQL ordered by first 30 letters
Long SQL ordered by first 15 letters
Long SQL ordered by first 30 letters
Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	Parse time	Wait time	Gets per Exec	CR Gets per Exec	Reads per Exec	Rows per Exec	SQL Id	SQL Module	Schema	Procedure	Line	VM Pages used(128K)	SQL Text
441.130	2996567	0.000	12.000	85.341	14.659	0.002	0.000	2.227	0.000	0.002	1.000	4071217845	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_order_line (...
324.480	1000000	0.000	9.000	87.900	12.100	0.000	0.000	2.965	0.000	0.006	1.000	0405006318	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_stock ( s_i...
213.617	30966	0.007	6.000	36.243	59.851	0.000	8.343	15.072	0.000	1.013	1.000	1326412389	JDBC	STEVEN		0	0.000	SELECT d_tax, d_next_o_id ...
200.385	29908	0.007	6.000	36.309	60.267	0.000	6.861	13.724	0.000	1.015	1.000	0289374106	JDBC	STEVEN		0	0.000	UPDATE bmsql_district SET ...
179.781	300000	0.001	5.000	94.943	5.057	0.000	0.000	3.498	0.000	0.003	1.000	0203728423	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_customer ( ...
107.357	309318	0.000	3.000	34.366	65.473	0.000	0.173	4.996	0.000	1.146	1.000	0617601049	JDBC	STEVEN		0	0.000	SELECT s_quantity, s_data, ...
72.754	29908	0.002	2.000	93.012	6.988	0.000	0.000	15.095	0.000	0.850	2.000	1619891791	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_history ( ...
63.497	29919	0.002	2.000	93.968	6.032	0.000	0.000	0.751	0.000	0.079	1.000	1781442178	JDBC	STEVEN		0	0.000	select bmsql_hist_id_seq.nextv...
54.158	309606	0.000	1.000	64.742	35.258	0.000	0.000	1.999	0.000	1.271	0.999	2690334720	JDBC	STEVEN		0	0.000	SELECT i_price, i_name, i_data...
39.518	30966	0.001	1.000	49.965	50.035	0.000	0.000	5.178	0.000	1.836	1.000	0729190854	JDBC	STEVEN		0	0.000	SELECT c_discount, c_last, c_c...
35.673	19544	0.002	1.000	14.773	85.227	0.000	0.000	4.356	0.000	3.132	2.331	0447837152	JDBC	STEVEN		0	0.000	SELECT c_id FROM bmsql_cus...
35.233	300000	0.000	1.000	75.890	24.110	0.283	0.000	2.127	0.000	0.003	1.000	0495268548	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_oorder ( o_...
32.389	300000	0.000	1.000	80.501	19.499	0.000	0.000	2.180	0.000	0.003	1.000	4146315128	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_history ( h...
27.138	27610	0.001	1.000	25.190	74.810	0.000	0.000	7.053	0.000	1.772	1.000	2305559646	JDBC	STEVEN		0	0.000	UPDATE bmsql_customer SET ...
26.936	27684	0.001	1.000	36.172	54.001	0.000	2.647	12.690	0.000	0.251	0.997	0567372848	JDBC	STEVEN		0	0.000	DELETE FROM bmsql_new_order ...
26.561	309318	0.000	1.000	73.752	26.248	0.000	0.000	10.569	0.000	0.644	1.000	4128069989	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_order_line (...
24.689	27610	0.001	1.000	32.841	67.159	0.000	0.000	44.113	0.000	1.158	9.980	2923084465	JDBC	STEVEN		0	0.000	UPDATE bmsql_order_line SE...
23.938	2866	0.008	1.000	72.244	27.756	0.000	0.000	794.052	0.072	151.493	1.000	0368405445	JDBC	STEVEN		0	4.000	SELECT count(*) AS low_stock F...
18.155	2735	0.007	0.000	45.325	54.675	0.000	0.000	1472.824	0.063	83.235	1.000	2280059544	JDBC	STEVEN		0	1.000	SELECT o_id, o_entry_d, o_carr...
17.038	27610	0.001	0.000	42.290	57.710	0.000	0.000	17.256	0.000	1.448	1.000	0209361974	JDBC	STEVEN		0	0.000	UPDATE bmsql_oorder SET o_...
15.431	309318	0.000	0.000	81.460	18.540	0.000	0.000	6.002	0.000	0.616	1.000	1775218545	JDBC	STEVEN		0	0.000	UPDATE bmsql_stock SET s_q...
15.120	2735	0.006	0.000	10.865	89.135	0.000	0.000	12.010	0.000	2.205	9.954	3638166556	JDBC	STEVEN		0	0.000	SELECT ol_i_id, ol_supply_w_id...
14.827	29908	0.000	0.000	32.911	67.089	0.000	0.000	5.000	0.000	1.623	1.000	3960484044	JDBC	STEVEN		0	0.000	SELECT c_first, c_middle, c_la...
14.144	29908	0.000	0.000	94.141	5.859	0.000	0.000	2.000	0.000	0.058	1.000	3660588145	JDBC	STEVEN		0	0.000	SELECT d_name, d_street_1, d_s...
14.124	29908	0.000	0.000	32.404	5.111	0.000	8.825	14.721	0.000	0.091	1.000	1661892907	JDBC	STEVEN		0	0.000	UPDATE bmsql_warehouse SET...
12.145	30966	0.000	0.000	58.928	41.072	0.000	0.000	15.773	0.000	1.296	1.000	4151099238	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_oorder ( ...
10.818	45	0.240	0.000	59.958	40.042	0.000	0.000	464.244	0.000	159.711	34.044	3583228784	JDBC	SYS		0	0.000	BEGIN WSR$CREATE_SESSION_SNAPS...
8.256	27684	0.000	0.000	73.329	26.671	0.000	0.000	3.079	0.000	0.381	100.000	2141580327	JDBC	STEVEN		0	0.000	SELECT no_o_id FROM bmsql_...
7.007	26831	0.000	0.000	85.720	14.280	0.000	0.000	6.004	0.000	0.677	1.000	0615692581	JDBC	STEVEN		0	0.000	UPDATE bmsql_customer SET ...
6.584	90000	0.000	0.000	68.107	31.893	0.000	0.000	2.077	0.000	0.002	1.000	0019533674	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_new_order ( ...
6.081	100000	0.000	0.000	11.309	88.691	0.000	0.000	2.213	0.000	0.006	1.000	3656167539	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_item ( i_id...
5.492	30966	0.000	0.000	93.771	6.229	0.000	0.000	5.002	0.000	0.060	1.000	3590314129	JDBC	STEVEN		0	0.000	UPDATE bmsql_district SET ...
5.239	27610	0.000	0.000	86.036	13.964	0.000	0.000	12.134	0.000	0.526	1.000	2314291513	JDBC	STEVEN		0	1.000	SELECT sum(ol_amount) AS sum_o...
5.081	30966	0.000	0.000	74.084	25.916	0.000	0.000	11.753	0.000	0.231	1.000	1316762144	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_new_order ( ...
4.354	27610	0.000	0.000	81.950	18.050	0.000	0.000	3.000	0.000	0.541	1.000	0844168030	JDBC	STEVEN		0	0.000	SELECT o_c_id FROM bmsql_o...
3.356	2735	0.001	0.000	66.900	33.100	0.000	0.000	3.000	0.000	1.572	1.000	4291921220	JDBC	STEVEN		0	0.000	SELECT c_first, c_middle, c_la...
2.912	45	0.065	0.000	34.201	65.799	0.000	0.000	63.956	0.000	35.289	1.000	2988770469	UNKNOWN	SYS	WSR$WRITE_INSTANCE_SNAP	19	1.000	select SUM(TXN_PAGES),SUM(UNDO...
2.244	29908	0.000	0.000	95.626	4.374	0.000	0.000	2.000	0.000	0.042	1.000	2815201306	JDBC	STEVEN		0	0.000	SELECT w_name, w_street_1, w_s...
1.976	147	0.013	0.000	66.022	33.978	0.000	0.000	9.857	0.000	1.769	1.000	0662783873	UNKNOWN	SYS	WSR$CREATE_SESSION_SNAPSHOT	23	0.000	insert INTO SYS.WSR_SESSION_SQ...
1.711	45	0.038	0.000	94.767	5.233	0.000	0.000	9.622	0.000	3.156	1.000	1377057357	UNKNOWN	SYS		0	4.000	insert INTO WSR_INSTANCE_SNAP ...
1.413	45	0.031	0.000	81.271	18.729	0.000	0.000	9.178	0.000	1.356	3.756	2354809456	UNKNOWN	SYS		0	0.000	insert INTO WSR_TRANSACTION (...
1.308	45	0.029	0.000	19.645	80.355	0.000	0.000	1.022	0.000	0.489	1.000	2906654698	UNKNOWN	SYS	WSR$CREATE_SESSION_SNAPSHOT	11	1.000	select COUNT(*) from WSR_CON...
1.174	3077	0.000	0.000	91.690	8.310	0.000	0.000	3.000	0.000	0.677	1.000	2694261527	JDBC	STEVEN		0	0.000	SELECT c_data FROM bmsql_c...
0.704	45	0.016	0.000	75.998	24.002	0.000	0.000	118.733	0.000	4.778	18.156	2735749187	UNKNOWN	SYS		0	0.000	insert INTO WSR_LOCK_OBJECT (...
0.331	3077	0.000	0.000	80.825	19.175	0.000	0.000	6.130	0.000	0.463	1.000	3747064878	JDBC	STEVEN		0	0.000	UPDATE bmsql_customer SET ...
0.236	100	0.002	0.000	89.820	10.180	0.025	0.000	3.790	0.000	0.340	1.000	0910329455	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_district ( ...
0.219	112	0.002	0.000	82.134	17.866	0.000	0.000	86.830	0.000	43.473	1.000	3964610326	UNKNOWN	SYS	WSR$CREATE_SESSION_SNAPSHOT	53	1.000	select COUNT(*) from SYS.WSR...
0.123	10	0.012	0.000	77.528	22.472	0.000	0.000	11.300	0.000	1.100	1.000	1645643541	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_warehouse ( ...
0.115	17	0.007	0.000	18.123	81.877	0.000	0.000	6.765	0.000	1.353	1.000	1100688548	UNKNOWN	SYS	WSR$CREATE_SESSION_SNAPSHOT	61	0.000	insert INTO SYS.WSR_SQLTEXT (...
0.100	1	0.100	0.000	81.530	18.470	0.000	0.000	12595.000	52.000	44.000	2010.000	0453948317	JDBC	SYS		0	0.000	BEGIN WSR$CREATE_SNAPSHOT(); E...
0.047	4	0.012	0.000	99.016	0.984	0.000	0.000	16.750	0.000	0.750	1.000	0092634197	JDBC	STEVEN		0	0.000	INSERT INTO bmsql_config ( cf...
0.046	1	0.046	0.000	89.925	10.075	0.008	0.000	2786.000	0.000	3.000	12.000	1136136383	JDBC	STEVEN		0	0.000	declare n integer; i integer; ...
0.040	1	0.040	0.000	71.315	28.685	0.000	0.000	5218.000	0.000	21.000	1010.000	1911224605	UNKNOWN	SYS		0	0.000	insert INTO WSR_SEGMENT (SNAP...
0.039	1	0.039	0.000	99.941	0.059	0.003	0.000	2771.000	0.000	1.000	1.000	1218455557	JDBC	STEVEN		0	1.000	select max(hist_id) from bmsql...
0.027	45	0.001	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	2671632775	UNKNOWN	SYS	WSR$WRITE_INSTANCE_SNAP	10	1.000	select COUNT(*),COUNT(DECODE(S...
0.020	1	0.020	0.000	97.525	2.475	0.000	0.000	181.000	0.000	4.000	14.000	4266041370	UNKNOWN	SYS		0	0.000	insert INTO WSR_SESSION_EVENTS...
0.018	45	0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1198270733	UNKNOWN	SYS	WSR$CREATE_SESSION_SNAPSHOT	21	0.000	select * from DV_SESSIONS WHER...
0.017	1	0.017	0.000	86.955	13.045	0.000	0.000	4176.000	52.000	6.000	454.000	2871286689	UNKNOWN	SYS		0	18.000	insert INTO WSR_DBA_SEGMENTS ...
0.016	665	0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1817342111	JDBC	STEVEN		0	0.000	SELECT 1...
0.007	77	0.000	0.000	95.627	4.373	0.000	0.000	3.338	0.000	0.039	1.000	3038683717	UNKNOWN	SYS		0	0.000	insert INTO WSR_SQLAREA (SNAP...
0.006	45	0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1854133114	UNKNOWN	SYS	WSR$WRITE_INSTANCE_SNAP	14	1.000	select SUM(DECODE(TABLESPACE_N...
0.005	1	0.005	0.000	53.101	46.899	0.000	0.000	1501.000	0.000	6.000	233.000	4036846721	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	198	0.000	insert INTO WSR_PARAMETER (SN...
0.005	1	0.005	0.000	56.156	43.844	0.000	0.000	518.000	0.000	178.000	81.000	0813566551	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	27	0.000	insert INTO WSR_SYS_STAT (SNA...
0.003	2	0.001	0.000	5.492	94.508	0.000	0.000	2.000	0.000	2.000	1.000	2742635046	JDBC	STEVEN		0	0.000	SELECT cfg_value FROM bmsql_co...
0.002	1	0.002	0.000	93.575	6.425	0.000	0.000	15.000	0.000	2.000	1.000	4229588365	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	15	0.000	select SNAP_ID$.NEXTVAL from ...
0.002	1	0.002	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	2008876062	ZSQL	SYS		0	0.000	SELECT DBTIMEZONE FROM SYS.DV_...
0.002	1	0.002	0.000	24.567	75.433	0.000	0.000	136.000	0.000	7.000	19.000	3425372336	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	39	0.000	insert INTO WSR_SYSTEM (SNAP_...
0.001	1	0.001	0.000	20.737	79.263	0.000	0.000	194.000	0.000	9.000	27.000	3358378755	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	51	0.000	insert INTO WSR_SYSTEM_EVENT ...
0.001	77	0.000	0.000	100.000	0.000	0.000	0.000	2.000	0.000	0.000	1.000	2167779333	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	128	1.000	select COUNT(*) from WSR_SQL...
0.001	1	0.001	0.000	35.047	64.953	0.002	0.000	3.000	0.000	1.000	20.000	0642457297	ZSQL	SYS		0	2.000	SELECT LPAD(SNAP_ID, 15, ' '),...
0.001	1	0.001	0.000	100.000	0.000	0.000	0.000	8.000	0.000	0.000	1.000	3310877950	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	387	2.000	insert INTO WSR_SNAPSHOT (SNA...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	3346861191	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	97	0.000	select SQL_ID, MIN(SQL_TEXT) S...
0.000	1	0.000	0.000	98.347	1.653	0.000	0.000	88.000	0.000	2.000	1.000	3923215066	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	73	0.000	insert INTO WSR_SYSTEM_EVENT ...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0049052732	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	19	0.000	select INSTANCE_ID from DV_I...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	38.000	0.000	0.000	5.000	2358353897	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	208	0.000	insert INTO WSR_LATCH (SNAP_I...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	30.000	0.000	0.000	5.000	4081488768	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	226	0.000	insert INTO WSR_WAITSTAT (SNA...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0803557546	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	305	0.000	select :1 , TO_DATE(CTIME,'YYY...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	5.000	0.000	0.000	1.000	1815131950	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	428	0.000	update WSR_CONTROL set MOST_RE...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	8.000	0.000	0.000	1.000	3887671171	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	238	0.000	insert INTO WSR_LIBRARYCACHE ...
0.000	1	0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0098598691	UNKNOWN	SYS	WSR$CREATE_SNAPSHOT	23	0.000	select DBID from DV_DATABASE...

Long SQL ordered by Elapsed Time

Resources reported long SQL.

Executions	Execution Time(s)	Max Execution Time (s)	Parses	Parse Time (s)	Fetchs	Fetch Time (s)	SQL Id	SQL Text

SQL ordered by CPU Time

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
376.464	2996567	0.000	13.000	441.130	85.341	14.659	4071217845	JDBC	INSERT INTO bmsql_order_line (...
285.219	1000000	0.000	10.000	324.480	87.900	12.100	0405006318	JDBC	INSERT INTO bmsql_stock ( s_i...
170.690	300000	0.001	6.000	179.781	94.943	5.057	0203728423	JDBC	INSERT INTO bmsql_customer ( ...
77.421	30966	0.003	3.000	213.617	36.243	59.851	1326412389	JDBC	SELECT d_tax, d_next_o_id ...
72.758	29908	0.002	2.000	200.385	36.309	60.267	0289374106	JDBC	UPDATE bmsql_district SET ...
67.670	29908	0.002	2.000	72.754	93.012	6.988	1619891791	JDBC	INSERT INTO bmsql_history ( ...
59.666	29919	0.002	2.000	63.497	93.968	6.032	1781442178	JDBC	select bmsql_hist_id_seq.nextv...
36.894	309318	0.000	1.000	107.357	34.366	65.473	0617601049	JDBC	SELECT s_quantity, s_data, ...
35.063	309606	0.000	1.000	54.158	64.742	35.258	2690334720	JDBC	SELECT i_price, i_name, i_data...
26.738	300000	0.000	1.000	35.233	75.890	24.110	0495268548	JDBC	INSERT INTO bmsql_oorder ( o_...
26.073	300000	0.000	1.000	32.389	80.501	19.499	4146315128	JDBC	INSERT INTO bmsql_history ( h...
19.745	30966	0.001	1.000	39.518	49.965	50.035	0729190854	JDBC	SELECT c_discount, c_last, c_c...
19.589	309318	0.000	1.000	26.561	73.752	26.248	4128069989	JDBC	INSERT INTO bmsql_order_line (...
17.294	2866	0.006	1.000	23.938	72.244	27.756	0368405445	JDBC	SELECT count(*) AS low_stock F...
13.315	29908	0.000	0.000	14.144	94.141	5.859	3660588145	JDBC	SELECT d_name, d_street_1, d_s...
12.570	309318	0.000	0.000	15.431	81.460	18.540	1775218545	JDBC	UPDATE bmsql_stock SET s_q...
9.743	27684	0.000	0.000	26.936	36.172	54.001	0567372848	JDBC	DELETE FROM bmsql_new_order ...
8.229	2735	0.003	0.000	18.155	45.325	54.675	2280059544	JDBC	SELECT o_id, o_entry_d, o_carr...
8.108	27610	0.000	0.000	24.689	32.841	67.159	2923084465	JDBC	UPDATE bmsql_order_line SE...
7.205	27610	0.000	0.000	17.038	42.290	57.710	0209361974	JDBC	UPDATE bmsql_oorder SET o_...
7.157	30966	0.000	0.000	12.145	58.928	41.072	4151099238	JDBC	INSERT INTO bmsql_oorder ( ...
6.836	27610	0.000	0.000	27.138	25.190	74.810	2305559646	JDBC	UPDATE bmsql_customer SET ...
6.486	45	0.144	0.000	10.818	59.958	40.042	3583228784	JDBC	BEGIN WSR$CREATE_SESSION_SNAPS...
6.054	27684	0.000	0.000	8.256	73.329	26.671	2141580327	JDBC	SELECT no_o_id FROM bmsql_...
6.006	26831	0.000	0.000	7.007	85.720	14.280	0615692581	JDBC	UPDATE bmsql_customer SET ...
5.270	19544	0.000	0.000	35.673	14.773	85.227	0447837152	JDBC	SELECT c_id FROM bmsql_cus...
5.150	30966	0.000	0.000	5.492	93.771	6.229	3590314129	JDBC	UPDATE bmsql_district SET ...
4.880	29908	0.000	0.000	14.827	32.911	67.089	3960484044	JDBC	SELECT c_first, c_middle, c_la...
4.577	29908	0.000	0.000	14.124	32.404	5.111	1661892907	JDBC	UPDATE bmsql_warehouse SET...
4.507	27610	0.000	0.000	5.239	86.036	13.964	2314291513	JDBC	SELECT sum(ol_amount) AS sum_o...
4.484	90000	0.000	0.000	6.584	68.107	31.893	0019533674	JDBC	INSERT INTO bmsql_new_order ( ...
3.764	30966	0.000	0.000	5.081	74.084	25.916	1316762144	JDBC	INSERT INTO bmsql_new_order ( ...
3.568	27610	0.000	0.000	4.354	81.950	18.050	0844168030	JDBC	SELECT o_c_id FROM bmsql_o...
2.245	2735	0.001	0.000	3.356	66.900	33.100	4291921220	JDBC	SELECT c_first, c_middle, c_la...
2.146	29908	0.000	0.000	2.244	95.626	4.374	2815201306	JDBC	SELECT w_name, w_street_1, w_s...
1.643	2735	0.001	0.000	15.120	10.865	89.135	3638166556	JDBC	SELECT ol_i_id, ol_supply_w_id...
1.622	45	0.036	0.000	1.711	94.767	5.233	1377057357	UNKNOWN	insert INTO WSR_INSTANCE_SNAP ...
1.304	147	0.009	0.000	1.976	66.022	33.978	0662783873	UNKNOWN	insert INTO SYS.WSR_SESSION_SQ...
1.148	45	0.026	0.000	1.413	81.271	18.729	2354809456	UNKNOWN	insert INTO WSR_TRANSACTION (...
1.076	3077	0.000	0.000	1.174	91.690	8.310	2694261527	JDBC	SELECT c_data FROM bmsql_c...
0.996	45	0.022	0.000	2.912	34.201	65.799	2988770469	UNKNOWN	select SUM(TXN_PAGES),SUM(UNDO...
0.688	100000	0.000	0.000	6.081	11.309	88.691	3656167539	JDBC	INSERT INTO bmsql_item ( i_id...
0.535	45	0.012	0.000	0.704	75.998	24.002	2735749187	UNKNOWN	insert INTO WSR_LOCK_OBJECT (...
0.267	3077	0.000	0.000	0.331	80.825	19.175	3747064878	JDBC	UPDATE bmsql_customer SET ...
0.257	45	0.006	0.000	1.308	19.645	80.355	2906654698	UNKNOWN	select COUNT(*) from WSR_CON...
0.212	100	0.002	0.000	0.236	89.820	10.180	0910329455	JDBC	INSERT INTO bmsql_district ( ...
0.180	112	0.002	0.000	0.219	82.134	17.866	3964610326	UNKNOWN	select COUNT(*) from SYS.WSR...
0.095	10	0.010	0.000	0.123	77.528	22.472	1645643541	JDBC	INSERT INTO bmsql_warehouse ( ...
0.082	1	0.082	0.000	0.100	81.530	18.470	0453948317	JDBC	BEGIN WSR$CREATE_SNAPSHOT(); E...
0.046	4	0.012	0.000	0.047	99.016	0.984	0092634197	JDBC	INSERT INTO bmsql_config ( cf...
0.042	1	0.042	0.000	0.046	89.925	10.075	1136136383	JDBC	declare n integer; i integer; ...
0.039	1	0.039	0.000	0.039	99.941	0.059	1218455557	JDBC	select max(hist_id) from bmsql...
0.028	1	0.028	0.000	0.040	71.315	28.685	1911224605	UNKNOWN	insert INTO WSR_SEGMENT (SNAP...
0.027	45	0.001	0.000	0.027	100.000	0.000	2671632775	UNKNOWN	select COUNT(*),COUNT(DECODE(S...
0.021	17	0.001	0.000	0.115	18.123	81.877	1100688548	UNKNOWN	insert INTO SYS.WSR_SQLTEXT (...
0.020	1	0.020	0.000	0.020	97.525	2.475	4266041370	UNKNOWN	insert INTO WSR_SESSION_EVENTS...
0.018	45	0.000	0.000	0.018	100.000	0.000	1198270733	UNKNOWN	select * from DV_SESSIONS WHER...
0.016	665	0.000	0.000	0.016	100.000	0.000	1817342111	JDBC	SELECT 1...
0.015	1	0.015	0.000	0.017	86.955	13.045	2871286689	UNKNOWN	insert INTO WSR_DBA_SEGMENTS ...
0.006	77	0.000	0.000	0.007	95.627	4.373	3038683717	UNKNOWN	insert INTO WSR_SQLAREA (SNAP...
0.006	45	0.000	0.000	0.006	100.000	0.000	1854133114	UNKNOWN	select SUM(DECODE(TABLESPACE_N...
0.003	1	0.003	0.000	0.005	53.101	46.899	4036846721	UNKNOWN	insert INTO WSR_PARAMETER (SN...
0.003	1	0.003	0.000	0.005	56.156	43.844	0813566551	UNKNOWN	insert INTO WSR_SYS_STAT (SNA...
0.002	1	0.002	0.000	0.002	93.575	6.425	4229588365	UNKNOWN	select SNAP_ID$.NEXTVAL from ...
0.002	1	0.002	0.000	0.002	100.000	0.000	2008876062	ZSQL	SELECT DBTIMEZONE FROM SYS.DV_...
0.001	77	0.000	0.000	0.001	100.000	0.000	2167779333	UNKNOWN	select COUNT(*) from WSR_SQL...
0.001	1	0.001	0.000	0.001	100.000	0.000	3310877950	UNKNOWN	insert INTO WSR_SNAPSHOT (SNA...
0.000	1	0.000	0.000	0.002	24.567	75.433	3425372336	UNKNOWN	insert INTO WSR_SYSTEM (SNAP_...
0.000	1	0.000	0.000	0.000	100.000	0.000	3346861191	UNKNOWN	select SQL_ID, MIN(SQL_TEXT) S...
0.000	1	0.000	0.000	0.000	98.347	1.653	3923215066	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
0.000	1	0.000	0.000	0.001	20.737	79.263	3358378755	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
0.000	1	0.000	0.000	0.001	35.047	64.953	0642457297	ZSQL	SELECT LPAD(SNAP_ID, 15, ' '),...
0.000	1	0.000	0.000	0.000	100.000	0.000	0049052732	UNKNOWN	select INSTANCE_ID from DV_I...
0.000	1	0.000	0.000	0.000	100.000	0.000	2358353897	UNKNOWN	insert INTO WSR_LATCH (SNAP_I...
0.000	2	0.000	0.000	0.003	5.492	94.508	2742635046	JDBC	SELECT cfg_value FROM bmsql_co...
0.000	1	0.000	0.000	0.000	100.000	0.000	4081488768	UNKNOWN	insert INTO WSR_WAITSTAT (SNA...
0.000	1	0.000	0.000	0.000	100.000	0.000	0803557546	UNKNOWN	select :1 , TO_DATE(CTIME,'YYY...
0.000	1	0.000	0.000	0.000	100.000	0.000	1815131950	UNKNOWN	update WSR_CONTROL set MOST_RE...
0.000	1	0.000	0.000	0.000	100.000	0.000	3887671171	UNKNOWN	insert INTO WSR_LIBRARYCACHE ...
0.000	1	0.000	0.000	0.000	100.000	0.000	0098598691	UNKNOWN	select DBID from DV_DATABASE...

SQL ordered by User I/O Wait Time

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
127.853	30966	0.004	19.000	213.617	36.243	59.851	1326412389	JDBC	SELECT d_tax, d_next_o_id ...
120.766	29908	0.004	18.000	200.385	36.309	60.267	0289374106	JDBC	UPDATE bmsql_district SET ...
70.290	309318	0.000	10.000	107.357	34.366	65.473	0617601049	JDBC	SELECT s_quantity, s_data, ...
64.666	2996567	0.000	9.000	441.130	85.341	14.659	4071217845	JDBC	INSERT INTO bmsql_order_line (...
39.261	1000000	0.000	6.000	324.480	87.900	12.100	0405006318	JDBC	INSERT INTO bmsql_stock ( s_i...
30.403	19544	0.002	4.000	35.673	14.773	85.227	0447837152	JDBC	SELECT c_id FROM bmsql_cus...
20.302	27610	0.001	3.000	27.138	25.190	74.810	2305559646	JDBC	UPDATE bmsql_customer SET ...
19.772	30966	0.001	3.000	39.518	49.965	50.035	0729190854	JDBC	SELECT c_discount, c_last, c_c...
19.095	309606	0.000	3.000	54.158	64.742	35.258	2690334720	JDBC	SELECT i_price, i_name, i_data...
16.581	27610	0.001	2.000	24.689	32.841	67.159	2923084465	JDBC	UPDATE bmsql_order_line SE...
14.545	27684	0.001	2.000	26.936	36.172	54.001	0567372848	JDBC	DELETE FROM bmsql_new_order ...
13.477	2735	0.005	2.000	15.120	10.865	89.135	3638166556	JDBC	SELECT ol_i_id, ol_supply_w_id...
9.948	29908	0.000	1.000	14.827	32.911	67.089	3960484044	JDBC	SELECT c_first, c_middle, c_la...
9.926	2735	0.004	1.000	18.155	45.325	54.675	2280059544	JDBC	SELECT o_id, o_entry_d, o_carr...
9.832	27610	0.000	1.000	17.038	42.290	57.710	0209361974	JDBC	UPDATE bmsql_oorder SET o_...
9.091	300000	0.000	1.000	179.781	94.943	5.057	0203728423	JDBC	INSERT INTO bmsql_customer ( ...
8.495	300000	0.000	1.000	35.233	75.890	24.110	0495268548	JDBC	INSERT INTO bmsql_oorder ( o_...
6.972	309318	0.000	1.000	26.561	73.752	26.248	4128069989	JDBC	INSERT INTO bmsql_order_line (...
6.644	2866	0.002	1.000	23.938	72.244	27.756	0368405445	JDBC	SELECT count(*) AS low_stock F...
6.315	300000	0.000	1.000	32.389	80.501	19.499	4146315128	JDBC	INSERT INTO bmsql_history ( h...
5.393	100000	0.000	1.000	6.081	11.309	88.691	3656167539	JDBC	INSERT INTO bmsql_item ( i_id...
5.084	29908	0.000	1.000	72.754	93.012	6.988	1619891791	JDBC	INSERT INTO bmsql_history ( ...
4.988	30966	0.000	1.000	12.145	58.928	41.072	4151099238	JDBC	INSERT INTO bmsql_oorder ( ...
4.332	45	0.096	1.000	10.818	59.958	40.042	3583228784	JDBC	BEGIN WSR$CREATE_SESSION_SNAPS...
3.830	29919	0.000	1.000	63.497	93.968	6.032	1781442178	JDBC	select bmsql_hist_id_seq.nextv...
2.861	309318	0.000	0.000	15.431	81.460	18.540	1775218545	JDBC	UPDATE bmsql_stock SET s_q...
2.202	27684	0.000	0.000	8.256	73.329	26.671	2141580327	JDBC	SELECT no_o_id FROM bmsql_...
2.100	90000	0.000	0.000	6.584	68.107	31.893	0019533674	JDBC	INSERT INTO bmsql_new_order ( ...
1.916	45	0.043	0.000	2.912	34.201	65.799	2988770469	UNKNOWN	select SUM(TXN_PAGES),SUM(UNDO...
1.317	30966	0.000	0.000	5.081	74.084	25.916	1316762144	JDBC	INSERT INTO bmsql_new_order ( ...
1.111	2735	0.000	0.000	3.356	66.900	33.100	4291921220	JDBC	SELECT c_first, c_middle, c_la...
1.051	45	0.023	0.000	1.308	19.645	80.355	2906654698	UNKNOWN	select COUNT(*) from WSR_CON...
1.001	26831	0.000	0.000	7.007	85.720	14.280	0615692581	JDBC	UPDATE bmsql_customer SET ...
0.829	29908	0.000	0.000	14.144	94.141	5.859	3660588145	JDBC	SELECT d_name, d_street_1, d_s...
0.786	27610	0.000	0.000	4.354	81.950	18.050	0844168030	JDBC	SELECT o_c_id FROM bmsql_o...
0.732	27610	0.000	0.000	5.239	86.036	13.964	2314291513	JDBC	SELECT sum(ol_amount) AS sum_o...
0.722	29908	0.000	0.000	14.124	32.404	5.111	1661892907	JDBC	UPDATE bmsql_warehouse SET...
0.671	147	0.005	0.000	1.976	66.022	33.978	0662783873	UNKNOWN	insert INTO SYS.WSR_SESSION_SQ...
0.342	30966	0.000	0.000	5.492	93.771	6.229	3590314129	JDBC	UPDATE bmsql_district SET ...
0.265	45	0.006	0.000	1.413	81.271	18.729	2354809456	UNKNOWN	insert INTO WSR_TRANSACTION (...
0.169	45	0.004	0.000	0.704	75.998	24.002	2735749187	UNKNOWN	insert INTO WSR_LOCK_OBJECT (...
0.098	29908	0.000	0.000	2.244	95.626	4.374	2815201306	JDBC	SELECT w_name, w_street_1, w_s...
0.098	3077	0.000	0.000	1.174	91.690	8.310	2694261527	JDBC	SELECT c_data FROM bmsql_c...
0.094	17	0.006	0.000	0.115	18.123	81.877	1100688548	UNKNOWN	insert INTO SYS.WSR_SQLTEXT (...
0.090	45	0.002	0.000	1.711	94.767	5.233	1377057357	UNKNOWN	insert INTO WSR_INSTANCE_SNAP ...
0.063	3077	0.000	0.000	0.331	80.825	19.175	3747064878	JDBC	UPDATE bmsql_customer SET ...
0.039	112	0.000	0.000	0.219	82.134	17.866	3964610326	UNKNOWN	select COUNT(*) from SYS.WSR...
0.028	10	0.003	0.000	0.123	77.528	22.472	1645643541	JDBC	INSERT INTO bmsql_warehouse ( ...
0.024	100	0.000	0.000	0.236	89.820	10.180	0910329455	JDBC	INSERT INTO bmsql_district ( ...
0.018	1	0.018	0.000	0.100	81.530	18.470	0453948317	JDBC	BEGIN WSR$CREATE_SNAPSHOT(); E...
0.011	1	0.011	0.000	0.040	71.315	28.685	1911224605	UNKNOWN	insert INTO WSR_SEGMENT (SNAP...
0.005	1	0.005	0.000	0.046	89.925	10.075	1136136383	JDBC	declare n integer; i integer; ...
0.003	2	0.001	0.000	0.003	5.492	94.508	2742635046	JDBC	SELECT cfg_value FROM bmsql_co...
0.002	1	0.002	0.000	0.005	53.101	46.899	4036846721	UNKNOWN	insert INTO WSR_PARAMETER (SN...
0.002	1	0.002	0.000	0.017	86.955	13.045	2871286689	UNKNOWN	insert INTO WSR_DBA_SEGMENTS ...
0.002	1	0.002	0.000	0.005	56.156	43.844	0813566551	UNKNOWN	insert INTO WSR_SYS_STAT (SNA...
0.001	1	0.001	0.000	0.002	24.567	75.433	3425372336	UNKNOWN	insert INTO WSR_SYSTEM (SNAP_...
0.001	1	0.001	0.000	0.001	20.737	79.263	3358378755	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
0.001	1	0.001	0.000	0.020	97.525	2.475	4266041370	UNKNOWN	insert INTO WSR_SESSION_EVENTS...
0.000	1	0.000	0.000	0.001	35.047	64.953	0642457297	ZSQL	SELECT LPAD(SNAP_ID, 15, ' '),...
0.000	4	0.000	0.000	0.047	99.016	0.984	0092634197	JDBC	INSERT INTO bmsql_config ( cf...
0.000	77	0.000	0.000	0.007	95.627	4.373	3038683717	UNKNOWN	insert INTO WSR_SQLAREA (SNAP...
0.000	1	0.000	0.000	0.002	93.575	6.425	4229588365	UNKNOWN	select SNAP_ID$.NEXTVAL from ...
0.000	1	0.000	0.000	0.039	99.941	0.059	1218455557	JDBC	select max(hist_id) from bmsql...
0.000	1	0.000	0.000	0.000	98.347	1.653	3923215066	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
0.000	45	0.000	0.000	0.027	100.000	0.000	2671632775	UNKNOWN	select COUNT(*),COUNT(DECODE(S...
0.000	45	0.000	0.000	0.018	100.000	0.000	1198270733	UNKNOWN	select * from DV_SESSIONS WHER...
0.000	665	0.000	0.000	0.016	100.000	0.000	1817342111	JDBC	SELECT 1...
0.000	45	0.000	0.000	0.006	100.000	0.000	1854133114	UNKNOWN	select SUM(DECODE(TABLESPACE_N...
0.000	1	0.000	0.000	0.002	100.000	0.000	2008876062	ZSQL	SELECT DBTIMEZONE FROM SYS.DV_...
0.000	1	0.000	0.000	0.001	100.000	0.000	3310877950	UNKNOWN	insert INTO WSR_SNAPSHOT (SNA...
0.000	77	0.000	0.000	0.001	100.000	0.000	2167779333	UNKNOWN	select COUNT(*) from WSR_SQL...
0.000	1	0.000	0.000	0.000	100.000	0.000	3887671171	UNKNOWN	insert INTO WSR_LIBRARYCACHE ...
0.000	1	0.000	0.000	0.000	100.000	0.000	0049052732	UNKNOWN	select INSTANCE_ID from DV_I...
0.000	1	0.000	0.000	0.000	100.000	0.000	4081488768	UNKNOWN	insert INTO WSR_WAITSTAT (SNA...
0.000	1	0.000	0.000	0.000	100.000	0.000	3346861191	UNKNOWN	select SQL_ID, MIN(SQL_TEXT) S...
0.000	1	0.000	0.000	0.000	100.000	0.000	1815131950	UNKNOWN	update WSR_CONTROL set MOST_RE...
0.000	1	0.000	0.000	0.000	100.000	0.000	0098598691	UNKNOWN	select DBID from DV_DATABASE...
0.000	1	0.000	0.000	0.000	100.000	0.000	0803557546	UNKNOWN	select :1 , TO_DATE(CTIME,'YYY...
0.000	1	0.000	0.000	0.000	100.000	0.000	2358353897	UNKNOWN	insert INTO WSR_LATCH (SNAP_I...

SQL ordered by User Gets

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6673259	2996567	2.227	13.000	441.130	85.341	14.659	4071217845	JDBC	INSERT INTO bmsql_order_line (...
4028174	2735	1472.824	8.000	18.155	45.325	54.675	2280059544	JDBC	SELECT o_id, o_entry_d, o_carr...
3269284	309318	10.569	7.000	26.561	73.752	26.248	4128069989	JDBC	INSERT INTO bmsql_order_line (...
2965278	1000000	2.965	6.000	324.480	87.900	12.100	0405006318	JDBC	INSERT INTO bmsql_stock ( s_i...
2275752	2866	794.052	5.000	23.938	72.244	27.756	0368405445	JDBC	SELECT count(*) AS low_stock F...
1856563	309318	6.002	4.000	15.431	81.460	18.540	1775218545	JDBC	UPDATE bmsql_stock SET s_q...
1545276	309318	4.996	3.000	107.357	34.366	65.473	0617601049	JDBC	SELECT s_quantity, s_data, ...
1217952	27610	44.113	2.000	24.689	32.841	67.159	2923084465	JDBC	UPDATE bmsql_order_line SE...
1049404	300000	3.498	2.000	179.781	94.943	5.057	0203728423	JDBC	INSERT INTO bmsql_customer ( ...
654103	300000	2.180	1.000	32.389	80.501	19.499	4146315128	JDBC	INSERT INTO bmsql_history ( h...
638222	300000	2.127	1.000	35.233	75.890	24.110	0495268548	JDBC	INSERT INTO bmsql_oorder ( o_...
618924	309606	1.999	1.000	54.158	64.742	35.258	2690334720	JDBC	SELECT i_price, i_name, i_data...
488438	30966	15.773	1.000	12.145	58.928	41.072	4151099238	JDBC	INSERT INTO bmsql_oorder ( ...
476428	27610	17.256	1.000	17.038	42.290	57.710	0209361974	JDBC	UPDATE bmsql_oorder SET o_...
466705	30966	15.072	1.000	213.617	36.243	59.851	1326412389	JDBC	SELECT d_tax, d_next_o_id ...
451476	29908	15.095	1.000	72.754	93.012	6.988	1619891791	JDBC	INSERT INTO bmsql_history ( ...
440271	29908	14.721	1.000	14.124	32.404	5.111	1661892907	JDBC	UPDATE bmsql_warehouse SET...
410461	29908	13.724	1.000	200.385	36.309	60.267	0289374106	JDBC	UPDATE bmsql_district SET ...
363935	30966	11.753	1.000	5.081	74.084	25.916	1316762144	JDBC	INSERT INTO bmsql_new_order ( ...
351316	27684	12.690	1.000	26.936	36.172	54.001	0567372848	JDBC	DELETE FROM bmsql_new_order ...
335008	27610	12.134	1.000	5.239	86.036	13.964	2314291513	JDBC	SELECT sum(ol_amount) AS sum_o...
221346	100000	2.213	0.000	6.081	11.309	88.691	3656167539	JDBC	INSERT INTO bmsql_item ( i_id...
194727	27610	7.053	0.000	27.138	25.190	74.810	2305559646	JDBC	UPDATE bmsql_customer SET ...
186944	90000	2.077	0.000	6.584	68.107	31.893	0019533674	JDBC	INSERT INTO bmsql_new_order ( ...
161082	26831	6.004	0.000	7.007	85.720	14.280	0615692581	JDBC	UPDATE bmsql_customer SET ...
160334	30966	5.178	0.000	39.518	49.965	50.035	0729190854	JDBC	SELECT c_discount, c_last, c_c...
154888	30966	5.002	0.000	5.492	93.771	6.229	3590314129	JDBC	UPDATE bmsql_district SET ...
149540	29908	5.000	0.000	14.827	32.911	67.089	3960484044	JDBC	SELECT c_first, c_middle, c_la...
85240	27684	3.079	0.000	8.256	73.329	26.671	2141580327	JDBC	SELECT no_o_id FROM bmsql_...
85141	19544	4.356	0.000	35.673	14.773	85.227	0447837152	JDBC	SELECT c_id FROM bmsql_cus...
82830	27610	3.000	0.000	4.354	81.950	18.050	0844168030	JDBC	SELECT o_c_id FROM bmsql_o...
59816	29908	2.000	0.000	2.244	95.626	4.374	2815201306	JDBC	SELECT w_name, w_street_1, w_s...
59816	29908	2.000	0.000	14.144	94.141	5.859	3660588145	JDBC	SELECT d_name, d_street_1, d_s...
32846	2735	12.010	0.000	15.120	10.865	89.135	3638166556	JDBC	SELECT ol_i_id, ol_supply_w_id...
22455	29919	0.751	0.000	63.497	93.968	6.032	1781442178	JDBC	select bmsql_hist_id_seq.nextv...
20891	45	464.244	0.000	10.818	59.958	40.042	3583228784	JDBC	BEGIN WSR$CREATE_SESSION_SNAPS...
18862	3077	6.130	0.000	0.331	80.825	19.175	3747064878	JDBC	UPDATE bmsql_customer SET ...
12595	1	12595.000	0.000	0.100	81.530	18.470	0453948317	JDBC	BEGIN WSR$CREATE_SNAPSHOT(); E...
9725	112	86.830	0.000	0.219	82.134	17.866	3964610326	UNKNOWN	select COUNT(*) from SYS.WSR...
9231	3077	3.000	0.000	1.174	91.690	8.310	2694261527	JDBC	SELECT c_data FROM bmsql_c...
8205	2735	3.000	0.000	3.356	66.900	33.100	4291921220	JDBC	SELECT c_first, c_middle, c_la...
5343	45	118.733	0.000	0.704	75.998	24.002	2735749187	UNKNOWN	insert INTO WSR_LOCK_OBJECT (...
5218	1	5218.000	0.000	0.040	71.315	28.685	1911224605	UNKNOWN	insert INTO WSR_SEGMENT (SNAP...
4176	1	4176.000	0.000	0.017	86.955	13.045	2871286689	UNKNOWN	insert INTO WSR_DBA_SEGMENTS ...
2878	45	63.956	0.000	2.912	34.201	65.799	2988770469	UNKNOWN	select SUM(TXN_PAGES),SUM(UNDO...
2786	1	2786.000	0.000	0.046	89.925	10.075	1136136383	JDBC	declare n integer; i integer; ...
2771	1	2771.000	0.000	0.039	99.941	0.059	1218455557	JDBC	select max(hist_id) from bmsql...
1501	1	1501.000	0.000	0.005	53.101	46.899	4036846721	UNKNOWN	insert INTO WSR_PARAMETER (SN...
1449	147	9.857	0.000	1.976	66.022	33.978	0662783873	UNKNOWN	insert INTO SYS.WSR_SESSION_SQ...
518	1	518.000	0.000	0.005	56.156	43.844	0813566551	UNKNOWN	insert INTO WSR_SYS_STAT (SNA...
433	45	9.622	0.000	1.711	94.767	5.233	1377057357	UNKNOWN	insert INTO WSR_INSTANCE_SNAP ...
413	45	9.178	0.000	1.413	81.271	18.729	2354809456	UNKNOWN	insert INTO WSR_TRANSACTION (...
379	100	3.790	0.000	0.236	89.820	10.180	0910329455	JDBC	INSERT INTO bmsql_district ( ...
257	77	3.338	0.000	0.007	95.627	4.373	3038683717	UNKNOWN	insert INTO WSR_SQLAREA (SNAP...
194	1	194.000	0.000	0.001	20.737	79.263	3358378755	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
181	1	181.000	0.000	0.020	97.525	2.475	4266041370	UNKNOWN	insert INTO WSR_SESSION_EVENTS...
154	77	2.000	0.000	0.001	100.000	0.000	2167779333	UNKNOWN	select COUNT(*) from WSR_SQL...
136	1	136.000	0.000	0.002	24.567	75.433	3425372336	UNKNOWN	insert INTO WSR_SYSTEM (SNAP_...
115	17	6.765	0.000	0.115	18.123	81.877	1100688548	UNKNOWN	insert INTO SYS.WSR_SQLTEXT (...
113	10	11.300	0.000	0.123	77.528	22.472	1645643541	JDBC	INSERT INTO bmsql_warehouse ( ...
88	1	88.000	0.000	0.000	98.347	1.653	3923215066	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
67	4	16.750	0.000	0.047	99.016	0.984	0092634197	JDBC	INSERT INTO bmsql_config ( cf...
46	45	1.022	0.000	1.308	19.645	80.355	2906654698	UNKNOWN	select COUNT(*) from WSR_CON...
38	1	38.000	0.000	0.000	100.000	0.000	2358353897	UNKNOWN	insert INTO WSR_LATCH (SNAP_I...
30	1	30.000	0.000	0.000	100.000	0.000	4081488768	UNKNOWN	insert INTO WSR_WAITSTAT (SNA...
15	1	15.000	0.000	0.002	93.575	6.425	4229588365	UNKNOWN	select SNAP_ID$.NEXTVAL from ...
8	1	8.000	0.000	0.001	100.000	0.000	3310877950	UNKNOWN	insert INTO WSR_SNAPSHOT (SNA...
8	1	8.000	0.000	0.000	100.000	0.000	3887671171	UNKNOWN	insert INTO WSR_LIBRARYCACHE ...
5	1	5.000	0.000	0.000	100.000	0.000	1815131950	UNKNOWN	update WSR_CONTROL set MOST_RE...
4	2	2.000	0.000	0.003	5.492	94.508	2742635046	JDBC	SELECT cfg_value FROM bmsql_co...
3	1	3.000	0.000	0.001	35.047	64.953	0642457297	ZSQL	SELECT LPAD(SNAP_ID, 15, ' '),...
0	45	0.000	0.000	0.027	100.000	0.000	2671632775	UNKNOWN	select COUNT(*),COUNT(DECODE(S...
0	45	0.000	0.000	0.018	100.000	0.000	1198270733	UNKNOWN	select * from DV_SESSIONS WHER...
0	665	0.000	0.000	0.016	100.000	0.000	1817342111	JDBC	SELECT 1...
0	45	0.000	0.000	0.006	100.000	0.000	1854133114	UNKNOWN	select SUM(DECODE(TABLESPACE_N...
0	1	0.000	0.000	0.002	100.000	0.000	2008876062	ZSQL	SELECT DBTIMEZONE FROM SYS.DV_...
0	1	0.000	0.000	0.000	100.000	0.000	0049052732	UNKNOWN	select INSTANCE_ID from DV_I...
0	1	0.000	0.000	0.000	100.000	0.000	3346861191	UNKNOWN	select SQL_ID, MIN(SQL_TEXT) S...
0	1	0.000	0.000	0.000	100.000	0.000	0098598691	UNKNOWN	select DBID from DV_DATABASE...
0	1	0.000	0.000	0.000	100.000	0.000	0803557546	UNKNOWN	select :1 , TO_DATE(CTIME,'YYY...

SQL ordered by Reads

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
434179	2866	151.493	16.000	23.938	72.244	27.756	0368405445	JDBC	SELECT count(*) AS low_stock F...
393656	309606	1.271	14.000	54.158	64.742	35.258	2690334720	JDBC	SELECT i_price, i_name, i_data...
354510	309318	1.146	13.000	107.357	34.366	65.473	0617601049	JDBC	SELECT s_quantity, s_data, ...
227649	2735	83.235	8.000	18.155	45.325	54.675	2280059544	JDBC	SELECT o_id, o_entry_d, o_carr...
199256	309318	0.644	7.000	26.561	73.752	26.248	4128069989	JDBC	INSERT INTO bmsql_order_line (...
190639	309318	0.616	7.000	15.431	81.460	18.540	1775218545	JDBC	UPDATE bmsql_stock SET s_q...
61215	19544	3.132	2.000	35.673	14.773	85.227	0447837152	JDBC	SELECT c_id FROM bmsql_cus...
56839	30966	1.836	2.000	39.518	49.965	50.035	0729190854	JDBC	SELECT c_discount, c_last, c_c...
48931	27610	1.772	2.000	27.138	25.190	74.810	2305559646	JDBC	UPDATE bmsql_customer SET ...
48540	29908	1.623	2.000	14.827	32.911	67.089	3960484044	JDBC	SELECT c_first, c_middle, c_la...
40136	30966	1.296	1.000	12.145	58.928	41.072	4151099238	JDBC	INSERT INTO bmsql_oorder ( ...
39981	27610	1.448	1.000	17.038	42.290	57.710	0209361974	JDBC	UPDATE bmsql_oorder SET o_...
31973	27610	1.158	1.000	24.689	32.841	67.159	2923084465	JDBC	UPDATE bmsql_order_line SE...
31373	30966	1.013	1.000	213.617	36.243	59.851	1326412389	JDBC	SELECT d_tax, d_next_o_id ...
30365	29908	1.015	1.000	200.385	36.309	60.267	0289374106	JDBC	UPDATE bmsql_district SET ...
25431	29908	0.850	1.000	72.754	93.012	6.988	1619891791	JDBC	INSERT INTO bmsql_history ( ...
18163	26831	0.677	1.000	7.007	85.720	14.280	0615692581	JDBC	UPDATE bmsql_customer SET ...
14941	27610	0.541	1.000	4.354	81.950	18.050	0844168030	JDBC	SELECT o_c_id FROM bmsql_o...
14534	27610	0.526	1.000	5.239	86.036	13.964	2314291513	JDBC	SELECT sum(ol_amount) AS sum_o...
10551	27684	0.381	0.000	8.256	73.329	26.671	2141580327	JDBC	SELECT no_o_id FROM bmsql_...
7205	2996567	0.002	0.000	441.130	85.341	14.659	4071217845	JDBC	INSERT INTO bmsql_order_line (...
7187	45	159.711	0.000	10.818	59.958	40.042	3583228784	JDBC	BEGIN WSR$CREATE_SESSION_SNAPS...
7144	30966	0.231	0.000	5.081	74.084	25.916	1316762144	JDBC	INSERT INTO bmsql_new_order ( ...
6958	27684	0.251	0.000	26.936	36.172	54.001	0567372848	JDBC	DELETE FROM bmsql_new_order ...
6031	2735	2.205	0.000	15.120	10.865	89.135	3638166556	JDBC	SELECT ol_i_id, ol_supply_w_id...
5914	1000000	0.006	0.000	324.480	87.900	12.100	0405006318	JDBC	INSERT INTO bmsql_stock ( s_i...
4869	112	43.473	0.000	0.219	82.134	17.866	3964610326	UNKNOWN	select COUNT(*) from SYS.WSR...
4300	2735	1.572	0.000	3.356	66.900	33.100	4291921220	JDBC	SELECT c_first, c_middle, c_la...
2728	29908	0.091	0.000	14.124	32.404	5.111	1661892907	JDBC	UPDATE bmsql_warehouse SET...
2367	29919	0.079	0.000	63.497	93.968	6.032	1781442178	JDBC	select bmsql_hist_id_seq.nextv...
2084	3077	0.677	0.000	1.174	91.690	8.310	2694261527	JDBC	SELECT c_data FROM bmsql_c...
1857	30966	0.060	0.000	5.492	93.771	6.229	3590314129	JDBC	UPDATE bmsql_district SET ...
1738	29908	0.058	0.000	14.144	94.141	5.859	3660588145	JDBC	SELECT d_name, d_street_1, d_s...
1588	45	35.289	0.000	2.912	34.201	65.799	2988770469	UNKNOWN	select SUM(TXN_PAGES),SUM(UNDO...
1426	3077	0.463	0.000	0.331	80.825	19.175	3747064878	JDBC	UPDATE bmsql_customer SET ...
1261	29908	0.042	0.000	2.244	95.626	4.374	2815201306	JDBC	SELECT w_name, w_street_1, w_s...
973	300000	0.003	0.000	179.781	94.943	5.057	0203728423	JDBC	INSERT INTO bmsql_customer ( ...
878	300000	0.003	0.000	32.389	80.501	19.499	4146315128	JDBC	INSERT INTO bmsql_history ( h...
874	300000	0.003	0.000	35.233	75.890	24.110	0495268548	JDBC	INSERT INTO bmsql_oorder ( o_...
562	100000	0.006	0.000	6.081	11.309	88.691	3656167539	JDBC	INSERT INTO bmsql_item ( i_id...
260	147	1.769	0.000	1.976	66.022	33.978	0662783873	UNKNOWN	insert INTO SYS.WSR_SESSION_SQ...
215	45	4.778	0.000	0.704	75.998	24.002	2735749187	UNKNOWN	insert INTO WSR_LOCK_OBJECT (...
206	90000	0.002	0.000	6.584	68.107	31.893	0019533674	JDBC	INSERT INTO bmsql_new_order ( ...
178	1	178.000	0.000	0.005	56.156	43.844	0813566551	UNKNOWN	insert INTO WSR_SYS_STAT (SNA...
142	45	3.156	0.000	1.711	94.767	5.233	1377057357	UNKNOWN	insert INTO WSR_INSTANCE_SNAP ...
61	45	1.356	0.000	1.413	81.271	18.729	2354809456	UNKNOWN	insert INTO WSR_TRANSACTION (...
44	1	44.000	0.000	0.100	81.530	18.470	0453948317	JDBC	BEGIN WSR$CREATE_SNAPSHOT(); E...
34	100	0.340	0.000	0.236	89.820	10.180	0910329455	JDBC	INSERT INTO bmsql_district ( ...
23	17	1.353	0.000	0.115	18.123	81.877	1100688548	UNKNOWN	insert INTO SYS.WSR_SQLTEXT (...
22	45	0.489	0.000	1.308	19.645	80.355	2906654698	UNKNOWN	select COUNT(*) from WSR_CON...
21	1	21.000	0.000	0.040	71.315	28.685	1911224605	UNKNOWN	insert INTO WSR_SEGMENT (SNAP...
11	10	1.100	0.000	0.123	77.528	22.472	1645643541	JDBC	INSERT INTO bmsql_warehouse ( ...
9	1	9.000	0.000	0.001	20.737	79.263	3358378755	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
7	1	7.000	0.000	0.002	24.567	75.433	3425372336	UNKNOWN	insert INTO WSR_SYSTEM (SNAP_...
6	1	6.000	0.000	0.017	86.955	13.045	2871286689	UNKNOWN	insert INTO WSR_DBA_SEGMENTS ...
6	1	6.000	0.000	0.005	53.101	46.899	4036846721	UNKNOWN	insert INTO WSR_PARAMETER (SN...
4	1	4.000	0.000	0.020	97.525	2.475	4266041370	UNKNOWN	insert INTO WSR_SESSION_EVENTS...
4	2	2.000	0.000	0.003	5.492	94.508	2742635046	JDBC	SELECT cfg_value FROM bmsql_co...
3	4	0.750	0.000	0.047	99.016	0.984	0092634197	JDBC	INSERT INTO bmsql_config ( cf...
3	1	3.000	0.000	0.046	89.925	10.075	1136136383	JDBC	declare n integer; i integer; ...
3	77	0.039	0.000	0.007	95.627	4.373	3038683717	UNKNOWN	insert INTO WSR_SQLAREA (SNAP...
2	1	2.000	0.000	0.002	93.575	6.425	4229588365	UNKNOWN	select SNAP_ID$.NEXTVAL from ...
2	1	2.000	0.000	0.000	98.347	1.653	3923215066	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
1	1	1.000	0.000	0.039	99.941	0.059	1218455557	JDBC	select max(hist_id) from bmsql...
1	1	1.000	0.000	0.001	35.047	64.953	0642457297	ZSQL	SELECT LPAD(SNAP_ID, 15, ' '),...
0	45	0.000	0.000	0.027	100.000	0.000	2671632775	UNKNOWN	select COUNT(*),COUNT(DECODE(S...
0	45	0.000	0.000	0.018	100.000	0.000	1198270733	UNKNOWN	select * from DV_SESSIONS WHER...
0	665	0.000	0.000	0.016	100.000	0.000	1817342111	JDBC	SELECT 1...
0	45	0.000	0.000	0.006	100.000	0.000	1854133114	UNKNOWN	select SUM(DECODE(TABLESPACE_N...
0	1	0.000	0.000	0.002	100.000	0.000	2008876062	ZSQL	SELECT DBTIMEZONE FROM SYS.DV_...
0	1	0.000	0.000	0.001	100.000	0.000	3310877950	UNKNOWN	insert INTO WSR_SNAPSHOT (SNA...
0	77	0.000	0.000	0.001	100.000	0.000	2167779333	UNKNOWN	select COUNT(*) from WSR_SQL...
0	1	0.000	0.000	0.000	100.000	0.000	3887671171	UNKNOWN	insert INTO WSR_LIBRARYCACHE ...
0	1	0.000	0.000	0.000	100.000	0.000	0049052732	UNKNOWN	select INSTANCE_ID from DV_I...
0	1	0.000	0.000	0.000	100.000	0.000	4081488768	UNKNOWN	insert INTO WSR_WAITSTAT (SNA...
0	1	0.000	0.000	0.000	100.000	0.000	3346861191	UNKNOWN	select SQL_ID, MIN(SQL_TEXT) S...
0	1	0.000	0.000	0.000	100.000	0.000	1815131950	UNKNOWN	update WSR_CONTROL set MOST_RE...
0	1	0.000	0.000	0.000	100.000	0.000	0098598691	UNKNOWN	select DBID from DV_DATABASE...
0	1	0.000	0.000	0.000	100.000	0.000	0803557546	UNKNOWN	select :1 , TO_DATE(CTIME,'YYY...
0	1	0.000	0.000	0.000	100.000	0.000	2358353897	UNKNOWN	insert INTO WSR_LATCH (SNAP_I...

SQL ordered by Executions

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2996567	2996567	1.000	441.130	85.341	14.659	4071217845	JDBC	INSERT INTO bmsql_order_line (...
1000000	1000000	1.000	324.480	87.900	12.100	0405006318	JDBC	INSERT INTO bmsql_stock ( s_i...
309606	309318	0.999	54.158	64.742	35.258	2690334720	JDBC	SELECT i_price, i_name, i_data...
309318	309318	1.000	26.561	73.752	26.248	4128069989	JDBC	INSERT INTO bmsql_order_line (...
309318	309318	1.000	15.431	81.460	18.540	1775218545	JDBC	UPDATE bmsql_stock SET s_q...
309318	309318	1.000	107.357	34.366	65.473	0617601049	JDBC	SELECT s_quantity, s_data, ...
300000	300000	1.000	35.233	75.890	24.110	0495268548	JDBC	INSERT INTO bmsql_oorder ( o_...
300000	300000	1.000	32.389	80.501	19.499	4146315128	JDBC	INSERT INTO bmsql_history ( h...
300000	300000	1.000	179.781	94.943	5.057	0203728423	JDBC	INSERT INTO bmsql_customer ( ...
100000	100000	1.000	6.081	11.309	88.691	3656167539	JDBC	INSERT INTO bmsql_item ( i_id...
90000	90000	1.000	6.584	68.107	31.893	0019533674	JDBC	INSERT INTO bmsql_new_order ( ...
30966	30966	1.000	5.492	93.771	6.229	3590314129	JDBC	UPDATE bmsql_district SET ...
30966	30966	1.000	5.081	74.084	25.916	1316762144	JDBC	INSERT INTO bmsql_new_order ( ...
30966	30966	1.000	39.518	49.965	50.035	0729190854	JDBC	SELECT c_discount, c_last, c_c...
30966	30966	1.000	213.617	36.243	59.851	1326412389	JDBC	SELECT d_tax, d_next_o_id ...
30966	30966	1.000	12.145	58.928	41.072	4151099238	JDBC	INSERT INTO bmsql_oorder ( ...
29919	29919	1.000	63.497	93.968	6.032	1781442178	JDBC	select bmsql_hist_id_seq.nextv...
29908	59816	2.000	72.754	93.012	6.988	1619891791	JDBC	INSERT INTO bmsql_history ( ...
29908	29908	1.000	200.385	36.309	60.267	0289374106	JDBC	UPDATE bmsql_district SET ...
29908	29908	1.000	2.244	95.626	4.374	2815201306	JDBC	SELECT w_name, w_street_1, w_s...
29908	29908	1.000	14.827	32.911	67.089	3960484044	JDBC	SELECT c_first, c_middle, c_la...
29908	29908	1.000	14.144	94.141	5.859	3660588145	JDBC	SELECT d_name, d_street_1, d_s...
29908	29908	1.000	14.124	32.404	5.111	1661892907	JDBC	UPDATE bmsql_warehouse SET...
27684	2768400	100.000	8.256	73.329	26.671	2141580327	JDBC	SELECT no_o_id FROM bmsql_...
27684	27610	0.997	26.936	36.172	54.001	0567372848	JDBC	DELETE FROM bmsql_new_order ...
27610	27610	1.000	5.239	86.036	13.964	2314291513	JDBC	SELECT sum(ol_amount) AS sum_o...
27610	27610	1.000	4.354	81.950	18.050	0844168030	JDBC	SELECT o_c_id FROM bmsql_o...
27610	27610	1.000	27.138	25.190	74.810	2305559646	JDBC	UPDATE bmsql_customer SET ...
27610	275551	9.980	24.689	32.841	67.159	2923084465	JDBC	UPDATE bmsql_order_line SE...
27610	27610	1.000	17.038	42.290	57.710	0209361974	JDBC	UPDATE bmsql_oorder SET o_...
26831	26831	1.000	7.007	85.720	14.280	0615692581	JDBC	UPDATE bmsql_customer SET ...
19544	45551	2.331	35.673	14.773	85.227	0447837152	JDBC	SELECT c_id FROM bmsql_cus...
3077	3077	1.000	1.174	91.690	8.310	2694261527	JDBC	SELECT c_data FROM bmsql_c...
3077	3077	1.000	0.331	80.825	19.175	3747064878	JDBC	UPDATE bmsql_customer SET ...
2866	2866	1.000	23.938	72.244	27.756	0368405445	JDBC	SELECT count(*) AS low_stock F...
2735	2735	1.000	3.356	66.900	33.100	4291921220	JDBC	SELECT c_first, c_middle, c_la...
2735	2735	1.000	18.155	45.325	54.675	2280059544	JDBC	SELECT o_id, o_entry_d, o_carr...
2735	27224	9.954	15.120	10.865	89.135	3638166556	JDBC	SELECT ol_i_id, ol_supply_w_id...
665	665	1.000	0.016	100.000	0.000	1817342111	JDBC	SELECT 1...
147	147	1.000	1.976	66.022	33.978	0662783873	UNKNOWN	insert INTO SYS.WSR_SESSION_SQ...
112	112	1.000	0.219	82.134	17.866	3964610326	UNKNOWN	select COUNT(*) from SYS.WSR...
100	100	1.000	0.236	89.820	10.180	0910329455	JDBC	INSERT INTO bmsql_district ( ...
77	77	1.000	0.007	95.627	4.373	3038683717	UNKNOWN	insert INTO WSR_SQLAREA (SNAP...
77	77	1.000	0.001	100.000	0.000	2167779333	UNKNOWN	select COUNT(*) from WSR_SQL...
45	45	1.000	2.912	34.201	65.799	2988770469	UNKNOWN	select SUM(TXN_PAGES),SUM(UNDO...
45	1532	34.044	10.818	59.958	40.042	3583228784	JDBC	BEGIN WSR$CREATE_SESSION_SNAPS...
45	45	1.000	1.711	94.767	5.233	1377057357	UNKNOWN	insert INTO WSR_INSTANCE_SNAP ...
45	169	3.756	1.413	81.271	18.729	2354809456	UNKNOWN	insert INTO WSR_TRANSACTION (...
45	45	1.000	1.308	19.645	80.355	2906654698	UNKNOWN	select COUNT(*) from WSR_CON...
45	817	18.156	0.704	75.998	24.002	2735749187	UNKNOWN	insert INTO WSR_LOCK_OBJECT (...
45	45	1.000	0.027	100.000	0.000	2671632775	UNKNOWN	select COUNT(*),COUNT(DECODE(S...
45	45	1.000	0.018	100.000	0.000	1198270733	UNKNOWN	select * from DV_SESSIONS WHER...
45	45	1.000	0.006	100.000	0.000	1854133114	UNKNOWN	select SUM(DECODE(TABLESPACE_N...
17	17	1.000	0.115	18.123	81.877	1100688548	UNKNOWN	insert INTO SYS.WSR_SQLTEXT (...
10	10	1.000	0.123	77.528	22.472	1645643541	JDBC	INSERT INTO bmsql_warehouse ( ...
4	4	1.000	0.047	99.016	0.984	0092634197	JDBC	INSERT INTO bmsql_config ( cf...
2	2	1.000	0.003	5.492	94.508	2742635046	JDBC	SELECT cfg_value FROM bmsql_co...
1	2010	2010.000	0.100	81.530	18.470	0453948317	JDBC	BEGIN WSR$CREATE_SNAPSHOT(); E...
1	12	12.000	0.046	89.925	10.075	1136136383	JDBC	declare n integer; i integer; ...
1	1010	1010.000	0.040	71.315	28.685	1911224605	UNKNOWN	insert INTO WSR_SEGMENT (SNAP...
1	1	1.000	0.039	99.941	0.059	1218455557	JDBC	select max(hist_id) from bmsql...
1	14	14.000	0.020	97.525	2.475	4266041370	UNKNOWN	insert INTO WSR_SESSION_EVENTS...
1	454	454.000	0.017	86.955	13.045	2871286689	UNKNOWN	insert INTO WSR_DBA_SEGMENTS ...
1	81	81.000	0.005	56.156	43.844	0813566551	UNKNOWN	insert INTO WSR_SYS_STAT (SNA...
1	233	233.000	0.005	53.101	46.899	4036846721	UNKNOWN	insert INTO WSR_PARAMETER (SN...
1	1	1.000	0.002	100.000	0.000	2008876062	ZSQL	SELECT DBTIMEZONE FROM SYS.DV_...
1	19	19.000	0.002	24.567	75.433	3425372336	UNKNOWN	insert INTO WSR_SYSTEM (SNAP_...
1	1	1.000	0.002	93.575	6.425	4229588365	UNKNOWN	select SNAP_ID$.NEXTVAL from ...
1	1	1.000	0.001	100.000	0.000	3310877950	UNKNOWN	insert INTO WSR_SNAPSHOT (SNA...
1	27	27.000	0.001	20.737	79.263	3358378755	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
1	20	20.000	0.001	35.047	64.953	0642457297	ZSQL	SELECT LPAD(SNAP_ID, 15, ' '),...
1	1	1.000	0.000	100.000	0.000	3887671171	UNKNOWN	insert INTO WSR_LIBRARYCACHE ...
1	1	1.000	0.000	100.000	0.000	0049052732	UNKNOWN	select INSTANCE_ID from DV_I...
1	1	1.000	0.000	98.347	1.653	3923215066	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
1	5	5.000	0.000	100.000	0.000	4081488768	UNKNOWN	insert INTO WSR_WAITSTAT (SNA...
1	1	1.000	0.000	100.000	0.000	3346861191	UNKNOWN	select SQL_ID, MIN(SQL_TEXT) S...
1	1	1.000	0.000	100.000	0.000	1815131950	UNKNOWN	update WSR_CONTROL set MOST_RE...
1	1	1.000	0.000	100.000	0.000	0098598691	UNKNOWN	select DBID from DV_DATABASE...
1	0	0.000	0.000	100.000	0.000	0803557546	UNKNOWN	select :1 , TO_DATE(CTIME,'YYY...
1	5	5.000	0.000	100.000	0.000	2358353897	UNKNOWN	insert INTO WSR_LATCH (SNAP_I...

SQL ordered by Parse Calls

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
665	665	58.000	1817342111	JDBC	SELECT 1...
45	45	4.000	3583228784	JDBC	BEGIN WSR$CREATE_SESSION_SNAPS...
19	19544	2.000	0447837152	JDBC	SELECT c_id FROM bmsql_cus...
9	2996567	1.000	4071217845	JDBC	INSERT INTO bmsql_order_line (...
9	1000000	1.000	0405006318	JDBC	INSERT INTO bmsql_stock ( s_i...
9	309606	1.000	2690334720	JDBC	SELECT i_price, i_name, i_data...
9	309318	1.000	4128069989	JDBC	INSERT INTO bmsql_order_line (...
9	309318	1.000	1775218545	JDBC	UPDATE bmsql_stock SET s_q...
9	309318	1.000	0617601049	JDBC	SELECT s_quantity, s_data, ...
9	300000	1.000	4146315128	JDBC	INSERT INTO bmsql_history ( h...
9	300000	1.000	0495268548	JDBC	INSERT INTO bmsql_oorder ( o_...
9	300000	1.000	0203728423	JDBC	INSERT INTO bmsql_customer ( ...
9	90000	1.000	0019533674	JDBC	INSERT INTO bmsql_new_order ( ...
9	30966	1.000	1316762144	JDBC	INSERT INTO bmsql_new_order ( ...
9	30966	1.000	4151099238	JDBC	INSERT INTO bmsql_oorder ( ...
9	30966	1.000	0729190854	JDBC	SELECT c_discount, c_last, c_c...
9	30966	1.000	1326412389	JDBC	SELECT d_tax, d_next_o_id ...
9	30966	1.000	3590314129	JDBC	UPDATE bmsql_district SET ...
9	29908	1.000	3660588145	JDBC	SELECT d_name, d_street_1, d_s...
9	29908	1.000	0289374106	JDBC	UPDATE bmsql_district SET ...
9	29908	1.000	3960484044	JDBC	SELECT c_first, c_middle, c_la...
9	29908	1.000	2815201306	JDBC	SELECT w_name, w_street_1, w_s...
9	29908	1.000	1661892907	JDBC	UPDATE bmsql_warehouse SET...
9	29908	1.000	1619891791	JDBC	INSERT INTO bmsql_history ( ...
9	27684	1.000	0567372848	JDBC	DELETE FROM bmsql_new_order ...
9	27684	1.000	2141580327	JDBC	SELECT no_o_id FROM bmsql_...
9	27610	1.000	2314291513	JDBC	SELECT sum(ol_amount) AS sum_o...
9	27610	1.000	2923084465	JDBC	UPDATE bmsql_order_line SE...
9	27610	1.000	0844168030	JDBC	SELECT o_c_id FROM bmsql_o...
9	27610	1.000	0209361974	JDBC	UPDATE bmsql_oorder SET o_...
9	27610	1.000	2305559646	JDBC	UPDATE bmsql_customer SET ...
9	26831	1.000	0615692581	JDBC	UPDATE bmsql_customer SET ...
9	3077	1.000	3747064878	JDBC	UPDATE bmsql_customer SET ...
9	3077	1.000	2694261527	JDBC	SELECT c_data FROM bmsql_c...
9	2866	1.000	0368405445	JDBC	SELECT count(*) AS low_stock F...
9	2735	1.000	3638166556	JDBC	SELECT ol_i_id, ol_supply_w_id...
9	2735	1.000	2280059544	JDBC	SELECT o_id, o_entry_d, o_carr...
9	2735	1.000	4291921220	JDBC	SELECT c_first, c_middle, c_la...
9	100	1.000	0910329455	JDBC	INSERT INTO bmsql_district ( ...
9	10	1.000	1645643541	JDBC	INSERT INTO bmsql_warehouse ( ...
1	1	0.000	2008876062	ZSQL	SELECT DBTIMEZONE FROM SYS.DV_...
0	100000	0.000	3656167539	JDBC	INSERT INTO bmsql_item ( i_id...
0	29919	0.000	1781442178	JDBC	select bmsql_hist_id_seq.nextv...
0	147	0.000	0662783873	UNKNOWN	insert INTO SYS.WSR_SESSION_SQ...
0	112	0.000	3964610326	UNKNOWN	select COUNT(*) from SYS.WSR...
0	77	0.000	2167779333	UNKNOWN	select COUNT(*) from WSR_SQL...
0	77	0.000	3038683717	UNKNOWN	insert INTO WSR_SQLAREA (SNAP...
0	45	0.000	1377057357	UNKNOWN	insert INTO WSR_INSTANCE_SNAP ...
0	45	0.000	1854133114	UNKNOWN	select SUM(DECODE(TABLESPACE_N...
0	45	0.000	2735749187	UNKNOWN	insert INTO WSR_LOCK_OBJECT (...
0	45	0.000	2671632775	UNKNOWN	select COUNT(*),COUNT(DECODE(S...
0	45	0.000	1198270733	UNKNOWN	select * from DV_SESSIONS WHER...
0	45	0.000	2906654698	UNKNOWN	select COUNT(*) from WSR_CON...
0	45	0.000	2354809456	UNKNOWN	insert INTO WSR_TRANSACTION (...
0	45	0.000	2988770469	UNKNOWN	select SUM(TXN_PAGES),SUM(UNDO...
0	17	0.000	1100688548	UNKNOWN	insert INTO SYS.WSR_SQLTEXT (...
0	4	0.000	0092634197	JDBC	INSERT INTO bmsql_config ( cf...
0	2	0.000	2742635046	JDBC	SELECT cfg_value FROM bmsql_co...
0	1	0.000	1218455557	JDBC	select max(hist_id) from bmsql...
0	1	0.000	1136136383	JDBC	declare n integer; i integer; ...
0	1	0.000	3310877950	UNKNOWN	insert INTO WSR_SNAPSHOT (SNA...
0	1	0.000	3887671171	UNKNOWN	insert INTO WSR_LIBRARYCACHE ...
0	1	0.000	0049052732	UNKNOWN	select INSTANCE_ID from DV_I...
0	1	0.000	0642457297	ZSQL	SELECT LPAD(SNAP_ID, 15, ' '),...
0	1	0.000	3923215066	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
0	1	0.000	0813566551	UNKNOWN	insert INTO WSR_SYS_STAT (SNA...
0	1	0.000	4081488768	UNKNOWN	insert INTO WSR_WAITSTAT (SNA...
0	1	0.000	2871286689	UNKNOWN	insert INTO WSR_DBA_SEGMENTS ...
0	1	0.000	3346861191	UNKNOWN	select SQL_ID, MIN(SQL_TEXT) S...
0	1	0.000	0453948317	JDBC	BEGIN WSR$CREATE_SNAPSHOT(); E...
0	1	0.000	3358378755	UNKNOWN	insert INTO WSR_SYSTEM_EVENT ...
0	1	0.000	3425372336	UNKNOWN	insert INTO WSR_SYSTEM (SNAP_...
0	1	0.000	4036846721	UNKNOWN	insert INTO WSR_PARAMETER (SN...
0	1	0.000	1911224605	UNKNOWN	insert INTO WSR_SEGMENT (SNAP...
0	1	0.000	1815131950	UNKNOWN	update WSR_CONTROL set MOST_RE...
0	1	0.000	0098598691	UNKNOWN	select DBID from DV_DATABASE...
0	1	0.000	4229588365	UNKNOWN	select SNAP_ID$.NEXTVAL from ...
0	1	0.000	0803557546	UNKNOWN	select :1 , TO_DATE(CTIME,'YYY...
0	1	0.000	4266041370	UNKNOWN	insert INTO WSR_SESSION_EVENTS...
0	1	0.000	2358353897	UNKNOWN	insert INTO WSR_LATCH (SNAP_I...

SQL ordered by first 6 letters

SQL prefix	Elapsed Time (s)	CPU Time (s)	IO Wait Time(s)	Executions	Buffer Gets	Physical Reads	%Total
INSERT	1142.622	988.889	153.734	5487839	16962248	288627	31.434
SELECT	561.152	239.369	313.266	887845	10002845	1663406	15.437
UPDATE	311.634	123.478	172.470	512838	4931234	366063	8.573
select	68.029	61.193	6.836	30339	38044	8849	1.871
DELETE	26.936	9.743	14.545	27684	351316	6958	0.741
BEGIN	10.918	6.568	4.350	46	33486	7231	0.300
insert	6.017	4.707	1.310	388	20106	937	0.166
declar	0.046	0.042	0.005	1	2786	3	0.001
update	0.000	0.000	0.000	1	5	0	0.000

SQL ordered by first 10 letters

SQL prefix	Elapsed Time (s)	CPU Time (s)	IO Wait Time(s)	Executions	Buffer Gets	Physical Reads	%Total
INSERT INT	1142.622	988.889	153.734	5487839	16962248	288627	31.434
UPDATE bms	311.634	123.478	172.470	512838	4931234	366063	8.573
SELECT d_t	213.617	77.421	127.853	30966	466705	31373	5.877
SELECT s_q	107.357	36.894	70.290	309318	1545276	354510	2.953
select bms	63.497	59.666	3.830	29919	22455	2367	1.747
SELECT i_p	54.158	35.063	19.095	309606	618924	393656	1.490
SELECT c_d	40.691	20.821	19.870	34043	169565	58923	1.119
SELECT c_i	35.673	5.270	30.403	19544	85141	61215	0.981
DELETE FRO	26.936	9.743	14.545	27684	351316	6958	0.741
SELECT cou	23.938	17.294	6.644	2866	2275752	434179	0.659
SELECT c_f	18.183	7.125	11.058	32643	157745	52840	0.500
SELECT o_i	18.155	8.229	9.926	2735	4028174	227649	0.499
SELECT ol_	15.120	1.643	13.477	2735	32846	6031	0.416
SELECT d_n	14.144	13.315	0.829	29908	59816	1738	0.389
BEGIN WSR$	10.918	6.568	4.350	46	33486	7231	0.300
SELECT no_	8.256	6.054	2.202	27684	85240	10551	0.227
insert INT	6.017	4.707	1.310	388	20106	937	0.166
SELECT sum	5.239	4.507	0.732	27610	335008	14534	0.144
SELECT o_c	4.354	3.568	0.786	27610	82830	14941	0.120
select SUM	2.917	1.002	1.916	90	2878	1588	0.080
SELECT w_n	2.244	2.146	0.098	29908	59816	1261	0.062
select COU	1.555	0.465	1.090	279	9925	4891	0.043
declare n	0.046	0.042	0.005	1	2786	3	0.001
select max	0.039	0.039	0.000	1	2771	1	0.001
select * f	0.018	0.018	0.000	45	0	0	0.001
SELECT 1	0.016	0.016	0.000	665	0	0	0.000
SELECT cfg	0.003	0.000	0.003	2	4	4	0.000
select SNA	0.002	0.002	0.000	1	15	2	0.000
SELECT DBT	0.002	0.002	0.000	1	0	0	0.000
SELECT LPA	0.001	0.000	0.000	1	3	1	0.000
select SQL	0.000	0.000	0.000	1	0	0	0.000
select INS	0.000	0.000	0.000	1	0	0	0.000
select :1	0.000	0.000	0.000	1	0	0	0.000
update WSR	0.000	0.000	0.000	1	5	0	0.000
select DBI	0.000	0.000	0.000	1	0	0	0.000

SQL ordered by first 15 letters

SQL prefix	Elapsed Time (s)	CPU Time (s)	IO Wait Time(s)	Executions	Buffer Gets	Physical Reads	%Total
INSERT INTO bms	1142.622	988.889	153.734	5487839	16962248	288627	31.434
SELECT d_tax, d	213.617	77.421	127.853	30966	466705	31373	5.877
UPDATE bmsql_di	205.877	77.909	121.108	60874	565349	32222	5.664
SELECT s_quanti	107.357	36.894	70.290	309318	1545276	354510	2.953
select bmsql_hi	63.497	59.666	3.830	29919	22455	2367	1.747
SELECT i_price,	54.158	35.063	19.095	309606	618924	393656	1.490
SELECT c_discou	39.518	19.745	19.772	30966	160334	56839	1.087
SELECT c_id	35.673	5.270	30.403	19544	85141	61215	0.981
UPDATE bmsql_cu	34.475	13.110	21.366	57518	374671	68520	0.948
DELETE FROM bms	26.936	9.743	14.545	27684	351316	6958	0.741
UPDATE bmsql_or	24.689	8.108	16.581	27610	1217952	31973	0.679
SELECT count(*)	23.938	17.294	6.644	2866	2275752	434179	0.659
SELECT c_first,	18.183	7.125	11.058	32643	157745	52840	0.500
SELECT o_id, o_	18.155	8.229	9.926	2735	4028174	227649	0.499
UPDATE bmsql_oo	17.038	7.205	9.832	27610	476428	39981	0.469
UPDATE bmsql_st	15.431	12.570	2.861	309318	1856563	190639	0.425
SELECT ol_i_id,	15.120	1.643	13.477	2735	32846	6031	0.416
SELECT d_name,	14.144	13.315	0.829	29908	59816	1738	0.389
UPDATE bmsql_wa	14.124	4.577	0.722	29908	440271	2728	0.389
BEGIN WSR$CREAT	10.918	6.568	4.350	46	33486	7231	0.300
SELECT no_o_id	8.256	6.054	2.202	27684	85240	10551	0.227
SELECT sum(ol_a	5.239	4.507	0.732	27610	335008	14534	0.144
SELECT o_c_id	4.354	3.568	0.786	27610	82830	14941	0.120
insert INTO WSR	3.926	3.381	0.544	224	18542	654	0.108
select SUM(TXN_	2.912	0.996	1.916	45	2878	1588	0.080
SELECT w_name,	2.244	2.146	0.098	29908	59816	1261	0.062
insert INTO SYS	2.091	1.325	0.765	164	1564	283	0.058
select COUNT(*)	1.555	0.465	1.090	279	9925	4891	0.043
SELECT c_data	1.174	1.076	0.098	3077	9231	2084	0.032
declare n integ	0.046	0.042	0.005	1	2786	3	0.001
select max(hist	0.039	0.039	0.000	1	2771	1	0.001
select * from D	0.018	0.018	0.000	45	0	0	0.001
SELECT 1	0.016	0.016	0.000	665	0	0	0.000
select SUM(DECO	0.006	0.006	0.000	45	0	0	0.000
SELECT cfg_valu	0.003	0.000	0.003	2	4	4	0.000
select SNAP_ID$	0.002	0.002	0.000	1	15	2	0.000
SELECT DBTIMEZO	0.002	0.002	0.000	1	0	0	0.000
SELECT LPAD(SNA	0.001	0.000	0.000	1	3	1	0.000
select SQL_ID,	0.000	0.000	0.000	1	0	0	0.000
select INSTANCE	0.000	0.000	0.000	1	0	0	0.000
select :1 , TO_	0.000	0.000	0.000	1	0	0	0.000
update WSR_CONT	0.000	0.000	0.000	1	5	0	0.000
select DBID fr	0.000	0.000	0.000	1	0	0	0.000

SQL ordered by first 20 letters

SQL prefix	Elapsed Time (s)	CPU Time (s)	IO Wait Time(s)	Executions	Buffer Gets	Physical Reads	%Total
INSERT INTO bmsql_or	467.691	396.053	71.638	3305885	9942543	206461	12.866
INSERT INTO bmsql_st	324.480	285.219	39.261	1000000	2965278	5914	8.926
SELECT d_tax, d_next	213.617	77.421	127.853	30966	466705	31373	5.877
UPDATE bmsql_distric	205.877	77.909	121.108	60874	565349	32222	5.664
INSERT INTO bmsql_cu	179.781	170.690	9.091	300000	1049404	973	4.946
SELECT s_quantity, s	107.357	36.894	70.290	309318	1545276	354510	2.953
INSERT INTO bmsql_hi	105.143	93.743	11.399	329908	1105579	26309	2.892
select bmsql_hist_id	63.497	59.666	3.830	29919	22455	2367	1.747
SELECT i_price, i_na	54.158	35.063	19.095	309606	618924	393656	1.490
INSERT INTO bmsql_oo	47.378	33.895	13.483	330966	1126660	41010	1.303
SELECT c_discount, c	39.518	19.745	19.772	30966	160334	56839	1.087
SELECT c_id FROM	35.673	5.270	30.403	19544	85141	61215	0.981
UPDATE bmsql_custome	34.475	13.110	21.366	57518	374671	68520	0.948
DELETE FROM bmsql_ne	26.936	9.743	14.545	27684	351316	6958	0.741
UPDATE bmsql_order_l	24.689	8.108	16.581	27610	1217952	31973	0.679
SELECT count(*) AS l	23.938	17.294	6.644	2866	2275752	434179	0.659
SELECT c_first, c_mi	18.183	7.125	11.058	32643	157745	52840	0.500
SELECT o_id, o_entry	18.155	8.229	9.926	2735	4028174	227649	0.499
UPDATE bmsql_oorder	17.038	7.205	9.832	27610	476428	39981	0.469
UPDATE bmsql_stock	15.431	12.570	2.861	309318	1856563	190639	0.425
SELECT ol_i_id, ol_s	15.120	1.643	13.477	2735	32846	6031	0.416
SELECT d_name, d_str	14.144	13.315	0.829	29908	59816	1738	0.389
UPDATE bmsql_warehou	14.124	4.577	0.722	29908	440271	2728	0.389
INSERT INTO bmsql_ne	11.665	8.248	3.417	120966	550879	7350	0.321
BEGIN WSR$CREATE_SES	10.818	6.486	4.332	45	20891	7187	0.298
SELECT no_o_id F	8.256	6.054	2.202	27684	85240	10551	0.227
INSERT INTO bmsql_it	6.081	0.688	5.393	100000	221346	562	0.167
SELECT sum(ol_amount	5.239	4.507	0.732	27610	335008	14534	0.144
SELECT o_c_id FR	4.354	3.568	0.786	27610	82830	14941	0.120
select SUM(TXN_PAGES	2.912	0.996	1.916	45	2878	1588	0.080
SELECT w_name, w_str	2.244	2.146	0.098	29908	59816	1261	0.062
insert INTO SYS.WSR_	2.091	1.325	0.765	164	1564	283	0.058
insert INTO WSR_INST	1.711	1.622	0.090	45	433	142	0.047
select COUNT(*) fro	1.527	0.437	1.090	234	9925	4891	0.042
insert INTO WSR_TRAN	1.413	1.148	0.265	45	413	61	0.039
SELECT c_data FR	1.174	1.076	0.098	3077	9231	2084	0.032
insert INTO WSR_LOCK	0.704	0.535	0.169	45	5343	215	0.019
INSERT INTO bmsql_di	0.236	0.212	0.024	100	379	34	0.006
INSERT INTO bmsql_wa	0.123	0.095	0.028	10	113	11	0.003
BEGIN WSR$CREATE_SNA	0.100	0.082	0.018	1	12595	44	0.003
INSERT INTO bmsql_co	0.047	0.046	0.000	4	67	3	0.001
declare n integer; i	0.046	0.042	0.005	1	2786	3	0.001
insert INTO WSR_SEGM	0.040	0.028	0.011	1	5218	21	0.001
select max(hist_id)	0.039	0.039	0.000	1	2771	1	0.001
select COUNT(*),COUN	0.027	0.027	0.000	45	0	0	0.001
insert INTO WSR_SESS	0.020	0.020	0.001	1	181	4	0.001
select * from DV_SES	0.018	0.018	0.000	45	0	0	0.001
insert INTO WSR_DBA_	0.017	0.015	0.002	1	4176	6	0.000
SELECT 1	0.016	0.016	0.000	665	0	0	0.000
insert INTO WSR_SQLA	0.007	0.006	0.000	77	257	3	0.000
select SUM(DECODE(TA	0.006	0.006	0.000	45	0	0	0.000
insert INTO WSR_PARA	0.005	0.003	0.002	1	1501	6	0.000
insert INTO WSR_SYS_	0.005	0.003	0.002	1	518	178	0.000
insert INTO WSR_SYST	0.003	0.001	0.002	3	418	18	0.000
SELECT cfg_value FRO	0.003	0.000	0.003	2	4	4	0.000
select SNAP_ID$.NEXT	0.002	0.002	0.000	1	15	2	0.000
SELECT DBTIMEZONE FR	0.002	0.002	0.000	1	0	0	0.000
SELECT LPAD(SNAP_ID,	0.001	0.000	0.000	1	3	1	0.000
insert INTO WSR_SNAP	0.001	0.001	0.000	1	8	0	0.000
select SQL_ID, MIN(S	0.000	0.000	0.000	1	0	0	0.000
select INSTANCE_ID	0.000	0.000	0.000	1	0	0	0.000
insert INTO WSR_LATC	0.000	0.000	0.000	1	38	0	0.000
insert INTO WSR_WAIT	0.000	0.000	0.000	1	30	0	0.000
select :1 , TO_DATE(	0.000	0.000	0.000	1	0	0	0.000
update WSR_CONTROL s	0.000	0.000	0.000	1	5	0	0.000
insert INTO WSR_LIBR	0.000	0.000	0.000	1	8	0	0.000
select DBID from D	0.000	0.000	0.000	1	0	0	0.000

SQL ordered by first 30 letters

SQL prefix	Elapsed Time (s)	CPU Time (s)	IO Wait Time(s)	Executions	Buffer Gets	Physical Reads	%Total
INSERT INTO bmsql_order_line (	467.691	396.053	71.638	3305885	9942543	206461	12.866
INSERT INTO bmsql_stock ( s_i	324.480	285.219	39.261	1000000	2965278	5914	8.926
SELECT d_tax, d_next_o_id	213.617	77.421	127.853	30966	466705	31373	5.877
UPDATE bmsql_district SET	205.877	77.909	121.108	60874	565349	32222	5.664
INSERT INTO bmsql_customer (	179.781	170.690	9.091	300000	1049404	973	4.946
SELECT s_quantity, s_data,	107.357	36.894	70.290	309318	1545276	354510	2.953
INSERT INTO bmsql_history (	72.754	67.670	5.084	29908	451476	25431	2.001
select bmsql_hist_id_seq.nextv	63.497	59.666	3.830	29919	22455	2367	1.747
SELECT i_price, i_name, i_data	54.158	35.063	19.095	309606	618924	393656	1.490
SELECT c_discount, c_last, c_c	39.518	19.745	19.772	30966	160334	56839	1.087
SELECT c_id FROM bmsql_cus	35.673	5.270	30.403	19544	85141	61215	0.981
INSERT INTO bmsql_oorder ( o_	35.233	26.738	8.495	300000	638222	874	0.969
UPDATE bmsql_customer SET	34.475	13.110	21.366	57518	374671	68520	0.948
INSERT INTO bmsql_history ( h	32.389	26.073	6.315	300000	654103	878	0.891
DELETE FROM bmsql_new_order	26.936	9.743	14.545	27684	351316	6958	0.741
UPDATE bmsql_order_line SE	24.689	8.108	16.581	27610	1217952	31973	0.679
SELECT count(*) AS low_stock F	23.938	17.294	6.644	2866	2275752	434179	0.659
SELECT c_first, c_middle, c_la	18.183	7.125	11.058	32643	157745	52840	0.500
SELECT o_id, o_entry_d, o_carr	18.155	8.229	9.926	2735	4028174	227649	0.499
UPDATE bmsql_oorder SET o_	17.038	7.205	9.832	27610	476428	39981	0.469
UPDATE bmsql_stock SET s_q	15.431	12.570	2.861	309318	1856563	190639	0.425
SELECT ol_i_id, ol_supply_w_id	15.120	1.643	13.477	2735	32846	6031	0.416
SELECT d_name, d_street_1, d_s	14.144	13.315	0.829	29908	59816	1738	0.389
UPDATE bmsql_warehouse SET	14.124	4.577	0.722	29908	440271	2728	0.389
INSERT INTO bmsql_oorder (	12.145	7.157	4.988	30966	488438	40136	0.334
INSERT INTO bmsql_new_order (	11.665	8.248	3.417	120966	550879	7350	0.321
BEGIN WSR$CREATE_SESSION_SNAPS	10.818	6.486	4.332	45	20891	7187	0.298
SELECT no_o_id FROM bmsql_	8.256	6.054	2.202	27684	85240	10551	0.227
INSERT INTO bmsql_item ( i_id	6.081	0.688	5.393	100000	221346	562	0.167
SELECT sum(ol_amount) AS sum_o	5.239	4.507	0.732	27610	335008	14534	0.144
SELECT o_c_id FROM bmsql_o	4.354	3.568	0.786	27610	82830	14941	0.120
select SUM(TXN_PAGES),SUM(UNDO	2.912	0.996	1.916	45	2878	1588	0.080
SELECT w_name, w_street_1, w_s	2.244	2.146	0.098	29908	59816	1261	0.062
insert INTO SYS.WSR_SESSION_SQ	1.976	1.304	0.671	147	1449	260	0.054
insert INTO WSR_INSTANCE_SNAP	1.711	1.622	0.090	45	433	142	0.047
insert INTO WSR_TRANSACTION (	1.413	1.148	0.265	45	413	61	0.039
select COUNT(*) from WSR_CON	1.308	0.257	1.051	45	46	22	0.036
SELECT c_data FROM bmsql_c	1.174	1.076	0.098	3077	9231	2084	0.032
insert INTO WSR_LOCK_OBJECT (	0.704	0.535	0.169	45	5343	215	0.019
INSERT INTO bmsql_district (	0.236	0.212	0.024	100	379	34	0.006
select COUNT(*) from SYS.WSR	0.219	0.180	0.039	112	9725	4869	0.006
INSERT INTO bmsql_warehouse (	0.123	0.095	0.028	10	113	11	0.003
insert INTO SYS.WSR_SQLTEXT (	0.115	0.021	0.094	17	115	23	0.003
BEGIN WSR$CREATE_SNAPSHOT(); E	0.100	0.082	0.018	1	12595	44	0.003
INSERT INTO bmsql_config ( cf	0.047	0.046	0.000	4	67	3	0.001
declare n integer; i integer;	0.046	0.042	0.005	1	2786	3	0.001
insert INTO WSR_SEGMENT (SNAP	0.040	0.028	0.011	1	5218	21	0.001
select max(hist_id) from bmsql	0.039	0.039	0.000	1	2771	1	0.001
select COUNT(*),COUNT(DECODE(S	0.027	0.027	0.000	45	0	0	0.001
insert INTO WSR_SESSION_EVENTS	0.020	0.020	0.001	1	181	4	0.001
select * from DV_SESSIONS WHER	0.018	0.018	0.000	45	0	0	0.001
insert INTO WSR_DBA_SEGMENTS	0.017	0.015	0.002	1	4176	6	0.000
SELECT 1	0.016	0.016	0.000	665	0	0	0.000
insert INTO WSR_SQLAREA (SNAP	0.007	0.006	0.000	77	257	3	0.000
select SUM(DECODE(TABLESPACE_N	0.006	0.006	0.000	45	0	0	0.000
insert INTO WSR_PARAMETER (SN	0.005	0.003	0.002	1	1501	6	0.000
insert INTO WSR_SYS_STAT (SNA	0.005	0.003	0.002	1	518	178	0.000
SELECT cfg_value FROM bmsql_co	0.003	0.000	0.003	2	4	4	0.000
select SNAP_ID$.NEXTVAL from	0.002	0.002	0.000	1	15	2	0.000
SELECT DBTIMEZONE FROM SYS.DV_	0.002	0.002	0.000	1	0	0	0.000
insert INTO WSR_SYSTEM (SNAP_	0.002	0.000	0.001	1	136	7	0.000
insert INTO WSR_SYSTEM_EVENT	0.002	0.001	0.001	2	282	11	0.000
select COUNT(*) from WSR_SQL	0.001	0.001	0.000	77	154	0	0.000
SELECT LPAD(SNAP_ID, 15, ' '),	0.001	0.000	0.000	1	3	1	0.000
insert INTO WSR_SNAPSHOT (SNA	0.001	0.001	0.000	1	8	0	0.000
select SQL_ID, MIN(SQL_TEXT) S	0.000	0.000	0.000	1	0	0	0.000
select INSTANCE_ID from DV_I	0.000	0.000	0.000	1	0	0	0.000
insert INTO WSR_LATCH (SNAP_I	0.000	0.000	0.000	1	38	0	0.000
insert INTO WSR_WAITSTAT (SNA	0.000	0.000	0.000	1	30	0	0.000
select :1 , TO_DATE(CTIME,'YYY	0.000	0.000	0.000	1	0	0	0.000
update WSR_CONTROL set MOST_RE	0.000	0.000	0.000	1	5	0	0.000
insert INTO WSR_LIBRARYCACHE	0.000	0.000	0.000	1	8	0	0.000
select DBID from DV_DATABASE	0.000	0.000	0.000	1	0	0	0.000

Long SQL ordered by first 15 letters

SQL prefix	Executions	Execution Time(s)	Max Execution Time (s)	Parses	Parse Time (s)	Fetchs	Fetch Time (s)

Long SQL ordered by first 30 letters

SQL prefix	Executions	Execution Time(s)	Max Execution Time (s)	Parses	Parse Time (s)	Fetchs	Fetch Time (s)

Complete List of SQL Text

SQL Id	SQL Text	ELAPSED(s)	SQL Plan
0019533674	INSERT INTO bmsql_new_order ( no_o_id, no_d_id, no_w_id) VALUES (:p1, :p2, :p3)
0049052732	select INSTANCE_ID from DV_INSTANCE
0092634197	INSERT INTO bmsql_config ( cfg_name, cfg_value) VALUES (:p1, :p2)
0098598691	select DBID from DV_DATABASE
0203728423	INSERT INTO bmsql_customer ( c_id, c_d_id, c_w_id, c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_since, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_payment_cnt, c_delivery_cnt, c_data) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21)
0209361974	UPDATE bmsql_oorder SET o_carrier_id = :p1 WHERE o_w_id = :p2 AND o_d_id = :p3 AND o_id = :p4
0289374106	UPDATE bmsql_district SET d_ytd = d_ytd + :p1 WHERE d_w_id = :p2 AND d_id = :p3
0368405445	SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock WHERE s_w_id = :p1 AND s_quantity < :p2 AND s_i_id IN ( SELECT ol_i_id FROM bmsql_district JOIN bmsql_order_line ON ol_w_id = d_w_id AND ol_d_id = d_id AND ol_o_id >= d_next_o_id - 20 AND ol_o_id < d_next_o_id WHERE d_w_id = :p3 AND d_id = :p4 ) )
0405006318	INSERT INTO bmsql_stock ( s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10, s_ytd, s_order_cnt, s_remote_cnt, s_data) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17)
0447837152	SELECT c_id FROM bmsql_customer WHERE c_w_id = :p1 AND c_d_id = :p2 AND c_last = :p3 ORDER BY c_first
0453948317	BEGIN WSR$CREATE_SNAPSHOT(); END;
0495268548	INSERT INTO bmsql_oorder ( o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_carrier_id, o_ol_cnt, o_all_local) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8)
0567372848	DELETE FROM bmsql_new_order WHERE no_w_id = :p1 AND no_d_id = :p2 AND no_o_id = :p3
0615692581	UPDATE bmsql_customer SET c_balance = c_balance - :p1, c_ytd_payment = c_ytd_payment + :p2, c_payment_cnt = c_payment_cnt + 1 WHERE c_w_id = :p3 AND c_d_id = :p4 AND c_id = :p5
0617601049	SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10 FROM bmsql_stock WHERE s_w_id = :p1 AND s_i_id = :p2 FOR UPDATE
0642457297	SELECT LPAD(SNAP_ID, 15, ' '), TO_CHAR(SNAP_TIME, 'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(STARTUP_TIME, 'YYYY-MM-DD HH24:MI:SS') FROM ADM_HIST_SNAPSHOT ORDER BY SNAP_ID DESC LIMIT 20
0662783873	insert INTO SYS.WSR_SESSION_SQL (CTIME , SID , SQL_ID , CURR_SCHEMA , CLIENT_IP , PROGRAM , AUTO_COMMIT , LOGON_TIME , WAIT_SID , SQL_EXEC_START , MODULE , EVENT ) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 )
0729190854	SELECT c_discount, c_last, c_credit, w_tax FROM bmsql_customer JOIN bmsql_warehouse ON (w_id = c_w_id) WHERE c_w_id = :p1 AND c_d_id = :p2 AND c_id = :p3
0803557546	select :1 , TO_DATE(CTIME,'YYYY-MM-DD HH24:MI:SS') CTIME, ELAPSED_TIME, SQL_ID, EXPLAIN_ID, EXPLAIN_TEXT, STAGE, SQL_TEXT from DV_LONG_SQL WHERE CTIME<=TO_CHAR(:2 :: DATE,'YYYY-MM-DD HH24:MI:SS') AND CTIME>TO_CHAR((SELECT MOST_RECENT_SNAP_TIME :: DATE from WSR_CONTROL),'YYYY-MM-DD HH24:MI:SS')
0813566551	insert INTO WSR_SYS_STAT (SNAP_ID , STAT_ID , STAT_NAME , VALUE ) SELECT :1 , STATISTIC#, NAME, VALUE from DV_SYS_STATS
0844168030	SELECT o_c_id FROM bmsql_oorder WHERE o_w_id = :p1 AND o_d_id = :p2 AND o_id = :p3
0910329455	INSERT INTO bmsql_district ( d_id, d_w_id, d_name, d_street_1, d_street_2, d_city, d_state, d_zip, d_tax, d_ytd, d_next_o_id) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11)
1100688548	insert INTO SYS.WSR_SQLTEXT (CTIME , SQL_ID , SQL_TEXT ) VALUES (:1 , :2 , :3 )
1136136383	declare n integer; i integer; dummy integer; begin select max(hist_id) into n from bmsql_history; i := 0; while i <= n loop select bmsql_hist_id_seq.nextval into dummy from dual; i := i + 30000; end loop; end;
1198270733	select * from DV_SESSIONS WHERE STATUS='ACTIVE' AND (CLIENT_IP<>'0.0.0.0' OR EVENT<>'idle wait')
1218455557	select max(hist_id) from bmsql_history
1316762144	INSERT INTO bmsql_new_order ( no_o_id, no_d_id, no_w_id) VALUES (:p1, :p2, :p3)
1326412389	SELECT d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = :p1 AND d_id = :p2 FOR UPDATE
1377057357	insert INTO WSR_INSTANCE_SNAP (SNAP_TIME , SESSION_NUM , ACTIVE_SESS_NUM , LOCK_NUM , TRANSACTION_NUM , TEMP_BUFFER_FREE , DATA_BUFFER_PIN , TS_SYSTEM_FREE , TS_SYSWARE_FREE , TS_USER_FREE , TXN_PAGES , UNDO_PAGES ) VALUES (SYSDATE, :1 , :2 , (SELECT COUNT() from DV_LOCKS), (SELECT COUNT() from DV_TRANSACTIONS), (SELECT SUM(FREE_PAGES) from DV_TEMP_POOLS), (SELECT SUM(CNUM_PINNED) from DV_BUFFER_POOL_STATS), :3 , :4 , :5 , :6 , :7 )
1619891791	INSERT INTO bmsql_history ( h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8)
1645643541	INSERT INTO bmsql_warehouse ( w_id, w_name, w_street_1, w_street_2, w_city, w_state, w_zip, w_tax, w_ytd) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9)
1661892907	UPDATE bmsql_warehouse SET w_ytd = w_ytd + :p1 WHERE w_id = :p2
1775218545	UPDATE bmsql_stock SET s_quantity = :p1, s_ytd = s_ytd + :p2, s_order_cnt = s_order_cnt + 1, s_remote_cnt = s_remote_cnt + :p3 WHERE s_w_id = :p4 AND s_i_id = :p5
1781442178	select bmsql_hist_id_seq.nextval from dual
1815131950	update WSR_CONTROL set MOST_RECENT_SNAP_TIME=:1 ,MOST_RECENT_SNAP_ID=:2
1817342111	SELECT 1
1854133114	select SUM(DECODE(TABLESPACE_NAME,'SYSTEM',TOTAL_SIZE-USED_SIZE,0)),SUM(DECODE(TABLESPACE_NAME,'SYSWARE',TOTAL_SIZE-USED_SIZE,0)), SUM(CASE WHEN TABLESPACE_NAME IN ('SYSTEM','SYSWARE','TEMP','UNDO','TEMP2','TEMP2_UNDO') THEN 0 ELSE TOTAL_SIZE-USED_SIZE END) from ADM_TABLESPACES
1911224605	insert INTO WSR_SEGMENT (SNAP_ID , OWNER , OBJECT_NAME , SUBOBJECT_NAME , TS# , OBJECT_TYPE , STATISTIC_NAME , STATISTIC# , VALUE ) SELECT :1 , OWNER, OBJECT_NAME, SUBOBJECT_NAME, TS#, OBJECT_TYPE, STATISTIC_NAME, STATISTIC#, VALUE from DV_SEGMENT_STATS WHERE VALUE>0
19533674	INSERT INTO bmsql_new_order ( no_o_id, no_d_id, no_w_id) VALUES (:p1, :p2, :p3)
2008876062	SELECT DBTIMEZONE FROM SYS.DV_INSTANCE
203728423	INSERT INTO bmsql_customer ( c_id, c_d_id, c_w_id, c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_since, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_payment_cnt, c_delivery_cnt, c_data) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21)
209361974	UPDATE bmsql_oorder SET o_carrier_id = :p1 WHERE o_w_id = :p2 AND o_d_id = :p3 AND o_id = :p4
2141580327	SELECT no_o_id FROM bmsql_new_order WHERE no_w_id = :p1 AND no_d_id = :p2 ORDER BY no_o_id ASC
2167779333	select COUNT(*) from WSR_SQLTEXT WHERE CTIME=:1 AND SQL_ID=:2
2280059544	SELECT o_id, o_entry_d, o_carrier_id FROM bmsql_oorder WHERE o_w_id = :p1 AND o_d_id = :p2 AND o_c_id = :p3 AND o_id = ( SELECT max(o_id) FROM bmsql_oorder WHERE o_w_id = :p4 AND o_d_id = :p5 AND o_c_id = :p6 )
2305559646	UPDATE bmsql_customer SET c_balance = c_balance + :p1, c_delivery_cnt = c_delivery_cnt + 1 WHERE c_w_id = :p2 AND c_d_id = :p3 AND c_id = :p4
2314291513	SELECT sum(ol_amount) AS sum_ol_amount FROM bmsql_order_line WHERE ol_w_id = :p1 AND ol_d_id = :p2 AND ol_o_id = :p3
2354809456	insert INTO WSR_TRANSACTION (SNAP_TIME , SID , UNDO_COUNT , BEGIN_TIME ) SELECT :1 , SID, UNDO_COUNT, BEGIN_TIME from DV_TRANSACTIONS
2358353897	insert INTO WSR_LATCH (SNAP_ID , ID , NAME , GETS , MISSES , SPIN_GETS , WAIT_TIME ) SELECT :1 , ID, NAME, GETS, MISSES, SPIN_GETS, WAIT_TIME from DV_LATCHS
2671632775	select COUNT(*),COUNT(DECODE(STATUS,'ACTIVE',1,NULL)) from DV_SESSIONS
2690334720	SELECT i_price, i_name, i_data FROM bmsql_item WHERE i_id = :p1
2694261527	SELECT c_data FROM bmsql_customer WHERE c_w_id = :p1 AND c_d_id = :p2 AND c_id = :p3
2735749187	insert INTO WSR_LOCK_OBJECT (SNAP_TIME , SID , OBJECT_NAME , LMODE ) SELECT :1 , SESSION_ID, OBJECT_NAME, LMODE from DV_LOCKED_OBJECTS
2742635046	SELECT cfg_value FROM bmsql_config WHERE cfg_name = :p1
2815201306	SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip FROM bmsql_warehouse WHERE w_id = :p1
2871286689	insert INTO WSR_DBA_SEGMENTS (SNAP_ID , OWNER , SEGMENT_NAME , PARTITION_NAME , SEGMENT_TYPE , TABLESPACE_NAME , BYTES , PAGES , EXTENTS ) SELECT :1 , OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, TABLESPACE_NAME, BYTES, PAGES, EXTENTS from ADM_SEGMENTS WHERE PAGES>0
289374106	UPDATE bmsql_district SET d_ytd = d_ytd + :p1 WHERE d_w_id = :p2 AND d_id = :p3
2906654698	select COUNT(*) from WSR_CONTROL WHERE STATUS='Y' AND SESSION_STATUS='Y'
2923084465	UPDATE bmsql_order_line SET ol_delivery_d = :p1 WHERE ol_w_id = :p2 AND ol_d_id = :p3 AND ol_o_id = :p4
2988770469	select SUM(TXN_PAGES),SUM(UNDO_PAGES) from DV_UNDO_SEGMENTS
3038683717	insert INTO WSR_SQLAREA (SNAP_ID , SQL_ID , SQL_TEXT , MODULE , EXECUTIONS , DISK_READS , BUFFER_GETS , SORTS , PARSE_CALLS , PROCESSED_ROWS , IO_WAIT_TIME , CON_WAIT_TIME , CPU_TIME , ELAPSED_TIME , REF_COUNT , IS_FREE , CLEANED , CR_GETS , PARSE_TIME , PARSING_USER_NAME , PROGRAM_ID , PROGRAM_LINE# , VM_PAGES_USED ) VALUES (:1 , :2 , SUBSTR(:3 ,1,30), :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , NULL, NULL, :16 , :17 , :18 , :19 , :20 , :21 )
3310877950	insert INTO WSR_SNAPSHOT (SNAP_ID , DBID , INSTANCE_ID , STARTUP_TIME , SNAP_TIME , FLUSH_ELAPSED , SESSIONS , CURSORS ) VALUES (:1 , :2 , :3 , (SELECT STARTUP_TIME from DV_INSTANCE), :4 , NUMTODSINTERVAL((SYSDATE-CAST(:5 as DATE)) * 86400,'SECOND'), (SELECT COUNT() from DV_SESSIONS), (SELECT COUNT() from DV_OPEN_CURSORS) )
3346861191	select SQL_ID, MIN(SQL_TEXT) SQL_TEXT, MIN(MODULE) MODULE, SUM(EXECUTIONS) EXECUTIONS, SUM(DISK_READS) DISK_READS, SUM(BUFFER_GETS) BUFFER_GETS, SUM(SORTS) SORTS, SUM(PARSE_CALLS) PARSE_CALLS, SUM(PROCESSED_ROWS) PROCESSED_ROWS, SUM(IO_WAIT_TIME) IO_WAIT_TIME, SUM(CON_WAIT_TIME) CON_WAIT_TIME, SUM(CPU_TIME) CPU_TIME, SUM(ELAPSED_TIME) ELAPSED_TIME, SUM(REF_COUNT) REF_COUNT, SUM(CR_GETS) CR_GETS, SUM(PARSE_TIME) PARSE_TIME, MIN(PARSING_USER_NAME) PARSING_USER_NAME, MIN(PROGRAM_ID) PROGRAM_ID, MIN(PROGRAM_LINE#) PROGRAM_LINE#, SUM(VM_FREE_PAGES) VM_PAGES_USED from DV_SQLS WHERE EXECUTIONS>0 GROUP BY SQL_ID
3358378755	insert INTO WSR_SYSTEM_EVENT (SNAP_ID , EVENT# , EVENT , WAIT_CLASS , TOTAL_WAITS , TIME_WAITED , TIME_WAITED_MIRCO , AVERAGE_WAIT , AVERAGE_WAIT_MIRCO ) SELECT :1 , EVENT#, EVENT, WAIT_CLASS, TOTAL_WAITS, TIME_WAITED, TIME_WAITED_MIRCO, AVERAGE_WAIT, AVERAGE_WAIT_MIRCO from DV_SYS_EVENTS
3425372336	insert INTO WSR_SYSTEM (SNAP_ID , STAT_ID , STAT_NAME , VALUE ) SELECT :1 , ID, NAME, VALUE from DV_SYSTEM
3583228784	BEGIN WSR$CREATE_SESSION_SNAPSHOT(); END;
3590314129	UPDATE bmsql_district SET d_next_o_id = d_next_o_id + 1 WHERE d_w_id = :p1 AND d_id = :p2
3638166556	SELECT ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d FROM bmsql_order_line WHERE ol_w_id = :p1 AND ol_d_id = :p2 AND ol_o_id = :p3 ORDER BY ol_w_id, ol_d_id, ol_o_id, ol_number
3656167539	INSERT INTO bmsql_item ( i_id, i_im_id, i_name, i_price, i_data) VALUES (:p1, :p2, :p3, :p4, :p5)
3660588145	SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip FROM bmsql_district WHERE d_w_id = :p1 AND d_id = :p2
368405445	SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock WHERE s_w_id = :p1 AND s_quantity < :p2 AND s_i_id IN ( SELECT ol_i_id FROM bmsql_district JOIN bmsql_order_line ON ol_w_id = d_w_id AND ol_d_id = d_id AND ol_o_id >= d_next_o_id - 20 AND ol_o_id < d_next_o_id WHERE d_w_id = :p3 AND d_id = :p4 ) )
3747064878	UPDATE bmsql_customer SET c_balance = c_balance - :p1, c_ytd_payment = c_ytd_payment + :p2, c_payment_cnt = c_payment_cnt + 1, c_data = :p3 WHERE c_w_id = :p4 AND c_d_id = :p5 AND c_id = :p6
3887671171	insert INTO WSR_LIBRARYCACHE (SNAP_ID , NAMESPACE , GETS , GETHITS , PINS , PINHITS , RELOADS , INVLIDATIONS ) SELECT :1 , NAMESPACE, GETS, GETHITS, PINS, PINHITS, RELOADS, INVLIDATIONS from DV_LIBRARY_CACHE
3923215066	insert INTO WSR_SYSTEM_EVENT (SNAP_ID , EVENT# , EVENT , WAIT_CLASS , TOTAL_WAITS , TIME_WAITED , TIME_WAITED_MIRCO , AVERAGE_WAIT , AVERAGE_WAIT_MIRCO ) SELECT :1 , -1, 'CPU', '', NULL, VALUE/1000000, VALUE, NULL, NULL from WSR_SYS_STAT WHERE SNAP_ID=:2 AND STAT_ID=2
3960484044	SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_since, c_credit, c_credit_lim, c_discount, c_balance FROM bmsql_customer WHERE c_w_id = :p1 AND c_d_id = :p2 AND c_id = :p3 FOR UPDATE
3964610326	select COUNT(*) from SYS.WSR_SQLTEXT WHERE CTIME=:1 AND SQL_ID=:2
4036846721	insert INTO WSR_PARAMETER (SNAP_ID , NAME , VALUE , RUNTIME_VALUE , DEFAULT_VALUE , ISDEFAULT , MODIFIABLE , DESCRIPTION , RANGE , DATATYPE , EFFECTIVE ) SELECT :1 ,NAME,VALUE,RUNTIME_VALUE,DEFAULT_VALUE, ISDEFAULT,MODIFIABLE,DESCRIPTION,RANGE, DATATYPE,EFFECTIVE from DV_PARAMETERS
405006318	INSERT INTO bmsql_stock ( s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10, s_ytd, s_order_cnt, s_remote_cnt, s_data) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17)
4071217845	INSERT INTO bmsql_order_line ( ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, ol_quantity, ol_amount, ol_dist_info) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10)
4081488768	insert INTO WSR_WAITSTAT (SNAP_ID , CLASS , COUNT , TIME ) SELECT :1 , CLASS, COUNT, TIME from DV_WAIT_STATS
4128069989	INSERT INTO bmsql_order_line ( ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_dist_info) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9)
4146315128	INSERT INTO bmsql_history ( hist_id, h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9)
4151099238	INSERT INTO bmsql_oorder ( o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7)
4229588365	select SNAP_ID$.NEXTVAL from SYS_DUMMY
4266041370	insert INTO WSR_SESSION_EVENTS (SNAP_ID , SID , EVENT# , EVENT , P1 , WAIT_CLASS , TOTAL_WAITS , TIME_WAITED_MIRCO ) SELECT :1 , SID, EVENT#, EVENT, P1, WAIT_CLASS, TOTAL_WAITS, TIME_WAITED_MIRCO from DV_SESSION_EVENTS WHERE WAIT_CLASS<>'Idle'
4291921220	SELECT c_first, c_middle, c_last, c_balance FROM bmsql_customer WHERE c_w_id = :p1 AND c_d_id = :p2 AND c_id = :p3
447837152	SELECT c_id FROM bmsql_customer WHERE c_w_id = :p1 AND c_d_id = :p2 AND c_last = :p3 ORDER BY c_first
567372848	DELETE FROM bmsql_new_order WHERE no_w_id = :p1 AND no_d_id = :p2 AND no_o_id = :p3
617601049	SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10 FROM bmsql_stock WHERE s_w_id = :p1 AND s_i_id = :p2 FOR UPDATE
729190854	SELECT c_discount, c_last, c_credit, w_tax FROM bmsql_customer JOIN bmsql_warehouse ON (w_id = c_w_id) WHERE c_w_id = :p1 AND c_d_id = :p2 AND c_id = :p3

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Writes
Segments by Row Lock Waits
Segments by Page Lock Waits
Segments by Buffer Busy Waits
Segments by Segment Space
Back to Top

Segments by Logical Reads

Total Logical Reads : 29960589

Owner	Tablespace Name	Object Name	Partition Name	Obj. Type	Logical Reads	%Total
STEVEN	USERS	BMSQL_ORDER_LINE		TABLE	8089277	27.000
STEVEN	USERS	BMSQL_OORDER_PKEY		INDEX	4409993	14.719
STEVEN	USERS	BMSQL_STOCK		TABLE	3988569	13.313
STEVEN	USERS	BMSQL_ORDER_LINE_PKEY		INDEX	2902631	9.688
STEVEN	USERS	BMSQL_STOCK_PKEY		INDEX	2874207	9.593
STEVEN	USERS	BMSQL_CUSTOMER		TABLE	1248320	4.167
STEVEN	USERS	BMSQL_DISTRICT_PKEY		INDEX	915150	3.055
STEVEN	USERS	BMSQL_OORDER		TABLE	856609	2.859
STEVEN	USERS	BMSQL_HISTORY		TABLE	789957	2.637
STEVEN	USERS	BMSQL_ITEM_PKEY		INDEX	618912	2.066
STEVEN	USERS	BMSQL_NEW_ORDER_PKEY		INDEX	575571	1.921
STEVEN	USERS	BMSQL_CUSTOMER_PKEY		INDEX	518158	1.729
STEVEN	USERS	BMSQL_WAREHOUSE_PKEY		INDEX	507703	1.695
STEVEN	USERS	BMSQL_OORDER_IDX1		INDEX	440617	1.471
STEVEN	USERS	BMSQL_NEW_ORDER		TABLE	403496	1.347
STEVEN	USERS	_PK_SYS_2_2		INDEX	239637	0.800
STEVEN	USERS	BMSQL_ITEM		TABLE	222574	0.743
STEVEN	USERS	BMSQL_DISTRICT		TABLE	145447	0.485
STEVEN	USERS	BMSQL_CUSTOMER_IDX1		INDEX	85138	0.284
STEVEN	USERS	BMSQL_WAREHOUSE		TABLE	70000	0.234
SYS	SYSTEM	IX_SEQ$001		INDEX	13642	0.046
SYS	SYSTEM	IX_WSR_SQLTEXT	SYS_P8F3	INDEX PART	10062	0.034
SYS	SYSTEM	SYS_SEQUENCES		TABLE	4555	0.015
SYS	SYSTEM	I_JOB_2		INDEX	4340	0.014
SYS	SYSTEM	IX_WSR_LOCK_OBJECT	SYS_P8F5	INDEX PART	3428	0.011
SYS	SYSTEM	WSR_LOCK_OBJECT	SYS_P8F5	TABLE PART	1970	0.007
SYS	SYSTEM	IX_MODS_003		INDEX	1861	0.006
SYS	SYSTEM	IX_WSR_SEGMENT	SYS_P950	INDEX PART	1691	0.006
SYS	SYSTEM	WSR_SEGMENT	SYS_P95F	TABLE PART	1515	0.005
SYS	SYSTEM	IX_COLUMN$001		INDEX	1390	0.005
SYS	SYSTEM	IX_WSR_SEGMENT	SYS_P95F	INDEX PART	1188	0.004
SYS	SYSTEM	WSR_DBA_SEGMENTS	SYS_P951	TABLE PART	1045	0.003
SYS	SYSTEM	WSR_PARAMETER_PK		INDEX	980	0.003
SYS	SYSTEM	WSR_SEGMENT	SYS_P950	TABLE PART	866	0.003
SYS	SYSTEM	I_JOB_1		INDEX	819	0.003
SYS	SYSTEM	IX_WSR_SESSION_SQL	SYS_P8F2	INDEX PART	790	0.003
SYS	SYSTEM	WSR_SESSION_SQL	SYS_P8F2	TABLE PART	661	0.002
SYS	SYSTEM	WSR_PARAMETER		TABLE	514	0.002
SYS	SYSTEM	IX_TABLEPART$001		INDEX	490	0.002
SYS	SYSTEM	WSR_TRANSACTION	SYS_P8F4	TABLE PART	458	0.002
SYS	SYSTEM	WSR_SYS_STAT_PK		INDEX	428	0.001
SYS	SYSTEM	IX_MODS_002		INDEX	392	0.001
SYS	SYSTEM	IX_INDEX$002		INDEX	335	0.001
SYS	SYSTEM	WSR_SQLAREA	SYS_P95E	TABLE PART	329	0.001
SYS	SYSTEM	IX_TABLE$002		INDEX	322	0.001
SYS	SYSTEM	IX_TABLE$001		INDEX	307	0.001
SYS	SYSTEM	SYS_DML_STATS		TABLE	299	0.001
SYS	SYSTEM	SYS_JOBS		TABLE	273	0.001
SYS	SYSTEM	IX_WSR_INSTANCE_SNAP	SYS_P8F6	INDEX PART	270	0.001
SYS	SYSTEM	IX_INDEX$001		INDEX	263	0.001
SYS	SYSTEM	IX_INDEXPART$001		INDEX	253	0.001
SYS	SYSTEM	IX_CONSDEF$001		INDEX	246	0.001
SYS	SYSTEM	SYS_COLUMNS		TABLE	218	0.001
SYS	SYSTEM	WSR_INSTANCE_SNAP	SYS_P8F6	TABLE PART	208	0.001
SYS	SYSTEM	SYS_CONSTRAINT_DEFS		TABLE	202	0.001
SYS	SYSTEM	WSR_SYS_STAT		TABLE	173	0.001
SYS	SYSTEM	WSR_SQLTEXT	SYS_P8F3	TABLE PART	172	0.001
SYS	SYSTEM	IX_CONSDEF$002		INDEX	159	0.001
SYS	SYSTEM	SYS_TABLES		TABLE	158	0.001
SYS	SYSTEM	WSR_SYSTEM_EVENT_PK		INDEX	139	0.000
SYS	SYSTEM	IX_CONSDEF$003		INDEX	124	0.000
SYS	SYSTEM	WSR_SYSTEM_PK		INDEX	96	0.000
SYS	SYSTEM	IX_MODS_001		INDEX	88	0.000
SYS	SYSTEM	SYS_INDEXES		TABLE	83	0.000
SYS	SYSTEM	IX_WSR_SESSION_EVENTS_SID	SYS_P952	INDEX PART	64	0.000
SYS	SYSTEM	IX_DISTRIBUTE_STRATEGY$001		INDEX	63	0.000
SYS	SYSTEM	IX_LOGICREP$_001		INDEX	63	0.000
SYS	SYSTEM	WSR_SYSTEM_EVENT		TABLE	61	0.000
SYS	SYSTEM	WSR_SESSION_EVENTS	SYS_P952	TABLE PART	56	0.000
SYS	SYSTEM	SYS_TABLE_PARTS		TABLE	54	0.000
SYS	SYSTEM	WSR_CONTROL		TABLE	51	0.000
SYS	SYSTEM	WSR_SYSTEM		TABLE	41	0.000
SYS	SYSTEM	SYS_DEPENDENCIES		TABLE	40	0.000
STEVEN	USERS	BMSQL_CONFIG		TABLE	38	0.000
STEVEN	USERS	_PK_SYS_2_1		INDEX	33	0.000
SYS	SYSTEM	WSR_LATCH_PK		INDEX	26	0.000
SYS	SYSTEM	IX_PARTOBJECT$001		INDEX	22	0.000
SYS	SYSTEM	IX_GARBAGE_SEGMENT$001		INDEX	19	0.000
SYS	SYSTEM	IX_WSR_WAITSTAT		INDEX	18	0.000
SYS	SYSTEM	IX_LOB$001		INDEX	17	0.000
SYS	SYSTEM	SYS_PART_OBJECTS		TABLE	16	0.000
SYS	SYSTEM	SYS_INDEX_PARTS		TABLE	15	0.000
SYS	SYSTEM	WSR_WAITSTAT		TABLE	13	0.000
SYS	SYSTEM	WSR_LATCH		TABLE	13	0.000
SYS	SYSTEM	IX_PROC_001		INDEX	11	0.000
SYS	SYSTEM	IX_DEPENDENCY1		INDEX	11	0.000
SYS	SYSTEM	SYS_PROCS		TABLE	11	0.000
SYS	SYSTEM	IX_DEPENDENCY2		INDEX	10	0.000
SYS	SYSTEM	IX_PROC_002		INDEX	8	0.000
SYS	SYSTEM	IX_DEPENDENCY4		INDEX	8	0.000
SYS	SYSTEM	IX_DEPENDENCY3		INDEX	7	0.000
SYS	SYSTEM	SYS_USERS		TABLE	6	0.000
SYS	SYSTEM	WSR_SNAPSHOT		TABLE	6	0.000
SYS	SYSTEM	WSR_LIBRARYCACHE		TABLE	5	0.000
SYS	SYSTEM	IX_PROC_003		INDEX	4	0.000
SYS	SYSTEM	IX_WSR_LIBRARYCACHE		INDEX	4	0.000
SYS	SYSTEM	WSR_SNAPSHOT_PK		INDEX	4	0.000
SYS	SYSTEM	WSR_SQLAREA	SYS_P94F	TABLE PART	3	0.000

Segments by Physical Reads

Total Physical Reads : 1748902

Owner	Tablespace Name	Object Name	Partition Name	Obj. Type	Physical Reads	%Total
STEVEN	USERS	BMSQL_STOCK_PKEY		INDEX	567836	32.468
STEVEN	USERS	BMSQL_ITEM_PKEY		INDEX	393651	22.508
STEVEN	USERS	BMSQL_OORDER_PKEY		INDEX	274175	15.677
STEVEN	USERS	BMSQL_CUSTOMER_PKEY		INDEX	177072	10.125
STEVEN	USERS	BMSQL_ORDER_LINE_PKEY		INDEX	87263	4.990
STEVEN	USERS	BMSQL_DISTRICT_PKEY		INDEX	65507	3.746
STEVEN	USERS	BMSQL_CUSTOMER_IDX1		INDEX	61215	3.500
STEVEN	USERS	BMSQL_OORDER_IDX1		INDEX	25136	1.437
STEVEN	USERS	BMSQL_NEW_ORDER_PKEY		INDEX	22466	1.285
STEVEN	USERS	BMSQL_STOCK		TABLE	20869	1.193
STEVEN	USERS	BMSQL_ORDER_LINE		TABLE	19834	1.134
STEVEN	USERS	BMSQL_CUSTOMER		TABLE	7547	0.432
STEVEN	USERS	BMSQL_WAREHOUSE_PKEY		INDEX	6900	0.395
STEVEN	USERS	_PK_SYS_2_2		INDEX	5060	0.289
SYS	SYSTEM	IX_WSR_SQLTEXT	SYS_P8F3	INDEX PART	4882	0.279
SYS	SYSTEM	IX_SEQ$001		INDEX	2395	0.137
STEVEN	USERS	BMSQL_HISTORY		TABLE	2003	0.115
STEVEN	USERS	BMSQL_OORDER		TABLE	1610	0.092
STEVEN	USERS	BMSQL_ITEM		TABLE	562	0.032
STEVEN	USERS	BMSQL_NEW_ORDER		TABLE	479	0.027
SYS	SYSTEM	I_JOB_2		INDEX	434	0.025
SYS	SYSTEM	I_JOB_1		INDEX	184	0.011
SYS	SYSTEM	WSR_SYS_STAT_PK		INDEX	176	0.010
SYS	SYSTEM	IX_WSR_SESSION_SQL	SYS_P8F2	INDEX PART	165	0.009
SYS	SYSTEM	IX_WSR_LOCK_OBJECT	SYS_P8F5	INDEX PART	137	0.008
SYS	SYSTEM	IX_TABLE$002		INDEX	114	0.007
SYS	SYSTEM	IX_MODS_003		INDEX	113	0.006
SYS	SYSTEM	IX_COLUMN$001		INDEX	106	0.006
SYS	SYSTEM	WSR_PARAMETER_PK		INDEX	102	0.006
SYS	SYSTEM	WSR_SESSION_SQL	SYS_P8F2	TABLE PART	95	0.005
SYS	SYSTEM	IX_WSR_INSTANCE_SNAP	SYS_P8F6	INDEX PART	84	0.005
SYS	SYSTEM	WSR_LOCK_OBJECT	SYS_P8F5	TABLE PART	78	0.004
SYS	SYSTEM	WSR_TRANSACTION	SYS_P8F4	TABLE PART	61	0.003
SYS	SYSTEM	WSR_INSTANCE_SNAP	SYS_P8F6	TABLE PART	58	0.003
SYS	SYSTEM	IX_DISTRIBUTE_STRATEGY$001		INDEX	56	0.003
SYS	SYSTEM	IX_LOGICREP$_001		INDEX	56	0.003
STEVEN	USERS	BMSQL_DISTRICT		TABLE	35	0.002
SYS	SYSTEM	SYS_CONSTRAINT_DEFS		TABLE	25	0.001
SYS	SYSTEM	IX_MODS_002		INDEX	24	0.001
SYS	SYSTEM	WSR_SQLTEXT	SYS_P8F3	TABLE PART	24	0.001
SYS	SYSTEM	WSR_CONTROL		TABLE	22	0.001
SYS	SYSTEM	IX_TABLE$001		INDEX	21	0.001
SYS	SYSTEM	SYS_TABLES		TABLE	20	0.001
SYS	SYSTEM	IX_GARBAGE_SEGMENT$001		INDEX	19	0.001
SYS	SYSTEM	IX_MODS_001		INDEX	17	0.001
SYS	SYSTEM	IX_CONSDEF$001		INDEX	16	0.001
SYS	SYSTEM	SYS_INDEXES		TABLE	12	0.001
SYS	SYSTEM	IX_CONSDEF$002		INDEX	12	0.001
SYS	SYSTEM	IX_CONSDEF$003		INDEX	12	0.001
SYS	SYSTEM	SYS_DML_STATS		TABLE	11	0.001
STEVEN	USERS	BMSQL_WAREHOUSE		TABLE	11	0.001
SYS	SYSTEM	IX_INDEX$001		INDEX	8	0.000
SYS	SYSTEM	IX_TABLEPART$001		INDEX	8	0.000
SYS	SYSTEM	SYS_TABLE_PARTS		TABLE	7	0.000
SYS	SYSTEM	WSR_SYSTEM_EVENT_PK		INDEX	7	0.000
SYS	SYSTEM	IX_DEPENDENCY2		INDEX	6	0.000
SYS	SYSTEM	WSR_PARAMETER		TABLE	6	0.000
SYS	SYSTEM	IX_DEPENDENCY1		INDEX	5	0.000
SYS	SYSTEM	WSR_SYSTEM_PK		INDEX	5	0.000
SYS	SYSTEM	SYS_DEPENDENCIES		TABLE	5	0.000
STEVEN	USERS	_PK_SYS_2_1		INDEX	5	0.000
SYS	SYSTEM	IX_WSR_SEGMENT	SYS_P950	INDEX PART	5	0.000
SYS	SYSTEM	IX_WSR_WAITSTAT		INDEX	5	0.000
SYS	SYSTEM	WSR_LATCH_PK		INDEX	5	0.000
SYS	SYSTEM	IX_INDEX$002		INDEX	4	0.000
SYS	SYSTEM	IX_PARTOBJECT$001		INDEX	4	0.000
SYS	SYSTEM	IX_DEPENDENCY4		INDEX	4	0.000
SYS	SYSTEM	WSR_DBA_SEGMENTS	SYS_P951	TABLE PART	4	0.000
SYS	SYSTEM	IX_INDEXPART$001		INDEX	4	0.000
SYS	SYSTEM	SYS_PROCS		TABLE	3	0.000
SYS	SYSTEM	IX_WSR_SEGMENT	SYS_P95F	INDEX PART	3	0.000
SYS	SYSTEM	WSR_SYSTEM_EVENT		TABLE	3	0.000
SYS	SYSTEM	WSR_SEGMENT	SYS_P95F	TABLE PART	3	0.000
SYS	SYSTEM	IX_DEPENDENCY3		INDEX	3	0.000
SYS	SYSTEM	WSR_SYS_STAT		TABLE	3	0.000
SYS	SYSTEM	SYS_SEQUENCES		TABLE	2	0.000
SYS	SYSTEM	WSR_SQLAREA	SYS_P95E	TABLE PART	2	0.000
SYS	SYSTEM	WSR_LATCH		TABLE	2	0.000
SYS	SYSTEM	WSR_WAITSTAT		TABLE	2	0.000
SYS	SYSTEM	WSR_LIBRARYCACHE		TABLE	2	0.000
SYS	SYSTEM	WSR_SEGMENT	SYS_P950	TABLE PART	2	0.000
SYS	SYSTEM	SYS_INDEX_PARTS		TABLE	2	0.000
STEVEN	USERS	BMSQL_CONFIG		TABLE	2	0.000
SYS	SYSTEM	WSR_SYSTEM		TABLE	2	0.000
SYS	SYSTEM	IX_PROC_001		INDEX	1	0.000
SYS	SYSTEM	IX_PROC_002		INDEX	1	0.000
SYS	SYSTEM	IX_PROC_003		INDEX	1	0.000
SYS	SYSTEM	WSR_SNAPSHOT		TABLE	1	0.000
SYS	SYSTEM	IX_WSR_LIBRARYCACHE		INDEX	1	0.000
SYS	SYSTEM	IX_WSR_SESSION_EVENTS_SID	SYS_P952	INDEX PART	1	0.000
SYS	SYSTEM	WSR_SESSION_EVENTS	SYS_P952	TABLE PART	1	0.000

Segments by Physical Writes

Total Physical Writes : 417002

Owner	Tablespace Name	Object Name	Partition Name	Obj. Type	Physical Reads	%Total
STEVEN	USERS	BMSQL_STOCK_PKEY		INDEX	129395	31.030
STEVEN	USERS	BMSQL_DISTRICT_PKEY		INDEX	61242	14.686
STEVEN	USERS	BMSQL_STOCK		TABLE	56238	13.486
STEVEN	USERS	BMSQL_ORDER_LINE		TABLE	51766	12.414
STEVEN	USERS	BMSQL_CUSTOMER_PKEY		INDEX	44209	10.602
STEVEN	USERS	BMSQL_CUSTOMER		TABLE	27275	6.541
STEVEN	USERS	BMSQL_OORDER_IDX1		INDEX	10478	2.513
STEVEN	USERS	BMSQL_ORDER_LINE_PKEY		INDEX	9551	2.290
STEVEN	USERS	BMSQL_HISTORY		TABLE	7557	1.812
STEVEN	USERS	BMSQL_NEW_ORDER_PKEY		INDEX	6050	1.451
STEVEN	USERS	BMSQL_OORDER		TABLE	3946	0.946
STEVEN	USERS	BMSQL_OORDER_PKEY		INDEX	2786	0.668
SYS	SYSTEM	IX_SEQ$001		INDEX	2324	0.557
STEVEN	USERS	BMSQL_ITEM		TABLE	1805	0.433
STEVEN	USERS	BMSQL_NEW_ORDER		TABLE	1221	0.293
SYS	SYSTEM	I_JOB_1		INDEX	193	0.046
SYS	SYSTEM	WSR_SESSION_SQL	SYS_P8F2	TABLE PART	112	0.027
STEVEN	USERS	_PK_SYS_2_2		INDEX	99	0.024
SYS	SYSTEM	IX_MODS_003		INDEX	89	0.021
SYS	SYSTEM	WSR_LOCK_OBJECT	SYS_P8F5	TABLE PART	84	0.020
SYS	SYSTEM	SYS_TABLES		TABLE	40	0.010
SYS	SYSTEM	SYS_CONSTRAINT_DEFS		TABLE	36	0.009
SYS	SYSTEM	WSR_TRANSACTION	SYS_P8F4	TABLE PART	36	0.009
SYS	SYSTEM	WSR_INSTANCE_SNAP	SYS_P8F6	TABLE PART	36	0.009
SYS	SYSTEM	IX_WSR_LOCK_OBJECT	SYS_P8F5	INDEX PART	30	0.007
STEVEN	USERS	BMSQL_DISTRICT		TABLE	25	0.006
SYS	SYSTEM	IX_WSR_SESSION_SQL	SYS_P8F2	INDEX PART	23	0.006
SYS	SYSTEM	I_JOB_2		INDEX	18	0.004
SYS	SYSTEM	WSR_SEGMENT	SYS_P95F	TABLE PART	18	0.004
SYS	SYSTEM	WSR_SQLTEXT	SYS_P8F3	TABLE PART	18	0.004
SYS	SYSTEM	IX_WSR_INSTANCE_SNAP	SYS_P8F6	INDEX PART	18	0.004
STEVEN	USERS	BMSQL_WAREHOUSE		TABLE	17	0.004
SYS	SYSTEM	IX_TABLE$001		INDEX	16	0.004
SYS	SYSTEM	SYS_INDEXES		TABLE	14	0.003
SYS	SYSTEM	SYS_DML_STATS		TABLE	14	0.003
SYS	SYSTEM	SYS_DEPENDENCIES		TABLE	13	0.003
SYS	SYSTEM	WSR_DBA_SEGMENTS	SYS_P951	TABLE PART	13	0.003
STEVEN	USERS	BMSQL_WAREHOUSE_PKEY		INDEX	13	0.003
SYS	SYSTEM	IX_WSR_SQLTEXT	SYS_P8F3	INDEX PART	12	0.003
SYS	SYSTEM	IX_WSR_SEGMENT	SYS_P95F	INDEX PART	11	0.003
SYS	SYSTEM	IX_MODS_002		INDEX	10	0.002
SYS	SYSTEM	IX_TABLEPART$001		INDEX	9	0.002
SYS	SYSTEM	SYS_TABLE_PARTS		TABLE	9	0.002
SYS	SYSTEM	IX_CONSDEF$003		INDEX	8	0.002
SYS	SYSTEM	WSR_SQLAREA	SYS_P95E	TABLE PART	8	0.002
SYS	SYSTEM	WSR_PARAMETER_PK		INDEX	7	0.002
SYS	SYSTEM	IX_WSR_SEGMENT	SYS_P950	INDEX PART	7	0.002
STEVEN	USERS	BMSQL_CONFIG		TABLE	7	0.002
SYS	SYSTEM	IX_INDEX$002		INDEX	6	0.001
SYS	SYSTEM	IX_MODS_001		INDEX	6	0.001
SYS	SYSTEM	WSR_PARAMETER		TABLE	6	0.001
SYS	SYSTEM	IX_COLUMN$001		INDEX	5	0.001
SYS	SYSTEM	IX_CONSDEF$002		INDEX	5	0.001
SYS	SYSTEM	WSR_SESSION_EVENTS	SYS_P952	TABLE PART	5	0.001
SYS	SYSTEM	IX_INDEXPART$001		INDEX	5	0.001
SYS	SYSTEM	IX_INDEX$001		INDEX	5	0.001
SYS	SYSTEM	IX_CONSDEF$001		INDEX	5	0.001
SYS	SYSTEM	IX_WSR_SESSION_EVENTS_SID	SYS_P952	INDEX PART	4	0.001
STEVEN	USERS	_PK_SYS_2_1		INDEX	4	0.001
SYS	SYSTEM	SYS_COLUMNS		TABLE	3	0.001
SYS	SYSTEM	WSR_SYS_STAT		TABLE	3	0.001
SYS	SYSTEM	SYS_SEQUENCES		TABLE	2	0.000
SYS	SYSTEM	WSR_SYSTEM_EVENT		TABLE	2	0.000
SYS	SYSTEM	SYS_PROCS		TABLE	2	0.000
SYS	SYSTEM	IX_DEPENDENCY4		INDEX	2	0.000
SYS	SYSTEM	WSR_SEGMENT	SYS_P950	TABLE PART	2	0.000
SYS	SYSTEM	IX_DEPENDENCY2		INDEX	2	0.000
SYS	SYSTEM	WSR_SYS_STAT_PK		INDEX	2	0.000
SYS	SYSTEM	IX_TABLE$002		INDEX	1	0.000
SYS	SYSTEM	IX_PROC_001		INDEX	1	0.000
SYS	SYSTEM	IX_PROC_002		INDEX	1	0.000
SYS	SYSTEM	IX_PROC_003		INDEX	1	0.000
SYS	SYSTEM	IX_PARTOBJECT$001		INDEX	1	0.000
SYS	SYSTEM	SYS_INDEX_PARTS		TABLE	1	0.000
SYS	SYSTEM	IX_DEPENDENCY1		INDEX	1	0.000
SYS	SYSTEM	IX_DEPENDENCY3		INDEX	1	0.000
SYS	SYSTEM	WSR_CONTROL		TABLE	1	0.000
SYS	SYSTEM	WSR_SNAPSHOT_PK		INDEX	1	0.000
SYS	SYSTEM	WSR_SNAPSHOT		TABLE	1	0.000
SYS	SYSTEM	WSR_SYSTEM_PK		INDEX	1	0.000
SYS	SYSTEM	WSR_SYSTEM		TABLE	1	0.000
SYS	SYSTEM	WSR_SYSTEM_EVENT_PK		INDEX	1	0.000
SYS	SYSTEM	IX_WSR_WAITSTAT		INDEX	1	0.000
SYS	SYSTEM	WSR_WAITSTAT		TABLE	1	0.000
SYS	SYSTEM	WSR_LATCH_PK		INDEX	1	0.000
SYS	SYSTEM	WSR_LATCH		TABLE	1	0.000
SYS	SYSTEM	IX_WSR_LIBRARYCACHE		INDEX	1	0.000
SYS	SYSTEM	WSR_LIBRARYCACHE		TABLE	1	0.000

Segments by Row Lock Waits

Total Row Lock Waits : 0

Owner	Tablespace Name	Object Name	Partition Name	Obj. Type	Row Lock Waits	%Total

Segments by Page Lock Waits

Total Page Lock Waits : 155619

Owner	Tablespace Name	Object Name	Obj. Type	Page Lock Waits	%Total
STEVEN	USERS	BMSQL_WAREHOUSE	TABLE	106044	68.143
STEVEN	USERS	BMSQL_DISTRICT	TABLE	49480	31.796
STEVEN	USERS	BMSQL_NEW_ORDER	TABLE	70	0.045
STEVEN	USERS	BMSQL_STOCK	TABLE	25	0.016

Buffer Busy Waits

Total Buffer Busy Waits : 35886

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	%Total
STEVEN	USERS	BMSQL_STOCK	TABLE	16543	46.099
STEVEN	USERS	BMSQL_ORDER_LINE	TABLE	15556	43.348
STEVEN	USERS	BMSQL_CUSTOMER	TABLE	2043	5.693
STEVEN	USERS	BMSQL_DISTRICT_PKEY	INDEX	932	2.597
STEVEN	USERS	BMSQL_WAREHOUSE_PKEY	INDEX	222	0.619
STEVEN	USERS	BMSQL_HISTORY	TABLE	169	0.471
STEVEN	USERS	_PK_SYS_2_2	INDEX	111	0.309
STEVEN	USERS	BMSQL_OORDER	TABLE	96	0.268
STEVEN	USERS	BMSQL_DISTRICT	TABLE	74	0.206
STEVEN	USERS	BMSQL_NEW_ORDER	TABLE	43	0.120
STEVEN	USERS	BMSQL_WAREHOUSE	TABLE	40	0.111
STEVEN	USERS	BMSQL_NEW_ORDER_PKEY	INDEX	28	0.078
SYS	SYSTEM	IX_SEQ$001	INDEX	12	0.033
STEVEN	USERS	BMSQL_ORDER_LINE_PKEY	INDEX	8	0.022
STEVEN	USERS	BMSQL_STOCK_PKEY	INDEX	4	0.011
STEVEN	USERS	BMSQL_CUSTOMER_PKEY	INDEX	2	0.006
STEVEN	USERS	BMSQL_OORDER_PKEY	INDEX	2	0.006
STEVEN	USERS	BMSQL_OORDER_IDX1	INDEX	1	0.003

Segments Space Increase

Segments Space Begin (Bytes) : 50921472
Segments Space End (Bytes) : 1211367424

Owner	Object Name	Partition Name	Obj. Type	Tablespace Name	Bytes	Pages	Extents
STEVEN	BMSQL_STOCK		TABLE	USERS	410058752	50056	6257
STEVEN	BMSQL_ORDER_LINE		TABLE	USERS	283181056	34568	4321
STEVEN	BMSQL_CUSTOMER		TABLE	USERS	205717504	25112	3139
STEVEN	BMSQL_ORDER_LINE_PKEY		TABLE	USERS	116981760	14280	1785
STEVEN	BMSQL_HISTORY		TABLE	USERS	25362432	3096	387
STEVEN	BMSQL_STOCK_PKEY		TABLE	USERS	23986176	2928	366
STEVEN	BMSQL_CUSTOMER_IDX1		TABLE	USERS	19136512	2336	292
STEVEN	BMSQL_OORDER		TABLE	USERS	16842752	2056	257
STEVEN	BMSQL_OORDER_IDX1		TABLE	USERS	13828096	1688	211
STEVEN	BMSQL_OORDER_PKEY		TABLE	USERS	10289152	1256	157
STEVEN	BMSQL_ITEM		TABLE	USERS	10092544	1232	154
STEVEN	BMSQL_CUSTOMER_PKEY		TABLE	USERS	8519680	1040	130
STEVEN	_PK_SYS_2_2		TABLE	USERS	6488064	792	99
STEVEN	BMSQL_NEW_ORDER_PKEY		TABLE	USERS	3932160	480	60
STEVEN	BMSQL_NEW_ORDER		TABLE	USERS	2686976	328	41
STEVEN	BMSQL_ITEM_PKEY		TABLE	USERS	2031616	248	31
SYS	WSR_SEGMENT	SYS_P95F	TABLE	SYSTEM	196608	24	3
SYS	WSR_LOCK_OBJECT	SYS_P8F5	TABLE	SYSTEM	131072	16	2
SYS	SYS_DEPENDENCIES		TABLE	SYSTEM	65536	8	1
STEVEN	BMSQL_CONFIG		TABLE	USERS	65536	8	1
STEVEN	BMSQL_WAREHOUSE		TABLE	USERS	65536	8	1
STEVEN	BMSQL_DISTRICT		TABLE	USERS	65536	8	1
SYS	IX_MODS_002		TABLE	SYSTEM	65536	8	1
STEVEN	_PK_SYS_2_1		TABLE	USERS	65536	8	1
STEVEN	BMSQL_WAREHOUSE_PKEY		TABLE	USERS	65536	8	1
STEVEN	BMSQL_DISTRICT_PKEY		TABLE	USERS	65536	8	1
SYS	WSR_SQLAREA	SYS_P95E	TABLE	SYSTEM	65536	8	1
SYS	WSR_SESSION_SQL	SYS_P8F2	TABLE	SYSTEM	65536	8	1
SYS	WSR_SESSION_EVENTS	SYS_P952	TABLE	SYSTEM	65536	8	1
SYS	WSR_DBA_SEGMENTS	SYS_P951	TABLE	SYSTEM	65536	8	1
SYS	IX_WSR_SESSION_SQL	SYS_P8F2	TABLE	SYSTEM	65536	8	1
SYS	IX_WSR_SESSION_EVENTS_SID	SYS_P952	TABLE	SYSTEM	65536	8	1
SYS	IX_WSR_SEGMENT	SYS_P95F	TABLE	SYSTEM	65536	8	1

Instance Parameters

Parameter Name	Begin value	End value (if different)
CONTROL_FILES	(/opt/gaussdb/data/data/cntl1, /opt/gaussdb/data/data/cntl2, /opt/gaussdb/data/data/cntl3)
DATA_BUFFER_SIZE	200M
DBWR_PROCESSES	8
ENABLE_SYSDBA_LOGIN	TRUE
INSTANCE_NAME	zenith
LOG_BUFFER_COUNT	8
LOG_BUFFER_SIZE	64M
LSNR_ADDR	127.0.0.1,192.168.56.102
LSNR_PORT	1888
SESSIONS	1500
SHARED_POOL_SIZE	100M
TEMP_BUFFER_SIZE	100M

gaussdb t

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

Gaussdb T WSR 报告示例

Workload Statistics Report

评论