Skip to Main Content

Ask The Oracle Masters

Recently Answered

Recently Answered Report

Chris SaxonImprove the performance of joining remote tables
Hi Tom,Hope you are doing good !!!I am very glad to writing this post to get valuable information from you. We were in situation to join multiple remote tables joining in order to get expected data into our schema but its taking longer execution time (i.e. 5k ...
Chris SaxonUser Requiring Access to SQL Tuning Advisor Getting ORA-13616
Hi,we have created a User to manage the SQL Tuning Advisor. Due to internal policy /Guideline we created a Role and assigned the Role the following Oracle Privs :<code>Role Privs------------------------------PERF_OWN CREATE JOBPERF_OWN ADMINISTER SQ...
Chris SaxonUnpivoting billion rows
Hi ask Tom team,Hope you people are doing great in 2020.I am working in migration team ,our goal is to take csv file from client and ultimately transform data as per our production table structure .Requirement :-Recenty we have received one file of 260 mill...
Chris Saxon99% wait time on SQL*Net more data to client
Hello Team,We are transferring 4 million records over the network and SQL*Net more data to client is 99%. We tried multiple drivers like ODBC, OLEDB , Oracle Drivers, QlikSense application Oracle drivers but the % didn't get reduced.We have tested our network...
Chris SaxonHow to find last DDL / DML timestamp for IOT tables
Hi, One of my Customer is asking for last DDL/DML timestamp change for IOT tables. They have many tables and they need to drop some of them which is not used / modified / altered frequently. I checked internally for IOT and Normal tables using ORA_ROWSCN but f...

Resources