No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
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 users48052
Total active users1733
Act. users last 24h10
Act. users last hour1
Registered user hits last week395
Registered user hits last month1204
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, 12 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, 12 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, 12 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