Search

OakieTags

Who's online

There are currently 0 users and 25 guests online.

Recent comments

Welcome to the Oaktable

Welcome to the OakTable. The OakTable network is a network for the Oracle scientist, who believes in better ways of administering and developing Oracle based systems. The network is an informal organisation, which will get together at various Oracle events.

Oaktable Challenge

The OakTable Challenge goes live whenever the OakTable Network sets up a stand at any of the public user-oriented events. Previous events which have seen an OakTable stand include: Miracle Open World, the UK Oracle User Group annual conference, and the Rocky Mountain Oracle User Group annual conference.

The OakTable Challenge is simple. Ask us (The OakTable members) any technical Oracle-related question and if we cannot provide you with either a solution or/and answer like, "yes", "no", "we need more information" or "cannot be done" within 24 hours, we'll give you a T-shirt that states that you challenged the OakTable Network - and won!

  • @kevinclosson @TanelPoder Curious - have you tried to truncate each partition in turn ? wouldn't expect it to make a different but ... (?!) 42 weeks 4 days ago
  • @kevinclosson @TanelPoder Slightly less drastic suggestion: use oradebug to remaster the partitions to the local node then truncate. 42 weeks 4 days ago
  • @kevinclosson @sql_handle @pudge1954 @TanelPoder ASSM - max table blocks per bitmap block is 256 => 32 L1 blocks per 64MB extent (8KB blks) 42 weeks 4 days ago
  • @kevinclosson @sql_handle @pudge1954 @TanelPoder For autoallocate Initial 128GB won't be taken literally - expect 64MB or 256MB extents. 42 weeks 4 days ago
  • RT @orcldoug: A seriously overloaded and slow database so you take an ASH dump before the instance is bounced so you don't lose data. Cleve… 42 weeks 4 days ago