Healty ratio of index segment size vs table segment size?
Wondering if there is a "rule of thumb", quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? If it can, what could be considered as average "healthy ratio" above which would be prudent to have a closer look and investigate? Related to the above dilemma, how "expensive" is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few "most suspected" indexes at a time? Thoughts, pointers, opinions - appreciated. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Deleting database
That's right - you would have to drop all schema owners. In my opinion it is simpler and easier task to automate dropping of all owners followed by one full import compared to task of automating database deletions followed by database creations then doing full import in very last step. DOS environment offers weak (better word is miserable) error handling, so unless you resort to non M$ scripting languages to do this task for you I believe you'd be better off to stick with simpler of two approaches. Another reason to try avoiding tearing/re-creating databases lies in the fact that when you create new database on WinXYZ platform, newly created data files are always fragmented at file level (which may not be overly fact important for your test database but it is an ugly site to look at nevertheless). Branimir > > Branimir, > > Correct me if I am wrong, but if I used your approach of > dropping schema > owner then if I have 25 schemas on my test db, I would have > to drop ALL > of them? I would think that dropping ALL schemas would equal removing > entire database. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Deleting database
Run oradim.exe from command line to see how to delete SID. Deleting Oracle service via oradim _will_ remove corresponding registry entries. But why bother removing database, wouldn't dropping schema owner with cascade option followed by full import do the trick? Branimir > > Wouldn't I have to worry about any registry info for the test instance > after physically deleting the OS db files? Would I be able to create > test using the same instance name? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[ORA-000060: Deadlock detected] Finding BOTH pieces of code that
I realize ORACLE-L could not be the best place to ask this question but (googling/metalink-ing did not help overly)... ORA-60 happens in our own application in the worst of possible places - at the customer's site. It happens intermittently. All I can do is look at the alert log for errors and follow the trail to the extremely verbose trace dumps and wonder. Clearly - I am over my head here as I have very little clue of what am I actually looking at. The question is how to interpret what trace dumps tries to tell (should I be scratching my head with it or is there some kind of magic behind TAR that would save the day)? For instance - what is the meaning of this trace snippet (coming from 8.1.7.x): Deadlock graph: -Blocker(s) -Waiter(s)- Resource Name process session holds waits process session holds waits TM-457a-24 37SX 17 14 SSX TM-4571-17 14 SSX 24 37 SX session 37: DID 0001-0018-0002 session 14: DID 0001-0011-0002 session 14: DID 0001-0011-0002 session 37: DID 0001-0018-0002 Rows waited on: Session 14: no row Session 37: no row On the assumption that the source of the above problem has nothing to do with INITTRANS/PCTFREE combo (as per metalink thread # 247579.999) but the culprit really is the broken app - what would be the 'proper' way to find which two pieces of code deadlocked each other? What comes to my mind ain't a pretty sight - turning on sql tracing on the database level (and suffering worsened performance), then once error happens finding out exact time from alert log, converting it to matching TIC number in 3 sec range (if I understand correctly Oracle will detect and break deadlock after 3 seconds). Once this range is known for 3 sec. window, digging through session traces would reveal what were other sessions doing at the time may be narrowing down the search to few possible sources of contention. Problem with this approach is way too much work to set up then 'dig' through all (tons of) trace files without any real guarantees source of deadlocking would be obvious after all this effort. So the question is - how to help duhveloper(s) by pointing closer to the 'root' of deadlocking? Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New to DBA !
On Win2K the easiest way to hack your way back into the database is to log on as local administrator then run orapwd utility to re-create the password file (change working directory to ORACLE_HOME/bin then type orapwd and you'll see the full syntax). New password file should be created in such a way as to be compliant with (or following) Oracle's defaults (be where Oracle expects to find it): ORACLE_HOME\database\PWD.ora If the password file was already there but you forgot the what that password is, rename existing password file to say PWD.ora.old then create the new one: orapwd file=C:\Oracle\Ora92\database\PWD.ora password= Using SQL*Plus: connect sys/@ as sysdba then alter user sys identified by to synchronize sys'es password in data dictionary. After that - the business as usual. Other way to achieve the same (hack back in) would be to fiddle with pfile, sqlnet.ora, and local ORA_DBA group in order to be able to use OS account to log on as SYSDBA and then 'alter user sys...'. But this way is a pain compared to simply 'blowing up' the old password file, creating the new one then re-synch-ing it. Branimir > -Original Message- > From: Rama, Shreekantha (K.) [mailto:[EMAIL PROTECTED] > Sent: October 21, 2003 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: New to DBA ! > > > No ! this is is on Windows 2000.. > > Warm Regards > Shreekanth > > Satyam Computer Services Ltd > BSAQ Project > Dearborn, MI > ( (313) 206 9132 > * [EMAIL PROTECTED] > > > > -Original Message- > Sent: Tuesday, October 21, 2003 11:45 AM > To: Multiple recipients of list ORACLE-L > > > is this a Unix box? > > if so, log on as the oracle account to the Unix server. Then in > sqlplus, login as follows > > sqlplus "/ as sysdba" > > this will get you in as the database owner and will allow you > to change > the system password > > alter user system identified by your_new_password; > > then log out of sqlplus and log in as system to do what you need to > > > --- "Rama, Shreekantha (K.)" <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I am new to the world of Oracle.. > > I am having this issue.. > > > > I have created a database on Oracle 8.1.7.4.. > > > > But I am not able to access as the password is lost.. > > Now, I am not able to login.. > > I tried login using system /manager.. but oracle is not > > allowing me to login .. > > > > What's the solution ?? > > > > Regards > > Shreekanth > > > > > > > > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rama, Shreekantha (K.) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: anyone have opinions on the future of the 'grid'?
> ... As load increases, Oracle > will spawn off work onto the other free servers somehow. > Looks like Oracle is finally "catching up" with what we've been enjoying on Windoze, for quite a number of years now. Only for some strange reason this very principle used to be called "worm propagation" in that wonderful land over there... Joking of course, but spawning off work automagically to remote "box" does sound a bit worrisome nevertheless. Branimir Bitten, thus on watch ever since. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and nfs mounted devices.
> > I have been asked to create datafiles (create tablespace) on > disk drives > that are mapped ( internal disk - attached to remote servers) > > When I tried creating tablespace...I get the following error message: > > > ERROR at line 1: > ORA-01119: error in creating database file > 'd:\oracle\oradata\mmstest\test.dbf' > ORA-27040: skgfrcre: create error, unable to create file > OSD-04002: unable to open file > O/S-Error: (OS 3) The system cannot find the path specified. > I firmly believe that placing database files across the network is one very bad idea indeed, however your problem most likely comes from the fact that Oracle service runs as local (Windows) system account and as such across the network it has exactly the level of rights it deserves - none whatsoever. If you set the Oracle service to run as recognized network user that have read/right permissions on mapped drive - it might work, but it would still be a bad-bad idea to go ahead and actually do so (teeny tiny network 'hick up', and find yourself practicing recovery scenarios). Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to generate unique file names on Windows.
> -Original Message- > From: Murali_Pavuloori/[EMAIL PROTECTED] > [mailto:Murali_Pavuloori/[EMAIL PROTECTED] > Sent: September 24, 2003 1:45 PM > To: Multiple recipients of list ORACLE-L > Subject: how to generate unique file names on Windows. > > > > Hello, > > I am trying to write a script on windows that would export > the db every > night. Can someone tell me how to generate unique file names > on windows... > > What I am looking for is the windows equivalent of echo > `date +%m%d%y` > > Thanks in advance. > > Murali. > Dynamically generated timestamp is what you want. Be warned though that this works only on Win2K and 'better': C:\>set zdate=_%date:~-4%%date:~7,2%%date:~4,2% C:\>set ztime=_%time:~0,2%%time:~3,2%%time:~6,2% C:\>echo %zdate%%ztime% _20030924_152452 On (not so) good ole NT4 this has to be done: :: === Create and initialize TIMESTAMP and NOW environment vars: :: set TIMESTAMP=_MMDD_HHMMSS :: set NOW=DD Month HH:MM:SS if EXIST SetTIMESTAMP.bat del /f /q SetTIMESTAMP.bat MakSetTIMESTAMPbat.wsf if exist SetTIMESTAMP.bat ( call SetTIMESTAMP.bat del /f /q SetTIMESTAMP.bat ) MakSetTIMESTAMPbat.wsf script dynamically creates SetTIMESTAMP.bat script. Execute that to create and initialize TIMESTAMP environment variable (mail me off-line if you want this script making script). Sooo much simpler/easier, more logical wouldn't you say than having to remember/worry about meaning of backticks in shell? Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on Win2000
Windows Terminal services that comes with Windows (in Control Panel, Add/Remove Programs, Add/Remove Windows Components, then install Windows Terminal Client on admin PC). Bigger hassle to install and configure, but a LOT better performer than PCAnywhere or VNC (other two "usual suspects" for remoting unremoteable). Branimir -Original Message-From: Bala Regupathy [mailto:[EMAIL PROTECTED]Sent: September 3, 2003 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle on Win2000 First time I have got to maintain Oracle databases on Win 2000 server. What tools do you guys use to get to the server to admin oracle databases ? Thanks, Bala.
RE: Listener problem on one client computer
> -Original Message- > From: Damien [mailto:[EMAIL PROTECTED] > Sent: September 2, 2003 4:09 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Listener problem on one client computer > > > I have to do netstat -a on the webserver or on the Oracle server? > Listener.ora is on the oracle server or on the webserver? > > I don't have any access on the oracle server and nobody can > help on this > side. > Do the netstat on your Win2K database server to see if TCP port 1521 is listed in LISTENIG category. Also confirm that there is and/or there is not DMZ (with firewall) between your web server and your database server. Usually DBAs are unaware od and/or are out of "loop" with these matters, and normally people in charge of these firey beasts are normally unaware of and/or uncaring for the dynamic nature of Oracle's TNS listener process... tnsping is a friend too. Try it out from any client (unit with Oracle Client software) on the same network segment where the database is. Then move a "step" away (to the next segment to verify that routing does indeed route TNS packets properly). Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
> The ports are the same, I've checked the tnsnames.ora files > and copied & > pasted the content of the box who work on the web server. > Still same prob. > > How can I check if i can open the port? It's a Win2000 server. > > To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\>netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in "insulated" DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on "dry". If you do have DMZ, you should either have "SQL*Net aware" firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: date checking ???
Question of this sort is best to be asked on one of JavaScript forums: comp.lang.javascript microsoft.public.scripting.jscript getDate() method of Date object returns date integer, meaning you can easily test if inputDate is less than today, but to avoid possible trouble - you must check and compare all date parts: if ( inputDate.getDate() < now.getDate() | inputDate.getMonth()< now.getDate() | inputDate.getYear() < now.getYear() ) { Branimir > -Original Message- > From: Andrea Oracle [mailto:[EMAIL PROTECTED] > Sent: August 20, 2003 6:49 PM > To: Multiple recipients of list ORACLE-L > Subject: date checking ??? > > > Hi all, > > May I ask a javascript question?? (sorry to post > here!) below is a form checking input date. The input > date cann't be earlier than today. But it also > compares hours and minutes which I don't want. > Suppose you input 08/20/2003, it thinks it's > 08/20/2003 00:00:00 which is earlier than now > (08/20/2003 15:30:00). How to solve this?? Thank you! > >inputDate = new Date(sDate); > if (inputDate < now) { > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 100 instances on same server !!!
100 instances is way too much even (especially?) if Win2K is the OS in question. Each instance means another service, and each service means spawning and maintaining multithreaded process... On Windows half of available RAM is taken by default for kernel processes and the other half is all that all other apps can hope to get. In your case with 4 GB of RAM on the system each of 100 instances will be getting 20 generous MB. Not enough by any means, not even considering way too many threads that will befell (say max 4?) CPUs. Having said that, le'mee admit a sin: we run with success (meaning nobody complains about performance) 28 concurrent development instances on powerful (at least it used to be 4 years ago) 4x450 PIII Xeon CPUs with full 1GB of RAM and 21 x 18 GB HDD in few RAID 5 containers (sorry for violating BAARF principles). Although we do run overly large number of instances on a single Windows NT 4 box, in reality most of them are used sparsely, and that's why getting away with it seems to work. Now back to your case - I'd warmly advise to reconsider one box running 100 instances assumption. Whatever you put there - will likely melt. On the other hand if your all 100 of your workstations are same, or form few groups of same hardware, investing in 512 MB of RAM for each of 100 workstations (should be much cheaper comparatively) and in 100 licenses (at approx $30 each) for Norton Ghost Enterprise then: - Slash the PC OS and do fresh install (with SP's and unavoidable patches) then install Oracle and create one local database with application installed and configured, - Take Ghost image of a system, - "Push" the image across all workstations (on condition it hardware is exactly alike) using Norton Multicast Server is a "piece of cake", and literally one "click" job. - See that the same image is used over and over again whenever the next round of training is about to take place. Fiddling with Ghost is NOT a DBA job, but any sysadmin type should pull it with ease (and gratitude, if I may say so ;-). Branimir -Original Message-From: Dilip Patel [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 100 instances on same server !!! Thanks for the replies so far. Considering the fact that my database is tiny ( just around 3 GB ), How many of them can work on same server? I can just test with 5 instances, with limited hardware. Will the CPUs be able to take load of 100 instances? Is it worth experimenting this? I am on 8.1.7.4 and the application is already built. I stand no chance of changing the code. That is why using individual schemas for individual users is not an option. Right now I am just asked if 100 instances can run on same server and I don't have solid answer. Just on side note, can I ask, What is the maximum number of instances anyone has ever worked/heard being installed with in same server? Thanks again. Dilip. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 11:54 AM Subject: Re: What books recommended for Data Modeling ? 100 instances woh . If you are in 9i look at possibilities like contextor label security . or creating another schema .-ak- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Wednesday, August 06, 2003 9:24 PM> I have not heard installing hundred database instances on same server.> Maybe you should think creating one instance, and then hundred schemas in> it.>> Guang>> On Wed, 6 Aug 2003, Dilip Patel wrote:>> > Hi All,> > Need some suggestions/Input.> >> > My application database is 8.1.7, NOARCHIVELOG, WIN200,> > total size 4 GB, more of single user OLTP client-server application.> >> > Now the customer wants to give training on this application to hundredtrainees> > at a time. For this he wants to install hundred database instances onsame> > server machine, which *each* will be accessed simultaneously from 100different> > client workstations.> >> > The reasons for installing all instances on same machine are> > - to avoid re-installing databases on 100 workstations after each roundof> > training.> > - No user should see any other user's data.> >> > Please suggest if this approach is feasible or is it at all possible.Tested this with upto 5 instances, and> > it seems to work. The customer is willing to upgrade to any hardwareneeded for> > this setup.> >> > Thanks in advance for your time.> >> > Dilip.> >>> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- > Author: Guang Mei> INET: [EMAIL PROTECTED]>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
RE: Windohs - monthly at job
Title: Message Jerry, to schedule "something" on local or remote Win2K computer: Simple (preferred), non-GUI way: - Make sure "Task Scheduler" service is running on the target system, - Open MSDOS "box" then: C:>at \\%ComputerName% 23:00 /every:1 C:\myJob.bat C:>at \\%ComputerName% 23:00 /every:15 C:\myJob.bat To see what's been scheduled: C:\>atStatus ID Day Time Command Line--- 1 Each 1 11:00 PM C:\myJob.bat 2 Each 15 11:00 PM C:\myJob.bat Do not specify \\%ComputerName% - and the job is scheduled locally. The above is also visible from GUI Task Scheduler. Other way (to do the same): == By leveraging WMI (hideously complex & ugly COM object hierarchy) that Win2K comes equipped with and by using "scripting for 21st century" the VB Script. For how to it (use M$ scripting) do - see the TechNet Script Centerr http://www.microsoft.com/technet/treeview/default.asp?url=""> Section on "Task Scheduling": http://www.microsoft.com/technet/treeview/default.asp?url=""> Now, let's talk abt. virtual pint... ;-) Branimir -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]Sent: July 8, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LSubject: Windohs - monthly at job Hi all, Does anybody know the syntax to schedule a monthly "at" job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A virtual pint o' Guiness (mm...) for anybody who can help! Thanks! - Jerry
RE: Microsoft VS Oracle (again)
> -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED] > Sent: July 2, 2003 11:31 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Microsoft VS Oracle (again) > > > > How do you go about finding MS SQL Server on > MS Advanced Server? > > We have quite few Win2k/NT servers around here: > no mention of MS SQL in the register, and it's > not on the program menu. > > Jared > > It comes with "Small Business Server". That's another name for M$ Exchange, M$ SQL, modem and fax sharing software running atop of Win2K server all bundled together and wrapped in gazillion wizards. All geared to fit needs of small business owners who "have better things to do in their lives" (than worry their (pretty?) heads with sordid details of what's been showed down their eager throats and why)... Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.2 RAC on Win2K?
> -Original Message- > From: Mladen Gogala [mailto:[EMAIL PROTECTED] > Sent: June 25, 2003 1:25 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle 9.2 RAC on Win2K? > > > > > Oracle RAC on Win2K is for some bizarre reason REQUIREMENT. > > Requirement by who? It usually helps to make a business case > for a specific configuration and benchmark it to see whether > the performance is satisfactory. This requirement is dictated by a prospect of ours, and since they say Win2K and IIS (there is a web part to this job) is a MUST, a must it is indeed. No matter how silly or plain wrong such a choice might be. In my opinion the task in question (database up to a TB in size) accessed via few thousand concurrent sessions that must be up and running in 7x24 mode with exactly 0 down time allowed, fault tolerant and load balanced is clearly way-way above capabilities of today's Windoze platform (but give'em another 20 years or so of slack and may be they'll get there?) I also believe that trying to pull or force such a thing using Windows is comparable to a pitiful task of trying to empty the swimming pool using just a hand and spoon combo, but what do I know... > Let me suggest a little benchmark: 4 clustered, beefed up PC > boxes vs. a single, 16-CPU IBM P690 with the latest "960" CPUs > and AIX 5.2. You can benchmark price and performance. I'd be > very intrigued to find out the outcome. It is very hard to > predict it properly (wink, wink). > There is (and always will be) a proper tool for a proper job. Tested proven and true. Mladen, thanks a lot for your input, I REALLY appreciate it! Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9.2 RAC on Win2K?
I need help with clearing up one conceptual issue: My understanding is that with Oracle RAC one set of physical database files "sitting" in the "middle" - shared storage are being accessed by multiple Oracle instances running on multiple physical servers (nodes). All instances "attacking" (sharing) the very same set of data files at the same time. Right or wrong? Provided the answer on the above question happens to be "yes" - I'd like to ask List Folks how feasible is to assemble and successfully (smoothly?) run 0.5-1 TB database, use Oracle RAC and high performance shared storage (say SAN) served ("pumped") by a number of Windows 2K servers? The "number" of Win2K servers I have on mind is at least 4 "beefy" (as beefy as it gets in Windows wrld) Win2K "boxes" each running Win2K AS with lots of RAM and at least 4 CPUs, with perspective of adding more later. It would be nice (for me) to know if new nodes can be added to the cluster at any later time to improve performance (in order to deal with increase in usage or to accomodate growth over period of time). It would be very nice to know if number of nodes is or is not limited (otherwise than by raw I/O capabilities of the shared storage). Has anyone seen/run/stumbled over similar beast, if so - does it "fly" or it "stinks"? Thanks (for any help, hints, links, etc.), Branimir P.S. I've looked at number of metalink articles and found none yet to "scratch" this specific "itch" of mine. Oracle RAC on Win2K is for some bizarre reason REQUIREMENT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Service on Win2k
> Subject: Oracle Service on Win2k > > > Hi list > > On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start > JUST the service > OracleService, most of the times, the database will also > be mounted and > opened ! > Doesn't matter wether I start the service via gui or via "net start > OracleService" or "oradim -STARTUP -SID -USRPWD > -STARTTYPE > srvc", the database will be opened right away. > I definitely don't want that. Out of sheer (sick?) curiosity - why wouldn't you want that? What happens if "manual-start-up-preferring" DBA goes on 2 week vacation and server gets rebooted as a result of prolonged power failure? Consequence will be - the database will not re-open automatically as it was specifically "told" not to do so... Having seen results (utter panic striking one of our customers) I always wondered what could have possibly been the motive or rationalization for setting things up this way in the first place. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
I'd say file size limit/autoextend feature has been Oracle's dirty little secret for quite a while. For a very long period of time there was similar 4GB 'magic' barrier on Windows, that was allegedly fixed. Workaround for the problem was to create datafile 1 MB larger than the 'magic' number, and ether resize it using this trick or add another datafile to tablespace when the time comes (whenever MagicNumber or N x MagicNumber is close). Despite rumours (of having fixed autoextend feature on Windows) I recently witnessed failed imports into Oracle 9.2.0.1.0 caused by too small tablespaces that just wouldn't autoextend. Interestingly, import died "beautifully" cuz silently in the middle of job without _any_ errors, traces etc. Just gone. There is also interesting myth here at the place where I work that systems tablespace autoextend feature ain't to be trusted as "it is known" to have caused intermittent data dictionary corruptions while code recompilation takes place under space "crunch" conditions... On slightly cynical side note: autoextend that doesn't - maps nicely into job safety ;-) Branimir > -Original Message- > From: Orr, Steve [mailto:[EMAIL PROTECTED] > Sent: June 4, 2003 11:40 AM > To: Multiple recipients of list ORACLE-L > Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ??? > > > I've just been informed that there is a 2GB datafile size > limit with Oracle 8.1.7 on Linux... PERIOD. This despite the > fact that we've had files in excess of this for some time and > they work just fine. The problem occurs when the autoextend > "feature" reaches the 2GB threshhold. Of course, Oracle > didn't tell me this until after about 4 days of back and > forth testing for them. (There is no such O/S file size > limit.) I've reviewed the Linux release notes, the Linux > install guide, the Linux admin guide and the contents of > $ORACLE_HOME/relnotes and I don't find any such limitation in > the documentation. Did I miss it? Can anyone find any such > published limitation in the docs? Is this a secret? > > > Peeved at Oracle... AGAIN, > Steve Orr > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: nt script
Title: RE: nt script Do yourself a favour - resist temptation of even considering DOS batch "language" (as it is nothing more than a horrid pile of I-won't-say-what;-) Better choice is WSH and VBScript or JScript. Windows Scripting Host comes with every IE - therefore every Windows machine. Should you go this way keep on mind that you will be painting yourself (using M$ proprietary paints) in corner with your own hands. It makes the most sense to choose cross platform scripting language then use it wherever you go. Down side - you'd have to ensure this particular scripting environment is installed on all platforms/systems you support. Python and Perl are two mature beasts that pack (more than) enough power, and yet are platform agnostic. Worth learning? You bet. Branimir -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]Sent: March 7, 2003 1:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: nt script Can anyone recommend a book / website on the DOS batch file language? I usually try to install cygwin and write shell scripts but some of our database servers don't have cygwin. For example, I have no idea what this statement does: FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B and when I tried it I received an error H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B %%A was unexpected at this time.