No question at this time
DBA Top 10
1 A. Kavsek 8400
2 B. Vroman 5900
3 M. Cadot 5400
4 P. Wisse 4800
5 T. Boles 3700
6 J. Schnackenberg 2100
7 . Lauri 1500
8 R. Pattyn 700
9 T. P 600
9 J. Péran 600
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48407
Total active users1518
Act. users last 24h0
Act. users last hour0
Registered user hits last week228
Registered user hits last month1049
Go up

avg row length and no of record in table
Next thread: user connect hung at sql prompt
Prev thread: jdbc connection

Message Score Author Date
hi masters, i want to know the avg row length a...... javed akhtar Jun 10, 2019, 17:42
Hello Javed,   <<<I> for a specific time period...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Bruno Vroman Jun 10, 2019, 19:07

Follow up by mail Click here


Subject: avg row length and no of record in table
Author: javed akhtar, India
Date: Jun 10, 2019, 17:42, 69 days ago
Os info: linux
Oracle info: 12c
Message: hi masters,

i want to know the avg row length and no of records in a table for a specific time period. like from 1 Jun 2019 to 10 Jun 2019.


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

Subject: Re: avg row length and no of record in table
Author: Bruno Vroman, Belgium
Date: Jun 10, 2019, 19:07, 69 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message: Hello Javed,

  << for a specific time period. like from 1 Jun 2019 to 10 Jun 2019>>

How do you "attach" a time to a row of your table? Do you have a DATE column like 'this_is_the_time'? Or by another mean (example: an ever-increasing column for which you can associate a time, at least for some rows (like milestones))

The main point of your question is "simply": can you identify the rows "from 01-JUN-2019 to 10-JUN-2019"?
(and you might have to be more precise, as for example I suppose that you mean from 01-JUN-2019 00:00:00 until 10-JUN-2019 23:59.59.9999.... but you have to clarify this, and I guess that you speak of "creation time" but maybe it is "last update time"? And what about deleted rows? ...)

If you just expect "Oracle" to attach a creation time to each and every row, you are out of luck.

Best regards,

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