powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / Oracle [игнор отключен] [закрыт для гостей] / Fixed SGA Variables
7 сообщений из 32, страница 2 из 2
Fixed SGA Variables
    #34820751
Сына
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
RihardИзвестный сайт случайно не itpub? :)
Неа, не угадал ;)
...
Рейтинг: 0 / 0
Fixed SGA Variables
    #34820774
Фотография Rihard
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Странно, вышеперечисленное гугль не находит
Может, плохо ищу...
...
Рейтинг: 0 / 0
Fixed SGA Variables
    #34820807
Vertigo
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Сына, спасибо. + чутка к Вашему списку
ФункцияРасшифровкаkgherror KGH: Internal routine for signaling an error kghfrmrg KGH: Free a chunk, merge with neighbors if free Returns merged chunk. kghfre KGH: Free a chunk of memory. kghfrh Free heap. Free all the extents allocated in the heap using kghalfrx(). kgldafr kgldafr - KGL data block FRee */ kglobfr kglobfr - KGL OBject FRee all heaps (except data block 0`s) of an object */ kglobf0 kglobf0 - KGL OBject Free heap/data block 0 of an object */ kglhdiv kglhdiv - KGL object HanDle InValidate all read-only dependents kglhdi kglhdi - KGL HanDle Invalidate all read-only dependents of an object, kqlmbpil kqlmbpil - KQLM Background process a Pin Instance Lock */ kqlmba kqlmba - KQLM Background interrupt Action */ ksbcti call timeout/interrupts */ kgllccl kgllccl - KGL Latch Clean-up CLean */ kgllcu kgllcu - KGL Latch Clean-Up for the library cache and pin latches */ kslcln0 Convenient cleanup subroutine for kslcln(): kslcln Invoke the latch cleanup procedure of the latch or free all latches acquired kqlnfy KQL: KQL NotiFY kscnfy KSC: Procedure to cause notifications be passed to components. ksmshu Oracle instance is about to be SHUt down. Do final checks on SGA.
...
Рейтинг: 0 / 0
Fixed SGA Variables
    #34976702
Vertigo
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Решил запостить здесь, хорошие темы не должны умирать :)

по следам топиков "как же мне инвалидировать конкретный курсор?"


Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",kglhdpar 
from x$kglcursor where kglnaobj like 'select count(*) from t %' and kglhdpar<>kglhdadr;
sql_text
--------------------------------------------------------------------------------
     loads executions invalidations KGLHDPAR 
---------- ---------- ------------- -------- 
select count(*) from t /* death is inevitable */
          1            2               0   27609164  

select count(*) from t /* life must go on */
          1            2               0  27609E8C 

SQL> alter session set events 'immediate trace name heapdump level 2050';

-- в получившемся трейсе ищу такое:

29BBB260 29BBB260 29BBB260 29BBB268 29BBB268 [`..)`..)h..)h..)]
29BBB270 29BBB270 29BBB270 29BBB278 29BBB278 [p..)p..)x..)x..)]
29BBB280 29BBB280 29BBB280 27609164 27609164 [...)...)d.`'d.`']
29BBB290 29BBB290 29BBB290 29BBB298 29BBB298 [...)...)...)...)]
29BBB2A0 29BBB2A0 29BBB2A0 29BBB2A8 29BBB2A8 [...)...)...)...)]

Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
SQL> oradebug peek 0x29bbb288  8 
[29BBB288, 29BBB290) =  27609164   27609164 
SQL> oradebug poke 0x29bbb288  4  0x29bbb288
BEFORE: [29BBB288, 29BBB28C) =  27609164 
AFTER:  [29BBB288, 29BBB28C) = 29BBB288
SQL> oradebug poke 0x29bbb28c  4  0x29bbb288
BEFORE: [29BBB28C, 29BBB290) =  27609164 
AFTER:  [29BBB28C, 29BBB290) = 29BBB288
SQL> oradebug peek 0x29bbb288  8 
[29BBB288, 29BBB290) = 29BBB288 29BBB288
SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",kglhdpar
 from x$kglcursor where kglnaobj like 'select count(*) from t %' and kglhdpar<>kglhdadr;
sql_text
--------------------------------------------------------------------------------
     loads executions invalidations KGLHDPAR 
---------- ---------- ------------- -------- 
select count(*) from t /* life must go on */
          1            2               0  27609E8C
выполния в другой сессии
Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
SQL> select count(*) from t /* death is inevitable */;

  COUNT(*)
----------
          1 

SQL> select count(*) from t /* life must go on */;

  COUNT(*)
----------
          1 
SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",kglhdpar
 from x$kglcursor where kglnaobj like 'select count(*) from t %' and kglhdpar<>kglhdadr;
sql_text
--------------------------------------------------------------------------------
     loads executions invalidations KGLHDPAR 
---------- ---------- ------------- -------- 
select count(*) from t /* death is inevitable */
          1            1               0  2750EC24

select count(*) from t /* life must go on */
          1            3               0  27609E8C
тот кусок дампа sga, который я привел - похоже это хэш бакеты library кэша и если к бакету не привязан никакой обьект, то он ссылается сам на себя. Если кто-то знает более простой способ узнать, к какому бакету относится конкретный объект, не таите это знание :)
пс. я долго пытался сделать все по-правильному, через oradebug call, но в конце-концов плюнул - и в результате этот тупой хак. Я понимаю, что по-хорошему надо бы "освободившиеся" чанки прилинковать к free list, но это для меня слишком сложно :) и неинтересно



напоследок - обратная процедура - запинить курсор. Я думаю, читатели _этого_ топика будут со мной солидарны, что dbms_shared_pool.keep - это не наш метод
Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",
to_char(KGLHDFLG, 'XXXXXXXX') as flags,kglhdpar,kglhdadr 
from x$kglcursor where kglnaobj like 'select count(*) from t%';

no rows selected

SQL> select count(*) from t /* cur1 */;

  COUNT(*)
----------
          1 

SQL> select count(*) from t /* cur1 */;

  COUNT(*)
----------
          1 

SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",
to_char(KGLHDFLG, 'XXXXXXXX') as flags,kglhdpar,kglhdadr 
from x$kglcursor where kglnaobj like 'select count(*) from t%';

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------
select count(*) from t /* cur1 */
          1            2               0    10010100                    27742CD4
 27742330 

select count(*) from t /* cur1 */
          1            0               0   120100D0                   27742CD4
27742CD4

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------


SQL> oradebug setmypid
Statement processed.
SQL> oradebug peek 0x277423A8  4      -----флаги по адресу KGLHDADR+0x78
[277423A8, 277423AC) =  10010100 
SQL> oradebug poke 0x277423A8  4  0x10810100
BEFORE: [277423A8, 277423AC) =  10010100 
AFTER:  [277423A8, 277423AC) =  10810100 
SQL> oradebug peek 0x27742D4C  4 
[27742D4C, 27742D50) = 120100D0
SQL> oradebug poke 0x27742D4C  4  0x128100D0
BEFORE: [27742D4C, 27742D50) = 120100D0
AFTER:  [27742D4C, 27742D50) = 128100D0
SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",
to_char(KGLHDFLG, 'XXXXXXXX') as flags,kglhdpar,kglhdadr 
from x$kglcursor where kglnaobj like 'select count(*) from t%';

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------
select count(*) from t /* cur1 */
          1            2               0    10810100                    27742CD4
 27742330 

select count(*) from t /* cur1 */
          1            0               0   128100D0                   27742CD4
27742CD4

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------


SQL> alter system flush shared_pool;

System altered.

SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",
to_char(KGLHDFLG, 'XXXXXXXX') as flags,kglhdpar,kglhdadr 
from x$kglcursor where kglnaobj like 'select count(*) from t%';

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------
select count(*) from t /* cur1 */
          1            2               1    14810100                    27742CD4
 27742330 

select count(*) from t /* cur1 */
          1            0               0   128100D0                   27742CD4
27742CD4

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------


SQL> select count(*) from t /* cur1 */;

  COUNT(*)
----------
          1 

SQL> select kglnaobj as "sql_text", kglhdldc as "loads",kglhdexc as "executions",kglhdivc as "invalidations",
to_char(KGLHDFLG, 'XXXXXXXX') as flags,kglhdpar,kglhdadr 
from x$kglcursor where kglnaobj like 'select count(*) from t%';

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------
select count(*) from t /* cur1 */
          1            3               1    14810100                    27742CD4
 27742330 

select count(*) from t /* cur1 */
          1            0               0   128100D0                   27742CD4
27742CD4

sql_text
--------------------------------------------------------------------------------
     loads executions invalidations FLAGS                       KGLHDPAR
---------- ---------- ------------- --------------------------- --------
KGLHDADR
--------


SQL>                                            
правда, на дочернем курсоре выставился флаг "object should be freed upon unlock" - видимо, я где-то накосячил, как обычно

кстати, значения битов курсора, если кому интересно:
Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
KGHP/TIM/LRG/[00000001]	SML/MED/LRG: small/medium/large indicates size of the handle
KGHP/TIM/BSO/[00000002]
KGHP/TIM/KEP/[00000004]
KGHP/TIM/NORFINV/[00000008]
KGHP/TIM/KST/[00000010]
KGHP/TIM/XLR/[00000020]
KGHP/TIM/DBN/[00000040]
KGHP/TIM/MTX/[00000080]
KGHP/TIM/EXP/[00000100]
KGHP/TIM/MSKPW/[00000200]
KGHP/TIM/[00000400]
KGHP/TIM/[00000800]
KGHP/TIM/[00001000]
KGHP/TIM/[00002000]
KGHP/TIM/[00004000]
KGHP/TIM/[00008000]
RON/KGHP/TIM/[00010000]	read only
REM/KGHP/TIM/[00020000]	remote object
KGHP/FIX/TIM/[00040000]	fixed object
KGHP/CGA/TIM/[00080000]	object in CGA memory
PKP/KGHP/TIM/[00100000]	permanently kept object
KGHP/TIM/MVR/[00200000]
KGHP/TIM/OBS/[00400000]	has been marked obsolete
KGHP/TIM/KEP/[00800000]	is marked to be kept in the shared pool
SEC/KGHP/TIM/[01000000]	this object is secondary
KGHP/TIM/SML/[02000000]	SML/MED/LRG: small/medium/large indicates size of the handle
KGHP/TIM/FUL/[04000000]	object should be freed upon unlock 
KGHP/TIM/FUP/[08000000]	object should be freed upon unpin
KGHP/TIM/PN0/[10000000]	heap 0 should be kept pinned as long as any user has a lock on the handle
KGHP/TIM/USE/[20000000]	in use (do not unpin)
KGHP/TIM/MED/[40000000]	SML/MED/LRG: small/medium/large indicates size of the handle
KGHP/TIM/FRE/[80000000]
...
Рейтинг: 0 / 0
Fixed SGA Variables
    #35213970
Сына
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Еще немного ядерных функций в общую копилку.

Функция Описаниеdrepprep perform the document indexingevapls EVAluate any PLSql functionkcmclscn check Lamport SCNkcsadj1 adjust SCNkgesinv KGE Signal Internal (Named) error (with VA_list)kghalo KGH: main allocation entry pointkghalp KGH: Allocate permanent memorykghfnd KGH: Find a chunk of at least the minimum sizekghfrunp KGH: Ask client to free unpinned spacekghfrx Free extent. This is called when a heap is unpinned to request that itkghgex KGH: Get a new extentkghnospc KGH: There is no space available in the heapkghpmalo KGH: Find and return a permanent chunk of spacekghxal Allocate a fixed size piece of shared memory.kglhpd KGL HeaP Deallocatekglobcl KGL OBject CLear all tableskglpnal KGL PiN ALlOcatekglpnc KGL: PiN heaps and load data pieces of a Cursor objectkglpndl KGL PiN DeLetekglrfcl KGL ReFerence CLearkgmexec KGM EXECutekkmpost POST PROCESSINGkksalx ALlocate 'size' bytes from the eXecution-time heapkkscls KKS: Close the cursor, user is done with itkkspfda Multiple context area managementkkssbt KKS: set bind typeskksscl KKS: scan child list?koklcopy KOK Lob COPY.koklcpb2c KOK Lob CoPy Binary data (BFILE/BLOB) into Clobkolfgdir KOL File Get DIRectory object, path and FileNames.kpuexec KPU: Executekpuexecv8 KPU: Execute V8kpurcsc KPU Remote Call with ServiceContext, Callbackskqdgtc return an open and parsed cursor for the given statementkqldprr KQLD Parent Referential constraint Readkqllod KQL: database object loadkqlsadd kqlsadd - KQLS ADD a new element to a subordinate setkqlslod KQLS: Load all subordinate set elements for a given heapkslcll KSL: Clean up after a given latchkslcllt Clean up after a given latchkslilcr invoke latch cleanup routine:ksmapg KSM: Callback function for allocating a PGA extent, calls OSD to allocksmasg Callback function for allocating an SGA extent.kssxdl KSS: delete SO ignoring all except severe errors. cleans latchesksucln KSUCLN: Cleanup detached processksudlc delete callksudlp KSU: delete process.called when user detaches or during cleanup by PMONksuxda KSUCLN: Attempt to delete all processes that are marked dead.ksuxdl KSUCLN: Delete state object for PMONksuxfl KSU: Find dead processes and cleanup their latches. Called by PMONkxfpbgpc Get Permanent Chunkskxfpbgtc Buffer Allocation Get Chunkkxfpnfy KXFP: NotiFY (component notifier)kxfxse KXFX: executekxstcls Trace cursor closingopicca ORACLE Program Interface: Clear Context Areaopiclo ORACLE Program Interface: CLOse cursoropiprs ORACLE Program Interface: PaRSeopitca OPITCA: sets up the context areapextproc Pefm call EXTernal PROCedureqerocStart This function creates a collection iterator row-source to iterateqkadrv QKADRV: allocate query structuresqkajoi QKAJOI: Query Kernel Allocation: JOIn processingqximeop QXIM Evaluate OPerandrpicls RPI: Recursive Program Interface CLoSeselexe SELEXE: prepare context area for fetchxtyinpr XTY Insert Numeric PRecision operator
...
Рейтинг: 0 / 0
Период между сообщениями больше года.
Fixed SGA Variables
    #35958919
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
раз пошла такая пьянка...
Bug No. 3644809
фильтровать что было, что не было лень :)
...
Рейтинг: 0 / 0
Период между сообщениями больше года.
Fixed SGA Variables
    #39579550
Kamael
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Собрал в один список.

Функция Описаниеctcdrv Create Table or Cluster DRiVer.insexe insert executeinsidx Insert indexed keys into the indexes after each row is inserted into the insflushinsrow Fetch a row for insertion. This is called back by multirow insertkaudfb KAU: Flush any pending bitmap index changeskauupd KAU: update table and modify indexeskauxsin Insert a key into x index segment(s) onlykcbema Exam and Maybe Applykcblio Kernel Cache Buffer Load issue I/Okcblrr Kernel Cache Buffer Load Release all Resourceskcblsy Kernel Cache Buffer Load Sync i/okcocbk Kernel Cache Op CallBacK -- invoke redo callback routinekcramr Apply Media Recoverykddchg perform delete/update CHanGe.kdddel Delete rowkdddgb KDD: Kernel Data Delete Get Blockkdiblcfls KDIBL conventional flush batch with undo overheadkdiblfls KDIBL: FLuSh batchkdiblovfls KDIBL: flush overlapping batchkdiblread KDIBL: READ kdi entry containing the speciied dml/load itemkdiblwrite KDIBL: WRITE a kdi entrykdiins0 inserts the argument key and associated keydata into. the argument b-tree indexkdiins inserts the argument key and associated keydata into. the argument b-tree indexkdilinle Insert argument key/keydata into an uncompressed leaf block.kdimod modifies the argument key`s row from the argument index accordingkdisle split the argument leaf block and insert the argument key.kdisnew Allocate a new index block during a split.kdisnewle Allocate and initialize a new leaf block during a split.kdl_copy copies data between two ILOB instanceskdoiur Applying rollback records to data blockskdsgrp Get a Row Piecekdstgr Tablescan Get Rowkdumrp KDU: Update multiple row pieceskduovw Kernel Data Update, updates already existing rowskdusru KDU: Single Row Update, main entrykduurp KDU: update row piecekgeasi Raise an error on an ASSERTION failure (IGNORE)kgepop kgepop - KGE POP to the current top error framekgerem KGE Record Error code (with already-formatted Message)kgerinv KGE Record Internal (Named) error (with Va_list)kgeriv KGE Record Internal error code (with Va_list) (IGNORE)kgesev KGE: Signal Error code (with Va_list)kgesiv KGE Signal Internal error code (with VA_list)kglgob KGL: GeT an Object locked and pinnedkglobld KGL2: OBject LoaDkglobpn KGL2: OBject PiN heaps and load data pieceskglpim KGL: PIn and load More heapskglpin KGL: PIN heaps and load data pieces of an objectkjuscv Sync. Convertkksfbc KKS: Find Bound Cursorkkxexe KKX: execute plsqlklclil1r Kernel Loader C Level Interface Load 1 Rowklcslod load nls data objectknahsma Kernel replicatioN Apply Hadb Slave MAinknasgvm Kernel replicatioN Apply Slave Get Validknaslod Kernel replicatioN Apply Slave LOaD metadataknasm2 Kernel replicatioN Apply Slave Main 2knaspd Kernel replicatioN Apply Slave Process Dmlknaspx Kernel replicatioN Apply Process transaXtionkoklcre KOK Lob CREatekokleva KOKL EVAluatekokliclo KOK Lob Internal Create with another LOcatorkprball execute ALL bundled KPR (RPI) operationsksbrdp KSB: run a detached (background) processksddoa Debug support Do an Actionksdpcg KSD: Post and check event in the specified event groupksdpec KSD: Post Event and Check trigger conditionksdxcb CallBack for sosd layer signal handler (IGNORE)ksedmp KSE: dump the process stateksepop perform cleanup when an error frame is being poppedksesec0 IGNORE: Signal an errorksfdmp Call relevant dump routineksfpec KSF: Post an eventkslgetl Get the latch specified by 'id', on behalf of the current session. If 'wait' is FALSE, returnksliwat KSL: Latching: Awaken a wait eventkslwait Wait for N centi-seconds or until postedksqcmi KSQ: Change modeksqcnv convert an enqueue`s modeksqcov convert an enqueue`s modeksqded KSQ: deadlock detectionksqgel KSQ: get an enqueue. Acquire an enqueue on the specified resource with the additional ability to read a lock value.ksqgtl KSQ: get an enqueuekssdch KSS: delete children of state obj.ksursn Kernel Transaction Undo Rollback segment Shrink Numbered.ktaadm Kernel Transaction Access get All DML locksktagdm KTA: Kernel Transaction Access Get DML lockktagetp Kernel Transaction Access Get Partition lockktaifm Kernel Transaction Access Internal Find DML lockktbgfi general find an itl entryktbgtl test a lock value, clean or wait as needed to delete itktcrab KTC: Kernel Transaction Control Real ABort - Abort a transaction.ktcwit KTC: Kernel Tranasction Control: WaITktmmon KTM: TX Monitor: background timeout actionktmpsm private procedure to post SMONktmpst post system monitor processktrsexec executes resumable function.ktsf_gsp Kernel Transaction Segment Get SPacektsxterr KTS Find EXtent Errorktuabt Kernel Transaction Undo ABorT. Updating undo segment headers on rollback (ABorT)ktubko Reading rollback blocks to apply undo recordsktubnd Kernel transaction Undo BiNDktubsy Kernel Transaction Undo BuSYktuchg Kernel Transaction Undo Change. Write logs and perform changes.ktucmt Kernel Transaction Undo CoMmit Transactionktudba Kernel Transaction Undo convert from usn to DBAktugdl Kernel Transaction Undo Get Ddl Lock Get an 'US' lock in X-mode. If (USC) is passed in, the USC row cache will also be read and the rbs name will be verified. If it does not match, OER(1534)ktugnb Undo segment header to Get Next undo Blockktugusc Kernel Transaction Undo Get Undo Segmentkturdb Kernel Transaction Undo segment Redo Data Block.ktursr Kernel Transaction Undo Rollback segment Shrink Requestedktusmasp1r Kernel Transaction Undo SMu Add SPace resumablektusmasp Kernel Transaction Undo SMu Add SPace - adding space to a SMU segmentktusm_shrinkoff Kernel Transaction Undo SMU Shrink Offline Rollback Segs. This routine shrinks offlined rollback segments. It walks through all rollback segments, for each offlined rollback segs, if the rollback seg belongs to this tablespace, shrinks it. If it gets 'extsize' # of blocks, it returns TRUE, otherwise, it returns FALSE.ktusrs Kernel Transaction Undo Shrink Rollback Segmentskwqitmmsgs Kernel OLTP Queues Interface Time Monitor MeSsaGeS.kwqitptm Kernel OLTP Queues Interface Perform Time Management.kxcbcri CReate Index containing everything in the current workspacekxcbcti KXCB Convert To Indexkxcbdel Delete the entry with a given key from the skip listkxccres KXCC REStrict constraint enforcementkxcwsub Decrement a workspace counter. Delete the counter if the count reaches 0kxfpgsg KXFP: Get Server Group (coordinator)kxfpqidqr KXFP: Queue Internal DeQueue queue Referencekxfpqrsod KXFP: Queue Ref State Object Deletekxfpqsod KXFP: Queue State Object Deletekxfpqsrls KXFP: Query Slave ReLeaSekxfprdp Run Detached Processkxfprienq KXFP: queue Ref Internal ENQueue messagekxfrAllocSlaves Allocate Slaveskxfralo KXFR: ALlOcate rowid ranges and slave processeskxfxcp1 KXFX: open, parse, bind 1 set of slaveskxibDoFinish do finish processing for a specified indexkxibFinish kxib Finish index maintenance processingnldatxt put current date/time into stringnstimexp expire function - invoked by ltm with these specific arguments.opiexe ORACLE Program Interface EXEcuteopifch oracle side of the fetch interfaceopifcr OPIFCH: fetch callback - fetch a rowopiino ORACLE Program Interface INitialize Opiopiodr OPIODR: ORACLE code request driver - route the current requestopirip Oracle Program Interface Run Independent Process (IGNORE).opitsk Two Task Oracle Side Function Dispatcherpeicnt PL/SQL controlled Executionpfrrun PSDEVN: PL/SQL Interpreter Main Instruction Looppsddr0 Null pointer definitions for ttcdrv callback and context. Used in psddrv.qerupFetch QERUP: Update Row source FetCHrpidru RPI: setup memory for the recursive session (unclear)rpidrus RPI: Recursive program handling (unclear)rpidrv RPI: Recursive Program Interface DRiVerrpiswu2 RPI: SWitch User in recursive sqlrwsfcd RWSIMA: fetch from row sourceskgmstack call specified function with extra STACK space.sou2o Main Oracle executable entry point IGNORE this in call stacksssexhd DUMP ROUTINE - IGNORE stuff above this on the stacksspuser handle SIGUSR2 for ORACLE.ttcpip Two Task Common PIPe read/writeupdaul UPDate Attempt Update of all rows or Lock all rowsupdexe update executeupdpcr UPDate Perform Constraint operations for each Row updatedupdrow Row Procedure used by KXRD to update or lock a rowdrepprep perform the document indexingevapls EVAluate any PLSql functionkcmclscn check Lamport SCNkcsadj1 adjust SCNkgesinv KGE Signal Internal (Named) error (with VA_list)kghalo KGH: main allocation entry pointkghalp KGH: Allocate permanent memorykghfnd KGH: Find a chunk of at least the minimum sizekghfrunp KGH: Ask client to free unpinned spacekghfrx Free extent. This is called when a heap is unpinned to request that itkghgex KGH: Get a new extentkghnospc KGH: There is no space available in the heapkghpmalo KGH: Find and return a permanent chunk of spacekghxal Allocate a fixed size piece of shared memory.kglhpd KGL HeaP Deallocatekglobcl KGL OBject CLear all tableskglpnal KGL PiN ALlOcatekglpnc KGL: PiN heaps and load data pieces of a Cursor objectkglpndl KGL PiN DeLetekglrfcl KGL ReFerence CLearkgmexec KGM EXECutekkmpost POST PROCESSINGkksalx ALlocate 'size' bytes from the eXecution-time heapkkscls KKS: Close the cursor, user is done with itkkspfda Multiple context area managementkkssbt KKS: set bind typeskksscl KKS: scan child list?koklcopy KOK Lob COPY.koklcpb2c KOK Lob CoPy Binary data (BFILE/BLOB) into Clobkolfgdir KOL File Get DIRectory object, path and FileNames.kpuexec KPU: Executekpuexecv8 KPU: Execute V8kpurcsc KPU Remote Call with ServiceContext, Callbackskqdgtc return an open and parsed cursor for the given statementkqldprr KQLD Parent Referential constraint Readkqllod KQL: database object loadkqlsadd kqlsadd - KQLS ADD a new element to a subordinate setkqlslod KQLS: Load all subordinate set elements for a given heapkslcll KSL: Clean up after a given latchkslcllt Clean up after a given latchkslilcr invoke latch cleanup routine:ksmapg KSM: Callback function for allocating a PGA extent, calls OSD to allocksmasg Callback function for allocating an SGA extent.kssxdl KSS: delete SO ignoring all except severe errors. cleans latchesksucln KSUCLN: Cleanup detached processksudlc delete callksudlp KSU: delete process.called when user detaches or during cleanup by PMONksuxda KSUCLN: Attempt to delete all processes that are marked dead.ksuxdl KSUCLN: Delete state object for PMONksuxfl KSU: Find dead processes and cleanup their latches. Called by PMONkxfpbgpc Get Permanent Chunkskxfpbgtc Buffer Allocation Get Chunkkxfpnfy KXFP: NotiFY (component notifier)kxfxse KXFX: executekxstcls Trace cursor closingopicca ORACLE Program Interface: Clear Context Areaopiclo ORACLE Program Interface: CLOse cursoropiprs ORACLE Program Interface: PaRSeopitca OPITCA: sets up the context areapextproc Pefm call EXTernal PROCedureqerocStart This function creates a collection iterator row-source to iterateqkadrv QKADRV: allocate query structuresqkajoi QKAJOI: Query Kernel Allocation: JOIn processingqximeop QXIM Evaluate OPerandrpicls RPI: Recursive Program Interface CLoSeselexe SELEXE: prepare context area for fetchxtyinpr XTY Insert Numeric PRecision operatorsedmp # KSE: dump the process statekgeriv # KGE Record Internal error code (with Va_list) (IGNORE)kgeasi # Raise an error on an ASSERTION failure (IGNORE)kdbmrd ? Module Notes: kdb.c - Kernel Data Block structure and internal manipulationkdoqmd ? Module Notes: kdo.c - Kernel Data Operationskcoapl NAME: kcoapl - Kernel Cache Op APpLyktuapundo ktuapundo - Kernel Transaction Undo APply UNdo ktbapundo ktbapundo - Kernel Transaction Block APply UNdo kdoiur declare local objects */kcoubk kcoubk - Kernel Cache Op Undo callBacK -- invoke undo callback routine */ktundo ktundo - Kernel Transaction UNDOktubko Get undo record to rollback transaction, non-CR only */ktuabt ktuabt - Kernel Transaction Undo ABorT */ktcrab KTC: Kernel Transaction Control Real ABort - Abort a transaction.k2labo abort session: first abort aborts txk2send TESTING SUPPORT:xctrol XaCTion ROLlback: Rollback the current transaction of the current session.opiodr OPIODR: ORACLE code request driver - route the current ttcpip TTCPIP: Two Task Common PIPe read/writeopitsk Two Task Oracle Side Function Dispatcheropiino ORACLE Program Interface INitialize Opi opidrv #ORACLE Program Interface DRiVer (IGNORE)sou2o # Main Oracle executable entry pointmain # Standard executable entry pointstart # C program entry point (IGNORE)


Может ещё кто дополнит.
...
Рейтинг: 0 / 0
7 сообщений из 32, страница 2 из 2
Форумы / Oracle [игнор отключен] [закрыт для гостей] / Fixed SGA Variables
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]