Just a quick note to say Oracle Midlands Event #11 is nearly here.
Cheers
Tim…
The old question about truncate and undo (“does a truncate generate undo or not”) appeared on the OTN database forum over the week-end, and then devolved into “what really happens on a truncate”, and then carried on.
The quick answer to the traditional question is essentially this: the actual truncate activity typically generates very little undo (and redo) compared to a full delete of all the data because all it does is tidy up any space management blocks and update the data dictionary; the undo and redo generated is only about the metadata, not about the data itself.
In the previous post, I mentioned that for a programming environment fetching rows from the database, then the method of
might not be appropriate for those situations where the result set is known be a single row (eg primary key lookup).
A better option might be to call a procedure and get those outputs as parameters.
And I broke a cardinal rule… I effectively said “Here’s something that I know to be true…so you should just trust me“.
Dear oh dear oh dear. That’s not good.
In various programming environments, a common metaphor is to open a cursor on the database (a REF CURSOR in Oracle parlance), return that cursor handle to the calling environment, and then that cursor is used to fetch or “fill” a data object, which may map to a grid on screen, or just to an array in memory.
And that’s totally fine – its an effective means to obtain a result set from the database to the calling environment.
For example, a typical PLSQL routine might look like:
PROCEDURE my_proc(p_resultset IN OUT sys_refcursor) IS
BEGIN
OPEN p_resultset FOR
SELECT col1, col2, col3, ...
FROM my_table
WHERE status = 'Unprocessed';
END;
That’s fine when you want a set of rows, and luckily, most programming environments have evolved to the state nowadays where they will perform that retrieval with an array fetc
Back on August 7th, the RMOUG’s Quarterly Education Workshop, I walked everyone through using a Pibrella board to create an art or flyer project that was powered with a python script and a motor.
In general, performance tuning is quite straightforward. You work out how much time is spent doing what, and follow the numbers to the things that are taking the most time. If you are fortunate to the have the Diagnostics Pack on Enterprise Edition of Oracle your Active Session History (ASH) will report the active database sessions. If you can measure the overall response time of a batch or application server you have merely to deduct the DB reported in ASH, and the difference is client/middleware time.
While that is an over-simplification, it is substantially true. The rest of this blog is about an exception to the general rule.
Hash Tag #otw15
Follow us on twitter
Oaktable World brings together some of the Oracle performance people in the world to present and discuss their findings.
Oaktable World is open to everyone free of charge and no registration necessary !
Oaktable World is Monday and Tuesday of Oracle Open World 2015 and is located on the same block as OOW.
Oaktable World is also hosting hands on labs Tuesday 12:30-4:30. The labs will have experts from
to assist you on installing Delphix, DBvisit, and Toad on your laptops. Delphix for example has a free version called Delphix Express that you can install during the labs.
August 23, 2015 (Modified August 31, 2015, September 14, 2015) (Back to the Previous Article in this Series) I started using Linux in 1999, specifically Red Hat Linux 6.0, and I recall upgrading to Red Hat Linux 6.1 after downloading the files over a 56k modem – the good old days. I was a little […]
I wrote a few months ago about having a play with Windows 10 (here).
I’m visiting family today, catching up on all the Windows desktop (and mobile phone) support that I missed while I was away.
I purposely postponed the Windows 10 update on the desktops before I went away, but now I’m back I did the first of them.
The update itself was fine, but it did take a long time. Nothing really to write home about.
For those of you lucky enough to live on the western half of Australia, I’ll be presenting at a couple of events in both Perth and Adelaide in the coming weeks. On Wednesday, 9th September 2015, I’ll be presenting on Oracle Database 12c New Features For DBAs (and Developers) at a “Let’s Talk Oracle” event […]
Recent comments
3 years 3 days ago
3 years 12 weeks ago
3 years 17 weeks ago
3 years 17 weeks ago
3 years 22 weeks ago
3 years 43 weeks ago
4 years 11 weeks ago
4 years 41 weeks ago
5 years 25 weeks ago
5 years 26 weeks ago