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 created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.