1. The statements that have been validated are exactly the same as those already in the shared pool
2. Variable names as consistent as possible
3. Rational use of outer joins
4. Use fewer layers of nesting
5. Multi-use concurrency
The
This article illustrates the method of PHP handling Oracle's CLOB. Share to everyone for your reference. The specific methods are as follows:
1. Write DataWhen using the preprocessing method of PDO, if you use Bindparam () without specifying the
1. Table structure
Sql> desc v$session_event
is the name empty? Type
----------------------------------------- -------- ----------------------------
SID number
EVENT VARCHAR2 (64)
Total_waits number
Total_timeouts number
time_waited number
SELECT * FROM (
select A.id,a.oacode,a.custid,a.custname,a.xsz,a.salename,a.communicationtheme, A.communicationproperty,a.communicationtime,a.productmanager,a.creator,a.createdate from Technology_flow a
where a.oastate= ' normal end '
Union
I. ASM disk and Disk Group management
1. Create a disk group
Create DiskGroup DG2 EXTERNAL redundancy DISK ' orcl:a1′;
NOTE:1) disk name requires uppercase
2) disk name using V$asm_disk.path
2. Adding disks to the disk group
Alter DiskGroup DG2
With alert, the order in which the instance was recovered was found:
1. Roll forward
2, open db
3, Rollback (Note: smon:parallel Transaction recovery tried
After Completed:alter DATABASE OPEN
Smon:enabling Cache Recovery
Mon June 13 16:50:50 20
trunc functionDate is the necessary parameterSyntax format trunc (DATE,[FMT])Select Sysdate from dual; --Current time 2016/9/7 10:32:04select trunc (sysdate) from dual;--take the day 2016/9/7select trunc (sysdate, ' yyyy ') from dual; --Take the
Connected toOracleDatabase11g Enterprise Edition Release11.2.0.1.0Connected asFocususersql>SQL> --the JOB needs to be executed at the command line;Sql> --number of job extraction jobsSql> CREATE OR REPLACE PROCEDURERPT2 --Business 3 as
1.1 Stored proceduresA stored procedure is a named PL/SQL program block that can have parameters and can have several input and output parameters. You can even have multiple arguments that do input and output, but none of them return a value. The
1. How do you solve a lock when designing a database? Lock: The same time period, many users occupy a resource. Rob a train ticket, submit an order but not paid, in order to avoid the deadlock, it can be designed to pre-1, wait a period of
(1) The Code of the Lock table query has the following form:Select COUNT (*) from V$locked_object;SELECT * from V$locked_object;(2) See which table is lockedSelect B.owner,b.object_name,a.session_id,a.locked_mode from V$locked_object a,dba_objects b
Lowering the water level lineAs the database table space is used for a long time, the amount of data continues to increase, and periodically delete some unimportant data informationOf course, the data can be deleted using the DELETE statement, but
Type of table connection: equivalent connection, self-connect, non-equivalent connection, (left and right) outer connectionOne, equivalent connection: by two tables with the same meaning of the column, you can establish an equal join condition.======
--Memory allocationWhen you build a library, you can allocate system memory 50%-80% to Oracle and later adjust to your business.SGA, PGA distribution ratio:Oltp:sga%80, PGA%20Olap:sga%50, PGA%50Mixed: SGA%60, PGA%40--SGA Automatic ManagementThe
I found the PL/SQL pop-up variable box when I updated a field in a table yesterday, and it thought that the field value I wanted to change contained undefined variables. For example, I execute a script: Update t_wlf_config set configvalue = '
1. First, create a (new) User: Create user username identified by password; Username: User name for new username Password: New user's passwordYou can also not create a new user, but still use the previous user, such as: Continue to use the
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service