Explore >> Select a destination
|
You are here 
|
tanelpoder.com | ||
| | | | |
blog.jooq.org
|
|
| | | | | This can probably be found elsewhere as well, but here's a short wrap-up how to get the most out of your execution plans, quickly 1. Be sure the actual rows and time statistics are collected. You can do this with -- login as user sys alter system set statistics_level = all; 2. Execute your bad... | |
| | | | |
blog.tanelpoder.com
|
|
| | | | | In recent past I've blogged few scripts which use specially crafted ordered nested loop for sampling contents of V$ and X$ views fast, with plain SQL. If you haven't read them yet, here are the links: WaitProf LatchProf LatchProfX I wrote the above scripts having special purposes in mind (e.g. profile session waits or latching activity). Now I introduce a simple but powerful sqlplus script for ad-hoc sampling of any V$ view. It's called.... (drumroll) .... sample.sql :) When you look into it, the script ... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | In an earlier articleI described how dbms_xplan.display_cursor() could be used to query memory to find the execution plans (and row source statistics) of recently executed SQL. In 9i, you have to use your own SQL to get the equivalent results. If you do, you should avoid using the "traditional" hierarchical type of query that you... | |
| | | | |
4uinews.wordpress.com
|
|
| | | ?? ????? ???? ?? ??????? ???? ?? ???? ???? ?? ????? ?? ????? ????? ?? ????? ???? 1978 ??? ?????? ?? ?? ?? ??? ??? ????? ?????? ?? ???? ???????? ?? ?????? ???? ?? ??? ???? ?? ?????? ?? ?? ???? ??? ?? ???? ??? ?? ????? ??? ??? ?? ???????????? ?? ?? ??? ???... | ||
