Oracle
??? A man named Sid, who loves to shoot, save and organize photos. Sid's wife named Debbie, who had three sons, Logan, Archie and Chuck. (SID is an Oracle instance, photo is data)
??? He had a big house with butler Simon and maid Pam. I will introduce his family, his house and his hobbies: shoot, collect and show off his pictures.
Now, Sid lives happily-family, friends and vacations. He takes pictu
Manual hot-Standby must be in the archive mode, read-only table space can not be hot-spare, temporary table space does not need to prepare.[emailprotected]> archive log list;——开启了归档Database log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/archOldest online log sequence 1Next log sequence to archive 1Current log sequence 1[emailprotected]> [emailprotec
) Statistics need to authorize the statement Grant create session,connect to DW; GrantSelectOn V_$sql to DW; GrantSelectOn v_$session to DW; GrantSelect, insert on Timdba.uc_logon_off to DW; --(2 Create a temporary table that records all user create table TIMDBA. Z_users as SelectDistinct owner fromall_objects; --(3 generates an authoritative SQL statement Select 'Grant Create Session,connect to'|| Owner | |'; ' fromTimdba. Z_users TwhereT.owner notinch('TIMDBA','SYS','SYSTEM') Union AllSelect
rollback. Scott users can see the inserted record when they view the AA table in the current sessionOpen a new Sqlplus session and look at the AA table and there are no newly inserted records: This is the isolation of thingsCommit a thing in the first sqlplus sessionThe fourth record inserted in the second session cannot be seen after submissionD: Persistence: Once you use the commit command to end a transaction, you must ensure that the database doe
current set of flash regression filesSelect Owner,table_name,tablespace_name from Dba_tables where table_name= ' sys_fba_hist_88707 ';--Determine the name, owner, and location of the history tableInsert, update, and delete operations on the EMP table, and then view the history trace table contents:SELECT * from EMP;[email protected]>begin2 for I in 5..103 loop4 INSERT INTO EMP values (i, ' TEST ', sysdate+i);5 end Loop;6
Pl/sql Procedure: Data reading of Clob field types in Oracle 11g
the database column of the LOB type stores only the locator, which points to the storage location of the large object.
manipulate LOB data with the Dbms_lob package. When reading data with an Oracle field type of CLOB column, only part of the following figure can be read: a
full read of the data
Tags: out get success ons ted Tput res char TNOStored procedures with no parameters sql> Create or replace procedure Get_time is2 begin3 Dbms_output.put_line (sysdate);4 End;5/ Procedure created. sql> exec get_time; 15-may-17 PL/SQL procedure successfully completed. Stored procedure with in parameter sql> Create or Replace procedure Add_dept2 (v_dept_id in number, v_dept_name in varchar2) is3 begin4 INSERT INTO Dept (DEPTNO, Dname)5 values (v_dept_id,
Tags: when case png shang pivot Red data row goto EnglishThe existing table, the original data is as follows: Now you need to query the following results (conditions are: [80,~] Excellent, [60,80) pass, [~,60] failed):The original table is converted with UNPIVOT, and the line changes to select * from CB_SHANGCICB UNPIVOT ("language", "math", "English"), and the results are as follows: The CJ is then matched with the band TT as (select * FROM Score Unpivot (CJ-KC in ("Language", "math", "English"
Tags: ROM performance exploits processing EXE database DBA situation Jobsbackground: The database appears to be long-term execution of the job resulting in excessive resource consumption, the following is expected to quickly locate the job, rapid intervention processing, restore database performance. Long-term operation through the following statements? T more than the database, a. Identify the job number that is being executed and its session numberSELECT sid,job from Dba_jobs_running;Stop exec
different using this parameter to convert#SET Log_file_name_convert ', '----if the log file path is different using this parameter to convert#SET sga_max_size 200M----Set the SGA size#SET Sga_target 125MSET "Db_unique_name" = "Foou" COMMENT "is a duplicate"SET log_archive_dest_2= "Service=inst3 ASYNC REGISTERValid_for= (Online_logfile,primary_role) "SET fal_server= "Inst1" COMMENT "is primary"Nofilenamecheck;Keyword Explanation:Dorecover: Automatic recover operation after restore is completeNof
, and everyone, common learning and growth! reprint Please indicate-java my life (Chen Leixing) Original source: http://blog.csdn.net/chenleixing/article/details/44708533 Finally, seriously read the netizens, the great gods, if there is a feeling I this program ape has a place to say wrong or wrong or you have a good proposal or suggestions or ideas, but also look You kindness alms n seconds to leave your valuable text (message), so that you, I, a
Disk DirectoryDisk directory contains information about all the disks in the disk group. Disk directory information is more detailed than PST. Each disc in a disk group has an entry that is indexed by a number. The file number of disk directory is number 2nd (F2) in each disk group.The fields in Disk directory are as follows:N Disk NameN Failure Group Namen Disk Sizen Disk Free Spacen Disk creation timeMost of the information in disk directory is available in the disk header. Alterdiskgroup ...
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.