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 cTable 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
Dig Deeper on Oracle database design and architecture
Related Q&A from Don Burleson
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
What is table partitioning and what are its advantages and disadvantages? Also, what is bulk collection? What are hints? Continue Reading
In Oracle 9i, is there a way to identify the specific row being locked in a particular table? I have seen much code that identifies the object being ... Continue Reading