/explore
|
You are here 
|
savvinov.com | ||
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
alexzeng.wordpress.com
|
|
| | | | | Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use... | |
| | | | |
hourim.wordpress.com
|
|
| | | | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | |
| | | | |
tanelpoder.com
|
|
| | | Reading the following article about PARALLEL hint by Jonathan Lewis made me remember a somewhat related gotcha with parallelism. Often when creating (or rebuilding) an index on a large table, doing it with PARALLEL x option makes it go faster - usually in case when your IO subsystem is not the bottleneck and you have enough spare CPU capacity to throw in. A small example below: Tanel@Sol01> create table t1 as select * from all_objects; Table created. Tanel@Sol01> create index i1 on t1(object_id); Index created. Tanel@Sol01> exec dbms_stats.gather_table_stats(user, 'T1', cascade=>true, no_invalidate=>false); PL/SQL procedure successfully completed. Ok, for whatever reason I need to rebuild my index, and for speed I do it in parallel: - Linux, Oracle, SQL perf... | ||
