Questions

<b>Use Case:</b> We are implementing partitioning in the AQ to enable batch processing with array dequeue while ensuring:1. Ordering maintained per partition (FIFO).2. Possibility to Array Deqeue on Application side. ( Unless provided a more performant solutio...

Hi,Tom:The recycle bin is empty, and no DDL statements similar todrop BIN$MmWdiJOqKt7gY0eQFAotmw==$0 were executed.However, the following error was reported:Caused by: java.sql.BatchUpdateException: ORA-00604: error occurred at recursive SQL level 1ORA-38301: ...

how can i import a file version 24.2.2 into 24.1.7 ...

Hello,Please advise on how to create List Partition with Range Sub-Partition.Also on the Range Sub-Partition like to have name custom defined based on each day like DEL_AUG_082019.<code>CREATE TABLE "DBB_USER"."STG_ES_STS" ( "CS_ID" CHAR(7), "CWIN" NUMBER(9), ...

Hi,I am getting error Ora-08103: Object No longer exists when select query uses type object in a procedure.below the code used for select query procedure upp_rate is l_typ_detail_list typ_detail_list; begin select typ_oc_sec_detai...

Why is the size of shared pool in the query not exactly the same as in the init.ora (52,428,800)?It is slightly large (54,361,560). SVRMGR> select pool,to_char(sum(bytes),'999,999,999') from v$sgastat group by pool ; POOL TO_CHAR(SUM(-----------...

Greetings,how do I calculate the temp space and undo space required for the "ALTER TABLE $SCHEMA.$table MOVE LOB ($lob) STORE AS (TABLESPACE $NEW_LOB_TABLESPACE)"We have very large segments, and currently have a small undo <code>-- show MAX SEGMENT SIZESELECT ...

I searched extensively but I couldn't find clarity, whether Primary Key (In this case, composite of Foo1ID and Foo2ID) should be selected into foo_cursor, even if not used in the procedure?Is it sufficient to rely on some internal mechanism (ROWID?) that will ...

Sometimes when I use a QB_NAME hint, when I later look at the execution plan, there is no record of that query block name.Why is this the case ?...

Hi Tom,It was run a impdp command with remap_table in parfile with sqlplus in Oracle Linux but it run a full import. We've lost impdp logs, How could we get information about the impdp command that was run and clarify the issue?Thanks a lotRegards!...

hi Tom,when a remote table is referred in sub query then it is not retrieving the data and it throws error.refer the below sql, I am trying to get latest record, so I am doing order by DATEM in sub query and taking first record in outer sql. here, OWNERDOCUMEN...

HiWe are looking to take a schema(abc) from our database to to a different server with a new schema name.I am looking to find what are the dependencies on the abc schema in our packages/procedure/functionsand is there anything else i should be looking at.regar...

Hello Ask-Tom-Team,I came across this Oracle documentation „Deploying Oracle RAC on Docker“:https://www.oracle.com/technetwork/database/options/clustering/rac-ondocker-bp-wp-5458685.pdfSpecifically the sentence:OracleRAC on Docker supports the <b>non-privilege...

Dear Ask Tom team memebers.Is it possible to to measure sql effectivity via computed throw away row count ?Its clear that optimizer tries to build the plan to minimize throw away rows for the next steps in the plan. So it tries to send only relevant rows to ne...

Hello everyone,I am trying to create a CSV file and then attach it to an email and send the email but I am receiving the following error: PLS-00201: identifier 'APEX_DATA_EXPORT.T_EXPORT' must be declaredBelow is the code I am attempting to run:<code>declare ...

On my test database, Oracle scheduler seems a bit lethargic.In my case, I am inserting data into 6 different tables ( million plus rows in each table ), these are done as insert into / select from via a stored procedure, I have a package with 6 procedures. In ...

I get a .csv log file dropped from a microsoft server to a linux server using winSCP. The column REASON, is enclosed with "" and includes LF. Here is a 2 record snippet of the file: 5826431,5826431,,,New,17255483,,,,2e4cf893-078d-45b3-b548-2dc3c970ff25,5826431...

Hello Team,First of all, thanks for all the good work you are doing.It would be great if you can help us understand how we can improve timings of query executed on a DB link.Consider an Oracle instance (DB1) that can talk with another oracle instance (DB2) via...

Oracle's Critical Patch Update Advisory publishes Oracle Patch number along with a matrix of CVE's that are on some Risk Matrix.For some reason, I am unable to see any way to see what CVE's a patch number affects.Am I missing something or is this not a possibi...

In our production environment ,a 2 nodes 11.2.0.4 rac ,the parameter parallel_force_local=true is set.one sql use hint parallel ie: SELECT /*+ PARALLEL(t1 8) */ .in sql execute plan we found Parallel Execution on 2 instanceParallel Execution Details (DOP=8 , S...