AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 12 min 18 sec ago

Finding records certain time apart

Tue, 01/16/2018 - 00:00
Hi, I have a following table: <code>create table t ( user_id varchar2(10), clinic varchar2(50), visit_dt date ); INSERT INTO T VALUES ( 012, 'oncology', TO_DATE( '08-APR-2008') ); INSERT INTO T VALUES ( 012, 'oncology', TO_DATE( '21-APR-2008'...

DBMS_AQ.LISTEN to listen to a Single/Multi-Consumer Queue

Sat, 01/13/2018 - 00:00
Dear Experts, Need your guidance/suggestions to resolve this issue: Part of oracle advance queueing implementation, we've to dequeue the message as soon as it has been enqueued into the queue. This should happen immediately without any manual inter...

Possibility of functional index/key in foreign key

Fri, 01/12/2018 - 00:00
Hi, I want to ask if there is possibility to use functional index/key in foreign key. As an example : In T1 there is opera_user_id column, with index upper(opera_user_id), in T2 a column ID, indexed as PK. From T1 there is FK defined by the column ...

Is there a way to search .fmb or .rdf for a string

Thu, 01/11/2018 - 00:00
Is there a way to search .fmb or .rdf for a string outside of the development tools?

Create table using existing table and copy column defaults

Thu, 01/11/2018 - 00:00
Hi Tom, I am creating table "tmp_pks1" with SID as DEFAULT 1. <code>SQL> CREATE TABLE tmp_pks1(SID NUMBER DEFAULT 1, NAME VARCHAR2(50) NOT NULL); Table created. SQL> CREATE TABLE tmp_pks2 AS SELECT * FROM tmp_pks1; Table created. SQ...

Why we should segment advisor to get fragmented space for tablespaces where segment space management is AUTO

Wed, 01/10/2018 - 00:00
Hi AskTom Team, Normally, to get fragmentation we do (num_rows*avg_row_length) from dba_tables and compare that with bytes in dba_segments to see if there is any fragmentation. But for tablespaces with segment space management "AUTO" oracle re...

oracle commit writes to redo, but not to datafiles

Wed, 01/10/2018 - 00:00
Hi Tom, I want to verify once the commit the transaction, only writes to redo log, but does not write to data files. How the verify the situation??

Very slow network interaction between Oracle DB and java application

Wed, 01/10/2018 - 00:00
I have a problem with my Oracle DB network speed. First of all, what's the essence of the problem. There are java application on my computer and Oracle DB on a remote server. Connection speed between them is about 2,5MB/s. I execute in my java app...

Get rows for first where condition

Wed, 01/10/2018 - 00:00
we face some issue as <code>select * from t where a is null or b is null or c is null</code> the question is if the query find the first where (a is null) then retrieve it only and not retrieve other where statment(b is null or c is null) can...

SPM accepted plan with different bind variable

Mon, 01/08/2018 - 00:00
<code>Hi Tom, I have POC on my lab about SQL Plan Management and found some thing that not make sense. My Oracle Database Version is "Oracle Database 11g Enterprise Edition Release - 64bit Production" with a single node, parameter ...

get file names in a directory not working anymore due to SQJ is no longer supported by 12.2 or later version

Mon, 01/08/2018 - 00:00
Hi Tom, I have been using your script as listed below to get the list of the file names in a directory and insert them into a global temporary table. Everything was working fine until last week I have upgraded my database to 12.2 and the script i...