dioncho.blogspot.com

Dion Cho - Oracle Performance Storyteller

Dion Cho - Oracle Performance Storyteller. Thursday, December 16, 2010. 表T1, T2, T3を作ります。 SQL create table t1(c1 number, c2 number);. SQL create table t2(c1 number, c2 number);. SQL create table t3(c1 number, c2 number);. グローバルヒントを使って、結合順序を T1- T2- T3. SQL explain plan for. 2 select * from. 5 /* leading(v.t1 v.t2 t3) */. 6 vc1 as v c1,. 7 vc2 as v c2,. 8 t3c2 as t3 c2. 14 t1, t2. 16 t1c1 = t2.c1) v,. 19 vc1 = t3.c1. Id Operation Name Rows Bytes Cost (%CPU) Time. 0 SELECT STATEMENT 1 65 7 (15) 00:00:01.

http://dioncho.blogspot.com/

OVERVIEW OF dioncho.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR DIONCHO.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.1 out of 5 with 14 reviews

5 star

6

4 star

6

3 star

1

2 star

0

1 star

1

Hey there! Start your review of dioncho.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT DIONCHO.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

8

SITE IP

216.58.216.193

LOAD TIME

0.344 sec

SCORE

6.2

PAGE TITLE

Dion Cho - Oracle Performance Storyteller | dioncho.blogspot.com Reviews

<META> DESCRIPTION

Dion Cho - Oracle Performance Storyteller. Thursday, December 16, 2010. 表T1, T2, T3を作ります。 SQL create table t1(c1 number, c2 number);. SQL create table t2(c1 number, c2 number);. SQL create table t3(c1 number, c2 number);. グローバルヒントを使って、結合順序を T1- T2- T3. SQL explain plan for. 2 select * from. 5 /* leading(v.t1 v.t2 t3) */. 6 vc1 as v c1,. 7 vc2 as v c2,. 8 t3c2 as t3 c2. 14 t1, t2. 16 t1c1 = t2.c1) v,. 19 vc1 = t3.c1. Id Operation Name Rows Bytes Cost (%CPU) Time. 0 SELECT STATEMENT 1 65 7 (15) 00:00:01.

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 oracle性能に関する実用的な高級知識

4 グローバルヒントの制約の面白いケース

5 次はグローバルヒントで結合順序を制御できないテストケースです

6 table created

7 にしますが、なぜか予想通りに動作しません

8 4 select

9 9 from

10 outline data

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,oracle性能に関する実用的な高級知識,グローバルヒントの制約の面白いケース,次はグローバルヒントで結合順序を制御できないテストケースです,table created,にしますが、なぜか予想通りに動作しません,4 select,9 from,outline data,begin outline data,outline @ sel$3,outline @ sel$2,merge @ sel$3,outline @ sel$1,all rows

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Dion Cho - Oracle Performance Storyteller | dioncho.blogspot.com Reviews

https://dioncho.blogspot.com

Dion Cho - Oracle Performance Storyteller. Thursday, December 16, 2010. 表T1, T2, T3を作ります。 SQL create table t1(c1 number, c2 number);. SQL create table t2(c1 number, c2 number);. SQL create table t3(c1 number, c2 number);. グローバルヒントを使って、結合順序を T1- T2- T3. SQL explain plan for. 2 select * from. 5 /* leading(v.t1 v.t2 t3) */. 6 vc1 as v c1,. 7 vc2 as v c2,. 8 t3c2 as t3 c2. 14 t1, t2. 16 t1c1 = t2.c1) v,. 19 vc1 = t3.c1. Id Operation Name Rows Bytes Cost (%CPU) Time. 0 SELECT STATEMENT 1 65 7 (15) 00:00:01.

INTERNAL PAGES

dioncho.blogspot.com

1

Dion Cho - Oracle Performance Storyteller: October 2009

http://www.dioncho.blogspot.com/2009_10_01_archive.html

Dion Cho - Oracle Performance Storyteller. Thursday, October 29, 2009. Posted by Dion Cho. Tuesday, October 27, 2009. 現実は、世界的な景気沈滞と共に大型プロジェクトが失踪しながらオラクル性能コンサルタントの単価は速い速度で下がっています。当分の間はこんな傾向が加速化するはずです。もう一度の事実は、ソフトウエア業界が若い人たちに離れられて実力のある者の数がかえって次第に減っていることです。それなら実力を認められた人たちの単価はかえって上がらないんでしょうか。今の選択が向後5－10年を左右します。皆さんの選択は何ですか。 Posted by Dion Cho. Monday, October 26, 2009. Http:/ download.oracle.com/docs/cd/B28359 01/server.111/b28320/initparams232.htm. Sort run information (SRD*/SRS*)". Drop table t1 purge;.

2

Dion Cho - Oracle Performance Storyteller: September 2009

http://www.dioncho.blogspot.com/2009_09_01_archive.html

Dion Cho - Oracle Performance Storyteller. Wednesday, September 30, 2009. Describeコマンドはテーブルの定義を確認する時によく使用します。僕はDescribeコマンドをチューニングツールの範疇に入れます。性能問題を扱って見ればオブジェクトと明確な定義を知るべき時か多いからです。たちを一緒に見るべきの場合がたくさんあります。僕はこんな機能が追加されたDescribeコマンドを Extended Describe. Create table t1(c1 int, c2 int, c3 int, c4 int, c5 int);. Create index t1 n1 on t1(c1);. Create unique index t1 n2 on t1(c1, c3);. Create index t1 n3 on t1(c1, c4);. Create index t1 n4 on t1(c1, c5);. Create index t1 n5 on t1(c3, c4);. Index 1.3.4.5. T1 N5 1 2.

3

Dion Cho - Oracle Performance Storyteller: July 2010

http://www.dioncho.blogspot.com/2010_07_01_archive.html

Dion Cho - Oracle Performance Storyteller. Monday, July 26, 2010. オラクルで特定のセッション（あるいはシステム）の現在の状態をすぐにわかる一番良い方法はなんでしょうか。オラクルで特定のセッション（あるいはシステム）が何をしているのかを追跡できる一番良い方法は何でしょうか。 Call Stack(oradebug dump callstack). スナップショットは特定の時点の状態を示しているから、ほとんど大部分差異（Delta）と比較（Diff）. を通じてだけ意味を持ちます。AWRレポートをみればスナップショット間の値を差異（Delta）を計算してくれます。差異と比較を通じて直感的にシステムの現在の状態がわかります。 Posted by Dion Cho. 12300;ティパック」を紹介します。 Posted by Dion Cho. Wednesday, July 14, 2010. これ以上チューニング不可能に見える完璧に最適化された文章です。ほぼ3.4秒がかかりました。 2 v value number;. 4 for idx...

4

Dion Cho - Oracle Performance Storyteller: November 2010

http://www.dioncho.blogspot.com/2010_11_01_archive.html

Dion Cho - Oracle Performance Storyteller. Tuesday, November 2, 2010. Oracle 11gのSerial Direct Path Readと very large object thresholdパラメータパラメータ. 次のポストを通じてOracle 11gのSerial Direct Path Readを制御する方法を紹介したことがあります。オラクル11ｇのserial全表スキャンに対するdirect path read非活性化しよう。を利用してSerial Direct Path Readを不活性化することが可能だということです。最近Serial Direct Path Readを制御するもう１つの隠しパラメータを知るようになりました。 VERY LARGE OBJECT THRESHOLD. Oracleのバージョンは11.2.0.1です。 SQL select * from v$version where rownum = 1;. SQL @para very large object. SQL set echo off.

5

Dion Cho - Oracle Performance Storyteller: November 2009

http://www.dioncho.blogspot.com/2009_11_01_archive.html

Dion Cho - Oracle Performance Storyteller. Sunday, November 29, 2009. 例えば、9i以下だったらV$SESSION WAITビューから、10g以上だったらV$SESSIONビューから待機イベント情報を抽出するスクリプトが作りたいんです。PL/SQLを利用せずSQL*Plusで実行可能な一つのスクリプトファイルで作りたければどうしたらいいでしょうか。多い方法があるはずですが次のような簡単なトリックが使えます。 Col is 10g new value is 10g. Col is 9i new value is 9i. With v as (. Instr(banner, 'Release ') 8,. Instr(banner, '.') - instr(banner, 'Release ')-8) as version. From v$version where rownum = 1. Case when version = 10 then ' else '- ' end as is 10g,. Select * from (.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

dioncho.wordpress.com

Interpreting Parallel MERGE Statement | Dion Cho - Oracle Performance Storyteller

https://dioncho.wordpress.com/2010/12/10/interpreting-parallel-merge-statement

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Interpreting Parallel MERGE Statement. This post is inspired by one of my colleagues, who had small difficulty while interpreting parallel MERGE execution plan. This is the step-by-step explanation I gave him. Would this MERGE statement run in parallel? The answer is NO. As you notice from the operation #2, the MERGE part itself runs in serial. It is SELECT part that runs in parallel. The reason would be parallel dml not enabled.

dioncho.wordpress.com

_gby_hash_aggregation_enabled bug | Dion Cho - Oracle Performance Storyteller

https://dioncho.wordpress.com/2010/07/06/_gby_hash_aggregation_enabled-bug

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Gby hash aggregation enabled bug. One of the customers complained that Oracle refuses to use the HASH GROUP BY operation under any circumstances. It’s 10gR2(10.2.0.1) database. TPACK@ukja1021 select * from v$version where rownum = 1; BANNER - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod. One thing to note is that you might see this bug only when you ...

dioncho.wordpress.com

TPack | Dion Cho - Oracle Performance Storyteller

https://dioncho.wordpress.com/tpack

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Is my personal library which I use for analyzing Oracle peformance problems. You can get more informations on TPack site. Written by Dion Cho. September 16, 2010 at 1:52 am. Subscribe to comments with RSS. 8230;] TPack‘s Wait Detail Report gives more detailed information on the deadlocked library cache pin contention. […]. Making self deadlock on the library cache pin « Dion Cho – Oracle Performance Storyteller. End to end tracing.

dioncho.wordpress.com

Rapid PGA size increase | Dion Cho - Oracle Performance Storyteller

https://dioncho.wordpress.com/2010/06/14/rapid-pga-size-increase

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Rapid PGA size increase. A couple of days ago, one of our customers experienced a rapid PGA increase and the system got rebounced by PMON. We suggested dumping the PGA heap while the problem reoccurs. But the problem is that the PGA increase is too rapid(upto 3.6G in less than 2 min), so it is a bit hard to get the PGA dump manually. Fortunately, in situation like this, Oracle provides a way of getting automatic PGA heap dump.

dioncho.wordpress.com

Interesting case of the restriction of global hints | Dion Cho - Oracle Performance Storyteller

https://dioncho.wordpress.com/2010/12/17/interesting-case-of-the-restriction-of-global-hints

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Interesting case of the restriction of global hints. One of my colleagues sent following test case, of which he couldn’t control the join order with hints. Create objects – table t1, t2 and t3. SQL create table t1(c1 number, c2 number); Table created. SQL create table t2(c1 number, c2 number); Table created. SQL create table t3(c1 number, c2 number); Table created. Now Let’s set the join order as T1- T2- T3. Written by Dion Cho.

dioncho.wordpress.com

Making self deadlock on the library cache pin | Dion Cho - Oracle Performance Storyteller

https://dioncho.wordpress.com/2010/09/16/making-self-deadlock-on-the-library-cache-pin

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Making self deadlock on the library cache pin. It’s very easy to make your session deadlocked on the library cache pin. Let me prove it. Make a dummy procedure called TEST PROC1. Execute simple PL/SQL which executes TEST PROC1 and compiles it. TPACK@ukja1120 begin 2 test proc1; 3 4 execute immediate 'alter procedure test proc1 compile'; 5 6 end; 7 / . (Hang). Very simple, isn’t it? Written by Dion Cho. September 16, 2010 at 2:06 am.

dioncho.wordpress.com

Batching NLJ optimization and ordering | Dion Cho - Oracle Performance Storyteller

https://dioncho.wordpress.com/2010/08/16/batching-nlj-optimization-and-ordering

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Batching NLJ optimization and ordering. You might be aware of the batching nested loops join(batching NLJ) optimization introduced at Oracle 11g. For who are not aware of this new feature, let me show you two different execution plans(Oracle 10g vs. 11g) of the same SQL. To save your time, let me show you the result of the above test case with some comments appended. The simple explanation is :. This could be a limitation when you...

UPGRADE TO PREMIUM TO VIEW 1 MORE

TOTAL LINKS TO THIS WEBSITE

8

OTHER SITES

dionchemicals.com

Dion | Surf Industry Materials Since 1962

Our Bennett – Dion Polyurethane blanks are considered to be the best in the world. Our Bennett – Dion Blank Formula is known for its whiteness, small cell structure, consistent density, strength and lightness. Why Choose a Bennett -Dion Blank? Guaranteed High Quality Surfboard blanks. Great Range of Blanks sizes. Custom made with any Rocker. Best customer service in the industry. We are also your one stop shop for all Surfboard Making Materials, check out our resin, glass etc. 6’9″ Fish Blank.

dionchen.com

dionchevrolet.com

Dion Chevrolet Buick GMC Inc | Concessionaire GM situé à Magog proche de Sherbrooke

Dion Chevrolet Buick GMC Inc. Recherche - inventaire des véhicules neufs 2017. Salle d’exposition des modèles. Soumission pour véhicule neuf. Rendez-vous pour un essai routier. Recherche - inventaire des véhicules d'occasion. Trouvez mon prochain véhicule. Formulaire de la valeur d'échange. Vérifiez votre admissibilité pour le crédit. SERVICE, PIÈCES ET ACCESSOIRES. Centre d'information sur des pneus. Demande de pièces et accessoires. Établissement et heures d'ouverture. Rechercher dans les stocks. Dion ...

dionchevrolet.net

Dion Chevrolet Buick GMC Inc in Magog | A Waterloo and Sherbrooke Chevrolet, Buick & GMC Dealership Alternative

Dion Chevrolet Buick GMC Inc. Book A Test Drive. Get Pre-Qualified For Credit. SERVICE, PARTS and ACCESSORIES. Parts and Accessories Request. Service, Parts and Accessories. Dion Chevrolet Buick GMC Inc in Magog. 2017 Acadia Liquidation ( 4 only left). Service, Parts and Accessories in Magog for Sherbrooke and Waterloo GMC, Buick and Chevrolet Customers. Goodyear Ultra Grip Winter Tire Installed from $99.95. 2017 Acadia Liquidation ( 4 only left). 2017 GMC Acadia SLE. See dealership for more details.

dionchi.wordpress.com

BLUE LION GENERATION | Just another WordPress.com weblog

December 10, 2009. Aditya si bocah karet. 8212; dionchi @ 11:15 am. Selain lihai melipat tubuh, Aditya, siswa kelas satu sekolah dasar itu juga ahli menulis di atas telapak kaki yang dilipatnya. June 16, 2008. The Incredible Hulk …. Filed under: film favoritku. 8212; Tags: resensi film the incredible hulk. The incredible hulk photo gallery. Trailer the incredible hulk. 8212; dionchi @ 7:36 am. The Incredible Hulk gallery . Pencetak Gol Fantastis …. 8212; Tags: all about Nihat Kahveci. June 15, 2008.

dioncho.blogspot.com

Dion Cho - Oracle Performance Storyteller

Dion Cho - Oracle Performance Storyteller. Thursday, December 16, 2010. 表T1, T2, T3を作ります。 SQL create table t1(c1 number, c2 number);. SQL create table t2(c1 number, c2 number);. SQL create table t3(c1 number, c2 number);. グローバルヒントを使って、結合順序を T1- T2- T3. SQL explain plan for. 2 select * from. 5 /* leading(v.t1 v.t2 t3) */. 6 vc1 as v c1,. 7 vc2 as v c2,. 8 t3c2 as t3 c2. 14 t1, t2. 16 t1c1 = t2.c1) v,. 19 vc1 = t3.c1. Id Operation Name Rows Bytes Cost (%CPU) Time. 0 SELECT STATEMENT 1 65 7 (15) 00:00:01.

dioncho.wordpress.com

Dion Cho - Oracle Performance Storyteller | We are natural born scientists

Dion Cho – Oracle Performance Storyteller. We are natural born scientists. Interesting case of the restriction of global hints. One of my colleagues sent following test case, of which he couldn’t control the join order with hints. Create objects – table t1, t2 and t3. SQL create table t1(c1 number, c2 number); Table created. SQL create table t2(c1 number, c2 number); Table created. SQL create table t3(c1 number, c2 number); Table created. Now Let’s set the join order as T1- T2- T3. Written by Dion Cho.

dionchristmas.com

Dion Christmas Galleries

Draw what you want. Draw what you want. Select a year at the top to see that year’s photo gallery. Powered By Freak Theme.

dionchzlhbxmapk.blogspot.com

Zulma

Monday, March 23, 2009. With all the bright bold colors of the season, I am Paul Frank Handbags. To feel over stimulated. Which is why I am so drawn to this subtle shade of taupe from Jimmy Choo! It’s calm and neutral, and after my latest purchase- an electric blue Tod’s tote (my “Trend” bag of the season)- I. Is this the end of the High Street? Tips on Baby Constipation Treatment. Avril Lavigne Perfumes Name Unveiled {Celebrity F. Perlabella Anti-Aging Skin Care Line. Bin Laden attacks Arab leaders.

dioncitylandscapes.com

Dion City Landscapes

Visit us on Facebook, Twitter, and Pinterest. Benches and Custom Carpentry. Welcome to DCL Outdoor Contracting. NYC based landscaping company that specializes in hardscaping, design and custom carpentry. Schedule A Free Appointment. Licensed New York City Contractor. Check out Dion City Landscapes, Inc. on Yelp. DION CITY landscapes, Inc. Outdoor Contracting 646-761-3031 info@dcloutdoorcontracting.com.

dionclaus.com

www.dionclaus.com geregistreerd via Argeweb | webhosting en domeinregistratie

Welkom op dionclaus.com. De domeinnaam www.dionclaus.com is geregistreerd in opdracht van een klant van Argeweb. Argeweb registreert domeinnamen voor bedrijven en particulieren. Levert Argeweb ook diensten als virtual private server. U kunt hieronder checken of uw domeinnaam vrij is.