When you have a partioned table full of UUIDs but partitioned through timestamp, you need a way to translate the UUID back into a timestamp to match a partition where the key is stored. So here is my way of how to extract the timestamp out of an UUIDv1.
- get oracle allocation sizes part 2
- calculating percentiles in oracle
- query index usage statistics in oracle
- query clob settings in oracle
- get table and index allocation size in oracle
- detect whether ASSM is managing your tablespace