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
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: 25050
Registered: January 2009
Location: SoCal
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
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:...
Senior Member

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

show parameter SORT_AREA_SIZE

Laughing
Previous Topic: Partition index Tablespace
Next Topic: hoe to select the concatenated column
Goto Forum:
  


Current Time: Sat Dec 10 07:14:18 CST 2016

Total time taken to generate the page: 0.09557 seconds