Oracle

(1) Check the index that needs to be rebuilt Check in the following areas to determine which indexes need to be rebuilt. First, view the user index in the system table space To avoid fragmentation of the data dictionary, try to avoid the presence

Profile is a named collection of password limits and resource constraints. When an Oracle database is established, Oracle automatically creates a default profile and then assigns each user, and if not specified, the user will enable default profile.

Well, I also Finon, because in the company's year-end goal of writing to learn Oracle, today began Oracle, to give you a new understanding of it! Not going to hit me! ~ Quack. Actually, to be honest, I don't want to write theory in this respect,

We know that in previous versions of Oracle 10g R2, temporary files for temporary tablespaces are not automatically restored if you use Rman to recover the database. This has caused a series of problems, many DBAs forget to add temporary files

In order to be successful, I'll involve some preliminary steps that will be needed to see what happens, including running Plustrce SQL scripts, creating a Explain_plan table, granting roles, configuring Sql*plus environments to view execution plans.

In the recent software system to delete a record, it is necessary to link to delete many tables at the same time, there is a constraint relationship between them. So consider adding a constraint relationship when creating a table, and the details

An index was created in Oralce for the constructor, and the result was unsuccessful. Source:create Index idx_t_sp_twotypestat_0_f on T_sp_twotypestat_0 (F_dateadd (yearmonth,12,2)); The Err:the function is not deterministic. Let's take a look at

When you start Tomcat, you are prompted to use 8080 ports, and then find the following findings: A 8080 port-occupied error occurs when you install Oracle with Tomcat, JBoss, and other 8080-port-consuming servers on a single machine First, check

Method One: Oracle's deadlock is very frustrating, summing up some bit of experience as a learning Note 1. Check which process is locked.Check V$db_object_cache view: SELECT * from V$db_object_cache WHERE owner= ' The owning user ' and locks!= ' 0 '

This paper explores the internal mechanism of Oracle data buffers--oracle Use this memory to prevent unnecessary data blocks from being reread from disk. Understanding how Oracle Data buffers operate is key to successfully using them to tune

Now there is this environment: A web Server, a pure Java app program The database is made up of two forms of RAC. Web server and app programs are connected through OCI (RAC) Database. Out of such a strange problem, webserver update or an

In today's rapid development of information age, day-to-day work, users often encounter the data in the Excel file and Oracle database in the data to each other, realize the operation of real-time data, but access to this information is not much. If

The most important new feature of oracle9i is the ability to dynamically modify almost all Oracle performance parameters. This allows Oracle experts to dynamically reconfigure the Oracle instance during the run-whether it is addressing a current

To enable a client machine to connect to an Oracle database, Oracle client software needs to be installed on the client machine, with the exception that the Java connection database can be used in JDBC Thin mode without Oracle client software. When

1.drop configuration files and repository run:Emca-deconfig dbcontrol db-repos drop 2. Logon sqlplus as user SYS or SYSTEM, and drop the Sysman account and Mangement objects:A. Drop user Sysman cascade;B. Drop role Mgmt_user;C. Drop user Mgmt_view

Oracle9 startup times wrong ORA-00600: Internal error code, parameters: [Kcratr1_lostwrt], [], [], [], [], [], [], [] This may be due to illegal shutdown or power off, following are the problems and solutions: C:\Documents and

In Rman, we can create a command file that contains the Rman command and then call the file in Rman. Such as: Rman Target Usr/pwd Cmdfile=backup.cmd Alternatively, it can be directly run directly in Rman @ @backup. cmd In addition, RMAN provides

1, set up catalog library, and register target database and synchronous catalog db --Establish a backup of the database [Oracle@rh4 ~]$ Rman Target/catalog rman/rman@catdb Recovery manager:release 10.2.0.1.0-production on Sun Feb 19 11:43:13 2012

A few days ago, a friend of the group said DB in the beginning of backup mode after shutdown not come up, today said backup recovery test a bit, found that can be up, but the production environment or to pay attention, it is best not to do so. sql>

Rman backed up db when: Waiting for snapshot control file Enqueue prompt, rarely see this hint, recorded. Rman> run{ 2> backup Database; 3> Delete noprompt obsolete; 4> backup Archivelog all; 5>} Starting backup at 2011-09-30 15:31:00 Using