skip to main
|
skip to sidebar
Oracle Study Notes by Denis
I am starting to study SQL Server as well
Friday, March 02, 2007
FW: locked pkg in gen2
The contents are removed. 03-26-09
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Like this Facebook page:
Database Administration Digest
About Me
View my complete profile
Twitter
Recent Comments
Blog Archive
►
2016
(1)
►
March
(1)
►
2015
(4)
►
April
(1)
►
March
(3)
►
2014
(11)
►
October
(1)
►
June
(2)
►
April
(3)
►
March
(2)
►
February
(1)
►
January
(2)
►
2013
(14)
►
October
(1)
►
September
(4)
►
August
(2)
►
July
(2)
►
June
(3)
►
May
(1)
►
March
(1)
►
2012
(11)
►
November
(1)
►
October
(5)
►
August
(1)
►
July
(2)
►
April
(1)
►
January
(1)
►
2011
(19)
►
December
(1)
►
November
(2)
►
October
(3)
►
September
(3)
►
May
(1)
►
April
(1)
►
February
(7)
►
January
(1)
►
2010
(22)
►
October
(1)
►
September
(1)
►
August
(2)
►
May
(3)
►
April
(7)
►
March
(5)
►
January
(3)
►
2009
(85)
►
December
(1)
►
November
(4)
►
October
(3)
►
September
(4)
►
August
(6)
►
July
(6)
►
June
(9)
►
May
(8)
►
April
(13)
►
March
(12)
►
February
(7)
►
January
(12)
►
2008
(62)
►
December
(11)
►
November
(9)
►
October
(7)
►
September
(7)
►
August
(8)
►
July
(3)
►
June
(16)
►
January
(1)
▼
2007
(123)
►
December
(5)
►
November
(10)
►
October
(11)
►
September
(23)
►
August
(10)
►
July
(14)
►
June
(10)
►
May
(13)
►
April
(10)
▼
March
(4)
Apply DDL in a replcation environment - not workin...
Using %TYPE
Sort in memory vs in disk
FW: locked pkg in gen2
►
February
(5)
►
January
(8)
►
2006
(70)
►
October
(1)
►
September
(11)
►
August
(29)
►
July
(22)
►
June
(7)
Label Cloud
_b_tree_bitmap_plan
(1)
01 - Performance Tunning
(2)
11g
(3)
ADG
(1)
alert log
(1)
alter table
(2)
analytic function
(3)
anti-join
(4)
archived log
(2)
ASM
(7)
ASSM
(1)
autotrace
(1)
AWK
(2)
AWR
(2)
backup
(5)
Big Data
(1)
bind variable
(4)
block corruption
(1)
boobooke
(1)
buffer hit ratio
(1)
bug
(1)
bulk collect
(4)
cancel-based recovery
(1)
case when
(3)
CBO
(9)
CentOS
(1)
clone
(5)
Cloud Computing
(1)
cluster
(1)
collection
(1)
concepts
(1)
configuration
(2)
connect by
(3)
constraint
(3)
control files
(2)
cursor
(1)
cursor variable
(2)
cursor_sharing
(2)
data dictionary
(1)
data files
(2)
data pump
(2)
data type
(1)
Database Control
(1)
database design
(1)
database link
(1)
DataGuard
(7)
DB Console
(1)
DBA command syntax
(7)
DBA General
(2)
DBA script
(2)
DBA_TAB_COL_STATISTICS
(1)
DBA_TAB_STATISTICS
(1)
DBID
(1)
DBMGRL
(1)
DBMS_JOB
(2)
DBMS_METADATA
(1)
DBMS_SCHEDULER
(1)
DBMS_SQLTUNE
(1)
DBMS_STATS
(8)
DBNEWID
(1)
DBSNMP
(1)
dbverify
(1)
deadlock
(1)
direct-path insert
(1)
duplicate row
(2)
email
(1)
errorstack dump
(1)
execution plan
(4)
exp
(2)
expdp
(1)
FGA
(1)
fine grained access
(1)
flashback
(4)
FORALL
(1)
GoldenGate
(4)
GTT
(1)
hanganalyze
(1)
I/O
(3)
imp
(2)
impdp
(1)
incarnation
(1)
index
(4)
index fast full scan
(1)
index rebuild
(3)
initialization parameter
(1)
installation
(7)
intelligent agent
(1)
interview
(4)
IOT
(1)
Java
(1)
join
(1)
Just Learned
(1)
kill
(1)
kopm$
(1)
latch
(2)
latency
(1)
library cache lock
(2)
library cache pin
(1)
listener.ora
(2)
Load Balancing
(1)
lock
(3)
logminer
(1)
MariaDB
(1)
materialized view
(4)
migration
(2)
MISC
(1)
mistake
(3)
multi-column index selectivity
(1)
MySQL
(1)
nologging
(1)
OCP
(44)
OCR
(2)
OEM
(1)
OGG
(1)
online redifinition
(1)
ORA-00600 [20022]
(1)
ORA-01555
(1)
ORA-01652
(1)
ORA-01722
(1)
ORA-14047
(1)
ORA-27101
(1)
ORA-27102
(1)
Oracle 12c
(1)
Oracle Advanced Replication
(5)
Oracle internal
(1)
Oracle Net
(1)
oradebug
(2)
package
(1)
parallel execution
(2)
parallel_index
(1)
parse
(1)
partition
(4)
patch
(3)
performance troubleshooting
(4)
performance tunning
(6)
pfile
(1)
pivot
(1)
PL/SQL
(13)
PL/SQL Package
(2)
Plan Guide
(1)
privilege
(1)
processstate dump
(1)
ps
(1)
RAC
(9)
rank
(1)
raw device
(1)
RBO
(1)
recovery
(9)
recyclebin
(1)
redo log
(2)
ref cursor
(2)
reference
(4)
regular expression
(1)
relink
(1)
relocate data files
(1)
reorganize
(1)
replication
(22)
resource manager
(1)
restore
(1)
RLS
(1)
RMAN
(22)
row_number()
(1)
ROWID
(2)
Runstat
(1)
schedular
(1)
scripts
(2)
Segment Advisor
(1)
self join
(1)
semi-join
(3)
sequence
(3)
session_cached_cursors
(1)
shared pool
(2)
SharePlex
(2)
shell scripting
(7)
snapshot too old
(1)
Solaris
(2)
sort
(2)
SPA
(1)
SQL
(24)
SQL Function
(1)
SQL Loader
(1)
SQL Plan Baseline
(3)
SQL Plus
(3)
Sql Profiles
(2)
SQL Server
(10)
sql tuning
(32)
SQL_TRACE
(2)
SQLPATH
(1)
SSH
(1)
standby
(8)
startup
(1)
statspack
(5)
storage
(1)
streams
(5)
switchover
(1)
SYSDATE
(1)
systemdump
(1)
table function
(2)
tablespace
(2)
TABLOCK
(1)
TAF
(1)
tempfile
(1)
tempoary table
(1)
temporary tablespace
(2)
test case
(5)
tip
(7)
TKPROF
(1)
TO_DATE
(1)
transaction
(1)
transaction isolation level
(1)
transaction read only
(1)
transportable tablespace
(3)
trigger
(1)
troubleshooting
(5)
unique index
(1)
unix
(8)
update
(2)
upgrade
(3)
v$lock
(1)
v$pwfile_user
(1)
v$session_longops
(1)
v$sql
(1)
v$sqlarea
(1)
VCS
(1)
video lecture
(1)
virtual box
(1)
virtual private database
(1)
VMware
(1)
wait event
(4)
My Blog List
Oracle Scratchpad
AWR Snap ID
1 week ago
Tanel Poder's blog: Core IT for geeks and pros
Oracle Shared Pool Internals: Allocated Chunk Status Indicators in Heap Dumps
5 weeks ago
Oracle related stuff
Oracle 19c RU Release Update 19.19 nice little enhancement: DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES columns populated
6 months ago
Kerry Osborne's Oracle Blog
HTAP: Well, How Did We Get Here?
6 months ago
Cary Millsap
How Slow Programs Are Like Christmas: a Sales Pitch
7 months ago
Dion Cho - Oracle Performance Storyteller
Interesting case of the restriction of global hints
13 years ago
Oracle Links
Alejandro Vargas's Blog
Ask Tom
Database Journal
DBA Support
Doug's Oracle Blog
ITPUB Personal Space - Tangbufan
Jeff Hunter's DBA/Development Website
OakTable
Oracle 10gR2 Document Library
Oracle FAQ's
Random Post
No comments:
Post a Comment