Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "what the oracle architecture is like". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Oracle parameter file

-- Summary:

-- oracl system

-show parameter xxx + CRUD + demo

-xxx_target: = 0, changed by 0

-1. Analysis of related parameters of SGA+PGA

-- SGA parameter analysis

-- show parameter memory

-- buffer_cache

-(1) sga_target

-- PGA parameter analysis

(2) pga_aggregate_target

-- buffer_cache

Show parameter shared_pool

-- db_cache_size

-- logbuffer

Show parameter shared_pool

-- 2.

ALTER SYSTEM RESET parameter

CRUD

3. Conversion between binary and spfile

-Parameter file conversion

Text-binary

Create spfile from pfile

Binary-text

Create pfile from spfile

-- orale NET

Shared mode, and proprietary mode

-shared u mode-system does not allow libraries to be closed, shared libraries

1.1 the server is the foreground process.

1.2 client-server process structure

-- DBLInk

-- operating system

Question:

1. Database write process mechanism.

two。 To discuss or ask questions.

That's all for "what the oracle Architecture is like". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.