Re: Take your system down with Cartesian Joins

[Spencer Elliott <spencer@xxxxxxxxxxxxxxx>]

Funny, I just posted this same note on another thread!

Vendor Plug!
We offer a product (DiskHunter) that will continually monitor you disk 
usage based of percent increase over time or absolute increase in disk 
usage. The product will then automatically analyze what is going on and 
produce reports that (in most cases) point to the culprit. Alerts and 
emails are sent which contain the results of the analysis. This product 
can catch, analyze and notify you of the findings before your system 
crashes... cheap insurance

Spencer Elliott
Vendor
http://www.s4isystems.com


elehti@xxxxxxxxxxxxxxxxxx wrote:
> How to fill up your disk (system auxiliary storage pool) and take down
> your system. Create a query  to output to a file. Join two or more
> tables but neglect to join the tables. This will produce a Cartesian
> join. http://www.orafaq.com/wiki/Cartesian_join
>
> You will get this message before your system goes down.
>
> Additional Message Information 
>
> Message ID . . . . . . : CPF0907 
> Date sent . . . . . . : 08/07/08 Time sent . . . . . . : 07:23:47 
>
> Message . . . . : Serious storage condition may exist. Press HELP. 
>
> Cause . . . . . : The amount of available auxiliary storage in the
> system 
> auxiliary storage pool has reached the threshold value. This is a 
> potentially serious system condition. The auxiliary storage capacity is 
> 210,990,268,416 bytes. The auxiliary storage used is 191,498,387,456
> bytes. The
> threshold is 90.000000 percent. The auxiliary storage available is
> 9.23828
> percent. 
> Recovery . . . : Use the WRKSYSSTS command to monitor the amount of
> storage
> used. The use of storage can be reduced by the following actions: Save 
> objects by specifying STG(*FREE); delete any unused objects. Save the
> old 
> log versions of QHST that are not currently used and then delete them; 
> either write or delete spooled files on the system. Failure to reduce
> the 
> More..