Ask The Oracle Mentors

Recently Answered

	Is there a view that a DBA can query to find out if "ORA-02393: exceeded call limit on CPU usage" Greetings,I've seen when "cpu_per_call" limit is reached. ORA-02393 is sent to the SQL Plus. Is there a view that a DBA can query to find out if "ORA-02393: exceeded call limit on CPU usage" occurs to applications using the database since it isn't written to...
	Get date filter from a table in Oracle? I would like to know how to access date column from a table and use it as date filter for another large volume table..I have the following query that currently uses a date in the filter criteria and it gets completed in about 10 to 15 minutes.<code>select a,b,...
	Understanding reused values for sql_id, address, hash_value, plan_hash_value in v$sqlarea good evening,I have a sql statement with the following information in v$sqlarea<code>select sql_id, address, hash_value, plan_hash_value from v$sqlarea where sqltext=<string to identify my query>sql_id \|address \|hash_value\|plan_hash_valuecv65zdur...
	USING REGEXP_REPLACE to remove duplicates Sorted input:<code>select regexp_replace( 'three0, three, two, two, two2, two3, three, three, three, one1, one1', '([^,]+)(,\1)+(,\|$)', '\1\3') from dual;three0, three, two, two2, two3, three, one1</code>unSorted input:<code>select regexp_replace( 'three0, thr...
	Requirements to set up an Oracle Directory for WRITE access We have several existing Oracle Directories set up to allow reading CSV files that work fine, and a couple of them work OK to Write new files. I have been trying to add a new Directory definition pointing to a different path and cannot get it to work. I am i...