dba

Learn about dba, we have the largest and most updated dba information on alibabacloud.com

MySQL DBA system Learning (7) binary log Three: related system variables

dba

1,binlog_cache_size and Max_binlog_cache_size Represents the cache allocated for each session In general, when inserting or modifying the data, the disk will not be written immediately, and the cache size is binlog_cache_size to control. Mysql>

Management of Oracle 9i roles

Oracle 9i Predefined roles Table 8.2 Oracle 9i Predefined roles Role name Description CONNECT Database connection role, used to connect to a database, with the right to create clusters, database links, sequences,

Oracle users, permissions, role management

Oracle Database users manage Oracle permissions settings I. Classification of authority: System permissions: The system requires users to use the database permissions. (System permissions are for users). Entity permissions: The access rights of a

Install Oracle 8.1.7.0.1 Release 3 under Turbolinux 7.0

Oracle Author: Shiley Time: 2002-5-20 ------------------------------------------------------------------------------- System configuration: CPU: ram:256m Objective: To install the Oracle 8.1.7.0.1 Release 3 Enterprise version database server under

The responsibilities of the database administrator include what

dba

I. GENERAL monitoring 1. Monitor the database warning log. Alert.log, do backup and delete regularly. 2. Linstener.log's monitoring,/network/admin/linstener.ora. 3. Redo Log State Monitoring, paying attention to the view v$log,v$logfile, which

Linux Oracle Installation Configuration treasure

Oracle installation includes both the Enterprise server and the client side, and users can choose different parts of the installation according to the actual situation. here on the enterprise server side as the main introduction object, the client'

Complete manual for daily maintenance of Oracle DBA database

During the Oracle database operation, the DBA should monitor the database's running log and table space usage, and discover the problems in the database as early as possible. Oracle Warning log file monitoring Oracle will log some of the database

Oracle Memory Architecture Detailed (v) Oracle PGA

The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA can

How to open asynchronous IO on HP's host

Asynchronous First, talk about asynchronous IO (Aio) In HP-UX, when synchronous IO is used, this means that the previous IO must return the "successful write" information before the next write Io, and see a performance bottleneck in the synchronous

Data movement in DB2-loading

Load (load) The load command format is similar to the import, the command keyword is load, but the following arguments are much more than the import command, and the detailed usage can refer to the DB2 documentation. Loading is similar to

Send an email using the JMail component instead of SQL Mail

Jmail|jmail components Say two words: In one's most difficult time, write down this article, send to So-and-so to cheat point fee, the result is ignored, a few years later, churning hard drive to turn out. Oh, may be helpful to users who want to

An overview of Oracle Rman architecture

A Server Management Recovery Recovery Manager, Recovery Manager, Jianchen RMAN. The RMAN implementation has been server Management recovery (Managed RECOVERY:SMR). SMR is the ability of a database to perform the operations needed to ensure the

The oracle8.1.7 installation process is recorded on Linux 7.1.

oracle| process System Preparation ======== Redhat8 Install the additional installation package by Server type: 1 contains an x system, it is recommended to use GNOME, 2 will develop toolkit develop tools selected, standard GCC tools and so on. 3 It

A solution to view table space utilization failure after mistakenly deleting LV

dba

Phenomenon: mistakenly delete lv after viewing table space utilization failure, see Alert log, found the following error: Errors in FILE/HOME/ORACLE/ADMIN/ZHJPORT/BDUMP/ZHJPORT1_DBW0_2871436.TRC: Ora-01186:file Bayi Failed verification tests Ora-0

Use Oracle's built-in security features for PHP

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.  

Common methods for viewing SQL execution plans

dba

Whether you are developing a DBA or maintaining a DBA, you are always more or less encountering SQL execution efficiencies or SQL tuning issues, and it is necessary to view the execution plan. Generally we can view in 3 ways: First, explain plan

Script to configure Oracle 10g RAC

#用户设置 GROUPADD-G 1000 Oinstall GROUPADD-G 1100 dba Useradd-u 1001-g oinstall-g dba Oracle Mkdir-p/oracle Chown-r oracle:oinstall/oracle Chmod-r 755/oracle Mkdir-p/kk #修改环境变量配置 Export Oracle_base=/oracle Export Oracle_home= $ORACLE

Oracle Certification OCP DBA Research easy to pass the detailed

Finally put OCP DBA's course all finished, tired Ah! Overall Oracle certification is worth the test. I have CCNP, MCSE certificate, but through the DBA examination, feel not only deepened the understanding of modern databases, but also enrich the

MySQL stored programs, functions, and issues related to replication

dba

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

Classic Oracle Book Recommendation

Oracle Recommend some classic Oracle books to everyone: Http://www.eygle.com/index-book.htm Oracle8i Internal Services by Steve Adams The classic of Steve Adams ... An in-depth discussion of Oracle's internal mechanisms and principles is an in-

Related Tags:
Total Pages: 17 1 2 3 4 5 .... 17 Go to: Go

Cloud Intelligence Leading the Digital Future

Alibaba Cloud ACtivate Online Conference, Nov. 20th & 21st, 2019 (UTC+08)

Register Now >

Starter Package

SSD Cloud server and data transfer for only $2.50 a month

Get Started >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.