DBA Blogs

plsql developer - delete memory record

Tom Kyte - Thu, 2017-04-20 08:46
can we delete a record from cursor memory with out effecting main table in plsql
Categories: DBA Blogs

Automatic Memory Management

Tom Kyte - Thu, 2017-04-20 08:46
Hi Tom, I am trying to understand For Automatic Memory Management in 11g.We have MEMORY_TARGET parameter. 1)Can you please explain how MEMORY_TARGET considers SGA_MAZ_SIZE if auto shared memory management is enabled. If i keep sga_targ...
Categories: DBA Blogs

Is it possible for a single session to fully utilize IO?

Tom Kyte - Thu, 2017-04-20 08:46
Dear Tom, We have an Oracle 12c database used mainly as a data warehouse for scientific data. The database has a few very large tables (>1TB) and they are usually accessed via a full table scan. The database is mostly idle having no more than one ...
Categories: DBA Blogs

Predicate evaluation order

Tom Kyte - Wed, 2017-04-19 14:26
I've known for a while that the order of predicate evaluation in a query is non deterministic, as posted by Tom here (https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:696647495510). I even wrote my own blog about it a while back (...
Categories: DBA Blogs

"accessible by" clause in 12.2

Tom Kyte - Wed, 2017-04-19 14:26
Team, Reading through the "accessible by" clause enhancements in 12.2 <u>http://docs.oracle.com/database/122/LNPLS/release-changes.htm#GUID-85A17D6B-4E7A-49D9-B5AC-B0D69390B449</u> <quote> Starting with Oracle Database 12c release 2 (12.2),...
Categories: DBA Blogs

Change font color in SQL*Plus

Tom Kyte - Wed, 2017-04-19 14:26
Hi Tom, I'm pretty sure that recently I stumbled upon an article on some Oracle blog, demonstrating how to change the color of fonts in SQL*plus. (No HTML etc., just the (server)output in SQL*Plus) Unfortunatly I didn't bookmark it, can't find ...
Categories: 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

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

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs