Skip to Main Content

Questions

QuestionUpdatedAsked

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...
28 hours ago6 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) -- '||...
29 hours ago6 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 ...
29 hours ago17.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...
6 days ago9 days ago

Is 'SELECT * FROM :TABLE_NAME;' available?...
8 days ago9 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 ...
8 days ago10 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...
8 days ago2 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...
8 days ago2.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...
9 days ago7 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 ?...
9 days ago8.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...
9 days ago11 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...
9 days ago11 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....
13 days ago3 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...
13 days ago2 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....
13 days ago7.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 ago14.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 ago6.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 ago7.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 ago1 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 ago8.5 years ago