Questions

Hope you're doing well.I'm reaching out to get your inputs on statistics gathering in our Oracle Autonomous Database (version 19c), which we use to support our integration workloads.We have a few very large tables (approximately 70 million records each) that s...

I want to upload multiple XLSX files, each containing multiple sheets. The data from each sheet should be inserted into a table with the same name as the sheet (the tables already exist) using Oracle APEX. Is this possible?...

Hi Chris/Connor. We have a production 12c Database (12.2.0.1) and have enabled a particular SQL Plan Baseline for a high-load query, but, for some reason, it's not being used. Baseline is ENABLED and FIXED, and REPRODUCED column reads YES, but I can't see a da...

Hi Tom,What I need to do is, to monitor a table for changes. For this a trigger needs to be setup. But my doubt is, if we create a trigger after insert or update of my table column on my table for each row, and the trigger does some time consuming task like DB...

I attended a Hotsos session by Toon Koppelaars yesterday morning on Semantic Query Optimization. Among other interesting topics, Toon lamented the lack of any DBMS implementing SQL "assertions". By which he meant a database-enforced constraint than encompass...

I have a requirement where I have to refresh tables from PROD to DEV. But refresh needs to be done in such a manner that partitioned table should be refreshed with its latest top 10 partitions and non partitioned table should be refreshed fullI am using DBPUMP...

Hi Tom,Oracle puts a TM lock on a table even if no rows are affected by a DML statement:TX_A>create table t (x int);Table created.-- just to show there are no locks on the table:TX_A>alter table t move;Table altered.-- in another session (marked as TX_B) we no...

Hi Tom,I am trying to view explain plan for a select statement in Livesql built on 19c oracle version.I am able to view the explan result using select * from table(dbms_xplan.display_cursor); but i see Error: cannot fetch last explain plan from PLAN_TABLE ...

how can i insert and read numeric value larger than 1000 digits into blob column in oracle...

El erro al crear un Interactive Grid en la versión Oracle APEX 24.2.0 en versiones anteriores funcionaba sin problemas ORA-01400: cannot insert NULL into ("APEX_240200"."WWV_FLOW_IG_REPORTS"."ID")...

We are currently in the process of upgrading our Oracle database servers from RHEL 7 to RHEL 8. We are considering two possible approaches:Migrating to a new server built with RHEL 8.Performing an in-place upgrade on the existing server.In both approaches, we ...

Hello!We encountered strange (and logically inconsistent) CBO behavior. To provide some context: we are working with an EAV (entity-attribute-value) schema, all objects are stored in a single table, let's call it "my_objects", another table, "object_ancestry",...

Environment InformationDatabase : Oracle Database 19c (Multi-Tenant Architecture) - Version 19.25.0.0.0GoldenGate : Oracle GoldenGate Microservices 19cReplication Setup : Data replication will be configured between:Source : On-premises database server (Server ...

Hello Chris. Hello Connor, I’m struggling with a performance issue … We have a single big table (167 million of rows, 118 columns). For ad hoc queries we have created a simple Apex application with 15 most important columns as filters. To avoid long running ...

After accessing a few questions on Ask TOM, I'm getting an error:400 Bad RequestRequest Header Or Cookie Too LargeThis "solves itself" if I try later - I don't know exactly how much later - it typically works the next day again, but it doesn't work immediately...

After using dbms_scheduler since its introduction I was surprised to learn that it is not the way application development should go.I was explained that having scheduling outside of the database is better than having it inside the database.And the replacement ...

(https://livesql.oracle.com/ords/livesql/s/da34i74lkmxt2mqrtp0k4xsk6 )(I was able to format better with screenshots on the Oracle forums - https://forums.oracle.com/ords/apexds/post/help-solving-a-logical-problem-using-analytical-query-3778)Hi,I am trying to s...

Hi!We have a lot of Apex apps, so we check the LAST_UPDATED_ON value in both the production and dev apps before deploying to production.Like this:<code>select d.APPLICATION_ID, d.APPLICATION_NAME, d.ALIAS, d.OWNER DEV_OWNER, p.OWNER PERP01_OWNER, d.LAST_UPDATE...

Hello,I have multiple baselines and after migrating the application many of them got not reproducible.The reason was renaming of some indexes during the migration.I have renamed those indexes back to the original name.My question is how I get Oracle to set tho...

Can someone please provide Oracle sql query to get below output?Deptno Dept Name No. of emp10 a 10 b 20 c 3020 d 40 e 50 f 6030 g 70 h 80 i 90...