I discovered ASM with a 10.1.0.3 RAC running on Linux Itanium and that was a big adventure. At this time there was no asmcmd. In 2005, Oracle released Oracle 10gR2 and asmcmd came into the place and we figured out how to make it work with a 10gR1 ASM. We were very excited to have a command line for ASM until… we tried it ! let’s call a spade a spade, it was very (more...)
Running a SQL trace is something that all DBAs do to varying degrees. Let’s say you are working on optimizing a SQL statement, and experimenting with some different hints for indexes and optimizer directives. This kind of effort typically goes something like this:
We are always on the hunt for interesting new uses of the Apple Watch, so when my colleague Ben Bendig alerted me to AstroPad’s new iPhone/Apple Watch app, I downloaded it immediately.
The app, AstroPad Mini, is intended to let you use your iPhone as a graphics tablet and controls Photoshop nicely right out of the box. But it will work with any Mac app; it lets you map any area of your (more...)
The Intel Compute Stick provides a full desktop experience in an ultra-portable HDMI dongle form factor. It’s like Google Chromecast, but an entire PC instead of just a web browser. I tested both the $150 Windows 8 version and the new $110 Ubuntu version.
TAP TAP TAP. IS THIS THING ON?
The HDMI end goes into a display, the power goes into an outlet, (more...)
Followers of the blog will know I’ve been waiting to get access to the Oracle Cloud for a while. Well, I’ve finally got access to a bit of it. Specifically, the “Oracle Database Cloud Service” (DBaaS) part.
The Schema Service has been around for a few years and I had already tried that out, but IMHO it’s not really part of Oracle Cloud database vision*, so I was reserving my judgement until I got the real (more...)
Following test commands are impromptu sesssion in which a user is being created, then a schema is created, and that user is authorized on that schema. Then a table is created with a default superprojection and then a projection (more...)
Step 1 - Create a T.DEV account
In order to get started you need to create an account on http://dev.telstra.com in order to be granted access to the SMS API. Once access is granted you need (more...)
I’ll be presenting at a “Lets Talk Oracle” event in Perth, with fellow Ex-Oracle ACE Directors Richard Foote and Chris Muir. Full agenda as follows:
8:30-9:00 Registration and coffee 9:00-10:30 Richard Part I – Database 12c New Features for DBAs (and Developers) 10:30-11:00 Break 11:00-12:30 Richard Part II – Database 12c New Features for DBAs (and Developers) 12:30-1:30 Lunch 1:30-2:30 Chris – Creating RESTful APIs with Oracle Data Services (for Developers and DBAs) 2:30-2:45 Break (more...)
The data presented by Digital Evolution Index seems supported by data from the European Commission. The EU defined a Digital Economy and Society Index to support and measure progress on the digital agenda for Europe:
The Digital Economy and Society Index (DESI) is a composite index that summarises relevant indicators on Europe’s digital performance and tracks the evolution of EU member states in digital competitiveness.
The Digital (more...)
I’ve said a number of times, the process of writing articles is part of an ongoing learning experience for me. A few days ago my personal tech editor (Jonathan Lewis) asked about a statement I made in the SQL Plan Directive article. On further investigation it turned out the sentence was a complete work of fiction on my part, based on my misunderstanding of something I read in the manual, as well as the assumption that (more...)
If not, here’s a recap of some of the tinkering going on in OAUX Emerging Technologies land.
it’s been a couple of months since my session at the oug_scot and I feel it’s enough time to write about it…
First of all – it was awesome!
I have never been to a user conference other than the ilOUG in Israel. I went to the Oracle Open World couple of years ago (and I’m not going this year ) but it was nothing alike…
The user group was at a lovely place near (more...)
Last week I attended the Oracle Mobile Cloud Service (MCS) track as part of the Oracle Summer Camps in Lisbon. Besides the great location and networking opportunities, it’s was a great learning experience. It turned out it not only was the first MCS training for me, it even was the first MCS training ever given! I feel a lucky bastard to be one of the first people worldwide, besides Oracle employees, to work with the (more...)
Red Samurai ADF Performance Audit Tool v 4.0 – Web Client Request Monitoring and Complete Query Analysis
It is already 3 years, since initial version - Red Samurai Performance Audit Tool - Runtime Diagnosis for ADF Applications. We are using it for many of our (more...)
so after much too-ing and fro-ing with Oracle Support, we finally have a solution to my datapatch problem. Prevent the timeout from happening when running datapatch! We know which part of the code was timing out, and we can do this by setting an undocumented event: 18219841.
Here’s a show test to show you how that was done:
SQL: select dbms_sqlpatch.verify_queryable_inventory from dual; VERIFY_QUERYABLE_INVENTORY -------------------------- ORA-20008: timed out. Job Load_opatch_inventory_1execution time is more than (more...)
Step 1: connect as a database os user
su – oradev
startDB.sh edit and saved
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addlnctl.sh start EBSDEV
stopDB.sh edit and saved
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addlnctl.sh stop EBSDEV
give execute permission chmod 750 for both file
Step 2: connect as applmgr os user
startAPP.sh edit and saved
Earlier this year The Fletcher School published the Digital Evolution Index. The Digital Evolution Index analyses the key underlying drivers and barriers that govern a country’s evolution into a digital economy:
- Demand – including consumer behaviours and trends, financial and Internet and social media savviness.
- Supply – including access, fulfilment, and transactions infrastructure.
- Institutional Environment – including government effectiveness and its role in business, laws and regulations (more...)