Tags » Dba

RECAP- Interpol, spilled beer, Social D

This last week for myself has been crammed with back to back shows and breakfast at 2 in the morning.

So pretty much I have had an amazing week. 606 more words


U.S. Meat Prices Pull Back in September

The U.S. Department of Agriculture (USDA) released its preliminary report on September farm prices Monday afternoon. The all-products price index fell 2.8% month-over-month to 106, with the crop index down 3.3% and the livestock index unchanged. 264 more words

Commodities & Metals

Detecting and terminating persistent locks and blocks on database

Here is the query to detect the persistent locks which are more than 20 minutes on the database along with the session details

SET LIN 120… 601 more words


Cara upgrade Oracle Database 10g menjadi

Secara garis besar dari dokumen readme.htm

  1. Matikan lsnrctl, matikan enterprise manager console, matikan database
  2. Installasi dari patch yg didownload (setup.exe), kemudian oracle homenya pilih ke lokasi oracle yg mau di patch…
  3. 88 more words

Getting execution plan details for the SQL

If you have been notified by the application support team that particular module is currently slow as compared to earlier. You are requested to provide the complete SQL information from the database side. 382 more words


The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 11–22)

Follow @Oratweets

On the Toad World site, I’m writing a series of blog posts and Wiki articles on the subject of EXPLAIN PLAN. I’m using EXPLAIN PLAN as a motif to teach not just SQL tuning but also relational theory, logical database design, and physical database design. 1,370 more words


Exclusive Opportunity to Influence IBM Product Usability: Looking for Participants for Usability Test Sessions - Data Warehousing and Analytics

By Arno C. Huang, CPE
Designer, IBM Information Management Design
The IBM Design Team is seeking people with a variety of database, data warehousing and analytics backgrounds to participate in usability test sessions. 122 more words