Filter
Exclude
Time range
-
Near
デジタル庁さん、おたくのDBエンジニアこれ出来ますか? ・第三正規系に拘らぬ的確な設計 ・SQLTraceから最適なindex構成、SQL文に書き直せる ・v$ビューを使いこなす、もしくはsystemstate dumpを読み解ける ・block dumpを読み解ける ・adbやdbx でprocessの実行状態、レジスター内を把握できる など
4
390
これ、DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGEのsqltraceみたらパーティション内のデータ(snap_id)が全部削除対象だっ場合はdrop partitionで先に落とした上でdeleteかけてた。エライ。
ASHのメンテナンスでハマリ… sptrunc的なのないんだっけか(DELETEさせたくない)
1
2
26 Aug 2022
理想: // sqltraceは架空のもの db, _ := sql.Open(...) db = sqltrace.Dump(db, os.Stdout)

1
5
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
Replying to @thesharpexpress
so you have sqltrace, sqld360, SQL real time monitor report, ... Anything which enables the switch from guesswork to analyse?
2
#SQLSentry is now using #ExtendedEvents in a Testphase. Finally :-) "Hasta la Vista #SQLTrace" blogs.sentryone.com/johnmart…

1
1
This series on #SQLTrace will teach you how to set up, schedule, and manage traces and the data generated. rd.gt/2iQaMdQ

1
Learn how to use the #SQLTrace subsystem in #SQLserver to audit your instances with this series of articles. rd.gt/2fBXb4L

Trace Files Split in Multiple Parts #SQLTrace #DB12c #DB12cR2 antognini.ch/2016/10/trace-f…

3
9
there is no plan_line in SQLtrace - if it should be, please vote community.oracle.com/ideas/2…

1
1
2
Replying to @sqltrace
@sqltrace Maybe next time you come back the Polercoaster will be done: en.wikipedia.org/wiki/Polerc…

1
Replying to @sqltrace
@sqltrace "Florida Cracker" is an insult to crackers everywhere. :D
1
Switching to xEvents, reason #1: SQLTrace is deprecated #sqlinternals
1
1
3
For an old SQLTrace junkie, trying to learn xEvents, this tool from @SQLPoolBoy is a wonder! #sqlinternals sqlskills.com/blogs/jonathan…

1
2
11
RT @sqltrace: 9 mi run yesterday in training for the @RunRocknRoll marathon (half)! So excited - its going to be GREAT! #RnRSD >> Way to go!