Oracle Community

The social network for Oracle people

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

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

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

 

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

Latest Posts

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 Hints What is index hint and what hint is not Index hint is suggestion to optimizer not a command to it. If u provide…

Tagged: 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 f…

Tagged: http://linux-oracle-dba.blogs…

Started Dec. 10, 2009

Gifts Received

Gift

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

Give http://linux-oracle-dba.blogspot a Gift

Latest Activity

December 14, 2009
December 11, 2009
December 11, 2009
http://linux-oracle-dba.blogspot added a discussion to the group Oracle Job's
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…
December 11, 2009
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…
December 11, 2009
December 11, 2009
http://linux-oracle-dba.blogspot added a discussion to the group Database Admins
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 car…
December 11, 2009
December 10, 2009
MY blog
December 10, 2009
December 10, 2009
http://linux-oracle-dba.blogspot.com/2009/11/explain-plan.html
December 10, 2009
December 10, 2009
I am jazzed by Oracle community !!!!!!!
December 10, 2009
December 10, 2009
December 10, 2009
December 10, 2009

Profile Information

About Me:
oracle dba

http://linux-oracle-dba.blogspot.com/
My Blog:
http://linux-oracle-dba.blogspot.com/
My Website:
http://linux-oracle-dba.blogspot.com/

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

http://linux-oracle-dba.blogspot

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 hint:

- Select /*+CHOOSE*/ col 1 , col2
From …..



to read more : visit http://linux-… Continue

Posted on December 11, 2009 at 2:57am —

http://linux-oracle-dba.blogspot

Explain plan


What is SQL–PLAN
The EXPLAIN PLAN shows execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements.… Continue

Posted on December 10, 2009 at 10:30am —

http://linux-oracle-dba.blogspot

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 : http://linux-oracle-dba.blogspot.com/2009/12/overview-and-requirements-for-oracle.html

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 ;)
 
 
 

© 2010   Created by Eddie Awad.   Powered by .

Badges  |  Report an Issue  |  Terms of Service