No question at this time
DBA Top 10
1 M. Cadot 11600
2 B. Vroman 6400
3 A. Kavsek 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. Péran 1800
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48560
Total active users1401
Act. users last 24h3
Act. users last hour0
Registered user hits last week152
Registered user hits last month875
Go up

Explain Plan and Statistics
Next thread: RFS process is not able to start on newly created physical standby database 12cr2
Prev thread: Cumulative SUM of Data

Message Score Author Date
Hi, This is an interview question. Could som...... Balaji M Nov 11, 2020, 06:42
This is in the documentation. ... Michel Cadot Nov 11, 2020, 06:53
Can you please post it here.... Balaji M Nov 11, 2020, 07:12
https://docs.oracle.com/en/database/oracle/oracl...... Michel Cadot Nov 11, 2020, 07:59
In this document, how could I find the answer. Co...... Balaji M Nov 11, 2020, 09:43
The same ones than in these late 12 years. ... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Nov 11, 2020, 09:51
Hi Michel, It so admirable to see you being ...... Joël Péran Nov 16, 2020, 08:00

Follow up by mail Click here


Subject: Explain Plan and Statistics
Author: Balaji M, India
Date: Nov 11, 2020, 06:42, 18 days ago
Os info: Linux 6
Oracle info: Oracle 11g,12c
Message: Hi,

This is an interview question.

Could someone please explain, will explain plan change if statistics are not gathered
for an object(s) for 1 week.

Regards,
Balaji

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

Subject: Re: Explain Plan and Statistics
Author: Michel Cadot, France
Date: Nov 11, 2020, 06:53, 18 days ago
Message:
This is in the documentation.

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

Subject: Re: Explain Plan and Statistics
Author: Balaji M, India
Date: Nov 11, 2020, 07:12, 18 days ago
Message: Can you please post it here.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Explain Plan and Statistics
Author: Michel Cadot, France
Date: Nov 11, 2020, 07:59, 18 days ago
Message:
https://docs.oracle.com/en/database/oracle/oracle-database/index.html

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

Subject: Re: Explain Plan and Statistics
Author: Balaji M, India
Date: Nov 11, 2020, 09:43, 17 days ago
Message: In this document, how could I find the answer.
Could you give me some hints.

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

Subject: Re: Explain Plan and Statistics
Author: Michel Cadot, France
Date: Nov 11, 2020, 09:51, 17 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
The same ones than in these late 12 years.

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

Subject: Re: Explain Plan and Statistics
Author: Joël Péran, France
Date: Nov 16, 2020, 08:00, 13 days ago
Message: Hi Michel,

It so admirable to see you being so patient :)
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here