oracle study guide

How can I increase the data loading speed of oracle swap partitions? CASE Environment: OS: linuxdb: oracle10g where the data loading speed of a database is very slow? Lower How can I increase the data loading speed of oracle swap partitions? CASE Environment: OS: linuxdb: oracle10g where the data loading speed of a database is very slow? Lower Case study of

ORACLE self-study note: in Oracle, the three default users sys change_on_install [as sysdba] system managerscott tiger data dictionary can be used to view the system permissions of the current user. select * from user_sys_privs; select * from user_tab_privs; create user wangwu identified by wangwu; grant create session to wangwu; grant create table to wangwu; gra

; # withBigfile Tablespace,you has theoption ofUsing theALTERTablespace statement toResize the datafile. This works because onlyOne datafilecan be associated withA bigfile tablespace.11.to add space to a temporary tablespace1Sql> SelectName,bytes fromV$tempfile; #first Query the V$tempfileView toVerify the CurrentSize andLocation of Temporarydata files.2Sql> Alter DatabaseTempfile ' u01/temp01.dbf ' resize 500m;3Sql> AlterTablespaceTemp AddTempfile ' u01/TEMP02.BDF ' size 5000m;12.toggling dat

Oracle 11g archive log study _ 1, oracle11g ARCHIVE _ 1 Oracle Database Operations are recorded in the redo log for undo (rollback) Or redo (redo) in case of database exceptions ). Redo logs are divided into online logs and archive logs. Oracle has three online log files by default. Generally, these files are filled wi

this SQL statement is select * from Scott.emp. The full name of an object in the database is Schema.object, not user.object. Similarly, if the object's schema is not specified when the object is created, the schema of the object is the default schema for the user. This is like a user with a default tablespace, but the user can also use a different tablespace, and if you do not specify a tablespace when creating the object, the object is stored in the default tablespace, and you need to specify

I have paid a lot of effort to improve it ........ You only need to define the following basic variables in the batch processing to generate clone instances of any Sid to any directory. Set oracle_base = D: \ Oracle10g \ app \ oracle \ product \ 10.2.0Set oracle_sid = tempSet syspwd = OracleSet data_base = D: \ data Not blow: study my scripts and you will get a lot! Known problems: you must underst

Please read firstOracle's purchase Price study (II.)Read moreToday, from a company's technical magazine "XXXX Internet best Practice" in the article "from Oracle to mysql– after the Prism Gate era of distributed database application new direction," the article read about the price of Oracle, this is absolutely true data, so posted out for reference.x86 price per

Oracle still does not take into account the popular Ubuntu release version! The installation of oracle11gr2 is much easier than that of 10gr2, enhancing the Linux Kernel Parameter check and automatic correction function, dependency package check and automatic correction function. Of course, the automatic correction function is not necessarily good. In addition, the installation interface and steps are more intelligent and reasonable than before! F

Oracle Study Notes --- (4) Thu Create a user and authorize the user in the System user:Create user usera identifiedBy usera defalut tablespace test;Grant connect, resourceUsera; 1. Synonyms Private and public PRIVATE: created by a common user. Only the user who creates the synonym can use it.Prerequisites: normal users have access rights to Scott's table EMP.Connect Scott/tiger;Grant

Tags: OracleOracle Study case--aix installing RAC error (ROOTPRE)　Oracle 10g for AIX 5309 rootpre execution times the following error:#./rootpre.sh　Required file./pw-syscall32 is missing.650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/7A/wKioL1Sbhhvzzbe-AAC0CUkG8WQ722.jpg "title=" ( f@o1r@ @L9BQ}kcr[~g]geb.jpg "alt=" Wkiol1sbhhvzzbe-aac0cukg8wq722.jpg "/>Workaround:　　1, download the patch num

To simulate the real environment, consider comparing multiple performance indicators in the case of concurrent use of Bound variables and not bound variables. Statspack is used for testing. If this tool is not installed, refer to Oracle9i database performance tuning guide and reference Release 2. Create Table job_parameters(Jobid number primary key,Iterations number,Table_idx number ); The stored procedure without variable binding is as follows: Cre

;Assigning Database System Privileges1Sql> SelectDESTINCT privilege fromDba_sys_privs;2Sql> Grant CreateSession to user_name#minimally AUserNeedsCREATESESSION toBe able toConnect toTheDatabase.3Sql> RevokeCteateTable from user_name; # toTake awayPrivileges.4Sql> Grant Create Table to user_name withAdminoption; #allows You to GrantA system privilege toAUser andalso give thatUserThe ability toAdminister a privilege. You can does this withThe withADMINOPTIONClause.Assigning Database Object Priv

principle of the statement is to firstwhereAfter the condition has been traced to the data, ifSet, the subquery executes the query to assign the value to the updated field and perform the update. such as: UpdateTable A set a. Field 1 = (select B. field 1 from table B where a. field 2=b. Field 2) where exists (select 1 from table B where a. field 2=b. Field 2). Look up all the data in table A, loop through each piece of data, verify that the data conforms to exists (select 1 from table B where a

Oracle 11g archive log study _ 2, oracle11g ARCHIVE _ 2 Starting from Block 1, the block stores all oracle Operation Records. The block structure is very simple. There are only blocks and blocks:Typedef struct bk {Redo_bh blockhead; uint8_t buf [496];} Redo_bk; Redo_bk The block header is consistent with the one described in the previous article:Typedef struc

Oracle Study--pl/sql Developer software errorThe blog is open at 51cto and CSDN.System environment:Operating system: Windows XP (64)Software: PL/SQL Devoloper 8.04Software, after normal installation, the following error occurred during use:650) this.width=650; "Src=" http://img.blog.csdn.net/20150408162908002?watermark/2/text/ ahr0cdovl2jsb2cuy3nkbi5uzxqvbhf4mdqwnq==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfc

Oracle Study case--rman ORA-19921 errorSystem environment:Operating system: AIX5.3Oracle:oracle 10GR2Error phenomena:The following error occurred when the database was connected via Rman:[11:01:51 [email protected]: ~] $rman target/Recovery manager:release 10.2.0.1.0-production on Mon Jan 19 11:01:53 2015Copyright (c) 1982, 2005, Oracle. All rights reserved.Conne

Oracle study Note 5 --- Table queryThe scott user is used below. The tables used are shown at the bottom.1. view the table structureDesc [Table name] desc emp2. Run the distinct command to remove duplicate lines.3. ExerciseSelect deptno, job, sal from emp where ename = 'Smith ';4. Function nvlIf the value is null, it is replaced by 0.Select sal * 13 + comm * 13 "annual salary" from emp;If comm has no value,

Oracle 11g archive log study _ 4, oracle11g ARCHIVE _ 4 The change content is the core of converting oracle logs into SQL statements, and is also the most troublesome and most changing place. The meaning of opcode is that there are a lot of searches on the Internet. What is really useful to me is addition, deletion, and modification. I don't care about any search

for the size of N;Iv. degree: concurrency, can be nice value, 8/16/24/32 ...*/ --Frees data space after data is deletedALTER TABLE my_table enable row movement;ALTER TABLE my_table shrink space cascade;ALTER TABLE my_table disable row movement; OrALTER TABLE table_name move; --After performing this operation, you need to rebuild the index Select T.num_rows, T.temporary, t.last_analyzed, t.* from User_tables twhere t.table_name = Upper (' gspauresult_tkk0107 '); Select T.num_rows, T.distinct_key

best stability, and returns the number of affected bars. IfwhereIf the fields in the criteria are indexed, the update is more efficient. But when you need to update the fields for the associated table,UpdateThe efficiency is very poor.2.Inline ViewUpdate methodInline ViewThe Update method is to update a temporary established view. such as: Update (select A.join_state asjoin_state_a,b.join_state as Join_state_bfrom t_join_situation A, T_people_info b where a . People_number=b.people_numberand a.