DBA CPU Benchmark2
Description
Categories: Enginatics
Repository: Github
Repository: Github
Benchmark report to measure a database server's CPU speed, mainly for PLSQL processing.
This report generates an output file of 200000 records from dual.
As the query itself should complete in less than a second, most of the execution time is spend in PLSQL code to generate the Blitz Report output file.
To measure meaningful results, there should be enough SGA memory assigned to ensure th ... more
This report generates an output file of 200000 records from dual.
As the query itself should complete in less than a second, most of the execution time is spend in PLSQL code to generate the Blitz Report output file.
To measure meaningful results, there should be enough SGA memory assigned to ensure th ... more
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select rownum||'SADSA' col1, rownum||'9873265498743265' col2, rownum||'fdsgerer' col3, rownum num1, sqrt(rownum) num2, sysdate+mod(rownum,100) dat1, sysdate+mod(rownum,100) dat2 from dual connect by level<=:row_number |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Row Number |
|
Number |
