30 Jun 2023
デジタル庁さん、おたくのDBエンジニアこれ出来ますか？
・第三正規系に拘らぬ的確な設計
・SQLTraceから最適なindex構成、SQL文に書き直せる
・v$ビューを使いこなす、もしくはsystemstate dumpを読み解ける
・block dumpを読み解ける
・adbやdbx でprocessの実行状態、レジスター内を把握できる
など
4
390
5 Oct 2022
これ、DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGEのsqltraceみたらパーティション内のデータ(snap_id)が全部削除対象だっ場合はdrop partitionで先に落とした上でdeleteかけてた。エライ。
24 Aug 2022
ASHのメンテナンスでハマリ…
sptrunc的なのないんだっけか（DELETEさせたくない）
1
2
2 Jul 2022
@JoshLuedeman
@lauraetiffany
@lotsahelp
@Sherrishh
@Spritelings
@SQLAJ
@SQLdad
@SQLServerIO
@sqltrace
@SQLvariant
@tradney
@TreySQL
@VesDBA
3/3
1
2
14 Dec 2020
How to Use SQL Trace , Trcsess and TKPROF | Oracle Database Performance Tuning Tutorial #SQLTrace
#Oracle #DBA #PerformanceTuning #TKPROF
ittutorial.org/how-to-use-sq…
2
2
8 Dec 2019
SQL Profiler ne demektir? Trace almak ne demektir?
#hergüne1sqlbilgisi #sqlprofiler #sqltrace #tracealmak
#sql #sqlserver #sqlservertips #mssql #tsql #sqladministration #dbManagement #veritabanıYönetimi #sqlperformance
#ocolakoglu #udemysql
6
31
6 Dec 2019
so you have sqltrace, sqld360, SQL real time monitor report, ...
Anything which enables the switch from guesswork to analyse?
2
13 Nov 2017
#SQLSentry is now using #ExtendedEvents in a Testphase. Finally :-)
"Hasta la Vista #SQLTrace" blogs.sentryone.com/johnmart…
1
1
12 Jan 2017
This series on #SQLTrace will teach you how to set up, schedule, and manage traces and the data generated. rd.gt/2iQaMdQ
1
28 Nov 2016
Learn how to use the #SQLTrace subsystem in #SQLserver to audit your instances with this series of articles. rd.gt/2fBXb4L
13 Oct 2016
3
9
28 Jun 2016
there is no plan_line in SQLtrace - if it should be, please vote community.oracle.com/ideas/2…
1
1
2
15 Oct 2015
@sqltrace Maybe next time you come back the Polercoaster will be done: en.wikipedia.org/wiki/Polerc…
1
10 Jan 2015
For an old SQLTrace junkie, trying to learn xEvents, this tool from @SQLPoolBoy is a wonder! #sqlinternals sqlskills.com/blogs/jonathan…
1
2
11
17 May 2012
RT @sqltrace: 9 mi run yesterday in training for the @RunRocknRoll marathon (half)! So excited - its going to be GREAT! #RnRSD >> Way to go!