Skip to content
- The power of SQL macros
- The missing multiplication aggregation in SQL
- SQL Macros = SQL Injection ?
- Faster software installations
- Application Express – the PSE update
- Updating my APEX 20.2 installation
- Math and SQL: Two of my favourite things
- APEX 20.2 comes to town (well, to my PC)
- The weirdest reason to avoid SELECT *
- Why you keep getting "ORA-01653: unable to extend table"
- Compression default settings
- When can I use SQL Macros?
- Age calculations – Just how old ARE you?
- The CEIL function, dates and floating point numbers
- Docs hack to save you time!
- DBMS_JOB and 19c – code changes needed
- Frequency histogram – where did that estimate come from?
- How to control resource usage on Autonomous
- How to make queries to DBA_FREE_SPACE faster
- How to do a GRANT on an entire schema
- How to upgrade to Oracle 19.8 on Windows
- Developer Live wrap up
- Faster DISTINCT operations in 19c
- How to stop your site from being Clickjacked!
- How to change Scheduler maintenance windows
- Automatically generate audit capture for tables
- How to TREAT data in a CLOB as JSON
- SQL tuning with Hashing and Sorting
- DDL gets my goat
- Completely free training for Oracle novices
- Upgrading…Its Time!
- How to generate random unique values
- Why relying on default DATE formats is a bug
- A better way of calculating Database space usage
- MAX_STRING_SIZE and the data dictionary
- How to migrate to SECUREFILE with DataPump
- Take care with Read-Only partitions in 18c
- Upgrading from 19.6 to 19.7 on Windows
- Getting a dog improved my productivity
- MAX_IDLE_BLOCKER_TIME to stop locking problems
- Code re-use in PL/SQL might just need SQL
- Patching APEX 20 with patch 30990551
- APEX upgrade – don’t forget your CDN
- Arbitrary length addition and subtraction
- Free In-memory in Oracle Database 19c
- Why you might add columns to external tables
- SQL Plus and the ROWPREFETCH parameter
- Expertise might not be the way forward
- PGA memory consumption with BLOBs
- Active Data Guard – limitations on ROWTYPE
- Combinations and consequences
- LOBs are larger in multibyte databases
- Tightened security in 20c for Oracle maintained accounts
- Working from home… Welcome!
- Nulls are not stored in indexes … most of the time
- Simple transaction benchmark on Oracle Database
- When upgrading, choose 19c not 18c
- GROUP BY better than DISTINCT for materialized views
- New LINESIZE settings for SQLPlus
- Handling UTL_FILE_DIR and DIRECTORY objects
- Checking status of the Database Scheduler
- Avoid orphaned Lockdown Profiles
- Getting the most out of in-memory – part 2
- Getting the most out of in-memory
- Why all pluggable database names should be unique
- Listener log data mining with SQL
- dbca silent mode – Windows
- 2019-what grabbed your attention
- Larger number of Exadata storage indexes
- Do you work in I.T?
- Cloning a schema with a one line command
- DML error logging – customising the error log table
- The holistic SQL tuning series
- The definition of proof
- PIVOT does not with materialized view refresh
- All the OpenWorld 2019 downloads!
- Then OpenWorld mega-list
- Extending in-lists past the 1000 item barrier
- Speaker info for Perth, Australia
- My OpenWorld!
- A new use for DML error logging
- DDL invalidates your SQL right ?
- No more stale statistics in 19c
- Plugzilla! A pluggable cloning utility
- Autonomous Transaction Processing – your slice of the pie
- Take a COPY out of SQLcl’s book
- Statistics on Load
- The APEX interface to the OOW catalog is back
- HIGH_VALUE (and other LONG columns) revisited
- Same dog, different leash – functions in SQL
- MERGE and ORA-8006
- SMON_SCN_TIME and ORA-8161? Digging deeper
- Kscope Sunday will be awesome
- With and without WITH_PLSQL within a WITH SQL statement
- Advice on fragmentation and shrinkage
- Generic data models … generic applications … ugh
- DBMS_JOB – the joy of transactions
- DBMS_JOB – watching for failures
- Better optimizer plans for adhoc search
- Generating INSERT scripts that run fast!
- Nostalgia and choosing your in-flight movie
- Partition loading in direct mode
- Raw partitions?
- Take care with automatic indexes
- Capture all DDL run on a database instance
- PL/SQL – Don’t mix and match scope
- Quick and easy masking
- APEX Upgrade redux
- Application Express 19.1
- Bulk processing with FORALL and INSERT-SELECT
- Do not set DETERMINISTIC on functions unrealistically
- Long running scheduler jobs
- Oracle Magazine
- External table preprocessor on Windows
- Connections with a wallet – redux
- Disabled EZCONNECT
- Use V$SQLSTATS not V$SQL to find expensive SQL
- Worth the wait
- Statistics on Object tables
- MERGE and ORA-30926
- The death of UTL_FILE – part 2
- Use the features available!
- DBMS_JOB is an asynchronous mechanism
- Work Life Travel balance
- LISTAGG hits prime time
- Patch conflicts
- From Database 18.3 to 18.5 (on Windows)
- EXPORT not GATHER with DBMS_STATS
- My APEX was fine and then it wasn’t
- 2018-what grabbed your attention
- Your New Years Resolution
- Another day…another "use the right datatype" post
- A Christmas Carol
- Your AskTOM Top 10 for 2018
- It’s all downhill past 30
- Automatic sequences not being dropped
- The phantom tablespace
- IRR function in PLSQL
- You need 10 minutes! Not 5, not 15, not 7
- Happy Thanksgiving!
- 18c and the ignoring of hints
- Add ORDER BY to make ANY query faster
- Interval versus Range partitions
- The Openworld Mega-Download!
- The strange place for INHERIT PRIVILEGES
- OpenWorld is done!
- 18c XE–running locally
- 18c XE is live!
- OpenWorld Wednesday – step right up!
- Compressed LOB–my table got bigger?
- LOBs vs Data – when compression occurs
- ODC Appreciation Day–LOB compression
- OpenWorld Tuesday … yep, still screwed
- Partial Indexes–Take Care With Truncate
- Easy as pi…. hole.
- My APEX 18.2 upgrade in a nutshell
- OpenWorld Monday…I’m so screwed
- Correcting datatypes with minimal downtime
- Datatype conversion laziness … yet another reason
- Another little 12c improvement
- Partial indexing – get the dictionary definitions right
- Connor and Chris at OpenWorld
- The full stack developer….is BACK for 2018!
- Modifying tables without losing materialized views
- Complex materialized views? Try a table first
- 18c database creation on Windows
- 18c Database installation on Windows
- Take care with regular expressions
- Gooey GUIDs
- Let’s talk about Techiquette
- Building community via the speaker community
- Humble pie made with NULL strings
- Hyper-partitioned index avoidance thingamajig
- 18.3 As easy as 1…2…3
- Searching in Oracle Database documentation
- Complex materialized views and fast refresh
- Standard Edition–different optimizer but still cool
- UTL_FILE_DIR and 18c
- More triggers are better
- DDL for constraints – subtle things
- The death of UTL_FILE
- When WHEN went faster
- Juicing up UTL_FILE
- The simplest things….can be risky
- The AskTOM data model
- “Call me!” Many many times!
- Attribute clustering….super cool
- You need scaling huh? Maybe it’s just ego
- From file names to directory hierarchy
- 18.2 patch… painless for me
- When you screw up … make it positive for your users
- Concurrency … the path to success and the path the failure
- TO_DOG_YEAR
- New day….new month….New AskTOM
- Hybrid histograms
- Trip down memory lane
- Text indexes for numbers
- Cool stuff with partition elimination
- ROWNUM and ORDER BY
- Choose your names wisely
- 18c merge partition online
- 18c–If you can’t wait
- Execution plans on LiveSQL
- Oracle Database 18c
- AskTOM Office Hours for DBA’s
- NVL vs COALESCE
- NULL’s vs NOT NULL’s and Performance
- Getting started…adding an account to use
- Those pesky LONG columns
- Identity columns in 12c … just a sequence ?
- Subtle changes in XML, 11g vs 12c
- Dealing with IP addresses
- Brand new year ? Brand new to installing Oracle ?
- Clone a table
- Licensed for Advanced Compression? Don’t forget the network
- It’s not about ego … it’s about knowledge
- 2017–what grabbed your attention
- Seasons greetings from the AskTOM team
- iASH–my “infinite ASH” routine
- LOBs from afar
- So good … it’s scary
- Buffer cache hit ratio–blast from the past
- UKOUG is coming
- Parsing freeform data in flat files
- “Oh…another language is too hard”
- Why being wrong can be awesome
- Idle banter
- Buzzword Bingo
- OpenWorld 2017–grab ALL of the content
- Oracle Developer Community Appreciation Day
- Snapshots from OpenWorld so far
- My OpenWorld theme song
- The devastating death PC emoji of doom
- AskTOM TV–episode 11
- Woo hoo … more OpenWorld 17 content
- OpenWorld 2017–where is the tech content ?
- Partition-wise join
- Updating indexes with partition maintenance
- LOBs and tiny typos
- Partitioning Guide updated
- The AskTOM team at OpenWorld 2017
- Please keep your foreign keys
- Upgrade with no effort
- Behold the full stack developer
- 12c Statistics on load–special cases
- Choosing a password scheme for the database
- AskTOM–more experts to help you!
- Oracle Code … Not for database people ?
- Interval partitioning just got better
- Quick tip–database link passwords
- AskTOM TV episode 8
- Top Ten Travel hints and Tips
- DIY parallel task execution
- It’s just bad code or bad design … most of the time
- Index compression–quick tip
- OTN Yathra 2017
- Instrumentation … not just for debugging
- The village idiot
- Quick tip–identity columns
- Session killin’ time
- Transportable Tablespace–part 2
- Sharing a tablespace between 2 databases
- SUM is better than DISTINCT
- Apex Interactive Grid and IOT’s
- Apex patch for 5.1
- End of an era …
- 12c Release 2, set feedback enhancement in SQL PLus
- Pi Day, March 14
- 12c Release 2 – Transparent Data Encryption online !
- TimTams, Twelve Two, and tete-a-tete !
- Oracle Database 12c Release 2 is here !
- Better to be safe than sorry…
- DDL triggers – interesting results
- Duplicate constraints are impossible right ?
- The real question is … why are you NOT blogging
- Partition count for interval partitioned tables
- AskTom TV
- The SQL Loader log file … as data
- How do I get my trace files on a db-as-a-service
- Haversine PL/SQL
- Logwriter I/O
- Extending Flashback Data Archive in 12c
- Hack-a-Mongo
- AskTom takes another step forward
- What you "liked" last year…
- When local partitions….aren’t
- UKOUG 2016
- Multi-table insert
- A 12.2 treat for the festive season
- Advanced Replication
- max_enabled_roles – nice touch
- Simple demo of message propagation
- Just one more week
- Attribute clustering (part 3)
- Attribute clustering (part 2)
- Attribute clustering (part 1)
- Performing a large correlated update
- OTN tour 2016 APAC
- Code enhancements without changing code
- BULK COLLECT into nested table
- Truncating a timestamp to the second
- Taking a peek at SYS_CONTEXT
- Translating SQL (a migration tool)
- Locked rows and lunch breaks ? A simple fix
- Generating rowids
- Running external programs from the scheduler
- Exceeding 1 million partitions
- Pending statistics and partition queries
- The non-existent partition
- Transaction subtleties
- Data denormalization … another take
- Exadata Express – I’m in !
- Shirts of OpenWorld
- The simple fix to date queries
- Partitioning an existing index
- Securefile in 12c – part 2
- Happy birthday to …. well … us 🙂
- After OpenWorld…
- How important is "up to date" to you ?
- OOW16 – The Park Central
- A bumper OpenWorld 2016 for me…
- Syntax formatter might change your data
- Uber’s move to MySQL
- Little enhancements are always nice
- OpenWorld 2016 is not far away
- Can a query on the standby update the primary ?
- LAG / LEAD quick tip
- Direct mode operations on IOT’s
- dbms_output and the scheduler
- Granular detail from a summary
- LOGGING and temporary space
- Parsing … no big deal eh ?
- 12c FETCH PERCENT
- SQL statements using literals
- MERGE vs UPDATE/INSERT revisited
- Datatypes for DATES
- Let me START WITH sequences
- A cool thing with EXCHANGE PARTITION (part 2)
- Those pesky dates as strings
- OTN Yathra– scenes from Bangalore and Hyderbad
- OTN Yathra Chennai
- Subtle variations in optimizer stats
- Quick tip on Function Based Indexes
- A little known RI clause
- Active and Inactive Sessions
- Why PLSQL ?
- Technology debates
- Understanding scheduler syntax
- AskTom – the personal touch
- Dealing with URL’s
- Opatch quick tip
- Median in SQL
- Are your SQL Plus scripts going to ‘ell ?
- Up to date text indexes
- India bound !
- The death of the demo script
- Views as “stored text”
- Database dictionary corruption ? Maybe not.
- The first matching row
- Tightening up your data model
- TOP-N histograms on 12c
- FOLLOWS clause
- Is a year a leap year ?
- Loading LOB from a file
- Amped on Amper
- How can I see my invisible columns
- Equi-sized partitions on random data
- Something new learned every day
- On building SQL
- DEFAULT SEQ.NEXTVAL in 12c
- Never rely on an assumed order
- EXCHANGE PARTITION revisited
- Public / private cursors
- AskTom–some thoughts on the future
- Bitwise operations
- Auto-backups of PLSQL source
- Forever is a long time
- Common GATHER_PLAN_STATISTIC confusion
- FIRST_ROWS vs FIRST_ROWS_n
- Histograms on data (not the optimizer)
- Automatic date formats
- SQL*Plus quick tip
- SAMPLE costing
- Literals and VARCHAR2
- A old story from the past
- Session level parallelism
- Problematic SQL ? PL/SQL is your friend.
- Not using binds .. banging an obsolete drum ?
- Converting LONG to CLOB
- PL/SQL arrays–the index datatype
- Certification exams
- A little known ORDER BY extension
- Multiple partitions
- AskTom–help us to help you
- Resolutions for 2016
- New Years Resolution–test cases
- Merry Christmas
- How big is my offline datafile ?
- How do I stop the use of TRUNCATE
- The art of describing a problem
- Highlights from UKOUG
- CLOBs are not just big varchars
- UK bound
- The twelve days of … AskTom
- Where did my triggers go ?
- KISS video series for Analytic functions
- ORA-14758: Last partition … cannot be dropped
- Countdown to Perth !
- Apex upgrade 4.2 to 5.0.2
- A justification for referential integrity constraints
- Countdown to Sydney
- CLOBS, from 11g to 12c
- You dont need that sequence number
- A new line on NEWLINE
- The power of metaphor
- Datapump cleanup
- SQL*Plus hints and tips
- Existence checks
- Passing parameters
- Why I love working on AskTom
- My sessions at OpenWorld 2015
- Virtualbox 5.0
- AskTom and formatting
- Fun with array fetch
- Evolution
- exitcommit … or your career down the drain
- Connection shortcuts with a wallet
- Row transposition
- Lets Talk DB Perth
- Longer strings in 12c
- Presenting in Perth on September 9th, 2015
- Less calls…more performance (part 2)
- Less calls…more performance
- Avoiding public embarrassment with triggers
- Where is my tracefile
- Loading file data … easier than you think
- Mr DISTINCT might not be your friend
- Better SQL via query block names
- Index compression–working out the compression number
- Navigating the world of Oracle database documentation
- Joining Oracle
- Things that are there but you cannot use
- Continuous Delivery – Moving to SECUREFILE
- Continuous delivery…
- Partial uniqueness
- Oracle Developer awards…chosen by Developers
- The technology community
- Upgraded and can’t see the tables you could before ?
- You never stop learning
- A new challenge…
- Optimizer curiosity in 12.1.0.2
- Cross-platform database migration
- Datapump TTS quick tip
- From Product X to SQL Developer
- dropping tablespaces and queues – not happy companions
- temporary undo in 12c
- NUMBER data type…what harm can it do ?
- Avoiding the COMMIT bomb!
- (OT) an idea for Easter (and well…every day)
- Edition based redefinition – an apology
- In-memory – can you REALLY drop those indexes ?
- WHEN OTHERS … sometimes just not enough
- v$object_usage catches me out every time 🙂
- RETURNING BULK COLLECT and database links
- GROUP BY – wrong results in 12.1.0.2
- Inappropriate behaviour
- Data Pump import makes me crabby
- Slow external table access
- Analytics Demo Scripts
- ORA-4068 and CONSTANT keyword…good and bad
- truncated ddl in 12c (and 11.2.0.4)
- AUSOUG conference Perth
- A simple 12c query with a cool result …
- Openworld
- Slides from OakTableWorld and OpenWorld
- Openworld day minus 3
- Openworld bound..
- MERGE and IOT’s ….. unhappy bedfellows
- 12c – Nested tables vs Associative arrays
- 12.1.0.2 security grrr…
- Associative arrays and Nested tables
- No Hakan factor for IOT
- 12c nasty with remote query optimization
- Testing…the surgeon’s approach
- Upgrade to 12c … credentials
- Dumb triggers part 2 – session level control
- Really dumb triggers
- An accusatory error message
- SQL injection
- Pluggable database and restricted sessions
- OUGN 2014
- Norway bound
- views in 12c
- Oracle Developer Day Perth
- Free developer day in Perth
- ORA-65131 grrrr
- Man…I really really like this 🙂
- The challenge of optimization
- Cloning databases
- number of set bits
- The cost of Oracle
- Once you’ve done your I/O…there’s still more to do !
- A good day…
- Openworld slides
- Thoughts from OpenWorld
- My stuff at OpenWorld
- 12c FETCH FIRST
- Insync 13 Brisbane
- 30 chars just not enough…
- Compressed partitions are not compressed tables
- How big will my index be ?
- 12c invisible columns
- 12c ddl logging
- 12c install on Windows
- from a friend…
- Feeling raw about raw…
- Expunging the Expand all
- Even on an ocean liner…
- A little quiz on tkprof
- can you lock part of a table ?
- hash keys … almost unique
- Datatype discipline
- Default null for collection parameter
- Long overdue…
- Its not about the outage
- OUGN Norway Conference
- Norway bound
- ORA_HASH and LOBs …. not nice partners
- MERGE – concise syntax but not always fastest
- AUSOUG session February 2013
- Lob CACHE vs NOCACHE – impact on flashback logging
- Off to Norway !
- EXCHANGE PARTITION those pesky columns
- Why can’t I resize my datafile
- IOT’s and a nasty bite on TEMP
- AUSOUG conference 2012
- slides
- Openworld day 4
- Openworld day 3
- Openworld Day 2
- Openworld has commenced…
- Fusion apps
- Goldengate 11gR2
- ACE director briefings
- The next release of Oracle….
- YY vs YYYY…It can make a BIG difference
- OakTable World is coming
- ORA-32033: unsupported column aliasing
- InSync12
- ORA-28511: lost RPC connection to heterogeneous remote agent
- bitmap indexes… better in new versions
- dbms_hs_passthrough–the magic package
- Index size
- Cute partition elimination trick
- Error when dropping user
- Mark Townsend
- Insert after compress
- Mount Wellington
- Tasmania 2012
- Perth AUSOUG meeting
- Calling all Oracle Tasmanians 🙂
- MOS–the brave new world
- UKOUG–feedback from attendees
- Updating primary keys and triggers
- UKOUG day 3
- UKOUG day 2
- UKOUG day 1
- My talks for UKOUG
- UKOUG day minus 1
- UK here I come
- Apress Deal
- Triggers
- UK conference coming up
- Descending index gotcha
- Post conference weather
- AUSOUG conference–day 2
- AUSOUG conference–day 1
- Careful in 11.2 with dbms_utility
- Oracle Certification
- Openworld – Tuesday / Wednesday
- Openworld – Thursday
- Oracle Openworld – Monday
- Hello world!
Like this:
Like Loading...
