DBA Consulting is momenteel een eenmans consultantcy bedrijf met meer dan 10 jaar ervaring met Oracle Database Implementaties en Migraties, van versie 6 tot en met 11^g, en kan u helpen met uw Implementatie en Migratie op elk Platform dat u heeft en ondersteund wordt door Oracle. Ook bekend met RAC (Real Application Clustering) en Grid technology voor Oracle 11^g. Enterprise Manager Grid Control voor beheer van grote hoeveelheden databases. RMAN backup en recovery setup. Flashback technieken en PL/SQL en SQL programmering en tuning. Ook kunt u geholpen worden met het opzetten van DataGuard en Stanby Database technieken.

Gebruik een Tuning Expert

DBA Consulting biedt de volgende Oracle Performance tuning diensten aan:

Expertiese in Oracle Performance tuning voor Databases. Oracle Certified Consultants die Oracle Performance tuning op de onderstaande terreinen doen:

Oracle RAC performance tuning
Oracle SQL Tuning
Oracle Health Checks
Oracle server tuning

Database 11g

DBA Consulting offers a wide range of Oracle options to extend the power of Oracle Database 11g Enterprise Edition to meet specific requirements in the areas of performance and availability, security and compliance, data warehousing, and manageability. This range of options, combined with Oracle Database's extensive out-of-the-box capabilities, make Oracle's the world's #1 database.

OPTIONS

Proactive Health Checks

It helps you sleep better at night knowing that the database is healthy and has no bad blocks. But how can you ensure that? Bad blocks show themselves only when they are accessed so you want to identify them early and hopefully repair them using simple commands before the users get an error.

What happes at health checks

■ DB Structure Integrity Check—This check verifies the integrity of database files and reports failures if these files are inaccessible, corrupt or inconsistent. If thedatabase is in mount or open mode, this check examines the log files and data fileslisted in the control file. If the database is in NOMOUNT mode, only the control file ischecked.

■ Data Block Integrity Check—This check detects disk image block corruptions such as checksum failures, head/tail mismatch, and logical inconsistencies within the block. Most corruptions can be repaired using Block Media Recovery. Corrupted block information is also captured in the V$DATABASE_BLOCK_CORRUPTION view. This check does not detect inter-block or inter-segment corruption.

■ Redo Integrity Check—This check scans the contents of the redo log for accessibility and corruption, as well as the archive logs, if available. The Redo Integrity Check reports failures such as archive log or redo corruption.

■ Undo Segment Integrity Check—This check finds logical undo corruptions. After locating an undo corruption, this check uses PMON and SMON to try to recover the corrupted transaction. If this recovery fails, then Health Monitor stores information about the corruption in V$CORRUPT_XID_LIST. Most undo corruptions can be resolved by forcing a commit.

■ Transaction Integrity Check—This check is identical to the Undo Segment Integrity Check except that it checks only one specific transaction.

■ Dictionary Integrity Check—This check examines the integrity of core dictionary objects, such as tab$ and col$. It performs the following operations:

– Verifies the contents of dictionary entries for each dictionary object.

– Performs a cross-row level check, which verifies that logical constraints on rows in the dictionary are enforced.

– Performs an object relationship check, which verifies that parent-child relationships between dictionary objects are enforced.

The Dictionary Integrity Check operates on the following dictionary objects:

tab$, clu$, fet$, uet$, seg$, undo$, ts$, file$, obj$, ind$, icol$, col$, user$, con$, cdef$, ccol$, bootstrap$, objauth$, ugroup$, tsq$, syn$, view$, typed_view$, superobj$, seq$, lob$, coltype$, subcoltype$, ntab$, refcon$, opqtype$, dependency$, access$, viewcon$, icoldep$, dual$, sysauth$, objpriv$, defrole$, and ecol$.

Example of a output Report:

RUN_ID NAME CHECK_NAME RUN_MODE SRC_INCIDENT

---------- ------------ ---------------------------------- -------- --------

1 HM_RUN_1 DB Structure Integrity Check REACTIVE 0

101 HM_RUN_101 Transaction Integrity Check REACTIVE 6073

121 TXNCHK Transaction Integrity Check MANUAL 0

181 HMR_tab$ Dictionary Integrity Check MANUAL 0

981 Proct_ts$ Dictionary Integrity Check MANUAL 0

1041 HM_RUN_1041 DB Structure Integrity Check REACTIVE 0

1061 HM_RUN_1061 Data Block Integrity Check REACTIVE 7418

TYPE DESCRIPTION

------------- -----------------------------------------

FAILURE Block 64349 in datafile 1: '/u01/app/orac

le/dbs/t_db1.f' is media corrupt

FAILURE Block 64351 in datafile 1: '/u01/app/orac

le/dbs/t_db1.f' is media corrupt

The tool dbverify can do the job but it might be a little inconvenient to use because it requires writing a script file contaning all datafiles and a lot of parameters. The output also needs scanning and interpretation. In Oracle Database 11g, a new command in RMAN, VALIDATE DATABASE, makes this operation trivial by checking database blocks for physical corruption. If corruption is detected, it logs into the Automatic Diagnostic Repository.

DBA Consulting can do the job for you.

Oracle SOA Suite 11g

Best-of-Breed Oracle Technology for Building Next-generation Business Applications
Oracle's complete SOA offering, Oracle SOA Suite 11g, is an integrated, best-of-breed suite of products that helps you rapidly design and assemble, deploy and manage, highly agile and adaptable business applications. This 100 percent standards-based, hot-pluggable infrastructure interoperates with your existing IT investments lowering your upfront costs. Many Oracle customers have succeeded in deploying high-volume, mission-critical SOA systems by leveraging the industry's best service bus, Oracle Service Bus, combined with Oracle's renowned extreme-scalability on a grid computing infrastructure.

Oracle SOA Suite is the foundation technology for Oracle Application Integration Architecture: Oracle's solution for delivering rapid application integrations.

BENEFITS

Integrated SCA-based designer—Improves developer productivity through easy-to-use, drag-and-drop features for rapidly assembling metadata-driven business applications
Unified events and services - Enables highly flexible and responsive applications through event-driven SOA
End-to-end instance tracking—The only complete SOA platform that provides end-to-end IT and business visibility into enterprise-wide implementations

Components of Oracle Fussion Middleware:

Oracle Fusion Middlware and its central role in the Application Building process:

Oracle Business Process Management

Business processes are at the heart of what makes or breaks a business, and what differentiates it from the competition. Business processes that deliver operational efficiency, business visibility, and agility give the enterprise the edge by enabling it to conduct business in a low cost, dynamic way, and to see change as an opportunity.

Why Oracle’s BPM Suite

DBA Consulting as Oracle Gold partner helps your enterprise achieve higher efficiency, visibility, and agility by delivering industry-leading products for business process management (BPM) and business process automation (BPA). The products in these pre-integrated portfolios span modeling tools for business analysts, developer tools for system integration, business activity monitoring for dashboards, and user interaction for process participants. Oracle BPM Suite and Oracle BPA Suite are the industry's most complete and unified family of BPM products. They deliver immediate and impact full ROI, driving customer service and operational excellence, and providing business value to SOA.

INDUSTRY-LEADING BPM

Oracle and its products are positioned in Leaders Quadrant in latest Gartner Magic Quadrant for Business Process Management Suites
Unified, complete, and social suite of BPM products
Versatile tools for line-of-business users and developers
Unified environment for modeling and execution
Support for industry-standards BPEL and BPMN

DBA Consulting can help you with implementation.

Voor alle Database Administration issues van de Implementatie en Migratie cyclus kunt u kontakt met ons opnemen voor assistentie. Ook voor Tuning issues met uw nieuwe en bestaande Oracle Implementaties kunt u kontakt met ons opnemen. Met een tevreden klanten kring met klanten zoals SAAB, Viag Interkom, BT Ignite, Mannesmann Iplusys, Bayer en Pfizer kunt u aannemen dat Expertise en Kwaliteit hoog in ons vaandel staan.

Gebruik een Tuning Expert

INDUSTRY-LEADING BPM

Contact Information