Segment

How to Resolve ORA-00600: [kdu_array_buf non-zero delta]

by Ed Chen
August 14, 2023August 29, 2023

kdu_array_buf non-zero delta An user reported ORA-00600 when updating a table. For example: SQL> update pay_hist set is_paid = 'Y' where ow is null; ...… Read More »

How to List Tables in Datafile

by Ed Chen
June 6, 2022March 31, 2023

Normally, we would like to list tables in a tablespace for better managing segment allocation. In fact, a tablespace is just a logical collection of… Read More »

How to List Tables in Tablespace

by Ed Chen
June 3, 2022March 31, 2023

We have talked about the differences between schema objects and segments in another post. From tablespace's point of view, program units and informative schema objects… Read More »

Segments vs Schema Objects

by Ed Chen
July 20, 2019December 10, 2022

Segments vs Schema Objects Not only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions… Read More »

How to Check Oracle Segment Size

by Ed Chen
January 14, 2019December 10, 2022

Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within… Read More »

JavaScript is not enabled. Please enable it and reload the page.