Hi,
I don't think it is right. X$KGLCURSOR.TIME (DATE) will hold the timestamp
(last used) and S$KGLCURSOR.KGLNAPTM will hold the previous time stamp
of the cursor and the KGLHDEXC will keep the execution count (how
many times the cursor is executed.
Each version of SQL will have their own cursor in respective namespace
and different addresses in the SGA. Two different versions of sqls can
not share a single cursor.
Hope this helps.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-----Original Message-----
From: surender sara [mailto:[Email Address Removed] Friday, September 21, 2001 8:11 AM
To: LazyDBA.com Discussion
Subject: x$kglcursor ?
Hi Gurus
Have a Quick question. Table x$kglcursor shows the time of sql run for the
whole day. Seems like there is rolling window of 2-3 days .
It is OK to asume that this table holds 24 hrs of SQL run along with
executions / version etc stats ?
look at the following querry
select KGLNAOBJ , KGLNATIM , KGLHDEXC from x$kglcursor ;
Trying to confirm this..( the second column seems to have 24 hrs of
timestamp for a library cache SQL statements ) for x days !
thks
sra
Make a difference, help support the relief efforts in the U.S.
http://clubs.lycos.com/live/events/september11.asp
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com