No question at this time
DBA Top 10
1 B. Vroman 14400
2 M. Cadot 14200
3 A. Kavsek 7100
4 T. Boles 6100
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3600
7 G. Lambregts 1100
7 T. P 1100
7 P. Wisse 1100
10 B. Derous 500
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48226
Total active users1641
Act. users last 24h5
Act. users last hour0
Registered user hits last week355
Registered user hits last month1464
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, 290 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, 290 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, 290 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