Generally help with skewed data
column level statistics (include index statistics and histrogram)
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Translate
Popular Posts
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
There might be a requirement to audit failure logins. sp_readerrorlog works in charm for version 2005 and above, however it is not in sql ...
-
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...
-
Although we see Oracle make it easier to dynamically manager its compoments: shared pool, large pool, buffer cache , java pool . However, ...
-
SEVERE: [FATAL] An internal error occurred within cluster verification framework Unable to get the current group. The relevant platform is H...
-
CRS-5019:All OCR locations are on ASM disk groups [DATA], and none of these disk groups are mounted.In my case , from ASM alert.log , actually it is due to ASM failed to start because of ORA-00600 as shown below. ORA-0060...
-
1. Refresh group failed with FAST REFRESH mode . SQL> exec dbms_refresh.refresh('"ARBOR"."ARBOR_DAILY_REF"...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
Upgraded to Ubuntu 15.10 from 15.10, resolved blank screen by playing with gdm/lightdm. Finally lightdm is my choice, which works with the v...
-
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
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
-
▼
2008
(93)
-
▼
May
(30)
- Merge Join caused Cartesian Product
- structure of redo.log is exactly the same as its a...
- DBMS package for tracing
- 白狐
- the after images
- redo log size
- Determining the Bad Source of statistics
- About Histogram
- Abandom Notepad++
- block's life of Full Table Scan
- remove external procedures
- Database checkpoint
- rows returned order
- object's precedence
- Ojbect Namespace
- reconfig DB Console HTTP port number
- example of index suppressed
- ORA-16014: log 2 sequence# 12 not archived, no ava...
- Useful v$acive_session_history
- Create DB Control
- 对ORACLE DBA 这份职业的看法
- Effect of creating missing index
- large pool for shared server + sga_target
- Check current sql execution plan and historical plan
- Import statistics failed due to object out of synch
- sga_target and its compoents
- RHEL/CentOS5 suspend
- centos 5 can't suspend
- VMware-player-2.0.2-59824.exe caused system keepin...
- How to check datatype length
-
▼
May
(30)