Search

OakieTags

Who's online

There are currently 0 users and 45 guests online.

Recent comments

Affiliations

"Good design" is a very ambiguous/subjective term in our profession ;-) #datachat — 20 hours 7 min ago
“@arupnanda: #datachat @OracleAlchemist like everything else, the trick is to find the balance.” +1 — 20 hours 8 min ago
wow - that's a big one ! #datachat @OracleAlchemist20 hours 8 min ago
#datachat @OracleAlchemist like everything else, the trick is to find the balance. — 20 hours 9 min ago
RT +1 "@pioro: @arupnanda Or using defaults which according to vendor can support 10 GB DB and 100 TB DB" — 20 hours 10 min ago
@EricGrancher #datachat +1 — 20 hours 10 min ago
Or using RAC when you shouldn't or don't need it — 20 hours 10 min ago
And let's not get started about RAC and lack of data distribution/partitioning. #datachat — 20 hours 11 min ago
RT @ToonKoppelaars: Also too small sequence cache sizes. #datachat — 20 hours 12 min ago
RT … or not taking them into account (like copy / paste) @arupnanda: #datachat A6 — 20 hours 12 min ago
Today, much less frequently than 10 years ago. RT @confio: Q6: How often do poor configuration options lead to poor performance? #datachat — 20 hours 12 min ago
Yep, another good painful one @ToonKoppelaars20 hours 13 min ago
Also too small sequence cache sizes. #datachat — 20 hours 13 min ago
RT @arupnanda: #datachat A6: poor config is always a result of not understanding the requirements. — 20 hours 13 min ago
#datachat A6: poor config is always a result of not understanding the requirements. — 20 hours 14 min ago
I see poorly configured redo log more than I would like to. #datachat — 20 hours 14 min ago
Things that don't get ironed out are applications that connect per SQL or Session pools that expand when performance slows down #datachat — 20 hours 14 min ago
#datachat A6: almost always — 20 hours 14 min ago
Typical configuration issues: redo logs too small, PGA too small , Parallel query over configured, SQL plans changing #datachat — 20 hours 15 min ago
A6 Configuration performance problems are pretty common but usually get ironed out quickly by competent DBAs #datachat — 20 hours 15 min ago
that can be a bad one for systems that have to stay in sync @pioro20 hours 17 min ago
RT @ddelmoli: Re-provisioning, re-building and building simulated prod envs are under appreciated benefits of virt #datachat — 20 hours 17 min ago
Re-provisioning, re-building and building simulated prod envs are under appreciated benefits of virt #datachat — 20 hours 18 min ago
Delphix eliminates the enormous bureaucracy and resource constraints of provisioning database and data copies by virtualizing data #datachat — 20 hours 19 min ago
The remaining major constraint in IT is provisioning copies of databases and data for environments #datachat — 20 hours 19 min ago
For provisioning environments, VMware, Puppet, Chef etc have alleviated enormous constraints on provisioning environments #datachat — 20 hours 20 min ago
In general, despite the tuning investigation challenges, virtualization is awesome for improving IT and systems performance #datachat — 20 hours 20 min ago
Confio's tools that provide direct insight into VM performance correlated with Oracle performance are exciting #datachat — 20 hours 21 min ago
Finding performance problems due to other VMs or the saturation of resources on ESX can be extremely difficult #datachat — 20 hours 22 min ago
RT @EricGrancher: A5: for the Oracle database, virtualisation is a layer which a challenge as it is not instrumented from the database poin… — 20 hours 22 min ago
On the other hand, since multiple VMs can run on the same shared hardware resouce, other VMs can cause problems #datachat — 20 hours 22 min ago
A5: for the Oracle database, virtualisation is a layer which a challenge as it is not instrumented from the database point of view #datachat — 20 hours 22 min ago
Virtualization requires even more explaining of what could be the cause. Great for dev test. Maybe not so for acc prod? #datachat — 20 hours 22 min ago
DBAs who blame virtualization for problems are just as bad as devs blaming the DB - demand the perf data you need #datachat — 20 hours 22 min ago
RT @arupnanda: #datachat #a5 it makes assessment and tuning much more difficult — 20 hours 24 min ago
#datachat #a5 it makes assessment and tuning much more difficult — 20 hours 25 min ago
@arupnanda for only some definitions of "much" :-) — 20 hours 26 min ago
A4 and of course all ongoing optimizer improvements. Not used in any java project btw... #datachat — 20 hours 26 min ago
#datachat on Q1: mistaking that logical I/O is much better than physical I/O — 20 hours 27 min ago
A4: like @ToonKoppelaars : temporary undo is great #datachat — 20 hours 28 min ago
RT @ddelmoli: If you can't measure or understand the work you DB does for each request, you can't tune it #datachat — 20 hours 28 min ago
RT @kylehhailey: It is not fair when a DBA sees a performance problem in OEM top activity and then yells at a developer who is flying blind… — 20 hours 29 min ago
Q4 - negative impact due to poorly thought out consolidation plans using 12c PDBs #datachat — 20 hours 29 min ago
#datachat @ToonKoppelaars temp undo in 12c is great for using unprotected flash storages — 20 hours 29 min ago
@kylehhailey admittedly in face of ill defined problem statements "click on the big stuff in my graphic" has a fair hit rate. #datachat — 20 hours 30 min ago
a4 I like temporary undo. But only helpfull in specific situation. Like all features btw. #datachat — 20 hours 30 min ago
RT @kylehhailey: It is not fair when a DBA sees a performance problem in OEM top activity and then yells at a developer who is flying blind… — 20 hours 31 min ago
#datachat q4 online partition global index building and partition operation are othjers — 20 hours 31 min ago
Adaptive execution plans RT @confio: Q4: What 12c features do you see as having the greatest performance impact? #datachat — 20 hours 31 min ago
#datachat just to clarify an q4: if I were to choose exactly one 12c feature, it would be hybrid histogram. There are others. — 20 hours 32 min ago