Advanced Search

Return to Snippet

Revision: 64199
at July 12, 2013 23:39 by ceduard0
Initial Code 
select a.TABLESPACE_NAME,a.BYTES/1024/1024 "Mb free",b.BYTES/1024/1024 "Mb used",
       (a.BYTES/1024/1024)+(b.BYTES/1024/1024) "Mb Total"
   from SM$TS_FREE a,SM$TS_USED b
  where a.TABLESPACE_NAME = b.TABLESPACE_NAME;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This SQL statement list tablaspace information from an Oracle database.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Show the state of the tablespace from Oracle Database

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL