March 10, 2010 In one of last week’s blog articles I asked why a SQL statement that had appeared in a…
Category Uncategorized
There are scenarios where you cannot login to SQL*PLUS even with SYSDBA credentials to restart a hanged database. There is…
Oracle Transparent Data Encryption using Oracle Wallet If you wish to use a wallet specifically for TDE, then you must…
Procedure to mount an NFS share on Exadata # service portmap start Starting portmap: [ OK ] service nfs start…
— Get DDL from impdp — The below command will not import the dump, but will just create a .sql…
Remove Comma Character from Column — Use the below sql query, which will remove , from the string UPDATE data_dict…
Today on one of our 10g (10.2.0.1, don’t ask !) production databases running on AIX 5.3 we saw the following…
If you see the below alert from the Cell Nodes, then the MS process is leaking memory RS-7445 [Serv MS…
There are times when we have more than 1 database on a single servers. So setting OS profile for oracle…
I thought of publishing this post to serve as a note of understanding on Smart Flash Cache in an Exadata…
Uwe’s Brillaint article on the very powerful DCLI utility for Exadata An Exadata Database Machine X2-2 Full Rack comes with…
What to do when a production database goes hanging and there is no time left and your boss is standing…
Many people after some years with Oracle software may come up with Direct SGA Access project and presentation of Kyle…
Oracle has just announced a suite of new Engineered systems. Of particular significance is the announcement of the Generation 6…
“Life is a transaction with no option to issue a rollback.”
Excellent blog on emulating Enterprise Edition features on a StandardEdition Oracle database. Link below: https://annsjokvist.wordpress.com/?utm_content=bufferb7d4f&utm_medium=social&utm_source=facebook.com&utm_campaign=buffer
With this posting, we look at the New Feature Hybrid Columnar Compression that is only available with the Exadata Database…
These I consider the most important points about Exadata Patching: Where is the most recent information? MOS Note 888828.1 is…
Recently while working on one of the test exadata machine came across one of the very useful tool to monitoring…
I’m surprised to find that Google is not cleanly ranking the helpful set of blog posts by Oracle’s Maria Colgan…
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor TNS-12541: TNS:no listener TNS-00511: No listener ERROR: ORA-12560:…
http://www.forbes.com/sites/samanthasharf/2014/09/18/larry-ellison-steps-down-from-ceo-position-at-oracle/
The guy who created Exadata for Oracle has teamed up with a VMWARE guru to create a disruptive technology for…