oracle| Solve | The problem
Most of the time, the technical problems of most it classes can be solved by themselves, and we need a method more than the answer. Here is an example of a solution to the Oracle problem (approach?). If you can say so).
Ask:
Questions about the X$ktuxe table??
I see this statement in the E-magazine (note: Www.itpub.net's electronic magazine) on page fifth 29th, but I am not sure what it means, can you help me explain? Besides, what do the KLUXESCNW and KLUXESCNB here mean?
Select Max (Ktuxescnw*power (2,32) +KTUXESCNB) SCN from X$ktuxe
A: Say Han, similar to the following questions, if I am how to find the answer.
First of all, let me see if there is any need to understand, x$ktuxe, at first glance, is an internal view of Oracle, since it is so, you can know it, do not continue to understand him deeply ...
What, this isn't a good habit? %$#@.....
Well, if that's not the case, I'd like to know what this view is for. What to do?
Looking for a document on Otn? Not likely, such a view of the general Oracle will not elaborate.
Yes, Metalink may have, oh, no Metalink account number ...
Okay, we have Google,
Http://www.google.com
Enter X$ktuxe. Search it, OK, a total of 116 query results, a little review:
The first result is:
Rollback Segment Scripts
... the rollback segment header blocks. The rollback segment header block transaction tables
Can be read via X$ktuxe, however the number of undo blocks in-not always accurately
reflected here until release 9i. Prior to which, it is necessary ...
Www.ixora.com.au/scripts/rbs.htm
－－－－－－－－－－－－－－－－－－－－－－－－－
The third result is:
Speculation of x$ Table Names
... x$ksulop, kernel service, user long operation, X$KSUPR, kernel service, user process, X$ksuse, kernel
Service, user session, X$ktuxe, kernel transaction, undo transaction Entry, X$KZSRO, kernel security,
System role, used in many SQL scripts in?/rdbms/admin. X$le, lock element, X$le_stat, lock element
Status, ...
www.stormloader.com/yonghuang/computer/x$table.html-16k
With these two results, it seems enough to read ... Well, I've got some basic understanding,
But can you not get some specific information? It's still Google.
Sometimes, Google can search the information directly, for us is not very useful, then you may also search Google's newsgroups:
Http://groups.google.com
In our example, we get the first result:
Re:where can I find the latest SCN
.. select Discn from X$KCCDI; You can get the SCN of the most recently committed (local) transaction with
The following query:select max (KTUXESCNW * Power (2) + KTUXESCNB) from X$ktuxe; This May is
Quite the same as the current SCN, because the latter could have advanced a little for various ...
Comp.databases.oracle-serge Lisin Written on September 18, 2002
Ok, look at it. What kind of questions, how others answer. Read the thread from start to finish, and so far the problem is at least clear--at least, you'll get a clearer answer than the one I tried to explain to you.
More often than not, people answer questions to you through this way.
Why don't you have a similar approach?
Look here, you may say: So simple, who will not?
Indeed, it is a way for everyone, and the question is: Can you think of a way to do that in a similar situation?
A bunch of nonsense, if you see a little bit of use then I would be too happy:D
Source: <a href= "http://www.csdn.net/Develop/read_article.asp?id=20360" >http://www.csdn.net/develop/read_ Article.asp?id=20360</a>
