Now in its 28th year, the NoCOUG Journal is the oldest Oracle user group publication in the world. No other small user group in the world has a printed journal. Most large user groups do not have printed journals either. But little NoCOUG does. I am the editor of the NoCOUG Journal and—I must confess—I get sad when I see […]
Wow! it has been a while since I posted something on my blog post. I have been very busy, moving to MongoDB, learning, learning, learning…finally I can breath a little and answer some questions.
Last week I have been helping my colleague Norberto to deliver a MongoDB Essentials Training in Paris. This was a very nice experience, and I am impatient to deliver it on my own. I was happy to see that
When I sat down at my desk yesterday morning I was greeted with some disturbing email alerts notifying me that one of the NFS mounts on my standby database host was full. This was the NFS mount that held an image copy of my database that is updated daily from an incremental backup. The concept and an example can be found in the documentation
. With a 25Tb database, waiting to restore from backups is not (more...)
It’s been a while since I put anything on this blog, most likely down to a combination of being overly busy in my previous life at UKOUG and not having anything to say that couldn’t be said in 140 characters.
Anyway, I’ll be at the UKOUG Tech13 Conference in Manchester (more...)
I've always considered myself a developer and a LOWER(DBA)
. I may have recovered perhaps one database and that was just a sandbox
, nothing production worthy. I've built out instances for development and testing and I've installed the software a few hundred times, at least. I've done DBA-like duties, but (more...)
This looks like an interesting feature of Oracle 12c. I’m still not sure about the security implications but it does say interesting things about pure network monitoring security tools. Now, more than ever, what you see on the network can be something completely different than what runs on the database. So, you can see a […]
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 (more...)
Reducing 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 (more...)
Moving 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 (more...)
Writing 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 (more...)
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 (more...)
Oracle’s “Security Alert Advisory for CVE-2012-3132” issued a warning about an attack vector that once again was discovered by security expert David Litchfield. The vulnerability allows to execute SQL code with SYS privileges by using object names containing quotation marks, if the attacker has authorized access to the database, has CREATE TABLE and CREATE PROCEDURE privileges […]
One of my customers uses AppDynamics as their tool of choice for Application Performance Management of a multi-tier, B2B/B2C application environment with several Oracle Databases at the back end. This tool gives a graphic overview of the application infrastructure, discovers (JDBC or .net) database queries automatically and provides metrics on the response time for those database […]
The New Zealand Oracle Users Group - NZOUG Conference 2013
is open for registrations
and Earlybird pricing is still available! The agenda
is now available.
NZOUG 2013 is being held in Wellington at the iconic Te Papa Museum
on the beautiful waterfront on the 18th and 19th of March, with an additional Workshop Day
on the 20th March.
The conference will see a wealth of brilliant speakers
from around the world, including Tom Kyte, Graham Wood, Andrew Holdsworth, John Schiff and Nadia Bendjedou and of course top speakers from Middle Earth
(NZ) as well. Tom, Andrew and Graham will be (more...)
Today at Amazon AWS re:invent, Amazon announced a cloud service for data warehouse customers. It allows to easily analyse petabytes of data, interacts with known BI solutions, and it’s usually 10 times faster than traditional implementations… queries run really blazing fast! This service is certified by MicroStrategy and Jaspersoft.
Redshift runs (more...)
For several years I’ve been using Oracle and other SQL relational databases. I’ve dedicated most of the time of my researching and developing on Oracle technology. There’s no question that Oracle leads on site installations and that the quality of the products and the ROI is one of the best. (more...)
Just a quick mention when you get the error bellow while trying to create a trigger for example:
CREATE OR REPLACE TRIGGER AGE_GROUP_TRG
BEFORE INSERT ON AGE_GROUP REFERENCING
NEW AS NEW
FOR EACH ROW
SELECT AGE_GROUP_SEQ.nextval INTO :NEW.AGE_GROUP_ID FROM dual;
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg1], , , , , , , , , , , 
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
00603. 00000 - “ORACLE server session terminated by fatal error”
*Cause: An ORACLE server session (more...)
We can’t stop the social flow! Social networks are ruling the world. So as I had some free time lately, I decided do create a facebook fan page. For most of us with a facebook profile visited daily, it’s easier to follow syndications and we’ve got a better (more...)
In the last 10 weeks suddenly I lost 80% of my blog visits… thanks to google! In the last 6 months I found dozens of copycats of posts I wrote and those sites have a greater rank than my legit original blog!
For that, Thank you a lot google… you’re (more...)
Red Hat Enterprise Linux has been out since November of 2010. Here we are 16 months later and it's not certified for database use by Oracle yet.
Yes, I know the database can be installed on RHEL6. In fact, I have it running in my development environment right now with no issues related to the OS/DB integration. Try to get Oracle Support to help you on those platforms for an issue unrelated to