Skip to Main Content

Can't see the Ask Question button?

Connor and Chris are in Italy for ITOUG and will be back taking questions again soon. Click Notify Me to be emailed when we're back taking new questions.

In the meantime, you can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Questions

QuestionUpdatedAsked

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 ...
24 hours ago44 hours ago

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...
24 hours ago2 days ago

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...
41 hours ago45 hours ago

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...
41 hours ago3 days ago

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...
45 hours ago45 hours ago

<b></b><code></code><u></u>Hi TomI have been trying to call an executable shell script placed on AIX 7.2 from Oracle 12.2 via following code:<code>BEGIN DBMS_SCHEDULER.create_job ( job_name => 'GEN_DAILY_CNT_FILE', job_type => 'executable'...
2 days ago2 days ago

In one of the databases , we have list of courses , descriptions , outlines , ... We would like to implement "google" like search ( ie) a) If I type the keyword "data" , it look for databases , data mining , big data ... b) If I type the keyword such as "Proje...
2 days ago2 days ago

Hi TomWe got a table which is partitioned on Range (date), Each partition holds approximately 5 Million records, there are 60 partitions. There are 4 Indexes on this table and they are Global Indexes. To remove old data we truncate partition.Truncate partition...
2 days ago12.3 years ago

Hi Tom,We have 16 GB of memory on Windows server. Database is Oracle 12.2.01. 6.6 GB is using Oraclekernel exe.We have set:SGA_MAX_SIZE = 10016 MSGA_TARGET = 6016 MPGA_AGGREGATE_LIMIT = 6000 MPGA_AGGREGATE_TARGET = 2900 MI hope it's simple question we sent...
2 days ago8 months ago

Example String:I01 I0102 TID6977105'Above is the string from a file format.Need the 7 digit number string after 'TID' Example: 6977105How to retrieve that one?...
2 days ago3 days ago

Hi All,We are using Oracle Flashback Data Archive in our database to track Audit in most of the critical tables. We initially planned to store data for 6months but there are few errors / issues we face making it unstable.So we have it as retention of one month...
2 days ago13 days ago

Hi Tom,Is this possible to execute all select statement in procedure even though one of the select statement fails. I mean if one of the select statement fails only that statement should not display output but rest of the statement in a procedure should work a...
2 days ago2 days ago

Hello,I want to create table that takes id information from a different table and according to this users' start date of work, calculating the working time annually and updating it daily. How can I do it? Please help me.I have 2 tables; <b>employee </b>and <b>...
2 days ago4 days ago

my customer has ODA 18 VM version, there is no console in use at this time.can we connect a console and configure the backup? for this feature; https://blogs.oracle.com/oda/oda-12213 ? All you need is an OCI account and an Object Store for the database and arc...
3 days ago3 days ago

Hello!I have a customer currently running Oracle Database 11g Standard Edition Release 11.2.0.4.0 64-bit on Oracle Linux 7.6 on physical hosts with multi-threaded CPUs. They are aware of the situation with the support for 11g and wish to upgrade to 18c or 19c ...
3 days ago4 days ago

How to compare the results from 2 sql queries.This is the query i need to execute on each session for specific sqlid. should i save the results somewhere in temp and than do comparison or any other way please update.select s.name, m.value/1024/1024 mb from v$m...
3 days ago3 days ago

<code>create or replace procedure tmp_insert_emp(vempno varchar2 default null,vename varchar2 default null,vdname varchar2 default null)as v_query varchar2(32767);v_where varchar2(32767);BEGINv_where:=' WHERE emp.deptno=dept.deptno';IF TRIM(vempno) IS NOT NUL...
3 days ago3 days ago

Hi,we have 1 TB datafile in a diskgroup with normal redundancy. We are planning to move that datafile to another diskgroup with external redundancy. The reason for that is because we have a huge diskspace consumption and if we get rid of redundancy, then we wi...
3 days ago2 weeks ago

Hello,Is it possible to write a single SQL query that would concatenate multiple rows into a single row with multiple columns?For example, I have a table with the following data:<code>TYPE DATE AMOUNT--------------------------------B 30.6.2019 ...
3 days ago3 days ago

Hi, I need query to find out Database growth. However in google lots of queries are available but not getting exact result. Currently was using below queries, if possible can you explain which query i need to use to get most accurate DB growth result. ********...
3 days ago10 days ago