Questions

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

Hi Tom,sorry for asking this dumb question. This is about how blocks are placed in the buffer cache, Say a 50 GB table is accessed using Full table scan with buffer cache size 20 GB, Does Oracle bring all the blocks of the 50 GB to the buffer cache and produce...

Tom, I have a doubt about adding columns with default values to a table. Recently, I have stumble upon an Arup Nanda article on it where he states the following"When a user selects the column for an existing record, Oracle gets the fact about the default value...

In my CI workflow I must often remove a complete schema with a very large number of objects in it.Simply using "drop user <user> cascade" works but takes a long time of up to 5 minutes.Starting by first removing constraints and tables before using "drop user <...

There is an requirement to get the DDL for Oracle fusion custom tables is it possible to achieve??...

Hi,is it possible to audit (unified auditing) access to tables only once per session? I don't need to catch all selects from audited tables in a session, I just want to to know if a table was at querried at least once. Currently it generates huge amount of aud...

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...

hello guys,I'm trying to create hierarchy using a parent child table for analytic view but I'm struggling.the steps:1. create a attribute dimension using the table --> (id,name,parent_id)(I succeeded but idk the correct way for the parent child hierarchy).2.cr...

Where may I find the database installer for Windows 32-bit for Oracle 11.2.0.2?I did not find the 11.2.0.2 Windows version, only Linux....

I need to move online a huge table with BLOBs (around 25 TB) to a new tablespace with bigger block size.Wich method is recommended? Is DBMS_REDEFINITION still the method recommended by oracle? Or is now ALTER TABLE MOVE ONLINE?...

How to move a queue table into other tablespace in 11g database?Can we shrink queue table in 11g database?The dbms_redefinition is throwing error in moving to other tablespace as can't redefine.My tablespace datafiles are very much fragmented because of this q...

Ask Tom:I would like to migrate a PL/SQL Web Toolkit application from an on-prem database instance to the Oracle Autonomous Database. I see references to the PL/SQL Gateway via ORDS (I think) in documentation and administration screens but I'm struggling to co...

Hi everyone,We’re developing an APEX app that handles Excel files, and we’ve run into a problem when trying to export the app from one Workspace and import it into another.<b>The main issue:When we export the app and attempt to import it into a different Works...

Hi there,I am facing an issue wherein i need to have more than 1000 values in IN Operator of query.Please suggest some way around for the same .here is the code snippet for you.Note: RMID IN can have 1000+values .Also had tried using OR RMID IN ()-for values g...

I thought I could take what Chris showed me in my original question (https://asktom.oracle.com/ords/asktom.search?tag=looking-for-help-with-json-object).However, after 2 days, I have not made any progress.The JSON data - { "recall_control":[ { "it...

Hello,I am executing a package on multiple threads. Our package is for deleting data in bulk.Whenever I am running the package on multiple threads I am getting a deadlock.On checking the trace file I found the delete statement which is causing deadlock. But th...

Hello,We have migration project form Oracle database 11g in Exadata server, to 19c in ODA server, when we tested the query in the new server with client tool such as Sql developper, Sqlplus and Sqlcl, the connection was lost after 1 hour of inactivity, the onl...

Tom,How can we display PDF files stored in the database,using htp.p (OAS PL/SQL cartridge )calls and dbms_lob ?We are developing a document archival and display app.Using ctxload, I can upload the files. Now, I would liketo display the file in its native forma...

Hello,I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?According to documentation https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authoriza...

<code>SQL> alter session set standby_max_data_delay=1;Session altered.SQL> show parameter standby_max_data_delaySQL> select * from v$parameter where name='standby_max_data_delay';no rows selectedSQL></code>Where can I see my current setting of standby_max_data...