Skip to Main Content

Can't see the Ask Question button?

Connor and Chris 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

Apologies... this is related to a previous question answered earlier today, but I did not know how to ask a 'follow up' question...I've written the code below to generate an email report on users in an instance which have not been logged into in the last 15 da...
36 hours ago2 days ago

We have a materialized view, which has undergone some tuning. When creating the new MVW, it took 15 mins.The MVW is then refreshed using a shell in which many MVWs are refreshed in order. As part of the refresh, to make it faster, the indexes on the MVW are dr...
36 hours ago6 days ago

Hello Teama while ago, I had a problem with a DB import. I managed to get it, but there's a question still remain in my head1. what is the difference between<code>expdp system/system schemas=ieulive directory=dir1 dumpfile=dump1.dmp logfile=exp.logimpdp system...
36 hours ago4 days ago

Hi guys,I have a problem when I try to start a stored procedure with DBMS_JOB.SUBMIT.I have the package "dafneMultithread":<code>CREATE OR REPLACE PACKAGE DAFNE.dafneMultithread AS PROCEDURE start_job(p_procedure_name IN VARCHAR2);END dafneMultithread;/</co...
36 hours ago1.7 years ago

Hi Tom, I have a below case in which bind variable peeking seems to not work well.1. I have a table RETRO where is around 1,5 millions records 2. This table has a three below indexes:- IK_RETRO_02 ON RETRO(PAR_ID, RETRO_PAYMENT_DATE) - IK_RETRO_05 ON RETRO(N...
36 hours ago4.5 years ago

Hi Tom,What are bloom filters? Is it new in 11g? How does it improve performance? How can I check, if bloom filter is happening in the DB or not?Regards,Ashish...
2 days ago8.5 years ago

I have a parent table and child table with a 1 to 0-many relationship. I need to create a json object that includes parent data and a list of child table data. The goal is an object that includes: <b>"child":[]</b> when there is no matching data in a child ta...
2 days ago4 days ago

Hi Chris/Connor,UseCase---------We need to design a table which will be used for batch processing for about 2.5M transactions at peak load.This table will be used for processing 100k in a batch and once the processing is complete we will be deleting the record...
2 days ago2 days ago

I have some code (see below) which tells me the username and last_login for any login not used in the last 15 days. I would like to add a 3rd column to the results, which shows the number of days sine the last login, to make it easier for the person running th...
2 days ago2 days ago

I have read several books which have repeatedly mentioned creating indexes on foreign keys. I know one advantage is that it eliminates table-level locks and, I have seen the benefit since I have encountered a similar problem. However, I would like to know if y...
2 days ago20 years ago

I am copying XML data from Operating System file into CLOB and then casting as XMLTYPE for extracting information into relational database.This solution is working for years but I received a business requirement to process big XML files ranging from 80-500MB. ...
3 days ago4 days ago

Hi all, I want to ask about auditing database.So I have a problem like this. I have a table that I have audited. Example we called it table x. Audit data in table X is recorded until the 14th. However, on the 15th onwards, no audit data is recorded. So what is...
3 days ago4 days ago

Example 3-22 Using UPDATE to Insert an Entire Multilevel CollectionINSERT INTO region_tab (region_id, region_name) VALUES(2, 'Americas');DECLARE v_country nt_country_typ;BEGIN v_country := nt_country_typ( country_typ( 'US', 'United States of America', nt...
3 days ago4 days ago

Hi,I would like to know if there is anyway it return the beginning of the hierarchy and end of hierarchy for the code below.<code>WITH o AS ( SELECT 'A' as obj, 'C' as link FROM dual UNION ALL SELECT 'C', 'D' FROM dual UNION ...
3 days ago4 days ago

Tom:I was interested in using the multi-table insert feature in 9i but am stumped by the restriction that the subquery can't contain a sequence. I use a sequence to assign a Primary Key in one of the tables that is the target of the multi-table insert. Can you...
3 days ago17.5 years ago

Hi Tom,I am trying to convert a non partitioned table into interval partitioned table online.I created a simple test table and ran the below script but I get ORA-14006 invalid partition name error. My conjecture would be this is not allowed for interval partit...
3 days ago3.2 years ago

Hello, Ask TOM Team.I have two tables: TABLE1 (parent) and TABLE2 (child). TABLE1_ID (FK) on TABLE2 table has an index. When I run a join query, I got a table access full. There are ~4M rows in the result set. <b>select * from user.table1 t join user.table2 t...
4 days ago4 days ago

Hi Tom, i have updated the plan.i was unaware how to submit the further information on the questions asked, thats why put the questions again.this is with reference to question asked at below linkhttps://asktom.oracle.com/pls/apex/asktom.search?tag=index-scan-...
4 days ago6 days ago

Hi Team,Thanks a lot for all the support you have provided so far :) I have created an On Commit Materialized view MVA recently on tableA. Primary Key M View log is used here.Occasionally this refresh fails with ORA-12034 error. Since this is a key table in ou...
4 days ago4 days ago

Hi Tom,This is a general question about the design of the tables in a DAILY use database. The users will uploading and downloading pdf files from a web app daily. What i want to ask is it a good idea to create my tables with BLOB columns and saving the pdf fil...
4 days ago4 days ago