Oracle

1 Node 2 use DBCA to delete a node 2 node 1alter database disable thread 2; 3 Node 1 Verify that a node database has been deleted [03:49:06 Oracle (DB) @rac1 ~]$ srvctl Config database-d proddatabase Unique name:proddatabase name:prodoracle home:/u01

Here is the conversion function To_char Select To_char (sysdate, ' yyyy ') from dual;Select To_char (sysdate, ' Fmyyyy-mm-dd ') from dual;Select To_char (sysdate, ' Yyyy-mm-dd ') from dual;Select To_char (sysdate, ' DDD ') from dual;

OEMs are a graphical database administrator tool. It provides a centralized system administration tool for database administrators, as well as a tool for managing, diagnosing, and debugging multiple databases, a tool for managing multiple network

Nls_lang format:Nls_lang = Language_territory.charsetThere are three components (language, geography, and character set), each of which controls the characteristics of the NLS subset. whichlanguage specifies the language of the server

Dblink's primary role is data access between two databases (1) Global_name View select * from Global_name; (2) View local global_names parameters show parameter Global_ Namesname TYPE VALUE-------------------------------------------------------------

--Discover those SQL runs a lot of Parseselect Sql_text, parse_calls, executions from V$sqlarea order by Parse_calls desc;-- The total parse condition of SYS is select name, value from V$sysstat where name is like ' Parse count% ';--cpu space and

Oracle provides a inverted inverted function reverse, but this function cannot be grouped upside down, this article provides a function that can be grouped upside down, as follows:CREATE OR REPLACE FUNCTION reverse_f (p_str VARCHAR2, P_delimiter

Statistical information Collection1: Create Analysis Table$ cd $ORACLE _home/rdbms/admin$ sqlplus/as SYSDBA > @utlxplan. SQL2: For convenience, you can create a synonym table ( by default only the SYS user can use )sql> create public synonym

Union and UNION ALL Select Deptno from empUnionSelect Deptno from dept;Equivalent to the two result sets, union removes the duplicate, union all retains the duplicate2. IntersectSelect Deptno from empIntersectSelect Deptno from dept;This

User Doiido when connecting Oracle, the following error is reported:Ora-28000:the account is lockedView user Status sql> conn/as sysdbaSql> SELECT username,account_status from Dba_users;USERNAME account_status-------------------

"Turn from" http://www.cnblogs.com/netsql/articles/1745978.htmlNote the point:1. If it is opened in a tool such as PL/SQL, directly modify the following code [ Italic bold section] to execute2. Ensure that the path exists, such as

Concept of view : Extracting logically related data collections from a tableView-related concepts :1. View is a continuation table2. Views are based on existing tables, and the tables on which the views are built are called base tables.3. The

connecting to Oracle often requires the installation of hundreds of megabytes of Oracle clients, which can be cumbersome. This first describes how to connect to an Oracle database with Plsql by using a thin client that does not require installation.

Permissions: Sub-system Permissions and Object permissions (object permissions are permissions for action tables, views, and so on)Roles: Sub-predefined roles and custom roles, roles are assigned a series of permissions.Give the User a role: The

Prerequisite: You must have DBA authority and have permission to query tablespace usage--View Table space usageSelect UPPER (f.tablespace_name) "Table space name",D.TOT_GROOTTE_MB "Table space size (M)",D.tot_grootte_mb-f.total_bytes "used Space (M)"

Can't login em, execute emca-config dbcontrol db do not know always default 1522 port number, helpless, Google some, from the second step below to start execution ... (My monitor is fine)1. Open the net config Assistant in the Oracle Configuration

[Ubuntu14.04] Build a PHP5 + Apache2 + Oracle environment RT A recently developed project where the database uses oracle. Oracle itself supports Red Hat, which is not good for ubuntu. If ubuntu needs to install oracle, the system itself needs to do

Do not install Oracle client to use PLSQL, oracle client plsqlTo connect to Oracle, you often need to install an ORACLE client of hundreds of megabytes, which is very troublesome. This section describes how to connect to the oracle database by using

Oracle Auto-start By default, Oracle databases in Linux do not start on their own, but many times we need to start the Database on their own, so we need to set the settings as follows: System Environment: CentOS 6.5 ORACLE version: 10.2 1.

Oracle Storage StructureOracle Storage StructureStorage Structure-Table Storage StructureTable space: A table space is composed of one or more files. The space capacity of a table space is the total size of multiple files.Create an intermediate