From: Stefan Jahnke (Stefan.Jahnke@bov.de)
Date: Wed Jul 31 2002 - 11:38:23 CEST
Message-ID: <70F54DBD18DED2119116009027307B230407F061@ebmc02.bov.int> From: Stefan Jahnke <Stefan.Jahnke@bov.de> Date: Wed, 31 Jul 2002 11:38:23 +0200 Subject: AW: [suse-oracle] OT: Table sys.x_$kvis is missing
Hi
this is not an application table. It's an Oracle fixed table.
There are lots of X$ tables providing information on Oracle's
internal structure, e.g. detailed information about the SGA.
A lot of the Data Dictionary views (v$) are based on those tables.
In case of the table name starting with a "k", one can assume that it is a
representation of
a kernel structure. In your case, it's X$KVIS: Oracle Data Block (size_t
type) variables,
where size_t is the infamous C struct to contain a generic size type (at
least on UNIX, don't
know about windows).
You might take a look at Steve Adam's Webpage:
http://www.ixora.com.au/scripts/x$tables.htm
Unfortunately, or fortunately, since they can change unnotified from Oracle
version to Oracle version,
they are not well documented. The Data Dictionary views are the ones that
are supposed to be stable.
X$ tables should only be used by the DBA to get some information that would
otherwise not be accessible.
Applications should never use X$ tables. Kick your developer, please ;).
Regards,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:stefan.jahnke@bov.de
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer
Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar?
Schreiben Sie eine E-Mail an mailto:qualification@bov.de oder rufen Sie uns
an unter 0 18 03 / 73 64 62 73!
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-----Ursprüngliche Nachricht-----
Von: Hoernle, Josef [mailto:Josef.Hoernle@t-systems.com]
Gesendet: Dienstag, 30. Juli 2002 15:10
An: 'Mark Tombs'; Suse-Oracle Mailing List (E-mail)
Betreff: RE: [suse-oracle] OT: Table sys.x_$kvis is missing
Hello,
May be an application table and you should ask someone who knows what your
script is doing.
Regards !!
Josef Hörnle
-----Original Message-----
From: Mark Tombs [mailto:mtombs@niku.nu]
Sent: Tuesday, July 30, 2002 11:33 AM
To: Suse-Oracle Mailing List (E-mail)
Subject: [suse-oracle] OT: Table sys.x_$kvis is missing
Hello
Not strictly an Oracle-on-SuSE problem, but I hope you can help.
I am using Oracle 8.1.7 on SuSE 7.3, and I have got some scripts from a
website that use a table called sys.x_$kvis. I don't have this table, and I
would like to know what it is and why I don't have it.
Any help gratefully appreciated.
thanks
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting
---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.4 : Wed Jul 31 2002 - 11:38:47 CEST