Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Connor McDonaldIs 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...
Connor McDonaldGet 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,...
Chris SaxonUnderstanding 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...
Chris SaxonUSING 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...
Connor McDonaldRequirements 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...