Recently, there was trouble in the air. I migrated a database into 11g to enjoy adaptive cursor sharing, but it did not adapt cursors. In the trouble shooting process, I discovered the following: Bug 8357294: ADAPTIVE CURSOR SHARING DOESN’T WORK FOR SQL FROM PL/SQL Nice one. A short quotation from the bug text: PL/SQL has […]
Category: Oracle
What’s the difference between Larry Ellison and god?
Talk about Database Technology Basics at Berufsschule Wiesau
Once again, I will talk about an IT topic at Vocational School (Berufsschule) Wiesau. This year, it’s Basics of Database Technology (Grundlagen der Datenbanktechnik) for 11th and 12th-graders, who will become certified IT specialists for software development soon. Their certification is called “Fachinformatiker der Fachrichtung Anwendungsentwicklung” in German. The paper for the talk is available […]
Oracle Technology Day Storage Optimisation – Impressions
In January, I’ve bee rather busy, so the blog was left alone. No sense in blogging just to blog. Now some content. I attended the Oracle Technology Day – Storage Optimisation in Bonn, Germany. It was a nice event, lots of information, a bit commercials, excellent catering. But this is a technical blog, let’s talk […]
Oracle 11g: Password expired, account locked – unwanted!
Hi, it’s old news, but oracle 11g expires passwords after 180 days, and locks you out if you mistype your password 10 times, and most DBAs don’t like that. It’s unsecure, but for client-server-applications a locked account is no single-user-annoyance, it’s a downtime killing SLAs, nerves and – hopefully not – DBA jobs. So just […]
DOAG Konferenz 2009: Impressions Day 3 (final)
Thursday 19th was the last day of DOAG Confernce 2009. Compared with the second day, the program was much more dense: For my (DBA) profile there have been several hours, where more that one talk would have been appropriate. This list is, what I collected during the day. […]
DOAG Konferenz 2009: Impressions Day 2
As promised, today my impressions of yesterday (confusing, I know). Clarification: This is about Wednesday, November 18th. I’m still at DOAG Conference 2009 in Nuremberg. Wednesday was a silent day for my interests, especially at noon there have been less talks being of interest, but maybe they have done something for my general knowledge… So […]
DOAG Konferenz 2009: Impressions Day 1
These days, the DOAG Conference 2009 happens in Nuremberg, Germany. First day was yesterday, Tuesday November 11th 2009. This is a machine-readable copy of my scratchpad, coming from the different talks I attended. Sun Oracle Database Machine Exadata 2: The “Quarter Rack” (consisting of 2 Servers and 3 storage nodes) sounds interesting. 11gR2 has some […]
New My Oracle Support (ex. Metalink): Use without flash: HTML Option
In the last days, My Oracle Support was redesigned. But since flash is a performance eater and not always available, people like to have an option to use My Oracle Support (formerly Metalink) with HTML only. The link to it is well-hidden, but nevertheless useful! Give it a try: https://supporthtml.oracle.com Best regards Usn […]
Oracle: Recreate PLAN_TABLE
drop table plan_table; @?/rdbms/admin/utlxplan.sql […]
AIX: Avoiding “ORA-27126: unable to lock shared memory segment in core”
Did you ever change lock_sga = true for an Oracle Instance on AIX 5.3, and did see ORA-27126: unable to lock shared memory segment in core IBM AIX RISC System/6000 Error: 1: Not owner in Return? Do the following: # vmo -o v_pinshm v_pinshm = 0 # vmo -o v_pinshm=1 Setting v_pinshm to 1 # […]