Oracle

Follow the steps below:1, check the user's proifle is which, is generally default:Sql>SELECT username,profile from Dba_users;2. View the password expiration settings for the specified profile (such as default):Sql>SELECT * from dba_profiles s WHERE

1. Modify the login identifier and default editor (not required)Modify $oracle_home/sqlplus/admin/glogin.sql to add the following at the end of the file:set sqlprompt ' _user ' @ ' _connect_identifier> 'define _EDITOR=VI2. Create initialization

Resizing swap partitionsMethod One: If the disk has the remaining space, use the partition tool to create a new swap partition. and write to/etc/fstab inside.Again #swapon-AMethod Two: You can use a file to do the swap partition.Su RootCD/Mkdir/swap1

Life, easy to forget the Oracle database system user password, how to do it, niche take you step by step back to Oracle, timely your password forgotten.1. Open cmd window, enter Sqlplus/as SYSDBA2, run CMD, enter the ALTER user username account

V$session is a synonym for the sys.v_$session view under the apps user.In this view, each session that is connected to a database instance has a record. including user session and background process such as dbwr,lgwr,arcchiver and so on.v$session

First, why need data backupThe main reasons for data loss:1, media failure.2, the user's error operation.3, the server's complete collapse.4, computer viruses.5. Unforeseen factors.The fault types in Oracle are divided into the following 4

The difference of function between Exp/imp and EXPDP/IMPDP:　　1, the user UserA to import the object into the UserBEmp/imp usage:Formuser=usera Touser=userb;EMPDP/IMPDP usage:Remap_schema= ' UserA ': ' UserB 'For example:Imp system/password

The calculation formula of average transaction response time in Oracle databaseNote: This calculation formula is taken from: Eel with Optimize journaling >> , p316 pageTop 5 Timed Events Event Waits Time (s) AVG Wait

1. Conflict resolutionIf there is a system that only you and me two users, and we are constantly in the system of a small number of data modification and query operations.If you're doing a batch of modifications in the database, and I'm doing a

1. How to unlock Scott account cause: The default oracle10g Scott cannot log in. Solution:(1) Conn Sys/sys as sysdba;//logged in as DBA(2) ALTER user Scott account unlock;//then unlock(3) Conn Scott/tiger//Popup A Password Change dialog box, modify

Oracle 11g InstallationFirst, the Environment preparation Dividing area /15000M/tmp 4096M/boot 100MSwap 4096M/u01 remaining space2. Change host name, IP address3. Install the PackageThen the Linux system needs to prepare the

Today, when doing Oracle archive testing, I found a few questions, which I want to be able to get everyone's faults and help.[Email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.1.0 Production on Fri Dec 17:34:42 2014Copyright (c) 1982,

In your database, online redo log files is multiplexed and one of theMembers in a group are lost due to media failure?How would recover the lost redo log member?A.import the last export of the database from theB.restore all the "the" group from the

--This article can be pasted directly into the Plsql run, the test table to create it yourself--Test name: Test Oracle Recursive--oracle version: oracle8i--Sample table: S_coalarea_test (Region table)--Table structure: country level (grade) 1 Level

1.shutdown Normal or shutdown immediate close the databaseSql*plus:release 12.1.0.1.0 Production on Monday December 15 15:49:47 2014Copyright (c) 1982, Oracle. All rights reserved.Connect to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-6

The Oracle database has three standard backup methods, namely export/import (EXP/IMP), hot and cold backup. Exporting a spare is a logical backup, and cold and hot backups are physical backups.First, export/import (Export/import)With export, data

User Creation (learning notes), User Creation learning notes Create a user: Syntax: Create user Username identified by password [default tablespace name] [temporary tablespace table name] [QUOTA number [K | M] unlimited on tablespace name QUOTA

[Original] solves the problem of excessive oracleCPU with the help of AWR report analysis, awroraclecpu  Introduction:In oracle databases, there are two very useful built-in monitoring tools: EM (Enterprise Manager) and AWR (Automatic Workload

Database backup and recovery (learning notes), backup learning notes -- ********************** Data Pump Technology ------ oracle 10 Gb later appeared -- Create a directory Create directory dump_dir as 'e:/backup '; -- Query all directories in the

Detailed description of oracle high water level line and oracle water level line 1. What is a High Water Mark )? All the oracle segments (segments here, for ease of understanding, we recommend that you use segment as a synonym for the table) have an