Re: Weird Issue : 01013 - User requested cancel, without ctl-c.
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 10 Jun 2019 07:19:51 -0400
Message-ID: <4c79606e-aef7-9f35-390e-00201d4e3b2f_at_gmail.com>
Date: Mon, 10 Jun 2019 07:19:51 -0400
Message-ID: <4c79606e-aef7-9f35-390e-00201d4e3b2f_at_gmail.com>
Actually, the lower item is incorrect. If the address limit is hit, the server process will die with segmentation violation and throw ORA-07445. The client process, in this case SQL*Plus, will get ORA-03113. I apologize for posting misleading information.
On 6/9/19 8:29 PM, Mladen Gogala wrote:
> Hitting the address space limit in the Oracle process. Oracle 11.2.0.4
> will more often than not use direct reads to execute a full table scan
> of the kind you're asking it to do. If there is an OS imposed address
> space limit and your process is hitting it, it may be that.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 10 2019 - 13:19:51 CEST