oracle database 11g sql fundamentals

'*.diagnostic_dest= '/u01/app/oracle '*.dispatchers= ' (protocol=tcp) (SERVICE=BBDGXDB) '*.fal_client= ' BBDG '*.fal_server= ' Bbsvri1 '#*.log_archive_config= ' dg_config= (BBSVR,BBDG) '#*.log_archive_dest_1= ' Location=use_db_recovery_file_dest valid_for= (all_logfiles,all_roles) db_unique_name= BBDG '#*.log_archive_dest_2= ' Service=bbsvr valid_for= (online_logfiles,primary_role) Db_unique_name=bbsvri1 '*.log_archive_format= ' Arc_%t_%s_%r.arc '*.l

In Oracle 11 g2, duplicating a database has two methods: 1. Active database duplication2. Backup-based duplication The advantages of using duplicate for a database are:Test backup and recovery proceduresTest an upgrade to a new release of Oracle DatabaseTest the effect of ap

1. Online segment shrink recycles idle space that uses fragments below the high water level line in the Oracle database segment. Segment shrink has the following benefits: 1. compressed data will lead to better cache utilization, resulting in better online transaction processing (OLTP) performance. 2. During full table scan, fewer blocks are required for shrinking data, which in turn leads to better perform

Tags: blog http os io strong file data forNothing to do, want to re-install Oracle 11g, recorded as follows:(1) First stop all Oracle services in the service;(2) Start, oracle-oradb11g_home1, Oracle installation products, Universal Installer, click "Uninstall Product"-"Expan

reference) "I know the results rowid would be sorted by"-No, they is not. The rows would be returned in any order the database thinks are the most efficient. There is no, absolutely no, guarantee this rows is returned in any specific order unless your specify an ORDER BY . The only-to-get-a specific order is ORDER BY -to-use. Http://stackoverflow.com/questions/20186673/in-oracle-

Tags:httpcom use data html cti This you need to install a 32-bit Oracle client to use Plsql, but at this time sqlplus can not be used, hehe . I tried the following method, successfully, haha 1) install Oracle 11g 64-bit 2) Install the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0) :http://www.oracle.com/

); (4) Perform database update operations, such as deleting several records and adding several records; (5) Close the database (SHUTDOWN IMMEDIATE); (6) Copy all previously saved data files, control files, online redo log files to the original location, overwriting the original files; (7) Restart the database (startup); (8) Query the data to see if the updated da

1. application scenarios:Environment:Host Name ip vip sid DiskGroupDb1 1.1.1.1 1.1.1.11 bkjia DATA1Db2 1.1.1.2 1.1.1.12 bkjiadb DATA2Expected results:Db1 and db2 can be backed up to each other. Here db1 is used as the master database, and db2 is used as the slave database to explain how to mount the disk groups DATA1, DATA2, and, all running instances bkjia and bkjiadb use virtual IP addresses as client acc

/bp_oracle Directory=dump_dir dumpfile=bp_oracle.dmp version=10.2.0.1.0--Remove TablespaceDrop tablespace bp_oracle including CONTENTS and datafiles;--delete the user, and execute the statement carefully, the Cascade deletes all objects under that user.Drop user bp_oracle cascade;--Modify User passwordAlter user bp_oracle identified by bp_oracle; --Export database with no versionEXPDP bp_oracle/bp_oracle schemas=bp_oracle dumpfile=bp_oracle20120221

Tags: Oracle 11gORACLES11 the startup state of the databaseORACLE11G must go through three states at boot time: Nomount,mount,open.Nomount: Only open the DB instance in this state, read the parameter file.MOUNT: Opens the control file according to the parameter file information. Reads various information in the control file, such as the data file location, the log file path, but does not open the data file.Open: Opens the data file and carries out a s

Tags: silent installation of Oracle 11g database under LiunxSed-i ' $a fs.aio-max-nr = 1048576 '/etc/sysctl.confSed-i ' $a fs.file-max = 6815744 '/etc/sysctl.confSed-i ' $a kernel.shmall = 2097152 '/etc/sysctl.confSed-i ' $a kernel.shmmax = 536870912 '/etc/sysctl.confSed-i ' $a kernel.shmmni = 4096 '/etc/sysctl.confSed-i ' $a kernel.sem = 32000 '/etc/sysctl.confS

1. create necessary Directories D: \ app \ Administrator \ admin \ jxg12_20104350121 2. Create a database file storage directory under oradata D: \ app \ Administrator \ oradata 3. Create the initialization parameter file D: \ app \ Administrator \ admin \ jxg12_20104350121 \ scripts \ init. ora ######################################## ###################################### # Copyright (c) 1991,200 1, 2002 by Orac