Search

Top 60 Oracle Blogs

Recent comments

March 2014

12c Temporary

Just one of those little snippets to cover something new and remind of something old. A single session can now have three (or more) temporary tablespaces in use at the same time for different reasons.

12c Temporary

Just one of those little snippets to cover something new and remind of something old. A single session can now have three (or more) temporary tablespaces in use at the same time for different reasons.

More and more jira resource endpoints

I have added a lot more jira rest endpoints to the jira_utl package. The progress has been a little slow for the last week, since I have been elected president of the local danish user group, so I'm trying to get up to speed on that as well. The next week should be back to normal "speed"

Interesting GNS anomaly in 12.1.0.1.2 RAC

I was encountering an interesting anomaly with my 12.1.0.1.2 RAC cluster based on Grid Naming System. I have written about the setup here.

Interesting GNS anomaly in 12.1.0.1.2 RAC

I was encountering an interesting anomaly with my 12.1.0.1.2 RAC cluster based on Grid Naming System. I have written about the setup here.

views in 12c

Observed an interesting idiosyncracy in the creation of views in 12c (this is in a pluggable database, but not confirmed whether this is related or not).  This database was upgraded from 11.2 without incident…until we came to replace one of the existing views.

SQL> create or replace
2 view EXISTING_VIEW_NAME
3 as select * from other_schema.account;
ERROR at line 3:
ORA-01720: grant option does not exist for 'OTHER_SCHEMA.ACCOUNT'
*

Now that struck us as odd, because this was a script from our source code control repository, which had no previous entries about grants for the OTHER_SCHEMA.ACCOUNT table.  So then I tried this:

SQL> create or replace
2 view NEW_VIEW_NAME
3 as select * from other_schema.account;

View created.

so there doesn’t appear to be the need for the grant option.  Similarly, dropping the original view also solves the problem.

Impressions from #oug_ire 2014

The Oracle User Group Ireland had its annual conference for 2014 at the Convention Centre in Dublin – which is a very nice location:

Convention Centre in DublinThere have been many well known Oracle Experts speaking, as you can see from the agenda. Oracle University was represented by Joel Goodman and myself – we really enjoyed talking there and listening to the other speakers :-)

Shrink Space

Here’s a lovely effect looking at v$lock (on 11.2.0.4)

OUG Ireland 2014

As you probably know by now I was at OUG Ireland yesterday.

It was a pretty early start for me. I needed to be up by 03:30 to get a taxi to the airport, but fear of missing my flight meant I was awake from about 01:00 onward. My taxi driver wanted to talk about some rather strange stuff during the ride. A conflicted individual I guess…

The Ryanair flight across to Dublin went smoothly enough. There were 18 people on a 737, so I’m guessing that flight didn’t cover the staff costs, since I paid £30 for a return flight. Once at Dublin I took the AirLink bus for 10 euros, which dropped me outside The Convention Centre Dublin.

What is the difference between logical and physical corruption in Oracle?

When we talk about logical corruption, there are two different failure states that fall under this label: