Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Archives
- 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!
