Hi,
After you've kicked them out already you can also do an alter system enable
restricted session. (no need to shut it down if for instance batch jobs are
already running)
This will allow anybody with restricted session privileges to connect to
the database (DBA role has it included).
Jack
Hi Larry
THX
Jack
Larry Elkins [EMAIL PROTECTED]@fatcity.com on 28-12-2001 14:25:18
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Jack,
I assume you
Hi all,
I recently installed an Oracle 8.1.6 under Netware 5.
The server is HP LH3000 with 1Go of Memory and 3x9 Go of disk space.
I have two instances and since that the server hangs frequently (min 2
times a day) and the error in the trace file is
*** SESSION ID:(13.123)
Title: RE: XP Professional 9i
I think it is our problem actually because the majority of questions you ask could be answered quite easily by looking at the manual or using Metalink.
Is your company just a one or 2 man band or is it a reasonably sized company. If so I would have thought that
Hi! Here are some new questions that I have but here is some background information you'll need to know about me first:
I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have
Title: RE: XP Professional 9i
John:
I work for
a very small company that does DB/application conversions for state
governments. They will not spend
the money for Metalink. I am the
only Oracle person in the company.
So, my only source of Oracle information is documentation and the
Oklahoma
Secretary of State. The client
doesn't belong to Metalink either.
They may after they go live.
Ken
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 29, 2001
11:45 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE:
Scott:
9i is for my home PC for educational purposed only. I have gotten feedback
from a couple of folks who have installed the W2000 version on XP Prof. and
have found that it works just fine.
As far as Metalink goes. I am using a DB for data conversion purposes only.
I am the only one
Gee, I thought I was the only one.
Regards,
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
Maritimes Region, DFO
Lyuda,
Did you get an answer for this? You can try using the SUBSTR command to
read the 7 char data string and rebuild it into something longer like:
col_dat substr(:col_seq,1,2) || '--' || substr(:col_seq,3,3) || '--' ||
substr(:col_seq,6,2)
Hope this helps
Tom Mercadante
Oracle Certified
Ken.
I work for a quasi state gov't organization ( state lottery) and we
are covered under the state contract with Oracle for support. I think that with
some creative investigating you can uncover the CSI number that exists in the
state organization and use it to get access to Metelink. That
Hi Gurus
I was try to import one table but an import failed with following errors.
IMP-00058: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [],
[]
IMP-00017: following statement failed with ORACLE error 3113:
ALTER TABLE PROD_SEARCH_TRACK ADD
As I made the jump from Access to Oracle a couple of years ago, I'll try
to answer some of your questions.
1. Salary: Very dependent on where you work and the state of the
economy. In my case, I started as a junior DBA with the same salary as a
very experienced Access developer. Oracle has much
Naw, But Jared did forget one:
Do you believe that a personal life is obsolete.
Dick Goulet
Reply Separator
Author: Boivin; Patrice J [EMAIL PROTECTED]
Date: 12/31/2001 4:35 AM
Gee, I thought I was the only one.
Regards,
Patrice Boivin
Systems
Here is the background of the stiuation I am facing.
We are piloting a application that uses a hybred store and forward system to
aggregate all of our disparate student data into one central database.
Currently there are 20 schools integrated into the system with another 48 to
go, those 20
Log on to Metalink and enter the ORA-600 line, including the arguments in
brackets, in the search. It will provide a resolution for you.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:
Tom Schruefer wrote:
I am guessing the answer to both of these questions is, It Depends. So my
question really is, how do I determine what the correct settings for my
installation are?
Tom
I'd say the frequency of 'checklog not complete' messages in the alert
log file is probably what I
Tom:
File sizes of 5k are not good. If you have the room on your server, I
would increase that significantly. Perhaps to 50-60m. Log switching every
90 sec. is not good.
There are many INIT.ORA parameters that control the performance of redo
logs. LOG_BUFFERS or LOG_BUFFER_SIZE is
Where can I find the total size of my DB? I have not found anything in the
DBA_ views or my documentation.
Thanks,
Ken
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
1. Depends on the company/part of the country and the economy.
2. State your experience with other databases. Once you get Oracle up
and running at home, add that so they know you have installed it (IMHO
installing on Linux is more impressive as it is very close to unix, but
doing it under
Tom,
My general rule of thumb in determining how large the redo logs should be is
to size them so that they fill no sooner than 20 minutes apart. This is
*not* a hard rule by any means. 20 minutes gives log writer plenty of time
to clear them so that they can be ready for the next go-around.
select sum(bytes) from dba_segments;
This should do it.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 31, 2001 11:10 AM
Where can I find the total size of my DB? I have not found anything in
the
DBA_ views or my
You want infrequent log switches, because each log switch flushes dirty blocks from
the SGA. The tradeoff is that recovery after a crash will be slightly longer.
I would try making the redo log size 1M. 5k every 90 seconds adds up to about 800k in
4 hours (14400 seconds / 90 seconds * 5k =
Ken,
Look in the DBA_DATA_FILES view. This will show the size of the data files.
It does NOT show you the size of the redo log or control files.
hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, December 31, 2001 11:11 AM
To: Multiple
Isn't that printed in the admin guide. chapter 37. Size of My Database?
-Original Message-
Sent: Monday, December 31, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
Where can I find the total size of my DB? I have not found anything in the
DBA_ views or my documentation.
I try to average 1 every hour or so depending on volume. You do have
archiving on don't you.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204 [EMAIL PROTECTED] 12/31/01 11:05:20
AM Tom: File sizes of 5k
DBA_DATA_FILES, DBA_SEGMENTS
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Monday, December 31, 2001 11:11 AM
To:
Tom,
It does depend on a number of factors. If you have a number of redo logs,
like 10 or more, you can allow a smaller size file as this prevents the database
from running out of on-line redo before arch gets one cleaned out. Sizing the
redo logs is more a matter of how granular do you
yea, or V$DATAFILES
-Original Message-
Sent: Monday, December 31, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
select sum(bytes) from dba_segments;
This should do it.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday,
Thanks for all the responses,
It turns out two of the triggers are from the vendor (database supports a
maintenance management system)
and the third is one of ours.
The trigger in question (the third one) updates the data for accounting
purposes before it gets moved
(one of the other
select sum(bytes) from sys.dba_datafiles;
select sum(bytes) from sys.dba_temp_files;
that is how much space allocated, not necessarily used within each datafile.
joe
Ken Janusz wrote:
Where can I find the total size of my DB? I have not found anything in the
DBA_ views or my
Good afternoon all:
I have been holding back on replying to this email because I really
wanted to see what some of the other answers were, especially ones related
to OCP. Rachel C. will understand as my answers will be very direct.
1. What is the average salary range for an entry-level
Semantics... Both of the below only give you the total size you've allocated
for storage not the actual size of the database. It's also going to include
sizing for the system tablespace, rollback segments and maybe temporary
segments depending on how they were created. Picky, picky... :-)
I will go with:
select sum(bytes) from dba_segments
-Original Message-
Sent: Monday, December 31, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L
select sum(bytes) from sys.dba_datafiles;
select sum(bytes) from sys.dba_temp_files;
that is how much space allocated, not
On my home PC running Windows NT 4.0, I have an Oracle Database 8.1.6. I had
setup the services for this database to start the database whenever the PC
is turned on and it used to work fine. But for the last few days when I turn
on the PC, the database does not start automatically and when I
Actually, if you reverse the order, they won't be able to log
back in after you kill their sessions.
Jared
On Sunday 30 December 2001 23:40, [EMAIL PROTECTED] wrote:
Hi,
After you've kicked them out already you can also do an alter system enable
restricted session. (no need to shut it down
Thanks for the input, the server is a Dell PowerEdge 6500.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 31, 2001 11:05 AM
Tom:
File sizes of 5k are not good. If you have the room on your server, I
would increase that
I have created the .bmp file for import to my DB. All I want to do is
import that data. Here is the imp script:
file=h:\kjanusz\sqlldr\log\nic13.dmp
log=h:\kjanusz\sqlldr\log\nic13imp.log
commit=N
ignore=Y
analyze=N
indexes=N
constraints=N
grants=N
rows=Y
destroy=N
tables=(*)
And here is
Hi Ken,
At first blush it doesn't look like the user kenneth owns any objects,
Were there particular users that owned the objects before?
If you want everything imported you could add full=yes and remove the
tables=* from your imp.dat.
Hope this helps,
John
[EMAIL PROTECTED] wrote:
I have
Physical size?
SELECT sum(bytes)/1024/1024 FROM dba_data_files;
Will show how much physical space your db takes up on the file system in
megabytes.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 31, 2001 10:10 AM
Where can I
Remove tables=(*) from your parfile or list all tables like
tables=tableA,tableb etc...
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 31 Dec 2001 12:45:18 -0800
I have created the .bmp file for import to my DB. All I want to do is
import
Hi list,
I am asking an OFF-TOPIC question,
I want to restrict users from copying any file from a
windows 2000 advance server box though I want them to read that file.
I have shared some folders to the users which I want them to
read/execute but not to copy to their hard drives.
I heard there is a way in windows 2000 server/advance server to restrict
the COPY operation from users. They can read and execute the files but
cannot copy Has any one tried that
Any suggestions/hints/material will be highly appreciated.
The Samba package is free and works nicely
43 matches
Mail list logo