By
Published: 12 Jul 2004
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
Dig Deeper on Oracle database design and architecture
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