Blesson's Blog
Where it matters to everyone!
SIM Memory full – Nokia XpressMusic 5800 – Problem
03 months ago
by Blesson
in Tips & Tricks
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%?
0
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’
3
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 http://mysmfforum.com and you tried to run the upgrade using http://mysmfforum.com, you will encounter the above error. [...]
SMF Forum 1.x – Preventing spam posts – Member Approval
0
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
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;
Checking number of open cursors in Oracle
07 months ago
by Blesson
in Uncategorized
Run the following query to check the number of open cursors in your Oracle select count(*) from v$open_cursor where USER_NAME=’xxxxxxxxx’ Replace xxxxxxxxx with the username your application is using.