ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 5433918F81A92DB4E0530100007F0B90Y with gb as ( select /*+ materialize*/ distinct gb.inst_id, gb.objd, count(*) over (partition by gb.inst_id, gb.objd, gb.status, gb.status_code, gb.dirty, gb.temp) blocks, count(*) over (partition by gb.inst_id, gb.objd) object_blocks, count(*) over (partition by gb.inst_id) total_blocks, gb.status, gb.status_code, gb.dirty, gb.temp from ( select gb.inst_id, gb.status status_code, decode(gb.status, 'free','Not currently in use', 'xcur','Exclusive', 'scur','Shared current', 'cr','Consistent read', 'read','Being read from disk', 'mrec','In media recovery mode', 'irec','In instance recovery mode') status, decode(gb.dirty,'Y','Y') dirty, decode(gb.temp,'Y','Y') temp, decode(gb.status,'free',null,gb.objd) objd from gv$bh gb ) gb ), do as ( select /*+ materialize*/ distinct do.data_object_id, min(do.owner) keep (dense_rank first order by do.object_id) over (partition by do.data_object_id) owner, min(do.object_type) keep (dense_rank first order by do.object_id) over (partition by do.data_object_id) object_type, listagg(do.object_name,', ') within group (order by do.object_name) over (partition by do.data_object_id) object_name from dba_objects do where do.data_object_id>0 ), ds as ( select /*+ materialize*/ ds.owner, ds.segment_type, ds.segment_name, sum(ds.blocks) blocks from dba_segments ds group by ds.owner, ds.segment_type, ds.segment_name ) select x.inst_id, x.blocks/x.total_blocks*100 percentage, x.owner, x.object_type, x.object_name, x.blocks*vp.value/1000000 buffer_size, x.blocks/ds.blocks*100 object_percentage &columns2 from ( select distinct gb.inst_id, do.owner, do.object_type, nvl(do.object_name,'------free------') object_name, sum(gb.blocks) over (partition by gb.inst_id, do.owner, do.object_type, do.object_name &partition_by) blocks, sum(gb.object_blocks) over (partition by gb.inst_id, do.owner, do.object_type, do.object_name) object_blocks, gb.total_blocks &columns1 from gb, do where gb.objd=do.data_object_id(+) ) x, ds, (select vp.value from v$parameter vp where vp.name like 'db_block_size') vp where x.owner=ds.owner(+) and x.object_type=ds.segment_type(+) and x.object_name=ds.segment_name(+) order by x.inst_id, x.object_blocks desc, x.blocks desc #,##0.00 AR DBA SGA Buffer Cache Object Usage استخدام مساحة ذاكرة التخزين المؤقت SGA بواسطة أسماء الكائنات (بالميغابايت). تُظهر "النسبة المئوية للكائن" مقدار كائن معين واحد يتم تخزينه حاليًا في ذاكرة التخزين المؤقت. 100٪ يعني أن الكائن موجود بالكامل في ذاكرة التخزين المؤقت. يتم سرد استخدام ذاكرة SGA الحالي أيضًا في طرق العرض: حدد * من v $ sga حدد * من v $ sgainfo حدد * من v $ sga_dynamic_components يقدم Arup Nanda شرحًا جيدًا لكيفية عمل ذاكرة التخزين المؤقت: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html D DBA SGA Buffer Cache Object Usage SGA-Puffer-Cache-Speicherplatznutzung nach Objektnamen (in MB). Object Percentage" zeigt an, wie viel von einem bestimmten Objekt derzeit im Puffer-Cache gespeichert ist. 100 % bedeutet, dass sich das Objekt vollständig im Puffercache befindet. Der aktuelle SGA-Speicherverbrauch wird auch in Ansichten aufgelistet: select * from v$sga select * from v$sgainfo select * from v$sga_dynamic_components Arup Nanda gibt eine gute Erklärung, wie der Puffercache funktioniert: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html E DBA SGA Buffer Cache Object Usage Uso del espacio de la caché del buffer SGA por nombres de objetos (en MB). El "porcentaje de objetos" muestra la cantidad de un objeto concreto que está almacenado actualmente en la caché del búfer. El 100% significa que el objeto está completamente en la caché del búfer. El uso actual de la memoria SGA también se muestra en las vistas: select * from v$sga select * from v$sgainfo select * from v$sga_dynamic_components Arup Nanda da una buena explicación sobre el funcionamiento de la caché del buffer: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html F DBA SGA Buffer Cache Object Usage Utilisation de l'espace mémoire tampon de la SGA par les noms d'objets (en Mo). Le "pourcentage d'objets" indique la quantité d'un objet particulier qui est actuellement stockée dans le cache tampon. 100% signifie que l'objet est entièrement dans le cache tampon. L'utilisation actuelle de la mémoire de la SGA est également indiquée dans les vues : sélectionnez * dans v$sga sélectionnez * dans v$sgainfo sélectionner * dans v$sga_dynamic_components Arup Nanda donne une bonne explication sur le fonctionnement du cache tampon : http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html I DBA SGA Buffer Cache Object Usage Utilizzo dello spazio della cache del buffer SGA per nomi di oggetti (in MB). La 'Percentuale dell'oggetto' mostra quanto di un particolare oggetto è attualmente memorizzato nella cache del buffer. 100% significa che l'oggetto è completamente nella cache del buffer. L'uso corrente della memoria SGA è anche elencato nelle viste: selezionare * da v$sga selezionare * da v$sgainfo selezionare * da v$sga_dynamic_components Arup Nanda dà una buona spiegazione su come funziona la cache del buffer: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html JA DBA SGA Buffer Cache Object Usage オブジェクト名別の SGA バッファキャッシュスペース使用量 (MB)。 オブジェクトのパーセンテージ」は、ある特定のオブジェクトが現在バッファキャッシュにどれだけ保存されているかを示しています。 100% は、オブジェクトが完全にバッファキャッシュに保存されていることを意味します。 現在のSGAメモリ使用量もビューに表示されます。 select * from v$sga select * from v$sgainfo select * from v$sga_dynamic_components Arup Nandaは、バッファキャッシュがどのように動作するかについて、良い説明をしています。 http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html KO DBA SGA Buffer Cache Object Usage 개체 이름 별 SGA 버퍼 캐시 공간 사용량 (MB)입니다. 'Object Percentage'는 현재 버퍼 캐시에 저장된 특정 개체의 양을 보여줍니다. 100 %는 개체가 완전히 버퍼 캐시에 있음을 의미합니다. 현재 SGA 메모리 사용량도보기에 나열됩니다. v $ sga에서 * 선택 v $ sgainfo에서 * 선택 v $ sga_dynamic_components에서 * 선택 Arup Nanda는 버퍼 캐시가 어떻게 작동하는지에 대한 좋은 설명을 제공합니다. http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html PTB DBA SGA Buffer Cache Object Usage Utilização do espaço de cache SGA por nomes de objetos (em MB). A 'Porcentagem de objeto' mostra quanto de um objeto em particular está atualmente armazenado no cache de memória intermediária. 100% significa que o objeto está completamente no cache do buffer. O uso atual da memória SGA também está listado nas vistas: selecione * da v$sga selecione * da v$sgainfo selecione * de v$sga_componentes_dinâmicos Arup Nanda dá uma boa explicação sobre como funciona o cache-tampão: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html RU DBA SGA Buffer Cache Object Usage Использование кэш-памяти SGA буфера по именам объектов (в мегабайтах). Процент объектов" показывает, сколько одного конкретного объекта в настоящее время хранится в буферном кэше. 100% означает, что объект полностью находится в буферном кэше. Текущее использование SGA-памяти также указано в видах: выбрать * из v$sga выбрать * из v$sgainfo выбрать * из v$sga_dynamic_components Аруп Нанда дает хорошее объяснение того, как работает буферный кэш: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html S DBA SGA Buffer Cache Object Usage SGA-buffertcache-utrymmesanvändning efter objektnamn (i MB). 'Objektprocent' visar hur mycket av ett visst objekt som för närvarande lagras i buffertcachen. 100% betyder att objektet är helt i buffertcache. Nuvarande SGA-minnesanvändning listas också i vyer: välj * från v $ sga välj * från v $ sgainfo välj * från v $ sga_dynamic_components Arup Nanda ger en bra förklaring till hur buffertcachen fungerar: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html TR DBA SGA Buffer Cache Object Usage Nesne adlarına göre SGA arabellek önbellek alanı kullanımı (MB cinsinden). 'Nesne Yüzdesi' belirli bir nesnenin ne kadarının o anda arabellek önbelleğinde depolandığını gösterir. % 100, nesnenin tamamen arabellek önbelleğinde olduğu anlamına gelir. Mevcut SGA bellek kullanımı da görünümlerde listelenmiştir: v $ sga'dan * seçin v $ sgainfo'dan * seçin v $ sga_dynamic_components'tan * seçin Arup Nanda, arabellek önbelleğinin nasıl çalıştığı konusunda iyi bir açıklama yapıyor: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html US DBA SGA Buffer Cache Object Usage SGA buffer cache space usage by object names (in MB). 'Object Percentage' shows how much of one particular object is currently stored in the buffer cache. 100% means that the object is completely in the buffer cache. Current SGA memory usage is also listed in views: select * from v$sga select * from v$sgainfo select * from v$sga_dynamic_components Arup Nanda gives a good explanation on how the buffer cache works: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html ZHS DBA SGA Buffer Cache Object Usage 按对象名称列出的SGA缓冲区缓存空间使用情况（单位：MB）。 '对象百分比'显示了某一特定对象当前存储在缓冲区缓存中的数量。 100%表示该对象完全在缓冲区缓存中。 当前的SGA内存使用情况也会在视图中列出。 从v$sga中选择*。 从v$sgainfo中选择*。 从v$sga_dynamic_components中选择*。 Arup Nanda对缓冲区缓存的工作原理做了很好的解释。 http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html Enginatics &columns1 &columns2 &partition_by 1 10 &columns1 ,gb.status, gb.status_code, gb.dirty, gb.temp LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher l'état du bloc US Show Block Status 2 &columns2 ,x.status, x.status_code, x.dirty, x.temp F Afficher l'état du bloc US Show Block Status 3 &partition_by , gb.status, gb.status_code, gb.dirty, gb.temp F Afficher l'état du bloc US Show Block Status