Posts Categorized: Oracle
I’ve been just sending the abstracts for UKOUG 2009 Conference before the extended deadline is over and realized that I hadn’t spread those exciting news. Actually, the news spread via Twitter before I saw the official confirmation in my inbox. Well, I guess the blog post title says it all. It’s a pleasure to join this program and get engaged in its activities.
This is the 150th edition of Log Buffer, the weekly review of database blogs.
This meetup will be focused on storage technologies for Oracle database. It looks like a short presentation on Oracle Automatic Storage Management is in order – quite a few people are missing the concepts of the Oracle flagman storage storage solution and it’s useful to understand the approach whether you use it now or not.
About six months ago, the question of storing images in a database came up. This is one of my favorite topics, and has many database-agnostic parts. Personally, I think “tell me about storing images in a database” is actually a great interview question, because you will be able to see the difference between someone who has just memorized “what’s right” versus someone who is really thinking. It also helps you see how someone will communicate.
A couple of weeks ago, we noticed some timeouts in some of our standard Oracle RDBMS health check scripts on a new instance. At first the timeouts were infrequent, but over the course of a week started to grow in frequencey until the point where none of the checks were finishing in the allowed timeframe. We ran an AWR report, and tucked far down in the “Latch Activity” section, a colleague noticed this…
Resource Manager not only allows one to define how much CPU a certain user or group gets, it also lets one switch into lower priority groups and kill a query while leaving the session running. It is like running a SELECT statement in sqlplus, and pressing ctrl-c. The session is still alive, yet the query is canceled. Sure, the Resource Manager is documented by Oracle, but when I started to test this feature, I came across a few very interesting things that are not as well documented, and that’s what prompted me to write this post
This is the 149th edition of Log Buffer, the weekly review of database blogs.
Just got an interesting note on Twitter that you can’t call a stored procedure dynamically in Oracle from a PL/SQL block like passing the procedure name in a variable. Well, yes we can! And the answer is EXECUTE IMMEDIATE — it can be used to run anonymous PL/SQL blog and not just a SQL statement. However, you will want to think many many times before doing so… if you love your data. Let’s create the test procedures…
I think it was the smallest group so far which is not surprising considering that Monday has been the least popular day in our internal poll. We had a tad less than 20 people but very good size for the informal discussion of Oracle 11g adoption that took place at the second half of the meetup.
Paul Vallée, Pythian’s founder and Executive Chairman really opened our eyes. Paul talks about Oracle’s 11G features with the same enthusiasm he has for MySQL’s federated architecture, or for SQL Server’s peer-to-peer replication technology. You could hardly find anybody who presents his visionary views of the new technology trends like cloud computing, virtualization, or server consolidation with such a deep understanding of the topics. Here is your opportunity to confer with Paul Vallée on Thursday, June 4, 2009 12:00 PM–1:00 PM CEST (11AM–12:00 PM GMT) in a free webinar, Database Platform Migration.