1)checking tablespace utilization and taking necessary action if tablespace is going to full.
2)I have worked on export and import.
( Remember:Idu table level backup aiytu ... So next come to RMAN backup then.)
2)Checking RMAN backup status , OCR and VOTING DISK backups.
3)Configured Netbackup client on database side to take backups to HYDRA storage.
Backup Inda cloning madbahudu
3)I have done 9i database cloning.
cloning ge 2 db beke beku so nin standby and primary anta anko
4)I have applied patches on both standalone and standby databases.
5)Ensuring that Primary and standby databases are in sync or not
6)I have worked on database SWITCH OVER activities when there is a OS maintaince activities.
7)Resloving User connectiviy issues.
8)User creation and assigning privileges.
9)Identifying Blocking session. taking neccessary actions .
10)Identifying HUng session taking neccesary actions .
11)Monitoring undo usage and temp usage , if any queries using maximum undo or temp then idenitifing those query and sending to APPLICATION team.
13)Refreshing Materialized views
14)When batch process are taking very long time , then taking trace file of session.
15)performing gather statistics on table which are not upto to date.
16)Generating EXplain plan.
17)Generated AWR REPORT , ASH REPORT and ADDM report.
18)Configured Netbackup client on database side to take backups to HYDRA storage.
19)I have configured connection from MS-ACCESS to oracle database via ODBC
20) Changing intialization parameter21)Tuning memory components.
22) DB LINK creation.
2)I have worked on export and import.
( Remember:Idu table level backup aiytu ... So next come to RMAN backup then.)
2)Checking RMAN backup status , OCR and VOTING DISK backups.
3)Configured Netbackup client on database side to take backups to HYDRA storage.
Backup Inda cloning madbahudu
3)I have done 9i database cloning.
cloning ge 2 db beke beku so nin standby and primary anta anko
4)I have applied patches on both standalone and standby databases.
5)Ensuring that Primary and standby databases are in sync or not
6)I have worked on database SWITCH OVER activities when there is a OS maintaince activities.
7)Resloving User connectiviy issues.
8)User creation and assigning privileges.
9)Identifying Blocking session. taking neccessary actions .
10)Identifying HUng session taking neccesary actions .
11)Monitoring undo usage and temp usage , if any queries using maximum undo or temp then idenitifing those query and sending to APPLICATION team.
13)Refreshing Materialized views
14)When batch process are taking very long time , then taking trace file of session.
15)performing gather statistics on table which are not upto to date.
16)Generating EXplain plan.
17)Generated AWR REPORT , ASH REPORT and ADDM report.
18)Configured Netbackup client on database side to take backups to HYDRA storage.
19)I have configured connection from MS-ACCESS to oracle database via ODBC
20) Changing intialization parameter21)Tuning memory components.
22) DB LINK creation.
No comments:
Post a Comment