oracle 11g tuning

Oracle 11g Data Loading Methods Data Loading: SQL * LOADER External table Import/Export SQL * LOADER: SQL * LOADER is an Oracle tool that can load data from external data files to databases. The command for running SQL * LOADER is sqlldr. Two Sqlldr usage methods: 1. Use only one control file, which contains data 2. Use a control file (as a template) and a

Selection:32-bit memory is a bottleneck, it is already 64-digit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In the virtual machine installation, use the Hostonly way to set up the networkNote: The Internet adapter will be able to set up ICS (Internet Connection Sharing) to VMware network Adapter VMnet1So for the virtual machine, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24

64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle 11g, plsql11g64-bit Windows 8/7 32-bit PL/SQL connection 64-bit Oracle 11gNote: Oracle's oci. dll is 64-bit after installation, while 32-bit application PL/SQL Developer cannot loadSolutionStep 1: Download the Instant Client for Microsoft Windows (32-bit) package address: http://www.oracle.com/technetwork/t

Label:1. Environmental information:System:Oracle-linux 5.7 Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-productionCORE 11.2.0.3.0 ProductionTNS for Linux:version 11.2.0.3.0-productionNlsrtl Version 11.2.0.3.0-production Main Library: 192.168.12.31 Sid:yoon Db_unique_name:yoonLibrary: 192.168.12.231 Sid:yoon DB_UNIQUE_NAME:YOONDG 2. Check if DG is installed:Sql> SELECT * from v$op

Then unzipClick setup.exeI'm using the default installation D drive.The database password is Wangxiaofei.NextFirst, on your own Windows 7 flagship edition, Oracle 11g prompts you for errors when "product-specific prerequisite condition checks":In, we can see that when Oracle checks the operating system compatibility, it does not pass the check, at this time, we c

Oracle Performance tuning is a broader and somewhat more complex topic, and the biggest problem for ordinary DBAs is where to start and what to do. All the information you know may be someone (a user) who reports a problem with the performance degradation of an application or query, and where do you start when faced with such a problem? Oracle's tuning approach

/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc5.d/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc0.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc1.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc6.d/k10oracle11Effect and execution Chkconfig--add Oracle11 is the same.Here, so the setup process is over, let's test it out:#cd/ETC/INIT.DSH oracle11 startAfter executing, look at the Oracle11log file in the/var/log directory, is there a script to start the branch output information?SH oracle11 s

Tags: open fast overwrite selected format finish home record Select1. Find the Repository control file path FirstFind the path to the control file on the repository first, as in the main library, but just in case, check is OK. Sql> select name from V$controlfile;NAME--------------------------------------------------------------------------------/oracle/app/oracle/oradata/powerdes/control01.

/[emailprotected] /service Take bash for example, such as the above password [email protected] situation, at this time need to write:sqlplus username/\ "[email protected]\ ] because "itself is a meta-character in bash. To pass "itself as part of a reference to Sqlplus." It must be escaped. finally recommend a ORACLEDBA book, the book has a lot of Oracle terminology and principles of very clear, just a slightly rough translation, it is recommended to

1, download Oracle 11g R2 for Windows version Download Address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html This includes two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip 2, the two compressed packets to the same directory, that is, "database", and then click the Extract directory under the "setup.exe" file: 3. In the "Config

following options: ASM This is the preferred storage option for Oracle and is the only configuration supported in the RAC Standard Edition OCFS2 Bare devices are not recommended, not only because they are deprecated by the new Linux kernel, but also not supported in Oracle 11.2 Network File System (NFS) The Red Hat Global file System is only supported in Red Hat and

Oracle oinstall 30416896 Jan 22:05 temp01.dbf-rw-r-----1 Oracle Oinstall 110108672 Jan 24 22:05 UNDOTBS01.DBF-RW-R-----1 Oracle oinstall 26222592 Jan 22:05 users01.dbf[[emailprotected] prod]$ Exit[emailnbs p;protected]> ALTER DATABASE Open;alter database Open*error at line 1:ora-03113:end-of-file on communication channelpr Ocess id:2951session id:125 Serial Numb

the following query: [Email protected] rc.d]$ find-name ' k*oracledb ' ./rc2.d/k10oracledb ./rc4.d/k10oracledb ./rc6.d/k10oracledb ./rc1.d/k10oracledb ./rc0.d/k10oracledb [Email protected] rc.d]$ find-name ' s*oracledb ' ./rc5.d/s80oracledb ./rc3.d/s80oracledb [Email protected] rc.d]$ chkconfig--list oracledb OracleDB 0:off 1:off 2:off 3:on 4:off 5:on 6:off As in the previous OracleDB file, the first two lines of comments may not be written, you can use the file link: # ln-s/etc/init.d/oracledb

does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web

　　 1. First download the oracle 11g x64 bit package from the official website. : Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip 2. Installation Package detection and Installation [root@struggle ~]# rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-commo

: # MV ORACLE/ETC/INIT.D # chkconfig--add Oracle # chkconfig--list Oracle view, so that Oracle can be switched on and off before shutdown immediate Rebooting the system, you can see starting Oracle in the boot process because we set the priority to 99, which is typically the

Oracle Database 11g performance optimization strategy-optimizing Table PerformanceIntroduction 1-1 Create a database with optimal performance problem description www.2cto.com you realize that when you first create a database, there are some attributes (if enabled) it will have a long-term impact on the performance and availability of tables in the database. Specifically, when creating a database, you need t

, Plsql Developer, bat. Can not be a bat to plsql developer to hack down, is Oracle development did not think of Win7? Baidu Baidu 、、、、 have the following method, the following method is I copy from the various versions out, but completely feasible, I personally tried.Disclaimer: The picture I intercepted from the Internet, because I did not install it, looks a little bitFirst of all: my machine is win7 64-bit flagship version, 64-bit

Tags: url sage png virt same 9.png Nanjing e-Mail The October Nanjing Rainy Weather Library spent a little more about the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's shoes to improve the installation efficiency.Mutual convenience and common progress! Oracle Two files There is a need to

Oracle Database 10g Performance Tuning tips and techniques is recommended. For Oracle performance test, diagnosis, analysis, and optimization, see! Chapter 2 Basic index principles (beginner developer and beginner dBA). For Oracle index optimization, refer! Chapter 4 tuning