data block examples (merged) [message #231826] |
Wed, 18 April 2007 09:19 |
gaur_poonam
Messages: 20 Registered: April 2007 Location: India
|
Junior Member |
|
|
hello all,
I need some practical examples for clarify more different topics of oracle 10g like about logical storage,physical storage(like datablock,segments,datafile,controlfile,tablespace etc.) so i can get better understanding of all this structural part of oracle 10g. i got some books n conceptually the idea of all parts is clear to me but for better understanding i want some examples so it will be more clear to me.so if anyone can help me out.....
thanks so much........
regards...........
|
|
|
|
|
|
|
|
query about data block [message #231964 is a reply to message #231826] |
Wed, 18 April 2007 23:25 |
gaur_poonam
Messages: 20 Registered: April 2007 Location: India
|
Junior Member |
|
|
hello,
1) i have a query about two prameters called PCTFREE and PCTUSED. if for better performance i need to tune both the parameters for a database, then it will affect the logical storage structure.for example i have old values set for both as,
PCTFREE=20
PCTUSED=40
now i have changed them to new values,like
PCTFREE=10
PCTUSED=50
so it will only effect to the new storage structures the old data which are already exist in database will not be affected by it. so if i want to give the changed values effect to the old data also, then is it possible? or i need to take the dump and need to restore to the new schema settings. please help me to get it solved.....
2) the other query is oracle 10g release 1 provides a rename tablespace feature. so after renaming tablespace do i need to take other backup of it or the older names backup will work. cause when i rename it, it changes all references of it in the various structures like controlfile and so on.....
please if anyone can help me.......
thanks so much.....
regards..............
|
|
|