Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the knowledge points related to oracle temp tablespace". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what are the knowledge points related to oracle temp tablespaces?"

1. Query space usage, useful views dba_temp_file, v$temp_extent_pool.

Select c.tablespace_name

To_char (c.bytes / 1024 / 1024 / 1024, '99999.99999') total_gb

To_char ((c.bytes-d.bytes_used) / 1024 / 1024 / 1024, '99999.999') free_gb

To_char (d.bytes_used / 1024 / 1024 / 1024, '99999.99999') use_gb

To_char (d.bytes_used * 100 / c.bytes, '99.99') | |'% 'use

From (select tablespace_name, sum (bytes) bytes

From dba_temp_files

GROUP by tablespace_name) c

(select tablespace_name, sum (bytes_cached) bytes_used

From v$temp_extent_pool

GROUP by tablespace_name) d

Where c.tablespace_name = d.tablespace_name

two。 Check which users are applying temp tablespaces, using views v$tempseg_usage, v$temp_space_header

Select a.username

A.sql_id

A.SEGTYPE

A.tablespace

B.BYTES_USED / 1024 / 1024 / 1024

B.BYTES_FREE / 1024 / 1024 / 1024

From V$TEMPSEG_USAGE a, V$TEMP_SPACE_HEADER b

Where a.TABLESPACE = b.tablespace_name

And a. Tablespaceful temps

3. Check which session is applicable to temp based on the sql_ id value found in the query.

At this point, I believe you have a deeper understanding of "what are the knowledge points related to oracle temp tablespaces?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.