Return
-
Title
Show SGA statement does not work -
Description
Show SGA statement does not work.
Steps to replicate the problem are:
1] Open an SQL editor
2] Type show sga;
3] Press F5 :
In Toad 10.5 : no results are shown
In Toad 10.5.1.3 : you get the error below:
"Error at line 1
Unable to show SGA
Only one top level element is allowed in an XML document"In Toad 9.5, for example, you get the same result as in SQL Plus :
ÂTotal System Global Area 805306368 bytes
Fixed Size 1289996 bytes
Variable Size 226492660 bytes
Database Buffers 574619648 bytes
Redo Buffers 2904064 bytes
 -
Resolution
WORKAROUND:
NoneSTATUS:
Waiting for fix in a future release of Toad For Oracle
 -
Defect ID
ST73854