Questions

Hello Tom,I’ve been assigned a task where I need to check whether a table has any child tables, and if so, list them.For example, if the table name is ABC, I should be able to list all its child tables. I’m working in SQL Developer.My question is: is there a s...

I have a Merge statement, i got an error couple over weekend run. we did not get this error prior to last week and neither this week. just got this once.valdoiated that there were no DDL's or DML's were done at the same time.what could be the issue ...

Hi, I am working on a RAC 19C with two nodes. When the database is brought up, I get an ORA-700 [sms physmem limit] error in the alert log. To fine-tune the various parts of VM, OS and DB, I referred to Oracle Doc ID 2610312.1. It says that SGA_MAX_SIZE+PGA_AG...

Hello, I’ve set up Social Login authentication using the Keycloak service. We’re in a cloud environment hosted on AWS. The AWS WAF is blocking the request that APEX makes for authentication because the request does not contain a User-Agent. I’m getting a 403 e...

We have an Oracle Forms / Database application and were asked to limit User's maximum online time to 15 minutes. Following this, we set the profiles' CONNECT_TIME to 15 - this works well.How is it possible to reset this if user does any action on frontend?Mayb...

Which PL/SQL package is primarily used for interacting with Generative AI services in Oracle Database 23ai?DBMS_AI or DBMS_ML or DBMS_VECTOR_CHAIN or DBMS_GENAI?...

Hi there!I've some trouble trying to upload data from agent to OMS server, everything seems correct but:<b>emctl upload agentOracle Enterprise Manager 24ai Release 1Copyright (c) 1996, 2024 Oracle Corporation. All rights reserved.-----------------------------...

QuestionWe're evaluating different approaches to implement the Outbox Pattern in Oracle 19c for reliable event publishing in our microservices architecture, but we're concerned about the significant I/O overhead and performance implications. Could you provide ...

I encountered inexplicable freezing of pl/sql procedure while trying to fetch and insert data into table, however same operation runs successfully when called with sql query in any IDE.I am trying to realise ETL process in data warehouse database.I need to loa...

Hi AskTom Team!According to https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/schema-object-dependency.html#GUID-B99E885E-900F-4F29-A188-A617A301FDCE : "Whenever a procedure is compiled, its time stamp is recorded in the data dictionary."Is i...

Tom, Starting at 10g, there is a new initialization parameter: DB_LOST_WRITE_PROTECT (which can be set to NONE, TYPICAL and FULL). Reading a few articles on that, I understand it protects against eventual asyncronous WRITE errors. From the 11g documentation: <...

Bring the consecutive number(strat_val,end_val) record based on id as one record and add new record if the consecutive number is breaks downhttps://livesql.oracle.com/next/?compressed_code=H4sIAAAAAAAACo3PwQqCQBCA4fvCvsPcVBjBXTWLboXHCoLOMupCgm2wO%252Fr8oXbo1j...

Thank you for taking my question.We're getting ready for 23ai and see that there is a new RESET_STATE option we can use if we're using PL/SQL behind a web server connected to Oracle using a connection pool and serving up stateless services. (https://docs.oracl...

Why does DML on a materialized view's master table cause the materialized view staleness to change from FRESH to NEEDS_COMPILE? I would have thought it would have changed to STALE. My understanding about NEEDS_COMPILE is that it is supposed to reflect struct...

It appears USING TRUSTED CONSTRAINTS causes a materialized view to have staleness=UNKNOWN when it would otherwise be FRESH.Is it possible to have a materialized view with staleness=FRESH when USING TRUSTED CONSTRAINTS?If not, would the optimizer be less likely...

Hi Tom.Is it possible to return rows from a table in the order that they were inserted?I have an old query, pre 8.1.6, that always returned rows in the order they were inserted. Now, in version 8.1.7 & 9 they are returned in a seemingly random order.Thanks ...

Hi tom, I have a table with compression, also have partitions and subpartitions. You can see The create DDL on the below. As you can see all of my objects are compressed or nocompressed. Bu i can't see this information on the all_tables table. Compression ad c...

Hello Tom,I am wondering what is the benefit of using a recovery catalog over a control file? What are some of the decisions one should consider before going either way?Please and thank you ...

I am using Windows 11 64 bit / Oracle 19c .Everything works fine except when I create a nested table and associate it with my table as a column . I can neither query it nor drop the table . When I query I get a message that the connection to the database was r...

Hey Tom,I have a Java application that runs thousands of different types of queries against an Oracle database millions of times. I wanted to save the query preparation time by using the oracle.jdbc.implicitStatementCacheSize JDBC property to cache prepared qu...