Data Mining Scripts

Data Mining Scripts

aveact.sql - day of data, 1 line per hour

"+" - represent CPU usage

"-" - represent wait time

"2" in the GRAPH is the number of CPUS on this machine

GRAPH is a graphical representation of AVEACT (AAS)

TM	NPTS	AVEACT	GRAPH	CPU	WAITS
06-AUG 13:00:00	270	.33	+-2	29	59
06-AUG 14:00:00	1040	2.24	++--------2---	341	1984
06-AUG 15:00:00	623	6.67	++++------2----------	438	3718
06-AUG 16:00:00	1088	2.59	++--------2----	335	2486
06-AUG 17:00:00	1104	1.26	++-----2	349	1043
06-AUG 18:00:00	1093	1.38	+++----2	663	842
06-AUG 19:00:00	1012	1.74	++-------2	373	1388
06-AUG 20:00:00	1131	.99	+----2	304	820
06-AUG 21:00:00	1111	1.22	++-----2	344	1012
06-AUG 22:00:00	1010	1.66	++------2	414	1259
06-AUG 23:00:00	1120	1.08	+----2	298	913
07-AUG 00:00:00	1024	.83	+---2	273	576
07-AUG >01:00:00	1006	1.74	++-------2	319	1428
07-AUG 02:00:00	1090	2.47	++--------2----	347	2345
07-AUG >03:00:00	687	6.59	+++-------2----------	382	4142
07-AUG >04:00:00	1004	1.95	++++++---2	1299	659
07-AUG 05:00:00	1104	3.08	+++++-----2------	1170	2226
07-AUG 06:00:00	1122	1.91	+++++++--2	1582	558
07-AUG 07:00:00	1115	1.06	+++---2	559	618
07-AUG 08:00:00	1140	.81	++--2	403	519
07-AUG 09:00:00	1128	.88	++---2	386	601

aveactn.sql - - day of data, 1 line per hour, show the top to waits as well as graph

TO_CHAR(STA	SAMPLES	AAS1	FIRST	AAS2	SECOND	GRAPH
23 10:00:00	647	.01	db file sequent	.01	db file scatter	4
23 11:00:00	2773	.02	CPU	.01	.buffer busy wai	4
23 12:00:00	3029	.00	CPU	.00	db file paralle	4
23 01:00:00	2761	.00	SQL*Net break/r	.00	control file se	4
23 02:00:00	2258	.00	CPU	.00	log file sync	4
23 03:00:00	1651	.03	buffer busy wai	.01	CPU

aveactf.sql- same as above but finer frequency ( 1 hour of data, line for every minute)

aveactnf.sql - same as above but finer frequency ( 1 hour of data, line for every minute)