AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 2 hours 5 min ago

SQLLDR display active sessions

Thu, 12/11/2014 - 00:00
Hello Tom, When I'm loading a table with sql loader, I don't see my session in V$SESSION view. How I can display the active sessions related with sql loader and how I can display wait events too ? Thanks in advance. --- Ludovic

Generate excel file from oracle auery and send to email on monthly basics

Thu, 12/11/2014 - 00:00
Hi , 1. I need to genereate excel file from oracle query(like...spool option etc),then i need to attach this file and send a mail to user for monthly basics through oracle procedure using oracle scheduling jobs. can u any one know the proced...

Upgrade from 11g to 12c

Thu, 12/11/2014 - 00:00
Tom, Looking at 12c documentation, it seems that there are a whole lot more background processes in 12c as compared to 11g.If I perform a one-to-one upgrade from 11g to 12c, do I need to increase resources on the server (like memory/CPU) or allocate...

add subpartitions to partitioned table using alter table

Tue, 12/09/2014 - 00:00
Hi Tom, I have a list based partitioned table as shown below. create table t( col1 number, col2 date, data_id varchar2(10), archived char(1)) partition by list (data_id) (partition a_data_id values ('A'), partition b_data_id values ('B') )...

How to get all records for a dynamic query using DBMS_SQL package

Tue, 12/09/2014 - 00:00
Newbie here. The following code works fine for a dynamic query but it just fetches only 1 record. I tried to use DEFINE_ARRAY function but not successful. Just need a hint for the following code on how to approach to get all the records. The procedur...

RAC Services

Tue, 12/09/2014 - 00:00
Is it possible to force a procedure to execute against a particular service so that any time that procedure executes, it executes on the nodes the service is running on?

Moving from dbms_jobs to scheduler

Tue, 12/09/2014 - 00:00
Got a few Jobs, in several databases in the form: <code> DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => 'begin JOB1; end;' ,next_date => to_date('09/12/2014 20:18:14','dd/mm/yyyy hh24:mi:ss') ,in...