Things for you DBA Part 1

what is DBA_Directories==============
select * from DBA_DIRECTORIES;
======================================
How to see when the last time object was modified===================
select * from user_objects;
select * from user_tables;
=========================================
How to create DB Link
=============================================
How to analyze tables ==========================================
ANALYZE TABLE emp VALIDATE STRUCTURE;
ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE;
ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE FAST;
ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE ONLINE;
========================================================
What is Mview======================================
===================================================
How many ways of refresh==========================
=====================================================
How to updated a table==========================
update table table_name
set column_name ='new value'
where column_name = 'condition';
===============================================
How to see all objects===============================
select * from user_objects;
select * from user_tables;
=======================================================
How to see space consumed
==================================================
check your oracle version===============>
SELECT * FROM PRODUCT_COMPONENT_VERSION;
=================================================
parameters of database comes from below :
select * from V$PARAMETER
select * from V$PARAMETER2
select * from V$SESSION
select * from V$DATABASE
select * from GLOBAL_NAME
select * from DATABASE_PROPERTIES
================================================
ALTER ANY Table privilige is required
Enable Triggers
ALTER TABLE inventory ENABLE ALL TRIGGERS;
=================================================
ALTER ANY PROCEDURE privilige is required
Manually Recompile View
ALTER VIEW emp_dept COMPILE;
=================================================
ALTER ANY PROCEDURE privilige is required
Manually Recompile Procedures and function
ALTER PROCEDURE update_salary COMPILE;
============================================
ALTER ANY PROCEDURE privilige is required
ALTER PACKAGE acct_mgmt COMPILE BODY;
ALTER PACKAGE acct_mgmt COMPILE PACKAGE;
===========================================
search in sysnonyms
 SELECT TABLE_OWNER, TABLE_NAME, SYNONYM_NAME
    FROM DBA_SYNONYMS
    WHERE OWNER = 'JWARD';

=======================================
check for privileges
SELECT DISTINCT PRIVILEGE AS "Database Link Privileges"
FROM ROLE_SYS_PRIVS
WHERE PRIVILEGE IN ( 'CREATE SESSION','CREATE DATABASE LINK',
                     'CREATE PUBLIC DATABASE LINK')
/