Archives

• DDL invalidates your SQL right ?
• No more stale statistics in 19c
• Plugzilla!
• Autonomous Transaction Processing – your slice of the pie
• Take a COPY out of SQLcl’s book
• Statistics on Load
• It’s 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
• Being generous to the optimizer
• Hacking together faster INSERTs
• Nostalgia and choosing your in-flight movie
• Partition loading in direct mode
• Raw partitions?
• Take care with automatic indexes
• Grab all the DDL
• PL/SQL – Don’t mix and match scope
• Quick and easy masking
• APEX Upgrade redux
• Application Express 19.1
• More chances to bulk process
• Determined on Determinism
• Long running scheduler jobs
• Oracle Magazine
• External table preprocessor on Windows
• Connections with a wallet – redux
• Disabled EZCONNECT
• Less slamming V$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!

One Comment on “Archives”

1. Hi. I need learn install every infraestructure to big data oracle. Please more info. Thansk and regards.

   Reply

Got some thoughts? Leave a comment Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out /  Change )

You are commenting using your Google account. ( Log Out /  Change )

You are commenting using your Twitter account. ( Log Out /  Change )

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

Notify me of new comments via email.

Notify me of new posts via email.

This site uses Akismet to reduce spam. Learn how your comment data is processed.