Oracle

--View disk statements that consume the most disk read and write ratesSELECT *From (select v.sql_id,V.child_number,V.sql_text,V.elapsed_time,V.cpu_time,V.disk_reads,Rank () Over (order by v.disk_reads Desc) Elapsed_rankFrom V$sql v) awhere

We need to delete the child nodes when we delete the parent node, and the child nodes are also deleted, so we need to loop the function until there are no child nodes.Print out all child nodes under a node as followsTable structure is a traditional

with the pagesize command, you can set the size of each page to control the amount of data displayed on each page. Syntax format of the pagesize commandAs follows:Set pagesize nWhere the parameter n represents a positive integer for each page size,

1.how to find invalid status stored procedure and recompile them?SELECT object_name, status from user_objects WHERE object_type = ' PROCEDURE ';Alter procedure Schme.procedurename Compile;Lack of practice is not a complete study of learning,

Use the Linesize command to set the number of characters a row of data can hold, with a default number of 80. If the value of the linesize is smaller,Then a row of data in the table will need to be displayed on the screen, and if the value of

SQL Indexing technology sharing - content Planning ORACLE Execution Technology 1) What is the implementation plan? 2) How does the execution plan analyze the best path? 3) use PL/SQL to demonstrate how to view the execution plan? 4)

Use the spool command to copy the results of the output from the Sql*plus to a specified file, or the results of the querySend to the printer and use the spool off command directly.The syntax of the spool command is as follows:Spool [file_name

OracleCBO evaluates like data volume There are two forms of Like Statement, which is evaluated by 5% of the total data volume. SQL> drop table test purge; SQL> create table test as select * from dba_objects; SQL> exec dbms_stats.gather_table_stats

Oracle edit command Use the edit command to copy the content in the SQL * plus buffer to an afiedt. buf file, and then start the default editor in the operating system to open this file, and the file content can be edited. In Windows, the default

How to adjust the performance through the internal mechanism of the Oracle Buffer In this advanced Oracle tutorial, I will discuss the internal mechanism of Oracle Data Buffer-Oracle uses this memory to prevent unnecessary data blocks from being

Calling the Oracle stored procedure in javaCalling the Oracle stored procedure in java This article describes how to call the stored procedure of Oracle through java. 1. Write the Stored Procedure Create or replace procedure sp_pro3 (sp_name VARCHAR2

Calling the Oracle stored procedure in javaCalling the Oracle stored procedure in java This article describes how to call the stored procedure of Oracle through java.1. Write the Stored Procedure Create or replace procedure sp_pro3 (sp_name VARCHAR2,

Auto-incrementing sequence and stored procedure in Oracle Oracle does not have auto-increment columns. In this case, you must manually write a method or use a sequence or trigger. Easy to use (personal habits) 1. create sequence salary_seq2.3.

Oracle modify listening port 1521 In oracle, the default listening port number is 1521. Once someone scans this port number, it will know that this server is an oracle database server. This poses an extremely high security risk, how to modify the

Oracle start commandThe start command can read the content in the file to the buffer, and then run the content in SQL * PLUS. the syntax of the start command is as follows:Start {url | file_name}The url is used to specify a url address, such as http:

Oracle get commandOracle can use the get command to read file content to the buffer zone,The get command syntax is as follows:Get [file] file_name {list | nolist]File_name indicates an external file, which is included in the SQL * plus buffer.List

Oracle user unlock Connect first SQL * Plus: Release 12.1.0.2.0 Production on Thursday February 12 15:40:422015 Copyright (c) 1982,201 4, Oracle. All rights reserved. Enter the User name: system Enter the password: Last Successful Logon Time:

Oracle date operations1. Obtain the last day of a month. SELECT TO_CHAR(LAST_DAY(TO_DATE('20140125', 'yyyymmdd')), 'yyyymmdd') LASTDAY FROM DUAL 2. Obtain the last day of the last month: select to_char(add_months(last_day(to_date('2008-08-08','yyyy-

ORACLE11GDataGuard role conversion1. ORACLE login uard Role SwitchingDataGuard已经是现今标准的主流容灾方案，由于日志传递对于网络适应程度强，且可以采用同步实时的传递方式和异步延迟的传递方式，甚至可以成为远程的异地容灾方案。不管用于何种用途，DG都免不了要进行角色转换，即将standby 数据库切换为primary数据库，角色转换分为：switchover和failover两种2. similarities and

Oracle10gLsnrctl does not reflect that the database cannot be connectedSymptom Description: The oracle version used is 10.2.0.1.0 in linux. If lsnrctl status is entered on the command line interface, no response is returned. If lsnrctl stop is