Specifies the file sizes, using K to specify the size of the kilobytes, and M to specify the megabyte size;
The Autoextend clause is used to enable or disable automatic extension of the data file, set to on to automatically expand when the space is used, and set to off it is easy to have a table space remaining capacity of 0, so that data can not be stored in the database.
Example: Creating an aut
back.At this point, CPU1 is forced to be placed in a wait state. The CPU1 waiting time ratio is%steal. (Personal understanding)Explanation of the format of the Device usage report:TPS: The number of transmissions sent to the device per second. The transmission here refers to an I/O request sent to the device.So, TPS means: the number of I/O requests sent to the device per second . A read request is called a i/0, and a write request is called an I/O.blk_read/s: number of blocks read from the dev
You may rarely face this situation, but once so, you must know what is wrong: insufficient memory or out-of-memory (OOM ). The result is very typical: you cannot reallocate the memory, and the kernel will kill a task (usually the one running ). Generally, with a large amount of read/write switching, you can see the screen and disk movements.
The following is an implicit question: How much memory do you need to allocate? How much does the operating system allocate to you? The basic reason for OOM
kilobytes per second.kB_wrtn/s Indicate the amount of data written to the device expressed in kilobytes per second.kB_read The total number of kilobytes read.kB_wrtn The total number of kilobytes written.MB_read/s Indicate the amount of data read from the device expressed in megabytes per second.MB_wrtn/s
of the space that is used for persistent generations. Unit KB.
-gc-gcold
Ygc
The number of times the generation of space GC time occurred.
-gc-gccapacity-gcnew-gcnewcapacity-gcold-gcoldcapacity-gcpermcapacity-gcutil-gccause
Ygct
The time taken by the new generation of GC processing.
-gc-gcnew-gcutil-gccause
FGC
The number of times the full GC occurred.
-gc-gccapacity-gcnew-gcnewcapacity-gcold-gcoldcapacity-gcpermcapaci
Pu
Outputs the size of the used space for durable generations. Unit KB.
-gc-gcold
Ygc
The number of times the generation of space GC time occurred.
-gc-gccapacity-gcnew-gcnewcapacity-gcold-gcoldcapacity-gcpermcapacity-gcutil-gccause
Ygct
The time taken by the new generation of GC processing.
-gc-gcnew-gcutil-gccause
FGC
The number of times the full GC occurred.
-gc-gccapacity-gcnew-gcnewcapacity-gcol
the virtual CPU or CPUs while the hypervi- SOR is servicing another virtual Processor.%idle Show the percentage of time that the CPU or CPUs were idle and the System do not has an outstand-ing disk I/O request.Device Utilization ReportTPS indicate the number of transfers per second that were issued to the device. A transfer is an I/O request to the device. Multiple logical requests can is combined into a single I/O request to the device. A transfer is of indeterminate size. blk_read/s indica
First look at my own experimental environment is in what kind of archiving mode:
Sql> Select T.log_mode from V$database t; Log_mode------------Noarchivelog
Two. After determining that it is in the non-archive mode, I first create a regular table t_test_nologging
1. Create a table, the so-called general is in the creation process does not specify this table is nologging
Sql> CREATE TABLE t_test_nologging as SELECT * from T_down_log where 1=0; Table created sql> Select COUNT (*) from T_down_log;
-ROM). Though a CD-RW disc can be erased and written again, character CD players and other equipment generally perform better with CD-R media ( Always check if a CD player supports CD-RW before you buy it ). A standard CD-RW is 120 in diameter and usually comes with a capacity of either 640 MB or 700 mb. A CD-RW will store 74 or 80 minutes of CD audio, but as mentioned, is much less compatible with CD players than CD-R.
Using software solutions suchNero burning Rom, At-home users can create au
View existing VG # lsvgrootvgoravgdatavg view the usage status of each VG # lsvgoravg focuses on several values PPSIZE: 512 megabyte (s)
View existing VG # lsvg rootvg oravg datavg view the status of each VG # lsvg oravg focuses on several values pp size: 512 megabyte (s)
View existing VG
# Lsvg
Rootvg
Oravg
Datavg
View the usage status of each VG
# Lsvg oravg
Focus on several values
Pp size: 512
-gcnew-gcutil-gccause
FGC
The number of times the full GC occurred.
-gc-gccapacity-gcnew-gcnewcapacity-gcold-gcoldcapacity-gcpermcapacity-gcutil-gccause
Fgct
The time spent by the full GC operation.
-gc-gcold-gcoldcapacity-gcpermcapacity-gcutil-gccause
GCT
Total time spent by GC operations.
-gc-gcold-gcoldcapacity-gcpermcapacity-gcutil-gccause
Ngcmn
Cenozoic minimum space capacity, in
run; Hi: The percentage of hardware terminals; Si: The percentage of software terminals; Percentage of st:cpu stolen (such as virtual machines running on a real machine)4, KiB Mem: in kilobytes to view memory, physical memory;5, KiB Swap: In kilobytes view memory, virtual memory, usage 0, if more than 0 indicates that the physical memory is not enough, the use of virtual memoryProcess information
= Priority: Precedenceni= nice value: Negative priority > Positive priorityvirt= Virtual Image (KB): The total amount of VM memory used by the process, in kilobytes. Virt=swap+resRes= resident Size (KB): The amount of physical memory that the process uses, not swapped out, in kilobytesShr= shared Mem Size (KB): Shared memory sizes, in kilobytess= process Status: Progress State, D: Non-disruptive sleep state, R: Run, T: Trace/Stop, Z: Zombie Processtim
= Priority: Precedenceni= nice value: Negative priority > positive priorityvirt= Virtual Image (kb): The total amount of VM memory used by the process, in Kilobytes. Virt=swap+resRes= resident Size (kb): The amount of physical memory that the process uses, not swapped out, in kilobytesshr= shared Mem size (kb): shared memory sizes, in kilobytesS= process status: Progress state, D: non-disruptive sleep state, R: run, T: trace/stop, Z: Zombie Processtim
user processes that have changed precedence
99.7%id
CPU percent of idle CPU
0.1%wa
CPU percentage of processes waiting for input/output
0.0%hi
Percentage of CPU consumed by the hard interrupt request service
0.1%si
Percentage of CPU consumed by soft interrupt request Service
0.0%st
The St (steal Time) virtual percentage.
Physical memory information of the IV behavior:
c
look at it.
Memory displays information about the RAM:
[] swpd: Represents the amount of memory switched to the swap partition, in kilobytes.
[] Free: Indicates the amount of memory currently idle in kilobytes.
[] Buff: Represents the buffer size (to be written to disk) in kilobytes.
[] cache: Represents the buffer size (read from disk) in
priority
The total amount of virtual memory used by the VIRT process, in kilobytes. Virt=swap+res
The size, in kilobytes, of the physical memory used by the RES process and not swapped out. Res=code+data
SHR shared memory size, in kilobytes
S process state. d= non-disruptive sleep status r= run s= sleep t= track/stop z= zombie Process
%cpu pe
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.