Wednesday, January 23, 2013

Oracle Database Spaces (Reserved / User / Free)

Login as oracle system user.
sqlplus / as sysdba


select
"Reserved_Space(MB)", "Reserved_Space(MB)" - "Free_Space(MB)" "Used_Space(MB)","Free_Space(MB)"
from(
select
(select sum(bytes/(1014*1024)) from dba_data_files) "Reserved_Space(MB)",
(select sum(bytes/(1024*1024)) from dba_free_space) "Free_Space(MB)"
from dual
)

Tuesday, January 22, 2013

SharePoint 2010 Deleted file recovery

As Site Collection Admin, here are steps to recover files deleted by other users

1. Site Actions -> Site Setting
2. Under "Site Collection Administration", click "Go to top level site settings"
3. "Site Collection Administration" section is expanded, one of options is "Recycle bin"
4. Click "Recycle bin", you should see all deleted files.
5. Select files that you want to recover and click "Restore Selection".