Ask The Oracle Masters

Recently Answered

	Improve 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 ...
	User 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...
	Unpivoting 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...
	99% wait time on SQLNet more data to client Hello Team,We are transferring 4 million records over the network and SQLNet 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...
	How 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...