{
    "version": "https:\/\/jsonfeed.org\/version\/1",
    "title": "M9K blog: заметки с тегом SQL",
    "_rss_description": "Заметки обо всём: devops, lifestyle, культура.",
    "_rss_language": "ru",
    "_itunes_email": "",
    "_itunes_categories_xml": "",
    "_itunes_image": "",
    "_itunes_explicit": "",
    "home_page_url": "https:\/\/blog.m9k.space\/tags\/sql\/",
    "feed_url": "https:\/\/blog.m9k.space\/tags\/sql\/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": "146",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-sql-baseenter-audit\/",
            "title": "OracleSQL История неудачных входов пользователя",
            "content_html": "<p>Возникла задача посмотреть историю неудачных входов пользователя за период:<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">SELECT username, terminal, timestamp,returncode  FROM dba_audit_session WHERE username = 'USERNAME' AND RETURNCODE !=0 AND TIMESTAMP between\r\n    to_date('2023-10-20 00:00:00', 'yyyy-mm-dd HH24:MI:SS') and\r\n    to_date('2023-10-20 16:43:00', 'yyyy-mm-dd HH24:MI:SS')<\/code><\/pre>",
            "date_published": "2023-10-20T09:51:19+00:00",
            "date_modified": "2023-10-20T10:12:38+00:00",
            "_date_published_rfc2822": "Fri, 20 Oct 2023 09:51:19 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "146",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "145",
            "url": "https:\/\/blog.m9k.space\/all\/oraclesql-profile-password-lifetime\/",
            "title": "OracleSQL profile password lifetime",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">select * from dba_profiles s where s.profile='PROFILE_NAME' \r\nand resource_name='PASSWORD_LIFE_TIME';<\/code><\/pre>",
            "date_published": "2023-10-20T08:19:53+00:00",
            "date_modified": "2023-10-20T08:19:50+00:00",
            "_date_published_rfc2822": "Fri, 20 Oct 2023 08:19:53 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "145",
            "_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": "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)"
}