Recent content by mscim

On the red and black boxes the pop up message is the same as the rest. I noticed the red and black boxes are only seen in large tablespace (10 GB). I suspect is represents fragmentation, but its best to be sure.

I'm using version 9i I onlu see the legend for yellow and cyan. What about red and black?

Hi, Can some explain to me how to interperate the colours in OEM tablespace map (Ver 9.1). We have Cyan = Used Yellow = Selected Red = ?? Black = ?? Thanks.

As with tracking DML changes to certain column, I have created a trigger to track down the users. select terminal into v_host from DBA_AUDIT_SESSION where sessionid = sys_context('USERENV','SESSIONID'); insert into audit_mytable values ( :old.name, :old.job, :old.salary, :old.address...

Hi, Can anyone give me a general overview how I can enable Oracle Server Security and Auditing features. I want to keep a log of a: Login and logout time of each user of the database b: Keep a record of each time certain fields in a table is updated, the time and user who updated it. Thanks...

Hi, my Oracle 8.1.7.4 database uses a localy managed temp tablespace. But it seems to be growing at an fast rate and there are no signs of the database reclaiming it. How do we reclaim the temp tablespace?

Oracle 8.1.7

Hi, would appreciate help on this issue. I would like to have redundant redo-log file on seperate hard disk. How do I set this? There is an option to specify additional redo-logs members in Oracle Enterprise Manager Console. Does this do the job? What about archive logs? How do we store...

There is a new issue here. Some of my server don't respond to the #ndd -get /dev/hme link_status I get this error: couldn't push module 'hme', No such device or address Are there any other ways of finding out? Should I find that I need to thange the configuration, how should I do it?

Thanks. Really appreciate it

How do I find the NIC settings of the following: 1. 10 or 100 MBps ? 2. Full or half duplex ? 3. Auto negotiation ON or OFF ? I'm using Solaris 8

Thanks for responding. I'm one of those crazy enough to take on database administration with having proper training. Please bear with me. I do have existing rollback segments. How do I extend it?

Non-root users are having problem ejecting the CD-ROM on my Sun Blade Solaris 8 workstation. Loading CD-ROM is not a problem because it is auto mount. But to eject, running a 'eject /cdrom/cdrom0' yeilds this message "/cdrom/cdrom0: Inappropriate ioctl for device". How do I let...

Hi, anyone that has encountered this problem and solved it, please share with me on how to solve it. Your help will be very much appreciated. EXP-00056: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 3 with name "RBS2" too small EXP-00008: ORACLE...

I just experienced this problem few days ago. I found that my problem in confined to a particular user. What I did was to remove the user account and re-created the account again with same setting. It works fine now. Could have been some setting files related to CDE being corrupted.