No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

Sql tunning
Next thread: ORA:02070 While updating rows using DBLINK
Prev thread: sqlloader with FIELD NAMES FIRST FILE in control file

Message Score Author Date
Dear Friends, In our production environment st...... Prasathi Ji Oct 05, 2017, 05:45
1/ You can use Statspack to replace AWR 2/ You ...... Michel Cadot Oct 05, 2017, 08:21
Thankyou Michael. 1.I will use statspack report ...... Prasathi Ji Oct 05, 2017, 09:59

Follow up by mail Click here


Subject: Sql tunning
Author: Prasathi Ji, India
Date: Oct 05, 2017, 05:45, 70 days ago
Os info: Rhel 6
Oracle info: Oracle 12g without container and pluggable database
Message: Dear Friends,

In our production environment statistics_level=BASIC, Tuning pack disable and AMM & ASMM (memory_target, sga_target) is disabled, no awr report. Can we still tune SQL queries. :-( :-(

Please share your experience.

Best Regards
Prasathi
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Sql tunning
Author: Michel Cadot, France
Date: Oct 05, 2017, 08:21, 70 days ago
Message:
1/ You can use Statspack to replace AWR
2/ You can use "dbms_xplan.display%" procedures to tune your current queries

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Sql tunning
Author: Prasathi Ji, India
Date: Oct 05, 2017, 09:59, 70 days ago
Message: Thankyou Michael.
1.I will use statspack report
2.I am using to generate explain plan

Que:-Will it require license to use Sql patch and sql baseline.

Regards
Prasathi
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here