Database Administrator

Scott is my first user name to contact Oracle. Regardless of the version of the database, 9i, 10g, I like to use scott for some testing. But after installing oracle 11g, scott users cannot use it, which makes me feel awkward. When you log on with

Oracle Database-based data synchronization technology can be divided into two types: data synchronization technology provided by Oracle itself and data synchronization technology provided by third-party vendors. Oracle's own synchronization

Oracle stores data through algorithm conversion in the database. This article aims to introduce how the value of the NUMBER type is stored. Let's take a look at a simple example: SQL>Select dump (1) from dual;DUMP (1)------------------Typ = 2 Len = 2

Create a database manually on the Linux platform (Oracle 10 Gb)After installing the Oracle software, you can create a database manually without using dbca.In the process.1. First set the SID of the ORACLE to be created. If this variable is set in

Test Import and Export todayIt is understood that if imp AND exp are used for import and export, as long as Oracle tools of the same local version are used, there is no problem with importing and exporting different versions of parts. For example,

Mysql reports the following error: ERROR 126 (HY000): Incorrect key file for table '/tmp/# SQL _6613_0.myi'; try to repair it The reason is that the temporary table is too large, and the/tmp partition is only 2 GB. If it cannot be put, an error is

Database environment: Oracle 9i HOST: AIX 5.3 Symptom: It is too slow to connect to the database. You can use topas to check the resource usage of the host. Everything is normal. The connection from the local database to itself will be slow as

Use show sgaYesCheck the size of SGA.,The results of show sga are in the following format: Total System Global Area AAAAA bytes Fixed Size BBBBB bytes Variable Size CCCCC bytes Database Buffers DDDDD bytes Redo Buffers EEEEE bytes ThisProvide a

Install Quick Installation Guide 10g Release 2 (10.2) for Linux x86. Problems encountered during installation: Start Oracle Universal Installer/tmp/OraInstall from the following address. please wait... [oracle @ nj15 database] $ Exception in thread "

// Sometimes, the result set and// Merge other sorted result sets (union or union all)// For example:Select * from tb where length (id) = 5 order by id descUnion allSelect * from tb where length (id) = 10 order by id asc// In general, the preceding

How to count the total number of records deleted after execution of the delete statement in PLSQL. Oracle uses two types of cursor: explicit cursor and implicit cursor. No matter how many records are returned by the statement, PL/SQL implicitly

Today, I encountered a lot of problems when installing the MySQL stress testing tool sysbench. Although there are many installation examples on the Internet, they are not accurate enough, or they are not very similar to my own environment, as a

Create a table: Mysql> create table students ( -> Sno CHAR (10) primary key, -> Sname CHAR (8) not null, -> Ssex CHAR (1) not null check (ssex = 'F' OR ssex = 'M '), -> Sage int not null, -> Sdept CHAR (20) DEFAULT 'computer' ->) ->; MySQl supports

To group queries by time period, you must first understand the addition and subtraction of level, connect by, and Oracle time.I will write only one query statement about level:  --- Level is a pseudo-Sample  Select Level FromDualConnect By Level

Oracle SQL optimization Consultant -- AuthorizationGrant administer any SQL tuning set to scott;Grant advisor to scott;Grant create any SQL profile to scott;Grant alter any SQL profile to scott;Grant drop any SQL profile to scott; -- Create a

As we all know, in the mmm environment, the data in each database is consistent. What you see after amoeba is consistent is that the Server Load balancer has been used, and you cannot see it. So what should we do? Here we can use a parameter in/etc/

Today, when I drop a user, it's time for hang to stop and don't care. After an hour, the result has not been deleted. There are not many objects in this user, and they are not big either, so I checked the alert Log and found the following

1.1 example of tables with OU shielding SELECT t.org _ id, t. * FROM po. po_headers_all t -- unshielded table, running data in PL/SQLSELECT t.org _ id, t. * FROM apps. po_headers t -- contains OU blocking and no data is queried in PL/SQL. 1.2

1. After reading the introduction of MemSQL, it took several minutes to browse the website, Read getting started, download, install, and start it. MemSQL http://memsql.com/ Its publicity Slogan is the world's fastest database. your data. ACCELERATED.

I. Syntax of copying a table: Create table name as (subquery) Example: copy the emp table in scott, the default database installed by El. Create table myemp as (select * from emp ); In this example, the table structure and table content are