Oracle Database Discussions

how can we extract the "bind" variables for a given query running in 10g? The performance of a query may vary based on the parameters supplied to it. For example, a query like the following

SELECT * FROM CUSTOMER_ORDERS WHERE CUSTOMER = :CUST_ID

.might run differently when the :CUST_ID is "123" who may have very few orders versus "456" who may have tens of thousands of orders.

So, if we see a spike in the system due to a query, we need visibility into what the exact query syntax and values are for any database session. We're aware of an Oracle view called V$SQL_BIND_CAPTURE, but what we're finding with this view is that it's only a snapshot of variables that are refreshed on an interval. That view does not give us a live view into what values are being used in the various sessions in realtime.

If someone ould provide us with some SQL (or other means) to do get a realtime view into the SQL and variables currently running in the database, it would be greatly appreciated.