Hi Experts, I am executin dbms_profile to see the the performance of one of stored procedure. The stored procedure took 3 min to complete it execution, but...
I am OCP 8i DBA and am looking for Power POint Presentations for Data base architecture and administration. Will appreciate if you can direct me to the right...
Hi All I need Your Help please I am trying to install oracle 8.1.7.0 at sun Solaris for Intel when I Run the /install/Solaris/runInstaller it's tell me please...
Go to DBSpecialists.com and download their hite paper for installing Oracle 9i on Solaris. It works. Or else go to OTN.oracle.com and download instructions...
hello, i am having a problem and not able to connect to oracle when i try to connect it gives the message ORA-01092 Oracle instance terminated .disconnection...
Hi Pavan, What are the error in the alert and trace file. Sameer ... From: pavanpatidar [mailto:pavanpatidar@...] Sent: Wednesday, April 16, 2003 3:14 AM...
Sameer Wadhwa
swadhwa@...
Apr 16, 2003 1:33 pm
327
i want to run oracle reports from a Java Frame. How can i do that ? regards Ahsen Saeed ... Do you Yahoo!? The New Yahoo!...
Hi Saeed, Refer the book Oracle web 101 for step by step instructions. Sameer ... From: Ahsen Saeed [mailto:ahsensaeed2003@...] Sent: Wednesday, April...
Sameer Wadhwa
swadhwa@...
Apr 30, 2003 1:24 pm
330
Hello all, In Oracle Report I want to print Labels in Last Page of the report ,Which should print the labels in same area in all Reports.When I keep Labels...
Hi !I have some questions regarding Oracle Reports. Please reply if you know. a) How can we call oracle reports from a Java Frame ?b) Can we send an oracle...
This is not a job, but an answer for some of us that used to have a 9 to 5 full time job In Corporate America with full health care benefit and more. However,...
Hi All ! IS there a way to check the validity of the archive log files . Like we can use db_verify to check for the validity of the data files . What about for...
Amith Uppal
uppal_amith@...
May 13, 2003 6:52 am
335
Hi Amith, I think, RMAN will check the validity of archive logs files while backup. Thanks Sameer ... From: Amith Uppal [mailto:uppal_amith@...] Sent:...
Sameer Wadhwa
swadhwa@...
May 13, 2003 2:00 pm
336
Hi Amith, I think, you can use db_block_checksum = true to ensure , the corruption is detected at the time of creation of archive log files, as well as...
Rajesh Arora
arora_rajesh@...
May 13, 2003 2:24 pm
337
Hi All ! In unix shell scripting , even if we prompt for username / password , it will still display in the ps command . I need a way to get rid of this . I...
Amith Uppal
uppal_amith@...
May 14, 2003 11:57 am
338
If I undestand you correctly, you are prompting for user/pass at the shell script level and passing them to SQLPlus. Instead of read USER read PASS sqlplus...
Hi Amith, Here is a script I saved long time ago. Take a look at it. It should hide the arguments passed to sqlplus(including username/password), & hides it...
Rajesh Arora
arora_rajesh@...
May 14, 2003 2:03 pm
340
Hi all ! That was very helpfull ! Amith Rajesh Arora <arora_rajesh@...> wrote: Hi Amith, Here is a script I saved long time ago. Take a look at it. It...
Amith Uppal
uppal_amith@...
May 15, 2003 3:51 am
341
Hi All, I am having a 9i database which is frequently crashing with the above message.The alert log shows the message as below. Errors in file...
Hi, I have application which use JSP at front end and oracle 8.1.7 at back end. I keep getting error which is java.sql.SQLException: ORA- 01000: maximum open...
Some thought on this . Whats the value of your init parameters ? cursor_sharing cursor_space_for_time Also when u close the web page , do u actually close all...
Amith Uppal
uppal_amith@...
May 16, 2003 4:08 am
345
Guys , I am looking for a generic script to generate alerts if any segment reaches the maxextents threshold . The segment type can be rollback , table , index...
Amith Uppal
uppal_amith@...
May 16, 2003 11:16 am
346
Hi Amith, cursor_sharing = EXACT cursor_space_for_time = FALSE I am using connection pool for my web pages. Usually, I close connection and it will close all...
Amith, I do not know, whether you are looking for the sql statement or the monitoring script. Here is a simple sql statement, you can expand of it for your...
Rajesh Arora
arora_rajesh@...
May 16, 2003 3:35 pm
348
Hi Sameer, All the file status and tablespace status are available and online respecitively. I made a file renaming to different partition and started the ...
hi all Please I need for yor Help very much I am going to 1z0-123 Architecture and Admin next week 1Z0-123 I am using testking ver1.0 for this exam can any one...
Sorry if this is a basic question. I am trying to pupulate a table which has a collumn called 'CONFIRM_YN'. When I try to insert data into this table I've...
What is your insert statement? What is the data type of the column? What's the error message? On Sat, 31 May 2003 02:11:09 -0000, "matthous2003" wrote: Sorry...
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.
