SWAP Memory being Used

[betoparanhos]

Dear friends,

How to check the reason you are taking the Oracle Bank being using the SWAP memory.
could anyone pass me commands to be able to track this use?

grateful,

Beto


Environment information:
* version of the Oracle: 10g
* Operating system: RedHat

[pauloaleo]

Reasons is one. If you are using swap it is why there is no memory.

How much memory you have on Linux, and as for SGA + PGA allocates.

To check full memory of Linux Use the Free command.

and how many location = on you have on the machine.

[betoparanhos]

Thank you friend for trying to help me.

My server has 4GB

SQL> Show SGA;

99] Total System Global Area 1040187392 bytes
Fixed Size 2025968 bytes
Variable Size 390071824 bytes
Database Buffers 641728512 bytes
Redo Buffers 6361088 bytes


Total memory:
[Oracle @ server ~] $ free
Total Used Free shared Buffers Cached
: 3981312 3898524 82785 0 31404 2402908
- / + Buffers / Cache: 1464212 2517100
SWAP: 2104472 32696 2071776


Check the location = no?

Thank you for your attention.

[pauloaleo]

at the OS prompt

PS -EF | Grep Local = No | WC -L

Multiply the number of 40

[betoparanhos]

Paul,

The result multiplied by 40 was 3,080.

[pauloaleo]

Verifying the data you sent, especially the free I see that your machine does not swap. Even Linux is making a 2.4GB caching of memory.

Where did you check the swap?

[emer_rosa]

Good afternoon,

PS -EF | Grep Local = No | WC -L multiplied by 40 gave 680

[root @ orcl ~] # PS -EF | Grep Local = No | WC -L
17
[root @ orcl ~] # Free
Total Used Free shared Buffers Cached
Mem: 16428948 16368384 60564 0 255856 15034040
- / + buffers / cache: 1078488 15350460
SWAP: 2104472 677440 1427032


Total System Global Area 4275781632 bytes
Fixed Size 2233336 bytes
Variable Size 2583694344 bytes
Database Buffers 1677721600 bytes
Loop Buffers 12132352 bytes


The server has 16GB, Oracle 11g, Is this good or doing swap?