Oracle Database - DbAppWeb.com

September 17, 2017 HPE Data Protector, Oracle Database

HPE DP: RMAN Backup Failed after Changing the SYS User Password of Oracle Database

Problem I have configured the RMAN backup of the oracle database on HPE Data Protector. Backup was scheduled for daily at 18:00 hrs. One day I found that the RMAN backup of the oracle database failed and when I saw the session report it was showing …

Full Article

September 30, 2015 Oracle Database

How to generate AWR/ADDM report as normal database user ?

You can create a role awradmin and grant all necessary privileges to this role. Then you can grant any user awradmin role to generate AWR and ADDM report — First connect as sys user. SQL> CONN / as sysdba connected SQL>CREATE USER awrtest IDENTIFIED BY awrtest …

Full Article

September 28, 2015 Oracle Database

How to Display Temporary Tablespace Free Space in oracle database

Query: set pagesize 60 column “Tablespace” heading “Tablespace Name” format a30 column “Size” heading “Tablespace|Size (mb)” format 9999999.9 column “Used” heading “Used|Space (SQL> mb)” format 9999999.9 column “Left” heading “Available|Space (mb)” format 9999999.9 …

Full Article

September 18, 2015 Oracle Database

How to query tablespace usage in Oracle Database?

Below query gives us detailed information about tablespace usageset pagesize 100 set linesize 200 break on report compute sum of free_mb on report compute sum of act_size on report compute sum of used_mb on report col %used format 999.99 col %Free format 999.99 col act_size format …

Full Article

September 17, 2015 Oracle Database

How to query uptime for Oracle Database?

The output of dbuptime.sql has four columns. Column hostname gives the machine name, Instance gives the name of the database instance, stime gives the date and time when the database was started and uptime gives total uptime duration in days, hours, minutes and seconds. Uptime Query …

Full Article

Category: Oracle Database