Problem solve
Get help with specific problems with your technologies, process and projects.
Can't find table x$ksppsv
Don's code included in his answer "How can I get a list of hidden Oracle parameters in Oracle9i?" is as follows:
SELECT
...
...
c.ksppstvl "Instance Value"
FROM
x$ksppi a,
x$ksppcv b,
x$ksppsv c
Table x$ksppsv (c above) doesn't exist in 8i, at least in my installation. Could you help out on this?
Hmmm, x$ksppsv was introduced in Oracle8, and it's in my 8i database. Try connecting as the SYS user.
Here is a good link on x$ details: http://www.stormloader.com/yonghuang/computer/x$table.html
Start the conversation
0 comments