Menu de navegação

[mpunganParticipante]

Olá, preciso descobrir o que esta instalado num banco oracle standard, quais são as features que estão disponíveis. Pois, acho que o Diagnostic Pack não esta instalado.

Att.

Mpungan

[Ricardo Portilho ProniParticipante]

SQL> set pages 1000
SQL> set lines 210
SQL> select * from v$option;

PARAMETER VALUE

---

Partitioning TRUE
Objects TRUE
Real Application Clusters FALSE
Advanced replication TRUE
Bit-mapped indexes TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel backup and recovery TRUE
Parallel execution TRUE
Parallel load TRUE
Point-in-time tablespace recovery TRUE
Fine-grained access control TRUE
Proxy authentication/authorization TRUE
Change Data Capture TRUE
Plan Stability TRUE
Online Index Build TRUE
Coalesce Index TRUE
Managed Standby TRUE
Materialized view rewrite TRUE
Materialized view warehouse refresh TRUE
Database resource manager TRUE
Spatial TRUE
Visual Information Retrieval TRUE
Export transportable tablespaces TRUE
Transparent Application Failover TRUE
Fast-Start Fault Recovery TRUE
Sample Scan TRUE
Duplexed backups TRUE
Java TRUE
OLAP Window Functions TRUE
Block Media Recovery TRUE
Fine-grained Auditing TRUE
Application Role TRUE
Enterprise User Security TRUE
Oracle Data Guard TRUE
Oracle Label Security FALSE
OLAP TRUE
Table compression TRUE
Join index TRUE
Trial Recovery TRUE
Data Mining TRUE
Online Redefinition TRUE
Streams Capture TRUE
File Mapping TRUE
Block Change Tracking TRUE
Flashback Table TRUE
Flashback Database TRUE
Data Mining Scoring Engine FALSE
Transparent Data Encryption TRUE
Backup Encryption TRUE
Unused Block Compression TRUE
Oracle Database Vault FALSE
Real Application Testing TRUE

56 rows selected.

SQL>

[mpunganParticipante]

No meu banco esta assim, como faço para ativar o Oracle Diagnostic Pack? Qual das features abaixo habilita essa funcionalidade?

Active Data Guard FALSE
Advanced Compression FALSE
Advanced replication FALSE
Application Role FALSE
Automatic Storage Management FALSE
Backup Encryption FALSE
Basic Compression FALSE
Bit-mapped indexes FALSE
Block Change Tracking FALSE
Block Media Recovery FALSE
Change Data Capture FALSE
Coalesce Index TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Data Mining FALSE
Database queuing TRUE
Database resource manager FALSE
Deferred Segment Creation FALSE
DICOM TRUE
Duplexed backups FALSE
Enterprise User Security FALSE
Export transportable tablespaces FALSE
Fast-Start Fault Recovery FALSE
File Mapping FALSE
Fine-grained access control FALSE
Fine-grained Auditing FALSE
Flashback Data Archive FALSE
Flashback Database FALSE
Flashback Table FALSE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Java TRUE
Join index FALSE
Managed Standby FALSE
Materialized view rewrite FALSE
Objects TRUE
OLAP FALSE
OLAP Window Functions TRUE
Online Index Build FALSE
Online Redefinition FALSE
Oracle Data Guard FALSE
Oracle Database Vault FALSE
Oracle Label Security FALSE
Parallel backup and recovery FALSE
Parallel execution FALSE
Parallel load TRUE
Partitioning FALSE
Plan Stability TRUE
Point-in-time tablespace recovery FALSE
Proxy authentication/authorization TRUE
Real Application Clusters FALSE
Real Application Testing FALSE
Result Cache FALSE
Sample Scan TRUE
SecureFiles Encryption FALSE
Server Flash Cache FALSE
Spatial FALSE
SQL Plan Management FALSE
Streams Capture FALSE
Transparent Application Failover TRUE
Transparent Data Encryption FALSE
Trial Recovery FALSE
Unused Block Compression FALSE
XStream TRUE

Att

MPungan

[rmanParticipante]

@mpungan

Qual versão do Oracle?

[Ricardo Portilho ProniParticipante]

11g:

SQL> show parameters CONTROL_MANAGEMENT_PACK_ACCESS

NAME TYPE VALUE

control_management_pack_access string NONE

SQL> alter system set control_management_pack_access=’DIAGNOSTIC+TUNING’;
System altered.

[mpunganParticipante]

A versão desse banco oracle é standard. Oracle Stantard 11g.

[mpunganParticipante]

Ricardo, com a execução do comando abaixo, e vou conseguir através do Grid Control verificar os diagnósticos desse banco?

Att.

Mpungan

[rmanParticipante]

@mpungan

O diagnostic pack e o tunning pack habilitam a aba desempenho do enterprise manager.

Vale lembrar que esses packs são option do da versão enterprise do oracle, até hoje não consegui entender, mas esses options não podem ser licenciados na versão standard do oracle, ou seja, mesmo você querendo comprar as licenças a oracle não vai vender, mais estranho ainda é que é possível habilitar. 😯

[Autor]

Posts