Performance Tuning

New Topic

35 topics • Page 1 of 1

Topics

Replies

Views

Last post

tkprof advise

Last post by xaeresis « Fri Nov 10, 2023 4:32 am
Replies: 2
by smac1 » Sat Feb 15, 2014 5:20 am

2 Replies

1572 Views

Last post by xaeresis
Fri Nov 10, 2023 4:32 am
Gathering Statistics

Last post by xaeresis « Thu Nov 09, 2023 5:34 pm
Replies: 2
by jimb » Sat Feb 04, 2012 10:21 pm

2 Replies

1522 Views

Last post by xaeresis
Thu Nov 09, 2023 5:34 pm
Quick Win Tips for SQL Performance Tuning

Last post by xaeresis « Thu Nov 09, 2023 5:20 pm
Replies: 1
by jimb » Sat Feb 04, 2012 1:24 pm

1 Replies

1500 Views

Last post by xaeresis
Thu Nov 09, 2023 5:20 pm
Using SQL Trace and TKPROF

Last post by xaeresis « Thu Nov 09, 2023 5:05 pm
Replies: 2
by jimb » Sat Feb 04, 2012 1:17 pm

2 Replies

1778 Views

Last post by xaeresis
Thu Nov 09, 2023 5:05 pm
View Long Running Operations

Last post by xaeresis « Thu Nov 09, 2023 3:11 pm
Replies: 2
by jimb » Fri Feb 03, 2012 11:01 am

2 Replies

1582 Views

Last post by xaeresis
Thu Nov 09, 2023 3:11 pm
Show Sessions With High I/O

Last post by xaeresis « Thu Nov 09, 2023 2:56 pm
Replies: 2
by jimb » Fri Feb 03, 2012 10:58 am

2 Replies

1468 Views

Last post by xaeresis
Thu Nov 09, 2023 2:56 pm
Top Segments with most I/O

Last post by xaeresis « Thu Nov 09, 2023 10:38 am
Replies: 2
by jimb » Thu Feb 02, 2012 3:10 pm

2 Replies

788 Views

Last post by xaeresis
Thu Nov 09, 2023 10:38 am
Indexes ANALYZE Status

Last post by xaeresis « Thu Nov 09, 2023 10:24 am
Replies: 2
by jimb » Thu Feb 02, 2012 3:09 pm

2 Replies

883 Views

Last post by xaeresis
Thu Nov 09, 2023 10:24 am
Tables ANALYZE Status

Last post by xaeresis « Thu Nov 09, 2023 10:09 am
Replies: 2
by jimb » Thu Feb 02, 2012 3:07 pm

2 Replies

924 Views

Last post by xaeresis
Thu Nov 09, 2023 10:09 am
Top 5 Queries (Executions)

Last post by xaeresis « Thu Nov 09, 2023 9:55 am
Replies: 1
by jimb » Thu Feb 02, 2012 3:05 pm

1 Replies

937 Views

Last post by xaeresis
Thu Nov 09, 2023 9:55 am
Latch Section

Last post by xaeresis « Thu Nov 09, 2023 8:44 am
Replies: 1
by jimb » Thu Feb 02, 2012 2:58 pm

1 Replies

734 Views

Last post by xaeresis
Thu Nov 09, 2023 8:44 am
Redo log buffer

Last post by xaeresis « Thu Nov 09, 2023 8:29 am
Replies: 2
by jimb » Thu Feb 02, 2012 2:57 pm

2 Replies

837 Views

Last post by xaeresis
Thu Nov 09, 2023 8:29 am
Library Cache Section

Last post by xaeresis « Thu Nov 09, 2023 8:15 am
Replies: 13
by jimb » Thu Feb 02, 2012 2:55 pm
1

2
13 Replies

863 Views

Last post by xaeresis
Thu Nov 09, 2023 8:15 am
Library cache miss ratio

Last post by xaeresis « Thu Nov 09, 2023 8:00 am
Replies: 2
by jimb » Thu Feb 02, 2012 2:51 pm

2 Replies

844 Views

Last post by xaeresis
Thu Nov 09, 2023 8:00 am
Data Dictionary Hit Ratio

Last post by xaeresis « Thu Nov 09, 2023 7:46 am
Replies: 2
by jimb » Thu Feb 02, 2012 2:47 pm

2 Replies

844 Views

Last post by xaeresis
Thu Nov 09, 2023 7:46 am
Locked Sessions

Last post by xaeresis « Thu Nov 09, 2023 7:31 am
Replies: 2
by jimb » Thu Feb 02, 2012 2:43 pm

2 Replies

794 Views

Last post by xaeresis
Thu Nov 09, 2023 7:31 am
Waits - What are users currently waiting on?

Last post by xaeresis « Thu Nov 09, 2023 6:48 am
Replies: 2
by jimb » Thu Feb 02, 2012 2:40 pm

2 Replies

983 Views

Last post by xaeresis
Thu Nov 09, 2023 6:48 am
Waits - By Class

Last post by xaeresis « Thu Nov 09, 2023 6:34 am
Replies: 1
by jimb » Thu Feb 02, 2012 2:38 pm

1 Replies

1041 Views

Last post by xaeresis
Thu Nov 09, 2023 6:34 am
Waits - Instance Level (by time waited)

Last post by xaeresis « Thu Nov 09, 2023 6:19 am
Replies: 2
by jimb » Thu Feb 02, 2012 2:35 pm

2 Replies

854 Views

Last post by xaeresis
Thu Nov 09, 2023 6:19 am
Waits - Waiting Session's SQL

Last post by xaeresis « Thu Nov 09, 2023 6:05 am
Replies: 1
by jimb » Thu Feb 02, 2012 2:34 pm

1 Replies

880 Views

Last post by xaeresis
Thu Nov 09, 2023 6:05 am
List Large Objects In Shared Pool

Last post by xaeresis « Thu Nov 09, 2023 5:50 am
Replies: 2
by jimb » Thu Feb 02, 2012 2:29 pm

2 Replies

741 Views

Last post by xaeresis
Thu Nov 09, 2023 5:50 am
To see if you have set OPEN_CURSORS high enough

Last post by xaeresis « Thu Nov 09, 2023 12:13 am
Replies: 2
by jimb » Wed Feb 01, 2012 11:59 am

2 Replies

659 Views

Last post by xaeresis
Thu Nov 09, 2023 12:13 am
Monitoring total cursors open, by username & machine

Last post by xaeresis « Wed Nov 08, 2023 11:58 pm
Replies: 2
by jimb » Wed Feb 01, 2012 11:58 am

2 Replies

711 Views

Last post by xaeresis
Wed Nov 08, 2023 11:58 pm
Track CPU Usage

Last post by xaeresis « Wed Nov 08, 2023 11:44 pm
Replies: 1
by jimb » Wed Feb 01, 2012 11:56 am

1 Replies

718 Views

Last post by xaeresis
Wed Nov 08, 2023 11:44 pm
View various statistics on your redo log buffer and files

Last post by xaeresis « Wed Nov 08, 2023 11:29 pm
Replies: 2
by jimb » Wed Feb 01, 2012 11:55 am

2 Replies

795 Views

Last post by xaeresis
Wed Nov 08, 2023 11:29 pm
Get the Free Memory Available in Shared Pool

Last post by xaeresis « Wed Nov 08, 2023 10:46 pm
Replies: 2
by jimb » Wed Feb 01, 2012 11:31 am

2 Replies

719 Views

Last post by xaeresis
Wed Nov 08, 2023 10:46 pm
Get DB Cache Size Advice

Last post by xaeresis « Wed Nov 08, 2023 10:31 pm
Replies: 2
by jimb » Wed Feb 01, 2012 11:29 am

2 Replies

728 Views

Last post by xaeresis
Wed Nov 08, 2023 10:31 pm
Top 5 Problem Queries (Disk Reads/Executions)

Last post by xaeresis « Fri Oct 13, 2023 9:07 pm
Replies: 1
by jimb » Thu Feb 02, 2012 3:04 pm

1 Replies

989 Views

Last post by xaeresis
Fri Oct 13, 2023 9:07 pm
Top 5 Problem Queries (Disk Reads)

Last post by xaeresis « Fri Oct 13, 2023 8:13 pm
Replies: 1
by jimb » Thu Feb 02, 2012 3:01 pm

1 Replies

883 Views

Last post by xaeresis
Fri Oct 13, 2023 8:13 pm
Buffer Busy Waits

Last post by xaeresis « Fri Oct 13, 2023 4:42 pm
Replies: 1
by jimb » Thu Feb 02, 2012 2:42 pm

1 Replies

836 Views

Last post by xaeresis
Fri Oct 13, 2023 4:42 pm
Waits - Datafile Level

Last post by xaeresis « Fri Oct 13, 2023 4:12 pm
Replies: 1
by jimb » Thu Feb 02, 2012 2:41 pm

1 Replies

939 Views

Last post by xaeresis
Fri Oct 13, 2023 4:12 pm
Get optimized Redo Log Files

Last post by xaeresis « Thu Oct 12, 2023 11:59 pm
Replies: 1
by jimb » Wed Feb 01, 2012 11:29 am

1 Replies

755 Views

Last post by xaeresis
Thu Oct 12, 2023 11:59 pm
PGA Target Advice

Last post by xaeresis « Thu Oct 12, 2023 11:29 pm
Replies: 1
by jimb » Wed Feb 01, 2012 11:27 am

1 Replies

703 Views

Last post by xaeresis
Thu Oct 12, 2023 11:29 pm
Automatic Workload Repository (AWR)

Last post by jimb « Sat Feb 04, 2012 10:28 pm

by jimb » Sat Feb 04, 2012 10:28 pm

0 Replies

2660 Views

Last post by jimb
Sat Feb 04, 2012 10:28 pm
Top 5 Problem Queries (Buffer Gets)

Last post by jimb « Thu Feb 02, 2012 3:02 pm

by jimb » Thu Feb 02, 2012 3:02 pm

0 Replies

876 Views

Last post by jimb
Thu Feb 02, 2012 3:02 pm

New Topic

35 topics • Page 1 of 1

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum