-
Which View display the control file size ?
Which View display the redolog file size ?
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com
-
v$controlfile, v$log
I'm not sure if you can get the size of the controlfile?
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
U can see it thru contolfile_record_section too i think
-
No size information .
In Oracle7.3 , there is no v$contolfile_record_section
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com
-
What does record_size show u in V$controlfile_record_section
-
There is no way you could find the size of controlfile from within the database. It is not recorded anywhere, no matter of the release you are using. Since controlfile size changes dynamicaly, what would be the point in storing that information anywhere?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Jmodic u are right
I don't think there is any need to know the sizes of files like controlfiles or initialisation files .
siva prakash
DBA
-
select sum(record_size) from v$controlfile_record_section will give u the app size of control file
-
Originally posted by sm8728
select sum(record_size) from v$controlfile_record_section will give u the app size of control file
I wouldn't rely on it, for example on my prod box it gives hardly a half of the real size.
Ales The whole difference between a little boy and an adult man is the price of toys
-
Just use:
$ ls -la
and u can see size control files and log files.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|