|
||||
|
My friend is having a problem while import using IMPDP, which poses us some questions here. The impdp is hung or just processing at constraints enabling around 7000+ (massive 2TB database) and apparently ran for 3 days. Note, He had already used parallel = 10. Now question is, 1) Does parallel clause work […] Hello, Until 10g when you want to export and import between releases (i.e 10g to 11g), For example you want to export from 11g database and import it into 10g. This is not possible until 10g, unless you use the higher version binaries(means expdp/impdp executables) in both databases. But from 11g R1 onwards you […] Object statistics will become stale whenever there is an dml operations performed on those objects, that means new/deletion of rows, adding columns, updating columns may change the row count, number of blocks, index entries etc. This staleness of object statistics has been determined or hardcoded to 10% of the modifications to the objects(tables etc), for […] Hi, Well, If your database environment has well established statistics gathering mechanism or your application has specific requirement of statistics gathering, you may need to disable the automatic statistics gathering, this is a bit different in 10g and 11g. All of us aware starting 10g automatic statistics gather job will kicked off every night 10PM […] Hello, Sometimes we tend to miss some simple thing which I had similar in expdp and impdp. Normally when you want to export a schema and import into another schema we user fromuser and touser, before to that you have to create the user in target database where you are going to import. In expdp/impdp […] OMS (Enterprise Manager) is generating huge quatity of logs. Logs generated by the Grid Infrastructure are spread across modules. There are logs for http Apache module, log for Infrastructure, agents logs and traces, opmn logs etc. Here are the location of logs that use a lot of disk space: 1) Agent Log and Trace Files: […] Once the grid agent has been installed on target servers, we have to log to Grid control and configure the targets located by the agent, in order to collect the metrics by agent and upload to OMS, (typically dbnsmp password etc to be provided) other wise the in GUI you will see metric collection errors […] We may need sometimes to export or import the monitoring templates in Oracle grid control from one environment to new environment, for example when you upgrade or a new OMS infrastructure has been built, in this case the emcli export/import will help you to copy the monitoring templates between environments, lets see how to do […] As you aware spfile located in asm disks only starting 11gR2 in cluster environment. When CRSD need to start the various resources of the node or updates it changes in OCR. the location of spfile also should known to crsd. Here the gpnp profile comes into handy. (read more here for gpnp) The order […] In 11gR2, Oracle has introduced a cache called flash cache which is a secondary cache of the buffer cache. This flash cache is resides in L2 Cache of the system (RAM) and can be very fast compare to the disk. The SSD disks which gives you the benefit of high speed disks , the same […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!