{
    "version": "https:\/\/jsonfeed.org\/version\/1",
    "title": "M9K blog: заметки с тегом Oracle",
    "_rss_description": "Заметки обо всём: devops, lifestyle, культура.",
    "_rss_language": "ru",
    "_itunes_email": "",
    "_itunes_categories_xml": "",
    "_itunes_image": "",
    "_itunes_explicit": "",
    "home_page_url": "https:\/\/blog.m9k.space\/tags\/oracle\/",
    "feed_url": "https:\/\/blog.m9k.space\/tags\/oracle\/json\/",
    "icon": "https:\/\/blog.m9k.space\/user\/userpic@2x.jpg?1769095194",
    "author": {
        "name": "M",
        "url": "https:\/\/blog.m9k.space\/",
        "avatar": "https:\/\/blog.m9k.space\/user\/userpic@2x.jpg?1769095194"
    },
    "items": [
        {
            "id": "183",
            "url": "https:\/\/blog.m9k.space\/all\/posmotret-telo-aktivnogo-sql-zaprosa-po-sid-u\/",
            "title": "Посмотреть тело активного SQL-запроса по SID-у",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">select \r\n  a.sid, \r\n  a.serial#,\r\n  b.sql_text \r\nfrom \r\n  v$session a, \r\n  v$sqlarea b \r\nwhere \r\n  a.sql_address = b.address \r\n  and sid = $SID_NUMBER;<\/code><\/pre>",
            "date_published": "2025-03-19T08:08:40+00:00",
            "date_modified": "2025-04-23T05:56:23+00:00",
            "_date_published_rfc2822": "Wed, 19 Mar 2025 08:08:40 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "183",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "164",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-cloning-scheme-in-entire-db\/",
            "title": "Oracle: Cloning scheme in entire DB",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">&gt;CREATE USER &lt;SCHEME_DEST&gt; IDENTIFIED BY &quot;&lt;SCHEME_DEST_PASSWORD&gt;&quot;;\r\n&gt;GRANT CONNECT TO &lt;SCHEME_DEST&gt;;\r\n&gt;GRANT CREATE SESSION TO &lt;SCHEME_DEST&gt;;\r\n&gt;ALTER USER &lt;SCHEME_DEST&gt; quota unlimited on &lt;DEFAULT_USER_TABLESPACE&gt;;\r\n&gt;expdp system\/&lt;SYSTEM PASSWORD&gt;@&lt;DB_SID&gt; schemas=&lt;SCHEME_SRC&gt; directory=&lt;DIRECTORY NAME&gt; dumpfile=&lt;DUMP NAME&gt;.dmp logfile=explog.txt\r\n&gt;impdp system\/&lt;SYSTEM PASSWORD&gt;@&lt;DB_SID&gt; directory=&lt;DIRECTORY NAME&gt; dumpfile=&lt;DUMP NAME&gt;.dmp logfile=implog.txt remap_schema=&lt;SCHEME_SRC&gt;:&lt;SCHEME_DEST&gt; transform=OID:N<\/code><\/pre>",
            "date_published": "2024-08-06T07:27:14+00:00",
            "date_modified": "2024-08-06T07:34:11+00:00",
            "_date_published_rfc2822": "Tue, 06 Aug 2024 07:27:14 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "164",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "121",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-view-scheduler-jobs\/",
            "title": "Oracle — View Scheduler Jobs",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">SELECT owner, job_name, comments FROM dba_scheduler_jobs;<\/code><\/pre>",
            "date_published": "2022-12-29T08:03:30+00:00",
            "date_modified": "2022-12-29T08:03:29+00:00",
            "_date_published_rfc2822": "Thu, 29 Dec 2022 08:03:30 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "121",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "117",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-disable-jobs\/",
            "title": "Oracle — Disable Jobs",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">BEGIN\r\nDBMS_SCHEDULER.disable (NAME =&gt; 'JOB_NAME', FORCE =&gt; TRUE);\r\nEND;<\/code><\/pre>",
            "date_published": "2022-12-16T03:22:18+00:00",
            "date_modified": "2022-12-16T03:22:14+00:00",
            "_date_published_rfc2822": "Fri, 16 Dec 2022 03:22:18 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "117",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "59",
            "url": "https:\/\/blog.m9k.space\/all\/sqlplus-i-kodirovka\/",
            "title": "SQLplus и кодировка",
            "content_html": "<p>Фикс:<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">cmd\r\n&gt;set NLS_LANG=russian_cis.ru8pc866\r\n&gt;sqlplus<\/code><\/pre>",
            "date_published": "2020-12-10T04:35:12+00:00",
            "date_modified": "2025-02-27T08:12:06+00:00",
            "_date_published_rfc2822": "Thu, 10 Dec 2020 04:35:12 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "59",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "52",
            "url": "https:\/\/blog.m9k.space\/all\/processy-oracle\/",
            "title": "Процессы Oracle",
            "content_html": "<p>Наличие запущенных листенеров в памяти<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">ps -ef | grep tnslsnr<\/code><\/pre><p>Запущенные инстансы Oracle SQL<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">ps -ef | grep pmon | cut -s -f 3 -d &quot;_&quot;<\/code><\/pre>",
            "date_published": "2020-09-25T04:51:14+00:00",
            "date_modified": "2020-09-25T04:49:56+00:00",
            "_date_published_rfc2822": "Fri, 25 Sep 2020 04:51:14 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "52",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        }
    ],
    "_e2_version": 3877,
    "_e2_ua_string": "E2 (v3877; Aegea)"
}