Patch InformationC:\users\xifenfei>e:\oracle\product\11.2.0\dbhome_1\opatch\opatch lspatches17977915; WINDOWS DB BUNDLE PATCH 12.1.0.1.3 (64bit): (17977915)
Session 1Xifenfei_cdb$root@sys> show
Many students on the optimization of SQL seems to know very little, recently summed up the following 34 articles for reference only.
(1) Select the most efficient table name order (valid only in the Rule-based optimizer):
The Oracle parser
Today encountered a problem, there is a table can not operate, it is likely to be locked, the first thought is kill session, so executed the following script to find out which session has a problem:
To see if a table is locked
SELECT/*+
The Oracle tutorial being looked at is: analysis and resolution of Oracle common error codes three.
--------------------------------------------------------------------------------
P align= "Justify" >ora-00600:internal error code,arguments:[num],
One. Query article
1. Query Oracle Table space usage
Select b.file_id file ID,
B.tablespace_name table Space,
B.file_name Physical file name,
The total number of bytes b.bytes,
(B.bytes-sum (NVL (a.bytes,0))) has been used,
Sum (NVL (a.bytes,0))
Today, the top request to do a similar function, the initial thought of column change, but how to achieve there is no good way, this function is good
The Decode function is an Oracle Pl/sql is one of the powerful functions, and currently only
It would be a hassle to go straight to step b.A.Because this is the blog I wrote after I installed it, so the first step is to uninstall Odtwithodac1120320_32bit1.2.3.4. To complete, close the window.==================================================
Oracle-based application system many performance problems are caused by poor application SQL performance, so, SQL performance optimization is very important, analysis and optimization of SQL performance we generally look at the SQL implementation
Oracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the fine combat courses, the road map is mainly to let everyone fast employment, high-paying employment. The course focuses on Oracle company
1. Row to column:First, the initial data:Data after conversion:Second, the conversion of the statement:--statistics on the number of staff in various positions in various departments:SELECT T.job, SUM (DECODE (t.job, ' clerk ', 1, NULL)) as COUNT1,
Introduction to Oracle Common analytic functions (ranking function + window function)November 30, 2014 ? database 3903 words ? No comments? Read 7,772 times Rating functionThe common rating functions are as follows:
Rank (): Returns the
The small partners who develop Oracle applications under the. NET Platform are sure to know that on the one hand, Oracle development and implementation is more complex than SQL Server to install Oracle clients (XCopy, extract related files
Basically, Oracle introduced dual as a syntax-compliant1. We start with the name, dual is not an abbreviation, itself is the complete word. Dual noun means logarithm, when doing adjectives refers to two heavy, two yuan.2. The dual table in Oracle is
Does Oracle support symbolic links under the RDBMS HOME (symbolic links)?References:Does Oracle support Symbolic Links in the RDBMS home?(Doc ID 813116.1)Suitable for:Oracle server-enterprise edition-version 9.2.0.1 to 11.2.0.3 [Release 9.2 to
Error when installing the data:To view operating system parameter settings:[[email protected] ~]# vi/etc/sysctl.conf # Kernel sysctl configuration file for Red Hat linux## for binary values, 0 is disabled, 1 is enabled. See Sysctl (8) and#
Oracle founder Ellison's 10 biggest bastards: The Microsoft Garbage heap"TechWeb Report" September 19 news, according to foreign media reports, Oracle founder and CEO (CEO) Larry Ellison announced his resignation as CEO, to replace Jeff Henley as
ORACLE multi-Table query optimization and ORACLE Optimization
ORACLE has a high-speed buffer concept. This high-speed buffer is used to store the executed SQL statements. Therefore, oracle has to do a lot of work when executing SQL statements, such
In the Database system class, the teacher introduced two types of databases: Oracle Database and SQL Server. They also talked about the differences between Schema and SQL Server, here, I also want to add the difference between the MySQL mode and the
Db replay setting scale_up_multiplier does not take effectSet scale_up_multiplier:BEGINDBMS_WORKLOAD_REPLAY.PREPARE_REPLAY (scale_up_multiplier => 10 );END;However, after setting, check DBA_WORKLOAD_REPLAYS.SCALE_UP_MULTIPLIER and find that this
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service