Many times, most IT classes can completely solve it, and we need a method than answers. Here are an example to say some Oracle problem solutions (ways? If you can say this).
ask:
Questions about x $ ktuxe table? ? I am in the E-magazine (Note: www.itpub.net Electronic Magazine) Page 29, see this statement, but I don't know how specific meaning, can I help explain? In addition, what does KluxescnW and Kluxescnb here mean?
SELECT MAX (KTuxescnw * Power (2,32) KTUXESCNB) SCN from x $ KTUXE
A: Say some questions, similar to the following questions, if I want to find the answer.
First of all, this problem let me see if there is necessary to figure out, X $ KTUXE, the first look, is an internal view of Oracle, since this, you can know, don't continue to understand him .. ....
What? This habit is not very good?% $ # @ .....
Well, if not this, I am going to know what this view is doing. How to do?
Looking for a document on OTN? Unlikely, such a similar view is generally Oracle not explained in detail.
By the way, Metalink may have, oh, there is no metalink account ...
Fortunately, 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 use is not always accurately reflected here until release 9i. Prior to that, it Is Necessary ... www.ixora.com.au/scripts/rbs.htm
------------------------ The third result is:
Speculation of X $ TABLE ... 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/yonghuaG/computer / / / Table.html - 16K has these two results, it seems enough, read ... Well, basically understand some,
But can you get some specific information? Or Google
Sometimes, maybe Google directly searches the information, it is not big for us, then you can also search for Google's newsgroup:
http://groups.google.com
In our example, 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 recordness meaning The following query: SELECT MAX (KTuxescnw * Power (2, 32) KTuxescnb) from x $ ktuxe; this may not be quite the Same as the current scn, Because the latter mother, because, is written ... Comp.Databases.Orcle - Serge Lisin Written on September 18, 2002
OK, see? What kind of problem, how others answer. Read this post from the head to the end, until now, this problem is at least clear - at least, the result you get will be clear than I try to explain it.
More time, others will answer questions and pass this way.
Why not master a similar approach?
Look here, you may say: This is not? Indeed, it is indeed a way to everyone, the problem is: I have a similar situation, can you think of such a method?
A bunch of non-diagnosed, if you think it is a bit, I can be too happy: D
Original source: http://www.9cbs.net/develop/read_article.asp?id=20360
