Re: Procedure to generate cpu load on a single core of a multicore cpu

For last 2 days I'm rewriting a report which does exactly that ;) It is written on SQL Server but I think it should work on Oracle too. In order to do that you should think in rows not in sets. So the idea of duhveloper was:
Create temporary table1 with N rows.
For each row in table1:
- insert it in temporary table2 just populating few id columns - calculate value for just inserted row for table2.col1 using select, which full scans table1
- calculate value for just inserted row for table2.col2 using select, which full scans table1
...
- calculate value for just inserted row for table2.colM using select, which full scans table1

Playing with values N and M you should get fantastic results. At least the duhveloper got.

Gints Plivna
http://www.gplivna.eu

2008/10/1 <fuchshp_at_gmail.com>:
> Good Morning Listers
>
> I am looking for a query/procedure wich uses on a multicore processor
> only one core and generates maintly cpu load and not much io load. Do
> you know such a query/procedure? I'd appreciate if you share it with
> me.
>
> Sincerely
> HP
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l