Title: RE: X$tables
x$tables/views are nothing but a clever implementation of SGA C structures as virtual tables. This is also in line with the RDBMS that all metadata etc should be accessible from tables.
Raj
control file
-Original Message-
Sent: Tuesday, September 23, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have a doubt,please clarify.
All we know about x$tables(fixed tables) and
these all are in-memory table.When instance startup the data will be brought
back in this
On Wednesday 02 May 2001 08:30, Mark Leith wrote:
> You will need to either be connected as SYS or SYSDBA:
Well, you can easily remedy that.
http://www.ixora.com.au/scripts/sql/create_xviews.sql
Courtesy of Steve Adams.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
You will need to either be connected as SYS or SYSDBA:
SQL> connect sys/password
Connected.
SQL> desc x$bh
Name Null?Type
-
ADDR RAW(4)
IND
X$ views can be seen only in sys, internal or system
account or in user account having select any table
previledge are u looking for x$ views in any of these
users
--- "Bunyamin K.Karadeniz" <[EMAIL PROTECTED]>
wrote:
> I see that there is no X$ tables in my database or
> I can not view them . My
You will
need to either be connected as SYS or SYSDBA:
SQL>
connect sys/password
Connected.
SQL>
desc x$bh
Name
Null? Type
-
ADDR
Bunyamin,
You should be able
to view these tables from the SYS
schema.
Regards
Suhen
I see that there is no X$ tables in my
database or I can not view them . My O.S. is NT .
How can I view them.??
Thanks
Bunyamin K.Karadeniz
Database Group / Informa
You might also peruse this area:
http://www.oreilly.com/catalog/orinternals/desc.html
-Original Message-
Sent: Friday, April 06, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Hi !
There is no document about X$tables outside oracle.
But Steve Adams has some details in his site
Title: X$ tables
v$fixed_tables
v$views
- NIHAR SANGHVINetMagic Solutions Pvt.
Ltd.22,Nirlon Complex,Western Express Highway,Goregaon (E), Mumabai 400
063Phone: 8723003 extn:
144www.netmagicsolutions.com
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTE
Hi !
There is no document about X$tables outside oracle.
But Steve Adams has some details in his site
(http://www.ixora.com.au) and Jonathan Lewis also
something in his site (http://www.jlcomp.demon.co.uk).
=
Have a nice day !!
B
10 matches
Mail list logo