As you certainly already have heard Oracle 11g came with a new feature called “Instance caging”. This feature allows Oracle DBA to easily manage Oracle Instance CPU-consumption. How does it work? Quite easily … see below
Read More
Category Archives: Application integration & Middleware
Index compression comes from Oracle 8i and has quite the same mechanism as table compression. Index compression eliminates duplicate column values in the leaf blocks. Let’s see how it works:
MySQL Workbench provides several necessary tools in order to manage a MySQL environment. MySQL Workbench 5.2 is available for Windows, Mac and Linux platforms, it encapsulates three main functionalities:
1. SQL Development: Allows connecting to existing databases and run SQL Queries, SQL scripts, edit data and manage database objects. This functionality replaces the ones previously provided by the Query Browser stand-alone application.
2. Data Modeling: Helps to create and manage models, allows forward & reverse engineering and provides capability to compare and synchronize schemas
3. Server Administration: Helps to configure a database server, to setup user accounts and browse status variables and server logs
Let’s have a look deeper in each of those features:
Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the correct number. In this posting, I will show you how.