Oracle Database query performance optimization
Querying, adding, modifying, and deleting databases are important factors that affect web application performance indicators. The following are some common suggestions to improve query performance.
1.
SSIS uses environment variables to configure data source connection Parameters
Step 1: Create an SSIS package
Create the OLEDB Source and Flat File Destination Connection Manager in the Data Flow Task.
Step 2: Configure parameters on the
Oracle FGA Audit
You may be familiar with trigger, but Oracle also has a function named FGA. It works like trigger, but it is more powerful. its full name is Fine-Grained Audit, which is a special method of Audit. to use FGA, you only need to call
Oracle SQL statement Optimization
Although orm ing is used in the project, the optimization of the Oracle system is very valuable. Here we will summarize the commonly used statements from the perspective of SQL statements.
1. Optimization in the
Recovery Process of rm-rf misoperations
Many DBAs must hate rm-rf. Maybe the database will be wiped out one day when they make a mistake, and then there will be no more ...... In case ...... Is it true that there is no medicine to save this
Use SPFILE to reset the configured initialization parameters to the default values of the system.Start with SPFILE. If you want to restore the initialization parameter to the default value, use a statement like this:Alter system reset db_create_file_
MariaDB: Selective binary log event
As the first article on MariaDB's series of interesting features, we started from selectively skipping the replication of binlog events. MariaDB 5.5 and 10 support this feature.
By default, when the MySQL standard
Error in building aix rac -- Default Gateway not configured
Environment:Operating System: AIX 5300-09Cluster software: CRS 10.2.0.1Database: Oracle 10.2.0.1Fault symptom:The following error occurs when running the root. sh script while building the
Automatically generate a Model that complies with Sqlachemy: How to Use sqlautocode. How to Use codeblocks
The call format is as follows:
sqlautocode [options, ]
Database_url is the database url we configured when using SQLAlchemy. Some people are
(64-bit oracle uses 32-bit PLSQL) install 64-bit oracle database software, use 32-bit PLSQL Developer Connection method, plsqloracle
Since PLSQL Developer does not provide 64-bit, I sorted out the information on the Internet and sent it
1.
Simple use of stored procedures, simple use of stored procedures
Create a stored procedure:
USE [ais20140425092531]GO/***** Object: StoredProcedure [dbo]. [HBSH_MS_BillType_in_ofmine] Script Date: 09/01/2014 14:34:24 ******/SET ANSI_NULLS ONGOSET
Hibernate uses hql for Chinese sorting,
Why does MySQL not support Chinese sorting? No way. You only need to wait for utf8_unicode_cn to come out. If you want to implement cross-database with hibernate and do not want to change the code, I will tell
[Oracle] deletes a node from RAC, which is a oraclerac node.
Environment:
OS: OEL5.6
RAC: 10.2.0.1.0
There are currently three rac1, rac2, and rac3 nodes. The following describes how to delete a rac3 node.
1. Delete the database instance on the rac3
Sing Xing interprets the advantages and disadvantages of mysql stored procedures, Xin Xing mysql
Common SQL statements must be compiled and executed before execution. stored procedures are a set of SQL statements to complete specific functions, it
The solution for delayed loading of common hibernate fields is invalid.
We don't need to talk about the delayed loading of associated objects.
Delayed loading of common fields, especially lob fields, has a great impact on performance if there is no
Some instances understand the mysql database stored procedures and mysql database Stored ProceduresMysql stored procedure: encapsulate SQL:
Create procedure p1 () beginselect * from t_news; end $ // simple mysql Stored procedure instanceDisplay
Mysql decompression and authorization, mysql authorizationDecompress mysql compressed version to a root directory
Note the content configuration of the INI File
Basedir = D: \ mysql-5.6.17-winx64Datadir = D: \ mysql-5.6.17-winx64Port = 3306Server_id
Removing temporary table empty ora-25152 error, removing ora-25152 Error
Deleting a temporary tablespace or shrinking a temporary tablespace often results in table space occupation.
Next we will handle this situation,
First, find the locked
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.