dba

Last week to interview the database manager's work, after the written test passed is the direct interview, he asked me a question, asked me to introduce Kazakhstan database of the views and understanding, but do not know the wrong without the chaos

Second, the initialization of the environment Before you are ready to create a streams replication environment, there are some preparations that need to be made, as follows: 1. Configure Administrator account For ease of administration, it is not

1.1 Confirm that the system library files required to install Oracle are installed lslpp-l bos.adt.base bos.adt.lib BOS.ADT.LIBM Bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools bos.adt.prof Bos.cifs_fs.rte 1.4 Confirm 64-bit operating

oracle| Data | Application Example Introduction to Oracle Database Dictionaries Oracle data dictionaries consist of tables and views that store some database objects about database structure information. The database dictionary describes how the

Program | Programmers abroad there are a lot of Chinese people who are engaged in the profession of programmer. I know many of these friends and I find that many people are not happy and just regard this job as a means of supporting the family.

The performance or stability of many application systems is not ideal, which is becoming a difficult problem soon after the system is online, and the reasons for these problems often reflect the fact that the people who design these systems are not

Oracle has previously installed Oracle on this machine, and generally does not appear to be unable to start the problem. But this time is not the same, installed 8.17 after a period of time can not be activated, the symptoms are as follows: In

Data | database 2004-11-16 Comparison between the three most popular databases today: MySQL Sql-server Oracle Mysql User variables: Set @varialname ={integer expression | real expression | string expression} Sql-server User variable: Declare

Flashback Data Archive (Flash back archive)The rollback information for the Undo table space Record, although it can provide a back-flash query, but for a long time, this information will be overwritten, in fact, as long as the transaction is

server| Backup | error | object | solve | data | database Describes an error resolution for SQL Server databases that cause orphaned users and object names ' xxx ' with a backup restore In the process of using a database, you often experience the

Five types of policies, column-related policies, and column masks make VPD a more powerful tool in the DBA's security toolbox The Virtual Private database (VPD), also known as fine-grained access control, provides powerful row-level security

Oracle Adjusts Oracle's competition One of the benefits of Oracle is that it manages the free space in each table space. Oracle handles the space management of tables and indexes so that we don't have to understand the internal workings of Oracle's

A well-designed, performance-capable database engine can easily serve thousands of users at the same time. And the "weak" database system with more users to access the system will greatly reduce its performance. In the worst case, it could even

When developing a Web site with asp.net, performance is always a matter of concern, and performance is not just the speed at which the code executes, it's about everything. Take a request from ASP.net, from the browser to the server's ASP.net Web

If you are going to be a DBA, it is recommended that you choose a database system that is now more popular. This means that you will have more opportunities for employment, communication and training, and that there are popular reasons why you can

Oracle Oracle DBA Day-to-day management Modified: 2000/8/23 Author: Thomas B. cox,with Christine Choi Objective: This document has very detailed information on one or more Oracle databases per day, monthly, The results of the yearly running status

My my.cnf file is like this. Innodb_data_home_dir =/usr/local/mysql/var Innodb_data_file_path = Ibdata1:10m:autoextend Innodb_log_group_home_dir =/usr/local/mysql/var Innodb_buffer_pool_size = 16M Innodb_additional_mem_pool_size = 2M

ORACLE10G has a new feature flashback Database that, when you start it, periodically writes the changed chunks to the log file of the flashback log. Note that these logs are not written by the traditional log Writer (LGWR) procedure, but by a new

Oracle claims to install the Oracle9i database under Linux at least 512MB of memory and at least 1GB or twice times the memory size of the swap space, for the system memory is greater than 2GB of servers, swap space can be between 2gb-4gb. If you

Stored Procedure | Statement A Content management system written four years ago, applied on the company intranet, the DBA said yesterday that the SQL statement did not use parameterized calls, resulting in heavier server burdens and large resource