Banco de dados oracle

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 processes for 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 of database 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 node has