ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEDA79D2E0530100007F1FF2 DBA Username Y select du.username value, null description from dba_users du order by du.username US 49A8B1A8039408ACE0530100007FEB91 select &column2 100*x.bytes/x.total_bytes percentage, x.bytes/1000000 mb, x.total_bytes/1000000 total_mb &column3 from ( select distinct &column1 sum(ds.bytes) over (partition by &partition_by) bytes, sum(ds.bytes) over () total_bytes from dba_segments ds, (select di.owner, di.index_name, di.table_owner, di.table_name from dba_indexes di where '&show_table'='Y') di, ( select dl.segment_name, nvl(di.table_owner,dl.owner) table_owner, nvl(di.table_name,dl.table_name) table_name from dba_lobs dl, dba_secondary_objects dso, dba_indexes di where '&show_table'='Y' and dl.owner=dso.secondary_object_owner(+) and dl.table_name=dso.secondary_object_name(+) and dso.index_owner=di.owner(+) and dso.index_name=di.index_name(+) ) dl where 1=1 and case when ds.segment_type in ('INDEX','INDEX PARTITION','INDEX SUBPARTITION') then ds.owner end=di.owner(+) and case when ds.segment_type in ('INDEX','INDEX PARTITION','INDEX SUBPARTITION') then ds.segment_name end=di.index_name(+) and case when ds.segment_type in ('LOBSEGMENT','LOB PARTITION','LOB SUBPARTITION') then ds.segment_name end=dl.segment_name(+) ) x &dba_tables where 2=2 order by x.bytes desc Renamed &enable_ lexicals to &show_ Y #,##0.00 AR DBA Segments مقاطع قاعدة البيانات مثل الجداول والفهارس ومقاطع الفص حسب الحجم وملخص حجم قاعدة البيانات الإجمالي D DBA Segments Datenbanksegmente wie Tabellen, Indizes, Lob-Segmente nach Größe und Zusammenfassung der gesamten Datenbankgröße E DBA Segments Segmentos de la base de datos como tablas, índices, segmentos del lob por tamaño y resumen del tamaño total de la base de datos F DBA Segments Segments de base de données tels que les tableaux, les index, les segments de lobes par taille et le résumé de la taille totale de la base de données I DBA Segments Segmenti di database come tabelle, indici, segmenti di lob per dimensione e riepilogo della dimensione totale del database JA DBA Segments テーブル、インデックス、サイズ別のローブセグメントなどのデータベースセグメントと、データベースの合計サイズの概要 KO DBA Segments 테이블, 인덱스, 크기별 lob 세그먼트 및 총 데이터베이스 크기 요약과 같은 데이터베이스 세그먼트 PTB DBA Segments Segmentos do banco de dados, tais como tabelas, índices, segmentos de lóbulos por tamanho e resumo do tamanho total do banco de dados RU DBA Segments Сегменты базы данных, такие как таблицы, индексы, лобовые сегменты по размеру и общая сводка по размеру базы данных. S DBA Segments Databasesegment som tabeller, index, lob-segment efter storlek och sammanfattning av databasstorlek TR DBA Segments Tablolar, dizinler, boyuta göre lob segmentleri ve toplam veritabanı boyutu özeti gibi veritabanı segmentleri US DBA Segments Database segments such as tables, indexes, lob segments by size and total database size summary ZHS DBA Segments 数据库段，如表、索引、叶段，按大小和数据库总大小汇总。 Enginatics &column1 &column2 &column3 &dba_tables &partition_by &show_table 1=1 2=2 1 10 1=1 ds.segment_name like upper(:segment_name) LOV custom Y select ds.segment_name value, ds.segment_type||' - '||ds.owner description from dba_segments ds where :$flex$.Level_of_Detail='Segment Name' order by ds.segment_name F Nom du segment comme US Segment Name like 2 20 1=1 ds.segment_type=:segment_type LOV custom Y select x.* from ( select 'CACHE' value, null description from dual union all select 'CLUSTER' value, null description from dual union all select 'INDEX PARTITION' value, null description from dual union all select 'INDEX SUBPARTITION' value, null description from dual union all select 'INDEX' value, null description from dual union all select 'LOB PARTITION' value, null description from dual union all select 'LOB SUBPARTITION' value, null description from dual union all select 'LOBINDEX' value, null description from dual union all select 'LOBSEGMENT' value, null description from dual union all select 'NESTED TABLE' value, null description from dual union all select 'ROLLBACK' value, null description from dual union all select 'SPACE HEADER' value, null description from dual union all select 'TABLE PARTITION' value, null description from dual union all select 'TABLE SUBPARTITION' value, null description from dual union all select 'TABLE' value, null description from dual union all select 'TYPE2 UNDO' value, null description from dual ) x F Type de segment US Segment Type 3 30 1=1 :table_name=:table_name LOV custom Y Y select dt.table_name value, dt.owner||nvl2(dt.num_rows,' ('||dt.num_rows||')',null) description from dba_tables dt order by dt.table_name F Nom de la table US Table Name 4 40 1=1 ds.tablespace_name=:tablespace_name LOV custom Y select dt.tablespace_name value, dt.contents description from dba_tablespaces dt order by dt.tablespace_name F Nom du Tablespace US Tablespace Name 5 50 1=1 ds.owner=:owner LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username F Propriétaire US Owner 6 60 2=2 x.bytes/1000000>=:size_mb_from Number US Size bigger than x MB 7 70 &partition_by ds.tablespace_name,ds.owner,ds.segment_type,ds.segment_name LOV custom Y select 'Tablespace Name' value, '' description from dual union all select 'Owner' value, 'Schema name' description from dual union all select 'Segment Type' value, '' description from dual union all select 'Segment Name' value, '' description from dual Segment Name Segment Name Y F Groupe par US Group by 8 &partition_by ds.owner Owner F Groupe par US Group by 9 &partition_by ds.segment_type Segment Type F Groupe par US Group by 10 &partition_by ds.tablespace_name Tablespace Name F Groupe par US Group by 11 &column1 ds.owner, Owner F Groupe par US Group by 12 &column1 ds.tablespace_name, ds.owner, ds.segment_type, ds.segment_name, coalesce(case when ds.segment_type in ('TABLE','TABLE PARTITION','TABLE SUBPARTITION') then ds.owner end,di.table_owner,dl.table_owner) table_owner, coalesce(case when ds.segment_type in ('TABLE','TABLE PARTITION','TABLE SUBPARTITION') then ds.segment_name end,di.table_name,dl.table_name) table_name, Segment Name F Groupe par US Group by 13 &column1 ds.segment_type, Segment Type F Groupe par US Group by 14 &column1 ds.tablespace_name, Tablespace Name F Groupe par US Group by 15 &column2 x.owner, Owner F Groupe par US Group by 16 &column2 x.tablespace_name, x.owner, x.segment_type, x.segment_name, Segment Name F Groupe par US Group by 17 &column2 x.segment_type, Segment Type F Groupe par US Group by 18 &column2 x.tablespace_name, Tablespace Name F Groupe par US Group by 19 &column3 ,x.table_name, dt.num_rows, dt.last_analyzed Segment Name F Groupe par US Group by 20 &dba_tables ,dba_tables dt Segment Name US Group by 21 &show_table Y Segment Name F Groupe par US Group by 22 2=2 x.table_name=nvl(:table_name,x.table_name) and x.table_owner=dt.owner(+) and x.table_name=dt.table_name(+) Segment Name F Groupe par US Group by