Gruñidos sobre …

6 octubre 2014

Why you should use Application Services with your Oracle Database

Filed under: Uncategorized — fidelinho @ 8:25 pm

Esto tengo que guardarlo.
Sabía como hacerlo en RAC, pero me interesa bastante en sistemas con una instancia.

Uwe Hesse

On a Single-Instance Oracle Database, Application Services offer benefits for Performance Monitoring & Tracing. That’s the focus of this posting. If you are on RAC respectively Data Guard already, you will use Services at least to provide Connect-Time Failover. You may find some additional useful things to do with them here. The playing field:

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0    Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

My demo DB has no Application Services yet. In the most simple case, there is one Application running and we take backups, so that gives us two services to introduce:

SQL> exec dbms_service.create_service('app1','app1')

PL/SQL procedure successfully completed.

SQL> exec dbms_service.create_service('bk','bk')

PL/SQL procedure successfully completed.

With Grid Infrastructure installed, we would use srvctl add service instead. The services are…

Ver la entrada original 1.179 palabras más

Crea un blog o un sitio web gratuitos con WordPress.com.

A %d blogueros les gusta esto: