{"id":1470,"date":"2011-06-12T12:12:16","date_gmt":"2011-06-12T15:12:16","guid":{"rendered":"http:\/\/blog.decade.com.br\/?p=1470"},"modified":"2011-08-30T11:02:36","modified_gmt":"2011-08-30T14:02:36","slug":"instancia","status":"publish","type":"post","link":"https:\/\/blog.decade.com.br\/?p=1470","title":{"rendered":"Inst\u00e2ncia"},"content":{"rendered":"

\n\u00c1rea que o Orade Database Server aloca em mem\u00f3ria e compartilha informa\u00e7\u00f5es. Principais componentes:<\/p>\n

\nSystem Global Area<\/strong><\/p>\n

\nEstrutura de mem\u00f3ria (Redo Log Buffer<\/u>, Data Base Cache<\/u>, Shared Pool<\/u> e Large Pool<\/u>) que facilita a troca de informa\u00e7\u00f5es entre os clientes. Cada estrutura que a constitui possui uma finalidade diferente:<\/p>\n

\n– Redo Log buffer: Armazena e registra altera\u00e7\u00f5es feitas, como instru\u00e7\u00f5es de INSERT, DELETE e UPDATE;<\/p>\n

\n– Database Buffer Cache: Armazena os dados que foram utilizados recentemente pelo Banco de Dados;<\/p>\n

\n– Shared Pool: Armazena todos os comandos (recentes<\/em>) utilizados;<\/p>\n

\n– Large Pool: \u00c1rea adicional para processar em mem\u00f3ria grandes requisi\u00e7\u00f5es de E\/S.<\/p>\n

\nProgram Global Area<\/strong><\/p>\n

\nAuxilia na execu\u00e7\u00e3o de processos, armazenando informa\u00e7\u00f5es de Vari\u00e1veis<\/u>, \u00c1reas de Classifica\u00e7\u00e3o<\/u> e Cursores de Blocos PL\/SQL<\/u>.<\/p>\n

\nBackground Processes<\/strong><\/p>\n

\nServi\u00e7os do Sistema Operacional que uma Inst\u00e2ncia utiliza. Esses servi\u00e7os variam desde a Grava\u00e7\u00e3o em Disco<\/u> at\u00e9 a Gera\u00e7\u00e3o de Arquivos de Redo Log File<\/u>, denominados ARCHIVES, que tem como finalidade a recupera\u00e7\u00e3o (RECOVERY<\/em>) do Banco de Dados.<\/p>\n

\nAl\u00e9m desses componentes, toda inst\u00e2ncia conta com um arquivo principal chamado INIT.ORA. Esse arquivo cont\u00e9m diversos par\u00e2metros de configura\u00e7\u00e3o. O caminho padr\u00e3o \u00e9 ORACLE_HOME\\server\\dbs.<\/p>\n

\nINIT.ORA<\/strong><\/p>\n

\n<\/p>\n

\n###########################################
\n# Copyright (c) 1991, 2005, Oracle. All rights reserved.
\n###########################################<\/p>\n

###########################################
\n# Cursors and Library Cache
\n###########################################
\nopen_cursors=300<\/p>\n

###########################################
\n# Database Identification
\n###########################################
\ndb_name=XE<\/p>\n

###########################################
\n# Diagnostics and Statistics
\n###########################################
\nbackground_dump_dest=C:\\ORACLE\\DBXE10G\\app\\oracle\\admin\\XE\\bdump
\ncore_dump_dest=C:\\ORACLE\\DBXE10G\\app\\oracle\\admin\\XE\\cdump
\nuser_dump_dest=C:\\ORACLE\\DBXE10G\\app\\oracle\\admin\\XE\\udump<\/p>\n

###########################################
\n# File Configuration
\n###########################################
\ncontrol_files=(\"C:\\ORACLE\\DBXE10G\\oradata\\XE\\control.dbf\")<\/p>\n

###########################################
\n# Job Queues
\n###########################################
\njob_queue_processes=4<\/p>\n

###########################################
\n# Miscellaneous
\n###########################################
\ncompatible=10.2.0.1.0<\/p>\n

###########################################
\n# Processes and Sessions
\n###########################################
\nsessions=20 <\/p>\n

###########################################
\n# SGA Memory
\n###########################################
\nsga_target=140M<\/p>\n

###########################################
\n# Security and Auditing
\n###########################################
\naudit_file_dest=C:\\ORACLE\\DBXE10G\\app\\oracle\\admin\\XE\\adump
\nremote_login_passwordfile=EXCLUSIVE<\/p>\n

###########################################
\n# Shared Server
\n###########################################
\ndispatchers=\"(PROTOCOL=TCP) (SERVICE=XEXDB)\"
\nshared_servers=4 <\/p>\n

###########################################
\n# Sort, Hash Joins, Bitmap Indexes
\n###########################################
\npga_aggregate_target=40M<\/p>\n

###########################################
\n# System Managed Undo and Rollback Segments
\n###########################################
\nundo_management=AUTO
\nundo_tablespace=UNDO<\/p>\n

###########################################
\n# Backup and Recovery
\n###########################################
\nDB_RECOVERY_FILE_DEST_SIZE = 10G
\nDB_RECOVERY_FILE_DEST = C:\\ORACLE\\DBXE10G\\app\\oracle\\flash_recovery_area<\/p>\n

os_authent_prefix=\"\"\n<\/p><\/blockquote>\n

<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00c1rea que o Orade Database Server aloca em mem\u00f3ria e compartilha informa\u00e7\u00f5es. Principais componentes: System Global Area Estrutura de mem\u00f3ria (Redo Log Buffer, Data Base Cache, Shared Pool e Large Pool) que facilita a troca de informa\u00e7\u00f5es entre os clientes. Cada estrutura que a constitui possui uma finalidade diferente: – Redo Log buffer: Armazena e […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1470","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1470"}],"version-history":[{"count":0,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1470\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}