Good Morning,Using the alert notification, go to the incident manager, and
extend the incident for the tablespace alert so you can view the tabs. The
incident should should you in the update what happened and when, then you can
drill in to see the exact time the tablespace alerted and gather more
information.
Hope this helps!
| |
| | | Kellyn Pot'Vin-Gorman about.me/dbakevlar |
| |
~Tombez sept fois, se relever huit!
On Tuesday, June 2, 2015 8:04 AM, Rich Jesse
<rjoralist3@xxxxxxxxxxxxxxxxxxxxx> wrote:
Hey all,
EM 12.1.0.3 popped a "Tablespace MYTBS is 97 percent full" incident last
week, but I haven't been able to determine why or how it thinks the
tablespace is at 97% capacity.
The target is 11.2.0.3 on AIX. There are no rows in DBA_OUTSTANDING_ALERTS
and no tablespace alerts in DBA_ALERT_HISTORY in the target, so I'm guessing
this is an EM12c calculation rather than a DB one.
Working from the storage calc listed on MOS 1590051.1, I'm using this query
to show "percent full":
SELECT
SUM(s.used_gb)/SUM(f.total_gb)*100
FROM dba_tablespaces t,
(
SELECT tablespace_name,
SUM(NVL(bytes,0))/(1024*1024*1024) total_gb
FROM dba_data_files
WHERE TABLESPACE_NAME = 'MYTBS'
GROUP BY tablespace_name) f,
(
SELECT tablespace_name,
SUM(NVL(bytes,0))/(1024*1024*1024) used_gb
FROM dba_segments
WHERE TABLESPACE_NAME = 'MYTBS'
GROUP BY tablespace_name) s
WHERE t.tablespace_name = f.tablespace_name (+)
AND t.tablespace_name = s.tablespace_name (+);
It returns a value of about 83.77, which is corroborated by Toad's Schema
Browser.
There's much more data for this, but in the interest of brevity, I'll start
with this.
Thoughts anyone?
Rich
--
//www.freelists.org/webpage/oracle-l
