Tablespaces - Revision history

Stuart: /* Segment Growth Report 3 */

2018-10-23T12:26:50Z

‎Segment Growth Report 3

2018-10-23T12:26:33Z

‎Tablespace Growth Report 2

2018-10-23T12:25:36Z

‎Report of available free space in tablespaces

2018-10-23T12:25:07Z

‎Tablespace Growth Report 2

2018-10-23T12:24:56Z

‎Segment Growth Report

2018-09-10T11:54:16Z

‎Reduce (or recreate) size of temporary tablespace

2018-09-10T11:54:00Z

‎Reduce (or recreate) size of temporary tablespace

2018-09-10T11:45:33Z

‎Reduce (or recreate) size of temporary tablespace

2018-09-10T11:44:59Z

‎Reduce (or recreate) size of temporary tablespace

2018-08-21T16:59:32Z

‎Which sessions are using TEMP tablespace?

@@ Line 185: / Line 185: @@
 </pre>
-===Segment Growth Report 3===
+===Segment Growth Report===
 <pre>
 column "Percent of Total Disk Usage" justify right format 999.99

@@ Line 63: / Line 63: @@
 order by 1;
 </pre>
 ===Segment Growth Report 3===
 <pre>

@@ Line 154: / Line 154: @@
 and    t1.naam = t3.naam
 order  by vullingsgraad desc
+/
 </pre>

@@ Line 63: / Line 63: @@
 order by 1;
 </pre>
 ===What is the size of the segments in the SYSAUX tablespace?===
 <pre>

@@ Line 88: / Line 88: @@
 from   v$sysaux_occupants
 order  by 2
+/
 </pre>

@@ Line 350: / Line 350: @@
 Check for any sessions still holding on to the TEMP tablespace
 <pre>
-set lines 1000 pages 0 neap none
+set lines 1000 pages 0 newpa none
 col stmt for a300
 select 'alter system disconnect session '''||s.killer||''' immediate;' stmt

@@ Line 350: / Line 350: @@
 Check for any sessions still holding on to the TEMP tablespace
 <pre>
-select vsu.username
+select 'alter system disconnect session '''||s.killer||''' immediate;' from
-,      vsu.session_num
-,      vsu.session_addr
+select s.sid||','||s.serial#                  killer
-,      vs.sid
+,      s.status                               status
-from   v$sort_usage vsu
+from   v$sort_usage    t
-,      v$session    vs
+,      v$session       s
 where  1=1
-and    vsu.session_num = vs.serial#
+and    t.session_addr = s.saddr
+/
 </pre>
 Drop the original temp tablespace
@@ Line 383: / Line 385: @@
 drop tablespace tempx including contents and datafiles;
 </pre>
 ===Recreate the temporary tablespace when it belongs to a tablespace group===
 Verify the tablespace groups and their members

@@ Line 283: / Line 283: @@
 set lines 1000
 col killer     for a15
 col username   for a15
 col osuser     for a15
@@ Line 292: / Line 293: @@
 col statements for 999
 select s.sid||','||s.serial#                  killer
 ,      s.username                             username
 ,      s.osuser                               osuser
 ,      p.spid                                 spid
 ,      s.module                               module
 ,      p.program                              program
@@ Line 309: / Line 312: @@
 and    t.tablespace   = tbs.tablespace_name
 group  by s.sid
 ,      s.serial#
 ,      s.username
 ,      s.osuser
 ,      p.spid
 ,      s.module
 ,      p.program