Oracle
Oracle Expert Tuning Secrets
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
ISQL *plus Page
Isql*plus is a product independent of Enterprise Manager. The Isql*plus user interface runs in a Web browser connected to the Internet or your intranet. Isql*plus enables a Web browser to connect to a Oracle database and perform the
# cd/home/oracle/crs/log/p570b/crsd # ls-lt Total 2150168-rw-r--r--1 root system 23958 19:14 crsd.log-rw-r--r--1 root system 10555307 Oct crsd.l01-rw-r--r--1 root System 10491275 SEP crsd.l02-rw-r--r--1 root system 10558627 Aug crsd.l03- rw-r--r-
1. Professional versatile (being an expert generalist)
Knowledge of the storage, operating system and other fields, Cross-platform database technology is also necessary to master, You can't leave the Windows environment. Nothing can be done under
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.
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,
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
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>
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.
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
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
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
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
Data | database | performance
Storage performance Assessment
When storing performance evaluations, we use the Disk Performance index (DPI, disk Performance Index), and the following table lists the indices in the DPI, which do not imply a full
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
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.