Questions

Hello Community, I have 5+ yrs of experience. I am trying for a job change. While attending interviews i can able to answer all theoretical questions and queries but i couldnt able to answer senario based questions. How can i level up my preperation as i am on...

Hello,I work as a dba and get requests from developers to create tables which we often review and sometimes change for better design and/or implementation.One of the developers recently sent a request to create a table such as the following ;table_name:t1_rela...

Hi,Does Oracle have any plans to support RS256 in Apex ? Thanks https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-4418&session=105003035734261...

After updating to v25.x.x of the Oracle SQL Developer extension for VS Code, I noticed that SET DEFINE OFF only works when I run the script (F5) in the first line. In previous versions, SET DEFINE OFF worked regardless of where the script was executed.Is this ...

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

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