Section2

admin

第1-5单时的我的输出(station37):

1. 
   
2. 
   
3. ----------------------------------------------------------------------------------------------------
   
4. ----------------------------------------------------------------------------------------------------
   
5. ----------------------------------------------------------------------------------------------------
   
6. ******************** Section2 ********************
   
7. ----------------------------------------------------------------------------------------------------
   
8. ----------------------------------------------------------------------------------------------------
   
9. ----------------------------------------------------------------------------------------------------
   
10. 
    
11. 
    
12. ******************** TOPIC 1 ********************
    
13. export ORACLE_SID=EMREP
    
14. .bash_profile OK
    
15. 
    
16. 
    
17. ******************** TOPIC 1.1 ********************
    
18. 
    
19. 
    
20. ******************** TOPIC 1.2 ********************
    
21. 
    
22. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:48 2015
    
23. 
    
24. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    
25. 
    
26. SQL> Connected.
    
27. SQL> SQL> SQL> SQL> SQL> SQL> ****************************
    
28. SQL> The database open mode here:
    
29. SQL> ****************************
    
30. SQL> SQL>
    
31. D
    
32. -
    
33. X
    
34. SQL>
    
35. OPEN_MODE
    
36. ----------
    
37. READ WRITE
    
38. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    
39. With the Partitioning, OLAP and Data Mining options
    
40. 
    
41. 
    
42. R102000=2
    
43. 
    
44. 
    
45. A: READ WRITE
    
46. 
    
47. 
    
48. ******************** TOPIC 1.3 ********************
    
49. Connection closed by foreign host.
    
50. tcp        0      0 0.0.0.0:7777                0.0.0.0:*                   LISTEN      10752/webcached     
    
51. Trying 127.0.0.1...
    
52. Connected to localhost.localdomain (127.0.0.1).
    
53. Escape character is '^]'.
    
54. 
    
55. 
    
56. R103001=0.5
    
57. 
    
58. 
    
59. A: tcp        0      0 0.0.0.0:7777                0.0.0.0:*                   LISTEN      10752/webcached     
    
60. tcp        0      0 0.0.0.0:7777                0.0.0.0:*                   LISTEN      10752/webcached     
    
61. Trying 127.0.0.1...
    
62. Connected to localhost.localdomain (127.0.0.1).
    
63. Escape character is '^]'.
    
64. 
    
65. 
    
66. R103002=2.5
    
67. 
    
68. 
    
69. A: Escape character is '^]'.
    
70. 
    
71. 
    
72. ******************** TOPIC 1.4 ********************
    
73. 
    
74. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:49 2015
    
75. 
    
76. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    
77. 
    
78. SQL> Connected.
    
79. SQL> SQL> SQL> SQL> SQL>   2    3  
    
80. KEY_VALUE
    
81. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
82. dbsnmp
    
83. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    
84. With the Partitioning, OLAP and Data Mining options
    
85. 
    
86. 
    
87. R104000=0.2
    
88. 
    
89. 
    
90. A: dbsnmp
    
91. 
    
92. 
    
93. ******************** TOPIC 1.5 ********************
    
94. 
    
95. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:49 2015
    
96. 
    
97. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    
98. 
    
99. SQL> Connected.
    
100. SQL> SQL> SQL> SQL> SQL>   2    3  
     
101. KEY_VALUE
     
102. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
103. dbsnmp
     
104. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
105. With the Partitioning, OLAP and Data Mining options
     
106. 
     
107. 
     
108. R105000=0.2
     
109. 
     
110. 
     
111. A: dbsnmp
     
112. 
     
113. 
     
114. ******************** TOPIC 1.6 ********************
     
115. 
     
116. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:49 2015
     
117. 
     
118. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
119. 
     
120. SQL> Connected.
     
121. SQL> SQL> SQL> SQL> SQL> SQL>
     
122. USER_NAME                                           SYSTEM_USER         DELETING
     
123. -------------------------------------------------- ----------- ----------
     
124. SYSMAN                                                             1                0
     
125. MGMT_VIEW                                                     0                0
     
126. SYS                                                             1                0
     
127. SYSTEM                                                             1                0
     
128. EMADMIN                                                      0                0
     
129. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
130. With the Partitioning, OLAP and Data Mining options
     
131. 
     
132. 
     
133. R106000=0.2
     
134. 
     
135. 
     
136. A: EMADMIN                                                      0                0
     
137. 
     
138. 
     
139. ******************** TOPIC 2 ********************
     
140. 
     
141. 
     
142. ******************** TOPIC 2.1 ********************
     
143. 
     
144. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:49 2015
     
145. 
     
146. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
147. 
     
148. SQL> SQL> Connected.
     
149. SQL>
     
150. VALUE
     
151. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
152. 524288000
     
153. 
     
154. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
155. With the Partitioning, OLAP and Data Mining options
     
156. 
     
157. 
     
158. R201001=0.1
     
159. 
     
160. 
     
161. A: 524288000
     
162. 
     
163. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:50 2015
     
164. 
     
165. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
166. 
     
167. SQL> SQL> Connected.
     
168. SQL>
     
169. VALUE
     
170. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
171. 
     
172. 
     
173. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
174. With the Partitioning, OLAP and Data Mining options
     
175. 
     
176. 
     
177. R201002=0.1
     
178. 
     
179. 
     
180. A: 0
     
181. 
     
182. 
     
183. ******************** TOPIC 2.2 ********************
     
184. 
     
185. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:50 2015
     
186. 
     
187. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
188. 
     
189. SQL> SQL> Connected.
     
190. SQL>
     
191. VALUE
     
192. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
193. 300
     
194. 
     
195. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
196. With the Partitioning, OLAP and Data Mining options
     
197. VALUE_A: 300
     
198. 
     
199. 
     
200. R202001=0.1
     
201. 
     
202. 
     
203. 
     
204. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:50 2015
     
205. 
     
206. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
207. 
     
208. SQL> SQL> Connected.
     
209. SQL>
     
210. VALUE
     
211. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
212. 300
     
213. 
     
214. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
215. With the Partitioning, OLAP and Data Mining options
     
216. VALUE_A: 300
     
217. 
     
218. 
     
219. R202002=0.1
     
220. 
     
221. 
     
222. 
     
223. 
     
224. ******************** TOPIC 2.3 ********************
     
225. 
     
226. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:51 2015
     
227. 
     
228. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
229. 
     
230. SQL> SQL> Connected.
     
231. SQL>   2  
     
232. WARNING_VALUE
     
233. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
234. 87
     
235. 
     
236. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
237. With the Partitioning, OLAP and Data Mining options
     
238. VALUE_A: 87
     
239. 
     
240. 
     
241. R203001=0.15
     
242. 
     
243. 
     
244. 
     
245. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:51 2015
     
246. 
     
247. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
248. 
     
249. SQL> SQL> Connected.
     
250. SQL>   2  
     
251. CRITICAL_VALUE
     
252. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
253. 95
     
254. 
     
255. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
256. With the Partitioning, OLAP and Data Mining options
     
257. VALUE_A: 95
     
258. 
     
259. 
     
260. R203002=0.15
     
261. 
     
262. 
     
263. 
     
264. 
     
265. ******************** TOPIC 2.4 ********************
     
266. 
     
267. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:51 2015
     
268. 
     
269. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
270. 
     
271. SQL> Connected.
     
272. SQL> SQL> SQL> SQL> SQL>
     
273. EMAIL_ADDRESS
     
274. --------------------------------------------------------------------------------------------------------------------------------
     
275. dba@ocm.com
     
276. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
277. With the Partitioning, OLAP and Data Mining options
     
278. 
     
279. 
     
280. R204000=0.3
     
281. 
     
282. 
     
283. A: dba@ocm.com
     
284. 
     
285. 
     
286. ******************** TOPIC 2.5 ********************
     
287. 
     
288. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:52 2015
     
289. 
     
290. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
291. 
     
292. SQL> SQL> Connected.
     
293. SQL>
     
294. TABLESPACE_NAME                     BYTES
     
295. ------------------------------ ----------
     
296. REGISTRATION                         94371840
     
297. 
     
298. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
299. With the Partitioning, OLAP and Data Mining options
     
300. 
     
301. 
     
302. R205000=0.1
     
303. 
     
304. 
     
305. A: 0
     
306. 
     
307. 
     
308. ******************** TOPIC 2.5.1 ********************
     
309. 
     
310. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:52 2015
     
311. 
     
312. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
313. 
     
314. SQL> SQL> Connected.
     
315. SQL>
     
316. TABLESPACE_NAME                     BYTES
     
317. ------------------------------ ----------
     
318. REGISTRATION                         94371840
     
319. 
     
320. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
321. With the Partitioning, OLAP and Data Mining options
     
322. 
     
323. 
     
324. R205010=0.1
     
325. 
     
326. 
     
327. A: REGISTRATION                         94371840
     
328. 
     
329. 
     
330. ******************** TOPIC 2.5.2 ********************
     
331. 
     
332. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:52 2015
     
333. 
     
334. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
335. 
     
336. SQL> SQL> Connected.
     
337. SQL>
     
338. TABLESPACE_NAME                  MAXBYTES
     
339. ------------------------------ ----------
     
340. REGISTRATION                        125829120
     
341. 
     
342. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
343. With the Partitioning, OLAP and Data Mining options
     
344. 
     
345. 
     
346. R205020=0.1
     
347. 
     
348. 
     
349. A: REGISTRATION                        125829120
     
350. 
     
351. 
     
352. ******************** TOPIC 2.5.3 ********************
     
353. 
     
354. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:52 2015
     
355. 
     
356. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
357. 
     
358. SQL> SQL> Connected.
     
359. SQL>
     
360. SEGMEN
     
361. ------
     
362. AUTO
     
363. 
     
364. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
365. With the Partitioning, OLAP and Data Mining options
     
366. 
     
367. 
     
368. R205030=0.1
     
369. 
     
370. 
     
371. A: AUTO
     
372. 
     
373. 
     
374. ******************** TOPIC 3 ********************
     
375. 
     
376. 
     
377. ******************** TOPIC 3.1 ********************
     
378. 
     
379. 
     
380. ******************** TOPIC 3.2 ********************
     
381. 
     
382. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:52 2015
     
383. 
     
384. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
385. 
     
386. SQL> SQL> Connected.
     
387. SQL>
     
388. SCHEDULE_NAME
     
389. ------------------------------
     
390. DAILY_PURGE_SCHEDULE
     
391. DAILYREBUILD
     
392. 
     
393. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
394. With the Partitioning, OLAP and Data Mining options
     
395. 
     
396. 
     
397. R302000=0.2
     
398. 
     
399. 
     
400. A: DAILYREBUILD
     
401. 
     
402. 
     
403. ******************** TOPIC 3.3 ********************
     
404. 
     
405. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:53 2015
     
406. 
     
407. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
408. 
     
409. SQL> SQL> Connected.
     
410. SQL>
     
411. SCHEDULE_NAME
     
412. ------------------------------
     
413. REPEAT_INTERVAL
     
414. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
415. DAILYREBUILD
     
416. FREQ=DAILY;BYHOUR=14;BYMINUTE=0;BYSECOND=0
     
417. 
     
418. 
     
419. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
420. With the Partitioning, OLAP and Data Mining options
     
421. 
     
422. 
     
423. R303000=0.3
     
424. 
     
425. 
     
426. A: FREQ=DAILY;BYHOUR=14;BYMINUTE=0;BYSECOND=0
     
427. 
     
428. 
     
429. ******************** TOPIC 3.4 ********************
     
430. 
     
431. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:53 2015
     
432. 
     
433. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
434. 
     
435. SQL> SQL> Connected.
     
436. SQL>
     
437. PROGRAM_NAME
     
438. ------------------------------
     
439. EMP_IND_REBUILD
     
440. AUTO_SPACE_ADVISOR_PROG
     
441. GATHER_STATS_PROG
     
442. PURGE_LOG_PROG
     
443. 
     
444. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
445. With the Partitioning, OLAP and Data Mining options
     
446. 
     
447. 
     
448. R304001=0.2
     
449. 
     
450. 
     
451. A: EMP_IND_REBUILD
     
452. 
     
453. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:55 2015
     
454. 
     
455. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
456. 
     
457. SQL> SQL> Connected.
     
458. SQL>
     
459. OBJECT_NAME                                                                                                                         LAST_DDL_
     
460. -------------------------------------------------------------------------------------------------------------------------------- ---------
     
461. EMP_EMAIL_UK                                                                                                                         12-SEP-15
     
462. EMP_EMP_ID_PK                                                                                                                         12-SEP-15
     
463. EMP_DEPARTMENT_IX                                                                                                                 12-SEP-15
     
464. EMP_JOB_IX                                                                                                                         12-SEP-15
     
465. EMP_MANAGER_IX                                                                                                                         12-SEP-15
     
466. EMP_NAME_IX                                                                                                                         12-SEP-15
     
467. 
     
468. 6 rows selected.
     
469. 
     
470. SQL>
     
471. ANALYZEDT
     
472. ----------
     
473. .000011574
     
474. 
     
475. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
476. With the Partitioning, OLAP and Data Mining options
     
477. VALUE_A: 0
     
478. 
     
479. 
     
480. R304002=0.55
     
481. 
     
482. 
     
483. 
     
484. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:55 2015
     
485. 
     
486. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
487. 
     
488. SQL> SQL> Connected.
     
489. SQL>
     
490. OBJECT_NAME                                                                                                                         LAST_DDL_
     
491. -------------------------------------------------------------------------------------------------------------------------------- ---------
     
492. EMP_EMAIL_UK                                                                                                                         12-SEP-15
     
493. EMP_EMP_ID_PK                                                                                                                         12-SEP-15
     
494. EMP_DEPARTMENT_IX                                                                                                                 12-SEP-15
     
495. EMP_JOB_IX                                                                                                                         12-SEP-15
     
496. EMP_MANAGER_IX                                                                                                                         12-SEP-15
     
497. EMP_NAME_IX                                                                                                                         12-SEP-15
     
498. 
     
499. 6 rows selected.
     
500. 
     
501. SQL>
     
502. ANALYZEDT
     
503. ----------
     
504. .000011574
     
505. 
     
506. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
507. With the Partitioning, OLAP and Data Mining options
     
508. 
     
509. 
     
510. R304002=0.55
     
511. 
     
512. 
     
513. A: 000011574
     
514. 
     
515. 
     
516. ******************** TOPIC 3.5 ********************
     
517. 
     
518. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:56 2015
     
519. 
     
520. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
521. 
     
522. SQL> SQL> Connected.
     
523. SQL>
     
524. WINDOW_NAME
     
525. ------------------------------
     
526. WINDOW1
     
527. 
     
528. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
529. With the Partitioning, OLAP and Data Mining options
     
530. 
     
531. 
     
532. R305001=0.2
     
533. 
     
534. 
     
535. A: 0
     
536. 
     
537. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:56 2015
     
538. 
     
539. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
540. 
     
541. SQL> SQL> Connected.
     
542. SQL>
     
543. RESOURCE_PLAN
     
544. ------------------------------
     
545. SYSTEM_PLAN
     
546. 
     
547. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
548. With the Partitioning, OLAP and Data Mining options
     
549. 
     
550. 
     
551. R305002=0.25
     
552. 
     
553. 
     
554. A: SYSTEM_PLAN
     
555. 
     
556. 
     
557. ******************** TOPIC 3.6 ********************
     
558. 
     
559. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:56 2015
     
560. 
     
561. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
562. 
     
563. SQL> SQL> Connected.
     
564. SQL>
     
565. JOB_NAME
     
566. ------------------------------
     
567. PROGRAM_NAME
     
568. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
569. SCHEDULE_NAME
     
570. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
571. REBUILD_JOB
     
572. EMP_IND_REBUILD
     
573. DAILYREBUILD
     
574. 
     
575. 
     
576. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
577. With the Partitioning, OLAP and Data Mining options
     
578. 
     
579. 
     
580. R306000=0.1
     
581. 
     
582. 
     
583. A: REBUILD_JOB
     
584. 
     
585. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:56 2015
     
586. 
     
587. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
588. 
     
589. SQL> SQL> Connected.
     
590. SQL>
     
591. JOB_NAME
     
592. ------------------------------
     
593. PROGRAM_NAME
     
594. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
595. SCHEDULE_NAME
     
596. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
597. REBUILD_JOB
     
598. EMP_IND_REBUILD
     
599. DAILYREBUILD
     
600. 
     
601. 
     
602. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
603. With the Partitioning, OLAP and Data Mining options
     
604. 
     
605. 
     
606. R306000=.15
     
607. 
     
608. 
     
609. B: EMP_IND_REBUILD
     
610. 
     
611. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:56 2015
     
612. 
     
613. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
614. 
     
615. SQL> SQL> Connected.
     
616. SQL>
     
617. JOB_NAME
     
618. ------------------------------
     
619. PROGRAM_NAME
     
620. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
621. SCHEDULE_NAME
     
622. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
623. REBUILD_JOB
     
624. EMP_IND_REBUILD
     
625. DAILYREBUILD
     
626. 
     
627. 
     
628. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
629. With the Partitioning, OLAP and Data Mining options
     
630. 
     
631. 
     
632. R306000=.20
     
633. 
     
634. 
     
635. C: DAILYREBUILD
     
636. 
     
637. 
     
638. ******************** TOPIC 3.7 ********************
     
639. 
     
640. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:57 2015
     
641. 
     
642. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
643. 
     
644. SQL> SQL> Connected.
     
645. SQL>
     
646. WINDOW_GROUP_NAME               WINDOW_NAME
     
647. ------------------------------ ------------------------------
     
648. WINGROUP1                       WIN1
     
649. WINGROUP1                       WIN2
     
650. 
     
651. SQL>
     
652.     COUNTW
     
653. ----------
     
654.          2
     
655. 
     
656. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
657. With the Partitioning, OLAP and Data Mining options
     
658. VALUE_A:          2
     
659. 
     
660. 
     
661. R307001=0.5
     
662. 
     
663. 
     
664. 
     
665. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:57 2015
     
666. 
     
667. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
668. 
     
669. SQL> SQL> Connected.
     
670. SQL>
     
671. RESOURCE_PLAN
     
672. ------------------------------
     
673. SYSTEM_PLAN
     
674. 
     
675. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
676. With the Partitioning, OLAP and Data Mining options
     
677. 
     
678. 
     
679. R307002=0.3
     
680. 
     
681. 
     
682. A: SYSTEM_PLAN
     
683. 
     
684. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 19:30:58 2015
     
685. 
     
686. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
687. 
     
688. SQL> SQL> Connected.
     
689. SQL>
     
690. RESOURCE_PLAN
     
691. ------------------------------
     
692. SYSTEM_PLAN
     
693. 
     
694. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
695. With the Partitioning, OLAP and Data Mining options
     
696. 
     
697. 
     
698. R307003=0.3
     
699. 
     
700. 
     
701. A: SYSTEM_PLAN
     
702. ****************************************************************************************************
     
703. 
     
704. 
     
705. R102000: 2 full is 2 2
     
706. R103001: 0.5 full is 0.5 2.5
     
707. R103002: 2.5 full is 2.5 5
     
708. R104000: 0.2 full is 0.2 5.2
     
709. R105000: 0.2 full is 0.2 5.4
     
710. R106000: 0.2 full is 0.2 5.6
     
711. R201001: 0.1 full is 0.1 5.7
     
712. R201002: 0.1 full is 0.1 5.8
     
713. R202001: 0.1 full is 0.1 5.9
     
714. R202002: 0.1 full is 0.1 6
     
715. R203001: 0.15 full is 0.15 6.15
     
716. R203002: 0.15 full is 0.15 6.3
     
717. R204000: 0.3 full is 0.3 6.6
     
718. R205000: 0.1 full is 0.1 6.7
     
719. R205010: 0.1 full is 0.1 6.8
     
720. R205020: 0.1 full is 0.1 6.9
     
721. R205030: 0.1 full is 0.1 7
     
722. R302000: 0.2 full is 0.2 7.2
     
723. R303000: 0.3 full is 0.3 7.5
     
724. R304001: 0.2 full is 0.2 7.7
     
725. R304002: 0.55 full is 0.55 8.25
     
726. R305001: 0.2 full is 0.2 8.45
     
727. R305002: 0.25 full is 0.25 8.7
     
728. R306000: .20 full is 0.2 8.9
     
729. R307001: 0.5 full is 0.5 9.4
     
730. R307002: 0.3 full is 0.3 9.7
     
731. R307003: 0.3 full is 0.3 10
     
732. full of this section:
     
733. RESULT:
     
734. 10.00
     
735. 
     
736. 
     
737. ****************************************************************************************************

复制代码