If ash is stopped, report problems cannot be solved.

If ash is stopped, report problems cannot be solved.
1. database version

Oracle 11.2.0.3.0

2. Problem

When you use ashrpt. SQL to generate an ash report, there is no response after you enter the start time, specify the report file storage path, and the file name.

SQL> @? /Rdbms/admin/ashrpt. SQL  ...... Using the report name /Home/oracle/ashrpt_20170802_1932.html   Summary of All User Input ------------------------- Format: HTML DB Id: 2024181297 Inst num: 1 Begin time: 02-Aug-14 19:22:34 End time: 02-Aug-14 19:32:34 Slot width: Default Report targets: 0 Report name:/home/oracle/ashrpt_20170802_1932.html   It's not moving here ......

 

3. Problem Analysis 3.1. view what the ashrpt session is waiting

SQL> select sid, program, event from v $ session where sid = 1590; SID PROGRAM EVENT Bytes ----------------------------------------------------------------------------------------------------- 1590 sqlplus @ nosql1 (TNS V1-V3)Control file sequential read

Wait for the event to continue to "control filesequential read" 3.2, view the optimizer_mode Parameter Setting Value

SQL> show parameter optimizer_mode   NAME TYPE VALUE Bytes -------------------------------------------------------------------------------------------------- Optimizer_mode stringFIRST_ROWS_10

It is found that optimizer_mode is modified to first_rows_10 instead of the default value all_rows.

3.3 preliminary analysis summary

Based on the abnormality of the preceding waiting event and the modified value of optimizer_mode, it is suspected that it may be an oracle bug.

4. Verification of analysis results

On metalink, find the article13794366.8In ORACLE 11.2.0.2 and 11.2.0.3, the BUG of OPTIMIZER_MODE = FIRST_ROWS_N is fixed in 11.2.0.4.

Description ASH reports can take a really long to complete if the optimizer_mode parameter is set to FIRST_ROWS_N Rediscovery Notes ASH reports will take a long time to complete when optimizer_mode parameter is set to FIRST_ROWS_N Workaround None

5. Solution

In order not to affect other aspects of the system by modifying the optimizer_mode parameter, select the "all_rows" method at the session level when creating the ash report to generate the ash report successfully.

SQL>Alter session set optimizer_mode = 'all _ rows '; SQL> @? /Rdbms/admin/ashrpt. SQL   ......   <P/> End of Report </Body> Report written to/home/oracle/ashrpt_1_0802_1932.html

The Ash report is generated successfully.

 

Author: LI Junjie (Network Name: Step-by-Step), engaged in "system architecture, operating system, storage device, database, middleware, application" six levels of systematic performance optimization work

Join the system performance optimization professional group to discuss performance optimization technologies. GROUP: 258187244

How to stop program error reports

During the running of Windows XP, an invalid operation or error message is reported to every computer. In this case, Windows XP will start the Error Reporting mechanism (WER), ask the user whether to send the Error message to Microsoft, and the program will stop running. But do you really understand the error reporting mechanism in Windows? How do you control it? In fact, as long as we solve the following two key points and find out the ins and outs of the "Error Report", it is not difficult.

I. Do you want to send an error report?

Do you want to send? The user is in trouble. To solve this problem, you must first know the results of different choices.
(1) If you choose not to send the message, the error report will appear again as long as the error persists.
(2) If you select send, the system automatically collects the relevant information and sends it to Microsoft over the Internet. After the report is sent, if

Other people have reported similar problems. Microsoft will provide a solution to the problem. You only need to click the "other information" link to open the relevant webpage. You can solve the problem by following the prompts on the webpage.

From the above results, you should choose to send, but it is not so simple. Do you know what the system did when sending the error report? It must be noted that when the system sends a report, the information that the user is browsing or compiling when the program crashes will also be sent to Microsoft. The data collected in the error report includes the error type, Recent user operations, network information, log files, configuration files, memory snapshots, and software configuration information, therefore, the privacy information of many users is sent to Microsoft together with the report.

TIPS: at present, many companies or individuals use the Internet to collect trade secrets or privacy, and rashly sending error reports may expose the company's secrets or privacy. Although the information leaked in most cases is not very important, users should cultivate a good sense of self-protection.

Ii. how to disable the error report

To protect their own rights and interests, we would rather not resolve errors or send reports. It is easy to say, but the prompt information that may pop up every time an error program is run is really annoying. In fact, users can use technical means to control the generation of error reports in three ways.

1. Selective close Method

(1) Right-click "my computer" on the desktop, select the "properties" command, open the "System Properties" dialog box, and click the "advanced" tab, click the "Error Report" button below.

(2) In the "Error Report" dialog box, select the "Disable Error Report" and "notify me when a serious error occurs" check boxes. Click OK. In this way, Windows XP will not bring up the error message for some small errors.

2. Targeted close Method

(1) If an error report is often caused by a program error, You can exclude the program directly from the error report. First, open the "Error Report" dialog box and select "enable error report ".

(2) Click the "Select Program" button. In the displayed dialog box, click the "add" button under "do not report errors for these programs" to open the "add program" dialog box, enter the complete file name of the program, such as "WINWORD. EXE ".

(3) Click "OK". In the future, even if a program error occurs in WORD, no error prompt will be displayed.

3. Completely close

In addition, the Error Reporting Service can be completely disabled. In the "run" box, enter "services. run the msc command to open the "Service" window, double-click "Error Reporting Service" on the right, and open the "Error Reporting Service Attributes" dialog box, change "Start type" to "disabled" (3), and then restart the system.
TIPS: If you need to view recent error statistics, you can select the "Start> program> attachment> System Tools> system information" command to open the "System Information" dialog box, expand "Windows Error Report" in "software environment .... Remaining full text>

When the phone number of the htc t328d storage fails, the following error occurs: "Dialer has unexpectedly stopped. Do you want to send an error report to HTC? This will help us improve our

I use HTC T328W. On the second day of the purchase, we found that we could not create a contact, and the mobile phone showed that "dialer has unexpectedly stopped. Please inform HTC of the prompt. At that time, it may be an operation problem. Then, the mobile phone is restored to the factory settings and the problem is solved. I didn't care about it. On the fourth day, the problem appeared again. Baidu, the omnipotent company, also found that this problem had a chance to be discovered. But the solution was to restore the factory settings, in this way, all the information on the mobile phone is lost, which is very troublesome. I contacted HTC's customer service and asked if he could restart the suspended dialer program. The customer service said this was a problem with the dialing program, we recommend that you back up the contact data and click "all"> "Settings"> "Applications"> "All Applications"> "Dialers" on the mobile phone's main page. Select "Clear Dialers" and try again. The result failed, but when I checked the dialer program, I suddenly found a contact program, which was stopped. After I enabled it, the problem was solved.
If you find that a friend who has encountered such a problem is also an operator dial, the contact prompts that dialer has unexpectedly stopped. You can start with the following programs: Mobile Phone main interface-all-settings-Application-all applications under 1. dialer 2. dialer storage 3 save contact information 4 call 5 contacts. Check whether the five programs are unexpectedly aborted. If yes, enable them.
Wu Tiantian [authoritative expert]