|
|
|
Fixed SGA Variables
|
|||
|---|---|---|---|
|
#18+
RihardИзвестный сайт случайно не itpub? :) Неа, не угадал ;) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.09.2007, 10:59 |
|
||
|
Fixed SGA Variables
|
|||
|---|---|---|---|
|
#18+
Странно, вышеперечисленное гугль не находит Может, плохо ищу... ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.09.2007, 11:05 |
|
||
|
Fixed SGA Variables
|
|||
|---|---|---|---|
|
#18+
Сына, спасибо. + чутка к Вашему списку ФункцияРасшифровка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. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.09.2007, 11:16 |
|
||
|
Fixed SGA Variables
|
|||
|---|---|---|---|
|
#18+
Решил запостить здесь, хорошие темы не должны умирать :) по следам топиков "как же мне инвалидировать конкретный курсор?" Код: plaintext 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. -- в получившемся трейсе ищу такое: 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. Код: plaintext 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. пс. я долго пытался сделать все по-правильному, через 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. кстати, значения битов курсора, если кому интересно: Код: 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. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 30.11.2007, 00:15 |
|
||
|
Fixed SGA Variables
|
|||
|---|---|---|---|
|
#18+
Еще немного ядерных функций в общую копилку. Функция Описание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 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.03.2008, 10:19 |
|
||
|
Fixed SGA Variables
|
|||
|---|---|---|---|
|
#18+
Собрал в один список. Функция Описание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) Может ещё кто дополнит. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.01.2018, 09:07 |
|
||
|
|

start [/forum/topic.php?fid=52&msg=34820774&tid=1884627]: |
0ms |
get settings: |
8ms |
get forum list: |
17ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
144ms |
get topic data: |
9ms |
get forum data: |
2ms |
get page messages: |
54ms |
get tp. blocked users: |
2ms |
| others: | 208ms |
| total: | 448ms |

| 0 / 0 |
