TweetShareSharePin0 SharesYou know how it is, when you have that feeling. You are on top of your game. You have a few quick brush strokes to add to a system to make it more dynamic. You have all the small needed changes in your head and you know it is just gonna work. You sit down for some quality time with your computer and with the application builder. It’s gonna be fun and you will get to bask in the […]
Recent Posts
Improving data move on EXADATA V
TweetShareSharePin0 SharesWrap-up This is the last post in this series and I’ll not introduce anything new here, but rather just summarise the changes explained and talk a bit about the value the solution delivers to the organisation. Let’s first review the situation we faced before implementing the changes. The cost of writing the log-records to the database was that all the parallel writing from many different sources was such that it introduced severe bottlenecks to the point that the logging feature […]
Improving data move on EXADATA IV
TweetShareSharePin0 SharesReducing storage requirements In the last post in this series I talked about how we sped up the move of data from operational to historical tables from around 16 hours down to just seconds. You find that post here. The last area of concern was the amount of storage this took and would take in the future. As it was currently taking 1.5 TB it would be a fairly large chunk of the available storage and that raised concerns […]
Improving data move on EXADATA III
TweetShareSharePin0 SharesMoving to history tables In the last post I talked about how we made the speed of actually writing all those log-records much faster. It has to date been so fast that no a single report of a problem has been filed. you find that post here. Once the data was written to the log-tables, it had to be moved to the history tables.This was a process that took around 16 hours. It was never allowed to run for […]
Improving data move on EXADATA II
TweetShareSharePin0 SharesWriting log records The last post in this series introduced the problem briefly. You find that post here. In this post I’ll talk about the changes made to make that writing of log records fast enough. There were 50 million records that was written. Each of them pretty much in its own transaction. Of course the commit activity caused problem, as did log buffer issues. Some of this could be somewhat remedied with configuration. The big issue though was that […]
Faster data move on EXADATA I
TweetShareSharePin0 SharesIntroduction In my work among other things I tune and tweak solutions for EXADATA. Today I’ll write about a big improvement we achieved with a process that moves data from the operational tables to the ones where the history is stored. This will not be a technical post. While I talk about using advanced technologies, I will not discuss code or deep details of them in this post. And yes, when I say post, I mean a series of […]
The power of using records in APEX III
TweetShareSharePin0 SharesIn this post I’ll finish up the CRUD implementation using records, procedures and views. This series of blog posts started with this post which was followed by this. At this point we have a working report that links to a form. The report is based on a view and the form is based on a procedure. At this point the form is only loading the record in using a procedure that uses a record in its signature. In this post […]
Previous post hidden
TweetShareSharePin0 SharesI have hidden my previous post on the explicit request by Oracle Security Team. If you did read it or have it in your RSS, please do not forward or talk about it online until further notice. I’m not sure it is the right thing to do, but I have promised Oracle to not publish it for now. Please help me keep that promise. TweetShareSharePin0 Shares
Can table security be circumvented with a view? (Bug for peer review)
TweetShareSharePin0 SharesMy collegue Daniel Ekberg (@dan_ekb) stumbled on a very strange issue the other day. After having tested it in three separate environments and on both 10g and 11g (11.2.0.1 and 11.2.0.2) we have resigned to believing that this may actually be a bug. If it is, it is a LARGE one. Essentially we can perform insert, update, and delete on a table on which we have only been given select rights. Yes, it sounds as if it really wouldn’t […]
The power of using records in APEX II
TweetShareSharePin0 SharesIn this post I follow up on the post where I started talking about records in APEX. In this post I’ll show how to add a page in front of the form created in that post. Thus this post will show a report and let you navigate to the form where the selected record is displayed. Pretty basic stuff, but it allows better testing of the form and it sets the stage for showing how to make the form […]