Skip to Main Content

Questions

QuestionUpdatedAsked

I run in sqlplus a query with huge result set. It has to return million recordsSet arraysize to 5000Monitoring v$session, v$process, v$sqlstats while query is running I can see after some minutes executions changes from 0 to 1. Then fetch count begin to be inc...
2 days ago7 days ago

I need to compare 2 table A and B I want to store the difference in C and after I want to update B to A.The B table could be updated every second so , I wondering what is the right approach to ensure when I update B to A I m using same value as when I compare...
2 days ago3 days ago

Hi Tom,Greetings, we have a requirement to capture data changes for multiple tables and push to Kafka topic in the following format similar to GoldenGate provides."op_type":"Insert or Update","op_ts": "timestamp","current_ts": "timestamp", "before" :"Row Data ...
2 days ago3 days ago

The question I have is regarding the ADD_MONTHS function. The live sql link for the test case is as below:- https://livesql.oracle.com/apex/livesql/s/JT1FDGOHXMRWN3LG94GEYLMPJIf we have a look at this link it has 3 components:- 1. A function that takes an old ...
2 days ago3.9 years ago

"alter session sync with primary"raises ORA-03173 for us.<code>SQL> select database_role, open_mode, db_unique_name from v$database;DATABASE_ROLE OPEN_MODE DB_UNIQUE_NAME---------------- -------------------- ------------------------------PHYSICAL...
2 days ago9 days ago

Hello,I have a production problem for which I need your inputs.Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production1) There is a monthly Partitioned Oracle table with monthly Partitions created at during table creation.2) The a...
2 days ago3.1 years ago

I am using PL/SQL in front end and Oracle 11gR2 in back end to developing a db app. In the middle of time, I am going to check hard parsed execution plan of one sql statment. What make me surprised is that the PL/SQL Developer seems has no capability given to ...
2 days ago7.7 years ago

Hello Tom,I have a table with a CLOB column:<code>create table plch_clob(i int primary key, x clob);begin for indx in 1 .. 1000 loop insert into plch_clob( i, x) values (indx, 'CLOB Row: ' || indx); end loop; commit;end;</code>By calling the func...
2 days ago8.1 years ago

Hello everyoneAt first, I have an angular UI client and ORDS as API.I'm going to use RAS(real application security) or VPD for row-level security. I read oracle RAS documentation and I didn't catch how to use it with ORDS(without apex) and this is true for us...
3 days ago3 years ago

Hi, I have a table contains 50+ million records, and I am writing a procedure to replace the bad data to the correct values(about 1500 records). <i><b>K_V</b></i> is the array of bad data and target correct value,like <code>K_V('bad data1') := 'correct value...
4 days ago8.1 years ago

Hello masters. Here I am again with another mystery from our favorite DBMS (no, that was not sarcasm, I do love Oracle in fact).So, in my company we are facing the referred error, ORA-12569: TNS:Packet Checksum Failure While Trying To Connect Through Client. ...
4 days ago5 weeks ago

Hi!I have a problem with <b>downloading XLIFF file</b> for whole application (Shared Components\Translate\XLIFF Export). It looks the request timeouts after 5 minutes ("Failed to load resource: the server responded with a status of 500 (Internal Server Error)"...
4 days ago2.1 years ago

I query table 'user_segments'sql>select segment_name, segment_type, tablespace_name, bytes, max_extentsfrom user_segmentswhere segment_type like 'LOB%'result isSEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAMESYS_IL0000012099C00002$$ LOBINDEX ...
4 days ago22.3 years ago

Apologies if my JSON terminology is not quite accurate, but hopefully the test case shows the issue. We are in the process of upgrading DBs for a legacy in house application from 12.1.0.2 to 19.18. We noticed during testing that when we are selecting sets of n...
4 days ago10 months ago

UserI HAVE SUCCESSFULLY RUNNED A JOB WHICH HAS STORED PROCEDURE OF TRUNCATE AND INSERT STATEMENTS USING DBLINK, IF ERROR OCCURS, ROLLBACK STAEMENTS ALSO THERE IN ORACLE PLSQL. WHILE DOING SO, TRUNCATED DONE AND DBLINK COMMUNICATION INTERUPPTED AND GOT END. SO,...
4 days ago10 days ago

Hi Tom,I have a some questions regarding the capacity planning.Thanks in advance.1.is there any way we can match LIOs & PIOs to the no of CPUs & no of disks ?2.is there any place , i can find documents to do capacity planning for the oracle database/sun solari...
5 days ago20.2 years ago

I need to have current cursor position in TinyMCE Oracle Apex. I use this js code for another type of page items and it work correctly.var curPos = document.getElementById("P7_TEXT").selectionStart;but when "P7_TEXT" is a Rich Text Editor (TinyMCE) , it will r...
5 days ago5 weeks ago

Hi TOM i have oracle cluster database EE with 2 nodes, and i have a big table with a big LOBs row, so after compressing the LOBs files i did move them to a new tablespace,so the principal table became just about 300MB but it still taking space of 1.2Tb, my con...
5 days ago5 weeks ago

HelloWe want to housekeep our user accounts and remove unsed and locked accounts. As far as I understand, the information in dba_users is from the primary DB. Users are not allowed to logon to the primary to query data, they must logon the read only standby (r...
5 days ago5 weeks ago

Views with group by grouping sets and pivot directly or in referenced view which worjk in Oracle 12c fall with ORA-56903 error sys_op_pivot function is not allowed here in Oracle 19. Bit in view or referenced view don't have explicit call sys_op_pivot. Mybe Or...
5 days ago4 weeks ago