Accidental DBA Tip One of the most important tasks of an Accidental DBA is to assure that access to your database is set correctly. Developers naturally build applications using the least restrictions possible when connecting and manipulating a database so that they can rapidly develop applications. Often they use an account to connect to the database server having administrative privileges. […]
Other News
How to use Xquery in OSB
(Mikku) I had a really tough time working with Xquery and how to use the same in our OSB project.
Daily DBA Monitoring Tasks
(Gregory Larsen) In order to keep your SQL Server up and running smoothly you need to constantly be performing routine maintenance and monitoring work. If you do not keep a watchful eye over your SQL Server instances performance and stability might suffer. Or worse yet you might not be able to rec
SQL Server: 32 bit Memory Management
(SQLZealot) It is been long time due to certain critical issues and ofcourse the QUIZ in beyond relational,I could not get in touch with you all.
Smart Content Reviewed: Text Analytics & Semantic Content Enrichment
(Seth Grimes) Spurred on by an online debate about the distinction between text analytics and semantic content enrichment, I turn in this article to the pressing question: “What does semantic content enrichment mean?”
Semantic Technology Key To Mastering Data Growth, Analysis
(Chris Talbot) As big data stores continue to grow and require additional management, enterprises are faced with the task of managing their explosive data growth while also trying to find the best way to analyze that data.
The Agony of Big Transactions in the MySQL Binlog
(Robert Hodges) Databases fail in interesting ways. About a week ago I was called in on a support case for Tungsten Enterprise. We were getting failures in which the master MySQL 5.1.50 server would run out of connections, block applications for 5 to 10 minutes and eventually trigger automated fai
E-Business Suite and APEX integration using APIs (1)
(Dimitri Gielis) I didn’t expect to many technical issues using E-Business Suite (EBS) APIs in APEX as it’s basically a call to PL/SQL packages.
SQLFire locator equals Load Balancing + Failover
(Pas Apicella) In this demo we show how not only does a locator provide load balancing among the SQLFire members from client connections but also high availability should a member crash or perhaps be brought down. This is illustrated below when using a JDBC Connection pool.
session_cached_cursors again
(Alex Fatkulin) Not so long time ago I had to troubleshoot code performance regression issue between 9iR2 and 11gR2.