Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2008-01-29
2008-01-29
Vital, Pierre (Department: 2169)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07325016
ABSTRACT:
The present invention provides a method and system for monitoring the process performance of a database that accepts and records SQL statements and that records the status of a session of use of the database. The invention obtains the SQL address and hash value for each SQL statement, the current session status corresponding to each SQL statement and the previous session status corresponding to each SQL statement. The invention also records a time stamp at the time the session status information is obtained. The information gathering steps are repeated at a predetermined interval of time. Using the information gathered, the run time for each SQL statement is calculated. The run time for each SQL statement may then be reviewed to determine which SQL statements experience the greatest run time, which allows DBAs to locate the source of any performance problems.
REFERENCES:
patent: 5860069 (1999-01-01), Wright
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6006220 (1999-12-01), Haderle et al.
patent: 6182079 (2001-01-01), Lenzie
patent: 6446062 (2002-09-01), Levine et al.
patent: 6665677 (2003-12-01), Wotring et al.
patent: 7082442 (2006-07-01), Sugimoto et al.
Lewis, Jonathan. “Guilty Party—Who's the worst sinner right now (Unix only).” Aug. 1999. <http://www.jlcomp.demon.co.uk/guilty.html>, pp. 1-3.
Lewis, Jonathan. “Lost SQL in $sql / v$session.” Sep. 7, 1999. <http://www.jlcomp.demon.co.uk/lost—sql.html.>, pp. 1-2.
Oracle 8i Reference. Dec. 1999. Oracle, Release 2 (8.1.6), pp. (3-90) to (3-93).
SQL Plus: User's Guide and Reference. Oct. 1999. Oracle, Release 8.1.6, pp. (2-10) to (2-11).
Oracle 8i SQL, “Timing SQL Commands”, Jun. 24, 2004, <http://web.archive.org/web/*/http://www1.tyict.vtc.edu.hk/freddy/ORACLE8i/oral8i—sql.htm>.
Nofal Christopher P
Sprint Communications Company L.P.
Vital Pierre
LandOfFree
Monitoring database performance by obtaining SQL addresses... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Monitoring database performance by obtaining SQL addresses..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Monitoring database performance by obtaining SQL addresses... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2760787