No question at this time
DBA Top 10
1 A. Kavsek 8700
2 B. Vroman 6600
3 M. Cadot 5600
4 T. Boles 4550
5 P. Wisse 4100
6 J. Schnackenberg 3700
7 G. Lambregts 1100
7 . Lauri 1100
7 T. P 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48379
Total active users1533
Act. users last 24h5
Act. users last hour0
Registered user hits last week231
Registered user hits last month580
Go up

query to find the number of archive logs generated by session
Next thread: system schema object droped
Prev thread: list available agents in the library

Message Score Author Date
Hi Guru's please help me by providing the query...... Raj Kumar Apr 08, 2019, 15:13
Archive logs contain change records for ALL sess...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Michel Cadot Apr 08, 2019, 17:51
Hi Michel Thankyou Very much for your quick hel...... Raj Kumar Apr 08, 2019, 19:09

Follow up by mail Click here


Subject: query to find the number of archive logs generated by session
Author: Raj Kumar, India
Date: Apr 08, 2019, 15:13, 69 days ago
Os info: linux
Oracle info: 11g
Message: Hi Guru's

please help me by providing the query to find the number of archive logs generated by a specific session.


Thanks in advance.

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

Subject: Re: query to find the number of archive logs generated by session
Author: Michel Cadot, France
Date: Apr 08, 2019, 17:51, 69 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message:
Archive logs contain change records for ALL sessions, they are shared if you want, so you can't get what you ask as this does not exist.

If your question is how much redo records or bytes are generated by each session you can get it with (depending on what you actually want):
select sid, name, value from v$sesstat s, v$statname n

where s.statistic# = n.statistic#
and n.name in ('redo entries','redo blocks written','redo size','redo writes')
order by 1, 2
/


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: query to find the number of archive logs generated by session
Author: Raj Kumar, India
Date: Apr 08, 2019, 19:09, 69 days ago
Message: Hi Michel

Thankyou Very much for your quick help.

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