Code note (8): Code note

Code note (8): Code note

1.

Find the deadlock process:

Select s.username,I.OBJECT_ID,I.SESSION_ID,s.SERIAL#,I.ORACLE_USERNAME,I.OS_USER_NAME,I.PROCESS FROM V$LOCKED_OBJECT I,V$SESSION S WHERE I.SESSION_ID=S.SID;

Kill the deadlock process:

Alter system kill session 'sid. serial # '; (sid = I. session_id)

If the problem persists,

Select pro.spid from V$SESSION SES,V$PROCESS PRO WHERE SES.SID=xx and ses.paddr = pro.addr;

The sid is replaced by the sid of the deadlock.

Exit

Ps-ef | grep spid

Where spid is the process Number of the Process, kill the oracle Process

2.

For a single shard:

$ ("# Compare"). find ("option: selected"). text (); obtain the value of the selected show option.

$ ("# Compare"). text (); obtain the displayed values of all options.

The Id cannot be the same as the method name. Otherwise, "object is not a function" appears, because the function is also an object.

3.

Do not use AJAX for submission in Form, so remove form

4.

Xshell startup graphical interface:

Start xstart.

 

Click "RUN" and fill in "" in the new pop-up window.

Displayed = 192.168.1.12: 0.0 Export DISPLAY

5.

Case-sensitive shortcut for myeclipse:

Ctrl + shift + Y: lower case

Ctrl + shift + X: uppercase

6.

For the style in tr, display: table-row display: none

You cannot use display: block, otherwise it will be squeezed into a td.

Function ShowInput () {var obj = document. getElementById ('numtr '); if (obj. style. display = 'table-row') // table-row is generated on the page, not block {obj. style. display = 'none';} else if (obj. style. display = 'None') {obj. style. display = 'table-row ';}}

7.

Add a dotted line above:

Style = "border-top: 1px dashed # ddd ;"

Add a dotted line below:

Style = "border-bottom: 1px dashed # ddd ;"

ToggleClss in css:

Implement switchover. If a class exists, delete it. If it does not exist, add it.