What Are Bind Variables?

1.	What Are Bind Variables?
Answer» With bind variable in SQL, ORACLE can cache QUERIES in a single time in the SQL cache area. This avoids a HARD parse each time, which saves on VARIOUS locking and latching resource we use to check OBJECT existence and so on. With bind variable in SQL, oracle can cache queries in a single time in the SQL cache area. This avoids a hard parse each time, which saves on various locking and latching resource we use to check object existence and so on.

Answer»

With bind variable in SQL, ORACLE can cache QUERIES in a single time in the SQL cache area. This avoids a HARD parse each time, which saves on VARIOUS locking and latching resource we use to check OBJECT existence and so on.

With bind variable in SQL, oracle can cache queries in a single time in the SQL cache area. This avoids a hard parse each time, which saves on various locking and latching resource we use to check object existence and so on.

Discussion

No Comment Found

Related InterviewSolutions

What Is A System Change Number (scn)?
What Is The Main Purpose Of Checkpoint In Oracle Database? How Do You Automatically Force The Oracle To Perform A Checkpoint?
What Happens When We Fire Sql Statement In Oracle?
What Is The Use Of Large Pool, Which Case You Need To Set The Large Pool?
What Does Database Do During The Mounting Process?
What Are Log File States?
What Are Bind Variables?
What Is Difference Between Oracle Sid And Oracle Service Name?
What Is The Difference Between Data Block/extent/segment?
What Is The Difference Between Pga And Uga?

What Are Bind Variables?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment