We have a rule i.e if a query takes more than one terabyte of spool we are supposed to abort it.
My question is lets say the total spool is used by a query , what is the expected behavior of the system , will the system restart or what can happen?
Next question is related to the 1st line ; If we have around 10 terabyte of spool , is this logical to abort the query that has just crossed 1tb of spool. i thnk we should allow it more spool that can be up to 9tb or so if there are no other sessions. Please provide your analysis on the above cases ,