Questions

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

I have a Oracle 23ai (Version 23.4.0.24.05) installed in a VM but currently not used. I would like to upgrade the same to 23.9. Is this possible as I could not find any articles? Any guidance on this.....

Hi Tom,I have a table like thiscreate table temp1(f_name varchar2(100), f_date date, f_amount integer);Records in this table will be like this:Ajay 15-JUL-02 500Bhavani 15-JUL-02 700Chakri 17-JUL-02 200Ajay ...

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

HiCan we update data in Materialized view directly using update statement. If yes,will that updated to table as well. What if there are more than one table in view?Please help me on this....

In some 10gr2 and 11gr2 Customer´s databases I need, inside sqlplus , print some data vertically, much like your PRINT_TABLE function, but my user is "read-only" , I´m not allowed to create nothing (ie, no stored PL/SQLs, no tables, nothing permanent) insid...

Hi Tom,Suppose I am having following SQL queryUPDATE TB38OSET G000KE =(SELECT TB39G.A6000D FROM TB39G WHERE TB39G.A0020C = TB38O.A020KF AND TB39G.A0090C = TB38O.A090KF AND TB39G.A1010Y = TB38O.B010KF AND TB39G.A6000Y = TB38O.G000KF AND TB39G.A0230Z = TB38O.A23...

I think there is a way to do this but I can't remember.We have 40 tables 500GB+ in size that we maintain between sites using fast refresh. It's a setup that's worked remarkably well for a long time which we don't want to change.We'll be rolling out a 3rd site ...

Hello.We just upgraded our main database from 12cR2 to 19c(exactly 19.25).Some of parameters are changed, including log_buffer.Previously we set log_buffer parameter to 20M, and also speicified in parameter file.After upgrade we removed because out consultant ...

Hi Tom,I’m encountering an issue with my Oracle Database 23Free. It throws the ORA-12954 error: "The request exceeds the maximum allowed database size of 12 GB." After investigating the database files, I discovered that the SYSAUX tablespace is the main contri...

I have developed a news application using Oracle APEX, and I am now preparing to move it into a production environment. I would like to estimate the required resources for both the Oracle database and the application server (Tomcat) to support approximately 60...

Hi, I know that there was one question about Apex automation successfull rows. But it was very basic example.I have a procedure that performs some DML operations inside a loop. Depending on certain conditions, it updates or deletes rows.My question/use case is...

Hi, Im having an issue with my <i>Databases for Developers: Foundations: Tables</i> class. I watched the youtube video included, by when I tried to navigate to <i>Creating Tables: Databases for Developers</i>, I got 'Unexpected error has occurred'. This has be...

Hi,I need to install RAC with 19c on RHEL 9.5. Due to compliance clarification I am asked a justification to say GUI is only good option to install GRID, GG and DB.We have only 6 installations with 4 nodes in each RAC.I want to go with GUI and want to justify ...

Hi,I have a table "XYZ", which needs to be accessed by application in active-active configuration over RAC(19C) in both Primary and Secondary sites. But condition is, connection should hit Primary first. In case Primary has any issues, it needs to be connected...

How to delete records from the unified_audit_trail from one year ago?The database is version 12.1.0.2.0, and I'm having trouble with queries because they're slow....