Questions

Dear Ask Tom team memebers.Is it possible to to measure sql effectivity via computed throw away row count ?Its clear that optimizer tries to build the plan to minimize throw away rows for the next steps in the plan. So it tries to send only relevant rows to ne...

Hello everyone,I am trying to create a CSV file and then attach it to an email and send the email but I am receiving the following error: PLS-00201: identifier 'APEX_DATA_EXPORT.T_EXPORT' must be declaredBelow is the code I am attempting to run:<code>declare ...

Hi Tom,It was run a impdp command with remap_table in parfile with sqlplus in Oracle Linux but it run a full import. We've lost impdp logs, How could we get information about the impdp command that was run and clarify the issue?Thanks a lotRegards!...

On my test database, Oracle scheduler seems a bit lethargic.In my case, I am inserting data into 6 different tables ( million plus rows in each table ), these are done as insert into / select from via a stored procedure, I have a package with 6 procedures. In ...

hi Tom,when a remote table is referred in sub query then it is not retrieving the data and it throws error.refer the below sql, I am trying to get latest record, so I am doing order by DATEM in sub query and taking first record in outer sql. here, OWNERDOCUMEN...

I get a .csv log file dropped from a microsoft server to a linux server using winSCP. The column REASON, is enclosed with "" and includes LF. Here is a 2 record snippet of the file: 5826431,5826431,,,New,17255483,,,,2e4cf893-078d-45b3-b548-2dc3c970ff25,5826431...

Hello Team,First of all, thanks for all the good work you are doing.It would be great if you can help us understand how we can improve timings of query executed on a DB link.Consider an Oracle instance (DB1) that can talk with another oracle instance (DB2) via...

Oracle's Critical Patch Update Advisory publishes Oracle Patch number along with a matrix of CVE's that are on some Risk Matrix.For some reason, I am unable to see any way to see what CVE's a patch number affects.Am I missing something or is this not a possibi...

In our production environment ,a 2 nodes 11.2.0.4 rac ,the parameter parallel_force_local=true is set.one sql use hint parallel ie: SELECT /*+ PARALLEL(t1 8) */ .in sql execute plan we found Parallel Execution on 2 instanceParallel Execution Details (DOP=8 , S...

Good afternoon, Tom.I've started working for a new company recently and was just assigned a ticket regarding a "Free Space Fragmentation Index" warning for the SYSTEM tablespace of one of our databases (something I never ran into at my previous job). The first...

In Oracle Release 19 Document: Database SecureFiles and Large Objects Developer's Guide (https://docs.oracle.com/en/database/oracle/oracle-database/19/adlob/LOB-storage-with-applications.html#GUID-B82B3C24-1FAF-4661-96A0-28241FD2A052)there are following des...

Hi Tom,While doing sql query tuning I came across SQLT Tool and I found it very useful. But there's one problem. Our clients (esp. client's DBAs) are not ready to allow me to use it on their production environment. I told them that it won't have any adverse im...

Hi Tom,sorry for asking this dumb question. This is about how blocks are placed in the buffer cache, Say a 50 GB table is accessed using Full table scan with buffer cache size 20 GB, Does Oracle bring all the blocks of the 50 GB to the buffer cache and produce...

If a SQL statement in pdb container A is <b>exactly</b> the same SQL statement as in pdb container B, will they share the same execution plan even though the owner of the tables and the user owning the session (including GTTs) will be different in each contain...

Problem StatementI am working with a large dataset (~11-12 million records), where I need to identify key out-of-stock (OOS) event dates for different products (MASTER_ID) across multiple marketplaces (MARKETPLACE_ID).Each record in the DETAILED_OOS_EVENTS tab...

v19.22Requirement is to run some queries against the audit table at the beginning of the month to capture details about the previous calendar month.EVENT_TIMESTAMP in UNIFIED_AUDIT_TRAIL is timestamp(6) (not date)Is this an appropriate where clause to query th...

Hi Tom,i have a question about the index fragmentation, on the famous white paper "How to stop defragmenting and start living: the definitive world of fragmentation" by Bhaskar Himatsingka and Juan Loaiza, on section 4.2, they provide a script to tell if the i...

now i have json response from oracle service like following code{ "Status": null, "RequestNumber": null, <b>"validationResults": [ { "code":E1000, "details":'Validation Error' } ]</b>}now i can read keys Status and reque...

I'm trying to follow along with the live lab 'Build a 'Doctor Appointments Made Easy' App using Oracle APEXIntroduction' to get to know the new Workflows in Application Express. In Lab 9 task 6 I run into an error in the Check Appointment Fee activity: ORA-018...

Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will have. (Please let me ...