| dbms version?? [message #52262] |
Thu, 11 July 2002 06:49  |
Anthony pena
Messages: 12
Registered: July 2002
|
Junior Member |
|
|
|
I'm trying to find my dbms version oracle database and what is the maximum users that can connect to my database....
|
|
|
|
| Re: dbms version?? [message #52266 is a reply to message #52262] |
Thu, 11 July 2002 11:12  |
christopher
Messages: 25
Registered: September 2000
|
Junior Member |
|
|
For the version:
Select * from v$version;
For sessions:
Select name, value
From v$parameter
Where name = 'sessions';
Note:
The background processes are counted in this number
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
