Thanks for tip on yourkit. My DBA just sent me this email. Any ideas?
Bryan -
This is the hottest running SQL:
select
ticketgran0_.ID as ID1_, ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_1_,
ticketgran0_.CREATION_TIME as CREATION3_1_, ticketgran0_.EXPIRATION_POLICY as
EXPIRATION4_1_,
ticketgran0_.LAST_TIME_USED as LAST5_1_, ticketgran0_.PREVIOUS_LAST_TIME_USED
as PREVIOUS6_1_,
ticketgran0_.ticketGrantingTicket_ID as ticketG10_1_,
ticketgran0_.AUTHENTICATION as AUTHENTI7_1_,
ticketgran0_.EXPIRED as EXPIRED1_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as
SERVICES9_1_
from TICKETGRANTINGTICKET ticketgran0_
where ticketgran0_.ticketGrantingTicket_ID=:1;
SQL> desc ugo.TICKETGRANTINGTICKET
Name Null?
Type
-----------------------------------------------------------------------
-------- ------------------------------------------------
ID
NOT NULL VARCHAR2(255 CHAR)
NUMBER_OF_TIMES_USED
NUMBER(10)
CREATION_TIME
NUMBER(19)
EXPIRATION_POLICY NOT NULL
BLOB
LAST_TIME_USED
NUMBER(19)
PREVIOUS_LAST_TIME_USED
NUMBER(19)
AUTHENTICATION NOT NULL
BLOB
EXPIRED NOT
NULL NUMBER(1)
SERVICES_GRANTED_ACCESS_TO NOT NULL BLOB
TICKETGRANTINGTICKET_ID
VARCHAR2(255 CHAR)
It contains almost 2 Million rows.
ID is the Table KEY
TICKETGRANTINGTICKET_ID is the Secondary Key
TICKETGRANTINGTICKET_ID is not populated -- all rows have a NULL Value.
So the SQL at the Top of page will always return Zero Rows.
I see multiple SQL matching on TICKETGRANTINGTICKET. TICKETGRANTINGTICKET_ID
This Code will always return ZERO rows.
Why is it executing Code against a Large tables where it will always return
ZERO Rows?
I don't know the order of how the SQL is being executed. I can only see
cursors that are open for a Session.
-----Original Message-----
From: Marvin Addison [mailto:[email protected]]
Sent: Monday, January 09, 2012 9:46 AM
To: [email protected]
Subject: Re: [cas-user] CAS slow today
> Any ideas on what else we can tune? (CAS is running on Glassfish
> 3.0.1, we have tried to tune TCP acceptor threads and max threads per a GF
> blog).
I would recommend you don't tune anything until you get some data about the
source of your bottlenecks. We use YourKit for profiling our apps, but there
are other tools out there. Get some data first and see what the problem is.
While the database is almost certainly the bottleneck, it would be good to have
some evidence before you start swinging the hammer.
Ping us back if you need help specifically with database tuning. May have some
pointers for you.
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
