Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Daily Archives: October 1, 2010
AWR and Statistics_level
Came across an interesting link between the statistics_level and the AWR data collected. Very easy to mess up the SYSAUX tablespace…..
Posted in Configuration., Enterprise Manager, Oracle, Parameters
Tagged awr, DATA~COLLECTION, STATISTICS_LEVEL, SYSAUX
Comments Off
Move a table with a long column
Generally you cannot move a table containing a long without exporting and importing the object. The alter table MOVE command will fail. Here’s one possible way around it.
Posted in Oracle
Tagged ALTER~TABLE~MOVE, CLOB, CREATE~TABLE~AS~SELECT, CTAS, LOB, LONG
Comments Off
Finding the highest object in a datafile or tablespace.
Finding the highest object in a datafile or tablespace. Here I had a problem, the sysman tablespace had grown very large, but had much less data in it, however I was unable to shrink the datafile. Here’s what you need … Continue reading
Posted in Configuration., Oracle
Tagged ALTER~LOB, ATLER~TABLE~MOVE, LOB, REBUILD, RELOCATE, REORGANZE
Comments Off
Anyone going to try it ?
Whilst investigating my SYSMAN tablespace problem, I came across the following footnote on metalink regarding table occupancy in the AWR…
SYSMAN tablespace grows excessively.
I had the sysman tablespace on a database grow to 22Gb and could not figure out why. Logged an SR for it and followed up with suprising results.
Posted in Configuration., Enterprise Manager, Oracle, Parameters
Tagged ALTER~TABLE, STATISTICS_LEVEL, SYSMAN, WRH$_LATCH_CHILDREN
Comments Off
