DBA CPU Benchmark2
Description
Categories: Enginatics, Kcapps
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
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 |
