Hi,I used explain plan and got the following results. Based on cost and time, does query 2 perform significantly better than query 1? The runtime for query 1 is approximately 1 minute and 40 seconds, but it shows 07:47:02. Why is the estimated time so differen... | 2 days ago | 8 days ago |
Hi, Tom. Please see below script.<code>create table t0326 (id number, num varchar2(100)); declare v_empno number:=125854437665589038536841445202964995521300;begin dbms_output.put_line('v_empno -- ' || v_empno); dbms_output.put_line('to_char(v_empno) -- '||... | 2 days ago | 7 days ago |
Hello Tom,A colleague of mine is a big fan of service-oriented architectures and middle-ware. His view is that dblinks are 99.9% of the time a bad idea and that you should go via some sort of message layer in order to pass information between applications.In ... | 2 days ago | 17.1 years ago |
We recently had a database failure that resulted in data loss after an Oracle 19.3.0.0.0 database had both both its control, and redo log files deleted. Please note that I am not a DBA, but simply an analyst that supports the system that sits on this Oracle da... | 7 days ago | 10 days ago |
Is 'SELECT * FROM :TABLE_NAME;' available?... | 9 days ago | 10 days ago |
Hello Sir,I am able to get one scenario to work and that scenario was where I had a VM (server) running Oracle 19c with just 1 table 5 records and I did a backup of the whole VM (disk backup) and now I added a new table in my db with 3 records (ensured db is ... | 9 days ago | 12 days ago |
We have an application that has been written to insert a variable that is char(50) into a column that is defined as char(40). In Oracle 11g (I know this is very old) it would merely truncate the last 10 characters without issue. However, Oracle 19c doesn't a... | 9 days ago | 3 weeks ago |
According to https://docs.oracle.com/database/121/SQLRF/functions100.htm#SQLRF00658 the length function should work on a clob and on a varchar2, returning the length of a string in characters, as defined by the input character set.Could you explain why the len... | 9 days ago | 2.4 years ago |
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... | 10 days ago | 7 months ago |
Hai all,I have 1000 number of tables. some of the tables got delete rows and updated the fragmentaion is created.How to determine which tables are fragmented ?... | 10 days ago | 8.2 years ago |
Hi TeamI have below scenario.Step#1) User clicks to particular App UI screen.Step#2) User selects multiple filters on UI - say filter1, filter2 which correspond to table columns.Step#3) For each filter selected by user, he needs to enter data - say Mark (for f... | 10 days ago | 12 days ago |
I am migrating 11g database cross endianness from on-prem to EXACS . On-prem database db_block_size is 4k and all the tablespaces are also of 4k block size . <u>Since, I cannot provision non-standard block size database in OCI</u> , I am worried about the per... | 10 days ago | 13 days ago |
How to connect oracle database / data set into Power BI, I already searched from google and youtube but I can't do it please help.Thank you.... | 2 weeks ago | 3 weeks ago |
Hi,We are trying to compile following class in Oracle database 23c. However, we are encountering surprising error (we are not using ANY database link:Error report -ORA-04054: database link MYOPTIMIUM does not exist04054. 00000 - "database link %s does not exi... | 2 weeks ago | 2 weeks ago |
Hi,I know how to use transform=oid:n in a CMD box using impdp. Is there a way to add that parameter to the import when using the Datapump Import Wizard in SQL Developer?Thanks.... | 2 weeks ago | 7.4 years ago |
Hi Tom,Can you explain, what is 'EDITION' and what is it meant as cross-edition triggers? How it can be useful for high availability.Thanks for you replies. It is a big learning experience.... | 2 weeks ago | 14.5 years ago |
Hi,What has happened to Tom Kyte's blog http://tkyte.blogspot.com/.Can you add me to white list of that blog ? Will be very great-full.ThanksFahd... | 2 weeks ago | 6.6 years ago |
Tom,DBA.DBLINKS - I am confused about what's in DBA_LINKS - I have never used them. I just want to understand what the column definitions mean. They are too vague.OWNER - The user who created the database link. If the link is public, then the user is listed as... | 2 weeks ago | 7.1 years ago |
Hello, I am an intermediate SQL and PL/SQL user and I am interested in becoming an Oracle Database Administrator. Could you provide me with a roadmap or step-by-step guide on how to become an Oracle DBA? Additionally, I would appreciate any recommendations on ... | 2 weeks ago | 1 years ago |
We just hit 2.1 billion row count on a table with primary key INT. This is the worse thing to happen :( Any one know if we can do alter without requiring space on the DB for the entire table?... | 2 weeks ago | 8.5 years ago |