Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Unset "Enable DNS for Windows Name Resolution"
Hi, Under "TCP/IP properties" > "WINS Address" there is the check-box "Enable DNS for Windows Name Resolution". This has become unset. (It should be ticked - it isn't). If I change this, I get two dialogs telling me that there is no WINS address for my adapter and then an invitation to...- DaPi
- Thread
- Replies: 0
- Forum: Microsoft: Windows servers
-
Oracle NT Service run as non-SYSTEM user
In an old thread sem said: "As far as I know, UTL_FILE does not work with mapped drives on NT while running under SYSTEM account, for this NT account normally has no access to those drives. You may refine the Oracle service settings (Log On As). You may also use \\machine\share\path...- DaPi
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Space used by Indexes
Hi everyone, two questions 1) The Oracle doc says I can see how much of the space allocated to an index is actually used with: SELECT pct_used FROM sys.index_stats WHERE . . . ANALYZE . . . COMPUTE STATISTICS and ANALYZE . . . VALIDATE STRUCTURE have been run, but the sys.index_stats view...- DaPi
- Thread
- Replies: 7
- Forum: Oracle: All versions
-
Statistics on Index use
Hi, Has anyone out there collected stats on index use? I suspect that I have several (lots?) of indexes that are never used – if so, there might be a chance to improve OLTP (and save space – 50% of the db is indexes) by dropping the unused ones. I raised a TAR with MetaLink, who replied that...- DaPi
- Thread
- Replies: 4
- Forum: Oracle: All versions
