Home » RDBMS Server » Server Administration » Unexpected queries on user_arguments (Oracle Database 12c Enterprise Edition Release - 64bit Production)
Unexpected queries on user_arguments [message #661986] Tue, 11 April 2017 01:52 Go to next message
Messages: 20
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:-
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

Re: Unexpected queries on user_arguments [message #661993 is a reply to message #661986] Tue, 11 April 2017 03:46 Go to previous message
Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No it does not at any call, it does it at the first call unless you modify the package in any way (a recompilation IS a modification).

Previous Topic: Tablespace Not re utilize space
Next Topic: Install Oracle 10g R2
Goto Forum:

Current Time: Fri Jan 15 21:48:24 CST 2021