ECCPRD to Q05 system copy 2018.01.25 first part V7000 storage for storage LUN copy
Using a consistency group for LUN cloning
To map a clone volume to a new host
Force the import of the volume group on the new host because the AIX image is
0. database parameter attributesCol PROPERTY_NAME format a25Col PROPERTY_VALUE format a30Col DESCRIPTION format a100Select * from database_properties;
Select * from v $ version;
1. Find the SID of the current session, SERIAL #SELECT Sid, Serial #
0. database parameter attributesCol PROPERTY_NAME format a25Col PROPERTY_VALUE format a30Col DESCRIPTION format a100Select * from database_properties;
Select * from v $ version;
1. Find the SID of the current session, SERIAL #SELECT Sid, Serial #
-- Monitor whether the index is usedAlter index & index_name monitoring usage;Alter index & index_name nomonitoring usage;Select * from V $ object_usage where index_name = & index_name;
-- Calculate the I/O distribution of data filesSelect DF. Name,
Web of Science crawler Actual (POST method)
one. Overview
This crawler mainly through the title of the paper to retrieve the paper, so as to crawl the paper was cited, nearly 180 days download and download the total amount. This is a web of
SQL statement Exercises 50 questions student (Sid,sname,sage,ssex) Student Table Course (CID,CNAME,TID) curriculum SC (sid,cid,score) score table teacher (Tid,tname) Teacher Table Practice Content:1. Check the number of all students who have a "1"
Oracle lock table and unlockSELECT/* + rule */s. username,Decode (l. type, 'TT', 'table lock ','Tx ', 'row lock ',NULL) LOCK_LEVEL,O. owner, o. object_name, o. object_type,S. sid, s. serial #, s. terminal, s. machine, s. program, s. osuserFROM v $
Oracle lock table and unlock
Select/* + rule */S. username,Decode (L. type, 'TT', 'table lock ','Tx ', 'row lock ',Null) lock_level,O. Owner, O. object_name, O. object_type,S. Sid, S. Serial #, S. Terminal, S. Machine, S. Program, S. osuserFrom
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.