v$session_longops

Always wondered what made it in here:

http://www.gplivna.eu/papers/v$session_longops.htm

Using Data Pump

Used data pump for the first time today. Did the following:

grant read,write on directory data_pump_dir to rdoggart;

Then to export:

expdp fline/lagan schemas=FLINE directory=data_pump_dir dumpfile=fline.dmp

logfile=fline.log exclude=table:\”in (‘LGNCC_DOCUMENTSTORE’,’LGNCC_MESSAGE’)\”

Then to move to new schema:

impdp fline/lagan remap_schema=FLINE:FLINE_EFORM directory=data_pump_dir
dumpfile=fline.dmp logfile=fline_eform.log

Clear alerts in OEM 10g

I had some alerts that would not clear in OEM and found some code that allows the alerts to be cleared via the database. Ran the following under the sysman schema:

begin
for i in (SELECT target_guid, metric_guid, key_value from MGMT_CURRENT_SEVERITY)
loop
EM_SEVERITY.delete_current_severity(i.TARGET_GUID, i.METRIC_GUID, i.KEY_VALUE);
end loop;
commit;
end;