Recently, i got an opportunity to look into CBC latch contention on 18.104.22.168 database version at one of the client’s site.As the number of users connecting to the database increased its performance degraded with poor application performance. The first thing was to check the statspack report.Lets see what the “Top 5 Wait Events” had to
In order to resolve this issue use the following steps: Ad hoc access to OLE DB provider ‘Microsoft.ACE.OLEDB.12.0′ has been denied. You must access this provider through a linked server. Run the Following T-SQL USE [master] GO EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’AllowInProcess’ , 1 GO EXEC master . dbo.
After I wrote about Oracle Database 11gR2 (22.214.171.124) is available on Linux x86-64, x86. It's time to test for upgrading. On my test system, I install Oracle Grid Infrastructure for Standalone Server (ASM) and Database 126.96.36.199, then test to upgrade 188.8.131.52 => 184.108.40.206:
SQL> select * from v$version;
220.127.116.11 Software is now available for download. It contains 4G+ binaries as you now perform out of place upgrade i.e software is installed in separate home from current home. You can also use it to install 18.104.22.168 directly instead of upgrading from 22.214.171.124. Use wget to download it directly to server (thus avoiding copying to [...]
The draft programme is out for the AUSOUG National Conference 2010. If you’ll be in Perth in November I recommend you register and attend – a number of excellent papers will be presented, some of which I had the privilege of hearing when I was in Melbourne – you’ll learn new things, relearn old things [...]
After introducing Kerberos, and getting SSO to the database working, it's time for some excitement: combine Single Sign On (SSO) with Enterprise User Security (EUS).Sure, I blogged about Enterprise Security a long time ago (See the "Enterprise Security" entries of 2005), but there I used certificates; in fact another identity.In this entry, some of the 2005 stuff returns, but parts will
When we created spfile in ASM instance and found ORA-29786.
SQL> create spfile='+DATA' from memory;
create spfile='+DATA' from pfile
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts
If we check oracle support 976075.1:
Recently I had a request to top align all the data within an Apex 3.2 interactive report.
There were some data in the report that made other information appear out of place. Consider the sample data below on demo_customers table. The address field is subtly pushing the other fields down. Combine this with an Edit record image and it starts to look silly.
I’m giving a NoSQL overview presentation at MOTS in two days. The presentation is somewhat misleadingly titled “Deep Dive” – it is deep enough in the sense that I go into specific requirements, algorithms and use-cases. It is not nearly deep enough for my tastes, so I’ll have to come up with a follow up.
Because I am a lazy guy who wants to do everything fast I really like to have aliases in user profiles. When I login on a box different version of Oracle Homes and multiple ORacle databases on the same machine I feel naked without aliases. I am a guy who wants to tail alert log/any [...]