The social network for Oracle people
-
http://linux-oracle-dba.blogspot
- Male
- muscat
- Oman
- Blog Posts (3)
- Discussions (2)
- Events
- Groups (10)
- Featured Photos
- Photo Albums
- Featured Videos
http://linux-oracle-dba.blogspot's Groups
-
OracleTURK
94 members
-
Performance Tuning
241 members
-
Oracle Job's
213 members
-
Oracle HA
50 members
-
Oracle_on_Windows
12 members
Gifts Received
http://linux-oracle-dba.blogspot has not received any gifts yet
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 HintsWhat is index hint and what hint is notIndex hint is suggestion to optimizer not a command to it. If u provide hint…Continue
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
http://linux-oracle-dba.blogspot added a discussion to the group Oracle Job's
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
http://linux-oracle-dba.blogspot added a discussion to the group Performance Tuning
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
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/"
http://linux-oracle-dba.blogspot added a discussion to the group Database Admins
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
Surachart Opun left a comment for http://linux-oracle-dba.blogspot"your blog is great... thank you for sharing"
http://linux-oracle-dba.blogspot left a comment for Surachart Opun"hi
i saw your blog , really Good one !!!
have a nice day !!!"
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 ;)"
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/"
Profile Information
- About Me:
- oracle dba
http://linux-oracle-dba.blogspot.com/
- My Website:
- http://linux-oracle-dba.blogspot.com/
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
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
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
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)
- 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.
