| Any software for testing performane? [message #53390] |
Tue, 17 September 2002 08:27  |
Jadie
Messages: 64
Registered: January 2002
|
Member |
|
|
Hello:
Does anyone know if there is any performance testing tool/software available for Oracle database, which can perform specified times of database operations (e.g. insert, update, search, and delete) and generates report?
I need the answer urgently. Please reply me if you know something about it. Thanks alot!!! :)
Jadie
|
|
|
|
| Re: Any software for testing performane? [message #53392 is a reply to message #53390] |
Tue, 17 September 2002 16:30  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
use sql trace and process the results through TKPROF. Be sure that TIME_STATISTICS is enabled.
alter session set timed_statistics=true;
alter session set sql_trace=true;
-- do some sql
alter session set sql_trace=true;
Then get the trace file from the udump directory and stick it through tkprof.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
