Shulou(Shulou.com)06/01 Report--

In fact, it is a very LOW thing to check the documents at the customer site and type according to the orders. the problem is that very often, your laptop and mobile phone are not allowed at the scene, what do you do? Many commonly used commands we need to remember, casually squeeze, spend half an hour every day while typing to understand is a good way to learn.

Can you type down the following diagnostic orders blindly on the basis of understanding?

[root@11g-ocp] # dateMon Dec 24 06:40:05 CST 2018 [root@11g-ocp] # su-oracle$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 24 06:40:12 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP and Real Application Testing optionsSQL > select sysdate from dual;SYSDATE---24-DEC-2018 06:40:18SQL > oradebug setmypid;Statement processed.SQL > oradebug event 10046 trace name context forever,level 12 statement processed.SQL > select count (*) from t COUNT (*)-1SQL > oradebug event 10046 trace name context off;Statement processed.SQL > oradebug tracefile_name;/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2761.trcSQL >! tkprof / u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2761.trc. / 1224.trcTKPROF: Release 11.2.0.4.0-Development on Mon Dec 24 06:41:30 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.SQL >! more. / 1224.trcTKPROF: Release 11.2.0.4.0-Development on Mon Dec 24 06:41:30 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Trace file: / u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2761.trcSort options: default****count = number of Times OCI procedure was executedcpu = cpu time in seconds executing elapsed = elapsed time in seconds executingdisk = number of physical reads of buffers from diskquery = number of buffers gotten for consistent readcurrent = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call*** * * SQL ID: cyzznbykb509s Plan Hash: 2966233522select count (*) from tcall count cpu elapsed disk query current rows-- -- Parse 1 0.00 0.00 0 0Execute 1 0.00 0.00 00 0 0Fetch 2 0.00 0.00 0 2 0 1-total 4 0.00 0.00 0 2 0 1Misses in library cache during parse: 0Optimizer mode: ALL_ROWSParsing user id: SYSNumber of plan statistics captured: 1Rows (1st) Rows (avg) Rows (max) Row Source Operation-- -11 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=65 us) 11 1 TABLE ACCESS FULL T (cr=2 pr=0 pw=0 time=37 us cost=2 size=0 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited-- Waited-- SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 10.31 10.31****OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTScall count cpu elapsed disk query current Rows--Parse 1 0.00 0.00 0 0Execute 1 0.00 0.00 0 0Fetch 2 0.00 0.00 0 01 -total 4 0.00 0.00 0 20 1Misses in library cache during parse: 0Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited-- Waited-- SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 10.31 15.89OVERALL TOTALS FOR ALL RECURSIVE STATEMENTScall count cpu elapsed disk query current rows--Parse 0 0.00 0.00 0 0Execute 0 0.00 0.00 0 0Fetch 0 0.00 0.00 00-- -- total 0 0.00 0.000 0Misses in library cache during parse: 0 1 user SQL statements in session. 0 internal SQL statements in session. 1 SQL statements in session.****Trace file: / u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2761.trcTrace file compatibility: 11.1 .0.7Sort options: default 1 session in tracefile. 1 user SQL statements in trace file. 0 internal SQL statements in trace file. 1 SQL statements in trace file. 1 unique SQL statements in trace file. 62 lines in trace file. 0 elapsed seconds in trace file.SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.