The shared pool in the SGA consists of a library cache, a dictionary cache (Dictionary cache), a buffer for parallel execution messages, and a control structure.
The size of the Shared POOL is determined by the parameter shared_pool_size. 9i, the default value of this parameter is 8M under 32-bit system, and the default value of 64-bit system is 64M. The maximum is 4G. 10g can be adjusted automatically by Sga_target parameters.
Memory management for shared pool is achieved through a modified L
The advantages of this method: 1, the integration of Oracle client within the program, no need to configure users themselvesThe disadvantage of this method: 2, increase the volume of the package (Oracle Instant client itself has a few 10 megabytes size)Here's how it's implemented.
0. First, download the corresponding version of Oracle Instant client package f
Oracle 10g is not difficult to install on win, but it is not very easy on other platforms. Our company uses RHAs 4 as the server and I work on databases. It is relatively simple to uninstall on other platforms. It is okay to delete files and environment variables. However, it is not so easy to delete files and environment variables on win. Now I will write down how Oracle uninstalls it on
Tags: Oracle oracle11g1. ORACLE11G Installation Environment PreparationWith OEL6.5 x64 installation, the installation process is consistent with Redhat, the installation process selected desktop, development package, development library, other default options.Desktops > X Window SystemDevelopment > Additional DevelopmentDevelopment > Development ToolsAfter installation:(1) Turn off SELinux(2) Close iptables(3) Restart2. Start the installation of the b
General framework of Oracle, Oracle framework
The physical structure of Oracle includes parameter files, control files, data files, redo log files, archive files, and password files.
1.1 parameter file
This includes a large number of settings that affect the functions of Oracle database instances, as shown in the fol
Enable Oracle NUMA support in Oracle 11gR2
Enable Oracle NUMA support in Oracle db 11gR2
Reference Original:Enable Oracle NUMA support with Oracle Server Version 11gR2 (Document ID 864633.1)Applicable:Oracle Database-Enterprise Ed
Label:Nothing to do, today under the virtual machine installed a single instance of ORACLE11G, hereby record sharing! Software used: Virtualbox-4.0.8-71778-win.exe Oracle Linux 6.3 (V33411-01.ISO) oracle11g (p10404530_112030_linux-x86-64_ 1of7.zip, P10404530_112030_linux-x86-64_2of7.zip) First, install Linux. Virtual machine configuration: 1g memory, 30g HDD, one NIC (host-only mode)Check memory condition # grep Memtotal/proc/meminfo # grep Swaptotal/
Oracle initialization parameter file knowledge, oracle knowledge
1. Server initialization parameter file Overview
The oracle initialization parameter file stores the initialization parameter configuration information required for database instance creation and startup.
The initialization parameter file is corrupted and the database cannot be started.
In 11g, the
Tags: example port mit architecture Loop redhat Force PNG DBAPurpose of this article: Oracle is a large database The age and version and the environment are older, performance affected the business is normal, recently the company needs to migrate data from Oracle Server Windows2003 32bit to Windows2012/linux Redhat 64bit Oracle, it involves a transcoding
http://blog.csdn.net/dbanote/article/details/10488581Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.There is a need to synchronize some Oracle data to MySQL, which is too cumbersome to synchronize with each time, so it takes a little time to study the way Oracle is connected directly to MySQL.Reference Document:detailed overview of connecting
Welcome to the Oracle community forum and interact with 2 million technical staff. A few days ago, Oracle announced the launch of Oracle Shipping Management (OracleTransportationManagement) software at its U.S. headquarters. According to reports, the new brand is based on the industry-leading transportation management products obtained after the acquisition of G-
Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package
**************************************** ******************************** **************
Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.
Please leav
The problem occurred when installing Oracle10G. Later, I asked my roommates to re-send an Oralce10g Client installation package and install it. It was possible to use PLSQL at the beginning. Later, due to work needs, an Oracle database backup was sent from an import colleague at a time, and an error 6550 occurred when importing data using the IMP statement under the command line, online query
The problem occurred when installing
Preparations
Install a Virtual Machine (VMware Workstation version 8. x or VMware Server Version 1. x)
Install the Operating System (CentOS 5.x or CentOS 4.x) on the Virtual Machine)
Create an Oracle user and copy the Oracle software to a directory related to the Operating System
Granted correct User Permissions
Suggestion: I hope everyone can have their own laptops and learn more conveniently. The memory s
How can I uninstall Oracle perfectly ?, Is it perfect to uninstall Oracle?
The uninstallation program that comes with Oracle cannot fundamentally uninstall Oracle, which leaves a hidden danger for the next installation. How can we completely uninstall Oracle?
To clear the R
[Disclaimer: This article is a study of the famous Oracle DBA Mr. Gai's masterpiece, "In-depth analysis of ORACLE--DBA introductory step and diagnosis case," the study notes and experience. In this statement, the text extracts some of the contents of the book, not for the purpose of plagiarism, but on the impression that Mr. Gai wrote really classic. In this statement to the original author of respect and a
Label:Oracle 11G RAC cluster installation (vii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. This docume
Oracle has been installed many times in both Linux and Solaris, and almost never succeeded. At the beginning of the installation, I couldn't even see the installation page. Later, I could see the installation
Oracle has been installed many times in both Linux and Solaris, and almost never succeeded. At the beginning of the installation, I couldn't even see the installation page. Later, I could see the insta
Oracle442 application scenarios --------- physical structure of Oracle Database, oracle Database Application
------------------------- Physical structure of Oracle Database -------------------------------
Physical Structure of Oracle DatabaseOracle data is actually saved in the form of files, which are stored in addit
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.