Examples of common Oracle maintenance statements

Oracle maintenance commonly used statement instance Article as a friend interested in oracle, will certainly be interested in this article oracle maintenance commonly used statement examples. View the table space name and size:

Select t. tablespace_name, round (sum (bytes/(1024*1024), 0) ts_size from dba_tablespaces t, dba_data_files d where t. tablespace_name = d. tablespace_name group by t. tablespace_name;

 

View the name and size of the tablespace physical file:

Select tablespace_name, file_id, file_name, round (bytes/(1024*1024), 0) total_space from dba_data_files order by tablespace_name;

 

View the rollback segment name and size:

Select segment_name, tablespace_name, r. status, (initial_ext Ent/1024) InitialExtent, (next_extent/1024) NextExtent, max_extents, v. curext CurExtent From dba_rollback_segs r, v $ rollstat v Where r. segment_id = v. usn (+) order by segment_name;

 

The above article mainly introduces the common statements for oracle maintenance. This article illustrates multiple related statements. Of course, these statements are often used in the actual use of Oracle, if you are an Oracle enthusiast. The above Article will be meaningful to you.