You are here:   Home
Oct
21
2010
OID - AD Integration : Import from AD to OID : DirSync V/S USN-Changed
If you are planning to integrate OID (Directory Service from Oracle) with Active Directory (from Microsoft ) and importing user/group from Active Directory (AD) to Oracle Internet Directory (OID) then you can use one of two approaches (USNChanged or DirSync) to poll changes in Microsoft Active Directory. This post covers overview of capturing changes in Microsoft Active [...]
Read more...
 
Oct
21
2010
Session Management in #OAM 11g : SME , Idle Timeout, Session Lifetime
This post covers key points related to Session Manager in Oracle Access Manager (OAM) 11g
Read more...
 
Oct
21
2010
How to get the Schema/User size

In SQLPLUS run any of the following scripts to find the total size occupied by a particular schema.


1.

SQL> SELECT sum(bytes)/1024/1024 FROM user_segments;


The output above query would be similar as follows:


SUM(BYTES)/1024/1024
——————–
2552.75
Read more...
 
Oct
20
2010
How to kill all ORACLE Process in one command
At OS prompt, Execute the following command to kill all ORACLE process

$ kill -9 `ps -ef |grep PROD |awk '{print $2}'`
Read more...
 
Oct
19
2010
How to Start the CSS Process ,ASM & DB Instances Services On Windows using Command Prompt.
1. To start the services for CSS, ASM & DB Instances:

C:\> net start oraclecsservice
C:\> net start OracleASMService+ASM
C:\> net start OracleServiceDBAASMW


2.
Check whether above services are running using following command :

C:\> net start


Example as shows:
C:\> net start
These Windows services are started:

OracleASMService+ASM
OracleCSService
OracleServiceDBAASMW


3
Read more...
 
Oct
19
2010
Oracle Database 11g Top New Features : Summary

Oracle Database 11g Top New Features : Summary



1) Automatic Diagnostic Repository [ADR]

2) Database Replay

3) Automatic Memory Tuning

4) Case sensitive password

5) Virtual columns and indexes

6) Interval Partition and System Partition

7) The Result Cache

8) ADDM RAC Enhancements

9) SQL Plan Management and SQL Plan Baselines

10) SQL Access Advisor & Partition Advisor

11) SQL Query Repair Advisor

12) SQL Performance Analyzer (SPA) New

13) DBMS_STATS Enhancements

14) The Result Cache

15) Total Recall (Flashback Data Archive)

Note: The above are only top new features, there are other features as well introduced in 11g which will be included subsequently

Oracle 11g Database DBA New Features with brief explanation
==========================================

# Database Capture/replay database workloads :
This allows the total database workload to be captured, transferred to a test database
create from a backup or standby database, then replayed to test the affects of an upgrade or
system change
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Follow Me