script to find redo generated by current sessions
Posted by Pavan DBA on March 30, 2012
#################################################
redo generated by current sessions
#################################################
select v$session.sid, username, value redo_size
from v$sesstat, v$statname, v$session
where v$sesstat.STATISTIC# = v$statname.STATISTIC#
and v$session.sid = v$sesstat.sid
and name = ‘redo size’
and value > 0
and username is not null
order by value
/
Pavan DBA's Blog 
news article said
I really enjoy examining on this web site, it contains great articles. “Beware lest in your anxiety to avoid war you obtain a master.” by Demosthenes.
Pavan DBA said
thank you
murthi said
Hi Sir,
please tell me steps for
how to migrate database mysql to oracle?
Pavan DBA said
even though i am not sure about steps, because I never handled that, this link may help you – http://www.iheavy.com/2008/01/01/migrating-mysql-to-oracle/
murthi said
please can you help on this
Pavan DBA said
i already replied. see my last reply
even though i am not sure about steps, because I never handled that, this link may help you – http://www.iheavy.com/2008/01/01/migrating-mysql-to-oracle/
Ram said
Hi Pavan,
The client requirement is as follows:
On the same server , they want production db and dev db should be running.But they dont want the db who manges development db to do startup and shutdown on the production db. They should be able to do so on the dev db only
How to manage it ?
Pavan DBA said
Hi Ram,
You have not specified the OS and Oracle versions. so I am assuming it to be Linux flavour and Oracle 10g.
At OS level, you can create two users (for example oraprod and oradev). do installations separately with those users, then don’t share password of oraprod user to anyone except whom you wish to manage prod database.
dinesh dubey said
This is great and what is redo log buffer wait and how to trace to the source from where they are coming and how to resolve them.
Pavan DBA said
redolog buffer wait means some transaction is waiting to get free buffer in log buffer cache. generally this happens when more transactions are hitting the database which are generating huge redo and log buffer cache size is small. We can identify this as a wait event in “top 5 timed events” in AWR report. Most of the times, the resolution would be increasing the size of log buffer cache
abinas said
Pavan please help me in this.
i want to change my character set of db from al32utf8 to wei8…
how can i do and option expect creating the db.
Pavan DBA said
Hi, I don’t find any reason why this conversion is required, because AL32UTF8 is superset to WEI8 that means what ever the characters you can store in WEI8… u can store in AL32UTF8 also. anyways here I am giving a link which give an idea on how to proceed
http://gavinsoorma.com/2011/07/changing-the-database-characterset-from-us7ascii-to-we8mswin1252/
please refer to MOS doc for clear steps…