25/09/2018 11:47
RANT MODE ONLast couple of weeks I've been trying to put together an architecture for anew highly available production internet web services and database W2K is the platform so 10G AS not available.
Great I thought I can use Oracle Maximum Availability papers I did - oh boy are there holes. Check MAA for details on IAS infrastruc HA -you won't find many.
The database - yes - completely solid - these are technologies - RAC,DataGuard and Standby etc etc - great no problem I can live wit.... read more

3 answersclick here to view

24/09/2018 11:47
Hi,It is Oracle 9i/HP-UX.
Network has sufficient bandwith OC3 155Mbits /sec ( WAN though ).
Required throughput is 30Mbits/sec.
log_archive_max_processes 10log_archive_dest_2 SERVICE=ERPST lgwr async=20480 reopen=15max_failure=10 optional net_timeout=30 Any ideas ? Regards, Ranko.

3 answersclick here to view

23/09/2018 11:47
Hello, I'm currently developing a JDBC program on Oracle and I have thefollowing problem.
I use the BLOB.getBinaryStream() method, it works fine, I got thestream and I can read it.
My problem is slow performances, when I call stream.read(): The first call takes 10 seconds.
Then 32*1024 next calls are very fast.
Then hang for 10 secondsThen 32ko readed fast, hang....
Do you have any idea if this is Database or JDBC problem? The network is fine.
I think it's a SQL Net problem, because.... read more

5 answersclick here to view

22/09/2018 11:47
Does anyone know how to instruct SQL*Loader to ignore the last recordin a flat file when the size of the flat file is not constant?

1 answersclick here to view

21/09/2018 11:47
hello DBAs, I think latch is private memory taken in SGA by each user while workingon database. Is it Correct.
AndAs Soon as I tried to connect to my database by any user on network, itis taking much time whereas my network and database are workingproperly. What can be the problem here, because after connection thereis no problem in performance.Pls help......
Thank You

4 answersclick here to view

20/09/2018 11:47
Hi, I would like to store perl scripts in tables in mysql. So that whensomeone clicks on a button on a web page, it will run the query onthat button to remove nodes in and out of the load balancers which isa perl script. This perl script telnets into the appliance. Willsomeone provide a command or keyword so that I can searchdev.mysql.com. The perl scripts has sensitive username/ passwords sothat by storing it in tables, will make it less hackable. Thanks inadvance.

7 answersclick here to view

19/09/2018 11:47
When backing up data from large RAM to small RAM (RAM backup ), ORACLEfailed to work with message 'database unavailable'.
Appreciate your help!

1 answersclick here to view

18/09/2018 11:47
Hi there, I have an obscure problem.
I moved my oracle instance (8.1.7) from one subnet to another (changedon server tnsnames.ora, listener.ora, tnsnames on clients) and now onlya few seconds after startup, sqlplus and other clients can connect.
After some seconds, I get errors on client side, but tnsping reports noerrors.
The error messages are : client: ORA-12545: Connect failed because target host or object does not exist sqlnet.log (client): *************************************************.... read more

2 answersclick here to view

16/09/2018 11:47
Hello, I've created a query that returns rows sorted by date. From the newestto the oldest.
I need to get the first element, that is the newest, and then the restof the elements but in reverse order, that is the oldest to thenewest ie.: id, name, date----------------------12 item4 2010-12-2516 item34 2005-11-5123 item2 2001-10-1591 item925 1996-8-882 item7 1992-3-12145 item445 1989-10-6283 item8 1985-5-1675 item53 1978-2-4345 item12 1976-7-772 item91 1963-5-17 output shoul.... read more

5 answersclick here to view

15/09/2018 11:47
Hi,I am planning to install Oracle 9i/10g on Sun Solaris. Below are theactivities I need to do. Can some body provide me Step-by-Stepprocedure to be followed for below activities.
Pre-Installation ActivitiesCreating a install UserConfiguring OS Memory and shared memoriesCreating distinct file systems for Oracle -- Capacity planningInstalling the productPost product installations Thanks in AdvanceSampath

2 answersclick here to view

14/09/2018 11:47
Hello, New to working with Oracle here and I cannot find the answer to myquestion. I have a table that stores a char e.g., 1, 2, or 3. Thosechars reflect that statuses of reports. 1 = open, 2 = review, 3 =closed. When querying I can use decode so the user sees open, review,or closed instead of the less meaningful 1, 2, or 3.
My question is what if I want to write to the DB? If the user is usinga GUI to interface with the DB and they see open, review, or closed inthe GUI's list of optio.... read more

3 answersclick here to view

13/09/2018 11:47
My company has created a profile that all Oracle databases mustimplement. The main purpose of this profile is to enforce strongerpassword standards. The corporate folks have a newPASSWORD_VERIFY_FUNCTION that will enforce longer password lengths,ensure at least one special character, and at least one numeric.
I manage a database that has about 300 folks in the DEFAULT profilewithout anything specified for PASSWORD_VERIFY_FUNCTION. I'm assumingthat many of my users don't have password.... read more

1 answersclick here to view

12/09/2018 11:47
Hi All.
I have small db which consist of two tables the menu and the auto. Thesize of menu table is 600 rows and auto table is 1800 rows. The equalrequest work well for tiny db: select a1.the_value, a2.the_valuefrom dic a1, dic a2where a1.the_key = tab.key and a2.the_key = tab.key; Following request can't finish itself. select a1.name_rec , a2.name_recfrom autoinner join menu a1 on a1.c_menu||a1.c_rec = c_typeinner join menu a2 on a2.c_menu||a2.c_rec = c_plant; My friends use other sql-se.... read more

1 answersclick here to view

11/09/2018 11:47
Tom Bishop better be at or near the top. He is the closest thing to atalking vagina I've ever seen.
BTW how many different ways can you spellAshley/Ashlee/Ashlei/Ashlie/Asslie etc?

2 answersclick here to view

10/09/2018 11:47
--____TDMFCWCGKQZDHUWOOCOW____Content-Type: text/plain; charset=iso-8859-1Content-Transfer-Encoding: quoted-printable Hi list I'm looking for a mecano like this.
mySQL_String :=3D 'select count(*) from table A' FOR tempData IN (mySQL_String) LOOP doSomethingWithTempData; =20END LOOP; Is this possible? Because it's annoying to implement different section for =each case of the needed SQL.
Because may be I need this: mySQL_String :=3D 'select count(*) from table A where myF.... read more

1 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS