Re: Where to find sort_area_size?

Peter wrote:

> I know you can just use "show parameter sort_area_size"
> But in which table can you find sort_area_size?
> Thanks

Familiarize yourself with the following:

SELECT *
FROM v_$parameter;

It has all values for all parameters.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)