dba

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

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

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

Oracle There are more than n such articles on the Internet, but I installed in the time, no article on the internet for me, and finally I almost browsed all the similar documents after, summed up the following installation methods, I hope you can

Still remember a few years ago, when I graduated from university, only to find a job to solve the problem of food and clothing, toiled, the Sun, shuttle in Beijing each talent exchange, a bit timid ... A bit helpless ... At that time, I have only a

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

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

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.

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

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

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

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

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

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

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

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

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

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