Re: ORACLE ERROR : ORA-00020
Date: Thu, 15 Feb 2001 15:13:43 -0000
Message-ID: <982250102.22634.0.nnrp-08.9e984b29_at_news.demon.co.uk>
v$resource limit
Shows for various static resources
name,
current usage,
maximum usage since instance startup,
limit specified in init.ora
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book rev.html
rocco wrote in message <3A8BEB92.FDA2A01_at_tiscalinet.it>... My server is OS is sun solaris and into the file init.ora the parameter is equal to 100.
Ma question is if someone know if there is some table where to see how many process are currently running.
For example for the opened cursor the table is sys.v $open cursor. thanks bye
--
Received on Thu Feb 15 2001 - 16:13:43 CET