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 '
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
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
Author: hackest [h.s. T.]Source: hackest's blog
Http://www.hackest.cn/post/102/
Introduction
I have been wondering, in what way can I control the permissions that have been obtained for a long time? Webshell, Trojan, or even rootkit? The webshell
Buffer header structure Diagram and introduction
Figure 1:
Buffer header: Each data block is read into the buffer cache, will first in the buffer cache to construct a buffer Header,buffer header and data block one by one corresponding. The main
The mode of the HASH joinHash join has three kinds of working modes, namely optimal mode, OnePass mode and Multipass mode, respectively, there are corresponding statistic information in V$sysstat:Sql> select name, value from V$sysstat where name is
Experiment idea: first in the database for bys. update a row in Table a, find the FILE # BLOCK # corresponding to the row, and then DUMP the FILE # BLOCK #. view the SCN information using BBEDDUMP this FILE # BLOCK # To view the SCN Information 1.
Guide:
Oracle Common Dump command, record for future reference
I. Memory dumps
1). Global Area
ALTER session SET EVENTS ' immediate trace name Global_area level n ';
1 contains PGA
2 contains SGA
4 contains UGA
8 contains indrect memory
2). Library
Common dump commands in Oracle for future reference.
1. Memory Dumps
1). Global AreaAlter session set events 'immediate trace name global_area level n ';1 Including PGA2 contains SGA4 include UGA8 contains indrect memory
2). Library CacheAlter
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.