OraFAQ Forum: Server Administration » Unexpected queries on user

Home » RDBMS Server » Server Administration » Unexpected queries on user_arguments (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unexpected queries on user_arguments [message #661986]

Tue, 11 April 2017 01:52

praveenpraj
Messages: 21
Registered: October 2011
Location: India

Junior Member

A report developed in a third party reporting tool causes lot of queries on USER_ARGUMENTS like the below one:-

Code: [Select all] [Show/ hide]

SELECT argument_name, data_type, data_length, data_precision,
  data_scale        , in_out
FROM user_arguments
WHERE object_name = 'PROC_INS_TRNS'
AND package_name  = 'PKG_FINS_TRNS_DN'
ORDER BY Position

Report uses a package procedure which returns a REF CURSOR.
But while running a single report, it generates a lot of queries on the combination of all the Package and its procedures.

My doubt is whether oracle uses such a query implicitly while getting any calls to its packages.

[Updated on: Tue, 11 April 2017 01:57]

Report message to a moderator