topic Oracle in Operating System - OpenVMS

Oracle

Mulder_1 — Fri, 06 Aug 2010 07:04:33 GMT

How do I determine which quota is exceeded ?

Oracle Rdb V7.2-350 Event Notification for Database
$1$DGA575:[PRL.PQL]JKHG.RDB;1
Process 206000D8 generating bugcheck dump file
PLTRDV1:[RDBBUGCHK]RDSBUGCHK.DMP;
Exception at 0000000000D3809C : RDMSHRP72\BLI$CALLG + 000000BC

%COSI-F-UNEXPERR, unexpected system error
-COSI-F-EXQUOTA, exceeded quota

Thanks

Re: Oracle

Richard J Maher — Fri, 06 Aug 2010 07:29:14 GMT

Reproducable at will? If so can you put one of those DCL process quota watchers on and see which one's growing/shrinking?

Do you have the source code? Program change? Rdb version (optimizer strategy) change? New program? Read-Only txn or Raed-Write? Selecting or Updating?

What do you have ENQLM and PQFLQUOTA set to?

If you go to www.jcc.com you can search the archives (or Rdb meta-link) for a link to Peter Jackson's bugcheck summarizer which can be useful if you have no luck tracking down the problem yourself and have to contact Oracle. May also be a more useful error "%" in the DMP file.

Cheers Richard Maher

Re: Oracle

Oswald Knoppers_1 — Fri, 06 Aug 2010 07:51:32 GMT

Process 206000D8 generating bugcheck dump file
PLTRDV1:[RDBBUGCHK]RDSBUGCHK.DMP;

You can edit this file, there should be info in there.

Oswald

Re: Oracle

Andy Bustamante — Fri, 06 Aug 2010 14:37:27 GMT

If you can recreate the error, bring up Availability Manager and monitor the process. http://h71000.www7.hp.com/openvms/products/availman/index.html?jumpid=/products/openvms/availabilitymanager

Re: Oracle

Guy Peleg — Sat, 07 Aug 2010 05:14:29 GMT

Assuming a recent OpenVMS version
you can use SDA to analyze the process
dump and look at the JIB to determine which
quota been exceeded.

$ analyze/crash process_dump.dmp

SDA> read sysdef
SDA> format JIB

Guy Peleg
Maklee Engineering
www.maklee.com