DBA Blogs

Huge Pages use for improvement of performance

Tom Kyte - Wed, 2017-04-19 14:26
hello, i would like to know the use of Huge pages in 12c for performance improvements. we got suggestion for implementing the Huge pages for performance improvements. could you advice on this?? thanks
Categories: DBA Blogs

SYS_REF_CURSOR AND REF CURSOR

Tom Kyte - Wed, 2017-04-19 14:26
Hi, When i learning about Cursor Variable (Ref Cursor) on One Website I found this Code. <code> CREATE OR REPLACE FUNCTION f RETURN SYS_REFCURSOR AS c SYS_REFCURSOR; BEGIN OPEN c FOR select * from dual; RETURN c; END; / set se...
Categories: DBA Blogs

import metadata with segment attributes deffered

Tom Kyte - Wed, 2017-04-19 14:26
Hi Tom, While doing metadata import of a schema using impdp its taking too much of space for creating empty partitions. Initialization parameter deferred_segment_creation is set to true still the partitions are taking space. Is there any way to im...
Categories: DBA Blogs

How does PIVOT work?

Tom Kyte - Wed, 2017-04-19 14:26
Hi, I tried to learn PIVOT concept to Pivot the Rows to Columns, but i could not understand how it works internally and how it identify which rows should get turn into Columns. So would you Explain How it Makes Rows as Columns.
Categories: DBA Blogs

Process to add temp tablesoaces in a Data Guard environment

Tom Kyte - Wed, 2017-04-19 14:26
We have a physical Data Guard environment. When checking the standby, a new temporary tablesoaces was not added to the standby (but is on the primary). I understand why it's not being automatically created on the standby. However, what's the best ...
Categories: DBA Blogs

Submitted two abstracts for Oracle OpenWorld 2017

Bobby Durrett's DBA Blog - Wed, 2017-04-19 14:07

I submitted two abstracts for Oracle OpenWorld 2017. I have two talks that I have thought of putting together:

  • Python for the Oracle DBA
  • Toastmasters for the Oracle DBA

I want to do these talks because they describe two things that I have spent time on and that have been valuable to me.

I have given several recent talks about Delphix. Kyle Hailey let me use his slot at Oaktable World in 2015 which was at the same time as Oracle OpenWorld 2015. Right after that I got to speak at Delphix Sync which was a Delphix user event. More recently I did a Delphix user panel webinar.

So, I’ve done a lot of Delphix lately and that is because I have done a lot with Delphix in my work. But, I have also done a lot with Python and Toastmasters so that is why I’m planning to put together presentations about these two topics.

I probably go to one conference every two years so I’m not a frequent speaker, but I have a list of conferences that I am thinking about submitting these two talks to, hoping to speak at one. These conferences are competitive and I’ve seen that better people than me have trouble getting speaking slots at them. But here is my rough idea of what I want to submit the talks to:

I’ve never gone to RMOUG but I think it is in Denver so that is a short flight and I have heard good things.

Also, we have our on local AZORA group in Phoenix. Recently we have had some really good ACE Director/Oak Table type speakers, but I think they might like to have some local speakers as well so we will see if that will work out.

If all else fails I can give the talks at work. I need to start working on the five speeches in my Toastmasters “Technical Presentations” manual which is part of the Advanced Communication Series. I haven’t even cracked the book open, so I don’t know if it applies but it seems likely that I can use these two talks for a couple of the speech projects.

Anyway, I’ve taken the first steps towards giving my Python and Toastmasters speeches. Time will tell when these will actually be presented, but I know the value that I have received from Python and Toastmasters and I’m happy to try to put this information out there for others.

Bobby

Categories: DBA Blogs

Compress Basic Table

Tom Kyte - Tue, 2017-04-18 20:06
Tom, I need help. -If I create a table with COMPRESS BASIC on the partitions and then I insert data from another table does not decrease the size. -Now if I create a table from another with a: CREATE TABLE AS SELECT * FROM TABLE_2 And COMPRESS ...
Categories: DBA Blogs

Swap memory

Tom Kyte - Tue, 2017-04-18 20:06
Hi Team, In which case Oracle uses Swap memory. If we set Memory_target=10G parameter Oracle allocates SGA + PGA which that 10G only. Thanks & Regards Krishna.
Categories: DBA Blogs

Can I optimize the auto extend operation by changing the resizing value?

Tom Kyte - Tue, 2017-04-18 20:06
Hi, I'm using Oracle database 12.1.0.2.0 on Windows 64-bit The alert log is showing many "Resize operation completed for file#..." messages and the "Resource monitor" is showing I/O intensive usage. select * from DBA_DATA_FILES shows that the IN...
Categories: DBA Blogs

How to remove the duplicates records which are in two different columns of a single table.

Tom Kyte - Tue, 2017-04-18 20:06
I have table called "DUPLICTAE" which contains the below records. I need the below desired ouput... <code>COL1 | COL2 :----- | -----: banglore | chennai kolkata | pune chennai | mysore pune | banglore mysore | kolkata mumba...
Categories: DBA Blogs

Loading a file in External Table with a fields more than 4000 characters

Tom Kyte - Tue, 2017-04-18 20:06
Hi Tom, I have a file with the following structure: <code>+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= 2017-03-01 16:17:08 : INFO : (65193 | WRIT...
Categories: DBA Blogs

Getting Started with Oracle Developer Samples

Are you just joining Oracle's transformation journey to Cloud? Are you just getting used to working with the technology leader ? Having trouble getting started?  Oracle is developing,...

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

Down the performance of single table using Various DML Operation.

Tom Kyte - Tue, 2017-04-18 01:46
Suppose I have a table that's called account_detail of customer account detail. And This table contain 100,000,000 Rows. suppose we fire select query on this table and at a same time may or may not be insert or update or delete record fire by staff...
Categories: DBA Blogs

PL SQL Bulk Insertion with a Mapping

Tom Kyte - Tue, 2017-04-18 01:46
I have a table Trans containing around 10 billion records an having index on a column "customer_id". Table Structure : FCT_Trans customer_id varchar2(20), trans_date date, trans_type varchar2(10), Cust_name varchar2(100), ect I have another ...
Categories: DBA Blogs

Trigger

Tom Kyte - Tue, 2017-04-18 01:46
Hi Team, I have to create a trigger which will record the old value as well as new value in case of insert. Situation is that I have one application and on frontend part whenever some changes happened then the xyz_id got changed. At the backend, ...
Categories: DBA Blogs

Migrating huge tables with blobs

Tom Kyte - Tue, 2017-04-18 01:46
Hello Tom, we migrate from informix to oracle and we have this problem : we have to unload tables with millions records, each record has blob, blobs are unloaded in some blob files with size near 2 GB. 170 thousand blobs are in one blob fil...
Categories: DBA Blogs

Loading data to CLOB column

Tom Kyte - Tue, 2017-04-18 01:46
Hello, I have 2 tables T1 and T2: <code> CREATE TABLE "T1" ("DATE_M" DATE, "ID" VARCHAR2(20), "ADDR" VARCHAR2(17), "VER" VARCHAR2(50), "MODEL" VARCHAR2(10), "ADD_I" VARCHAR2(10), "SN" VARCHAR2(15), "MODE" VARCHAR2(5), ...
Categories: DBA Blogs

Storing historic records

Tom Kyte - Tue, 2017-04-18 01:46
Hi, I have a requirement to write a view on the table containing historic price information of different products. The 1 st history record(when sorted in an asecnding order of date) for a product should have the GRANT_DATE as the effective_date...
Categories: DBA Blogs

How to find the object that caused ORA-08103 error

Bobby Durrett's DBA Blog - Mon, 2017-04-17 14:50

A developer told me that two package executions died with ORA-08103 errors and he didn’t know which object caused the errors.

I found two trace files that had the following contents:

*** SESSION ID:(865.1201) 2017-04-17 10:17:09.476
OBJD MISMATCH typ=6, seg.obj=21058339, diskobj=21058934, dsflg=100000, dsobj=21058339, tid=21058339, cls=1

*** SESSION ID:(595.1611) 2017-04-17 10:17:35.395
OBJD MISMATCH typ=6, seg.obj=21058340, diskobj=21058935, dsflg=100000, dsobj=21058340, tid=21058340, cls=1

Bug 13844883 on Oracle’s support site gave me the idea to look up the object id for the diskobj part of the trace as the current object id. So, I needed to look up 21058934 and 21058935. I used this query to find the objects:

select * from dba_objects where DATA_OBJECT_ID in
(21058934,
21058935);

This pointed to two index partitions that had been rebuilt while the package was running. I’m pretty sure this caused the ORA-08103 error. So, if you get an ORA-08103 error find diskobj in the trace file and look it up as DATA_OBJECT_ID in dba_objects.

Bobby

Categories: DBA Blogs

Deploying a SpringBoot Application to Oracle App Container - Part 2/2

In the first part of this blog, I have created a simple SpringBoot application and tested it locally. In this second part I am going to deploy this application to Oracle Application Container Cloud...

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

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs