DbAppWeb.com - Page 28 of 28 - Solution of Database, Application and Web Server Problems

October 28, 2015 Blogger

How to reduce space between gadgets in Blogger

To reduce the space between gadgets in blogger do the steps shown below: Login to your blogger account. Go to your blog’s Dashboard >> Theme >> Customise >> Advanced >> Add CSS. Copy the below code and paste it to Add Custom CSS .widget { margin: 10px 0 …

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

September 16, 2015 Blogger

How to add Recent Posts Slider with images for Blogger

To add a recent posts slider with images on your blog follow the steps given below: Login to your blogger account. Open the layout of the blog in which you want to add the recent posts gadget. Click on Add a Gadget and click on HTML/Java …

Full Article