Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Tuesday, April 21, 2009

Oracle and Sun Micro System - What is the next version of Java

Oracle Corp (ORCL.O) plans to buy Sun Micro systems Inc (JAVA.O) for more than $7 billion. Both are two main players in the computer world. 

How this going to affect the Oracle products and Sun Micro systems products? Specially Sun gives out many free services and one thing we cannot forget is JAVA. Are they going to be unchanged?

Anyway these kind of news always affect the share market.

Monday, August 11, 2008

Oracle 10g Hints for Performance Improvement

List of Oracle 10g Hints for the Oracle Optimizer so that you can dictate the execution plan of a query/statement..

Undocumented Hints ( You won't find this mentioned under Oracle Official documentation).. They are TOP Secret!


  • bypass_recursive_check
  • bypass_ujvc
  • cache_cb
  • cache_temp_table
  • civ_gb
  • collections_get_refs
  • cube_gb
  • cursor_sharing_exact
  • deref_no_rewrite
  • dml_update
  • domain_index_no_sort
  • domain_index_sort
  • dynamic_sampling
  • dynamic_sampling_est_cdn
  • expand_gset_to_union
  • force_sample_block
  • gby_conc_rollup
  • global_table_hints
  • hwm_brokered
  • ignore_on_clause
  • ignore_where_clause
  • index_rrs
  • index_ss
  • index_ss_asc
  • index_ss_desc
  • like_expand
  • local_indexes
  • mv_merge
  • nested_table_get_refs
  • nested_table_set_refs
  • nested_table_set_setid
  • no_expand_gset_to_union
  • no_fact
  • no_filtering
  • no_order_rollups
  • no_prune_gsets
  • no_stats_gsets
  • no_unnest
  • nocpu_costing overflow_nomove
  • piv_gb
  • piv_ssf
  • pq_map
  • pq_nomap
  • remote_mapped
  • restore_as_intervals
  • save_as_intervals
  • scn_ascending
  • skip_ext_optimizer
  • sqlldr
  • sys_dl_cursor
  • sys_parallel_txn
  • sys_rid_order
  • tiv_gb
  • tiv_ssf
  • unnest
  • use_ttt_for_gsets


Documented Hints

  • all_rows
  • first_rows
  • first_rows_1
  • first_rows_100
  • choose
  • rule
  • full
  • rowid
  • cluster
  • hash
  • hash_aj
  • index
  • no_index
  • index_asc
  • index_combine
  • index_join
  • index_desc
  • index_ffs
  • no_index_ffs
  • index_ss
  • index_ss_asc
  • index_ss_desc
  • no_index_ss
  • no_query_transformation
  • use_concat
  • no_expand
  • rewrite
  • norewrite
  • no_rewrite
  • merge
  • no_merge
  • fact
  • no_fact
  • star_transformation
  • no_star_transformation
  • unnest
  • no_unnest
  • leading
  • ordered
  • use_nl
  • no_use_nl
  • use_nl_with_index
  • use_merge
  • no_use_merge
  • use_hash
  • no_use_hash
  • parallel
  • noparallel / no_parallel
  • pq_distribute
  • no_parallel_index
  • append
  • noappend
  • cache
  • nocache
  • push_pred
  • no_push_pred
  • push_subq
  • no_push_subq
  • qb_name
  • cursor_sharing_exact
  • driving_site
  • dynamic_sampling
  • spread_min_analysis
  • merge_aj
  • and_equal
  • star
  • bitmap
  • hash_sj
  • nl_sj
  • nl_aj
  • ordered_predicates
  • expand_gset_to_union
Blog Widget by LinkWithin