Oracle

--- Spfile is created when you use dbca to create a database.--- Spfile must be created on the shared volume or shared raw device--- All instances use the same spfile--- If you create a database manually, use pfile to create a spfile.[Oracle @ rac11

1. generate an AWR report for a single instance: @ $ ORACLE_HOME/rdbms/admin/awrrpt. SQL 2. generate an Oracle rac awr report: @ $ ORACLE_HOME/rdbms/admin/awrgrpt. SQL 3. Generate AWR reports for specific database instances in the RAC

-- Get all dictionary for oracle db select * From dict; -- select * From dictionary; -- get all columns for dictionarys select * From dict_columns; -- get the default name-space for current user select username, default_tablespace from

Public Network: provides external services for connecting clients, application systems, and databases. In addition to database maintenance, users seldom directly connect to the database,A common practice is to connect a user to a database through

To query the list of users that are CRS administrators: [Grid @ Rac1 ~] $ Crsctl query CRS AdministratorCRS administrator list :* To enable role-separated management and grant privileges to non-permanent CRSAdministrators, you must add specific

I. Concepts of Data Pump:Oracle Data Pump technology can quickly migrate data and metadata from one database to another.Oracle Data Pump consists of three unique parts: 1. command line Client: expdp and impdp2. DBMS_DATAPUMP PL/SQL package (also

In 11g, full table scan may use direct path read to bypass the buffer cache. Such full table scan is physical read. In 10 Gbit/s, it is read through GC buffer, so there is no direct path read problem. High direct path read may be caused: 1. A large

Step by step, no error will be reported IP address planning 192.168.8.241 192.168.8.242192.168.8.248192.168.8.249 Rac1-> export lang = en_US.UTF-8 VI/etc/sysconfig/network-scripts/ifcfg-eth0VI/etc/sysconfig/network-scripts/ifcfg-eth1[Root @ rac2 ~] #

--------- Management of asm (Management of Shared disks)1. Manage the ASM in instance mode. Before starting the database, you must first start the ASM instance. After the ASM instance is started, the ASM disk is mounted. --------- Install the ASM

Cause? -? The plug-in failed in its perform MethodAction? -? Refer to the logs or contact Oracle Support Services.Log File Location/U01/APP/orainventory/logs/installActions2013-01-04_08-37-53PM.log /U01/APP/orainventory/logs/installActions2013-01-04_

Run the following command to find the orphan process on the server that has been connected to the database but the session has been killed but the session resource has not been released. select p.addr from v$process p where pid <> 1 minus

Aggregate functions, multiline functions, and grouping functions are all types of functions.Group by and having Group function: AVG \ sum \ min \ MAX \ count \ stddev \ varianceUse distinct in combination with the group FunctionProcessing of null

Use the dbms_workload_repository package to manage baseline 1. Create a baseline -- Check the existing snapshots in the dba_hist_snapshot view to determine the snapshot range to be used. Select snap_id, dbid, begin_interval_time, end_interval_time,

 Oracle restart improves the availability of your single-instance Oracle database. oracle restart automatically restarts the database instance, the Automatic Storage Management (ASM) instance, the listener, and other components after a hardware or

1. Create a single baseline template using the create_baseline_template stored procedure: Col baseline_name for A30Template_name for A30Select dbid, baseline_id, baseline_name, baseline_type, expiration, template_name from dba_hist_baseline;Dbid

How to determine the IP address of the remote session client in Oracle A few days ago, a tragedy happened to multiple databases in Daniel's Environment: After we changed the passwords of all database hosts and databases,An Oracle database monitoring

-- 1. obtain information about the tablespace to be released (including the tablespace owned by Oracle database)-- Drop table system. tbs_detail;Create Table System. tbs_detail as selectA. tablespace_name,A. Bytes/1024/1024 "sum_mb ",(A.

-- 1. view the Undo tablespace and undo parameters currently used by the instance. SQL> show parameter undo Name type value-----------------------------------------------------------------------------Undo_management string autoUndo_retention integer

Summary of dbms_service subprograms Table 130-5 dbms_service package subprograms Subprogram Description Create_service procedure Creates Service Delete_service procedure Deletes Service

Reprinted from: http://jinyumantang110.blog.163.com/blog/static/5457915620107244833630/ The types of Oracle Data Dictionary views are user, all, and DBA. User _ *: Information about objects owned by users, that is, information about objects created