Oracle

Previously wrote a line-and-column article: Oracle Simple column changeSql> select * from V$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit

How to use: Set up the ADDM directory below the e-drive and put three files into it addm.cmd,ADDM. sql,myaddm. sql. The user needs to be given two permissions to connect the premises.Grant Select any dictionary to user,-----user for production

Steps1 Installing Oracle 11gOracle official website Download Orcale 11g, "Now still do not use 10g, anyway I did not use" 2 Installing Microsoft Visual studio2012 Expressmicrosoft visual studio2013the use of the installation did not succeed, but it

Http://www.infoq.com/cn/news/2013/07/Oracle-Removes-getCallerClassAs Java developers, we often ignore @deprecated annotations and continue to use them, even though we know that Oracle will get this tag at some point, but still fantasize that these

Login without password: SYS as SYSDBAView all current databases: select */name from V$database;View current database connection User: Show userView all tables for current data: Select table_name from All_tables;View structure: Table structure: DESC

Select table_name from User_tables; The current user's tableSelect table_name from All_tables; All users ' tablesSelect table_name from Dba_tables; including system tablesSelect table_name from dba_tables where owner= ' user name

Oracle remote connection is not directly using the IP plus port form, but using TNS (Personal feeling and ODBC DSN a bit similar, somewhere to save some settings, and then give these settings a name, when used to directly write the name on the

1. Explain The difference between a hot backup and a cold backup and the benefits associated with each. a hot backup was basically taking A backup of the database while it was still up and running and it must being in Archiv E log mode.

1. A tablespace has a table with the extents in it. Is this bad? Why or is not.Multiple extents in and of themselves aren?t bad. However if you also has chained rows this can hurt performance.2. How does the set up tablespaces during an Oracle

In Oracle Pl-sql, the left and right connections can also be implemented in the following wayExample:SELECT Stu_name, class_nameform students, Classeswhere students.classid (+) = Classes.idThe above SQL query uses the right connection.That is, the

First, the database administrator1, SYS and system differences (illustrated with examples)The following two words were spoken at the first:(1) SYS user is superuser, has the highest privileges, has DBA role and SYSDBA, Sysoper database management

1. Change the password(1). Open the Doc Command box type: Sqlplus/nolog(2). Input: Connect/as SYSDBA(3). Change Password: Alter user userName identified by PassWord;(4). Unlock: Alter user userName account unlock;(5). Exit: Exit;2. Open Service(1).

To establish the tablespace and the user's steps: User Create:Create user username identified by "password"; Authorization:Grant create session to user name; Grant create table to user name; Grant create tablespace to user name;

First, dynamic monitoringAn Oracle listener is a stand-alone process that typically starts before a DB instance is started, and dynamically registers its service_names and instance_name with the listener program when the Oracle instance is open.

Remember once Oracle Clusterware installation failure handling1. Environmentcat /etc/5.8 (tikanga) Kernel \ r on an \m2. Description of the problem during the installation of the RAC, the nodes were shut down after successfully installing the grid (

Oracle startup error ORA-00845: MEMORY_TARGETnotsupportedonthissystem Solution Oracle start error ORA-00845: MEMORY_TARGET not supported on this system Possible cause: the ORACLE MEMORY_TARGET parameter exceeds the memory of the oracle server. Eg:

Oracle undo Reading Notes Two parameters related to undo: Undo_tablespace UNDO_MANAGEMENT = auto After oracle 9i, we recommend that you use undo for automatic management; Undo_retention This parameter is used to ensure that the content in the undo

Oracle forced index using HINT First of all, it depends on whether your Oracle optimizer uses RBO or CBO,(1) If RBO is used, it will be performed in the Rule Order.(2) If CBO is used, you can use the HINT method to modify it. Syntax:SELECT/* +

Oracle locks the temporary table statistics and whether the hint can be dynamically collected after the lock The statistical information of the global temporary table cannot be collected. If it is collected, its statistical information must be 0,

ORA-30009: insufficient memory for CONNECTBY operations Today in the 11G environment manufacturing data encountered ORA-30009: connect by Operation memory is insufficient, 10g began to support XML, changed to xmltable can be. SQL> drop table t_range