Banco de dados oracle

Disponível somente no TrabalhosFeitos
  • Páginas : 10 (2333 palavras )
  • Download(s) : 0
  • Publicado : 4 de abril de 2013
Ler documento completo
Amostra do texto
Alterar tamanho de SGA
Para alterar o tamanho do banco primeiro clique em administração, depois em memória e gerenciar SGA.

Depois defina o tamanho do SGA

Parâmetros de configuração do Banco de Dados



Tabela de parâmetros de configuração:
Nome | Valor | Is Default | Descrição |
active_instance_count | - | TRUE |number of active instances in the cluster database |
aq_tm_processes | 0 | TRUE | number of AQ Time Managers to start |
archive_lag_target | 0 | TRUE | Maximum number of seconds of redos the standby could lose |
asm_diskgroups | - | TRUE | disk groups to mount automatically |
asm_diskstring | - | TRUE | disk set locations for discovery |
asm_power_limit | 1 | TRUE | number of processesfor disk rebalancing |
audit_file_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP | FALSE | Directory in which auditing files are to reside |
audit_sys_operations | FALSE | TRUE | enable sys auditing |
audit_trail | NONE | TRUE | enable system auditing |
background_core_dump | partial | TRUE | Core Size for Background Processes |
background_dump_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP |FALSE | Detached process dump directory |
backup_tape_io_slaves | FALSE | TRUE | BACKUP Tape I/O slaves |
bitmap_merge_area_size | 1048576 | TRUE | maximum memory allow for BITMAP MERGE |
blank_trimming | FALSE | TRUE | blank trimming semantics parameter |
buffer_pool_keep | - | TRUE | Number of database blocks/latches in keep buffer pool |
buffer_pool_recycle | - | TRUE | Number ofdatabase blocks/latches in recycle buffer pool |
circuits | - | TRUE | max number of circuits |
cluster_database | FALSE | TRUE | if TRUE startup in cluster database mode |
cluster_database_instances | 1 | TRUE | number of instances to use for sizing cluster db SGA structures |
cluster_interconnects | - | TRUE | interconnects for RAC use |
commit_point_strength | 1 | TRUE | Bias this nodehas toward not preparing in a two-phase commit |
commit_write | - | TRUE | transaction commit log write behaviour |
compatible | 10.2.0.1.0 | FALSE | Database will be completely compatible with this software version |
control_file_record_keep_time | 7 | TRUE | control file record keep time in days |
control_files | C:\ORACLEXE\ORADATA\XE\CONTROL.DBF | FALSE | control file names list |core_dump_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP | FALSE | Core dump directory |
cpu_count | 1 | TRUE | number of CPUs for this instance |
create_bitmap_area_size | 8388608 | TRUE | size of create bitmap buffer for bitmap index |
create_stored_outlines | - | TRUE | create stored outlines for DML statements |
cursor_sharing | EXACT | TRUE | cursor sharing mode |cursor_space_for_time | FALSE | TRUE | use more memory in order to get faster execution |
db_block_buffers | 0 | TRUE | Number of database blocks cached in memory |
db_block_checking | FALSE | TRUE | header checking and data and index block checking |
db_block_checksum | TRUE | TRUE | store checksum in db blocks and check during reads |
db_block_size | 8192 | TRUE | Size of database block in bytes |db_cache_advice | ON | TRUE | Buffer cache sizing advisory |
db_cache_size | 0 | TRUE | Size of DEFAULT buffer pool for standard block size buffers |
db_create_file_dest | - | TRUE | default database location |
db_create_online_log_dest_1 | - | TRUE | online log/controlfile destination #1 |
db_create_online_log_dest_2 | - | TRUE | online log/controlfile destination #2 |db_create_online_log_dest_3 | - | TRUE | online log/controlfile destination #3 |
db_create_online_log_dest_4 | - | TRUE | online log/controlfile destination #4 |
db_create_online_log_dest_5 | - | TRUE | online log/controlfile destination #5 |
db_domain | - | TRUE | directory part of global database name stored with CREATE DATABASE |
db_file_multiblock_read_count | 128 | TRUE | db block to be read each IO |...
tracking img