Home » Server Options » RAC & Failsafe » PX Deq Credit: send blkd (10g, 10.2.0.5, Linux)
PX Deq Credit: send blkd [message #589682] Wed, 10 July 2013 00:21 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Below query doesn't have any parallel hints. Though, it is without where clause, so full scan is must but why "PX Deq Credit: send blkd" occurred?

SELECT ROWID, REGION, STATE, CITY, DEALERNAME, DEALERCODE, DEALERID, BUSINESSUNIT, GARDEALERID, MASTERCLAIMNUMBER, CLAIMNUMBER, COMPANY, POLICYNUMBER, STARTDATE, ENDDATE, POLICYISSUEDEALERNAME, ISSUEDEALERCODE, CUSTOMERNAME, CUSTOMERADDRESS, ACCIDENTDATE, ACCIDENTTIME, INTIMATIONDATE, INTIMATIONTIME, REGISTRATIONDATE, REGISTRATIONTIME, DRIVERNAME, ACCIDENT_DESCRIPTION, INTIMATION_DELAY_REASON, INTIMATORNAME, INTIMATORMOBILENO, CLAIM_INTIMATED_BY, TOWING_ASSISTANCE, ACCIDENTPLACE, ACCIDENTLOCATION, GARAGENAME, WORKSHOPADDRESS, WORKSHOPMOBILENO, MANUFACTURINGYEAR, CHASSISNUMBER, ENGINENUMBER, REGISTRATIONNUMBER, VEHICLEMODEL, BUSINESSTYPE, TOTALSI, CLAIMEDAMOUNT, ESTIMATEDAMOUNT, "LABOUR(E)", "PARTS(E)", "PAINTING(E)", EXCESS, SURVEYORNAME, SURVEYAPPOINTDATE, SURVEYAPPOINTTIME, TAT_SURVEYORAPPT, SURVEYDATE, SURVEYTIME, REPORTDATE, REPORTTIME, REPORTRECEIPTDATE, TAT_SURVEYREPORT, REPORTID, CLAIMSTATUS, LOSSCODE, LOSSTYPE, SPOTSURVEYNAME, SPOTSURVEYAPPDATE, SPOTSURVEYDATE, PARTS, LABOUR, PAINTING, ASSESSEDAMOUNT, TAT_INTIMATION_HOUR, TAT_REGISTRATION_HOUR, TAT_SETTLEMENT_DAY, TAT_SURVEYAPPT_HOUR, TAT_SURVEY_HOUR, TAT_REPORT_DAY, PAYEENAME, PAYEEADDRESS, PAYABLE_AT, PAIDAMOUNT, CHEQUENO, CHEQUEDATE, PAYMENTMODE, DISBURSEMENTINFO, GARAGECODE, GARAGESTATE , GARAGECITY, GARAGEREGION, "ACCIDENT AREA VILLAGE CODE", "ACCIDENT AREA VILLAGE", "ACCIDENT CITY CODE", "PLACE OF ACCIDENT CODE", "ACCIDENT CITY", STATECODE, CITYCODE, AUTHORIZED, RRESERVEAMOUNT, SMOBILE, SPOTMOBILE, SURVEYORCODE, MANUFACTURER, SETTLEDDATE, SALVAGE, TOWING_CHARGES, DEPRECIATION_AMOUNT, NUM_YEAR, NUM_PERIOD_CD, TXT_PERIOD, TOTALLOSS, TAT_INTIMATION, TAT_REGISTRATION, INSUREDMOBILENO, TAT_SETTLEMENT, TRANSACTIONDATE, TAT_REGISTRATION1, TAT_SURVEYORAPPT1, REMARKS, INSERTDATE, SURVEYORAPPOINTUSERID, INTIMATIONUSERID FROM INS.MIS_CLAIMDETAILS_ADMINUSR Tbl 


RATIONALE: Waiting for event "PX Deq Credit: send blkd" in wait class 
         "Other" accounted for 99% of the database time spent in processing 
         the SQL statement with SQL_ID "gp2j06fk8dhfb".


Kindly help me out to understand about "PX Deq Credit: send blkd"...

Regards,
IShika

Re: PX Deq Credit: send blkd [message #589693 is a reply to message #589682] Wed, 10 July 2013 02:04 Go to previous message
John Watson
Messages: 8928
Registered: January 2010
Location: Global Village
Senior Member
There is a MOS article (I do not have the number) that says that this event is considered an idle event. So you can ignore it.
Previous Topic: Query on depenedency between DB Instance and Service?
Next Topic: RAC - storage configuration
Goto Forum:
  


Current Time: Tue Apr 16 13:57:11 CDT 2024