Noel (@noelportugal) is a clever dude. He’s also passionate. If you’ve ever met him, you already know these things.
Although I haven’t yet jumped into Raspberry Pi, despite Noel’s unbridled passion about the little-computer-that-could, I have captured some metadata about it, just from being around him and his passion.
For example, I know the Raspi needs to be shutdown a certain way, or bad things happen. I recall Noel being very specific about (more...)
Some of the strangest ideas (to me, anyway) can be found in the depths of PL/SQL code, be it a package, a procedure, a function or an anonymous block. Granted, such decisions may be the result of budgetary considerations which prevented a more robust and reliable application design. I was looking at some code just recently that made me scratch my head in wonder and disbelief. Let’s look at a similar piece of PL/SQL that (more...)
This was my first Maker Faire, and wow was it an absolutely blast. I highly recommend taking in one of their events if there’s one in your town. Perhaps the best attribute of the Maker Faire is that it includes not just technology, but also handicrafts, woodcraft, pretty much every kind of craft. Walking around, you can feel (more...)
Google Now recently added a Parking Location card to help you solve the classic dude-where’s-my-car problem. According to The Verge:
The company’s Google Now assistant will now recognize when you’ve left a moving vehicle and automatically keep track of your car’s last location. There’s no magic happening here: Google does all of this using your smartphone’s bevy of sensors. It’s essentially guesswork, and the company readily admits that it may sometimes guess wrong. “You (more...)
I’ve been buying digital content from Amazon since they launched their MP3 Store, the first place to buy music without any DRM, back in 2007, and Amazon is the only place to get stuff like Dora and other Nickelodeon shows. Yeah, that’s a parenting problem.
Amazon doesn’t support the Chromecast and probably won’t anytime (more...)
A recent IT-related survey had in its list of questions one rather interesting offering:
“Are there any safeguards preventing the DBA from accidentally dropping a table?”
That is probably not a commonly considered aspect of data security however it is an issue that should be voiced and addressed. How do you ensure that the DBA doesn’t, or can’t, drop a table accidentally? Oracle has at least two ways to ensure that a table cannot (more...)
While investigating a question on returing unmatched rows between two tables I set up an example where both tables had indexes which could be used to speed up the query and hopefully return the result set in less time than required for a full table scan. To my surprise when the index was used on the table with the missing record the query returned no rows. Not understanding this behavior (as I KNEW there was (more...)
Indexes can be very useful tools to improve query performance, but it can be difficult to test indexes in an environment that exactly mirrors production. Although not the preferred method, Oracle offers in 11.2 and later releases the option of invisible indexes. What are invisible indexes? An invisible index can’t be ‘seen’ by any session by default, so it can be created and remain unavailable until testing is scheduled. This can be confusing since (more...)
Sometimes statements take longer than you’d like to complete. This can happen for a number of reasons including data changes, table growth, stale statistics and the occasional optimizer bug you haven’t encountered before. When it’s a SQL query that is misbehaving it’s pretty easy to find the cause and, in many cases, fix it. When it’s PL/SQL it isn’t as easy to do. There are views available from Oracle to assist in this endeavor and, (more...)
At March I will be presenting my very successful seminar “Mastering Backup and Recovery” in some countries of Latin America for the very first time. Thank you Panama, Chile and Brazil OUGs for inviting me to your amazing countries! Please, use the following links for registration and also to find more information about the seminar: […]
Hi All, On February 4, 2014 at 9:30 am PT I will be talking on the next OTN Virtual Developer Day about Oracle VM and Oracle Database. Come and discover the answers for the following questions: Does an Oracle Database perform well on a virtualized environment? What virtualization technology is more stable and […]
Some time ago, I received the request to migrate some Windows 2008 Servers to my Oracle VM farm and after complete the P2V migration the newly create VM would not start. It would crash on boot with blue screen and error: STOP: 0x0000007B (0xXXXXXXXX,0xXXXXXXXX,0×00000000,0×00000000) This issue is related to the storage drivers needed for the guest […]
Managing free space in a tablespace seems to be an easy task, what with the views DBA_DATA_FILES, DBA_TEMP_FILES and DBA_FREE_SPACE avaliable. Those views can provide accurate information for datafiles not set to autoextend, however for autoextensible datafiles they can paint a bleaker picture because they’re based on the current size of the file, not the autoextend limit that file could reach. Let’s look at how those views, without taking autoextend into consideration, can report a (more...)
I hit the following problem with a 220.127.116.11 database running on Windows 2003 this morning (info pulled from the alert log). The database had failed to restart after a client’s cold backup process ALTER DATABASE MOUNT Wed Jan 15 22:32:08 2014 ORA-09341: scumnt: unable to mount database OSD-04400: unable to acquire internal semaphore for process
I’ve been trying to install open source software. In this case an application called Moodle. I followed the instructions to install it on an Ubuntu Server vm but they were missing a couple of key points.
After installing the Moodle package (under “Moodle Installation” in the instructions) you need to (more...)
Top 5 Key Reasons Why Oracle VM is Best for Oracle Database When: Tuesday December 17th , 10am PST Register Here: http://event.on24.com/r.htm?e=725350&s=1&k=1512E332202610FE9518AB8B01354C6A&partnerref=Francisco Oracle VM application-driven architecture is designed for rapid deployment and ease of lifecycle management providing IT a highly scalable and cost effective virtualization solution for Oracle (more...)