quadro 2000m

The EXP export tool compresses the data backup in the database into a binary system file. Can be migrated between different OSThe Imp Import tool imports binary system files formed by exp into the database.I. EXPORT TOOL EXPIt has three modes:A. User mode: Export all user objects and data in the object;B. Table mode: Export all tables or tables specified by the user;C. Entire database: Exports all objects in the database.$exp oa1/[email protected] file=d:/all.dmp grants=yDescription: Export all

-database version information SELECT * from V$version; --Database default information SELECT username,profile,default_tablespace,temporary_tablespace from Dba_users; --Database character setting information SELECT * from Nls_database_parameters; --store case-sensitive data, but the index is case-insensitive CREATE TABLE tab (col1 VARCHAR2); CREATE INDEX idx1 on tab (UPPER (col1)); ANALYZE TABLE a COMPUTE STATISTICS; --Adjust the tablespace without adding data files ALTER DATABASE data

/data3306 Pid-file =/usr/local/mysql-5.6.30/data3306/mysql.pid Log_error=/var/log/mysqld.log #set binaryloggingisrequiredforreplication Log-bin=mysql-bin Binlog_cache_size =32m # Event_schedulershutoffinmysqldslave event_scheduler=1 Binlog_format=row Expire_logs_days=3 #setslowlog slow_query_log=1 long_query_time= 2 #set Characters Character_set_server=utf8 #set case sensitive Lower_case_table_names=1 #set innodbparams innodb_data_home_dir=/usr/local/mysql-5.6.30/data3306 Innodb_data_file_path

Description1, red indicates key parameter2, "Global Cache", "Thread cache", the global cache is all thread sharing, the thread cache is each line thread attached the data when the creation of a thread ( if not set up a thread pool), if there is a 200 connection, that is 200 threads, if the parameter setting value is 10M, then the parameter value is 10 *200=2000M=2G, it is possible to eat down memory, so the thread cache is not like the global cache as

Label:Description 1, red indicates key parameter2, "Global Cache", "Thread cache", the global cache is all thread sharing, the thread cache is each line thread attached the data when the creation of a thread ( if not set up a thread pool), if there is a 200 connection, that is 200 threads, if the parameter setting value is 10M, then the parameter value is 10 *200=2000M=2G, it is possible to eat down memory, so the thread cache is not like the global c

* from Nls_database_parameters; Get Oracle versionSELECT VALUE from v$system_parameter WHERE name = ' compatible '; Store case-sensitive data, but the index is case-insensitiveSometimes you might want to query a database for some independent data, you might use UPPER (..) = UPPER (..) for case-insensitive queries, so you want the index to be case-insensitive and take up so much space, this statement will solve your needs.CREATE TABLE tab (col1 VARCHAR2 (Ten)); CREATE INDEX idx1 on

\ADMINISTRATOR\ORADATA\ORCL\mytisjs.dbf ' (mytisjs.dbf in front of the path for you to query out the path, in fact, the path can be written anywhere, just and the previous database in the same location is better ) size 2000m on Next 500m maxsize 10096m 3. Create a temporary table space Create Temporary tablespace mytisjs_temp ' E:\APP\ADMINISTRATOR\ORADATA\ORCL\mytisjs_temp.dbf ' size 500m on next 500m maxsize 2048m e

Label: a while ago, to do Oracle restore of the database. Because it's a rookie, I didn't use oracle database. So many places do not know how to start. in the SQL Server database restore, nothing more than an additional database . Or use a script to restore it. but in Oracle in the database restore, there is no such visual tools (self-installed client does not count). after the Oracle Server is installed, the restore of the database must use dos command-line operations. Oracle do not unde

self Baidu.16, in this I divide the disk into the/boot 200m used to do the system boot, 5000m to the root directory, 5000m to home directory, 5000m to USR Software installation directory, 2000m virtual memory, the rest of the later backup.17. Click Format18, write the modified option to disk, Partition complete.19, here default, equivalent to the choice of Windows C disk for the system disk meaning, you can also customize the name of the system start

DIR1 Displays the total capacity of the directory Dir1, measured in K-bytesFind File LookupCommand format: Find dir-name filename commandExample:Find. -name Hello-print look for the current directory and all subdirectories inside calledHello's documentation.Find. -ctime +7-print Find documents that have not been changed within seven daysFind. -size +2000m-print to find documents larger than bytesFind/tmp-user b1234567-print documents belonging to b12

db_file_multiblock_read_count to allow more blocks to be read in one IO, which Can bring the same benefits as the size of the block.7. Set the sga_max_size to 25% to 50% of the primary memory size If you use the Sga_max_size parameter, the general experience is to initially allocate 20% to 25% of the main memory to it. If sga_max_size If 1 If the sga_max_size is set to 2000M and the db_cache_size is set to 9M, then db_cache_size is rounded to 16M (b

VirtualBox are available, and here we use VMware.Vii. installation of Linxu7.37.1. Download lunux7.3 disc image (r.aminglinux.com)7.2. Using VMware, install the Linux7.3ios disc image7.3. Virtual Machine Network modeBridging: It's like your virtual machine and host are connected to a router.Nat: Just like your virtual host is just surfing the internet through the host, its cyberspace is independent. (We'd better use this connection so that we don't have to change the configuration of the virtua

User Deployment(Take Bb_hs_pos as an example)Start the database first under Oracle user Su–oracleDbstartDeploy user directory, execute useradd-g dba-s/bin/bash-m with root user Bb_hs_pospasswd Bb_hs_posBb_hs_pos modify the. Bash_profile under Bb_hs_pos User, add the following configuration information at the end of the file(with Oracle users): exportld_assume_kernel=2.4.1Exportoracle_base=/home/oracleexportoracle_home=/home/oracle/product/10gExportoracle_term=xtermexportoracle_sid=ora10gExportnl

Linux is an open source software. The release versions are SlackWare, SuSE, Debian, Ubuntu, RedHat, CentOS, Fedora. One of the most used is radhat,centos. So this is an example of a centos6.6 version of the teaching. The original download 6.5 version of the installation is good for the Yum update upgrade to 6.6 version. When you create a new virtual machine, select other, and do not select mirroring first.HDD 20G, Memory needs 1G, less than 1G no half-open graphics.The network adapter sets the b

To view disk space usage:Df-hView the space occupied by the first level directory under the root directory:Du-h--max-depth=1/Find files larger than 2000M in the root directory:Find/-size +2000mFind files that have been deleted, but are still occupied by the process:Lsof |grep deletedReview the process information based on the process ID found in the previous step:Ps-ef | grep pidServices to restart the process:Use the kill-9 PID command to stop the pr

The previous article describes how Php-excel-reader reads Excel files because it requires that data such as Excel: The new database table is as follows: --Database: ' Alumni ' --The structure of the table ' alumni ' CREATE TABLE IF not EXISTS ' alumni ' ( ' ID ' bigint not NULL auto_increment, ' gid ' varchar DEFAULT NULL COMMENT ' file Number ', ' student_no ' varchar DEFAULT NULL COMMENT ' School Number ', ' Name ' varchar (#) DEFAULT NULL, PRIMARY KEY (' id '), KEY ' gid ' (' gid ')

: Export two table emp,dept from Scott user to file/directory/scott.dmp$exp Scott/tiger tables=emp query=\ "where job=\ ' salesman\ ' andsal\Description: Add the query condition of the EMP in exp inside job= ' salesman ' and sal(but I personally rarely use this, or after the conditions of the record to generate temporary tables, then exp will be more convenient)$expparfile =username.par file=/directory1/username_1.dmp,/directory1/username_2.dmpfilesize=2000m