Oracle Learning Combat Experience Summary

Recently to another system docking, the other side with Oracle, the bite, from the installation of Oracle, deployment, access to data, technology has been greatly improved, no longer have the sense of mystery and fear.

1, the server is 64 bits, so all installed 64 bits of Oracle and Plsql.

2, if the server more than 32 cores, will not install, card in the replication database 2%. The company server seems to be a 16-core, in the BIOS open Hyper-threading, the system shows 32 cores, supposedly just good, but the same can not be used. Tried to turn off the hyper-thread, in the system to see the change 16 core is not. Finally, the hyper-threading is turned on, and the Msconfig is set to 16 cores in the boot to normal.

3, Oracle installed character set How is UTF16, may have the option to install but did not notice. The client character set is better, the server is a bit troublesome, but there are tutorials on the Internet, on the line to knock once. If the character set is not on the Update table, the Chinese will not go in, garbled.

4. Oracle's several concepts are different from SQL Server, Oracle tablespace, SQL-like library, Oracle's package, SQL-like stored procedure/function, Oracle sequence, SQL-like self-increment;

5, build the table space, build users, assign permissions, guide table, script, etc., to execute under Sqlplus, DOS best right-click Administrator run

6, Sqlplus the end of each line to a semicolon, the words like Shift + ENTER, if copied from other places, the middle can not take a blank line.

7, PL/SQL with a good, basic can like SSMs as handy, its own powerful, but there is no such as sqlprompt-like ox x plug-in assistant (online find a circle did not find). If the update, Del, and so on, the default is the transaction, to commit the transaction. When multiple SELECT statements are selected, SQL Server is vertically discharged, and PL/SQL is a row of rows across. If you want to edit, PL/SQL has a convenient is directly at the end for UPDATE, then point that lock can be directly in the query interface editing. I do not know ssms why not learn from this function, there is a CTRL + 1 or 2/3 and so on, there are similar effects, can be directly modified in the query, but why not simply do the ordinary query interface.

8. The SQL backup file is bak and is imported with SSMs. The Oracle is DMP and is imported under DOS. There is also a PDE in the Plsql with the import table. Originally Plsql seems can also direct DMP, but tried unsuccessfully, in DOS can.

9, in SQL stored procedures to operate Oracle, generally with OPENQUERY, but with parameters to be more troublesome. Direct use of linked servers is also possible, but is said to be less efficient than openquery.

10, Oracle does not have the self-increment key, to use the sequence. If you insert a piece of data, you can temporarily fetch the SEQ_XX. Nextval, if it's more than one, you're going to get a trigger. When it's done, it's just like SQL, and when you insert it, you don't have to worry about that column, it's a SQL self-increment column. Oracle does not know how to go around this big circle, should be able to deal with the background, or get a simple grammar sugar.

11, Oracle does not have the top N of SQL, only rownum, not as easy as SQL.

12, Apache-tomcat to first install JRE/JDK, such as can, after loading to match the system parameters Java_home, I added the spot is not valid, to restart the line ... The server is not easy to restart it is not used? Apache can not install, copy files in, change the configuration can be

13, Apache can not be shared with IIS port, 80 is used by IIS, Apache can only use other ports.

Recently every day overtime, sleep quality has become worse, but also learned a lot.

Oracle Learning Combat Experience Summary