Temporary tablespace and files management in oracle
Query to count hourly log switch in oracle
Check Available Space on Disk Group
Delete archive logs using RMAN (to make space on disk)
View tablespace list with used, free, total and free space percentage
View available datafiles in Tablespace
Export database using expdp export
Check oracle users, alter user password, unlock user
Generate AWR report from Oracle Database 11g
Usefull oracle commands
Claim empty space of tablespace to reuse
SQL queries which are using CPU resources
Oracle 11g Hidden Database Parameters
OUI-10020: A write lock cannot be obtained
Oracle parameters list
Query to count hourly log switch in oracle
Check Available Space on Disk Group
Delete archive logs using RMAN (to make space on disk)
View tablespace list with used, free, total and free space percentage
View available datafiles in Tablespace
Export database using expdp export
Check oracle users, alter user password, unlock user
Generate AWR report from Oracle Database 11g
Usefull oracle commands
Claim empty space of tablespace to reuse
SQL queries which are using CPU resources
Oracle 11g Hidden Database Parameters
OUI-10020: A write lock cannot be obtained
Oracle parameters list
No comments:
Post a Comment