Questions

Hi Team,This is the first time I am asking question on asktom, while I am very much thankful to the solutions you have provided and kept helping people always.We want to add 60 CLOB columns to the table which is around 17TB in size. This is a datawarehouse DB...

Dear TomI have Oracle EBS 12.8 with Oracle 12C. I upgraded my database to 19C with the latest patches, and everything is working fine, except my DBlink with another MS SQL server. Note that it was working before the upgrade. I dropped the DBlink and re-created...

Hi,I see Oracle document shows an example of insert statement for fast ingest as INSERT /*+ MEMOPTIMIZE_WRITE */ INTO test_fast_ingest VALUES (1,'test');Can fast ingest using memoptimize be used for insert statement, that is INSERT as select...INSERT /*+ MEM...

I’m having trouble with the parallel execution of an Oracle SQL query for creating indexes on <b>separate table (assume each table have single index)</b>.The performance boost isn’t even close to what I was hoping for. I therefore need your help in determining...

I created a new project in Visual Studio 2019 with Entity Framework v6.5.1, Oracle.ManagedDataAccess v23.8, and Oracle.ManagedDataAccess.EntityFramework v23.8.When I add an ADO.NET Entity Data Model, I select EF Designer from the database. It then prompts me f...

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...

Hi,While listening through the video "Developer Coaching - Oracle Database 23ai - Zero Slides, Zero Marketing, 100% Live Demo" there mentioned that we can set the oracle wallet path to system: to access the windows level certificates, but when I tried the same...

hello I have a table FCM PARTITIONED ON (Q) Column BY RANGE INTERVAL( NUMTODSINTERVAL(7, 'DAY')) i have an issue that "current/active" partition becomes stale several times a day vast majority of DMLs on the table are INSERTS (basic inserts , with val...

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: ...

Hi TeamPlease find re-producible data available in LiveSQL shared link -> https://livesql.oracle.com/ords/livesql/s/c9r56fcrqizrcrc5aiep4hrpnRequirement is to fetch last record for "t_id" column value for each "code" + "status" column values respectively.Looki...

<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...

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...