Oracle

What is redo Redo record transaction logs, divided into online and archived. For the purpose of recovery. For example, if the machine is out of power, then you need to go online redo logs to restore the system to the failure point after the reboot.

1. Concept PGA: The program global area, the memory area used by the server process, including data and control information for a particular server process, such as private information and operating system resources used. UGA: The user global area,

The database cannot be started (or crash immediately after startup), alert log error ora-00600[17182],ora-00600[25027],ora-00600[kghfrempty:ds], and so on Tue June 23:36:06 2014 ALTER DATABASE openbeginning crash Recovery of 1 threads  parallel

oracle| Solution | data | database | problem JBuilder several issues to be aware of when connecting Oracle 9i correctly Oracle8 above should all use the Classes12.jar file as JDBC driver; Correctly set up the enterprise Setup,

Oracle Oracle Product Services and Technology level introduction Many friends ask the genuine Oracle database products and pirated products are mainly different, in fact, from the product technology itself, the difference is not small, can

Mysql|oracle This is my comparison's installing and getting started with Oracle 10g, PostgreSQL 8 and MySQL 5. This is what I consider the comparison of the ' art for three categories to db:commercial vs. Academe vs. Internet Model. This is a

10g in view v$sga_dynamic_components we notice a component:asm Buffer Cache, and in the Instance_type=asm instance, the parameter has a value. That is, the parameter is used for ASM instances, it is used to do what, in the doc searched for a while

When using Navicat connection Oralce database times ORA-28547 error, direct Meng forced, online check the information is Navicat comes with the version of the Oci.dll file and the server side of the ORALCE database version inconsistency

Toad for Oracle 11.6 (Win7 64)File location: C:\Users\Administrator\AppData\Roaming\Quest software\toad for Oracle\11.6\user files\fmtplus.optNote: For a long time, this format is best for reading1) and OR manual line wrapping2) when ... Then do not

Use ODBC to monitor Oracle Database (11.2.0.3) and MySQL database under Zabbix1. Monitor MySQL Database1) Installing ODBCYum-y Install UnixODBC Unixodbc-develYum Install Mysql-connector-odbc2) odbcinst-j View configuration fileUnixODBC 2.2.14DRIVERS

Recently new customer requirements, in the form of Excel data, the contents of the data table, through the AS2 protocol transfer to the client side, originally intended to use stored procedures directly output Excel, but a think, ODI such a powerful

Oracle 12C still supports the beta version of Bbed,oracle 12C, and for those accustomed to using bbed (Oracle scalpel), whether 12C continues to be supported is a matter of great concern, through this experimental test, 12C continues to support bbed,

Oracle Database EXP Export DMP file corrupt existence bad block/corruption skip DMP bad block by CPFL tool importIn some cases, it is known that data can be recovered from a table of damaged DMP files through Dul, but there are many problems with

Nonsense: There has been no development for some time, do the project and rediscover the memory of the development of the point. Regain a little bit of fragmentation. Run a lot of production line, configuration of some parameters also forget almost,

Author: Jason priceAddress: http://www.oracle.com/technology/global/cn/pub/articles/price_dbtrans_dotnet.html Understand the basics of writing database transactions in Visual Basic. NET and C. ExampleCode:

This article mainly discusses the following parts: how to view and query Oracle character sets, modify and set character sets, and common Oracle utf8 and Oracle exp character sets. 1. What is the Oracle character set? The Oracle character set is

Address: http://fengwen.iteye.com/blog/580323 Problem: a xx Settlement System requires transaction statistics from another system, which stores and exports images for viewing.   The Slice directly exists in the database as blob. I thought it was a

BackgroundLast year, I installed the meego netbook on the open-source Oracle virtualbox. It seems that the speed is good and it is much better to use than the meego simulator (emulator) in qemu. After the beta version of meego tablet was released at

  In Oracle Linux 5, we can use ORACLE validated configuration to accelerate the deployment of the Oracle environment. For more information about validated deployments, see: Oraclevalidated configurations installation

Oracle basic concepts and comparison with informix I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user