| Is it safe to query X$ ? [message #308628] |
Tue, 25 March 2008 01:54  |
Serg.K.
Messages: 7
Registered: March 2008
|
Junior Member |
|
|
Hi all!
As far as i know X$ tables are not documented, and there are issues when a single select against x$ table can hung the db.
Is it safe to query x$ tables (x$bh especially) regularly?
|
|
|
|
|
|
|
|
| Re: Is it safe to query X$ ? [message #308652 is a reply to message #308628] |
Tue, 25 March 2008 02:34  |
Serg.K.
Messages: 7
Registered: March 2008
|
Junior Member |
|
|
We are going to install new monitoring system (BMC monitoring for oracle. see bmc.com) .
I've installed it on my Test server, and i noticed that is uses x$bh . To be more accurate, it creates new view called p$bh based on x$bh.
It work O.K. on my test server... But, i have production servers of different versions and on different operation systems...
|
|
|
|
|
|
|
|
|
|
| Re: Is it safe to query X$ ? [message #308740 is a reply to message #308628] |
Tue, 25 March 2008 05:48 |
Serg.K.
Messages: 7
Registered: March 2008
|
Junior Member |
|
|
| Quote: | Yes, the header you access should not be modified during the time you access it.
|
If i understand you right :
All x$ tables are latch affected. V$ views based on X$ tables are not?
|
|
|
|
|
|
| Re: Is it safe to query X$ ? [message #308899 is a reply to message #308628] |
Tue, 25 March 2008 21:34 |
Serg.K.
Messages: 7
Registered: March 2008
|
Junior Member |
|
|
Thanks for the explanation.
So, V$ system views are not like user created views. If I'll create new view based on any X$ table it it will be latch affected?
But, why? How does it works?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
.