Revision [3613]
Last edited on 2010-01-11 00:08:03 by WikiAdminAdditions:
=== Create tablespace ===
create tablespace xxx_data logging
datafile '+DATA/xxx/xxx01.dbf' size 500m autoextend on next 50m maxsize 5000m extent management local;
create user xxxdba identified by yyy
default tablespace coaction quota unlimited on xxx_data;
grant CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE ROLE, CREATE PROCEDURE,
CREATE ANY SYNONYM, CREATE PUBLIC SYNONYM, CREATE ANY SEQUENCE to xxxdba;
create tablespace xxx_data logging
datafile '+DATA/xxx/xxx01.dbf' size 500m autoextend on next 50m maxsize 5000m extent management local;
create user xxxdba identified by yyy
default tablespace coaction quota unlimited on xxx_data;
grant CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE ROLE, CREATE PROCEDURE,
CREATE ANY SYNONYM, CREATE PUBLIC SYNONYM, CREATE ANY SEQUENCE to xxxdba;
Revision [3476]
Edited on 2009-08-08 19:59:56 by WikiAdminAdditions:
set linesize 200
Deletions:
Revision [989]
Edited on 2007-10-01 18:33:48 by WikiAdminAdditions:
SELECT tablespace_name, SUM(bytes_used)/1048576 UsedMB, SUM(bytes_free)/1048576 as TotalMB
Deletions:
Revision [988]
Edited on 2007-10-01 18:33:13 by WikiAdminAdditions:
SELECT tablespace_name, SUM(bytes_used)/1048576 UserMB, SUM(bytes_free)/1048576 as TotalMB
Deletions:
Revision [976]
Edited on 2007-09-24 02:17:48 by WikiAdminDeletions:
Revision [975]
Edited on 2007-09-24 02:12:01 by WikiAdminAdditions:
===List all tablespace usage===
===Listing temp tablespace usage===
SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_header
GROUP BY tablespace_name;
===Listing temp tablespace usage===
SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_header
GROUP BY tablespace_name;
Deletions:
Revision [809]
Edited on 2007-07-25 20:53:53 by WikiAdminAdditions:
column file_name format A50;
column tablespace_name format A13;
column tablespace_name format A13;
Revision [808]
Edited on 2007-07-25 20:53:09 by WikiAdminAdditions:
WHERE a.file_id=b.file_id
GROUP BY b.tablespace_name,b.file_name,b.file_id,b.bytes
ORDER BY b.tablespace_name;
GROUP BY b.tablespace_name,b.file_name,b.file_id,b.bytes
ORDER BY b.tablespace_name;
Deletions:
Revision [807]
Edited on 2007-07-25 20:52:36 by WikiAdminAdditions:
===List all tablespace usage
set linsize 132
set pagesize 200
SELECT b.file_id, b.tablespace_name, b.file_name, b.bytes/1048575 AS AllocatedMb,
(b.bytes-sum(nvl(a.bytes,0)))/1048576 AS UsedMb,
sum(nvl(a.bytes,0))/1048576 AS FreeMb,
sum(nvl(a.bytes,0))/(b.bytes)*100 AS FreePct
FROM dba_free_space a,dba_data_files b
WHERE a.file_id=b.file_id GROUP BY b.tablespace_name,b.file_name,b.file_id,b.bytes;
set linsize 132
set pagesize 200
SELECT b.file_id, b.tablespace_name, b.file_name, b.bytes/1048575 AS AllocatedMb,
(b.bytes-sum(nvl(a.bytes,0)))/1048576 AS UsedMb,
sum(nvl(a.bytes,0))/1048576 AS FreeMb,
sum(nvl(a.bytes,0))/(b.bytes)*100 AS FreePct
FROM dba_free_space a,dba_data_files b
WHERE a.file_id=b.file_id GROUP BY b.tablespace_name,b.file_name,b.file_id,b.bytes;
Revision [200]
Edited on 2007-04-16 07:26:18 by WikiAdminAdditions:
{{parent page="Oracle"}}
%%(sql)
%%(sql)
%%(sql)
%%(sql)
