INSTANCIA
~~~~~~~~

Parameterek
----------

DB_block_puffers
Inditasi parameterek: $orahome/(...)/init.ora init_v8.ora

Parameterek lekerdezese:
select name, value form v$parameter
where name like '%db_block%';


Hangolasi parameterek
------------------
v$sysstat ( fizikai_db/(db_block gets + consistant gets) ) --> alt. 90%
v$rowcache ( getmisses / gets )
v$librarycache
v$sgastat (Mennyi szabad hely van az SGA-ban?)


Init parameterek
-------------
open_cursor (Egy user hany kurzort hasznalhat?)
processes (Max. hany kurzor futhat?)
sessions (Max. hany session futhat?)
shared_pool_size (A Shared Pool merete?)
transactions (Rollback-szegmensenkent hany tranzakcio futhat?)
timed_statistics (Csak tesztuzemben ajanlott: a futasi idoket meri, de sok eroforrast lekot)


Feladat6.txt
---------
1. v$sysstat
2. v$parameter
3. v$parameter
4. v$sessions
5. v$database
6. v$filestat
7. v$logfile, v$controlfile
8. v$opencursor

File-statisztikak:
phyrds (physical reads)
phywrtd (ph. writes)
phyblkrds (ph. block reads)
phyblkwrtrs (ph. block writes)

Hangolas.txt
----------
4. (shared pool)
5. v$sysstat, sort_area_size (+ decode fuggveny)
6. v$sqlare (disk_reads, buffer_gets)
7. v$filestat, v$dbfile, dba_data_files

--------
2002. december 3.
Szamoskozi Peter