This note started life as a nutshell until I realised that it was going to be more of a coconut than a hazel nut and decided to turn it into a short series instead. I should manage to post four parts over the next two weeks: Introduction – this bit Disk and Tablespace Fragmentation Table [...]
Now that Oracle OpenWorld 2010 is just under 70 days away I thought I would take a moment to mention that the Oracle Real-World Performance Group will again be hosting three sessions. This year I think we have a very exciting and informative lineup of sessions that are a must-attend for those wanting to see and hear Oracle Database performance insight right from Oracle’s own performance engineers. Hope to see you there! And for those who are interested, there will likely be many discussions about the Oracle Database Machine and Oracle Exadata. Very hot stuff! Session ID: S317164 (Monday 2:00PM) Session Title: The Latest Real World Performance Challenges Session Abstract: Oracle’s Real-World Performance Group — the group that first presented at Oracle OpenWorld parallel query techniques with partitions, the index-less database, cardinality challenges with the optimizer, over-processed databases and connection storms — this year presents the performance issues before you experience them and how to plan for future projects with success. All topics discussed in this session come from the Real-World Performance Group’s observations and problem solving. Session ID: S317166 (Monday 5:00PM) Session Title: Real-World Performance Panel Session Session Abstract: This session is your chance, via written questions, to ask a [...]
Back from two weeks of vacation I noticed that the schedule of the next OpenWorld is available here.
The detailled information about my session, which is based on chapter 10 of my book, is the following:
ID#
S316683
Title
Join Techniques
Abstract
This presentation explains how the query optimizer joins multiple sets of data to each other. First it explains the operation [...]
I only just noticed because I've fallen behind on my blog reading, but this is one of my favourites, so it'll mean some catch-up reading.
I have created a reference to the PeopleTools tables and views on my website.
In the course of my work on PeopleSoft, I spend a lot of time looking at the PeopleTools tables. They contain meta-data about the PeopleSoft application. Much of the application is stored in various tables that are maintained by Application Designer. Some tables provide information about the Data Model. Others contain configuration data that is maintained via PeopleTools components in the PIA.
Many of my utility scripts query information from PeopleTools tables, and some also update them. Of course, that is strictly not supported, but if you understand how the tables fit together it can be done relatively safely. So, it is very helpful to be able to understand what is in these tables.
I have created a reference to the PeopleTools tables and views on my website.
In the course of my work on PeopleSoft, I spend a lot of time looking at the PeopleTools tables. They contain meta-data about the PeopleSoft application. Much of the application is stored in various tables that are maintained by Application Designer. Some tables provide information about the Data Model. Others contain configuration data that is maintained via PeopleTools components in the PIA.
Many of my utility scripts query information from PeopleTools tables, and some also update them. Of course, that is strictly not supported, but if you understand how the tables fit together it can be done relatively safely. So, it is very helpful to be able to understand what is in these tables.
Systemtap is a scripting language for analyzing linux systems. Systemtap needs debuginformation to be able to know what is going on. Systemtap is considered the “answer” to Sun/Oracle’s DTrace. Systemtap and DTrace differ, most notably because DTrace doesn’t need additional software (debug information) for both kernel and userspace. Let’s see how Systemtap can be installed [...]![]()
Well after a month of watching the World Cup during these long cold Canberra nights, my beloved Spain have finally, at long long last, after years and years of bitter disappointment and despair, have deservedly won the World Cup !! Iniesta, you legend, you will never have to buy a drink ever again, whenever or wherever you walk [...]![]()
My friend Karen Morton asked if I would be willing to contribute to a book that she is working on (i.e. write a few chapters). Of course I said yes. The book’s title is Pro Oracle SQL and it is to be published by Apress sometime before the end of the year (my first deadline is fast approaching).
Karen is the lead author, but there are also several co-authors involved in this project, all of whom I have a lot of respect for. Here’s the List (in alphabetical order by last name):
One of the biggest problems in learning is that you don’t know how much you don’t know, and this reises two questions: how do you find out that there are huge gaps in your knowledge that need to be filled ? how do you know whether or not the material you’re learning from is any [...]
Recent comments
16 weeks 4 days ago
26 weeks 3 days ago
28 weeks 23 hours ago
31 weeks 2 days ago
33 weeks 4 days ago
43 weeks 1 day ago
44 weeks 4 days ago
45 weeks 4 days ago
45 weeks 5 days ago
48 weeks 4 days ago