Execution Plan Changes When Doing 'select from all_arguments' As non-sys User
(Doc ID 429877.1)
Last updated on APRIL 09, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
Execution plan of the query changes when doing 'select from all_arguments' as non-sys user.
Select object_name, position, data_type, overload, argument_name, position,
data_level, data_length, data_precision, data_scale, default_value, in_out,
object_id, sequence from sys.all_arguments where object_id = (
select object_id from all_objects where owner = 'APPS' and
object_name ='XXAR_INVOICE_PKG' and object_type in ('PACKAGE',
'PROCEDURE', 'FUNCTION'))order by Object_Name, Overload, Sequence
If you look at the execution plan of the above query you will find that view 'ALL_ARGUMENTS' is not getting merged when running as non-sys user.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document