Archive

Archive for September, 2013

Find size of table in Oracle (includes indexes and LOBs)

September 20, 2013 Leave a comment
COLUMN TABLE_NAME FORMAT A32
COLUMN OBJECT_NAME FORMAT A32
COLUMN OWNER FORMAT A10

SELECT
   owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg
FROM
(SELECT segment_name table_name, owner, bytes
 FROM dba_segments
 WHERE segment_type = 'TABLE'
 UNION ALL
 SELECT i.table_name, i.owner, s.bytes
 FROM dba_indexes i, dba_segments s
 WHERE s.segment_name = i.index_name
 AND   s.owner = i.owner
 AND   s.segment_type = 'INDEX'
 UNION ALL
 SELECT l.table_name, l.owner, s.bytes
 FROM dba_lobs l, dba_segments s
 WHERE s.segment_name = l.segment_name
 AND   s.owner = l.owner
 AND   s.segment_type = 'LOBSEGMENT'
 UNION ALL
 SELECT l.table_name, l.owner, s.bytes
 FROM dba_lobs l, dba_segments s
 WHERE s.segment_name = l.index_name
 AND   s.owner = l.owner
 AND   s.segment_type = 'LOBINDEX')
WHERE owner in UPPER('&owner')
GROUP BY table_name, owner
HAVING SUM(bytes)/1024/1024 > 10  /* Ignore really small tables */
ORDER BY SUM(bytes) desc
;
Advertisements
Categories: Oracle

Python notes

September 20, 2013 Leave a comment

from module import function
from module import *

function(*args)  # Can have many arguments

inventory = {‘gold’ : 500,
‘pouch’ : [‘flint’, ‘twine’, ‘gemstone’], # Assigned a new list to ‘pouch’ key
‘backpack’ : [‘xylophone’,’dagger’, ‘bedroll’,’bread loaf’]}

# Adding a key ‘burlap bag’ and assigning a list to it
inventory[‘burlap bag’] = [‘apple’, ‘small ruby’, ‘three-toed sloth’]

# Sorting the list found under the key ‘pouch’
inventory[‘pouch’].sort()
# Here the dictionary access expression takes the place of a list name

# Your code here
inventory[‘pocket’] = [‘seashell’, ‘strange berry’, ‘lint’]
inventory[‘backpack’].sort()
inventory[‘backpack’].remove(‘dagger’)
inventory[‘gold’] += 50

print inventory

Categories: Uncategorized