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;

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE    Production
TNS for Linux: Version - Production
NLSRTL Version - 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