Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Insert with NOLOGGING option.

vittelJan 29 2010 — edited Jan 29 2010
Hi,

I'm in ORACLE 10gR2/Redhat4

I need to insert in a table more than 1000000 rows with NOLOGGING.
For that I do:

alter table TRACES_00_HIST NOLOGGING;

SQL> ed
écrit file afiedt.buf

1 INSERT /*+ APPEND */ INTO TRACES_00_HIST
2 (select traces_00_seq.nextval AS ID,TRACE_DATE,TIMESTAMP AS TSTAMP,TYPE_OF_ACTION,
3 from TRACES_OLD
4 where OPCO_ID in (0,-1)
5* and TO_CHAR(CREATED_TIME,'yyyymmdd') <= TO_CHAR(sysdate -366,'yyyymmdd'))
SQL> /

1440592 ligne(s) créée(s).


Statistiques
- -------------------------------------------------------- -
42337 recursive calls
256523 db block gets
1507334 consistent gets
1482469 physical reads
*231394900 redo size*
535 bytes sent via SQL*Net to client
830 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
9 sorts (memory)
0 sorts (disk)
1440592 rows processed

I'm doing some thing wrong? why my insert is genrating redo?
I try this Link:665145 and it's working fine but not with my query!!

Please help

Comments

Hello kelthuzad87,

The link to the icon it'll use is configured in your FW_Application, in the Icon URL field (and subsequent URL fields). You'll need to make sure the URL to that icon works and displays the correct image.

Kind regards,

Stephan.

1 person found this helpful
kelthuzad87

Hello, thank you for the quick answer.

I check all of the path that I must to insert to registrate the application: the .png file exist and the .app also but when I create the the FW_View and the FW_Application nothing happens. However after that I have created this two elements I cannot still access to the application with the old link: http://localhost:9180/articles-1.0/home.app . On tomcat is started but I cannot access to the application like before the creation of FW_View and FW_Application.

PS: I also published FW_View an FW_Application, is it correct?

Stephan Da Silva-Oracle
Answer

Hello kelthuzad87,

I just tried it out and I see the problem. For some reason it's appending the URL of the image to the base URL:http://sites-server:8080/cs/http://articles-server:9080/articles-1.0/images/articles.png

If you've installed the articles application on the same appserver as Sites, you can try changing the icon URL to: ../articles-1.0/images/articles.png

and the layout URL to: ../articles-1.0/layout.app

Or try copying the articles.png from your {deployed articles-1.0)/images and layout.jsp from your {deployed articles-1.0}/WEB-INF/jsp into the deployed Sites application somewhere, and change the URLs accordingly. E.g. if you place them both in {deployed Sites app}/articles/, then change the URLs to /articles/articles.png and /articles/layout.jsp (not .app!) respectively.

I'll raise a bug for the fact that it's appending the URLs to the Sites base URL.

Kind regards,

Stephan.

Edit: the bug id is 18388817.

Message was edited by: Stephan da Silva-Oracle

Marked as Answer by kelthuzad87 · Sep 27 2020
1 person found this helpful
kelthuzad87

Thank you very much! Now It is perfect. Anyway there's still a problem: When I stop and restart Jump start Kit It cannot show me the application: even If I go at http://localhost:9180/articles-1.0/home.app page the browser give me back an error page. If I go on tomcat app manager the application is running but the number of application session grow up quickly seconds after seconds. I don't know why it happens: The first time that I run the application it doesn't happens. I have try to remove the application from tomcat(also folder and .war file) but after the first run when I try to restart JSK it show me the error message in the application.

I'm not sure what that could be.

Is the articles-1.0 application running on the JSK?

What kind of error do you get when you try to access it?

Are there any errors in the tomcat logs?

Kind regards,

Stephan.

kelthuzad87

I think that I have discovered which is the problem: Every time that I restart JSK I need to launch again the install.app page. If I do not start the install.app page the application crash and you can't use it until you restart JSK. However I desire that every time I restart JSK I don't need to reinstall the application: is there any way to do this? I have try to remove the file .war from the webapps folder but if I do this also the articles-1.0 folder will be removed by tomcat after some seconds(and so also the application).

That sounds like a tomcat thing. Try this:

- Stop the appserver
- Remove everything related to articles-1.0 from the webapps directory.

- Create an empty articles-1.0 in webapps.

- unzip your articles-1.0.war into the directory you just created.

- Start the appserver

Kind regards,

Stephan.

2 people found this helpful
kelthuzad87

Solved! Thank you very much!!

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 26 2010
Added on Jan 29 2010
#general-database-discussions
22 comments
48,822 views