Home » SQL & PL/SQL » SQL & PL/SQL » dbms_utility.get_parameter_vaue
dbms_utility.get_parameter_vaue [message #218302] Wed, 07 February 2007 12:11 Go to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Does anyone know the the story with dbms_utility.get_parameter_value and it not supporting so many init parameters? Was it just never kept updated fully after roughly 8i days? Although I can get some 9i params, like workarea_size_policy, I can't get others, like pga_aggregate_target.

MYDBA@orcl > start demo_get_parameter_value;
declare
*
ERROR at line 1:
ORA-20000: get_parameter_value: invalid or unsupported parameter "pga_aggregate_target"
ORA-06512: at "SYS.DBMS_UTILITY", line 104
ORA-06512: at line 6


Re: dbms_utility.get_parameter_vaue [message #218306 is a reply to message #218302] Wed, 07 February 2007 12:41 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I think Tom actually encountered this limitation too.

[Updated on: Wed, 07 February 2007 12:42]

Report message to a moderator

Re: dbms_utility.get_parameter_vaue [message #218312 is a reply to message #218302] Wed, 07 February 2007 13:06 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Thanks ebrian. I waded through 5 pages of google results, but neglected to check Tom's site.

And you weren't kidding. He used the exact same parameters to test with that I did...talk about a coincidence.

His topic is from 9iR2 and I've found that other params aren't supported in 10g, such as sga_target.

It is interesting to note though that most, if not all, of the params that I've noticed that aren't supported have to do with memory.
Re: dbms_utility.get_parameter_vaue [message #219439 is a reply to message #218302] Wed, 14 February 2007 07:06 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
AFAIK the values of unsupported parameters may exceed some limit imposed inside DBMS_UTILITY.
They probably defined some field as 4-bytes binary and now it's not enough.

My 2 cents of "wisdom".
Previous Topic: Materialized view or Temporary Table
Next Topic: Variables
Goto Forum:
  


Current Time: Sat Dec 10 05:20:27 CST 2016

Total time taken to generate the page: 0.15817 seconds