Oracle Common Dump command
Memory Dumps
1). Global Area
ALTER session SET The EVENTS ' immediatetrace name Global_area level n ';
1 contains PGA 2 contains SGA 4 contains UGA 8 contains indrect memory
2). Library Cache
ALTER session SET The EVENTS '
Dump is a dump of information on the memory of the program runtime, allowing us to see how the program is running. Dump is a very useful tool for tuning and troubleshooting.Heap DumpThe Java runtime objects are allocated to heap memory, and heap
Keyword: System exception system exception memory dump (Information dump), windbg tool. 1. Why dump memory?The system often has various problems, which may beProgramDuring the design, the system may be faulty due to program exceptions or system
Debug SQLSERVER (1) generate dump file debugging SQLSERVER (2) use Windbg to debug SQLSERVER's Environment Settings debugging SQLSERVER (3) using Windbg to debug some SQL Server commands, we know that there are two main ways to debug the program:
One, Oracle trace fileThere are three types of Oracle trace files, a background alarm log file that records the activity of the background process during startup, shutdown, and operation of the database, such as tablespace creation, rollback segment
One, Oracle trace FileOracle trace files are grouped into three categories:
One is the background alarm log file that records the activity of the background process during startup, shutdown, and running of the database , such as table space
As mentioned above, the dump file can save the Process status for easy analysis. Because the dump file records the specific information of a process at a certain time point, it is very important to save the dump. For exampleProgramCrash: dump should
I,OracleTracking FileThere are three types of Oracle tracking files:
One is the background alarm log file, which recordsDatabaseActivities of background processes during startup, shutdown, and running, such as creating tablespaces, creating
Debug SQL Server (i) How to generate a dump fileDebug SQL Server (ii) Debugging environment settings for SQL Server using WinDbgDebug SQL Server (iii) Some commands for debugging SQL Server using WinDbgWe know that there are two main ways of
about how to set up kernel dumps1. Kernel dump function(1) The greatest benefit of a kernel dump is the ability to save the state when the problem occurs.(2) As long as the executable file and the kernel dump, you can know the status of the process.(
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.