Answer Posted / anonymous

We have parameters like parallel to assign number of workers in data pump, but not in exp/imp.
Also Data Pump uses stream pool of SGA.

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2814

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2622

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2168

---

what is asm?

1052

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1731

---

internal architecture

2197

---

What would you do with an "in-doubt" distributed transaction?

1887

---

How do you open a cluster administrator? : sql server DBA

1104

---

what is ora 24313?what is the procedure to exclude that error?

2570

---

What authentication modes does sql server support? : sql server DBA

1217

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2113

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2043

---

What is a correlated sub-query? : sql server DBA

1087

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2720

---

what do you understand by fine-grained auditing?

1057

---