Eliminate Idle Redundancy in Your Data Center

Oracle Active Data Guard, with Oracle Database 11g Enterprise Edition, enhances quality of service by offloading resource-intensive activities from a production database to one or more synchronized standby databases. Oracle Active Data Guard enables read-only access to a physical standby database for queries, sorting, reporting, Web-based access, and so on, while continuously applying changes received from the production database. Oracle Active Data Guard also enables the use of fast incremental backups when offloading backups to a standby database and can provide additional benefits of high availability and disaster protection against planned or unplanned outages at the production site.

BENEFITS
Increase performance—Offload unpredictable workloads to an up-to-date replica of the production database
Simplify operations—Eliminate management complexity that accompanies traditional replication solutions
Eliminate compromise—The reporting replica is up to date and online at all times, which is not possible with traditional storage mirroring technology
Reduce cost—An Oracle Active Data Guard physical standby database can also provide disaster recovery and/or serve as a test database—no additional storage or servers required

Posted in Database | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Viewing Who’s Using Transaction Undo / Rollback Segment

Here is a script to identify the active transaction are currently using rollback segments or undo segments. Conditions, log into the database as user SYS or SYSTEM or a user who has been in the grant DBA.

col o format a10 col u format a10 select osuser o, username u, sid, segment_name s, substr(sa.sql_text,1,200) txt from v$session s, v$transaction t, dba_rollback_segs r, v$sqlarea sa where s.taddr=t.addr and t.xidusn=r.segment_id(+) and s.sql_address=sa.address(+) And substr(sa.sql_text,1,200) is not null order by 3;

col name format a8 col username format a8 col osuser format a8 col start_time format a17 col status format a12 tti ‘Active transactions’ select username, osuser, t.start_time, r.name, t.used_ublk “ROLLB BLKS”, decode(t.space, ‘YES’, ‘SPACE TX’, decode(t.recursive, ‘YES’, ‘RECURSIVE TX’, decode(t.noundo, ‘YES’, ‘NO UNDO TX’, t.status) )) status from sys.v_$transaction t, sys.v_$rollname r, sys.v_$session s where t.xidusn = r.usn and t.ses_addr = s.saddrSubmit Article :- BlinkList + Blogmarks + Digg + Del.icio.us + Ekstreme Socializer + Feedmarker +Furl + Google Bookmarks + ma.gnolia + Netvouz + RawSugar + Reddit + Scuttle + Shadows +Simpy + Spurl + Technorati + Unalog + Wink

Posted in Script | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Know Your Grid Technology

Oracle 10g, g stands for grid. The following discussion of the Grid which I quoted from Wikipedia. Grid computing (grid computing) is the use of resources involves many separate computers that are geographically distributed and to solve problems in large-scale computing.


Background grid

The development speed of the processor developed in accordance with Moore’s Law, however bandwidth computer networks expand far more rapidly. The more quickly the lines of communication are opened up opportunities to combine the computing power of computing resources separate. This development enables large-scale distributed computing enhanced even further geographically, across the boundaries of existing administrative domains.

The rapid development of computer technology in advanced countries, making its researchers increasingly thirsty for computing power that can meet the challenges and problems they face. Although it already has a supercomputer with a very high capacity, what is out there felt this was still less, because they are trying to solve bigger problems. After all the computer that has a ” power -hungry computing researchers ” used an all-out to solve the problem, after a variety of ways to solve problems attempted, and selected the most efficient, but still the problem can not be solved as well, what should he do? Grid computing is one answer to this question.

definition of grid

According to the brief article [1 ] by Ian Foster no check -list that can be used to identify that a system of grid computing, namely:

The coordinate system of the computing resources that are not under a centralized control. If the resources used in the same administrative domain coverage, then it can not be said computing grid computing.
The system uses standards and protocols that are open ( not adrift in an implementation or a specific product ). Grid computing is composed of the agreements on fundamental issues, needed to bring together in a large-scale computing. Agreements and standards are needed in the areas of authentication, authorization, resource searches, and access to resources.
The system is trying to achieve a sophisticated quality of service, ( nontrivial quality of service ) which is well above the quality of service the individual components of the computing grid.

opportunities grid

In the book The Grid: Blue Print for a new computing infrastructure explained that what is meant by grid computing is the infrastructure hardware and software that can provide access to reliable, consistent, durable and inexpensive to sophisticated computing capabilities that are available.

” A computational grid is a hardware and software infrastructure That provides dependable, consistent, pervasive, and inexpensive access to high-end computational capabilities. ”

If someday in the future the technology needed to realize the vision of grid computing paradigm has been established, opportunities will be more open to cooperation across organizations, across continents and across the nation. Will open opportunities for researchers in Indonesia who want to do very complex computation, using the fastest supercomputer in the world, without having to make massive investments in information technology.

Products from Oracle Grid

Oracle has built a grid computing software infrastructure capable of dividing and balancing all of the load ( workload ) among different servers, and manage different servers as a single unit system.

The ability of grid computing is the equivalent of a mainframe because all components ( grids ) in – cluster. But unlike mainframes and servers SMP (symmetric multiprocessing ) are large, the grid is open ( open system technologies ) which could include small systems with Intel processors and Linux OS that costs so much cheaper.

The grid of Oracle’s products are:

Storage Grid: Automatic Storage Management ( ASM )
Grid Database: Real Application Server ( RAC )
Application Grid: Oracle Streams
Grid Control: Enterprise Manager Grid Control

Posted in Plugin | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Knowing the configuration database

Here’s how to find information about the configuration of the Oracle database that we maintain. This information is very important to know, especially for DBAs who di-install/create/configure by the database ( DBA ) another.

Information about the environment Operating System ( OS )
One of the most important information is the ORACLE_HOME, the directory where the Oracle installation is placed. See the OS environment here:

In Windows, look in the registry My Computer – > HKEY_LOCAL_MACHINE – > SOFTWARE – > ORACLE
In Unix, see the user profile from the database owner. For the shell sh / ksh / bash, user profile is in the file. Profile. To shell csh / tcsh, user profile is in the file. Login

Information Instance parameters ( init file )
Its location is in $ ORACLE_HOME / dbs for OS Unix

Parameters instance, if not in – specify the init file, then Oracle will give the default value. When the instance is up, we can see the parameters of the instance through the view v $ parameter. example:

SQL > SELECT NAME, VALUE, ISDEFAULT from v $ parameter order by name;

NAME column is the name of the parameter. VALUE column is the value of the parameter. ISDEFAULT column, means the value YES if the value is still the default value or not in – specify.

Feature (option ) is used by the database
When we create the database, not all the features of Oracle database ( which we have installed ) we need. To see features that are used by the database, query the view dba_registry

SQL > select COMP_NAME, VERSION, STATUS from dba_registry;

So, it should be understood very well the difference between the information on the VIEW v $ option and in dba_registry. Feature (option ) that are installed ( there is in v $ option) is not necessarily used by the database (there are at dba_registry ). Conversely, a feature that used the database (there are at dba_registry ) is definitely a feature that already exists in the Oracle database software installation ( on view v $ option).

Information about database properties
Examples of the database is the default tablespace properties (permanent and temporary ), timezone, character set, language, etc.. Such information can be viewed by querying the view database_properties.

SQL > select PROPERTY_NAME, PROPERTY_VALUE
from database_properties order by PROPERTY_NAME;

Posted in Database | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Work Related to Oracle Databases

Any job related to the Oracle database?

  1. To be sure DBA ( Database Administrator ): )
  2. Application developer.
  3. Often referred to as a programmer. Sometimes called SQL / PLSQL Developer.
  4. Application Architect. Sometimes referred to as System Analyst
  5. Data Architect. For large jobs, Application Architect to focus more logical design, while for the Physical Design done by the Data Architect. But most jobs Data Architect at -handle also by the Application Architect.

For consulting firms ( service providers ), the following job types:

Pre Sales Engineer
Assisting in selling Oracle’s sales, particularly in explaining technical product. Sales usually sell a lot of (anything) and the knowledge of his product is out of focus ( depth ), so sales in desperate need of pre – sales engineer.
implementer
After the product sold ( so prospective customers to buy product), the next step is implementation. This work includes: installation, configuration system, and handover to the customer (user ). Frequently encountered, the work is concurrently performed by the implementer of Pre Sales Engineer.
maintenance
Once the system is running, the consulting firm can offer a maintenance service. Maintenance is this which is the principal work of the DBA. Scope DBA:

Basic administration (basic adminitration )
& Backup recovery
tuning
Throubleshooting
Apply patch
upgrade version
Trainer
Most companies also sell consulting services training. Trainers can be dedicated ( in the sense that the employee works only) or no dedicated ( could use another employee, such as DBA, which was not busy in the project. It could also hire freelance )

In the formal education sector, several universities have incorporated the material of Oracle Database into the curriculum specialization in the field of study. This of course adds jobs for professions related to Oracle Database

Posted in Jobs | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment