| show sga equivalent in 9.2.0 [message #58271] |
Mon, 11 August 2003 21:10  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
Hi,
I was trying to login as 'dgmgrl' and do a 'show sga' on oracle 9.2.0 and it wouldn't let me. It errored out. What is the equivalent of 'show sga' of 8.1.7 in 9.2.0?
Thanks
|
|
|
|
|
|
|
|
| Re: show sga equivalent in 9.2.0 [message #58287 is a reply to message #58271] |
Tue, 12 August 2003 08:15  |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Works fine for me (logged in as SYSTEM)
% sqlplus system
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Aug 12 09:47:28 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
SQL> show sga
Total System Global Area 236157912 bytes
Fixed Size 740312 bytes
Variable Size 150994944 bytes
Database Buffers 83886080 bytes
Redo Buffers 536576 bytes
SQL>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
