hi Guys
Does anybody know how to use bind variables in RDO connection to Oracle. I have a requirement of recoding a part of a module which uses oracle Database Connectivity. Can anybody help me out with this
Hi guys,
Could anyone help me out by giving the steps needed to configure my database to MTS . I am running the database (ver 8.1.7) in dedicated mode. How do we calculate the number of dispatchers (i.e. how do we calculate connections per dispatcher? supposing that i have around 250 users...
Hi ,
Has anyone used Oracle 9i Internet File system on Windows 2000. If so could you tell me how to configure E-mail . I am testing the IFS for the first time. I am using Oracle 9.0.1 version and Using Windows 2000 Server
I saw in its documentation that i would need to get send mail...
hi guys,
First of all i would like to say i am new to Linux (Being oracle Dba on windows) . I would like to test Oracle Database in Linux. So i want to join (? or add to the network) my linux server to the Existing Windows 2000 Domain so that users from windows can connect to the oracle...
Hi,
Is it possible to shift a database from one machine to another without export and import. Here is what would like to do. I am running oracle 8.1.6.3 ON windows 2000 server (Hp machine) with datafiles,redo log files and control files on a NetApp Storage Device (Filer F720) .(log files and...
Hi,
I have created around 4 listener which i dont use now how do i delete the listeners from the services I have removed them from listener.ora file. But when i go to Component services i can see that they are still there. I am using windows 2000 server with oracle 8i
Thanks
hi,
I was doing full import on the database when a hardware error caused the database and the server to crash. now when i am starting up the database it says media recovery required but i do not have the log files since durring import i was running the database in noarchivelog mode. Now i can...
Hi,
I have just upgraded my test server to 9i from 8.1.6.0.0. Now while taking an export it is showing the following error.
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export...
Hi,
could anybody tell me what 'SQL*Net message from client' waits mean and what i should do decrease
1 select SUBSTR(EVENT,1,27),TOTAL_WAITS,TOTAL_TIMEOUTS,
2 TIME_WAITED from v$system_event where time_waited<>0
3* order by time_waited desc
SQL> /
SUBSTR(EVENT,1,27)...
hi,
My problem again is with regard to redo log buffer. I just joined in a firm as a beginner and here the redo log buffer is seen to be set as 29 MB .But still the log space waits and more importantly the log file sync is seen to be increasing in an enormous rate. could anybody give me advice...
hi,
My problem is as follows,
1)the redo buffer allocation retries and log space request in the V$systat increases constantly by about 2 (each of them with max of upto 12 ) durring each check point. is there any scope for tuning here and if so how.
2)I am new to this databse and it has...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.