Recovery
Yesterday encountered an Oracle database problem, the environment is: windows2000+oracle9i.
After using Windows shutdown reboot, Oracle cannot connect, and when startup with startup always reports a ORA-00333 error, check the Oracle
"V$sqlarea" and "v$sql" are very useful views in which you can find the SQL statements that you find to be optimized for the least efficient execution. The value of the "disk_reads" column represents the amount of disk read by the statement in the
Error | resolution
Analyze and resolve ora-4030 errors
What does ORA-4030 mean?
This error means that the Oracle server process cannot obtain more memory from the operating system. The memory here refers to the PGA (Program Global Area) and
Use off-the-shelf Oracle technology to build distributed systems.
Replication involves keeping some or all application data in a distributed system synchronized across multiple databases. In this column, I'll explain why you need to use the
Oracle recently in the toss hp-ux11.11, I will be the Oracle 8I in HP-UX installation and configuration process written out, I hope to share with you, if you can help, Diao greedy feel gratified. If you have any questions or your experiences and
This document is only the process of deploying Dataguard, does not involve the interpretation and description of concepts, there is no dataguard theory of introduction, in this regard, please check the official Oracle documentation.
Operating
TNS-00510 Internal Limit restriction exceeded
Cause Too Many files or sockets open simultaneously (or some other resource has).
Action for further details, trace the operation for protocol details.
TNS-12500 Tns:listener failed to start a dedicated
Oracle patch is also an Oracle patch. Oracle patches also contain several kinds, small patches are simply difficult to count, it is inevitable to dazzle people. However, Oracle patch is still in order. And Oracle's Opatch tools are handy for
I. Oracle built-in role connect and resource permissions
Grant Connect,resource to user;
Connect role:--is the typical right to give end users, the most basic
Alter session--modifying sessions
Create CLUSTER--Create a cluster
Create DATABASE
When Oracle releases each new release, the database becomes more focused, especially in its external environment. Oracle has set many important initialization parameters based on the number of CPUs on the Oracle server, and Oracle is now more aware
This paper is compiled from Oracle documentation
Warehouse Builder 11g Architecture and components
Oracle Warehouse Builder is an information integration tool that can transform data into high-quality information using an Oracle database. The
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
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.