Oracle internals, debugging and undocumented features
ORA-15655: preliminary connection+oradebug direct_access
September 29, 2008Posted by on
ORA-15655: Fixed table \\”%s\\” cannot be accessed safely in prelim connection.
When login to oracle using preliminary connection ( wrote about it few days ago )
e.g. sqlplus -prelim / as sysdba and
oradebug direct_access command e.g.
SQL> oradebug setmypid
SQL> oradebug direct_access select * from x$ksmmem
ORA-15655: Fixed table “X$KSMMEM” cannot be accessed safely in prelim connection.
X$KSMMEM has one row for every memory address in the SGA but oracle is not allowing to see it using prelim connection.
but you can access other structures like
oradebug direct_access select * from X$KSLED; ( event wait descriptors )..
Get the list of X$TABLES and play if you have time to burn…
select kqftanam from x$kqfta