(3 comments, 25 posts)

Blesson is a software engineer from India. He works in various languages like php, java, .NET to mention a few.

Home page:

Posts by Blesson

How to display excerpt (summary) of posts in wordpress using Mystique theme

If you do not want to show the entire post in category, archives and home page, you can do it by following the below steps: 1. Login as the administrator 2. Go to wordpress Dashboard 3. Go to Appearance -> Mystique 4. Click on Content Options tab 5. Under Post Previews section, check the Content checkbox and [...]

How to deactivate all call diverts in any brand mobile?

If somebody is calling you and the call is going to your voice mail or it is diverted to some other number, then you can deactivate all the call diverts by typing ##002# and pressing call button. This is a universal code ie., you can use this code in any brand of phone and in [...]

SIM Memory full – Nokia XpressMusic 5800 – Problem

If your Nokia XpressMusic 5800 shows blinking message that SIM memory Full, then follow the below instructions to fix that issue. Option 1. If you want to empty all sms in the sim, hit messaging > Options > SIM messages > Options > Mark/Unmark > Mark All > Options > Delete > Yes. Option 2. [...]

My battery is set up to charge to 80%. How to I change it to charge a 100%?

If you are using a Samsung laptop, you might have come accross this issue. To change the settings, click Start > All programs > Samsung > Battery Life Extender > Battery Life Extender . Click “yes” if prompted. When the program launches you should have the option to go back and forth between 100 and [...]

Unknown column ‘a.attachment_type’ in ‘field list’

If you are facing issue while upgrading from SMF 1.x version to 2.x and you are pretty new to this, then probably you are encountering the following error: Unknown column ‘a.attachment_type’ in ‘field list’ Suppose your forum is at and you tried to run the upgrade using, you will encounter the above error. [...]

SMF Forum 1.x – Preventing spam posts – Member Approval

I’ve been getting a lot of spam postings on my SMF 1.x Forums. So I decided to do a bit of research. So here are the things that I could figure out so far: In SMF 1.x, there is no built-in support for post approvals. I couldn’t figure out any other mods as well. So [...]

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

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

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

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 = ‘opened cursors current’ and ‘open_cursors’ group by [...]

Viewing PGA Statistics of your Oracle Database

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;
Blesson's RSS Feed
Go to Top