Oracle

Manually Brush Oracle StatisticsSelect COUNT (1) from Log_trx_detail;SELECT * FROM user_tab_statistics WHERE table_name = ' log_trx_detail ';exec dbms_stats.gather_table_stats (' Ardb ', ' acct_balance ', cascade = TRUE);exec dbms_stats.gather_table_

Recently the Department of testing staff found a problem, said the Oracle user password prompt to expire, ask me what happened?The discovery found that the Oracle user password is only valid for 180 days, communicating with the responsible person

First, the functionFunctions are stored as database objects in an Oracle database, and functions are called PL/SQL subroutines. Oracle processing uses system-provided functions, and users can define their own functions. A function is usually called

 sql>set Colsep '; -The field output delimiter.  sql>set Term {on| OFF}; On: The query results are displayed both in the spool file and in the Sqlplus;  off: The query results are displayed only in the spool file. Sql>set Echo {on| OFF}; Sets

Attention:Host name needs to be checked and the Hosts file modifiedCheck the size of the system table space. If the system does not scale automatically. Need to add data files or modify ask auto-extensionLsnrctl's check (this step I took a long time

Concept:The logical structure of Oracle can generally be divided into:table Spaces (tablespace), segments (segment), zones (extent), data blocks. Oracle consists of table spaces, which consist of segments, segments composed of blocks, and extents

Create tablespace user3 datafile ' e:\test\user3_data.dbf ' size 20M--Table space Initial Size: 20MAutoextend on next 5M maxsize 50M--auto-grow and 5M per expansion, table space Max is 50M--View table Space storage path and informationSELECT * FROM

This article is intended to instruct project personnel to extract the AWR reports of Oracle databases themselves.1. The AWR report extraction for the current connection instance:@?/rdbms/admin/awrrptSql> @? /RDBMS/admin/awrrpt CurrentInstance~~~~~~~

Two different database servers, one user from one database server, reads data from a user under another database server, which can use Dblink.In fact, Dblink and the database in the same view, build dblink need to know the IP address of the database

Operator optimizationIn operatorThe advantages of SQL in write are easier to write and easy to understand, which is more suitable for modern software development style.But SQL performance with in is always lower, and the steps taken from Oracle to

Application Scenarios:According to the keyword query similar to this keyword information, some of the keywords to exclude such as: "Limited", "limited liability Company", "Co., Ltd.", need to create an exclusion thesaurus table;First step: Thesaurus

DeclareV_col1 varchar2 (254);V_col2 varchar2 (254);V_sql VARCHAR2 (1024);Type my_cursor is REF CURSOR;V_cur My_cursor;BeginV_sql: = ' select:1,:2 from dual where 1 =: 3 ';Open V_cur for V_sqlUsing ' col1 ', ' col2 ', 1;LoopFetch V_curinto V_col1,

--Create TABLE spaceCreate Tablespace MySchoolDataFile ' d:/ms.dbf 'Size 50M--Create UserCreate user t87 identified by t87;--Grant permissions (Dba,connect,resource)Grant Connect,resource to t87;--Revoke permissionsRevoke Connect,resource from t87;--

Invalid when querying against incoming parameters in Oracle stored procedureEnvironment: oracle11gRequirements: Query the relevant data based on the parameters passed in as criteriaProblem: Invalid conditionCode:Create or Replace procedure XXX

Oracle Dynamic Cursor Declarev_col1 varchar2 (254); v_col2 varchar2 (254); v_ SQL varchar2 (1024); type my_cursor is ref cursor; v_cur my_cursor; beginv_ SQL: = 'select: 1 ,: 2 from dual where 1 =: 3'; open v_cur for v_sqlusing 'col1', 'col2', 1;

Oracle job process solves the problem of no automatic execution It's easy to create a job. Here we mainly talk about the problem that the job is not automatically executed according to the specified time.Solution: 1. Run the job Begin

Oracle local database connection* ****************** Create a tablespace and User Name/* Step 2: create a data table space */Create tablespace flxLoggingDatafile 'e: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ flx. dbf'Size 50 mAutoextend onNext 5

Oracle Stored Procedure record in project-common syntax memoOracle Stored Procedure record in project-common syntax memo   You need to write an oracle stored procedure in the project. You need to collect a complex query (involving multiple tables)

Oracle Development Environment ConstructionI. software preparation address: installation package on the oracle Official Website: because of personal learning, you can install the server without a client. A total of two compressed files are extracted

Use OracleRac11gR2's new feature renamedg to change diskgroupnameEnvironment Description: AIX7.1 + dual-node Oracle Rac 11.2.0.3Because this Rac is not installed by your own department, it is installed by the Development Department and is now