Oracle SQL
  • LICENSE

More on tracing the offload server

Posted on May 4, 2017 by Roger MacNicol Posted in cell_offload, oracle, SmartScan, trace 1,656 Page views 0 Comments

I posted a while back on how to use Tracing Hybrid Columnar Compression in an offload server so this is a quick follow up.

  1. I have trouble remembering the syntax for setting a regular parameter in an offload server without bouncing it. Since I need to keep this written down somewhere I thought it might be use to support folks and dbas.
  2. I forgot to show you how to specify which offload group to set the trace event

So this example should do both: 

1
CellCLI > alter cell offloadGroupEvents = "immediate cellsrv.cellsrv_setparam('my_parameter, 'TRUE')", offloadGroupName = "SYS_122110_160621"

this will, of course, set a parameter temporarily until the next time the offload server is bounced, but also adding it to the offload group’s init.ora will take care of that.

Cell Offloading HCC oracle Roger MacNicol SmartScan traces
« Tracing Hybrid Columnar Compression in an offload server
Using INMEMORY with External Tables »
Page views: 1,656
photo Sayan Malakshinov

Oracle ACE Pro Oracle ACE Pro Alumni

DEVVYOracle Database Developer Choice Award winner

Oracle performance tuning expert

UK / Cambridge

LinkedIn   Twitter
sayan@orasql.org

Recent Posts

  • Oracle Telegram Bot
  • Partition Pruning and Global Indexes
  • Interval Search: Part 4. Dynamic Range Segmentation – interval quantization
  • Interval Search Series: Simplified, Advanced, and Custom Solutions
  • Interval Search: Part 3. Dynamic Range Segmentation – Custom Domain Index

Popular posts

  • Amazing optimization of getting distinct values from the index, and TopN for each of them
    2012/09/21 by Sayan Malakshinov: 11.9k views
  • Oracle diagnostic events — Cheat sheet
    2021/05/20 by Sayan Malakshinov: 9.2k views
  • Deterministic functions, result_cache and operators
    2014/03/31 by Sayan Malakshinov: 8.8k views
  • Deterministic function vs scalar subquery caching. Part 1
    2013/02/10 by Sayan Malakshinov: 8.6k views
  • Differences between integer(int) in SQL and PL/SQL
    2012/11/10 by Sayan Malakshinov: 8.1k views
  • SQL*Plus tips #5: sql_text/sql_fulltext formatting(sql beatifier)
    2013/04/29 by Sayan Malakshinov: 7.9k views
  • Top-N again: fetch first N rows only vs rownum
    2018/12/30 by Sayan Malakshinov: 7.3k views
  • SQL*Plus tips #6: Colorizing output
    2013/05/22 by Sayan Malakshinov: 5.9k views
  • SYS_OP_MAP_NONNULL is in the documentation now
    2014/02/10 by Sayan Malakshinov: 4.3k views
  • Workaround for deadlock with select for update order by on 11.2.0.2-11.2.0.3
    2013/02/16 by Sayan Malakshinov: 4.3k views
  • SQL*Plus tips #4: Branching execution
    2013/04/17 by Sayan Malakshinov: 3.9k views
  • SQL*Plus tips. #1
    2013/03/29 by Sayan Malakshinov: 3.7k views

Recent Comments

  • Oracle SQL | Interval Search: Part 4. Dynamic Range Segmentation – interval quantization on Interval Search: Part 3. Dynamic Range Segmentation – Custom Domain Index
  • Oracle SQL | Interval Search: Part 4. Dynamic Range Segmentation – interval quantization on Interval Search: Part 2. Dynamic Range Segmentation – Simplified
  • Oracle SQL | Interval Search: Part 4. Dynamic Range Segmentation – interval quantization on Interval Search: Optimizing Date Range Queries – Part 1
  • Oracle SQL | Interval Search Series: Simplified, Advanced, and Custom Solutions on Interval Search: Part 2. Dynamic Range Segmentation – Simplified
  • Oracle SQL | Interval Search: Part 2. Dynamic Range Segmentation – Simplified on Interval Search: Part 3. Dynamic Range Segmentation – Custom Domain Index

Blogroll

  • Alex Fatkulin
  • Alexander Anokhin
  • Andrey Nikolaev
  • Charles Hooper
  • Christian Antognini
  • Coskan Gundogar
  • David Fitzjarrell
  • Igor Usoltsev
  • Jonathan Lewis
  • Karl Arao
  • Mark Bobak
  • Martin Bach
  • Martin Berger
  • Neil Chandler
  • Randolf Geist
  • Richard Foote
  • Riyaj Shamsudeen
  • Tanel Poder
  • Timur Akhmadeev
  • Valentin Nikotin
©Sayan Malakshinov. Oracle SQL