DBA Blogs

trigger

Tom Kyte - Tue, 2016-07-05 20:26
Hi, my table is with fist name , last name , status. Now the thing is I want to change the status to "APPROVED" as soon as I made the entry in last name, if last name column is empty status should be default lets say "PENDING". I tried it u...
Categories: DBA Blogs

High Soft Parsing

Tom Kyte - Tue, 2016-07-05 02:06
Hi Tom, We are experiencing high Soft parsing in our databases , though we have enabled session cached cursors and all our SQL/PL SQL blocks using bind variables. We are using Pro C as a host language interact with the back end database. Load...
Categories: DBA Blogs

Can we do a CTAS (Create table as) without the NOT NULL constraints?

Tom Kyte - Tue, 2016-07-05 02:06
Can we do a CTAS (Create table as) and create the new table without the NOT NULL constraints? select * from v$version; Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE ...
Categories: DBA Blogs

Format the Number for display

Tom Kyte - Tue, 2016-07-05 02:06
<code>Hello Guru, Q1) I need to display numbers from a database in a specific format. Table Tn (n number(6,3)); The format is 999.999 SQL> insert into tn values( 123.123) ; 1 row created. SQL> insert into tn values(0) ; 1 row created. SQL...
Categories: DBA Blogs

NOLOGGING

Tom Kyte - Tue, 2016-07-05 02:06
Hi, We have a problem, each day our DR setup is getting about 300 GB of data. We have found this is due to the huge amount of archive logs being written. We have certain bulk operations that are taking place, most of which are from bulk deletes or...
Categories: DBA Blogs

Retreive userid who has taken training more than once

Tom Kyte - Tue, 2016-07-05 02:06
Hi Tom, I have 2 tables user and training User Userid Username Trainingid 1 A 1 2 B 2 3 C 2 4 D 3 5 E 2 Training Trainingid trainername userid countoftrainings Date 1 X 1 2 ...
Categories: DBA Blogs

oracle text with order by clause

Tom Kyte - Mon, 2016-07-04 07:46
Dir Sir: I am developing an anti-plagiarism system, I am using Oracle text to search for my text. my corpus contains more than 30 million of records. I want to check my document against this corpus. I want to fetch the highest score only, not all...
Categories: DBA Blogs

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

Tom Kyte - 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

Tom Kyte - 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

Tom Kyte - 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

Tom Kyte - 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?

Tom Kyte - 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

Tom Kyte - 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

Persistent storage in Oracle Compute Cloud (IaaS)

&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;span...

We share our skills to maximize your revenue!
Categories: DBA Blogs

ACS, SQL Patch and SQL Plan Baseline

Hemant K Chitale - Mon, 2016-07-04 03:49
Marko Sutic's blog post on Adaptive Cursor Sharing and SQL Plan Baselines, with an example of SQL Patch as well.
.
.
.
Categories: DBA Blogs

expdp from physical standby database

Tom Kyte - 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

Tom Kyte - 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

Tom Kyte - 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.

Tom Kyte - 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

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs