Re: Insert problem ( sqlarea)

Hi Anita, In my schema all tables have less than 100 columns. Thanks, Ajay Singh Rathore HCL Infosystems Ltd --- visit us at www.hclinsystems.com - Original Message - To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, June 23,

RE: Is it possible???

I think you can try using PRODUCT_USER_PROFILE table. You can disable perticular command by this table. This will only work in sql prompt. Other applications can use commands. -Original Message- Malik(IT) Sent: Monday, June 25, 2001 11:50 AM To: Multiple recipients of list ORACLE-L

RE: Is it possible???

You can achieve this in Oracle 8i with the login trigger. You can check in the login trigger if the application that trie to connect to the database is an allowed one. If not, than raise an exception and the login failes. For earlier versions you can use the product_user_profile table, but it's

Re: Can DBA*Studio run on the Web through a browser?

Be prepared for poor performance though. Jack Rama Malladi

RE: Is it possible???

Title: RE: Is it possible??? if you are on 8i, then you can define rules in product_user_profile for preventing users from using sql*plus. like: -insert into system.product_user_profile(product, userid, attribute, char_value) 2 values ('SQL*Plus', 'user', 'SELECT', 'DISABLED'); 1 row

Re: SGA QUESTION

Hi Jared, I think like Greg . Oh, we're in trouble now - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Questions for Oracle creation Backup

Meng Fangtao m.fangtao@geneTo: Multiple recipients of list ORACLE-L

RE: Is it possible???

Title: RE: Is it possible??? THANKS -Original Message-From: Amar Kumar Padhi [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 1:11 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Is it possible??? if you are on 8i, then you can define rules in

RE: Can DBA*Studio run on the Web through a browser?

I don't expect much of performance, it's slow enough as a client/server too. All the same, it's much quicker than going to the customer ;-) Thanks for the replies. Tamas Szecsy -Original Message- Sent: Monday, June 25, 2001 9:50 AM To: Multiple recipients of list ORACLE-L Be

AARRGGHH !!!

Over the weekend, (Friday to be precise) I was unsubscribed from the list. Is there away I can catch up on mails I have missed ?? I had posted a question on Friday afternoon that I needed answers to. Regards Lee The information contained in this communication is confidential, is intended

Tracing PL/SQL-Calls

Hi, we have some trouble with an application, which calls rapidly several PL/SQL-packages. The trouble seems to be inside the packages, but I need the exact order of PL/SQL-calls and the values put into the parameters. Then I can debug the packages by hand. How can I trace the calling session

Re: How to return Multi-row query into a single row?

Don Dealy II wrote: Sample Table DocId Integer DateVal Date TextVal Varchar2(40) NumValNumber(10,0) Sample Data DocIdDateValTextValNumVal 12 01/15/2000 12 Sally Smith 5 Bob Brown 5

Re: SGA QUESTION

HERE IS THE KNOWLEDGE, my database is nearly 700 tables where 2 of it is 3 gb growing per year. My total disk is 400 GB. Total number physical users which will connect to database is 1000 but will be 2 for 2 years. Total number of database users is 30. Oracle is on NT. Oracle Version is

Re: Is it possible???

Shahid Malik(IT) wrote: Hi Friends, I want that user only access data from application not from sql prompt. Any help would be highly appreciated. Shahid. Shahid, Read everything you find in the manuals about PRODUCT_USER_PROFILE. I think that it is documented in the

Rachels Chocolate Mousse Cake

Oh My God. Even the most hardened chocaholic would find this a little hard to get through. I was warned by Rachel herself to take a small slice but Oh No, I had to cut myself a large one. I felt so sick. IT WAS TREMENDOUS !!! Mark Leith, you have to try this one. Lee The

RE: NOLOGGING FEATURE

Hi Raj RTFM is a relational trace file management system. Originally released as an add-on with 8.0.0.6, I think it now comes standard with 9i. Cheers Greg -Original Message- Sent: Monday, 25 June 2001 09:52 To: Greg Solomon Greg I'm curious.. Whats RTFM is?? Raj -Original

RE: AARRGGHH !!!

Hi, Do you want me forward to you all those mails ? Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robertson Lee - lerobeSent: Monday, 25 June 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: AARRGGHH !!! Over

Upgrade 8.0.4 to 8.1.6

Hello I am in the process of upgrading from 8.0.4 to 8.1.6.. it asked if I wanted to migrate my 8.0.4 datafiles to 8.1.6. I said yes to this and it started migrating, this was on friday. Today it still seems to be going , its a 8 gig database..; If I click on Finish it says that the upgrade

RE: AARRGGHH !!!

Lee, I have all emails from Friday to today - I archive after three days - and you only have one email in the list, this one unfortunately. What was the question? Regards Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robertson Lee -

RE: Tracing PL/SQL-Calls

Did you have TOAD ? If so then you can enable debug mode and trace the package until the detail of calling of procedure /function as nested as possible. In the same time you can activate the watch {to show you the values of the variable} -Original Message- Sent: Monday, June 25, 2001

ok to alter SYS tables/cluster (obj$/C_OBJ#) for buffer_pool KEEP

List, any known restrictions in doing an alter table obj$ storage(buffer_pool keep) ? or, would it be better to keep the entire C_OBJ# cluster in KEEP pool ? Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

RE: NOLOGGING FEATURE

Greg, In 9i our good old Relational Trace File Management has been renamed to Real Trace File Management. Worse than that. The Logical Oracle Listener option is now called Real Oracle Transmission Failover Listener Management Advanced Option. Regards, Mike Hately Oracle DBA Greg Solomon

FW: sqlloader problem

Apologies to those of you who may have answered this already but I was unsubscribed at the weekend and all of the mails from the list were bounced. Plus, I don't appear to be able to use the INDEX command for a list of the archives as it keeps failing. Regards Lee Lee Robertson

RE: 8.1.7 Install Confusion

Unzip the entire zip file to a directory of your choice, then underneath that dir. will be a DISK1 directory, if you go in to DISK1, there will be a setup program, use this to install. The DISK1 directory will be from the way they setup CD install disk directories. We used to do it on our

Automatic emails from Solaris

Hi, I'm Running Oracle 8.1.6 on Solaris 2.6. I want to Run checking scripts every hour, i.e. extents, Tablespace sizes etc.. If there is a problem with any of these I want the to be able to email the output, so that the database can me managed remotely. Has anyone got any Ideas what need

Re: AARRGGHH !!!

[EMAIL PROTECTED] wrote: Hmm, me too was unsubscribed on friday. This was second time. The previous was month and a half ago. I'm pretty sure we hadn't any delivery or network problems at least the last time. Just interesting why me??? ;) Gints Plivna Probably because they are all out

Re: FW: sqlloader problem

Hi Starting with 8i you have the filleroption in SQL*Loader control file, which does what you want. In older versions I don't think you can do it directly. Maybe ask Jared how to make a perl script to remove the column you don't want :-) A very roundabout way is to load entire file into

Re: AARRGGHH !!!

On Jun 25, 2001 at 02:41:23AM, [EMAIL PROTECTED] wrote: Hmm, me too was unsubscribed on friday. This was second time. The previous was month and a half ago. I'm pretty sure we hadn't any delivery or network problems at least the last time. Just interesting why me??? ;) You are not

RE: NOLOGGING FEATURE

Good one. Jack MHately@etech- uk.com To:

Re: Automatic emails from Solaris

checking scripts every hour ... email alerts The last script on this page does a few database checks and emails you notice of problems if any are found. It's a Korn shell script. http://www.dbspecialists.com/4dbas/download.html - Greg -- Please see the official ORACLE-L FAQ:

db_file_multiblock_read_count

Listers, I am attempting to tune a 7.3.4 OLTP database and I have a couple of questions. 1. The db_file_multiblock_count is 64 which seems way too high to me. What are the consequences, if any, of setting this parameter too high? 2. I want to increase the SGA to be 20% of the available

Re: Is it possible???

Dear Shahid. Yes product_user_profile will disable commands used in sql*plus. i tried, it worked. Thanks to the guy who gave the clue insert into PRODUCT_USER_PROFILE (product,userid,attribute,char_value) values('SQL*PLUS','TEST','SELECT','DISABLED') Ramana - Original Message - To:

Pl/SQL question

List hi! Oracle 8.1.7 EE on AIX. One of our developers wrote a procedure. Inside that procedure he wants to know instance and schema, while executing that procedure. Do you have any suggestions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Rachels Chocolate Mousse Cake

RUBBING HANDS TOGETHER WITH GLEE MODE This REALLY does sound like a good candidate for a BBQ we have planned mid week - time to break out thepinafore and starting working Rachel's magic me thinks :) /RUBBING HANDS TOGETHER WITH GLEE MODE Cheers Lee Mark (Gonna take a big bit anyway)

Re: Using Recovery Catalog with RMAN

Donald, We have a second catalog of the same version number on a different small UNIX machine which we back up the first catalog database to. We also export the first catalog database. Cherie Machler Oracle DBA Gelco Information Network

Trace Evaluation

Is there Any Scope for Improvement in the Following ? select acct_crncy_code into :b0 from GAM where acid=:b1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00

Re: Automatic emails from Solaris

we run cron jobs to handle this. fairly simplistic, we run scripts that generate output if there is a problem (and empty spool files if there isn't), then use mail to send them to ourselves. you need to be able to send mail out to the net from the Solaris box though. From: butler, daniel

Re: AARRGGHH !!!

Ho, ho, now I'm well prepared! I created an e-mail template with all subscribe statements needed for all fatcity lists I'm interested in. It will be like an event trigger on_bounce ;) I only hope that I will be bounced from all lists hosted in fatcity or the second alternative - I cannot

RE: Using Recovery Catalog with RMAN

Done, Our Rman catalog is on a different box from all of the Oracle databases. It is backed up nightly (cold) after all Rman backups have been completed. You could, optionally, simply export the Rman user on a daily basis (when the catalog is not in use). hope this helps Tom Mercadante

Re: Pl/SQL question

Sonja, The schema will be determined by the owner of the procedure, which he should know or you could tell him and won't change. For the instance name you could grant him select on v$database or create a view of v$database.name. I'm not sure about OPS tho. HTH, Liam From: Sonja ©ehoviæ

RE: Pl/SQL question

Sonja, Instance is easy enough. Either grant the person SELECT access to the V_$INSTANCE view under the SYS account, or create another view owned by the DBA that returns the same information. By schema, do you mean the schema where the procedure exists, or of the person executing the

OT RE: Rachels Chocolate Mousse Cake

Mark, May I make a suggestion to avoid chocolate overload? Take a small piece and go back for seconds :) Rachel From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rachels Chocolate Mousse Cake Date: Mon, 25

RE: Automatic emails from Solaris

Here's a simple set of 2 scripts that we use to check every five minutes if Oracle is running and send out a page if it isn't: is_oracle_run: cd /oracle/alert_mail check_oracle is_run if [ `grep Oracle is running is_run|grep -v grep|wc -l` = 0 ] then mail [EMAIL PROTECTED] alert_message

RE: Rachels Chocolate Mousse Cake

Did I miss the recipe? In matters of chocolate, I trust Rachel completely. Can we repost it? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 5:02

OT Re: Rachels Chocolate Mousse Cake

I don't mess around when it comes to chocolate anything :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Rachels Chocolate Mousse Cake Date: Mon, 25 Jun 2001 02:02:27 -0800 Oh My God. Even the most

RE: Upgrade 8.0.4 to 8.1.6

These are the reasons I don't tend to rely on these GUI tools Last month-end I did some migration (of four databases) 8.0.4 to 8.1.7 manually and pretty successfully on NT. Check Note 133920.1 on Metalink . You might need this... All the best, Rajesh OC DBA 88i -Original

I KNOW ITS NOT FRIDAY BUT ..........FW: Recipes, as promised

Chocolate Mousse cake and New York Cheesecake (which I haven't tried). -Original Message- Sent: 17 March 2001 16:25 To: Multiple recipients of list ORACLE-L Unlike Mark, I cannot translate the measurements into metric. Note that I AM a chocoholic, dark chocolate to be precise, and

RE: SGA QUESTION

I believe that you can have 8 Gig's, but don't you have to apply a patch in order for it to work? KK -Original Message- Dayal Sent: Monday, June 25, 2001 6:36 AM To: Multiple recipients of list ORACLE-L Oracle is on NT. My RAM is 8 GB. Is it a good (VALID) combination ;-) Rajesh

Re: NOLOGGING

Hi Greg, Delete isn't an operation that supports nologging. So you should see exactly the same performance. Regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: License high water mark

This is what the manual says: Oracle Product Document Library(C) Oracle Corporation Manual: ORACLE 8.1.5 SERVER CODES Reference: A67785-01 ORA-12540 TNS:internal limit restriction exceeded Cause: Too many TNS connections open simultaneously. Action: Wait for connections to close

RE: License high water mark

Dave, yea i understand, oracle should be putting that "high water" entry everytime is shuts down. yea oracle support, what a joy :) joe "Farnsworth, Dave" [EMAIL PROTECTED] 06/25/01 10:04AM I mentioned the license high water mark as the culprit because I do not see it listed in my

Re: License high water mark

License high water mark is exactly that, the max number of connections to the database(if i remember correctly), what lends you to believe thats the culprit? Also what is emn0 process? thanks, joe [EMAIL PROTECTED] 06/25/01 10:01AM My database is down!! In my SIDAlert file is the

RE:

Hey List , I am using the below script updating 4.3 millions rows to a table. This table has 1500 bytes per record but actually the avgrow is 156 bytes. I did a test on NT, with same table (no index). It takes 54 minutes to load. However, the same load, same table (no index), it takes 16

RE: db_file_multiblock_read_count

Title: RE: db_file_multiblock_read_count Hi Lisa, IIRC, the first line of vmstat gives you cumulative values since system boot. And "2 10" means "every 2 seconds, 10 times" (on Solaris, at any rate). Cheers, g -Original Message-From: Koivu, Lisa [mailto:[EMAIL

RE: NOLOGGING

Hi Greg, Yes, you should get a improve performance due to the nologging option in the delete wont write redo log information. Ramón Estévez *809-565-3121 x 225 * [EMAIL PROTECTED] -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Greg Solomon

RE: License high water mark

Dave, Error 12540 can be raised due to a number of issues. If you have access to Metalink you will get quite a few documents describing it. Are there any other databases on the server. If so, and if it is possible to shutdown any on those, please do that, and then try to start your database. If

Re: Griping about auditing (not the Oracle Kind)

Hi, Been there recently We had change management here breathing down our necks at one point. They wanted everything documented and approved. I flooded them with change request forms (even for changing a users password on the test database) and within two days they wanted a meeting about what

RE: SGA QUESTION

Who knows. Perhaps your database is 100K perhaps it is 1000Pb. Perhaps it is DSS, DW, or even OLTP. I would say use a 8Gb sga and buy more memory, should be perfect for what your trying to do. "Walking on water and developing software from a specification are easy if both are frozen."

RE: OT RE: Rachels Chocolate Mousse Cake

NA!!! Choccy overload is a GOOD thing!! I WANT to get FAT!! LoL I'll let you know.. Mark -Original Message- Lee - lerobe Sent: Monday, June 25, 2001 02:56 To: Multiple recipients of list ORACLE-L I second that emotion !!! -Original Message- Sent: 25 June 2001 14:41 To:

RE: Griping about auditing (not the Oracle Kind)

Close, it's a brokerage. But regarding flooding the SVP, one of my favorite Dilbert moments came about a month after the new procedures were in place. They were getting forms from multiple sources (me, the developers on our OLTP database and the developers from our datawarehouse). All those

RE: Griping about auditing (not the Oracle Kind)

A non-DBA? Is that because we stick together like the Mafia or something?! g -Original Message- Sent: Monday, June 25, 2001 3:32 PM To: Multiple recipients of list ORACLE-L We've been through an internal audit and I was just wondering if anyone else has to deal with the rather

Re: How to return Multi-row query into a single row?

Don, In you code, add the line GROUP BY DocID David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Don Dealy

RE: db_file_multiblock_read_count

Title: RE: db_file_multiblock_read_count geez. Load a trial copy of MKS on NT and get back into da swing of tings, gal! :) -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 12:23 PMTo: Multiple recipients of list ORACLE-LSubject: RE:

RE: License high water mark

Dave, I've never seen the license HWM cause a problem. It's usually informational in order for the DBA or auditors to tell if them have purchased sufficient licenses. Internal limit messages often indicate that a process is trying to exceed a user or system limit (memory/semaphores/file

RE: Griping about auditing (not the Oracle Kind)

Jay; I have had to go thru the same thing a couple times on a previous job with Auditors. Every time those kind of restrictions were placed on us it brought things to a snails pace or, in some conditions, a complete halt. Sooner or later they realized that it was unreasonable and lifted them.

RE: db_file_multiblock_read_count

Title: RE: db_file_multiblock_read_count Thanks Guy. I don't even have a unix system here to do a man page. Talk about BOREDOM. Lis -Original Message- From: Guy Hammond [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 11:28 AM To: Multiple recipients of list ORACLE-L Subject:

RE: License high water mark

Re-booting the server worked. But I still need to know what caused the database to shut itself down. I'll let the list know what Oracle says. Thanks, Dave -Original Message- Sent: Monday, June 25, 2001 10:28 AM To: Multiple recipients of list ORACLE-L Dave, Error 12540 can be

MTS problem

Hello I've got a problem with MTS. When I start database then the service is registered to listener as a next dedicated server instead of connecting as dispatcher and if I force the client to use shared connection I get an error :ORA-12519 / TNS-12519 Text: TNS:no appropriate service handler

RE: Griping about auditing (not the Oracle Kind)

Alex, that was the result of an inexperienced DBA. an experienced DBA would know that there is a load placed on the server during datafile addition time. if you have a server with extra oomf, then the users should not see any difference. it sounds like you had a very sensitive database that

Sqlloader question solved.

HiStarting with 8i you have the "filler"option in SQL*Loader control file=which does what you want. Thanks Jack. It was indeed on 8i (I should have mentioned this) and the FILLER keyword worked like a charm. I love this list !! Lee The information contained in this communication is

OT : UNIX man and Boredom ... RE: db_file_multiblock_read_count

Lisa, Who needs a UNIX system for man pages? Just try these: http://www.rt.com/man/ or http://www.bsdi.com/bsdi-man/ or http://sunsite.queensu.ca/cgi-bin/man-cgi Hope this ends your BOREDOM ... :) Enjoy.. - Kirti Deshpande Verizon Information Services

Intel just bought the Alpha technology from Compaq

Fyi, Check out www.arstechnica.com http://www.arstechnica.com Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique

Query on Month-to-date and Year_to_date

I am creating a report based on a couple tables. The report should show the total amount sold for the current month and another field for total amount sold Year To Date. How can I created the report so that the month to date value for a particular item is adjacent to the total amount for Year to

RE: Griping about auditing (not the Oracle Kind)

Wahey !!! The answer I was going to provide. We started calling the manager up quite frequently at home to authorise changes - he eventually saw sense. Not quite as bad as 2am in the morning but inconvenient enough for him to put a stop to it. Best of Luck. -Original Message- Sent: 25

RE: Griping about auditing (not the Oracle Kind)

Jay, 'you can't put that many changes through' I love it! see, how it works! follow the dumb process they establish, and it gets even dumber!eventually, it breaks and they see the folly of the process. it reminds me of almost every M*A*S*H episode I ever saw. Want me to arrest him too,

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

Title: RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area.. Requirements: Must be able to lift heavy database files. Must be at least 30 years old, having graduated from college and immediately become a DBA and put in your 7 years. This position is with a Great company offering:

Design Question - Thoughts Needed

We are looking to redesign our current system and a question popped up that I am struggling with. (our business is auto insurance). Each vehicle on a policy may have 1 or many coverages.For example, comprehensive, collision, towing, property damage ... A couple of things: 1- some

RE: Griping about auditing (not the Oracle Kind)

I say that if you wait until you database has an error you really aren't proving much except that you are not proactive in your job. Which, in my book, makes you not a very good DBA. Dealing with a dumb process is one thing (we have our fair share on this account) but I take to much pride in my

RE: License high water mark

Tom, Bingo! You were the first person to notice that a shutdown immediate was issued. If Oracle crashes the db you'll either get an error or nothing at all, but never a shutdown immediate. Dave, you need to check for cron jobs or OEM jobs that can shutdown the db as well as checking who has

RE: License high water mark

I am looking into this possibility now. The network admins all can do this by simply shutting down the service. It is good to know that if it crashes, that it will either create an error or nothing at all. Thanks for the help, Dave -Original Message- Sent: Monday, June 25, 2001 11:28

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

Title: RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area.. And Lisa, most of them lie thru their teeth in order to get a position filled ! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 11:47 AMTo: Multiple recipients of list

RE: Intel just bought the Alpha technology from Compaq

Patrice, *thanks* for the fyi! -Original Message- Sent: Monday, June 25, 2001 12:43 PM To: Multiple recipients of list ORACLE-L Fyi, Check out www.arstechnica.com http://www.arstechnica.com Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et

Re: Design Question - Thoughts Needed

Tracy, where do you draw the line of when you should include them in the table as atrributes? Since new coverages could be added at any time, i'd make them their own child entity. I wouldnt concern yourself with i/o, if its indexed correctly its so fast noawadays, i'm not sure you could

RE: db_file_multiblock_read_count

Title: RE: db_file_multiblock_read_count Hi A year or two back, the suggestion (on solaris at least) was to avoid using vmstat with the first parm set to a value lower than 10, because the act of measuring perf becomes a drain if you do it every 5 seconds(or less). I tend to use vmstat 10

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

Lisa: You need to update this. Must not be over 30 years old with a minimum of 15 years of post graduate work as an Oracle DBA with a minimum of 5 years of experience with 9i and 11i. etc. Ken Janusz, CPIM Requirements: Must be able to lift heavy database files. Must be at least 30

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

yeppers. I'm so glad I got all of his garbage filtered to /dev/null :) joe [EMAIL PROTECTED] 06/25/01 01:40PM And Lisa, most of them lie thru their teeth in order to get a position filled ! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, June

RE: License high water mark

Dave, by simply shutting down the service. Are you on NT? If so and you've set the registry entries to shutdown the db when the service or the server is shutdown, this could be what happened. -- Anita --- Farnsworth, Dave [EMAIL PROTECTED] wrote: I am looking into this possibility now.

RE: License high water mark

Check the audit folder as well under $ORACLE_HOME "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Monday, June

Q: Oracle 8.1.7 install on Redhat 7.1

Hi list, I#m trying to install Oracle 8.1.7 on Redhat Linux 8.1.7. First of all, I'm a newbie in Linux. So installed Redhat Linux. I have done what Oracle docs says about pre-installation tasks on Linux. I've created a user oracle, two groups oinstall, dba the mountpoints... What I haven't

RE: MTS problem

It is the same with mts_dispatchers=TCP,2 Ivo -Original Message- Sent: Monday, June 25, 2001 07:22 PM To: Multiple recipients of list ORACLE-L Ivo, isn't it mts_dispatchers=TCP,10 (or however many you want) -The Dinosaur -Original Message- Sent: Monday, June

RE: db_file_multiblock_read_count/max i/o

alter session set db_file_multiblock_read_count = 32768; enable event 10046 at level 8 do a large full scan check the trace file, 'p3' tells you the max mb count it could use, and thus the max io (from oracle's perspective) hth connor --- Koivu, Lisa [EMAIL PROTECTED] wrote: Um that

RE: Griping about auditing (not the Oracle Kind)

Well Kimberly, sometimes you have to do what you have to do to get a point accross. Depending on the type of employer you have, sometimes you have to take drastic measures that you would not normally take. -Original Message- Sent: Monday, June 25, 2001 12:16 PM To: Multiple recipients

RE: Design Question - Thoughts Needed

Tracy, I would fight tooth and nail for a separate auto_coverage table that is a child to each parent auto record. (It actually represents a many-to-many relationship between the auto table and the available_coverage table which lists all coverages available). When you argue about performance

RE: db_file_multiblock_read_count/max i/o

Title: RE: db_file_multiblock_read_count/max i/o Oracle will silently set it to the max setting for the platform. Meaning the v$parameter will just show what you set it at reguardless of what the max is. The only way is using truss type utility and monitor the system calls. "Walking on

RE: SGA QUESTION

Hi all, If he has 8GB of memory, why not allocate 4GB to the data buffer instead of I don't remember the limit, but there *is* an upper limit on the amount of memory that a single process can address in NT (was it 2Gb?). Since the architecture of Oracle on NT is a single-process-multi-threaded

RE: Design Question - Thoughts Needed

Tracy: I'd make the coverages their own entity. And use a cross-reference table to determine if a specific coverage is available in given state. This stuff needs to be entity driven because it is so dynamic (who knows, your company may stop offering coverage in, say New Jersey.) As for I/Os, I

RE: Griping about auditing (not the Oracle Kind)

Sorry but there are better ways. -Original Message- Sent: Monday, June 25, 2001 11:00 AM To: Multiple recipients of list ORACLE-L Well Kimberly, sometimes you have to do what you have to do to get a point accross. Depending on the type of employer you have, sometimes you have to

Moving tablespace across disks

Do I need to make the tablespace READONLY before cpying it to another disk location - ora can I simply - take the file offline - and copy the file across -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network

Re: Design Question - Thoughts Needed

I would go for creating a separate table for coverage , to make design more flexible. If you add 10 cols in vehicle table and and a new coverage is added later you will have to alter your table. Still you think performance and space you can cluster the two tables . -Big P - Original Message

which initSID?

Hi gurus How we know which initSID.ora file are in use in running instance if disk is not designed as OFA? Where can I found referenced tables name menas which Data dictionary table? Thanks -Seema _ Get your FREE download of MSN

  1   2   >