Search results for query: *

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.

Hi, I wish to add or ask something here. I find Solaris 8 frustrating when it comes to hardware info collection. Being a regular HP UX user, I get the choice of choosing between SAM, ioscan and xstm. I just want to know the device path for my CD-ROM on a Sun workstation...but I don't know where...

I'm considering using ufsdump because I might want to backup folders. What are the parameters that I need to set? Can multiple ufsdump session be appended to tape?

Hi, thanks for responding to my question. I'm a new Unix user. I'm confused by the 'eom' argument. I don't seen it in the man files. The closest argument I get is 'eof' what does 'eom' do ?

I wish to write a script to append different sets of files to a DDS tape. I want to ensure that the data will be appended after existing data on that particular tape even after the tape have been unloaded and reloaded on the drive. I don't want the tape to rewind when it is loaded. I want it to...

Hi, Recently the listener on the database server did not respond to tnsping and keeps timing out. Attempts to check its status fails as >lsnrctl status commands also fail to get respond and timed out. The only solution I could think of was to kill the listener proccess and restart it. A...