HowtoDiagnoseOracleDataPump-how to add diagnostic information to a Data Pump
There are still many bugs in the 11g Data Pump (expdp/impdp), and we often encounter inexplicable card death, which makes people feel overwhelmed. I recently read an article, in fact, you can track logs when exporting and importing data from a data pump.
Parameter: TRACE
To enable the tracking function, you only need to add a trace parameter when DataPump (expdp) or DataPump
subdirectory FD stores the FD of all files opened by the process. The target is very close to us. Okay. Let's go to/proc/3125/FD/and check whether:
# cd /proc/3125/fd/# ls -ltotal 0lrwx------ 1 root root 64 Nov 5 09:50 0 -> /dev/pts/0lrwx------ 1 root root 64 Nov 5 09:50 1 -> /dev/pts/0lrwx------ 1 root root 64 Nov 5 09:50 2 -> /dev/pts/0lr-x------ 1 root root 64 Nov 5 09:50 3 -> /tmp/foo# readlink /proc/3125/fd/3/tmp/foo
T
:1539615854095$Then you can order various kinds of gestures to get a variety of ...Summarize:
Before installing Arthas, you need to install JDK, configure environment variables such as Java_home, and Telnet. Unzip look at the situation, if you finish the decompression and then upload to the server, also line ...
Do not know whether it is a bug or God horse situation, according to the steps of the document once again installed on the test server, the program runs normally, there is n
User Managed Backup Recovery Diagnostic Collection
Note:
Log on to SQL * PLUS with SYSDBA permission for executionThe instance must be mounted or OPEN mode.Generate the result file: recovery_diagnostics.out (default location is/tmp)
----------------- Start ------------------Set echo onSet linesize 200 trimspool onCol name form a60Col status form a10Col dbname form a15Col member form a80Col inst_id form 999Col resetlogs_time form a25Col created form a
One, three, nine.Inch off ruler, floating medium sink, total 3*3=9
Inch
Off
Feet
Left
Heart, in the tan
Liver, spleen
Kidney, lower abdomen, bladder, small intestine
Right
Lung, Ebony
Spleen
Kidney, lower abdomen, large intestine
Two, pulse fingeringselect = = "cloth refers to the ==〉 (float for lift, take for the search, sink for the press)Three, normal pulsePulse level, pulse often (not floa
FreeBSD 5, so to use the truss or Strace tracker, you must manually load the proc file system: Mount-t PROCFS Proc/proc , or add a line to the/etc/fstab:
Proc /proc procfs rw 0 0
Ltrace does not require the use of PROCFS.Resources
Truss (1) manual page
Strace (1) manual page
Ltrace (1) manual page
Ptrace (2) manual page
Lsof (1) manual page
Debugging with Strace:http://
Robert said:Ok, so I bought a Lexia3 interface from eobd2.fr in 2010. I have had no issues over the past 5 years on my Citroen XM. It is use have been primarily as a maintenance tool 2 or 3 times a year to be sure everything are OK with my car. I had pulled a fault code with it when the airbag came on. Erased the code and the light were turned off, never come back.Gilbert said:The Lexia3 V48 works on both my 2002 2.0 HDI and 2004 2.0 HDIs.Frank said:My Chinese lexia have been used successfully o
updated to current
L
Time
Total CPU time used by the process, in seconds
M
time+
Total CPU time used by the process, Unit 1/100 sec
N
%MEM
Percentage of physical memory used by the process
O
VIRT
The total amount of virtual memory used by the process, in kilobytes. Virt=swap+res
P
SWAP
The size, in kilobytes, of the virtual memory that the process is using, swapped out.
Linux system monitoring and diagnostic toolsLinux users may not be unfamiliar with top commands (different system names may be different, such as topas in IBM aix ), it is mainly used to monitor the system's real-time load rate, process resource usage, and other system status attributes. Next let's take a look at the top: (1) system and task statistics: the first eight rows are the overall statistics of the system. The second line is the task queue in
Knowledge Point Analysis:
The Western Data Official instrumentation tool can be used to diagnose when a possible failure occurs with the West hard drive (desktop or notebook hard disk).
Operation Steps:
Please make a full backup of the data on your hard disk before using the tool to prevent loss.
Click here to download >>
This is the Windows version of the Data lifeguard diagnostics. It will test the WD built-in and external hard drives. In addition, it can provide you with the system to co
See an article about system resource usage in 1 minutes by executing the following command: A general overview. Pro-Test, very easy to use, we can check the gaps, good things not only to share but also to real deal study in (*^__^*)
Uptime
DMESG | Tail Error Statistics
Vmstat 1
Mpstat-p all 1 CPU cores usage
Pidstat 1 Process consumes CPU number
IOSTAT-XZ 1
Free-m
Sar-n DEV 1 Network interface throughput
Sar-n tcp,etcp 1 TCP Connection establishment number
Top
Posted Addre
as650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/58/4A/wKiom1St22ujm2YRAAEAIoCIv4Q407.jpg "title=" Mctop.jpg "alt=" Wkiom1st22ujm2yraaeaiociv4q407.jpg "/>One eye to see, is esf-wordfilter__all value too large accounted for the 4m/s bandwidth, inform the Business Unit optimization of ~Summarize:Mctop is a very good online monitoring program, but also to inspire, you can do a set of MC monitoring according to this, well, that's it ~This article is from the "Flying Snail" blog, please
...................................................................................................................................................................................................sbd2j1tq000440 214 Sat Dec 10:45 (Host Map:lookup (xxxx.com): deferred)[Email protected]sbd301x9000637 214 Sat Dec (Host Map:lookup (xxxx.com): deferred)[Email protected]Total requests:120[Email protected] mail]# The "host Map:lookup: Deferred" error means that the delivery of the message is delayed. Yo
After diagnosing the system, all the modified items are listed, and for these items, the security level of each item is provided in the main list table according to the strong knowledge base content of the 360 security guardian, and the details are described in detail; if the user wants to know more about an item, just click on the item Immediately displays all information about the item for the user in the floating window below.
At the same time, the
running the !process command:At this point, master the above several simple analysis methods, basically the majority of DMP can be independently analyzed, of course, WinDbg is a powerful tool, while the reasons for the blue screen is also a lot, if you want to analyze enough accurate, then only more learning more practice, more to analyze, Because WinDbg analysis is more important than just a few commands!Reasonable to give you some analysis and suggestions:Not necessarily each DMP file can be
Label:This is done in the following ways:@d:\latchprofx.sql sid,name,laddr% Cache 10000@d:\latchprof.sql sid,name,laddr% Cache 10000Script Source: http://www.tanelpoder.comLatchprofx.sql------------------------------------------------------------------------------------File Name:latchprofx.sql ( Latch Holder Profiler eXtended)--purpose:perform high-frequency sampling on v$latchholder--and Presen T a profile of latches held by sessions--including extended statistics on which kernel--
:tns:application timeout occurred
kmduicxd:0x7f381c4bd960, Kmduiflg:1, circuit:0x377942fd0
process id = (0X37F799EF8, 1)
process id = (17, 1)
# = 798
Connection context = 0x7f381c4bd960
User session = ((nil)), flag = (100c0), queue = (9)
Current buffer = (0), status = (4, 0)
Can be seen mainly because of the following statement caused by SELECT from WHERE for UPDATE
Select from where' srn-ymg-201608-' for Update
As soon as you see the FOR UPDATE statement, you already know that
DC--perform connection, most recently executed query informationCross apply sys.dm_exec_sql_text (dc.most_recent_sql_handle) DTJoin Sys.dm_exec_sessions DS on dc.session_id=ds.session_idwhere Ds.login_name= ' LCGS609999 '--where ds.program_name = '. Net SqlClient Data Provider 'ORDER by Dt.textCopy Code Copy Code--Clears all cached data in the buffer poolDBCC dropcleanbuffersGO--Clears all cached execution plans in the buffer poolDBCC FreeproccacheGO--statistical information, implementation pla
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.