Claims
- 1. A method of debugging a database system, the method comprising the steps of:preventing modification to a first set of data stored in volatile memory, wherein the first set of data includes at least a portion of volatile memory state of a first database system; durably storing a second set of data that includes at least a portion of said first set of data; using the second set of data to cause a volatile memory state of a second database system to at least partially reflect the volatile memory state of the first database system; and using the second database system to extract high-level debug information relating to the first database system.
- 2. The method of claim 1 wherein the step of using the second database system to extract high-level debug information relating to the first database system includes issuing queries to the second database system.
- 3. The method of claim 1 further comprising the steps of:executing the first database system on a first machine; and executing the second database system on a second machine that is separate from said first machine.
- 4. The method of claim 3 further comprising the step of recovering the first database system on said first machine after durably storing said second set of data and prior to executing said second database system on said second machine.
- 5. The method of claim 1, wherein the first set of data includes a group of shared memory structures that contain data and metadata, wherein the metadata includes initialization parameters for initializing the first database system, control information, and information for interpreting the preserved memory state portion of the first database system for use in the debugging operations.
- 6. A computer-readable medium bearing instructions for debugging a database system, the instructions arranged, when executed by one or more processors, to cause the one or more processors to perform the steps of:preventing modification to a first set of data stored in volatile memory, wherein the first set of data includes at least a portion of volatile memory state of a first database system; durably storing a second set of data that includes at least a portion of said first set of data; using the second set of data to cause a volatile memory state of a second database system to at least partially reflect the volatile memory state of the first database system; and using the second database system to extract high-level debug information relating to the first database system.
- 7. The computer-readable medium of claim 6 wherein the step of using the second database system to extract high-level debug information relating to the first database system includes issuing queries to the second database system.
- 8. The computer-readable medium of claim 6 further comprising the steps of:executing the first database system on a first machine; and executing the second database system on a second machine that is separate from said first machine.
- 9. The computer-readable medium of claim 8 further comprising the step of recovering the first database system on said first machine after durably storing said second set of data and prior to executing said second database system on said second machine.
- 10. The computer-readable medium of claim 6, wherein the first set of data includes a group of shared memory structures that contain data and metadata, wherein the metadata includes initialization parameters for initializing the first database system, control information, and information for interpreting the preserved memory state portion of the first database system for use in the debugging operations.
CROSS REFERENCE TO RELATED APPLICATIONS
This application is related to and claims domestic priority under 35 U.S.C. §119(e) from prior U.S. Provisional Patent Application Ser. No. 60/166,598 filed on Nov. 19, 1999 entitled “Debugging Techniques And Fast SGA Dumps For Deferred Analysis Of The Database”, by inventors Vikram Joshi, Alex Tsukerman, and Shari Yamaguchi, the entire disclosure of which is hereby incorporated by reference as if fully set forth herein.
This application is related to U.S. patent application Ser. No. 09/649,310 filed on Aug. 28, 2000 entitled “Method And Apparatus For Debugging A Software Program”, by inventors Vikram Joshi, Alex Tsukerinan, and Shari Yamaguchi, the entire disclosure of which is hereby incorporated by reference as if fully set forth herein.
This application is related to U.S. patent application Ser. No. 09/717,187, filed on the same day herewith entitled “Method and Apparatus for Debugging a Software Program Using Dynamic Debug Patches and Copy on Write Views”, by inventors Vikram Joshi, Alex Tsukerman, and Shari Yamaguchi, the entire disclosure of which is hereby incorporated by reference as if fully set forth herein.
This application is related to U.S. patent application Ser. No. 09/717,161, filed on the same day herewith entitled “A Debug and Data Collection Mechanism Utilizing a Difference in Database State by Using Consecutive Snapshots of a Database State”, by inventors Vikram Joshi, Alex Tsukerman, and Shari Yamaguchi, the entire disclosure of which is hereby incorporated by reference as if fully set forth herein.
US Referenced Citations (12)
Non-Patent Literature Citations (1)
Entry |
“Solaris 2.6 Reference Manual AnswerBook>>man pp.(3): Library Routines”, 5 pages, 2001, http://docs.sun.com:80/ab2/@LegacyPageView?toc=SUNWab_40_4%3A%Fsafedir%Fsp. |
Provisional Applications (1)
|
Number |
Date |
Country |
|
60/166598 |
Nov 1999 |
US |