Why so many recursive statements??
Hi,
I have a question concerning Oracle 11.1.0.7 on IBM AIX 6.1 and Windows Server 2003: We're developing interactive applications for geographic information systems. The corresponding Oracle database schema has about 1,300 tables, our test database has about 2.5 GB of data. Shared pool and buffer cache are both around 1G each.
In order to measure interactive performance, we use a standard test scenario that contains typical interactive actions and runs for about 8-10 minutes of user interaction time. On a good day and with one or two users on the database, this scenario generates around 15,000 user SQL statements, and the total elapsed time, according to the tkprof summary of a complete session trace (event 10046, level 12) is around 25-30 seconds.
I have a question concerning Oracle 11.1.0.7 on IBM AIX 6.1 and Windows Server 2003: We're developing interactive applications for geographic information systems. The corresponding Oracle database schema has about 1,300 tables, our test database has about 2.5 GB of data. Shared pool and buffer cache are both around 1G each.
In order to measure interactive performance, we use a standard test scenario that contains typical interactive actions and runs for about 8-10 minutes of user interaction time. On a good day and with one or two users on the database, this scenario generates around 15,000 user SQL statements, and the total elapsed time, according to the tkprof summary of a complete session trace (event 10046, level 12) is around 25-30 seconds.
0