I am trying to calculate total Oracle memory usage on a Windows server. I am taking Total System Global Area from show sga to get the memory allocated to SGA....
Hi all, I am new in trigger development. I am using Oracle 10G and trying to develop a trigger to solve the following problem: I have 2 tables LIST_TABLE and...
Hello, I think there is no need of loop in trigger body because you trigger fors for every row. Second thing is you first checkt that the inserting row is...
The problem is that you are trying to loop through the columns as if the list of columns was an array, but it is not an array. Yes, I know, if you are used to...
Hiya All, I am trying to build an Application Server for the first time, and I am kinda stuck. I am trying to install Oracle AS 10.1.2.0.2 onto a machine that...
Larry Blankenship
lblankenship@...
Mar 20, 2006 2:10 pm
845
We have a 10g database running on HP-Unix Itanium servers. We have two identical servers with Oracle 10g installed and configured. All database files (control...
I have never done this before but I think it is very possible (I was about to test this idea but ended up creating them again). Since OEM jobs are saved in a...
Devamanoharan, Mano
devamanp@...
Mar 20, 2006 8:28 pm
847
I am writing an Oracle Standards Document for our Company but have found very few templates available for this. Does anyone out there have an Oracle Standards...
Yeah, we had that problem too. Turns out that this version of Forms and Reports server CANNOT be installed without OID. OID doesn't have to be running on the...
William, Hi. I too have found very few standards on the internet. Do you mean database naming standards or ones for columns and tables. ?? Allen ... I am...
Allen Shepard
ashepard@...
Mar 24, 2006 12:35 pm
850
I have a few standards-type documents on my website: http://www.smdi.com/employee/JohnF/ Don't know if anything there will be helpful to you. I found an old ...
We're a UNIX shop that uses 8i, 9i, and 10g. We're a bizarre mix at my company. We definitely have standards but they're not documented in one place. We have...
Hi, Ruth - you are right about picking the battles. Often a company is made up of many people who each have atleast 10 *different* years of database and...
Allen Shepard
ashepard@...
Mar 27, 2006 2:53 pm
853
Hey Bill, What kind of standards are you looking for, we have created some basic programming standards, if this is what you are looking for let me know. Thanks...
Since this was part of the original discussion - Can either Ruth, Allen or anyone provide some real world examples of the seperation between dba accounts....
Steff Gonos
steff_gonos@...
Mar 27, 2006 8:22 pm
855
Thanks - I am going to "play around" with this and see what happens. Since each job is linked to a target, the database jobs should may still work but I am...
Folks, We are on a Solaris Sparc system. It has Oracle 9i Enterprise Edition software already installed along with a database. I am trying to install Oracle...
Hello, I tried to use the DBMS_LOB and a procedure here attached. I have a DIRECTORY created and used the directory_name as the parameter, the file name, and...
Hello all, I am tasked with getting an Oracle 10g database up on RHEL 3.... I munged the install, and would like to uninstall the database software. When I...
Larry Blankenship
lblankenship@...
Apr 21, 2006 6:34 pm
859
Larry, Just delete the oracle home directory (and everything in it)... You can then start over... Unlike Windows, there are no registry entries to worry about...
Michael Glover
glovermj@...
Apr 21, 2006 8:01 pm
860
Larry, Don't forget to delete the inventory. Especially in your case, you want to make sure you start with a clean slate. You told the installer where to ...
Larry, You probably already did this but I forgot to mention shutting down all oracle programs and demons running before deleting the directory (that may be...
Michael Glover
glovermj@...
Apr 25, 2006 2:32 pm
862
I've never done this with the DBMS_LOB package, but there are several ways to do this. In fact, I'm in the middle of writing an ODTUG presentation on the...
My experience has been that for this to work, the physical directory (p_Directory) must be on the database server. You must copy these files to the db server...
Worthington, Richard
worthinr@...
Apr 25, 2006 2:34 pm
864
Why would a query of all_constraints cause 7 million consistent gets and take nearly two minutes ? On a similarly configured instance it only takes about 700...
Sjmnetx, Hi. Hmm, well the knee jerk reactions are 1) No index to help 2) The data in ordered differently between the two tables causing more page fetches. ...
Allen Shepard
ashepard@...
May 1, 2006 1:47 pm
866
I had no chance to review the trace yet today. However, I checked dba_indexes and dba_ind_columns for the tables that comprise all_constraints view; Namely,...
-- Interjection by listserv moderator: -- Please email Victoria directly at nichollsvi@... -- if you interested in responding to this post (don't -- reply...
Sjmnetx, Hi. Ok, when you get a chance to add the line " set arraysize 1000 ' and re- run the query let us know. Have you analyzed the table? I would think...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
