Tags | Domains | Searches | Statistics | Options | Advanced Search
|
Tags | Domains | Searches | Statistics | Options | Advanced Search |
Pythian Group Blog - Jul 4, 2008
We hit an ORA-01450 error today trying to do online rebuild for an index in an unusable state. This was a non-unique index on a fairly large column — VARCHAR2(800 CHAR). SQL> alter index i1 rebuild online; alter …
Tagged: oracle, online, internals, indexes, group blog posts, iot, index rebuild, ora 01450
Pythian Group Blog - Jul 4, 2008
So, how does one gather statistics on indexes? With InnoDB it’s one thing, with MyISAM it’s another thing. This post however, will focus on MyISAM. There are various ways, each having their own drawbacks and positive …
Tagged: statistics, mysql, myisam, indexes
Pythian Group Blog - Jul 4, 2008
We recently had an issue with a client while cloning a huge database. The result was that we had to restore the whole database as the post-clone corrupted the existing database. Pain! It took another fourteen hours to …
Tagged: cloning, oracle e business suite, clone, dba jobs, post clone
Pythian Group Blog - Jul 4, 2008
Andrew Clarke has published to 104th edition of Log Buffer , the weekly review of database blogs, on Radio Free Tooting, marking LB’s second year. Happy Birthday, LB ! Log Buffer always needs editors, so if you you’d …
Tagged: sql server, oracle, mysql, postgresql, non tech articles, log buffer
Pythian Group Blog - Jul 3, 2008
If you have created a new Oracle 11g database using DBCA and opted to use by default 11g’s enhanced security settings or, at least, the audit setting, then you risk the unlimited growth of the SYSAUS tablespace that …
Tagged: security, oracle, audit, purge, group blog posts, 11g, aud
11g, asm, ausoug, australia, birmingham, community, conference, conferences, database, db2,