Tom Kyte

Subscribe to Tom Kyte feed Tom Kyte
These are the most recently asked questions on Ask Tom
Updated: 16 hours 59 min ago

appendChildXML with parent-namespace in the child

Tue, 2016-10-11 12:26
Hi Chris & Connor I want to append child nodes to an XML but have problems because of the (parent)namespace in the children: The child node in appendchildxml() is not a valid XML because of the namespace that comes from the parent. The XML shou...
Categories: DBA Blogs

PDF pages in Oracle Apex 5

Tue, 2016-10-11 12:26
Dear Tom how to open a specific page or range of pages of a PDF file in oracle APEX 5. Let us say that I want to display only pages 15-20 of a PDF file stored in a database table. I am able to open the PDF file in Apex 5, but I need to open a spec...
Categories: DBA Blogs

file not importing in apex 4.2

Tue, 2016-10-11 12:26
Guys, I am getting erro, that " File is not valid Application Express application export file " When importing exported SQL application file, I am selecting Unicode UTF - 8 when importing, I am using apex 4.2 version. My possibilitie...
Categories: DBA Blogs

Log file sync

Tue, 2016-10-11 12:26
Hi There, I found slow performing pl/sql functionality indicated to be slow only when a backup of rachivelog is in progress. Checking the events using AWR and ASH reports there is clear indication for "Log file sync" waiting event for a delete...
Categories: DBA Blogs

Input parameters tramsission into logging procedure

Mon, 2016-10-10 18:06
Hello, Tom! I'm sure, my problem is not nontrivial one, but I've certainly stuck on it and need your help. This is it. I need to write a logging procedure that will catch exceptions from other pl-sql blocks and assembly error messages with the str...
Categories: DBA Blogs

Inconsistent results from queries involving date predicates

Mon, 2016-10-10 18:06
Hey there, I am confused to see inconsistent query results from (seemingly) same queries: <code> SELECT NVL(ROUND(SUM(TRD_BRKRG_VL)/10000000,2),0) FROM TRD_TRD_DTLS WHERE TRUNC(TRD_TRD_DT) BETWEEN '01-Apr-2014' AND '31-Mar-2015' </code>...
Categories: DBA Blogs

identify increasing amount.

Mon, 2016-10-10 18:06
Hi Tom, I have just came across a requirement, where I need to identify the increasing amount. say I have a table for quarterly expenses and I need to identify the dept which has increasing expense by 105 or more from previous quarter, and if any dep...
Categories: DBA Blogs

Passing array size for a structure dynamically in PRO*C using a select query in a function.

Mon, 2016-10-10 18:06
Hi, I have declared a C variable in declare section and trying to get its value using a select query from a function as follwing, Note: I have mentioned only relevant codelines. ---------------------------------------------------------------- #...
Categories: DBA Blogs

How to Update millions or records in a table

Mon, 2016-10-10 18:06
Good Morning Tom. I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up in Roll...
Categories: DBA Blogs

ODBC changes national characters to latin equivelant

Mon, 2016-10-10 18:06
Hi all, I ran into a bit of a problem using Oracle database through ODBC from C++. The situation is as follows: - There is an Oracle database installed on a Linux OS - There is a C++ component which is communicating with that database throug...
Categories: DBA Blogs

ORA-27465 when setting File Watcher's attribute steady_state_duration a value less that 10 second

Sun, 2016-10-09 23:46
Hi, I am trying to set an interval of 5 seconds to steady_state_duration while creating a file watcher or change the interval to an existing file watcher. BEGIN DBMS_SCHEDULER.CREATE_FILE_WATCHER ( file_watcher_name => 'TEST_FILEW...
Categories: DBA Blogs

sql query related question

Sun, 2016-10-09 05:26
i want to compare this month data(ex:sep-2016) with previous year month data(ex:sep-2015) in same page of SQL PLUS by using date column(i.e.DAL_ARR_DATE_TIME) of my table,so please give me a solution for the same.thanks in advance. my table structur...
Categories: DBA Blogs

Implicit rollback on error in NDS and dbms_sql

Sun, 2016-10-09 05:26
Good day. Could you please explain to me why the following script returns the next output? <code> in foo_proc Static call - 1 in foo_proc NDS - 0 in foo_proc dbms_sql - 0 </code> Why the inserted row is implicitly rollbacked before th...
Categories: DBA Blogs

Physical Standby database - user sync

Sun, 2016-10-09 05:26
Will new users created on the primary database be synced to the standby database automatically?
Categories: DBA Blogs

non-cdb architecture on 12c

Sun, 2016-10-09 05:26
Tom. If we upgrade our 11g database to 12c 12.1.0.2, can we still use the non-cdb model? With 11g going into extended support very soon we would like to upgrade to 12c however, we are not familiar with PDBs yet so we would prefer to mo...
Categories: DBA Blogs

How to speed up an Insert with SELECT

Sat, 2016-10-08 11:06
Hi Tom, good morning Sir. I am trying to speed up an Insert statement where the SELECT is selecting all the source table according to this example: var_select_a_insert := 'insert into lwm_usrappods.ITEM_LOC_SOH select to_number...
Categories: DBA Blogs

High number of misses in library cache during execute - where to dig for explanations?

Sat, 2016-10-08 11:06
I'm relatively familiar with using SQL_TRACE and tkprof for tuning, but I recently spotted something in a tkprof report for one of our customers that raised my suspicions. There is a lot of SQL in the file where the number of library cache executi...
Categories: DBA Blogs

Session wait time of a transaction

Sat, 2016-10-08 11:06
Dear Tom, please help me with the below. Session 1: update table set field = 'A' where field2 = 'B'; it is not committed/rollbacked Session 2: update table set field = 'C' where field2 = 'B'; The session will be waiting for sessio...
Categories: DBA Blogs

How to observe current values of a running plsql code.

Sat, 2016-10-08 11:06
Hello, I can observe the current value of a bind variable, using v$sql_bind_capture. I don't know how to do it, when having no bind variable. Having a simple code like this below, I would like to see a VALUE of rec.column1 being passed to my_functi...
Categories: DBA Blogs

BULK Delete

Sat, 2016-10-08 11:06
Hi Tom, This is my first question to you and hope to receive a positive response :) Straight to the Question: I have a table named trail_log. This is a huge table and a daily growth of this table is 12GB Approx. Currently 76216160 rows. Import...
Categories: DBA Blogs

Pages