Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

March 2013

Open Cursors

Submitted by Jonathan Lewis on Wed, 2013-03-27 19:13

Here’s a little detail that appeared in 11gR2 that may help you answer questions about open cursors. Oracle has added a “cursor type” column to the view v$open_cursor, so you can now see which cursors have been held open because of the pl/sql cursor cache, which have been held by the session cursor cache, and various other reasons why Oracle may take a short-cut when you fire a piece of SQL at it.

The following is the output showing the state of a particular session just after it has started up in SQL*Plus and called a PL/SQL procedure to run a simple count:

Back to the Future AWR Mining Webinar Followup

Submitted by KarenMorton on Tue, 2013-03-26 20:05

Thanks to everyone who attended my webinar and thanks to Embarcadero (@DBPowerStudio) for hosting it. The presentation and scripts can be downloaded from the following links:

Presentation (PDF)
Scripts (ZIP)

Value of Improving One’s Knowledge

Submitted by Charles Hooper on Mon, 2013-03-25 02:48

March 24, 2013 As I type this blog article I am in the middle of reading a second book on the topic of Windows Server 2008 R2.  I bought the books several months ago, possibly even a year or two ago, and just had not found the time to invest in reading yet another dry […]

Value of Improving One’s Knowledge

Submitted by Charles Hooper on Mon, 2013-03-25 02:48

March 24, 2013 As I type this blog article I am in the middle of reading a second book on the topic of Windows Server 2008 R2.  I bought the books several months ago, possibly even a year or two ago, and just had not found the time to invest in reading yet another dry […]

Oracle Forms and Reports Services 11gR2 on Oracle Linux 6…

Submitted by oraclebase on Sat, 2013-03-23 14:45

Last year I wrote an article about the installation of Oracle Forms and Reports Services 11gR2 on Oracle Linux 5. I’ve now written the article for Oracle Forms and Reports Services 11gR2 on Oracle Linux 6. The latest patch of F&RS is certified for OL6, along with JDK6 and JDK7.

In addition to the installation articles, I’ve compiled a collection of random notes about post-installation configuration into a separate article. I keep adding to it every time I come across a new (for me) issue.

UltraEdit for Linux/Mac v4.0 Beta II

Submitted by oraclebase on Sat, 2013-03-23 09:29

Hot on the heels of the recent UltraEdit v19 release for Windows, comes the UltraEdit v4 Beta II release for Linux/Mac.

I’ve just started using it and so far so good. They usually progress through the betas pretty quick. I didn’t have time to install the beta I before this one dropped. :)

Cheers

Tim…

LOB Update

Submitted by Jonathan Lewis on Fri, 2013-03-22 23:36

This note is about a feature of LOBs that I first desribed in “Practial Oracle 8i” but have yet to see used in real life. It’s a description of how efficient Oracle can be, which I’ll start with a description of, and selection from, a table:

Where to begin with Oracle and SQL

Submitted by khailey on Fri, 2013-03-22 05:16

Seeing more and more questions on “where do I start with Oracle if I want to be a DBA?”  My perspective is a bit off since I’ve been surrounded by Oracle for over 20 years.  I hardly remember what it was like to start with Oracle and starting with Oracle now in 2013 is quite different than starting with Oracle in 1990.

Here is my list and everything on this list is excellent. I’m sure I missed a few good ones, but maybe people can add them in the comments.

Start with Oracle Docs, they are free and good!

Get the best books and read them

Listing Exadata storage cells and their configuration info from V$CELL_CONFIG

Submitted by tanelpoder on Thu, 2013-03-21 23:18

If you attended my Exadata hacking session today, you saw me using the cellver.sql script which lists some basic configuration info about the currently connected storage cells:

OIC(A) again

Submitted by Timur Akhmadeev on Thu, 2013-03-21 20:00

Issues with OICA/OIC (OPTIMIZER_INDEX_COST_ADJ/OPTIMIZER_INDEX_CACHING) parameters have already been mentioned many times. Recently I’ve noticed one more and I think I didn’t see this case somewhere else on the Internet so I’ll share it.


Here’s a simple table T1 holding 1M rows with the indexed column X having 10 distinct values: