No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

TEMP Tablespace queries have given different values
Next thread: DBMS_SCHEDULER.CREATE_CREDENTIAL
Prev thread: Total Count with 2 tables

Message Score Author Date
Hi Expert, I need your solution that how I will...... Abdullah A Dec 07, 2017, 08:38
Ni feedback no rate no help http://www.dba-vi...... Michel Cadot Dec 07, 2017, 08:44
OK Michel, I have reply even given rate to you....... Abdullah A Dec 07, 2017, 09:47
There is no need to try to get this information ...... Michel Cadot Dec 07, 2017, 09:58
Thanks Michel, One question If I executed this ...... Abdullah A Dec 07, 2017, 13:45
To say in other words what I said: free space is...... Michel Cadot Dec 07, 2017, 14:15
Thanks Michel, I want to find Used & Free space...... Abdullah A Dec 10, 2017, 09:55
Why? What do you want to do with these figures? ...... Michel Cadot Dec 10, 2017, 10:15
Dear Expert, When I executed the below queries ...... Abdullah A Dec 12, 2017, 06:52

Follow up by mail Click here


Subject: TEMP Tablespace queries have given different values
Author: Abdullah A, Saudi Arabia
Date: Dec 07, 2017, 08:38, 7 days ago
Os info: Solaris Sparc 11.2
Oracle info: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
Message: Hi Expert,

I need your solution that how I will get the result of TEMP Tablespace Total Space, Free Space and Used Space ..

When I executed the below queries then I got different result ..

SQL> select TABLESPACE_NAME, round(BYTES_USED/1024/1024/1024, 2) Used_in_GB, round(BYTES_FREE/1024/1024/1024, 2) Free_in_GB from V$TEMP_SPACE_HEADER;

Tablespace
Name USED_IN_GB FREE_IN_GB
------------------------------ ---------- ----------
TEMP 31.97 .03

SQL> select TABLESPACE_NAME, round(TABLESPACE_SIZE/1024/1024/1024, 2) TSize_in_GB, round(ALLOCATED_SPACE/1024/1024/1024, 2) Allo_in_GB, round(FREE_SPACE/1024/1024/1024, 2) Free_in_GB from DBA_TEMP_FREE_SPACE;

Tablespace
Name TSIZE_IN_GB ALLO_IN_GB FREE_IN_GB
------------------------------ ----------- ---------- ----------
TEMP 32 31.97 31.93

please suggest your valuable solution.

Thank you very much in advance.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Michel Cadot, France
Date: Dec 07, 2017, 08:44, 7 days ago
Message:
Ni feedback no rate no help

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=87925

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Abdullah A, Saudi Arabia
Date: Dec 07, 2017, 09:47, 7 days ago
Message: OK Michel,

I have reply even given rate to you.

So please reply me.

Thanks in Advance.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Michel Cadot, France
Date: Dec 07, 2017, 09:58, 7 days ago
Message:
There is no need to try to get this information for a temporary tablespace.
A temporary tablespace is, by design, full as soon as the database is working and you need some temporary space.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Abdullah A, Saudi Arabia
Date: Dec 07, 2017, 13:45, 7 days ago
Message: Thanks Michel,

One question If I executed this view i.e: V$TEMP_SPACE_HEADER then I got TEMP space 98% USED/Full.

But when I run through DBA_TEMP_FREE_SPACE then I got space 99% FREE.

I searched the documents the I got dynamic view DBA_TEMP_FREE_SPACE introduced in 11gR2.

SO question is that which query is best to find out the free and used space of TEMP Tablespace ?

Thanks in Advance
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Michel Cadot, France
Date: Dec 07, 2017, 14:15, 7 days ago
Message:
To say in other words what I said: free space is meaningless for a temporary tablespace.

What do you search with this figure?

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Abdullah A, Saudi Arabia
Date: Dec 10, 2017, 09:55, 4 days ago
Message: Thanks Michel,

I want to find Used & Free space in Temporary Tablespace

Thanks for in Advance.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Michel Cadot, France
Date: Dec 10, 2017, 10:15, 4 days ago
Message:
Why? What do you want to do with these figures? What do you expect from us?


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: TEMP Tablespace queries have given different values
Author: Abdullah A, Saudi Arabia
Date: Dec 12, 2017, 06:52, 2 days ago
Message: Dear Expert,

When I executed the below queries Why I got different result ? One has given .03 GB free and other has given 31.93 free.

SQL> select TABLESPACE_NAME, round(BYTES_USED/1024/1024/1024, 2) Used_in_GB, round(BYTES_FREE/1024/1024/1024, 2) Free_in_GB from V$TEMP_SPACE_HEADER;

Tablespace
Name USED_IN_GB FREE_IN_GB
------------------------------ ---------- ----------
TEMP 31.97 .03

SQL> select TABLESPACE_NAME, round(TABLESPACE_SIZE/1024/1024/1024, 2) TSize_in_GB, round(ALLOCATED_SPACE/1024/1024/1024, 2) Allo_in_GB, round(FREE_SPACE/1024/1024/1024, 2) Free_in_GB from DBA_TEMP_FREE_SPACE;

Tablespace
Name TSIZE_IN_GB ALLO_IN_GB FREE_IN_GB
------------------------------ ----------- ---------- ----------
TEMP 32 31.97 31.93

If I want to query free & Used value of TEMP Tablespace, Which query I will execute in oracle 12c.

Thank you very much


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here