tag:blogger.com,1999:blog-2140152386224658811.post7385713449513327907..comments2024-01-09T15:48:36.110-08:00Comments on Cloud Control 12c: Use EM12c to Get Database Storage InformationJavier Ruizhttp://www.blogger.com/profile/12820988076924632290noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-2140152386224658811.post-59648807847389111752017-01-03T05:42:49.448-08:002017-01-03T05:42:49.448-08:00Thank you Adrian for sharing happy new year!Thank you Adrian for sharing happy new year!Javier Ruizhttps://www.blogger.com/profile/12820988076924632290noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-11720665939028834752016-12-23T05:27:20.145-08:002016-12-23T05:27:20.145-08:00Javier this script has become very useful but I ha...Javier this script has become very useful but I have had to re-write several parts as they are a little wrong. I have had to create different cursor names in each procedure script as using the same cursor name causes problems and also your DBA_CURRENT_DB_STORAGE View is looking at the Historic table.Anonymoushttps://www.blogger.com/profile/11445759953951715774noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-81368573053645871362016-12-10T02:46:50.104-08:002016-12-10T02:46:50.104-08:00on DBA_CURRENT_DB_STORAGE_USAGE-
Used +Free shou...on DBA_CURRENT_DB_STORAGE_USAGE- <br />Used +Free shouuld match allocated space<br />4G+2G is not 5B on table .. you are rounding too hight k lawhttps://www.blogger.com/profile/08439846628798191508noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-1018127544839677512016-12-09T08:57:21.413-08:002016-12-09T08:57:21.413-08:00you can change the view to add property of target...you can change the view to add property of target like "Line of Business" to have some business meaning <br /><br /> select c.VALUE AS DB_NAME , d.property_value "Line of Business",to_char(calendar_month,'yyyy-mm-dd') as calendar_month,<br />allocated_space_gb as allocated_space_gb,<br />used_space_gb as used_space_gb,<br />allocated_free_space_gb as allocated_free_space_gb,<br />used_pct,<br />ceil(allocated_space_gb*0.30) as "backup_space_used_rman",ceil(used_space_gb*0.15) as"backup_space_used_export" from DBA_HISTORICAL_STORAGE_USAGE a,<br />(SELECT value,target_guid<br /> FROM MGMT$DB_INIT_PARAMS<br /> WHERE name = 'db_name') c, <br />(<br /> select p.property_value, t.target_guid<br /> from mgmt$target t,<br /> mgmt$target_properties p,<br /> mgmt$all_target_prop_defs d<br /> where t.target_guid=p.target_guid<br /> and p.property_name=d.property_name<br /> and d.property_display_name ="Line of Business"<br />) d <br />where a.target_guid = c.target_guid<br />and a.target_guid = d.target_guid<br />order by 1 asc,2 asc;<br />k lawhttps://www.blogger.com/profile/08439846628798191508noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-12336551408085036352016-10-31T05:38:32.637-07:002016-10-31T05:38:32.637-07:00Darwish you will need to check as metric current d...Darwish you will need to check as metric current does not have all the info we are looking for in this specific report.Javier Ruizhttps://www.blogger.com/profile/12820988076924632290noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-35260339879972962902016-10-27T01:26:48.334-07:002016-10-27T01:26:48.334-07:00This is pretty great!, I believe we can use MGMT$M...This is pretty great!, I believe we can use MGMT$METRIC_CURRENT as well , can't we ?Darwishhttps://www.blogger.com/profile/03605478068979197791noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-63268628350538362862016-09-19T23:16:38.592-07:002016-09-19T23:16:38.592-07:00I had to (as sys) add
grant exempt access policy t...I had to (as sys) add<br />grant exempt access policy to dba_repository;<br />to fetch rows from mgmt_targets with dba_repository userAnonymoushttps://www.blogger.com/profile/18263148006342303153noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-84412176622763050772016-03-22T21:28:56.648-07:002016-03-22T21:28:56.648-07:00I have the same question as with V-Cruisers. How t...I have the same question as with V-Cruisers. How to I run these reports on OEM?Bakerohttps://www.blogger.com/profile/12389345727275320888noreply@blogger.comtag:blogger.com,1999:blog-2140152386224658811.post-58870631162610724132016-01-20T18:02:11.115-08:002016-01-20T18:02:11.115-08:00How often do you set the procedures to run? also o...How often do you set the procedures to run? also on oem have you setup a Info publisher report with queries on views<br />V-Cruisershttps://www.blogger.com/profile/13585650592609593582noreply@blogger.com