Reputation
422
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 7 16
Impact
~55k people reached

  • 0 posts edited
  • 0 helpful flags
  • 36 votes cast
Aug
19
awarded  Notable Question
Jun
2
awarded  Yearling
Apr
10
awarded  Famous Question
Oct
10
awarded  Notable Question
Oct
7
awarded  Famous Question
Aug
1
awarded  Popular Question
Jul
2
awarded  Curious
Apr
9
awarded  Popular Question
Mar
25
awarded  Notable Question
Nov
5
awarded  Popular Question
Jul
2
awarded  Popular Question
Mar
18
answered Materialized View does not import properly when importing a db for a second time in another schema
Mar
11
awarded  Notable Question
Jan
2
comment Simplified/automated datafile free disk space reclaim
Interesting info: check if your tablespaces are "locally managed" or "directory managed". The former seems to have a better handling of "defragmenting" datafiles. See: orafaq.com/node/3
Oct
7
awarded  Yearling
Sep
26
awarded  Popular Question
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Apr
6
answered ORA-01502: index or partition of such index is in usable state problem
Mar
21
comment At which frequency run CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on a fulltext index?
Thanks for those very interesting "starting points".