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 24h4
Act. users last hour1
Registered user hits last week232
Registered user hits last month580
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, 6 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, 6 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