DBA Blogs

How to identify null columns vs null rows in left join

Tom Kyte - Fri, 2017-08-04 11:26
Hi Chris/Connor, I have a below query output: <code>select tab1.usr, tab2.salary from tab1 LEFT JOIN tab2 ON (tab1.usr = tab2.usr and tab1.name = tab2.name); USR salary ----- ------- 1111 5001 2222 NULL 3333 NULL Since usr: 22...
Categories: DBA Blogs

Oracle FY18 Partners Immersion Training

This Oracle fiscal year, the FY18 Partners Immersion Training to our OPN partners promises to be a modern learning engagement designed to provide the building blocks to: Articulate the...

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

Duplicate records in MLOG

Tom Kyte - Thu, 2017-08-03 17:06
Is it possible to restrict creation of duplicate record in MLOG. In our scenario, same record is updated twice then it is creating two record in MLOG and fast refresh is taking longer time. Is it possible if it create only one record in MLOG n...
Categories: DBA Blogs

Materialized view

Tom Kyte - Thu, 2017-08-03 17:06
Hi Tom Just wanted to know whether materialized view will be available for querying during refresh if refresh is performed using atomic refresh=>false..?
Categories: DBA Blogs

SQL_Target,tablespace Question

Tom Kyte - Thu, 2017-08-03 17:06
1)What happen when SGA_MAX_SIZE & SGA_TARGET not define under Init parameter file? 2)When extending datafile with Auto extend on command without specifying size what will happnen?
Categories: DBA Blogs

ENABLE PARALLEL DML Vs FORCE PARALLEL DML

Tom Kyte - Thu, 2017-08-03 17:06
Hi Chris/Connor, I came across below two piece of codes where only difference is "ALTER SESSION FORCE PARALLEL DML PARALLEL 16" Can you please help to understand if we need to perform DELTE using parallelism, do i need to write both ALTER SESSI...
Categories: DBA Blogs

update bulk row based on case statement

Tom Kyte - Thu, 2017-08-03 17:06
Hello Experts, We have a requirement as per below example, For Example, Need to create a procedure which fulfill below condition, create or replace procedure as <declaration part> Begin select emp_id,emp_name,mgr_id, (case when dep...
Categories: DBA Blogs

Multiple inserts in a PL/SQL block

Tom Kyte - Thu, 2017-08-03 17:06
Hi Gurus, I have a piece of code similar to the one below: I have a table in which I have to make insert as given below : The select fetches multiple rows and my manager doesn't want me to use cursor or bulk collect to make the code usable. ...
Categories: DBA Blogs

Response obtained from SoapUI but not through PLSQL using UTL_HTTP

Tom Kyte - Thu, 2017-08-03 17:06
Hi, Need your advice and help. <b>Problem Description</b> We have a requirement of invoking a web-service for uploading data in tax authority website. We have been provided a WSDL url which contains the data about the web-service we need...
Categories: DBA Blogs

Sorting concatenated number list inside a string column

Tom Kyte - Wed, 2017-08-02 22:46
Hello, I have a column in the table that has a current value for example '29|1|3004|3|2|24' I want to rearrange the value in the order to '|1|2|3|24|29|3004' I'm trying to do that without creating temp table or any holding place is there way to do ...
Categories: DBA Blogs

Performance tuning a SQL query

Tom Kyte - Wed, 2017-08-02 22:46
Hello, I need to increase the performance of the following query,Please suggest alternative,this is taking longer time in production. SELECT * FROM ( SELECT MAX (IDN_HEADER_DATA_EXCH) AS IDN_HEADER_DATA_EXCH_MAX, NBR_...
Categories: DBA Blogs

SQL Execution Speed depending on Line Breaks in Query

Tom Kyte - Wed, 2017-08-02 22:46
Dear Tom, if I execute in Toad a query like: select * from SOMESCHEMA.TABLE_A A join SOMESCHEMA.TABLE_B B on B.A_ID = A.A_ID join SOMESCHEMA2.TABLE_C C on A.C_ID = C.C_ID join SOMESCHEMA.TABLE_D D on B.D_ID = D.D_ID where C.C_ID = 1234; ...
Categories: DBA Blogs

By DBA user through After Logon Triggers

Tom Kyte - Wed, 2017-08-02 22:46
Hi, we have schema owner user named ABC, that execute our dayend jobs and as per application requirement it required a DBA role as the application is in development phase, what i needed to do is to fix that only a machine with specific IP address...
Categories: DBA Blogs

September AZORA meeting

Bobby Durrett's DBA Blog - Wed, 2017-08-02 10:30

The September AZORA meeting has a great lineup of speakers. AZORA is the Arizona Oracle User Group. Republic Services is providing us with an excellent place to meet off of the 101. I’m looking forward to it. Check it out if you are in the Phoenix area.

Bobby

#meetup_oembed .mu_clearfix:after { visibility: hidden; display: block; font-size: 0; content: " "; clear: both; height: 0; }* html #meetup_oembed .mu_clearfix, *:first-child+html #meetup_oembed .mu_clearfix { zoom: 1; }#meetup_oembed { background:#eee;border:1px solid #ccc;padding:10px;-moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;margin:0; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; }#meetup_oembed h3 { font-weight:normal; margin:0 0 10px; padding:0; line-height:26px; font-family:Georgia,Palatino,serif; font-size:24px }#meetup_oembed p { margin: 0 0 10px; padding:0; line-height:16px; }#meetup_oembed img { border:none; margin:0; padding:0; }#meetup_oembed a, #meetup_oembed a:visited, #meetup_oembed a:link { color: #1B76B3; text-decoration: none; cursor: hand; cursor: pointer; }#meetup_oembed a:hover { color: #1B76B3; text-decoration: underline; }#meetup_oembed a.mu_button { font-size:14px; -moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;border:2px solid #A7241D;color:white!important;text-decoration:none;background-color: #CA3E47; background-image: -moz-linear-gradient(top, #ca3e47, #a8252e); background-image: -webkit-gradient(linear, left bottom, left top, color-stop(0, #a8252e), color-stop(1, #ca3e47));disvplay:inline-block;padding:5px 10px; }#meetup_oembed a.mu_button:hover { color: #fff!important; text-decoration: none; }#meetup_oembed .photo { width:50px; height:50px; overflow:hidden;background:#ccc;float:left;margin:0 5px 0 0;text-align:center;padding:1px; }#meetup_oembed .photo img { height:50px }#meetup_oembed .number { font-size:18px; }#meetup_oembed .thing { text-transform: uppercase; color: #555; }
Starting the fall with a bang! Rich Niemiec, Jerry Ward, Benoit Chaffanjon

Thursday, Sep 21, 2017, 10:00 AM

Republic Services – 2nd Floor Conference Rooms
14400 N 87th St (AZ101 & Raintree) Scottsdale, AZ

6 AZORAS Attending

Wow! We’re coming off of the summer break with a bang! We’ll have three speakers: Rich Niemiec and Jerry Ward from Viscosity, followed by Benoit Chaffanjon, Oracle VP of Enterprise Solutions and Chief Architect.We’ll also be starting earlier in the day at 10:00 am to change things up!Save the date! Thursday, September 21st, 10am-2:30pmFor the la…

Check out this Meetup →

 

Categories: DBA Blogs

Transparent Data Encryption Architecture: Quickly and Easily

We have covered in the past a lot of information on database security via posts and partner webcasts such as Partner Webcast - Oracle Database Security Inside-Out. Moving to cloud, data...

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

Queue_to_Queue Propagation does not Propagate Messages but no errors are reported

Tom Kyte - Wed, 2017-08-02 04:26
We are trying to set up an AQ Schedule Propagation between two JMS (RIB version 13.1.8 to RIB version 16.0.0). We followed all documentation steps to set this up, but even with the AQ JOB created and running, the message is not being dequeued from th...
Categories: DBA Blogs

Same query from multipule sessions, but dont see Read By Multipule Session

Tom Kyte - Wed, 2017-08-02 04:26
Hi, I was going through the below link, and doing some testing of my own. http://oracleinaction.com/simulate-buff-busy/ Focusing only on the below. PROCEDURE RUNSELECT as cursor dummy is select * from t; c1 t_refcur; rec dummy...
Categories: DBA Blogs

Oracle Text - synonym of a word !

Tom Kyte - Wed, 2017-08-02 04:26
Hi All, I have questions about Oracle Text 12c. And I would like to have your supports on this. 1. Synonym of a word For example, I have a word "REVEAL" and can I get all the synonyms of the REVEAL, such as: show, display, exhibit, disclose, u...
Categories: DBA Blogs

Truncate Statement running for hours in 11.2.0.2

Tom Kyte - Wed, 2017-08-02 04:26
Team: As requested at this link (https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:283015939157#9536017900346127115 ) posted this as a new question. Very recently in our database, we identified that few "Truncate Table" statem...
Categories: DBA Blogs

Model

Tom Kyte - Wed, 2017-08-02 04:26
Hi Masters, I have below questions with oracle Model clause: 1. Was the name Spreadsheet initially ? When to use Model clause, does it worth learning for oracle ebs developers ? or is it totally warehousing thing ? 2. Why so many people don't us...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs