Re: Is possible to return the SQL result but not query the table?
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Thu, 11 Mar 2010 23:17:21 +1100
Message-ID: <4B98DF51.7000301_at_iinet.net.au>
Nuno Souto wrote,on my timestamp of 11/03/2010 10:50 PM:
> Brooks, Dominic (London)(c) wrote,on my timestamp of 11/03/2010 8:19 PM:
>
>
>
>
> You could be a reeeeeealy baaaaaad boy and re-create the all_tab_columns
> and all_ind_columns views yourself to be something harmless and fast.
> But of course that will invalidate any other SQL that might access them.
> Don't tell support I suggested that, OK? ;)
Date: Thu, 11 Mar 2010 23:17:21 +1100
Message-ID: <4B98DF51.7000301_at_iinet.net.au>
Nuno Souto wrote,on my timestamp of 11/03/2010 10:50 PM:
> Brooks, Dominic (London)(c) wrote,on my timestamp of 11/03/2010 8:19 PM:
>
>
>
>> This SQL's result is not been used anymore, but I can't access the >> program code, so my question is: >> Can I do something in the database side, and tell the database when >> this SQL runs, just return a static result, avoid to querying >> all_tab_columns and all_ind_columns views?
>
> You could be a reeeeeealy baaaaaad boy and re-create the all_tab_columns
> and all_ind_columns views yourself to be something harmless and fast.
> But of course that will invalidate any other SQL that might access them.
> Don't tell support I suggested that, OK? ;)
Oh, and of course: if you re-create these two owned by the user that fires off the original SQL instead of owned by SYS, it'll quietly "overload" the SYS definition without affecting other user's SQL.
-- Cheers Nuno Souto in overcast Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 11 2010 - 06:17:21 CST