One, the Resource Manager (DRM) consists of three elements:
Resource Consumption Group (Resource_consumer_group)
Resource Planning (Resource_plan)
Resource planning directives (resource_plan_directive)
To perform DRM-related operations, you must
Data security is more and more important, not to say that your production database security, your data must be safe, Rman backup is also an important place to leak data, if someone else got your backup set, same as the intrusion of your production
1. Determine the server version Choose your Oracle Server version first to download the appropriate client. Look at the following sql: SELECT * from V$version; If you can't connect to Oracle remotely, you can only log on to the server. 2. Download
The Oracle installation configuration tutorial is shared with you for your reference, the details are as follows
1, installation
Oracle version: Oracle DatabaseG Release 2 (10.2.0.1)
Download Address:
1. Three modes of protection
–maximum Protection
Under maximum protection, you can ensure that the data from the library and the main library is exactly the same, and that the zero data loss. The transaction is completed at the same time on both
1. Execute a SQL script file
Copy Code code as follows:
Sqlplus User/pass@servicename
Or
Copy Code code as follows:
Sql>start File_names
Or
Copy Code code as follows:
sql>@
It's interesting to see a document called "Penetration:from application down to OS (Oracle)" These days, and the general meaning of the document is that if Oracle services are started with an administrator account, you can just have A database
One. Get an instance of this object
Connection con;
con = drivermanager.getconnection (Url,username,password);
DatabaseMetaData Dbmd = Con.getmetadata ();
Two. Method Gettables usage
Prototype:
ResultSet
Recently make a batch import requirement, insert multiple records into the database in bulk.
Solution: Encapsulate a list object in a program, and then insert the entities in the collection into the database because the project uses MyBatis, so you
Abstract OLE DB is an open specification built on the success of ODBC, which provides an open standard for accessing and manipulating different types of data. ADO is a consumer of old db that provides access to OLE DB data sources at the application
Instance
1. Start Oracle Server. Startup[nomount|mount|open][force][pfile=filename]
Parameter description:
Nomount: Only Start instance
Mount: Start the instance and mount the database
Open: Launches the instance, mounts and opens the
oracle| Recovery | control | data
---------------------------------------------
Experimental platform: Windows + Oracle 10.1.0.2.0
Author:ningoo 2005-03-26
--------------------------------------------
After the control file is backed
This paper introduces the comparison of DB2 common functions with Oracle in detail
1. Type conversion functions: Decimal, Double, Integer, Smallint,real,hex (ARG),
Date, Time,timestamp,char, varchar
Common examples:
--Convert to String type
Data pump includes export table, export scheme, export table space, export database 4 ways.
1, EXPDP command parameters and instructions
(1) ATTACH
This option is used to establish an association between a client session and an existing export
First, Latch description
1.1 Latch
Latch belongs to System lock, which is used to protect a serial locking mechanism of shared data structures in the SGA area. Latch implementations are related to the operating system, especially if a process
The TOPAS command can monitor system activity ――memory,i/o,paging space,cpu,process.
This command is included in the Perfagent.tools file set.
How to use the command:
Topas [D-Number_of_monitored_hot_disks] [-h]
[I.
An inefficient SQL statement is enough to ruin the entire application.Statement is the parent interface of PreparedStatement and does not pre-compile, reducing the overhead of precompiling. A single run of PreparedStatement is slower than
1. Physical bad blocks and logical bad blocksThere is a concept in the database called data block consistency, Oracle's data block consistency includes two levels: physical consistency and logical consistency, if a data block at these two levels of
Oracle GoldenGate Studio is a graphical interface management tool. This tool makes it easier to complete the Ogg replication design. Installing this tool requires Java 8 (1.8) JDK software, which can be downloaded from the official Oracle website.1.
InstallationFirst of all, PHP supports oracle. The first thing I think of is the pdo-related driver. After reading it, it is actually called pdo_oci. But it still depends on the oracle instant client, which needs to be downloaded from the oracle
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