What about the statement below from our DBA's: The select that was performing scans which has been the target of our tuning efforts and runs for 8 hours a day, 6 million reads and is executed about 1,800 times a day is as follows. Essentially, it’s scanning the database all day long and from what we can tell, isn’t returning anything.
SELECT ticketgran0_.ID as ID2_, ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_, ticketgran0_.CREATION_TIME as CREATION3_2_, ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_, ticketgran0_.LAST_TIME_USED as LAST5_2_, ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_, ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_, ticketgran0_.AUTHENTICATION as AUTHENTI7_2_, ticketgran0_.EXPIRED as EXPIRED2_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ FROM TICKETGRANTINGTICKET ticketgran0_ WHERE ticketgran0_.ticketGrantingTicket_ID=? Thanks -----Original Message----- From: Marvin Addison [mailto:[email protected]] Sent: Thursday, April 17, 2014 10:59 AM To: [email protected] Subject: Re: [cas-user] TGT table not getting cleaned up > We are not doing any proxying, so in reality, that column should be null? Yes. It has no child tickets since you're not proxying. A proxy ticket is modeled as a parent-child relation between the original SSO session ticket (parent) and proxy ticket (child). > Like I said, this process seems to have been working before we implemented > throttling. I'm not sure why thought it started happening around that time. No cause-effect relationship comes to mind with throttling. > Can anyone tell me the referncial integrity between the SERVICETICKET and > TICKETGRANTINGTICKET tables? The TICKETGRANTINGTICKET_ID column of SERVICETICKET has a foreign key reference on TICKETGRANTINGTICKET.ID. > Also, so that TICKETGRANTINGTICKET_ID column is only used if using a proxy? TICKETGRANTINGTICKET.TICKETGRANTINGTICKET_ID, yes. M -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
