| Claiming information about the DB with SQL [message #628365] |
Mon, 24 November 2014 09:15  |
 |
chricken
Messages: 13
Registered: November 2014
|
Junior Member |
|
|
Hi,
I am about to write a tool to monitor some vital information of my oracle-DB in a very basic manner.
Therefore I am trying to find a way to read the needed information via sql.
I already found some interesting information, but not all.
So, I hope one of you knows, how I can get the following information with SQL - if possible at all.
Size of the fast recovery area
Usable space in fast recovery area
Regards
Christian
|
|
|
|
|
|
|
|
| Re: Claiming information about the DB with SQL [message #628384 is a reply to message #628365] |
Mon, 24 November 2014 13:09  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
Try these:
COL Name FOR A20
COL File_Type FOR A32
SELECT Name
, ROUND ( Space_Limit / 1024 / 1024, 1 ) Mb_Limit
, ROUND ( Space_Used / 1024 / 1024, 1 ) Mb_Used
, ROUND ( Space_Reclaimable / 1024 / 1024, 1 ) Mb_Reclaimable
, Number_Of_Files
FROM V$recovery_File_Dest;
SELECT * FROM V$flash_Recovery_Area_Usage;
[Updated on: Mon, 24 November 2014 13:17] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: Claiming information about the DB with SQL [message #628435 is a reply to message #628434] |
Tue, 25 November 2014 04:39 |
|
chricken
Messages: 13
Registered: November 2014
|
Junior Member |
|
|
Hi gazzag,
we are using cloud control and I like it.
But I am building a central overview, that may show me some information with a single look.
I already have information about our mailqueue, errormails and a bit more.
Now there shall be some vital data about oracle on the same page.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
