Hi Folks, I have a question about interpreting ARS server SQL logs. I am in the process of migrating from a Sybase database server to an Oracle server and I am trying to evaluate the performance of the Oracle server. I have turned on API and SQL logs and have them both written to a combined log file. When I complete a typical search using the Windows User tool, the following log entries are written:
01 /* Wed Apr 14 2010 08:25:23.5164 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 02 /* Wed Apr 14 2010 08:25:23.5178 */ SELECT ... 03 /* Wed Apr 14 2010 08:25:24.6918 */ COMMIT WORK 04 /* Wed Apr 14 2010 08:25:24.8038 */ -GLEWF OK 05 /* Wed Apr 14 2010 08:25:24.8097 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 06 /* Wed Apr 14 2010 08:25:24.8935 */ -GLEWF OK 07 /* Wed Apr 14 2010 08:25:24.8992 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 08 /* Wed Apr 14 2010 08:25:24.9841 */ -GLEWF OK 09 /* Wed Apr 14 2010 08:25:24.9896 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 10 /* Wed Apr 14 2010 08:25:25.0660 */ -GLEWF OK 11 /* Wed Apr 14 2010 08:25:25.0716 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 12 /* Wed Apr 14 2010 08:25:25.1086 */ -GLEWF OK 13 /* Wed Apr 14 2010 08:25:25.1146 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 14 /* Wed Apr 14 2010 08:25:25.1492 */ -GLEWF OK 15 /* Wed Apr 14 2010 08:25:25.1545 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 16 /* Wed Apr 14 2010 08:25:25.1810 */ -GLEWF OK 17 /* Wed Apr 14 2010 08:25:25.1864 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 18 /* Wed Apr 14 2010 08:25:25.1967 */ -GLEWF OK My questions is: Which times constitute the exact time that it took the database server to complete the select? For this particular query, 825 rows were returned. I have numbered the lines so that we can say something like: line04-line02 = whatever... Config: ARS 5.01.02 patch 1313 / Solaris 8 Oracle 10.2.0.4 Thanks. Larry Larry Robinson [email protected] Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
