guif Posted March 19, 2009 Share Posted March 19, 2009 hi! i would like to monitoring the size of tablaspaces in my oracle. I have the query to show this values but i don't know to show in my web. The query is: $query = "select fs.tablespace_name, (df.totalspace - fs.freespace),fs.freespace, df.totalspace, round(100 * (fs.freespace / df.totalspace)) from (select tablespace_name, round(sum(bytes) / 1048576) TotalSpace from dba_data_files group by tablespace_name) df, (select tablespace_name, round(sum(bytes) / 1048576) FreeSpace from dba_free_space group by tablespace_name) fs where df.tablespace_name = fs.tablespace_name"; I see the function "oci_connect" in php to establishes a connection to the Oracle server but my level of php is very low. Any body help me??? I would like to show in a different rows and columns my values for example: name_tamblespace | total_size | Used_% | free_size | free_size_% very thanks! Quote Link to comment https://forums.phpfreaks.com/topic/150112-monitor-of-tablespaces-in-php/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.