Oracle

The processes in Oracle are divided into three categories: User processes, service processes, background processes. The background process with the start of the instance started, they are mainly to maintain the stability of the database, the

1. * Number of execution efficiency caused byMinimize the use of SELECT * to query, when you query using *,The database is parsed and the * is converted to all columns.Select COUNT (si.student_id)From Student_info si (student_id as index)AndSelect

Oracle's package packages can have a lot of storage, which can be called directly in Java via the package's total gateway.Java calls Oracle's package codepublic boolean cal () Java.lang.Exception {CallableStatement cstmt = null; String procedure = "

Web Search--The first step is to view the locked tableSelect B.owner,b.object_name, B.object_id, L.session_id,l.locked_modeFromV$locked_object L, Dba_objects bwhere B.object_id=l.object_id;--Step TwoSelect Do.OBJECT_ID, do.object_nameFrom

SELECTUPPER(F.tablespace_name) Tablespace name, D.TOT_GROOTTE_MB table space Size (M), D.TOT_GROOTTE_MB-F.total_bytes "used Space (M)", To_char (ROUND ((D.TOT_GROOTTE_MB-F.total_bytes)/D.TOT_GROOTTE_MB*100,2),‘990.99‘"Use ratio", f.total_bytes "free

1. Base of the database: DB, DBMS, DBA, DBS. The application interacts directly with Oracle, which contains two parts of DB and DBMS.2. The early database model is: Hierarchical && Mesh-type relational database--Object relational database system

Data table: Table:textID DateTime Name Value1 2015-03-1 Zhang 33,4002 2015-03-1 Li 42,5003 2015-03-2 Zhang 32,3004 2015-03-2 Wang 52,100I want to get the value that is the maximum time value of name Zhang SanIn general, we use the time to check out

1. Overview of the ViewA view is actually a query SQL statement that displays related data in one or more tables or other views. The view uses the results of a query as a table, so the view can be thought of as a stored query or a virtual table.

There are two ETL business machines deployed PowerCenter in the production environment, and the recent discovery cannot connect to the ETL service through the client.The initial suspicion is that the powercenter is dead or the database has

[What is an index]In a relational database, an index is a data structure associated with a table that makes it faster to execute a query's SQL statement. In fact, the index is like a book directory, we can quickly find the content according to the

[Gu JIU Jian] Oracle knowledge point sorting (5) Table, View, and oracletable of common database objectsLink navigation for this series: [Lone sword] Oracle knowledge point sorting (1) Table space and users [Gu JIU Jian] Oracle knowledge point

Hibernate connects to the oracle database, and hibernateoracle All of the following operations are performed properly when you have successfully installed the oracle database and the java development environment is normal. If not, configure the

Creating large file tablespaces in oracleLarge file tablespace is a new tablespace type introduced by oracle10g and later versions. It is mainly used to solve the problem of insufficient storage of large files. Unlike Common tablespaces, large file

Temporary tables, external tables, and partition tables in OracleTemporary tables, external tables, and partition tables in OracleTemporary table In Oracle, a temporary table is "static". It only needs to be created once like a common data table.

Oracle subquery, create, and manage tablesSummarySubquery: Single Row subquery: returns a single rowUse Single Row comparison OperatorsMulti-row subquery: multi-row subquery returns multiple rowsMultiline operators:IN, ANY, ALLIf the query result of

Oracle basics-Index 1. What is indexing? A: indexes are used in databases to improve query efficiency. Supplement: too many indexes can greatly reduce the efficiency of DML statements. The indexing principle is to create fields that are frequently

[Oracle] Sequence object usage Sequence: oracle can generate primary keys through sequences.1. Create a sequence Create table Foo (foo_id number (11), foo_value varchar2 (50), constraint FOO_PK primary key (foo_id )) Create sequence DDL Create

Oracle flash back flashbackFlash back: fixed a logic error and returned from the current point.1. There are dedicated flashback logs stored in the FIA, but they are only used in the database. 2. If a full database flash is performed, it is

Oracle users unlock lockd The following error is reported when the user doiido connects to oracle: ORA-28000: the account is locked View user statusSQL> conn/as sysdba SQL> SELECT username, account_status FROM dba_users; USERNAME

Tomconrefused solution for tomcat7 connection to oracle The server. xml configuration of tomcat is as follows:   The error message is as follows:     java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870592)