Oracle Community

The social network for Oracle people

http://linux-oracle-dba.blogspot
  • Male
  • muscat
  • Oman
Share on Facebook
Share Twitter

Http://linux-oracle-dba.blogspot's Friends

  • Arnoud Roth
  • Yann Neuhaus
  • Surachart Opun

http://linux-oracle-dba.blogspot's Groups

Gifts Received

Gift

http://linux-oracle-dba.blogspot has not received any gifts yet

Give a Gift

 

http://linux-oracle-dba.blogspot's Page

Latest Posts

Loading… Loading feed

http://linux-oracle-dba.blogspot's Discussions

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/Index HintsWhat is index hint and what hint is notIndex hint is suggestion to optimizer not a command to it. If u provide hint…Continue

Tags: hints, index

Started Dec 11, 2009

please give your suggestions for my blog http://linux-oracle-dba.blogspot.com/

i have created a blog Linux - oracle - DBA (http://linux-oracle-dba.blogspot.com/) , this is generally created for mid-level Oracle DBAs and newbie /aspirant in Oracle DBa field.I need suggestion…Continue

Tags: http://linux-oracle-dba.blogspot.com/

Started Dec 10, 2009

Latest Activity

Yann Neuhaus and http://linux-oracle-dba.blogspot are now friends
Dec 14, 2009
http://linux-oracle-dba.blogspot posted blog posts
Dec 11, 2009
http://linux-oracle-dba.blogspot posted discussions
Dec 11, 2009
http://linux-oracle-dba.blogspot added a discussion to the group Oracle Job's
Thumbnail

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/Index HintsWhat is index hint and what hint is notIndex hint is suggestion to optimizer not a command to it. If u provide hint it doesn’t h=mean that it will definitely get used . this decision is taken care by Optimizer itself.Specifying index:Select /*+FULL(table_name) */ col1 ,col2From ….Using Index hints:1 ) using CHOOSE hint:- Select /*+CHOOSE*/ col 1 , col2From …..to read more : visit…See More
Dec 11, 2009
http://linux-oracle-dba.blogspot added a discussion to the group Performance Tuning
Thumbnail

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/Index HintsWhat is index hint and what hint is notIndex hint is suggestion to optimizer not a command to it. If u provide hint it doesn’t h=mean that it will definitely get used . this decision is taken care by Optimizer itself.Specifying index:Select /*+FULL(table_name) */ col1 ,col2From ….Using Index hints:1 ) using CHOOSE hint:- Select /*+CHOOSE*/ col 1 , col2From …..to read more : visit…See More
Dec 11, 2009
http://linux-oracle-dba.blogspot left a comment for Arnoud Roth
"thanks for accepting my friend request have a nice day ahead sunil http://linux-oracle-dba.blogspot.com/"
Dec 11, 2009
http://linux-oracle-dba.blogspot added a discussion to the group Database Admins
Thumbnail

knowledgeSharing initiative from http://linux-oracle-dba.blogspot.com/

http://linux-oracle-dba.blogspot.com/Index HintsWhat is index hint and what hint is notIndex hint is suggestion to optimizer not a command to it. If u provide hint it doesn’t h=mean that it will definitely get used . this decision is taken care by Optimizer itself.Specifying index:Select /*+FULL(table_name) */ col1 ,col2From ….Using Index hints:1 ) using CHOOSE hint:- Select /*+CHOOSE*/ col 1 , col2From …..to read more : visit…See More
Dec 11, 2009
http://linux-oracle-dba.blogspot left a comment for Surachart Opun
"Its my pleasure !!"
Dec 10, 2009
Surachart Opun left a comment for http://linux-oracle-dba.blogspot
"your blog is great... thank you for sharing"
Dec 10, 2009
http://linux-oracle-dba.blogspot updated their profile
Dec 10, 2009
http://linux-oracle-dba.blogspot left a comment for Surachart Opun
"hi i saw your blog , really Good one !!! have a nice day !!!"
Dec 10, 2009
Surachart Opun left a comment for http://linux-oracle-dba.blogspot
"Nice to meet you... your blog is nice... don't forgot to tour my blog ;)"
Dec 10, 2009
http://linux-oracle-dba.blogspot left a comment for Surachart Opun
"Hi accept my friend request : sunil http://linux-oracle-dba.blogspot.com best blog for mid-level Oracle DBAs and Aspirants \0/"
Dec 10, 2009

Http://linux-oracle-dba.blogspot's Blog

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/

knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/



Index Hints





What is index hint and what hint is not

Index hint is suggestion to optimizer not a command to it. If u provide hint it doesn’t h=mean that it will definitely get used . this decision is taken care by Optimizer itself.



Specifying index:

Select /*+FULL(table_name) */ col1 ,col2

From ….





Using Index hints:



1 ) using CHOOSE… Continue

Posted on December 11, 2009 at 2:57am

Explain plan

What is SQL–PLAN

The EXPLAIN PLAN shows execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements.

It’s a is the sequence of operations performed by Oracle to run the statement.



How Execution Plans Can… Continue

Posted on December 10, 2009 at 10:30am

Overview and Requirements for Oracle RAC Part 2

Preinstallation tasks :



I n this chapter we will see how to check system requirement s are ready / complete to install clusterware and Oracle Application Cluster.



What is CVU (Cluster Varification Utility)

CVU used to perform system checks before starting Clusterware and Oracle Real Application installation.

Syntax for CVU



$ /mountpoint/crs/Disk1/cluvfy/runcluvfy.sh options





read more here :… Continue

Posted on December 10, 2009 at 2:01am — 1 Comment

Comment Wall (2 comments)

You need to be a member of Oracle Community to add comments!

Join Oracle Community

At 10:49am on December 10, 2009, Surachart Opun said…
your blog is great... thank you for sharing
At 5:37am on December 10, 2009, Surachart Opun said…
Nice to meet you... your blog is nice... don't forgot to tour my blog ;)
 
 
 

© 2013   Created by Eddie Awad.

Badges  |  Report an Issue  |  Terms of Service