IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: January 2008

Number of users logged into Oracle E-Business Suite

You can check the number of active users currently logged into the application using the following query. select to_char(START_TIME,’DD-MON-YYYY’) Login_Time, count(*) cnt from fnd_logins where START_TIME > (select to_date(’25-JAN-2008 00:00:00′,’DD-MON-YYYY HH24:MI:SS’) from dual) and login_type is not null and end_time is null group by to_char(START_TIME,’DD-MON-YYYY’); LOGIN_TIME               CNT —————– ———- 26-JAN-2008               26 25-JAN-2008              132 28-JAN-2008               13 [...]

R12 New Techstack and Directory Structure Changes

R12 New Techstack There has been a specific directory structure and file structure that is followed in Oracle application. In the previous release till 11iCU2, there was some standard naming convention that is following. Each directory whether it’s a product top or form directory was having an organized path. In the new oracle application release, [...]

Cloning Oracle Application 11i Instance

Introduction This section will cover the detailed steps required for cloning an 11i instance. Cloning an instance is creating a duplicate of the instance. But this definition is not exactly true, because during cloning we change various details like hostname, SID etc and configure the system as per these new values. But if we see [...]

Dumping redo log file information – Oracle Database 10g

Redo log files are written by redo log writter process. The files are written in Oracle proprietary format and cannot be read directly. However there are simple command for reading the logfile. I had a situation where I wanted to read the blocks of online redo log files. I was knowing the commands to read [...]

Oracle Hot backup under microscope

I was reading one of the post for oracle hotbackup and also recovery using the hotbackups. There was quite a lot of information in the post and it took me 3 readings to understand the contents. The post was written excellently well, its just that the concept is bit complex. I thought of expressing the [...]

Follow

Get every new post delivered to your Inbox.

Join 130 other followers