Tom Kyte

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

Real time scenarios

Tue, 2017-02-07 13:46
friends, I am searching complex real time scenarios and solutions on PL/SQL and SQL, Please provide reference documentation links if any. this will b great helpful Thanks, vin
Categories: DBA Blogs

Flush buffer cache and shared pool

Tue, 2017-02-07 13:46
Hi Tom, We have an application performing many inserts and updates from many machines. At peak time, we may have the application running on 300 machines performing inserts and updates. Once in a while, we saw some active sessions blocking other sess...
Categories: DBA Blogs

Question on ORA-12899: value too large

Tue, 2017-02-07 13:46
Hi Tom, We have a migration project which from Sybase SQL Anywhere to Oracle. And there is an issue we still have no perfect solution. In Sybase, When insert/update to a target column, the source string will be auto truncate if the length more t...
Categories: DBA Blogs

right way to grant permissions to developers

Tue, 2017-02-07 13:46
hello, i am junior dba with quite a little knoweledge about oracle. lately i wanted to make users for plsql developers who work on production database with the same user-bill(which has DBA role). i wanted to make them their own user for security p...
Categories: DBA Blogs

Error(24,1): PLS-00103: Encountered the symbol "BEGIN"

Tue, 2017-02-07 13:46
I wonder where it shows PLS-00103: Encountered the symbol "BEGIN" when i compile the procedure. please help <code> create or replace PROCEDURE GETCTRLEDPTDETAILSBYIPADDRR ( v_ipaddress IN NVARCHAR2 DEFAULT NULL , v_organizationId IN NUM...
Categories: DBA Blogs

Passing multiple value in IN clause in SQL query

Tue, 2017-02-07 13:46
Hi I have SQL query which takes around 50000 as input value in IN clause. What is best approach to passing value into IN clause which are more than 1000 in count.
Categories: DBA Blogs

Dynamic SQL

Tue, 2017-02-07 13:46
Hi Tom, I have the following dynamic sql statement, I want to return the rowid of the inserted record into a variable but I get a command not properly ended error. What is the problem? stmt:= 'INSERT INTO ' || destination_table_name || ' ( ' |...
Categories: DBA Blogs

Query for generating resultset with continuos dates for existing data

Mon, 2017-02-06 19:26
Dear Tom, I have a table which stores all the account balances with dates. A row is inserted into this table only for those days where the account has transactions. The table looks as below. create table account_balance (account varchar2(16), b...
Categories: DBA Blogs

Oracle AQ and wait delay issue

Mon, 2017-02-06 19:26
I wonder if you can shed any light on the following problem we're seeing when we dequeue payloads from AQ. What seems to be happening is whenever we set a delay then all delayed payloads seem to be taking ~3 seconds longer to dequeue than the wait we...
Categories: DBA Blogs

how to use ANSI outer join in subquery

Mon, 2017-02-06 19:26
how to write this query in ANSI STANDARD (I mean without using + symbol) select a.ename, a.empno from dept a where exists(select null from emp b where a.deptno=b.deptno(+))
Categories: DBA Blogs

Why i am getting invalid cursor error/

Mon, 2017-02-06 19:26
<code>DECLARE CURSOR C_Emp IS SELECT Ename,Deptno FROM Emp WHERE Ename = 'RINTU'; V_Ename Emp.Ename%TYPE; V_Deptno Emp.Deptno%TYPE; BEGIN DBMS_OUTPUT.PUT_LINE('LOOP STAR...
Categories: DBA Blogs

How to identify sql query running against a database

Mon, 2017-02-06 19:26
Hi Toms Team, First of all thanks to you for sharing information using "Ask Tom" platform. My question is When we run any sql against a database (I mean simple select sql eg. select 1 from dual) we can see this information by querying against ...
Categories: DBA Blogs

Execute Shell Script from Oracle Database Program.

Mon, 2017-02-06 19:26
Hi Experts, I have done the required setup to execute unix OS commands using Java class as mentioned in the link(https://oracle-base.com/articles/8i/shell-commands-from-plsql) from database programs , I was able to run echo command from the Pl/SQL...
Categories: DBA Blogs

DBA_HIGH_WATER_MARK_STATISTICS Dictinoary view has cpu_count. is this value dynamically read while DB startup.

Mon, 2017-02-06 19:26
DBA_HIGH_WATER_MARK_STATISTICS Dictinoary view has cpu_count. is this value dynamically read while DB startup. if it's static can it be possible to change. we are moving OS and database disk' from 8 core to 4 core system to fix license issue. so want...
Categories: DBA Blogs

How find deleted row without using flashback

Mon, 2017-02-06 19:26
After commit how to find a deleted row from emp table in oracle?
Categories: DBA Blogs

Installing Pervasive and Oracle on the same physical server

Mon, 2017-02-06 19:26
My company is moving from Pervasive to Oracle and we are about to install Oracle 12c. We would like to know if there are any issues that we may encounter if we installed Oracle DB on the same physical server the Pervasive DB is on.
Categories: DBA Blogs

OS bootable disk with server

Mon, 2017-02-06 01:06
Hello, I am trying to make a bootable disk to run Linux on my laptop. I am learning how to use oracle database. I have downloaded the iOS image and when I start my laptop I boot off of the disk and then I get a message that a serve is not found. I do...
Categories: DBA Blogs

move DB from 8 core to 4 core

Mon, 2017-02-06 01:06
HI we need to migrate DB from 8 core system to 4 core system. one of my DB engineer is saying On the startup Oracle reads the processor and ?stamp? on the database. After that, next time when you start the database Oracle only override the stam...
Categories: DBA Blogs

update stats required after splitting adding partitions/subpartitions

Mon, 2017-02-06 01:06
I have to add dynamic partitioning/subpartitioning fucntionality to my warehouse application where i may need to split default subpartition or add new partition. These partitions may or may not contain data. Indexes used are non partitioned global...
Categories: DBA Blogs

sql execute elapsed time in awr report

Sat, 2017-02-04 12:26
Hello Experts Does "sql execute elapsed time" in AWR report include parse time as well? I am getting time model statistics for a session as : SQL> set pagesize 200 set line 500 select stat_name, value/1000000 seconds from v$sess_...
Categories: DBA Blogs

Pages