dba

Application Purpose ======= The purpose of this article are to provide a understanding of freelists and freelist. SCOPE & Application =================== This article was intended to being used by DBAs to help understand the how freelists and

Do MySQL 5.1 stored programs and functions work for replication? Yes, the standard behavior performed in stored programs and functions is copied from the primary MySQL server to the from server. Can the stored programs and functions created on the

Oracle 1. Modifying the kernel Vi/etc/system Set shmsys:shminfo_shmmax=268435456 (native memory is 512M) Set Shmsys:shminfo_shmmin=1 Set shmsys:shminfo_shmmni=100 Set shmsys:shminfo_shmseg=10 Set semsys:seminfo_semmni=110 Set semsys:seminfo_semmns=3

Must understand the SQL knowledge One, two table outer join query The existing two table A,b contents are as follows Mysql> select * from A; +------+------+ | ID | Col1 | +------+------+ | 1 | AA | | 2 | BB | | 3 | CC | +------+-

Oracle Objective Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies.

Data | database 1. Test the Sybase jconnect-5_2 JDBC Database interface with one JSP file: FFFF00 border=1> JSP test Sybase jconnect-5_2 JDBC Database interface jsp test Sybase Jconnect-5_2 JDBC Database interface " +rs.getstring ("emp_lname") + "")

Objective Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of

oracle| to install Oracle 8i on Linux (Note: Refer to http://vip.6to23.com/hanson/htdocs/oracle.htm and make corrections during installation) There's been a lot of discussion about Oracle installation, but in practice you always have some trouble,

Data files for MySQL First, the system parameter DataDir In MySQL, each database will have a folder named after the database in the defined (or default) data directory, which is used to store various table data files in the database DataDir

Open source database MySQL has developed to today has a very broad user base, some say it has a strong challenge to the traditional business database, and some say it has yet to prove itself in the corporate environment, and this article lists the

Q: Why is it slow to operate on a table with 30,000 records and indexed tables? A: 30,000 records are not too much, you feel a bit slow may be the reason for too many records, because each record is too long, or your machine performance is very low,

Most WEB applications today need to adopt at least some basic security policy. For example, a Web site that provides password-protected content, only Web sites with admin backend, blogs and personal magazines, E-commerce sites, intranet, and so on.

Install FEDORA2 2. Download oralce10g (www. Oracle. com), general installation simply download ship.db.cpio.gz 3. untie [Oracle @oar10g oracle]$ cd/tmp [Oracle @oar10g oracle]$ GZIP-CD ship.db.cpio.gz | Cpio–idmv 4. Modify the Linux system

A lot of the time, do Oracle DBA us, when the application administrator to inform us that the application is now slow, the database is very slow, when we go to the database to do a few examples of select also found the same problem, sometimes we can

Oracle Data Guard, logical standby and physical standby. Here are the steps to build a physical standby environment. First, enable Force Logging Set the primary database to force logging mode. Use the following statement: View Status: Sql>

A case, view trace file found the following error message D:\oracle\product\10.2.0\admin\dbserver\udump\orcl_ora_5888.trc Corrupt block relative dba:0x09848269 (file 295529) Bad header found during buffer read Data in bad block: Type:1 Format:5

In Oracle databases, it is often difficult for management tablespaces to visualize data from SQL queries. One way to achieve tablespaces visualization and easier management is to create a segmented use mapping (block usage maps) similar to the

DB2PD Options for lock monitoring DB2PD is a utility for monitoring various DB2 database activities and troubleshooting. It is a stand-alone utility that starts with the DB2 engine, starting with the DB2 V8.2, and looks and functions like the

When I was in charge of managing a technical consulting firm, I heard some reasons not to use MySQL. While many of the reasons are misleading, there are some very good reasons not to use MySQL. Of course, the actual situation will vary depending on

Oracle No setting required to immediately recognize all changes to a row In the Oracle9i Database, we saw that it introduced a "time Machine" in the form of a flashback query. This feature allows the DBA to see the column value at a specific time,