Home » SQL & PL/SQL » SQL & PL/SQL » viewing parameters
viewing parameters [message #267269] Wed, 12 September 2007 22:35 Go to next message
jxh461
Messages: 185
Registered: March 2005
Karma: 0
Senior Member
how can I view parameters settings such as SORT_AREA_SIZE ?

Thanks in advance

[Updated on: Wed, 12 September 2007 22:42]

Report message to a moderator

Re: viewing parameters [message #267271 is a reply to message #267269] Wed, 12 September 2007 22:38 Go to previous messageGo to next message
BlackSwan
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
SQL> desc v$parameter
Re: viewing parameters [message #267272 is a reply to message #267269] Wed, 12 September 2007 22:48 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Karma: 0
Senior Member
http://download-uk.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch3103.htm
Re: viewing parameters [message #267274 is a reply to message #267269] Wed, 12 September 2007 23:08 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Karma: 0
Senior Member

If you don't want to work much try then,

show parameter SORT_AREA_SIZE

Laughing
Previous Topic: cursor query
Next Topic: procedure
Goto Forum:
  


Current Time: Tue Aug 22 11:57:58 CDT 2017

Total time taken to generate the page: 0.04219 seconds