query for checking space tablespace and used tablepace in oracle database


select a.tablespace_name as tablespace_name ,a.total_mb,b.used_mb ,a.total_mb-b.used_mb  as free_space from
(select d.tablespace_name, sum(d.bytes/1024/1024) as total_mb from dba_data_files d
group by d.tablespace_name) a,
( select s.tablespace_name,sum(s.bytes/1024/1024) as used_mb from dba_segments s
group by tablespace_name)  b  where a.tablespace_name=b.tablespace_name order by tablespace_name



select a.tablespace_name as tablespace_name ,a.total_mb,b.used_mb ,a.total_mb-b.used_mb as  free ,free_space  as free_space from
(select tablespace_name, sum(bytes/1024/1024) as total_mb from dba_data_files
group by tablespace_name) a,
( select tablespace_name,sum(bytes/1024/1024) as used_mb from dba_segments
group by tablespace_name)  b,
(select tablespace_name,sum(bytes/1024/1024) as free_space from dba_free_space
group by tablespace_name)  c
where a.tablespace_name=b.tablespace_name and b.tablespace_name=c.tablespace_name
order by tablespace_name

Comments

Post a Comment

Popular posts from this blog

Oracle Management Server _ EMGC_OMS1 _1 in windows

12c: EM: OMS Server Fails - error nm home replaced Environment: Oracle Enterprise Manager 12c, Windows 2008 R2 Error: Below error occured on one of the client environment C:\Windows\system32> %OMS_HOME%/bin/emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Windows service OracleManagementServer_EMGC_OMS1_1 failed to be started Oracle Management Server is Down Please check E://gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details Log file showed below 2013-12-22 10:30:54,300 [main] INFO wls.OMSController main.219 - Executing emctl command : start 2013-12-22 10:30:58,536 [main] INFO commands.BaseCommand getEnvProps.456 - nm home replaced : E:/gc_inst/NodeManager/emnodemanager 2013-12-22 10:30:58,581 [main] INFO commands.StartCommand startOMS.371 - net start return code is 2 2013-12-22 10:30:58,582 [main] ERROR commands.BaseCommand logAndPrint.620 - Windows service OracleManagementServe...
Read more

ORA-00600: internal error code, arguments: [qctVCO:csform] ORA-64131 ORA-01403 Errors After Upgrade From 11.2.0.1 To 11.2.0.3 (Doc ID 1394206.1) when database is running in the Chinese language

Solution APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 or 11.2.0.4 [Release 11.2] Information in this document applies to any platform. ***Checked for relevance on 24-Jul-2013*** SYMPTOMS After upgrading the database from 11.2.0.1.0 to 11.2.0.2 or 11.2.0.3.0, XDB upgraded successfully but now there are XDB errors of: Tue Jan 10 13:22:01 2012 XDB installed. XDB initialized. .. ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [2], [213], [], [], [], [] ORA-64131: XMLIndex Metadata: failure during the looking up of the dictionary ORA-01403: no data found And the following object(s) are invalid in the database: SYS ALL_XSC_SECURITY_CLASS_DEP VIEW SYS ALL_XSC_SECURITY_CLASS VIEW SYS ALL_XSC_PRIVILEGE VIEW SYS ALL_XSC_AGGREGATE_PRIVILEGE VIEW SYS ALL_XSC_SECURITY_CLASS_STATUS VIEW Attempts to recompile these objects also fail with the above errors. CAUSE T...
Read more

EXPDP – ORA-39006,ORA-39213 Metadata processing is not available

==> Environmental Details : O/S :Windows Server 2008 64 bits Oracle Version : 11.2.0.1 ==> Error Details : While Taking full database export using “EXPDP” i was getting below mentioned error : ############################################### C:\> expdp directory=pump_dir=expdp_test.dmp logfile=expdp_test.log full=y Export: Release 11.2.0.1.0 – Production on Thu Feb 27 10:48:09 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username : system/oracle123 as sysdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available ############################################### Soultion login  to sys C:\sqlplus sys as sysdba SQL> execute dbms_metadata_util.load_stylesheets ...
Read more