LOCALITY indicates whether this partitioned index is LOCAL or GLOBAL.
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Translate
Popular Posts
-
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
Lots of such article in internet, also can refer to " F.3 Using the DUPLICATE Command to Create a Standby Database" in Oracle...
-
Need to reduce AWR retention due to no disk space in this development database. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 ...
-
verify the connectivity before rman DUPLICATE command, but hit below error. orarac2poc:DGS:/u01/app/oracle/product/11.2.0/db_2/dbs> sqlp...
-
Tuned a " HASH GROUP BY" after increase the pga_aggregate_target from 190MB to 2GB , since workload increased over the time. Feel...
-
RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # de...
-
1. Refresh group failed with FAST REFRESH mode . SQL> exec dbms_refresh.refresh('"ARBOR"."ARBOR_DAILY_REF"...
-
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
Labels
- 10g (35)
- 11g (13)
- 12c (9)
- 4.3 (1)
- ACHI (1)
- AIX (3)
- Android (1)
- APEX (8)
- Architecture (2)
- ASM (3)
- audit (1)
- automation (1)
- AWR (4)
- backup and recovery (15)
- Basic (22)
- Best Practices (3)
- bind variable (2)
- BIOS (1)
- Bleeding Case (20)
- bug (3)
- career (2)
- case (7)
- centos (4)
- character set (1)
- cloud control (11)
- clusterware (1)
- Concept (1)
- cron (1)
- Cygwin (1)
- Data Guard (13)
- data management (6)
- DBConsole (5)
- dbua (2)
- delphix (2)
- Edge (2)
- Error latch (1)
- events (1)
- Exam (1)
- Experience (2)
- firmware (1)
- flashback (3)
- Fun (1)
- Fundamental (36)
- HDD (1)
- health check (1)
- Hidden Parameter (2)
- Howto (2)
- install (1)
- instantclient (1)
- ITIL (2)
- itpub (2)
- ITSM (2)
- Java (1)
- jmeter (1)
- joomla (2)
- knives (3)
- knowledge gained (1)
- labs (5)
- latch (1)
- Lazarus (2)
- life (6)
- Linux (36)
- Listener (3)
- LogMiner (1)
- management (5)
- migration (7)
- mind (1)
- mview (3)
- mysql (3)
- NewFeature (3)
- ODBC (1)
- OEM (9)
- oerr (27)
- opatch (2)
- ora600 (1)
- OS (1)
- outline (1)
- Partition (4)
- performance (5)
- PGA (2)
- PL/SQL (5)
- postgresql (1)
- Price (1)
- programming (1)
- qnap (2)
- question (2)
- RAC (6)
- raw device (3)
- Recovery (23)
- RHCE (1)
- RMAN (50)
- SAP Basis (1)
- scripts (1)
- security (7)
- Server-Generated Alert (2)
- shared server (3)
- Software Engineering (4)
- sql developer (3)
- sql*plus (2)
- sqlnet (1)
- sqlserver (13)
- SSD (2)
- SSD IO (1)
- standards (1)
- statistics (5)
- statspack (2)
- Stock (1)
- storage (2)
- timesten (2)
- tips (45)
- Tools (38)
- Trace (3)
- Tuning (17)
- Ubuntu (24)
- Unix (5)
- vertica (1)
- vmware (2)
- vnc (1)
- WhatIs (1)
- XServer (1)
- zabbix (1)
Blog Archive
-
▼
2007
(89)
-
▼
May
(15)
- Bad magic number
- ORA-1031 : change oracle owner group
- TSM产品大比拼擂台
- 运用HP OpenView实施ITSM理念
- About ITIL
- 论中国ITIL实施
- Recover from loss of the password file
- Recovering from a Read-Only Tablespace
- Mview log is not purged
- How to check locality of partition table's index
- Error Message: "Total lru latches configured: 1; l...
- Recovering from loss of an Index Tablespace
- recovering from loss of an Online Redo Log File
- recovering from loss of a Temporary Tablespace
- Create DB Control in Active/Passive High Availabil...
-
▼
May
(15)