Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Index Sizing

I was in a discussion recently about how to estimate the size of a bitmap index before you build it, and why it’s much harder to do this for bitmap indexes than it is for B-tree indexes. Here’s what I wrote in “Practical Oracle 8i”:

Calling Java procedure from database

Oracle Database has had the possibility to run Java code inside the database for a long time. It's a very rare occasion when you need to use it but still. Here is one example I used to download content from HTTPS website that required user certificates for authentication. Please take the code below more as an example how to put simple Java code inside the database, not as a solution for user certificates authentication, because UTL_HTTP can do the same thing (although I wasn't successful in implementing it under 11.2.0.2).

Extracting private key from Oracle Wallet

Oracle Wallet Manager and orapki do not let you extract the private key associated with user certificate located in Oracle Wallet. If you need it for some reason, for example testing with external tools like wget, then its possible to extract the private key using openssl, since Orale Wallet (ewallet.p12 file) is just PKCS#12 file.

SLOB Is Not An Unrealistic Platform Performance Measurement Tool – Part I. Let’s See If That Matters…To Anyone.

I just checked to find out that there has been 3,000 downloads of SLOB – The Silly Little Benchmark. People seem to be putting it to good use. That’s good.

Before I get very far in this post I’d like to take us back in time–back before the smashing popularity of the Orion I/O testing tool.

OEM12c Discovery of Exadata Cluster

dbm_configurator.xls is needed to generate databasemachine.xml file which is needed by OEM 12c to discover an exadata cluster.

Following is a step  by step process as how to generate databasemachine.xml file to be used with OEM 12c:

1) Get the dbm_configurator70.xls file from /opt/oracle.SupportTools/onecommand directory from the first compute node of Exadata cluster.

2) Also get config.dat and dbmachine.params file from /opt/oracle.SupportTools/onecommand directory.

Easy text/html multipart emails with Email::Simple::Markdown

These days, to craft basic emails, I go with Email::Simple. For the more heavy stuff with attachements and what-nots, I reach out for Email::MIME. Together, they make a pretty awesome duo. But… (come on, admit it, you knew there was going to be a ‘but’) But there is a fairly common use-case that falls pretty [...]

Third International NoCOUG SQL & NoSQL Challenge

The Third International NoCOUG SQL & NoSQL Challenge sponsored by Pythian—Love Your Data™ will be revealed on Monday, May 21 at 9 AM PST at http://bit.ly/JvJS46. In this challenge, the Wicked Witch of the West needs help in creating a magic spell to ensure that the Third Annual Witching & Wizarding Ball is a grand [...]

Pythian and NoCOUG Announce: The Third International SQL Challenge

For the third consecutive year, NoCOUG is hosting an international SQL challenge. Last year we ran into a small difficulty where the international DBA community proved too clever and solved the challenge before we could properly publicize it. A good DBA learns from her mistakes, and this year we are pre-announcing the challenge: The challenge [...]

Oracle VM Manager: OVMAPI_6000E Internal Error: Connection refused

This is just a quick post to share my first 3.1.1 Oracle VM Manager (OVMM) troubleshooting experience. After the initial installation I rebooted the server, tried to access OVMM https://ovmmhost:7002/ovm/console and received the following error in a browser screen: Unexpected error during login (com.oracle.ovm.mgr.api.exception.FailedOperationException: OVMAPI_6000E Internal Error: Connection refused Connection refused[[ < date > ), please consult logs [...]

Have you registered for Kscope12?

Join the Oracle Database Insider team at this year's ODTUG Kscope12 conference in San Antonio, Texas. June 24-28. Use discount code DBI (Database Insider) for $100 off!

view counter
ITNewsCast is the only resource that is entirely dedicated to delivering ahead of the curve, exhaustive coverage about the Oracle Corporation and Oracle technologies. ITNewsCast is the authoritative resource where Oracle professionals look to for Oracle Support, Oracle News, Oracle Editorials, Oracle Reviews, Oracle Tips and Tricks and Oracle Announcements.

With a first appearance in 2009, ITNewsCast already has over 40,000 visitors a month. ITNewsCast lets you reach the people you want to reach most, the decision makers and the technicians that consume Oracle technologies.