Optimizing Oracle Instances

Question

I work with a team that develops an application that runs on SQL Server and Oracle.

SQL Server has an instance concept that can host multiple databases. Oracle 10g requires one instance for each database (and may allow more for redundancy), so for each running database we have a completely separate set of processes and, therefore, a much larger amount of memory usage.

Because of this, we began to move more, having one instance with separate circuits. However, we still want to separately separate the individual client data (or dev machines).

Most of our instances are created using locally developed scripts (for example, oradim for Windows).

What can be done to reduce the requirements for the use of memory, footprint, etc. Oracle instances so that multiple instances can work safely on the same machine? Is Linux or Windows the best host? Can we make a simple gain by disabling additional features (data mining, Oracle Text, etc.) that we do not need?

Answer 1

MEMORY_TARGET is the parameter that you want to set if you are using Oracle 11g.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams133.htm

, , . Oracle 10g PGA_AGGREGATE_TARGET SGA_TARGET.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams157.htm

, Oracle , , .

Windows Linux.

Answer 2

IMHO Oracle.

SQL PL/SQL, ..

, TABLESPACES . LOGFILES.

, Data Mining, , , .

, , , , , , , .

, OLTP , concurrency, , , sort_area_size hash_area_size, db_block_buffers .

HASH JOINS MERGE JOINS, sort_area_size hash_area_size , db_block_buffers, .

Linux Windows Oracle. Linux, , LOCK_SGA. Windows , .

Answer 3

:

• per-instance SGA
• UGA, PGA ( ..)
• . , (, , , , ..).

1 , . , , .

2, ( ), .

, 3 Linux - fork , , . * nix fork-for-multithreaded , , ( .)

---

, Windows top - " ": , oracle , ( ) . Unix "pmem" "cat/proc//maps", , .

Answer 4

, . , . , , . , . . , , . " ".

- Oracle , . , , TOAD Oracle, Oracle.

Answer 5

, . ? producton.

. .

Answer 6

" ". , , .

http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/admusers.htm#i1012785

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2007.htm#sthref4352

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dbrm.htm#ADMIN027

( ) . , tt () , , (, , ), .

Answer 7

Can you add memory to the server? You can buy 32 GB of memory for less than $ 1,000.