Tom Kyte

Subscribe to Tom Kyte feed Tom Kyte
These are the most recently asked questions on Ask Tom
Updated: 1 month 1 day ago

Can be differentiate cascade delete or statement(delete from query) inside the table trigger

Mon, 2016-07-04 07:46
Hi Tom, i have question about cascade delete, How its work internally and how to differentiate that row by delete from delete statement on child table or row deleted by a cascade delete. because i am facing problem and try to solve Mutating error...
Categories: DBA Blogs

Partitioning Questions

Mon, 2016-07-04 07:46
Hello I would like to post a question related to which partitioning I can go for based on the below scenario. I have 2 tables named table1 and table2. Both the tables are having customer I'd and user id column. The hierarchy is multiple users...
Categories: DBA Blogs

the maximum number of logical operators(AND/OR) can be used in where clause

Mon, 2016-07-04 07:46
Hi Tom, How many maximum number of logical operators(either AND/OR) are allowed in where clause in select statement. eg select * from employees where first_name = 'abc' or first_name = 'cde' or first_name = 'def' or .... .... .......
Categories: DBA Blogs

Composite partition

Mon, 2016-07-04 07:46
Hi Team, We have a requirement to use composite partition for few partition from the list of partition. Please consider below create team where in we are using composite partition using 2 columns RELATED_CLOSED_REQ_STAMP and Request_Id. Main parti...
Categories: DBA Blogs

when to use bitmap or b tree index?

Mon, 2016-07-04 07:46
when to use bitmap or b*tree index? And which one is best for containing 1 Milion rows in a single table contain child-parent relationship?
Categories: DBA Blogs

Using existing exception names

Mon, 2016-07-04 07:46
You have define an exception type and named it as invalid_number on execution,your plsql code raises exception invalid_number internally.In this case what should you do in order to handle this kind of situation. 1..Exception when invalid_number. 2....
Categories: DBA Blogs

expdp from physical standby database

Sun, 2016-07-03 13:46
Have a good day I am trying to export using expdp from the standbay server to offload the load from the production So I follow Oracle Doc ID : 1356592.1 but I get the follwing error Export: Release 11.2.0.4.0 - Production on Sat Jul 2 18...
Categories: DBA Blogs

How do instead-of-triggers work

Sun, 2016-07-03 13:46
1)After updating on complex view by using instead of trigger which table will affect first and why.
Categories: DBA Blogs

impdp parallel

Sun, 2016-07-03 13:46
Dear TOM when i impdp a db user with parallel parameter,does it really create the indexes with the parallel degree which i specified? thank you.
Categories: DBA Blogs

Questions about performance tuning.

Sun, 2016-07-03 13:46
I am working as plsql developer with 2 years of experience and I have some doubts which listed below. 1- What are the basic concepts I should know as a junior engineer about performance tuning. 2- What is the performance of " select * from Emp...
Categories: DBA Blogs

Dataguard in SE edition

Sun, 2016-07-03 13:46
I know that oracle 11g SE edition does not support any data guard. so Is it possible to create a physical standby database with RMAN on SE edition? help
Categories: DBA Blogs

why ref cursor is inefficient that regular cursor

Sun, 2016-07-03 13:46
I have seen many posts and observed that Ref Cursors are inefficient when compared to Regular cursors. it would be great if you explain me what happens internally and why ref cursors are inefficient than regular cursors.
Categories: DBA Blogs

OOW

Sun, 2016-07-03 13:46
Hello Sir, Can we have your presentation from OOW 2010? Thanks & Regards
Categories: DBA Blogs

Getting values dynamically

Sat, 2016-07-02 19:26
Hi, I will pass table_name tabl1 and its primary key value pk=(some value). My requirement is suppose there is table1, its has primary key pk1 and also it has unique keys ak1,ak2 , And its one of unique keys is foreign key to table2, now i require...
Categories: DBA Blogs

Count months 15 days record.

Sat, 2016-07-02 01:06
Hi, I want to count records from my database table on every month's 15 days count in respect any group by Id. Like : GroupBy_Id Count statDate EndDate 5 15 01-Mar-2016 15-Mar-2016 5 2 16-M...
Categories: DBA Blogs

How to schedule a script in sql developer

Sat, 2016-07-02 01:06
Hi; I have tried many ways to schdule an a script using sql developer;But for these scripts those are failed.But those can nicely run using built in oracle sql-plus.i can use the script by using @ sign and with the file name (eg : @filename) Here...
Categories: DBA Blogs

SQL Server 2016 TCO

Fri, 2016-07-01 07:06
Team, i was going through this link. https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Comparing the cost of SQL Server 2016 with Oracle 12c, Oracle cost 12x more. We know Ora...
Categories: DBA Blogs

Block user account to PRIMARY production server and move them to the REPORTING STANDBY Db.

Fri, 2016-07-01 07:06
We are planning to all our Business users to use our read only Active data guard standby database and restrict them using the Primary production database using logon trigger. But as part of security, users have to change their passwords every 60 ...
Categories: DBA Blogs

How to validate the XML data exists in the XML table

Fri, 2016-07-01 07:06
Hi Tom, Can you please help me on how to validate the XML data available in the XML table. I have one XML table as: CREATE TABLE TEST_XML OF XMLTYPE XMLTYPE STORE AS SECUREFILE BINARY XML; And the data as: INSERT INTO TEST_XM...
Categories: DBA Blogs

Would there be a better way of improving the performance?

Fri, 2016-07-01 07:06
I have a code as shown. Objective of this piece of code is to give a report on counts for student enrollments, student absences and percentage present in the district starting from the first day of school up until the last day (i.e. a total of 18...
Categories: DBA Blogs

Pages