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”:
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).
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.
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.
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.
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 [...]
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 [...]![]()
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 [...]
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 [...]
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!
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.