| schema after export and import slowlier [message #306209] |
Thu, 13 March 2008 05:16  |
brandointheweb
Messages: 25
Registered: August 2005
Location: Germany
|
Junior Member |
|
|
Hi all together,
I have a question for export and import oracle-schemes
With following export-file I created my .dmp-file:
USERID=MyUser/PW@SID1
log=E:\DATENBANKEN\Export\exp_MyUser_1303.log
DIRECT=N
FILE=E:\DATENBANKEN\Export\exp_MyUser_1303.dmp
owner=MyUser
COMPRESS=Y
RECORD=N
STATISTICS=NONE
I imported this user with following file into a new instance:
USERID=MyUser1/PW@SID2
FILE=exp_MyUser_1303.dmp.dmp
fromuser=MyUser
touser=MyUser1
IGNORE=Y
COMMIT=Y
LOG=MyUser1.log
All this worked fine!
BUT:
I noticed that all of my procedures, functions etc. run aproox. 2-3 times slowlier as in the original schema.
I checked everything: all configuration of my instances is the same. The only difference is, that the slowlier schema was imported.
Can anyone give me a hint what to look for?!
Best regards!
|
|
|
|
|
|
|
|
| Re: schema after export and import slowlier [message #306236 is a reply to message #306231] |
Thu, 13 March 2008 06:50  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Sorry my mistake.
Collect statistics again.
execute this from sqlplus.
Substitute scott with your schema name.
exec dbms_stats.gather_schema_stats('SCOTT',method_opt=>'For all indexed columns',cascade=>true);
With this you collect the statistics for all tables, for all indexed columns and indexes. Based on this information CBO will lay the best path to fetch the data.
[Updated on: Thu, 13 March 2008 06:53] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
