{"id":814,"date":"2013-05-01T12:36:37","date_gmt":"2013-05-01T12:36:37","guid":{"rendered":"http:\/\/mojtabanow.info\/web\/?p=814"},"modified":"2013-05-01T15:53:07","modified_gmt":"2013-05-01T15:53:07","slug":"%d8%a3%d8%b3%d8%a7%d8%b3%d9%8a%d8%a7%d8%aa-%d8%aa%d8%b5%d9%85%d9%8a%d9%85-%d8%aa%d8%b7%d8%a8%d9%8a%d9%82%d8%a7%d8%aa-%d9%82%d9%88%d8%a7%d8%b9%d8%af-%d8%a7%d9%84%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa","status":"publish","type":"post","link":"https:\/\/qdatabyte.com\/?p=814","title":{"rendered":"\u0623\u0633\u0627\u0633\u064a\u0627\u062a \u062a\u0635\u0645\u064a\u0645 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a"},"content":{"rendered":"

\u0639\u0645\u0644\u064a\u0629 \u062a\u0635\u0645\u064a\u0645 \u0648\u062a\u0637\u0648\u064a\u0631 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 \u0627\u0648 \u0643\u0645\u0627 \u064a\u0637\u0644\u0642 \u0639\u0644\u064a\u0647\u0627 \u0627\u0644\u0645\u0637\u0648\u0631\u0648\u0646 (\u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u0646\u0638\u0627\u0645) \u0639\u0645\u0644\u064a\u0629 \u0645\u0639\u0642\u062f\u0647 \u0648\u0644\u064a\u0633\u062a \u0628\u0627\u0644\u0628\u0633\u0627\u0637\u0647 \u0627\u0644\u062a\u0649 \u064a\u0645\u0643\u0646 \u062d\u0635\u0631\u0647\u0627 \u0641\u0649 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0648\u062a\u0634\u063a\u064a\u0644 \u0645\u0639\u0627\u0644\u062c \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u0641\u0648\u0631\u0645\u0627\u062a \u0648\u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0628\u0644 \u064a\u0645\u062a\u062f \u0644\u0627\u0628\u0639\u062f \u0645\u0646 \u0630\u0644\u0643 \u0643\u062b\u064a\u0631\u0627 \u0641\u064a\u062c\u0628 \u0644\u0644\u0645\u0637\u0648\u0631 \u0627\u0644\u0625\u0644\u0645\u0627\u0645 \u0628\u0643\u0644 \u0627\u0644\u062a\u0641\u0627\u0635\u064a\u0644 \u0627\u0644\u062a\u0649 \u064a\u062d\u062a\u0627\u062c\u0647\u0627 \u062a\u0637\u0628\u064a\u0642\u0647 \u0628\u062f\u0627\u064b \u0645\u0646 \u0641\u0647\u0645 \u0648\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0645\u0637\u0644\u0648\u0628 \u0648\u0627\u062e\u062a\u064a\u0627\u0631 \u0627\u0641\u0636\u0644 \u0627\u0644\u0637\u0631\u0642 \u0644\u062a\u0646\u0641\u064a\u0630\u0647 , \u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u0644\u0627\u064a\u0631\u0643\u0632 \u0639\u0644\u0649 \u0627\u0633\u0627\u0633\u064a\u0627\u062a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0646\u0638\u0645 \u0628\u0644 \u0639\u0644\u0649 \u0627\u0644\u0646\u0627\u062d\u064a\u0629 \u0627\u0644\u0628\u0631\u0645\u062c\u064a\u0629 \u0644\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a, \u0627\u0649 \u0639\u0644\u0649 \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u0639\u0631\u0641\u0649 \u0628\u0623\u062f\u0648\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 \u0627\u0644\u062a\u0649 \u064a\u062c\u0628 \u0639\u0644\u0649 \u0645\u0637\u0648\u0631 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0645\u0639\u0631\u0641\u062a\u0647\u0627 \u0644\u0627\u062e\u062a\u064a\u0627\u0631 , \u0641\u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 \u062a\u062a\u064a\u062d \u0627\u0644\u0639\u062f\u064a\u062f \u0645\u0646 \u0627\u0644\u0623\u062f\u0648\u0627\u062a \u0627\u0644\u062a\u0649 \u064a\u0645\u0643\u0646 \u0627\u0646 \u062a\u0624\u062f\u0649 \u0639\u062f\u0629 \u0627\u063a\u0631\u0627\u0636 \u0627\u0641\u0636\u0644 \u0645\u0646 \u0627\u0644\u0627\u062e\u0631\u0649 , \u0641\u0645\u062b\u0644\u0627 \u0628\u062f\u0648\u0646 \u0645\u0639\u0631\u0641\u0629 \u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 \u0627\u0644\u062c\u062f\u0648\u0644 \u0627\u0644\u0639\u0627\u062f\u0649 Table \u0648\u0627\u0644 View \u0648 \u0627\u0644 Materialized View\u00a0 \u0633\u064a\u0643\u0648\u0646 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u062d\u062a\u0645\u0627 \u063a\u064a\u0631 \u0645\u0643\u062a\u0645\u0644 \u0627\u0644\u062c\u0648\u0627\u0646\u0628 \u0648\u0631\u0628\u0645\u0627 \u0633\u064a\u0639\u0627\u0646\u0649 \u0645\u0646 \u0645\u0634\u0643\u0644\u0627\u062a \u062d\u0642\u064a\u0642\u064a\u0629 \u0641\u0649 \u0627\u0644\u062a\u0635\u0645\u064a\u0645 \u062a\u0624\u062f\u0649 \u0644\u0645\u0634\u0643\u0644\u0627\u062a \u0627\u0643\u0628\u0631 \u0641\u0649 \u0639\u0645\u0644\u0647 \u0645\u0646 \u0646\u0627\u062d\u064a\u0629 availability\u00a0 \u0648\u0631\u0628\u0645\u0627 \u064a\u0624\u062b\u0631 \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0643\u0643\u0644 , \u0641\u0627\u0644\u0645\u0637\u0648\u0631 \u064a\u062c\u0628 \u0627\u0646 \u064a\u0627\u062e\u0630 \u0641\u0649 \u0627\u0644\u0627\u0639\u062a\u0628\u0627\u0631 \u0645\u062a\u0649 \u064a\u062d\u0641\u0638 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u0649 \u062c\u062f\u0648\u0644 \u0639\u0627\u062f\u0649 \u0627\u0648 \u062c\u062f\u0648\u0644 \u0639\u0634\u0648\u0627\u0626\u0649 \u0648\u0645\u062a\u0649 \u064a\u0633\u062a\u062e\u062f\u0645 external tables \u0643\u0645\u0627 \u064a\u062c\u0628 \u0639\u0644\u064a\u0647 \u0643\u064a\u0641 \u064a\u062a\u0648\u062c\u0628 \u0639\u0644\u064a\u0647 \u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0645\u0646 \u0648\u062d\u062f\u0629 \u0627\u0644 DUAL \u0648\u0627\u0644\u062a\u0649 \u064a\u0633\u062a\u062e\u062f\u0645\u0647\u0627 \u0627\u0644\u0645\u0637\u0648\u0631\u0648\u0646 \u0628\u0643\u062b\u0631\u0629 \u062f\u0648\u0646 \u0645\u0631\u0627\u0639\u0627\u0629 \u0644\u0633\u0631\u0639\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u062f\u0648\u0646 \u0645\u062d\u0627\u0648\u0644\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0634\u063a\u0631\u0627\u062a \u0627\u0644 pause \u0648\u0627\u0644\u062a\u0649 \u062a\u062a\u064a\u062d \u0627\u0632\u0627\u0644\u0629 \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0632\u064a\u0627\u062f\u0629 \u0644\u0633\u0631\u0639\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u063a\u064a\u0631\u0647\u0627 , \u0633\u0627\u062a\u062d\u062f\u062b \u0628\u0627\u064a\u062c\u0627\u0632 \u0639\u0646 \u0628\u0639\u0636 \u0627\u0644\u0646\u0642\u0627\u0637 \u0627\u0644\u062a\u0649 \u064a\u062c\u0628 \u0644\u0645\u0637\u0648\u0631\u0649 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0631\u0627\u0639\u0627\u062a\u0647\u0627 \u0628\u0634\u062f\u0647 \u0648\u0642\u0628\u0644 \u0643\u0644 \u0634\u064a\u0649 \u064a\u062c\u0628 \u0639\u0644\u0649 \u0643\u0637\u0648\u0631 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644\u0625\u0644\u0645\u0627\u0645 \u0628\u0643\u0644 \u0627\u0644\u0627\u062f\u0648\u0627\u062a \u0627\u0644\u062a\u0649 \u062a\u0633\u0627\u0639\u062f\u0647 \u0641\u0649 \u0639\u0645\u0644\u0647 \u0645\u062a\u0648\u0641\u0631\u0629 \u062f\u0627\u062e\u0644 \u0627\u0644\u0627\u0648\u0631\u0627\u0643\u0644 \u0627\u0645\u062b\u0627\u0644 Tables \u0648\u0627\u0644 indexes \u0648 Views \u0648\u0627\u0644 synonym \u0648 snapshot \u0648\u063a\u064a\u0631\u0647\u0627 , \u062f\u0639\u0648\u0646\u0627 \u0646\u062f\u062e\u0644 \u0644\u0644\u0645\u0648\u0636\u0648\u0639 :<\/p>\n

\"JoseArticle-300x179<\/a><\/p>\n

<\/p>\n

\u0646\u0642\u0637\u0647 \u0627\u0648\u0644\u0649 :\u00a0 \u062d\u0633\u0628 \u0627\u062d\u0635\u0627\u0626\u064a\u0627 \u0627\u0648\u0631\u0627\u0643\u0644 \u0641\u0623\u0646 50% \u0645\u0646 \u0645\u0634\u0627\u0643\u0644 \u0633\u0631\u0639\u0629 \u0648\u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u062a\u0639\u062a\u0645\u062f \u0623\u0633\u0627\u0633\u0627\u064f \u0639\u0644\u0649 \u0627\u062e\u0637\u0627\u0621 \u0641\u0649 \u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u062f\u0648\u0627\u062a \u0628\u062f\u0644\u0627 \u0639\u0646 \u0627\u062f\u0648\u0627\u062a \u0628\u0639\u064a\u0646\u0647\u0627 \u0645\u062b\u0644\u0627 \u0643\u0623\u0633\u062a\u062e\u062f\u0627\u0645 \u062c\u062f\u0648\u0644 \u0628\u062f\u0644\u0627 \u0639\u0646 View \u0627\u0648 \u062c\u0639\u0644 \u0627\u0644\u062a\u0642\u0631\u064a\u0631 \u064a\u0642\u0648\u0645 \u0628\u0639\u0645\u0644\u064a\u0627\u062a \u062a\u062c\u0643\u064a\u0639 \u0645\u062c\u0647\u062f\u0629 \u0644\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0643\u0644 \u0645\u0631\u0647 \u0628\u062f\u0644\u0627 \u0645\u0646 \u062a\u062c\u0647\u064a\u0632 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062a\u0649 \u064a\u062d\u062a\u0627\u062c\u0647\u0627 \u0627\u0644\u062a\u0642\u0631\u064a\u0631 \u0641\u0649 \u062c\u062f\u0648\u0644 \u0648\u0627\u062d\u062f \u0628\u0642\u062f\u0631 \u0627\u0644\u0625\u0645\u0643\u0627\u0646 \u0639\u0644\u0649 \u0627\u0646 \u062a\u062a\u0645 \u0630\u0644\u0643 \u0641\u0649 \u0643\u0631\u062d\u0644\u0629 \u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u062a\u0637\u0628\u064a\u0642.<\/p>\n

\u0628\u0639\u0636 \u0623\u0633\u0627\u0633\u064a\u0627\u062a \u062a\u0635\u0645\u064a\u0645 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a <\/span>:<\/span><\/p>\n

\u00a01- \u0645\u0633\u062a\u062e\u062f\u0645\u0649 \u0648\u0645\u062f\u062e\u0644\u0649 \u0628\u064a\u0627\u0646\u0627\u062a \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0627\u064a\u0647\u0645\u0647\u0645 \u0645\u0627\u0644\u0630\u0649 \u062a\u062d\u062a\u0648\u064a\u0647 \u0627\u0644\u062a\u0641\u0627\u0635\u064a\u0644 \u0627\u0644\u062f\u0627\u062e\u0644\u064a\u0629 \u0644\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0642\u0627\u0631\u0646\u0629 \u0628\u0633\u0631\u0639\u0629 \u0627\u0633\u062a\u062c\u0627\u0628\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u0633\u0647\u0648\u0644\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647 \u0645\u0639 \u0627\u0644\u0648\u0636\u0639 \u0641\u0649 \u0627\u0644\u0639\u062a\u064a\u0627\u0631 \u0628\u062a\u063a\u0637\u064a\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0644\u0623\u062d\u062a\u064a\u0627\u062c\u0627\u062a \u0627\u0644\u0639\u0645\u0644 , \u0641\u0644\u0627\u064a\u062c\u0628 \u0639\u0646\u062f \u0627\u0644\u0628\u062f\u0621 \u0641\u0649 \u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0648\u0636\u0639 \u0643\u0644 \u0627\u0644\u0627\u0647\u062a\u0645\u0627\u0645 \u0639\u0644\u0649 \u0627\u0644\u0646\u0638\u0631\u064a\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u064a\u0629 \u0648\u0627\u063a\u0641\u0627\u0644 \u0627\u0644\u062c\u0627\u0646\u0628 \u0627\u0644\u0630\u0649 \u064a\u062e\u0635 \u0633\u0647\u0648\u0644\u0629 \u062a\u0639\u0627\u0645\u0644 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0645\u0639 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0645\u0646 \u0643\u0627\u0641\u0629 \u0627\u0644\u0646\u0648\u0627\u062d\u0649 \u0641\u064a\u062c\u0628 \u062a\u0628\u0633\u064a\u0637 \u0627\u0644\u062a\u0635\u0645\u064a\u0645 \u0644\u0623\u0642\u0635\u0649 \u0645\u0627\u064a\u0645\u0643\u0646 , \u0641\u0645\u062b\u0644\u0627 \u0641\u0649 \u0627\u0644\u0627\u0646\u0638\u0645\u0629 \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u064a\u0645\u0643\u0646\u0646\u0627 \u0627\u062e\u0630 \u0627\u062f\u062e\u0627\u0644 \u062a\u0641\u0627\u0635\u064a\u0644 \u0639\u0646\u0635\u0631 \u0644\u0641\u0627\u062a\u0648\u0631\u0647 \u0641\u0627\u0644\u0639\u0645\u0644\u064a\u0629 \u0631\u0628\u0645\u0627 \u062a\u0642\u0648\u0645 \u0628\u0639\u0645\u0644\u064a\u0629 \u0628\u062d\u062b \u0639\u0646 \u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0648\u062a\u0641\u0627\u0635\u064a\u0644 \u0628\u062c\u062f\u0648\u0644 \u0627\u062e\u0631 \u0643\u0645\u0627 \u064a\u0645\u0643\u0646 \u0627\u0646 \u062a\u0642\u0648\u0645 \u0628\u0627\u0643\u062b\u0631 \u0645\u0646 \u0639\u0645\u0644\u064a\u0629 \u0627\u062f\u062e\u0627\u0644 \u0641\u0649 \u0639\u062f\u0629 \u0645\u0648\u0627\u0642\u0639 , \u0647\u0630\u0627 \u0639\u0644\u0649 \u0646\u0637\u0627\u0642 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0648\u0627\u062d\u062f \u0631\u0628\u0645\u0627 \u064a\u0643\u0648\u0646 \u0644\u064a\u0633 \u0630\u0649 \u0634\u0623\u0646 \u0641\u0649 \u0628\u0627\u0644 \u0645\u0637\u0648\u0631 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 , \u0644\u0643\u0646 \u064a\u062c\u0628 \u0639\u0644\u064a\u0647 \u0627\u0639\u0637\u0627\u0621\u0647 \u0627\u0634\u062f \u0627\u0644\u0627\u0646\u062a\u0628\u0627\u0647 \u0641\u0649 \u062d\u0627\u0644\u0629 \u0627\u0646 \u0627\u0644\u0627\u062f\u062e\u0627\u0644 \u064a\u062a\u0645 \u0628\u0627\u0643\u062b\u0631 \u0645\u0646 \u0645\u0633\u062a\u062e\u062f\u0645 \u0648\u0627\u062d\u062f \u0641\u0633\u064a\u0633\u0628\u0628 \u0647\u0630\u0627 \u0645\u0634\u0643\u0644\u0627\u062a \u0636\u062e\u0645\u0629 \u0644\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u0633\u064a\u062f\u062e\u0644\u0647 \u0641\u0649 \u062d\u0644\u0641\u0629 \u0645\u063a\u0644\u0642\u0629 \u0645\u0646 \u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644 Locks \u0648\u0627\u064a\u0642\u0627\u0641 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0648\u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0627\u062d\u064a\u0627\u0646\u0627 , \u0647\u0646\u0627 \u0648\u062c\u0628 \u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u062a\u0635\u0645\u064a\u0645 \u0648\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u062f\u0648\u0627\u062a \u0627\u0644 Materialize views \u0648\u063a\u064a\u0631\u0647\u0627 \u0644\u062f\u0648\u0631\u0647\u0627 \u0627\u0644\u0641\u0639\u0627\u0644 \u0641\u0649 \u062d\u0644 \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0643\u0644\u0627\u062a .<\/p>\n

2- \u0627\u0644\u063a\u0627\u0621 \u0648\u062a\u0642\u0644\u064a\u0644 \u0645\u0646\u0627\u062f\u0627\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0627\u0648\u0631\u0627\u0643\u0644 , \u0627\u0644\u0645\u0639\u0631\u0648\u0641 \u0627\u0646\u0647 \u0639\u0646\u062f \u0639\u0645\u0644 \u0627\u0649 \u0627\u062c\u0631\u0627\u0621 \u0639\u0644\u0649 \u062c\u0647\u0627\u0632 \u0627\u0644\u0643\u0645\u0628\u064a\u0648\u062a\u0631 \u0641\u0627\u0646 \u0627\u0644\u0645\u0639\u0627\u0644\u062c \u064a\u0642\u0648\u0645 \u0628\u0639\u0645\u0644 \u0645\u0639\u064a\u0646 \u0644\u062a\u0646\u0641\u064a\u0630 \u0627\u0644\u0627\u062c\u0631\u0627\u0621 \u0648\u0627\u0644\u0648\u0635\u0648\u0644 \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0639\u0644\u0649 \u0627\u0644\u0642\u0631\u0635 \u0647\u0630\u0647 \u0627\u0644\u0639\u0645\u0644\u064a\u0629 \u0646\u0637\u0644\u0642 \u0639\u0644\u064a\u0647\u0627 Physical reads \u0648\u0639\u0649 \u0639\u0645\u0644\u064a\u0629 \u0645\u062c\u0647\u062f\u0629 \u062c\u062f\u0627 \u0648\u064a\u062c\u0628 \u062a\u062c\u0646\u0628\u0647\u0627 \u0645\u062a\u0649 \u0645\u0627\u0633\u0646\u062d \u0630\u0644\u0643 , \u062f\u0639\u0646\u0627 \u0646\u0646\u0638\u0631 \u0644\u0644\u0645\u062b\u0627\u0644 \u0627\u0644\u062a\u0627\u0644\u0649 : \u0633\u0627\u0641\u062a\u0631\u0636 \u0627\u0646 \u0645\u0635\u0645\u0645 \u0646\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u064a\u0642\u0648\u0645 \u0628\u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0645\u0646 \u062c\u062f\u0648\u0644 dual \u0645\u062b\u0644\u0627 \u0642\u064a\u0645\u0629 \u0627\u0644\u0648\u0642\u062a \u0639\u062f\u0629 \u0645\u0631\u0627\u062a \u062f\u0648\u0646 \u0627\u0644\u0648\u0636\u0639 \u0627\u0644\u0627\u0639\u062a\u0628\u0627\u0631 \u0627\u0646 \u0647\u0630\u0627 \u0627\u0644\u062c\u062f\u0648\u0644 \u0628\u0627\u0644\u0630\u0627\u062a \u0644\u064a\u0633 \u062c\u062f\u0648\u0644\u0627 \u0639\u0627\u062f\u064a\u0627 \u0628\u0644 oracle internal table , \u0641\u0627\u0630\u0627 \u0642\u0645\u062a \u0645\u062b\u0644\u0627 \u0628\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0632\u0645\u0646 \u0645\u0646 \u0647\u0630\u0627 \u0627\u0644\u062c\u062f\u0648\u0644 \u0641\u0627\u0639\u0644\u0645 \u0627\u0646 \u0628\u064a\u0627\u0646\u0627\u062a \u0647\u0630\u0627 \u0627\u0644\u062c\u062f\u0648\u0644 \u064a\u062a\u063a\u064a\u0631 86,400 \u0645\u0631\u0647 \u0641\u0649 \u0627\u0644\u064a\u0648\u0645 \u0648\u0647\u0630\u0627 \u0627\u0644\u0645\u0635\u0645\u0645 \u0642\u0627\u0645 \u0628\u0627\u0633\u062a\u062f\u0639\u0627\u0621 \u0628\u064a\u0627\u0646\u0627\u062a \u0639\u062f\u0629 \u0645\u0631\u0627\u062a \u062f\u0627\u062d\u0644 \u062a\u0637\u0628\u064a\u0642\u0647 \u0645\u0646 \u062f\u0627\u062e\u0644 \u0647\u0630\u0627 \u0627\u0644\u062c\u062f\u0648\u0644 \u0648\u062a\u0637\u0628\u064a\u0642\u0647 \u0647\u0630\u0627 \u064a\u0633\u062a\u062e\u062f\u0645\u0647\u00a0 50 \u0645\u0633\u062a\u062e\u062f\u0645 \u0641\u062a\u062e\u064a\u0644 \u0639\u062f\u062f \u0645\u0631\u0627\u062a \u0627\u0644 physical read \u0627\u0644\u062a\u0649 \u0633\u062a\u062a\u0645 \u0648\u0643\u0645\u0627 \u0633\u0628\u0642 \u0648\u0630\u0643\u0631\u062a \u0627\u0646 \u0647\u0630\u0627 \u0627\u0644\u062c\u062f\u0648\u0644 \u0644\u064a\u0633 \u062c\u062f\u0648\u0644 \u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0646\u0642\u0648\u0644 \u0627\u0646\u0647\u0627 Logical reads \u0628\u0644 physical reads\u00a0 \u0641\u0641\u0649 \u0647\u0630\u0647 \u0627\u0644\u062d\u0627\u0644\u0627\u062a \u064a\u0645\u0643\u0646 \u0644\u0645\u0637\u0648\u0631 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 sleep \u0639\u0644\u0649 \u0645\u0633\u062a\u0648\u0649 \u0646\u0638\u0627\u0645 \u0627\u0644\u062a\u0634\u063a\u064a\u0644 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647 \u0644\u062d\u0632\u0645\u0629 DBMS_LOCK.SLEEP() \u0639\u0646 \u0637\u0631\u064a\u0642 plsql \u062d\u062a\u0649 \u064a\u062c\u0646\u0628 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0649 \u0627\u0639\u0645\u0627\u0644 \u0644\u0627\u062a\u062d\u062a\u0627\u062c \u0627\u0644\u064a\u0647\u0627 \u0641\u0639\u0644\u0627\u064b \u0647\u0630\u0627 \u0628\u0639\u0636 \u062a\u062d\u0633\u064a\u0646 \u0639\u0645\u0644\u064a\u0629 \u0627\u0644\u0648\u0635\u0648\u0644 \u0644\u0647\u0630\u0647 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n

3- \u062a\u062c\u0646\u0628 \u062a\u0643\u0631\u0627\u0631 \u062a\u0646\u0641\u064a\u0630 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062a\u0649 \u0642\u0645\u062a \u0628\u062a\u0646\u0641\u064a\u0630\u0647\u0627 \u0645\u0633\u0628\u0642\u0627\u064b \u0628\u0642\u062f\u0631 \u0627\u0644\u0625\u0645\u0643\u0627\u0646 , \u0639\u0644\u0649 \u0627\u0644\u0645\u0635\u0645\u0645 \u0641\u0647\u0645 \u0627\u0647\u0645\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644 procedures \u0648\u0645\u062e\u0631\u062c\u0627\u062a\u0647\u0627 \u0648\u0627\u0647\u0645\u064a\u0629 \u0646\u062e\u0632\u064a\u0646 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0627\u0644\u062a\u0649 \u064a\u062d\u062a\u0627\u062c\u0647\u0627 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0648\u0646 \u0628\u0643\u062b\u0631\u0647 \u0641\u0649 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0628\u062f\u0644\u0627\u0621 \u0639\u0646 \u0627\u062c\u0631\u0627\u0621 \u0646\u0641\u0633 \u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644 sort \u0648 \u0627\u0644 group \u0643\u0644 \u0645\u0631\u0647 , \u0641\u0627\u062d\u064a\u0627\u0646\u0627 \u062a\u062c\u062f \u0628\u0628\u0639\u0636 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u063a\u064a\u0631 \u0630\u0627\u062a \u0627\u0644\u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u062c\u064a\u062f \u0627\u0646 \u0627\u0644\u0645\u0637\u0648\u0631 \u064a\u0642\u0648\u0645 \u0628\u0639\u0645\u0644 \u0627\u062c\u0631\u0627\u0621 \u0627\u0643\u062b\u0631 \u0645\u0646 \u0645\u0631\u0647 \u0644\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0646\u0641\u0633 \u0627\u0644\u0646\u062a\u064a\u062c\u0647 \u0639\u0644\u0649 \u0627\u0644\u0631\u063a\u0645 \u0645\u0646 \u0627\u0645\u0643\u0627\u0646\u064a\u0629 \u0627\u0644\u0648\u0635\u0648\u0644 \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0633\u0627\u0628\u0642\u0629 \u0648\u0627\u0644\u062a\u0649 \u0644\u0645 \u064a\u062d\u062f\u062b \u062a\u063a\u064a\u064a\u0631 \u0628\u0647\u0627 \u0628\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a , \u0641\u0645\u062b\u0644\u0627 \u0639\u0646\u062f \u0628\u0646\u0627\u0621 procedures \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u062a\u0649 \u0644\u0627\u062a\u062a\u063a\u064a\u0631 \u0627\u0648 \u0627\u0644\u062b\u0627\u0628\u062a\u0647 \u0643\u062b\u0648\u0627\u0628\u062a \u0641\u0649 \u0625\u062c\u0631\u0627\u0621 \u0648\u0644\u0627\u062a\u0642\u0645 \u0628\u062a\u062e\u0632\u064a\u0646\u0647\u0627 \u0641\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a , \u0644\u0627\u0646\u0643 \u0628\u0630\u0644\u0643 \u062a\u0642\u0648\u0645 \u0628\u0639\u062f\u0629 \u0639\u0645\u0644\u064a\u0627\u062a \u0644\u0644\u0627\u0634\u064a\u0621 , \u0645\u062c\u0645\u0648\u0639\u0629 physical reads \u0648 waitings \u0631\u0628\u0645\u0627 \u062a\u0646\u0641\u0630 \u0645\u0646 \u0642\u0628\u0644 30 \u0645\u0633\u062a\u062e\u062f\u0645 !!!! \u062a\u062e\u064a\u0644 \u0623\u0646\u0647 \u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u0627\u0633\u062a\u063a\u0646\u0627\u0621 \u0628\u0628\u0633\u0627\u0637\u0647 \u0639\u0646 \u0643\u0644 \u0647\u0630\u0627 .<\/p>\n

4- \u0641\u0649 \u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0642\u0645 \u0628\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062a\u0649 \u062a\u062d\u062a\u0627\u062c\u0647\u0627 \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0641\u0649 \u062c\u062f\u0648\u0644 \u0644\u062a\u0643\u0648\u0646 \u062c\u0627\u0647\u0632\u0629 \u0645\u0633\u0628\u0642\u0627\u064b, \u062a\u0639\u0637\u0649 \u0627\u0644\u0627\u0648\u0644\u0648\u064a\u0629 \u062f\u0627\u0626\u0645\u0627 \u0644\u0644\u0633\u0631\u0639\u0629 \u0645\u0642\u0627\u0631\u0646\u0629 \u0628\u0627\u0644\u0645\u0633\u0627\u062d\u0629 , \u0641\u0645\u062b\u0644\u0627 \u062a\u062e\u064a\u0644 \u0627\u0646\u0646\u0627 \u0646\u0631\u064a\u062f \u0639\u0645\u0644 \u062a\u0642\u0631\u064a\u0631 \u064a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 \u0628\u0631\u0627\u0645\u064a\u062a\u0631, \u0641\u0639\u0643\u0633 \u0645\u0627\u064a\u062a\u062e\u064a\u0644\u0647 \u0645\u0639\u0638\u0645 \u0645\u0637\u0648\u0631\u0649 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u064a\u0641\u0636\u0644 \u062a\u0645\u0627\u0645\u0627 \u062a\u062c\u0647\u064a\u0632 \u0647\u0630\u0647 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0639\u0644\u0649 \u0627\u0644\u062c\u062f\u0648\u0644 \u0645\u0628\u0627\u0634\u0631\u0629 \u0648\u0645\u0646\u0627\u062f\u0627\u062a\u0647\u0627 \u0628\u062f\u0648\u0646 \u0628\u0627\u0631\u0627\u0645\u064a\u062a\u0631 \u0627\u0641\u0636\u0644 \u0645\u0646 \u0627\u062c\u0631\u0627\u0621 \u0639\u0645\u0644\u064a\u0629 \u0627\u0644\u0641\u0644\u062a\u0631 Select \u0627\u062b\u0646\u0627\u0621 \u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u062a\u0642\u0631\u064a\u0631 \u0648\u0627\u0644\u0641\u0627\u0631\u0642 \u0633\u064a\u0643\u0648\u0646 \u0636\u062e\u0645 \u062c\u062f\u0627 \u0648\u0633\u064a\u0644\u0627\u062e\u0638\u0647 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0639\u0627\u062f\u0649 \u0628\u0633\u0647\u0648\u0644\u0629 \u062c\u062f\u0627 \u0641\u0649 \u0633\u0631\u0639\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u0642\u0644\u0629 \u0627\u0644\u062c\u0631\u0627\u0621 \u0627\u0644\u0630\u0649 \u0633\u062a\u0642\u0648\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0639\u0645\u0644\u0647 \u0641\u0647\u0649 \u0641\u0642\u0637 \u0633\u062a\u0642\u0648\u0645 \u0628\u0639\u0645\u0644 \u062a\u062d\u062f\u064a\u062b refresh \u0644\u0644 materialized View\u00a0 \u0627\u0648 \u0627\u0644\u062c\u062f\u0648\u0644 .<\/p>\n

5- \u0644\u0627\u062a\u0642\u0645 \u0628\u0627\u0644\u0627\u062a\u0635\u0627\u0644 \u064a\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u062a \u0628\u0627\u0643\u062b\u0631 \u0645\u0646 \u0645\u0631\u0647 , \u0639\u0627\u062f\u0629 \u0639\u0645\u0644\u064a\u0629 \u0627\u0644\u0627\u062a\u0635\u0627\u0644 \u0628\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u062a\u0627\u062e\u0630 \u0648\u0642\u062a \u0627\u0643\u062b\u0631 \u0645\u0646 \u0645\u062c\u0631\u062f \u0627\u0644 Connect \u0627\u0644\u0630\u0649 \u064a\u0639\u0644\u0645\u0647\u0627 \u0627\u0644\u0645\u0637\u0648\u0631 \u0641\u064a\u062c\u0628 \u0639\u0644\u0649 \u0627\u0644\u0645\u0637\u0648\u0631 \u0645\u0639\u0631\u0641\u0629 \u0643\u064a\u0641\u064a\u0629 \u0639\u0645\u0644 Reuse \u0644\u0644 Connection \u0648\u0628\u0627\u0644\u0645\u0642\u0627\u0628\u0644 \u062a\u0631\u0643 \u0627\u0644\u0627\u062a\u0635\u0627\u0644 \u0645\u0641\u062a\u0648\u062d\u0627 \u062f\u0627\u062e\u0644 \u0627\u0644\u062a\u0637\u0628\u064a\u0642.<\/p>\n

6- \u0636\u0631\u0648\u0631\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644 indexes \u0648\u0639\u062f\u0645 \u0627\u0644\u0627\u0643\u062b\u0627\u0631 \u0641\u064a\u0647\u0627 ,\u00a0 \u0645\u0639\u0631\u0648\u0641 \u0644\u062a\u0627\u062b\u064a\u0631 \u0627\u0644\u0645\u0628\u0627\u0634\u0631 \u0644\u0644 indexes \u0639\u0644\u0649 \u0633\u0631\u0639\u0629 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u0639\u0645\u0644\u064a\u0629 \u0627\u0644\u0648\u0635\u0648\u0644 \u0644\u0633\u062c\u0644 \u0639\u0644\u0649 \u062c\u062f\u0648\u0644 \u064a\u062d\u062a\u0648\u0649 \u0645\u0644\u064a\u0648\u0646 \u0633\u062c\u0644 \u0645\u0646 \u062f\u0648\u0646 index \u0628\u0645\u0643\u0646 \u0627\u0646 \u062a\u0627\u062e\u0630 15 \u062b\u0627\u0646\u064a\u0629 \u0628\u0627\u0644\u0627\u0636\u0627\u0641\u0629 \u0644\u0644\u062a\u0627\u062b\u064a\u0631 \u0627\u0644\u0633\u064a\u0649\u0621 \u062c\u062f\u0627 \u0639\u0644\u0649 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0643\u0643\u0644 \u0644\u0643\u0646 \u0641\u0649 \u0638\u0644 \u0648\u062c\u0648\u062f index \u064a\u0645\u0643\u0646 \u0644\u0647\u0630\u0647 \u0627\u0644\u0639\u0645\u0644\u064a\u0629 \u0627\u0646 \u062a\u0627\u062e\u0630 \u0641\u0642\u0637 3 \u062b\u0648\u0627\u0646 !!!! \u0648\u0645\u0627\u0627\u0633\u0647\u0644 \u0645\u0646 \u0627\u0646\u0634\u0627\u0621 index , \u0644\u0643\u0646 \u0628\u0627\u0644\u0645\u0642\u0627\u0628\u0644 \u064a\u062c\u0628 \u0639\u062f\u0645 \u0627\u0644\u0627\u0643\u062b\u0627\u0631 \u0645\u0646 \u0627\u0633\u0646\u062e\u062f\u0627\u0645 \u0627\u0644 Index \u0627\u0648 \u0639\u062f\u0645 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647 \u0641\u0649 \u0645\u0643\u0627\u0646 \u063a\u064a\u0631 \u0645\u0643\u0627\u0646\u0647 \u0627\u0644\u062d\u0642\u064a\u0642\u0649 , \u0643\u0645\u062b\u0627\u0644 \u0644\u0627\u064a\u062c\u0628 \u0627\u0633\u0646\u062e\u062f\u0627\u0645 \u0627\u0644 Bitmap Index\u00a0 \u0645\u0639 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644 OLTP .<\/p>\n

7- \u062a\u062c\u0646\u0628 \u062a\u062c\u0646\u0628 \u062a\u062c\u0646\u0628 \u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644 sort \u0627\u0644\u063a\u064a\u0631 \u0636\u0631\u0648\u0631\u064a\u0629 \u0645\u062a\u0645\u062b\u0644\u0629 \u0641\u0649 Order by , \u0645\u062b\u0644\u0627 \u062a\u062e\u064a\u0644 \u062c\u062f\u0648\u0644 \u0636\u062e\u0645 \u0645\u0646 \u063a\u064a\u0631 index \u0648\u0627\u0644\u0645\u0635\u0645\u0645 \u064a\u0631\u064a\u062f \u0627\u062c\u0631\u0627\u0621 \u0639\u0645\u0644\u064a\u0629 Sort \u0644\u062d\u0642\u0644 \u0645\u0639\u064a\u0646 \u0641\u0633\u064a\u062a\u0645 \u0627\u062c\u0631\u0627\u0621 \u0639\u0645\u0644\u064a\u0629 \u0645\u062d\u062f\u0647 \u064a\u062a\u0645 \u0641\u064a\u0647\u0627 \u0639\u0645\u0644 scan \u0644\u0643\u0644 \u0627\u0644\u062c\u062f\u0648\u0644 \u0648\u0645\u0646 \u062b\u0645 \u064a\u0642\u0648\u0645 \u0628\u0639\u0645\u0644 sort \u0644\u0644\u0646\u0627\u062a\u062c !!! \u0648\u0639\u0645\u0644\u064a\u0629 \u0627\u0644 sort \u062a\u0646\u0641\u0630 \u0645\u0639\u0647\u0627 \u0639\u0645\u0644\u064a\u0629 select \u0644\u0643\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0648\u062c\u0648\u062f\u0647 \u0628\u0627\u0644\u062c\u062f\u0648\u0644 \u0643\u0643\u0644 \u0648\u0646\u0642\u0644\u0647\u0627 \u0627\u0644\u0649 \u062e\u0627\u0631\u062c \u0627\u0644 data file \u0644\u0627\u062c\u0627\u0621 \u0627\u0644\u0639\u0645\u0644\u064a\u0629 , \u0648\u0643\u0627\u0645\u062a\u062f\u0627\u062f \u0644\u0647\u0630\u0647 \u0627\u0644\u0639\u0645\u0644\u064a\u0629 \u062a\u062c\u0646\u0628 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 Union\u00a0 \u0648\u0627\u0633\u062a\u0639\u0645\u0644 Union all \u0646\u0633\u0628\u0629 \u0644\u0627\u0646 union \u062a\u0642\u0648\u0645 \u0628\u0639\u0645\u0644 Sort \u0627\u064a\u0636\u0627 \u0648\u0644\u064a\u0633 Union all .<\/p>\n

8- \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u00a0Partitioning\u00a0, \u0643\u0645\u0637\u0648\u0631 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u064a\u062c\u0628 \u0639\u0644\u064a\u0643 \u0627\u0633\u062a\u0639\u0645\u0627\u0644\u00a0\u00a0 Partitioning \u00a0\u0645\u0639 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0643\u0628\u064a\u0631\u0647 \u0644\u0623\u062b\u0631 \u0630\u0644\u0643 \u0641\u0649 \u062a\u0633\u0631\u064a\u0639 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0648\u062a\u062e\u0641\u064a\u0641 \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a .<\/p>\n

9- \u0642\u0645 \u0628\u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644 Materialized View \u0644\u062a\u0642\u0633\u064a\u0645 \u0648\u062a\u0635\u0646\u064a\u0641 \u0627\u0644\u0627\u062c\u0631\u0627\u0621\u0627\u062a \u0627\u0644\u062a\u0649 \u064a\u062d\u062a\u0627\u062c\u0647\u0627 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0645\u0646 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 , \u0641\u0639\u0646\u062f \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644 Materialized view \u064a\u0642\u0648\u0645 \u0627\u0644\u0627\u0648\u0631\u0627\u0643\u0644 \u0628\u0639\u0645\u0644 \u0646\u0633\u062e\u062a\u064a\u0646 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0646\u0633\u062e\u0629 \u062a\u062a\u0627\u062d \u0639\u0646\u062f \u0627\u062f\u062e\u0627\u0644 \u0628\u064a\u0627\u0646\u0627\u062a \u062c\u062f\u064a\u062f\u0647 \u0648\u0646\u0633\u062e\u0629 \u0627\u062e\u0631\u0649 \u062a\u062e\u0635\u0635 \u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644 Query \u0648\u063a\u064a\u0631\u0647\u0627 \u0628\u0627\u0644\u0627\u0636\u0627\u0641\u0629 \u0644\u0623\u0645\u0643\u0627\u0646\u064a\u0629 \u0636\u0645 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0648\u0627\u0646\u0634\u0627\u0621 \u062c\u062f\u0627\u0648\u0644 \u062d\u0633\u0628 query \u0645\u0639\u064a\u0646 \u0645\u0645\u0627 \u064a\u0633\u0647\u0644 \u0648\u064a\u0642\u0644\u0644 \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0630\u0649 \u0633\u064a\u062d\u062a\u0627\u062c\u0647 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0644\u062a\u0648\u0641\u064a\u0631 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a .<\/p>\n

10- \u0627\u062e\u062a\u0628\u0631 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0645\u0639 \u0643\u0645\u064a\u0629 \u0636\u062e\u0645\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0639\u062f\u062f \u0643\u0628\u064a\u0631 \u0645\u0646 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0644\u0627\u0646 \u0641\u0649 \u0647\u0630\u0647 \u0627\u0644\u062d\u0627\u0644\u0629 \u0641\u0642\u0637 \u0633\u062a\u062e\u0631\u062c \u0628\u0646\u062a\u0627\u0626\u062c \u0635\u062d\u064a\u062d\u0629 , \u0644\u0627\u0646 \u062a\u062c\u0631\u0628\u0629 \u0627\u0644\u0646\u0638\u0627\u0645 \u0645\u0639 \u0645\u0633\u062a\u062e\u062f\u0645 \u0648\u0627\u062d\u062f \u0644\u0627\u064a\u0639\u0637\u0649 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0627\u0644\u0645\u0631\u062c\u0648\u0629 \u0648\u0627\u0644\u0645\u062a\u0639\u0644\u0642\u0629 \u0628\u062c\u0648\u0627\u0646\u0628 \u0627\u0644\u0633\u0631\u0639\u0629 \u0648\u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 .<\/p>\n

11- \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u062d\u064a\u062d \u0644\u0644 Data types , \u0641\u0644\u0627 \u064a\u062c\u0628 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644 Varchar2 \u0645\u0639 \u0628\u064a\u0627\u0646\u0627\u062a \u062b\u0627\u0628\u062a\u0647 \u0645\u062b\u0644\u0627 \u0645\u0641\u0627\u062a\u064a\u062d \u0627\u0644\u062f\u0648\u0644 \u0629\u0627\u0644\u062a\u0649 \u0633\u062a\u062a\u0643\u0648\u0646 \u0641\u0642\u0637 \u0645\u0646 \u062d\u0631\u0641\u064a\u0646 \u064a\u0645\u0643\u0646 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u0646\u0648\u0639 char \u0628\u0637\u0648\u0644 2 , \u0648\u0643\u0645\u062b\u0627\u0644 \u0627\u062e\u0631 \u0648\u0638\u0627\u0626\u0641 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 raw \u0648 BLOB \u0648\u0627\u0645\u0627\u0643\u0646 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0643\u0644 \u0648\u0627\u062d\u062f\u0647 \u0645\u0646\u0647\u0645\u0627 .<\/p>\n

\u064a\u062a\u0628\u0639 \u0627\u0644\u062c\u0632\u0621 \u0627\u0644\u062b\u0627\u0646\u0649 \u2026.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0639\u0645\u0644\u064a\u0629 \u062a\u0635\u0645\u064a\u0645 \u0648\u062a\u0637\u0648\u064a\u0631 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 \u0627\u0648 \u0643\u0645\u0627 \u064a\u0637\u0644\u0642 \u0639\u0644\u064a\u0647\u0627 \u0627\u0644\u0645\u0637\u0648\u0631\u0648\u0646 (\u062a\u0635\u0645\u064a\u0645 \u0627\u0644\u0646\u0638\u0627\u0645) \u0639\u0645\u0644\u064a\u0629 \u0645\u0639\u0642\u062f\u0647 \u0648\u0644\u064a\u0633\u062a \u0628\u0627\u0644\u0628\u0633\u0627\u0637\u0647 \u0627\u0644\u062a\u0649 \u064a\u0645\u0643\u0646 \u062d\u0635\u0631\u0647\u0627 \u0641\u0649 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0648\u062a\u0634\u063a\u064a\u0644 \u0645\u0639\u0627\u0644\u062c \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u0641\u0648\u0631\u0645\u0627\u062a \u0648\u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0628\u0644 \u064a\u0645\u062a\u062f \u0644\u0627\u0628\u0639\u062f \u0645\u0646 \u0630\u0644\u0643 \u0643\u062b\u064a\u0631\u0627 \u0641\u064a\u062c\u0628 \u0644\u0644\u0645\u0637\u0648\u0631 \u0627\u0644\u0625\u0644\u0645\u0627\u0645 \u0628\u0643\u0644 \u0627\u0644\u062a\u0641\u0627\u0635\u064a\u0644 \u0627\u0644\u062a\u0649 \u064a\u062d\u062a\u0627\u062c\u0647\u0627 \u062a\u0637\u0628\u064a\u0642\u0647 \u0628\u062f\u0627\u064b \u0645\u0646 \u0641\u0647\u0645 \u0648\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0645\u0637\u0644\u0648\u0628 \u0648\u0627\u062e\u062a\u064a\u0627\u0631 \u0627\u0641\u0636\u0644 \u0627\u0644\u0637\u0631\u0642 \u0644\u062a\u0646\u0641\u064a\u0630\u0647 , \u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u0644\u0627\u064a\u0631\u0643\u0632 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[151,152,134,139],"class_list":["post-814","post","type-post","status-publish","format-standard","hentry","category--adf","tag-----adf","tag----adf","tag--11-","tag-139"],"views":8740,"_links":{"self":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts\/814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=814"}],"version-history":[{"count":3,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts\/814\/revisions"}],"predecessor-version":[{"id":817,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts\/814\/revisions\/817"}],"wp:attachment":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}