adaptive cursor sharing and bind peeking
From: amonte <ax.mount_at_gmail.com>
Date: Thu, 30 May 2013 06:53:14 +0200
Message-ID: <CABV7K9tUZWSjPsnGiBASEzQZWSnbA3qO71B6Npr4fxaz0YS_rw_at_mail.gmail.com>
Hi
When adaptive cursor sharing is in action does the database peek the bind variables over and over again? i.e does the database find out the bind literal value in order to determine weather the cursor should choose one plan or another?
Date: Thu, 30 May 2013 06:53:14 +0200
Message-ID: <CABV7K9tUZWSjPsnGiBASEzQZWSnbA3qO71B6Npr4fxaz0YS_rw_at_mail.gmail.com>
Hi
When adaptive cursor sharing is in action does the database peek the bind variables over and over again? i.e does the database find out the bind literal value in order to determine weather the cursor should choose one plan or another?
Thank you
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 30 2013 - 06:53:14 CEST