Skip to Main Content

Questions

QuestionUpdatedAsked

Hey Tom, 1. I would like to know the factors influencing the rollback speed of a transaction. And why does it generally take more than the time it took for the actual transaction. Could you show some light on this?2. I read one of your answers where you have s...
6 hours ago2 weeks ago

Hi Gurus,Below query run very long, after checking with SQL Plan Monitoring Details, i found oracle read one table with huge "read bytes". the table has 688k records, but the read bytes is 298TB. could you please take a look this. what causes the issue? <code>...
6 hours ago4 years ago

We have a UI based application where users come in and setup SQL's to get excel based reports back, there are multiple options to chose on the schedule of the SQL execution and other related parameters. It's a free text box, the expectation is that the users w...
6 hours ago6 weeks ago

Hi Tom,I have a query ,I want to pass multiple values to pbd_prod_code is this possible ,as I am getting null v after passing 1001,1002 values to the parameterSELECT field_key, field_lable,FROM json_table( (SELECT PBD_BLOCK_INFO FROM PIIM_PROD_BLOCK_DE...
7 hours ago4.2 years ago

Hi,What are the best practices to develop CRUD/DML APIs (using packages or subprograms) in Oracle. If i want to insert, read, update or delete data, i want to do it through APIs. Furthermore, what can be the possible cons of using APIs instead of using normal ...
7 hours ago2 weeks ago

I have noticed that the HWM will only go down if the table is truncated. If I do the following will it lower the HWM:CREATE TABLE temp AS SELECT * FROM table_name;TRUNCATE table_name;INSERT INTO table_name SELECT * FROM temp;COMMIT;This has been successful at...
7 hours ago23.9 years ago

I HAVE "Windows 11 Home Single Language". DEVICE NAME: Laptopnum02. NO PASSWORD FOR MY ACCOUNT.1.CREATE A TEST *.CMD FILE . CREATE A *.TXT THEN CHANGED THE EXTENSION TO: *.CMD THIS MAKES THE *.CMD CALLED: creararchivo.cmd<code>@echo offecho Este es el contenid...
7 hours ago2 weeks ago

What is the difference between using sequence.netxval as DEFAULT value in a column or check the column as identity? Please, check the following scenarios: <b>SCENARIO 1:</b>CREATE TABLE USER1.TEST_TABLE(ID NUMBER GENERATED BY DEFAULT AS IDENTITY ( START WITH 1...
7 hours ago6 years ago

Hi Tom, I am getting following error when i use copy_file procedure of dbms_file_transfer package. Here i am trying to copy log file from one folder to other.ThanksSQL> BEGIN 2 dbms_file_transfer.copy_file(source_directory_object => 3 'SOURCE_DIR', sou...
7 hours ago18.6 years ago

Hi Tom,I need to come up with an automated method to insert data (xml_type) from an external flat file into to a table in Oracle Database using SQL Developer.Read some articles which shows how to load the files by using a control file, but I couldn't find any ...
7 hours ago2 weeks ago

I am wondering how does SKIPEMPTYTRANS work? when does ogg judge a transaction empty or not? if it does the judgement in the middle transction? how does ogg know it's a empty transaction? provided that it did not update mapped tables before the judgement, but ...
6 days ago5.9 years ago

HI,I need to perform fulltext searches in an xmltype XML field. The table in which this field is located has other fields that can be used to narrow the search in the fulltext index (for example, a date field). However, I noticed that by creating a composite d...
10 days ago13 days ago

Can the shared_pool_size and the streams_pool_size parameters be set to the same value?Both parameters are currently set to zero. I would like to set them both to 2g. I will need to use about 1.5g of the streams_pool memory for Golden Gate. Will this work? ...
13 days ago2 weeks ago

Hi,Due to my work environment, I'm not allowed to cut and paste from my environment. As a result of that I cannot provide a specific test case, but just gives symptoms, would you give me general guidance on how to approach this problem?I'm running a huge inser...
13 days ago3 weeks ago

We perform a duplicate database from prod to test weekly and have a script that captures the current user permissions on dev via the dbms.metadata.get_ddl package that generates DDL to another file to be used after the duplication to re-create any user that ha...
13 days ago6.5 years ago

Tom-- I subscribe to your SQL mantra for data (and truly, is there anything else? :)) which is:1. Do it in a single SQL statement if at all possible.2. If you cannot, then do it in PL/SQL (as little PL/SQL as possible!).3. If you cannot do it in PL/SQL, try a ...
2 weeks ago18.9 years ago

Hi Tom , I have your book and am still not able to understand the mechanism of hash join . it just says similar to this ( I do not have book at work so can not exactly reproduce it )one table would be hashed into memory and then the other table would be used t...
2 weeks ago18.1 years ago

Hi!We have a lot of Apex apps, so we check the LAST_UPDATED_ON value in both the production and dev apps before deploying to production.Like this:<code>select d.APPLICATION_ID, d.APPLICATION_NAME, d.ALIAS, d.OWNER DEV_OWNER, p.OWNER PERP01_OWNER, d.LAST_UPDATE...
2 weeks ago2 weeks ago

Hello. I have an application in which users upload PDFs to a table. How can I check in PL/SQL if a PDF in a blob is digitally signed?Ideally I'd like to know if the signature is valid, but just knowing if a file is not signed would be enough to reject it and s...
2 weeks ago2 weeks ago

hello , i have a table TDRCORE.FCM_CCBF , PARTITION BY RANGE (RQO_PROC_UTC_DATETIME TIMESTAMP(6))INTERVAL( NUMTODSINTERVAL(7, 'DAY')) tehre is an SQL running on LIVE db that comtains many unions but i will not post full script , i will post just 1 part of th...
2 weeks ago2 weeks ago