-
编辑 删除
Manually Creating a New Oracle Database
Step 1: Decide on Your Instance Identifier (SID) $ export ORACLE_SID=newdb Step 2: Create the Initialization Parameter File Step 3: Creating and Maintaining a Password File (REMOT...
-
编辑 删除
Setup Oracle 10g EM dbconsole
Oracle Enterprise Manager (OEM) is used to manage the database easily. The following options are available: Database Grid Control This option is a...
-
编辑 删除
Index Fragmentation / Rebuild
How to find index fragmented?Step 1, Analyze the index. SQL> analyze index INDEX_NAME validate structure;Step 2, Query INDEX_STATS viewSQL> column status format a10SQL> select tru...
-
编辑 删除
How to Kill the Running DBMS_JOB Process
What Jobs are scheduled in the DB # scheduled_dbms_jobs.sqlset linesize 250col log_user for a10col job for 9999999 head 'Job'col broken for a1 head 'B'col failures for 99 head "fail"col last_da...
-
编辑 删除
Online Drop & Recreate TEMPORARY Tablespace
Check current temporary tablespace status: col FILE_NAME format a30;set lines 200 pages 200select a.TABLESPACE_NAME, a.FILE_NAME, a.FILE_ID, (a.BYTES)/1024/1024 AS "total size(MB)", (b.BYTES_U...
-
编辑 删除
Online Recycling the listener.log File
As the listener.log file grows, the DBA will want to either remove or rename this log file. Most DBAs simply stop the TNS listener process, rename (or remove) the file, then restart the T...
-
编辑 删除
Automatic Database Diagnostic Monitor (ADDM)
ADDM is used to diagnose database performance issues. Its analysis can be performed across any two AWR snapshots. Three options to run ADDM analysis: 1st , Running ADDM Using addmrpt.sql (@$...
-
编辑 删除
Automatic Workload Repository (AWR)
Basically, AWR is an Oracle built-in tool that collects performance related statistics and derives performance metrics from them to track a potential problem. Unlike Statspack, snapshots are collected...
-
编辑 删除
Killing DBMS_JOB
To check scheduled job:scheduled_dbms_jobs.sqlset line 200 pages 200col log_user for a10col job for 9999999 head 'Job'col broken for a1 head 'B'col failures for 99 head "fail"col last_date for a18 h...
-
编辑 删除
Oracle 10g Data Pump
Oracle introduced Data Pump in Oracle Database 10g Release 1. Oracle Data Pump is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle ver...
