Skip to content
Below are some of the useful scripts related to Oracle Applications database
–FIND DATABASE SIZE select 'DATA_n_INDEX: ' || sum(bytes)/1024/1024/1024 || ' GBytes' DATABASE_SIZE from dba_data_files
select 'TEMP: ' || sum(bytes)/1024/1024/1024 || ' GBytes' from dba_temp_files
select 'REDO LOGS: ' || sum(bytes)/1024/1024/1024 || ' GBytes' from v$log
select 'CONTROLFILE: ' || sum(FILE_SIZE_BLKS*BLOCK_SIZE)/1024/1024 || ' MBytes' from v$controlfile;
[Post Views: 8754]
Below are some of the frequently used Physical Standby Data Guard related SQL queries 1) Basic information of database (primary or standby) SQL> SELECT DATABASE_ROLE,…
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performant, manageable backup and recovery, for all Oracle data formats.
RMAN provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems.
Below are some of the commonly used RMAN commands which you can run through RMAN command line.
[Post Views: 7942]
Few frequently used SQL queries related to ASM : 1) Create Disk Group: Create Disk groups using the CREATE DISKGROUP statement and specify the level…
Few good questions on Automatic Storage Management (ASM) 11gR2: (Oracle ASM Interview questions) Q 1 Can an ASM file be contained in more than one disk groups…
Some useful scripts related to Oracle Apps (11i,R12) are listed. The list is updated regularly so keep coming back for updated version of this webpage.…
Application users in Oracle Apps (EBS) can be created from the front end as well as back end. The back end method for user creation can be used when you don’t have sysadmin access to the applciation or also it can be used to speed up the process when there are many userids to be created.
You will require apps access to connect to database to run the package fnd_user_pkg.
[Post Views: 9362]
error: Alert: Content is protected !!