Tutorials

Oracle query to get session pga & uga memory usage for inactive sessions

0
I’m listing below some of the queries I have created to see various oracle session related memory statistics. Replace all occurrences of XXXXXXXXXXXXXXXX with your database username. Please drop a comment below if these queries are useful for you guys. Query for getting ‘session pga memory’ usage for inactive sessions: select sum(ROUND(s.value/1024)) || ‘ KB’ [...]

How to get maximum limit of open_cursors, sessions and processes in Oracle

0
In order to display the maximum limit of open_cursors, sessions and processes in Oracle, you can run the below queries on SQL Plus: select value from v$parameter where name = ‘open_cursors’ select value from v$parameter where name = ‘sessions’ select value from v$parameter where name = ‘processes’

How to get current open_cursors utilization and maximum limit in Oracle

0
If you are looking for a query which will list you the¬†current open_cursors utilization and maximum limit in Oracle database, then try the below given query: select max(a.value) as highest_value, p.value as max_value from v$sesstat a, v$statname b, v$parameter p where a.statistic# = b.statistic# and b.name = ‘opened cursors current’ and p.name= ‘open_cursors’ group by [...]

Viewing PGA Statistics of your Oracle Database

0
VIEWING PGA STATISTICS ———————————- V$PGASTAT – This view gives instance-level statistics on the PGA memory usage and the automatic PGA memory manager. For example: SELECT * FROM V$PGASTAT;

java.lang.Exception: SQL Error : java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)

0
If you get the following error in your java+jsp+oracle application, then you probably need to increase your maximum session/process limits (Default process and sessions limit in Oracle 9i are 150 and 170 respectively) java.lang.Exception: SQL Error : java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=) Instructions for Increasing session, process and open_cursors max limits to 500 each are: [...]

How to change footer copyright text in your wordpress site (Mystique Theme)

0
In order to change the footer copyright text for Mystique Theme, login to your administrative account, click on the Mystique settings link under Appearance section. Go to the General section and edit the Footer content section. If you use any other theme, check in your theme’s settings under Appearance and if there is no field [...]

Unable to delete drupal sites folder when uninstalling? Here is the solution..

2
This is a common issue when people try to remove their test drupal installation files. Most of us try to delete all the files through ftp and suddenly we realize that it deletes all files except the sites folder and some files in it. In order to delete these files you just need to change [...]

How to install firefox plugins

2
In this post, I will show you two ways to install Firefox plugins (add-ons). The last few steps in each method is similar and I’ve put those in PART II. And PART I shows steps for each method separately. I have used Video DownloadHelper 4.6.4 firefox plugin for this post. But any firefox plugin can [...]
Video DownloadHelper 4.6.4 Firefox Plugin

Download youtube with DownloadHelper firefox plugin

0
For better understanding of the steps, please watch my video on this topic How to download youtube videos with DownloadHelper firefox plugin A – HOW TO DOWNLOAD AND INSTALL Video DownloadHelper 4.6.4 firefox plugin: Video DownloadHelper 4.6.4 is available here. If you don’t know how to install it, please read my post on How to [...]
super_settings_for_youtube_creative_zen

Youtube to creative zen player video conversion

1
Please read my previous post to learn how to download youtube video as .flv file. When you have downloaded the flv file, follow these easy steps to convert the video to the format that creative zen will play without any problems! 1. Open SUPER © Simplified Universal Player Encoder & Renderer and select the following [...]
Go to Top