Questions

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

I have an interesting request from our Warehouse Team.They require us to enable supplemental logging on ALL COLUMNS on core tables, we already have force logging for our DG.Our DB size 60TB.Interestingly our SLA's on processing is 3/4 seconds.Can I both Supp a...

<code>declare    raw_hash  RAW(20);begin    /* 4000 + 1. */    select standard_hash(    [literal string of length 4000]                          || '-'                        )      into raw_hash      from dual    ;end;/-- ORA-01489: result of string concatena...

Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors ...

I have to open a url having image and display from oracle forms in a separate browser window. Since the image will change for every transaction, the image should show in same window. My forms is running on Oracle EBS R12....