Tom Kyte

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

Dynamic Fields

Sat, 2016-11-19 10:06
Hi, I am ramesh developing the web application using java and oracle.Our requirment is user can add the fields dynamically for ex: Step 1: user enters name,age we will store that value in parent table. ID COLUMNS_ 1 name ...
Categories: DBA Blogs

ORA-04021: timeout occurred while waiting to lock object on SYS.DBMS_AQADM.CREATE_QUEUE

Sat, 2016-11-19 10:06
Hi, i have a problem during SYS.DBMS_AQADM.CREATE_QUEUE. After 15 minutes Oracle writes : ORA-04021: timeout occurred while waiting to lock object ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3647 ORA-06512: at "SYS.DBMS_AQADM", line 130 In ord...
Categories: DBA Blogs

History of User privileges held

Sat, 2016-11-19 10:06
In Oracle 12c or 11g, is it possible to fetch the history of user privileges held by a schema? Say from last two months, I might have granted different roles and privileges. I can get the current privileges the schema holds, but is it possible to kno...
Categories: DBA Blogs

Does a Pragma serially_reusable clause is helpful for the .net front end that calls the package.

Sat, 2016-11-19 10:06
Does a Pragma serially_reusable clause is helpful for the .net front end that calls the package. I have a package create or replace pkg_test as Pragma serially_reusable l_var number := 0 //some code here end; this package is called by ...
Categories: DBA Blogs

Frequent Truncate

Sat, 2016-11-19 10:06
We are frequently truncating partitions in a stage schema through java after loading data into a target table. Once partitions are truncated frequently are there any other steps to be taken to release the space?
Categories: DBA Blogs

Inserts inside before update trigger

Sat, 2016-11-19 10:06
I've come across this issue during trigger code testing today. My requirement is, 1. If INSERTING then statements in this block should execute on T1. 2. If UPDATING then statements in this block should execute on T1. It has IF ELSE block and it ...
Categories: DBA Blogs

Query for selecting top 10 percent of records

Sat, 2016-11-19 10:06
Hi Tom, I have the requirement of selecting top 10 percent for each group based on score for the below data "GROUPID" "SCORE" "group1" 13 "group1" 12 "group1" 10 "group1" 12 "group2" 12 "group2" 13 "group2" 16 "group2" 20 "group2" 22 ...
Categories: DBA Blogs

Parse CPU to Parse Elapsd has horrible ratio.. but others not too bad?

Sat, 2016-11-19 10:06
Tom - this is from running a statspack report. It captures activity over a 3 day period. Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100...
Categories: DBA Blogs

Columnar Storage

Sat, 2016-11-19 10:06
Hi Tom, I recently read an article http://visualstudiomagazine.com/Blogs/Data-Driver/2010/11/SQL-Server-Scan-1-Trillion-Rows-Per-Min.aspx which claims to be revolutionary and unmatched. How does Oracle measure up to it? Very recently new jargons h...
Categories: DBA Blogs

oracle data pump for a list of tables from different schemas

Fri, 2016-11-18 15:46
Hi Tom, Please note that I have a requirement where I need to export and import data in oracle 11g. At the source there are 4 schemas and each schema contains different numbers of tables. I need to load the target schema with the exported data fro...
Categories: DBA Blogs

Error when exporting table space which is contained

Fri, 2016-11-18 15:46
We are trying to move the database from Solaris to Linux and are facing an issue with the self-contained tablespace. Even after setting the execute sys.dbms_tts.transport_set_check('PSRBS',true); on a tablespace , get the below violation. How do we ...
Categories: DBA Blogs

Saving updates to an filtered table

Fri, 2016-11-18 15:46
Hi Thanks for this service I would to filter an table, preferably using interactive reports as it is easy to use, and then use a button to: write the filtered table into a new table or to update the existing table to remove the non fil...
Categories: DBA Blogs

Parser for plsql queries

Fri, 2016-11-18 15:46
Dear Tom, I have a requirement for displaying all the tables in the sql statement also columns that are participating in joins in the same sql statement. I am storing the queries that needs to be parsed in a table "PARSEQRY". However, post parsin...
Categories: DBA Blogs

Diff BW Collection type and Object Type

Fri, 2016-11-18 15:46
Hi, I am Oracle Beginner,Would you please explain the difference between Object type and Collection Type? Thank you.
Categories: DBA Blogs

SQL queries consuming host memory

Fri, 2016-11-18 15:46
Hi Tom, I would like to know which queries currently running is consuming host memory From OS level i came to know that the below process is consuming memory - $ ps aux | head -1; ps aux | sort -rn +3 | head USER PID %CPU %MEM VSZ...
Categories: DBA Blogs

Role behaviour change in 12c

Fri, 2016-11-18 15:46
I have created one package(pk_data_updates) in schema A and assigned Execute permission to existing Role Role1(ROLE Role1 is password protected). this Role (R1) is assigned to user venkat. CREATE ROLE Role1 IDENTIFIED BY roc_super; GRANT EXECU...
Categories: DBA Blogs

when redolog turns into archivelog?

Fri, 2016-11-18 15:46
Hi, My confiurations says that my redologs are of <b>200MB</b> max, and they are switched every 30minutes. <code>SQL> show parameter ARCHIVE_LAG_TARGET; archive_lag_target 1800 </code> Of course, with more activity, redo logs, are archived ...
Categories: DBA Blogs

Parse HTML in PL/SQL

Fri, 2016-11-18 15:46
Hi, Tom! I need some advice in what is the best way to solve the following task in PL/SQL. I have the following link https://wiki.xmldation.com/Support/EPC/List_of_SEPA_countries. I need to get IBAN-s (the third column) from this site and c...
Categories: DBA Blogs

Dynamic Query is running Slow in 12 C

Fri, 2016-11-18 15:46
Hi Tom, I had 1 sql file which was running perfectly fine in 10G but after migration to 12 c performance is very poor. The query logic is : A table has around 550 columns and data is getting inserted into this table from XL Sheet. Once loaded then...
Categories: DBA Blogs

Diff BW Optimizer SQL Engine

Thu, 2016-11-17 03:06
Hi, I would like to know the difference Between Optimizer,SQL Engine and PL/SQL Engine? I asked this question So many times But I did not get answers from you. Thank you
Categories: DBA Blogs

Pages