/explore
|
You are here 
|
kerryosborne.oracle-guy.com | ||
| | | | |
www.binovarghese.com
|
|
| | | | | Oracle creates a memory area, known as the context area for processing an SQL statements, which contain all the informations needed for procesing the SQL statements... | |
| | | | |
orastory.wordpress.com
|
|
| | | | | There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID).... | |
| | | | |
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... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | |||
