Oracle

On that day, I received a task to install an Oracle client with the sqlplus function in the local testing environment. The environment is HP-UX, anteng. I found out that the installation method provided on the Oracle official website is not

1. Create a tablespace   Create tablespace data01 datafile 'd:/oracledb/data01.dbf' size 500 m   2. delete a tablespace Drop tablespace data01 including contents and datafiles;   3. Modify the tablespace size Alter database datafile

Connect to the Database SQL Server Data Source = PC-YZC \ sqlexpress server nameInitial catalog = News Database NameSQL Server AuthenticationUser ID = sa User NamePassword = 19920514 Password Start cacheCd c: \ WINDOWS \ Microsoft. NET \

In a previous articleArticleIntroduced that the additional Association has a great impact on SQL, so in the SQL audit work, there are quite a lot of attention to table Association, if redundancy can optimize table association, we try to do some

Oracle databases are widely used in different regions. Therefore, professional Oracle staff must understand how network connections affect database performance. The TNS provided by Oracle allows communication in each database. The TNS server is

Guidance: I. Introduction: A rollback segment is a part of a database that records information about database changes. Use this information to achieve database read consistency and restoration. If the rollback segment fails, the database cannot

Drop table releases the space occupied by the segment, while the OS space occupied by Data Files remains unchanged. 1. Create a tablespace, table, and insert 300 pieces of data 1 SQL > Create Tablespace TBS datafile ' /Opt/Oracle/oradata/nwom/

Guidance: Several project teams have begun to use the full-text index of oracle. Oracle's lexical analyzer is not smart enough for the lexical analysis of the zhs16gbk character set. It can only be mechanically matched in words. The utf8 character

The default naming conventions for this file are:Init $ oracle_sid.ora (in UNIX environment)Init % oracle_sid %. ora (in Windows) By default, it is placed in the following directory$ ORACLE_HOME/DBS (UNIX)% ORACLE_HOME %/Database (Windows) This

The types of Oracle Data Dictionary views are user, all, and DBA. (here, * Can be tables, indexes, objects, and users .) User _ *: Information about objects owned by users, that is, information about objects created by users All _ *:

1. view the SQL statements that consume the most memory (V $ sqlarea) 1 Select B. username, 2 A. buffer_gets, -- The number of times the sub-cursor runs this statement. 3 A.exe cutions, -- Number of times that this statement is executed by

Data Block In an Oracle database, the block is the smallest unit of data file I/O and the smallest unit of space that can be allocated. An Oracle block consists of one or morecontiguous operating system blocks. Standard block size Use

Oracle cluster is a separate installation package. After installation, Oracle clusterware on each node is automatically started. The operating environment of Oracle clusterware isTwo Disk Files (OCR, voting disk), composed of several processes and

Steps for upgrading oracle from 10 Gb to 11 GB Database Old Version: 10.2.0.4New database version: 11.2.0.2OS: Solaris 10Reference:Complete checklist for manual upgrades to 11gr2 [ID 837570.1]Part 1-install 11gr2 SoftwareHere Software Of Install For

I haven't read much about Oracle technical documentation for a long time. Today I read an article titled Oracle response time optimization with method R. This is the main idea of optimizing Oracle performance classic book. R represents the response

In Windows, it is usually: D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin   But is this version installed in Linux? Isn't it possible to only use the client? ,,   We can useRpm-IVH Linux-1.4-6.i368.Rpm command InstallationThis

To put it simply, the global variables in pageckage under the same session are public, causing a conflict. The following are some related materials andArticle.   Application of global variables in Oracle Database packages 1 PrefaceInProgramSome

In my project, we use SSIS to import data between two oralce instances. Because of the large data volume, An error is reported when more than 0.7 million of the data is exported to more than 80 thousand.CodeIs Row-00060, which is the same for a

From today on, I decided to take some free time every week to record some basic knowledge about Oracle, which is also convenient for Baidu and Google. Today we will introduce a very mathematical connection. First, we will introduce the two

I. Oracle Database default tablespace settings DBAs often encounter such a headache: they do not know who created a user in Oracle and did not specify the default tablespace for this user, therefore, this user will use the default