Ask The Oracle Mentors

Recently Answered

	Tuning - execution plan changed I have a query that used to run under 2 seconds but it is now running over 2 minutes. In other environments, it is still running in 2 seconds. In the execution plan, I only see a difference in the order of filter and E-Rows/byte. Could you please suggest what...
	Use nonprefix local index Tom,Could you please explain for which scenario I should consider non-prefix local index over prefix local index?Thank you very much for you time....
	Returning a named constant in a SQL query Is it possible to return a named constant in a SQL query? In other words, let's say we want to return the equivalent of:SELECT 'Business rule violation: '\|\|to_char(bsnss_rule) FROM violation_table;But, we would like to pick up 'Business rule violation: ' f...
	SPM> SQL in AWR to tie SQL_ID <> SQL_HANDLE <> PLAN_HASH_VALUE Is there a way to tie SQL_ID with SQL_HANDLE in SQL Plan Baseline (SPM) along with it’s plan hash value in AWR history. It appears that we can tie this in cursor cache but not from the history. I’m working with a customer who is dumping this data periodically ...
	The date That appears on the Grid is different than the one downloaded Dear Tom ,When Downloading the data from interactive Grid it gives me wrong date (the date on excel is different from the one that appears on the grid)It Gives me 1905 for the yearwould you please inform me how to solve this problemThank YouBest RegardsUpdate:...