oracle database 11g sql fundamentals

Label:Previously on the 10g database, if the binding snooping caused the execution plan is slow, want to clear the execution plan of a SQL, let it hard parsing, for a long time did not find a direct operation share pool method (total cannot alter system flush Shared_pool), SQL can only be hardened by parsing the table DDL. Now finally found, using Sys.dbms_shared

Oracle Database Migration-FundamentalsAs a developer, database knowledge must be in our hands. But now the company's database is dedicated DBA maintenance, usually give us an environment address, and then we write Crud SQL. And the company's product requirements can cross th

Oracle 11g Database shutdown causes the crsd process of 10g Database to restart The customer has an Oracle 10 Gb RAC environment. Due to an occasional demand, a database of 11 GB needs to be temporarily started. When we mount the

Tag:cahttpcom use data Transfer from:http://www.360doc.com/content/14/0602/10/4903283_382949382.shtml 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 32-bit Oracle cl

BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you are processing maintenance tasks at night and opening a maintenance window at night is not a good idea, you may want t

: Database version is 11g Operation user must have SYSDBA permission Database parameter timed_statistics must be true IO must be allowed asynchronously, but with the file system, you can set the Filesystemio_options parameter to SetAll Ensure that the data file allows asynchronous IO, which can be confirmed by the following

responsible of resolving IN-DOUBT transactions when Oracle was participating in distributed transactions with M Icrosoft Transaction Server. List of programs:From the Start menu, you will find the newly installed Oracle program:These procedures include: Start and Stop Database is used to control the Oracleservicexe service Backup and Restore

; Dbms_output.put_line ('time is:'| | Mnttime); --Set Serveroutput on/off turns on or off the screen display dbms_output.put_line ('ok, im fine' ); end; /You can save the statement to a file and then call it with the "@/path/filename.sql".Substitution variables:SELECT empno, ename from EMP WHERE deptno= Department number;If the replacement variable provides data for a numeric column, you can drink it directly, or if you provide data for a character type or a date type, you ne

Today, a friend asked me why 11g exp files cannot be imported into 9I? Due to the incompatibility of exp/imp tools, when importing a database of a higher version to a lower version, you need to use the exp/imp tool of a lower version for import and export. A friend used 9i exp to export 11G data and then import imp to 9i. The import is normal. However, I reported

Tags: capacity www. Lib BST ksh opening an ace share pictureReference article:Http://www.cnblogs.com/lightnear/archive/2012/10/07/2714247.htmlHttp://www.cnblogs.com/xqzt/p/5456401.htmlHttp://www.cnblogs.com/anzerong2012/p/7528311.htmlFirst, installation environmentCentOS Linux release 7.2.1511 (Core)Oracle Database 11g Release 2 (11.2.0.4)Second, before the insta

My environment is like this: Win7 64-bit + Oracle 11g + PL/SQL 9.04 Since PL/SQL does not support 64-bit data at the moment, only Oracle client 32-bit data can be used, so you need to download it from the official website: Remember: you must download a 32-bit package) Http:/

Solve the problem that the database cannot automatically collect statistics due to Oracle 11g installation. Recently, it was found that some Oracle 11g databases could not automatically collect statistics. Some View query results are as follows:

for MigrationImpdp ityy_z1_w/z1_w123 directory = DATA_PUMP_DIR network_link = zqxt logfile = ityy. logThe execution result is as follows:Import: Release 11.2.0.1.0-Production on Friday June 28 16:52:03 2013Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.Connect to: Oracle Database 11g Enter

Issue: ORACLE 11g exports a user's own table with the EXP command export and IMP imports 10g found empty table cannot be exportedCause: 11g When you start to build a table, segment is not assigned by default to save space, and when the table inserts the first data, it is redistributed segmentWorkaround 3 ways:1: Insert a piece of data into the blank, and then del

Tags: Oracle 11g database modified character SetOracle 11g Database Modified character SetNls_characterset I set the database to ZHS16GBK while developing the required UTF8According to the development reactionWhen inserting a piec

follows.DELETE from StudentsWHERE SName = ' Zhang Qing cut 'In another case, if the primary key value of the row to be deleted is referenced by another table, for example, the StudentID in the score table refers to the SCODE column in the Student information table, then the referenced row is deleted:DELETE from StudentsWHERE SCode = 22SQL Server will report error messages that conflict with constraintsTip: The DELETE statement deletes the entire record and does not delete only a single column,

How to manually delete an Oracle 11g database in Linux The following steps teach you how to manually delete an Oracle 11g Database in a Linux environment. I installed the Oralce 11G

end of the installation, you will be prompted to execute two scripts: Execute the two scripts again with the root user.Note: When the second script executes, it depends on the information returned. [[emailprotected] ~]#/u01/app/11.2.0/grid/root.sh Running Oracle 11g root.sh script ... The following environment variables is set as:oracle_owner= ORACLE oracle_ho

SetWholeKingdeeEAS DatabaseMove to another environment for development and testing: BackupOracle Database: (you can also PL-SQL through external tools) [Oracle @ rcno8 ~] $Sqlplus SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010 Copyright (c) 1982,200 9, Oracle